Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1jUMQT-0003qc-C4
	for pgsql-sql@arkaria.postgresql.org; Fri, 01 May 2020 03:33:21 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1jUMQR-0001I1-Vw
	for pgsql-sql@arkaria.postgresql.org; Fri, 01 May 2020 03:33:19 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <robjsargent@gmail.com>)
	id 1jUMQR-0001Gf-Mj
	for pgsql-sql@lists.postgresql.org; Fri, 01 May 2020 03:33:19 +0000
Received: from mail-il1-x144.google.com ([2607:f8b0:4864:20::144])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <robjsargent@gmail.com>)
	id 1jUMQL-0004Xx-7a
	for pgsql-sql@postgresql.org; Fri, 01 May 2020 03:33:18 +0000
Received: by mail-il1-x144.google.com with SMTP id b18so3482197ilf.2
        for <pgsql-sql@postgresql.org>; Thu, 30 Apr 2020 20:33:12 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=from:message-id:mime-version:subject:date:in-reply-to:cc:to
         :references;
        bh=K+nmuxYBgcEm8Qyde7IkkYVmjNRLGikG/XciZjKlWqU=;
        b=WYF3lWaRS5Zp56e1DXayWZP//nNeV8nvTNqkksFInuyZUhXINcHVVosKXbWm6IqJqZ
         QRjFd3Zfry9uyI74J8Tz+gW22JP6UI5pMlAUWvCqbnkL3+KoCJwM82hlKeHyhVA0kpX9
         5oRyPUe7K3c59WnBzTrowdcc2MMEnkwmSSzRrMjIYd/whdmx3hb87/6V2uBAclXNKZXE
         hAXbTeWPxIP9/WQAJWRHf6+JEnFBPebymgiOLUwCkUciFzkCK9LdEMDBvTxIdt9C+Ic8
         hTdDrdmSrRdRuuK8KdA00uRRmOo4cv59/QBb7KJLwGTmc6fKbkgykjgl+TkfRfgVmSf3
         h9Cw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:from:message-id:mime-version:subject:date
         :in-reply-to:cc:to:references;
        bh=K+nmuxYBgcEm8Qyde7IkkYVmjNRLGikG/XciZjKlWqU=;
        b=Uwa1fJj3zNSTTzYNeo0ERMok2pz0AXReof6ziZlo4UAVrzD2lpiUGsOTIDLQ2Yi8JK
         vdKbMFfZU27Z8Nz5BfDJxSvR2imIzPo5IAUy/JGK6RoISAeh/8XIfjaT+BEkuOQDdgo8
         KGt8446EyRvSEVYhWbMz905N8VJImBvup43t3hUPVK6fL49F5WlBoyZCCkmaohiF+m6O
         BgfP89IOZMFkgvn51rwt5+yV9xJA9AWBVuhrSZgQ2GVu7PAleKSid46u92gta4kwXUIy
         8QxBIPp3OlSsJ3Lj6URqL4Ocb9yBddIebAxY3iNr3RniS6ZFBbNJdgKjw6idZRuDJ/FR
         CIlw==
X-Gm-Message-State: AGi0PuZ0zxfZu9++TND7DUZy4+YFNaPJMGETHmK6RxEQpNGcMXA4WbIx
	xaZmLupfsuE+NVTjks4z54c=
X-Google-Smtp-Source: 
 APiQypK9GeycwgZNefDf3ERBp+lbf2O7/ZJ0PUpe4hkoeUtEf99FbvodIGCB5oxAyvugWsjbRRnweg==
X-Received: by 2002:a92:49c7:: with SMTP id k68mr1605727ilg.252.1588303992326;
        Thu, 30 Apr 2020 20:33:12 -0700 (PDT)
Received: from ?IPv6:2601:681:5500:dde0:7453:8889:1405:3501?
 ([2601:681:5500:dde0:7453:8889:1405:3501])
        by smtp.gmail.com with ESMTPSA id
 u197sm708526ilc.0.2020.04.30.20.33.11
        (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128);
        Thu, 30 Apr 2020 20:33:11 -0700 (PDT)
From: Rob Sargent <robjsargent@gmail.com>
Message-Id: <2C56068A-8E81-4E5B-8926-A7D8F7804BD8@gmail.com>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_51950DFA-76A3-43FB-A5F7-B72B1B83A4A9"
Mime-Version: 1.0 (Mac OS X Mail 13.0 \(3608.60.0.2.5\))
Subject: Re: Table/log file name which store the queries which got executed in
 last 1 month
Date: Thu, 30 Apr 2020 21:33:10 -0600
In-Reply-To: 
 <CAByYU3T6g6gh9=DA-bnme7YMOA9zK0ZPUZ2DR-cL6kV25yY+sg@mail.gmail.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
To: Gaurav Tomar <gauravtomar14@gmail.com>
References: 
 <CAByYU3T6g6gh9=DA-bnme7YMOA9zK0ZPUZ2DR-cL6kV25yY+sg@mail.gmail.com>
X-Mailer: Apple Mail (2.3608.60.0.2.5)
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Precedence: bulk


--Apple-Mail=_51950DFA-76A3-43FB-A5F7-B72B1B83A4A9
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8



> On Apr 30, 2020, at 9:19 PM, Gaurav Tomar <gauravtomar14@gmail.com> =
wrote:
>=20
> Hi All,
>=20
> In our production environment data in some of the table has been =
updated from the back end by some user. The update is very random, is =
there any table which stores the details of queries got executed in last =
one month or so.
> Regards,
>=20
> Gaurav
>=20
> +91 876 265 4621
>=20
No.
Depending on the system configurations settings such as =
=E2=80=98log_statement=E2=80=99 there may be useful information in the =
postgres server logs.
Current version of these settings are described here: =
https://www.postgresql.org/docs/12/runtime-config-logging.html =
<https://www.postgresql.org/docs/12/runtime-config-logging.html>=

--Apple-Mail=_51950DFA-76A3-43FB-A5F7-B72B1B83A4A9
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3Dutf-8"></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;" class=3D""><br =
class=3D""><div><br class=3D""><blockquote type=3D"cite" class=3D""><div =
class=3D"">On Apr 30, 2020, at 9:19 PM, Gaurav Tomar &lt;<a =
href=3D"mailto:gauravtomar14@gmail.com" =
class=3D"">gauravtomar14@gmail.com</a>&gt; wrote:</div><br =
class=3D"Apple-interchange-newline"><div class=3D""><div dir=3D"ltr" =
class=3D"">Hi All,<div class=3D""><br class=3D""></div><div class=3D"">In =
our production environment data in some of the table&nbsp;has been =
updated from the back end by some user. The update is very random, is =
there any table which stores the details of queries got executed in last =
one month or so.</div><div class=3D""><div class=3D""><div dir=3D"ltr" =
class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div =
dir=3D"ltr" class=3D""><p =
style=3D"font-size:small;background-image:initial;background-repeat:initia=
l" class=3D""><span style=3D"font-size:10pt;font-family:'GE =
Inspira',sans-serif;color:rgb(51,51,51)" class=3D"">Regards,</span></p><p =
style=3D"font-size:small;background-image:initial;background-repeat:initia=
l" class=3D""><span style=3D"font-size:10pt;font-family:'GE =
Inspira',sans-serif;color:rgb(51,51,51)" class=3D"">Gaurav</span></p><p =
style=3D"font-size:small;background-image:initial;background-repeat:initia=
l" class=3D"">+91 876 265 4621</p></div></div></div></div></div>
</div></blockquote></div>No.<div style=3D"orphans: 2; widows: 2;" =
class=3D"">Depending on the system configurations settings such as =
=E2=80=98<span style=3D"orphans: 2; widows: 2; background-color: =
rgb(255, 255, 255);" class=3D""><font color=3D"#0d0a0b" face=3D"monospace"=
 class=3D""><span style=3D"font-size: 14.4px;" =
class=3D"">log_statement</span><span style=3D"caret-color: rgb(13, 10, =
11); font-size: 14.399999618530273px;" class=3D"">=E2=80=99</span><span =
style=3D"font-size: 14.4px;" class=3D"">&nbsp;there may be useful =
information in the postgres server logs.</span></font></span></div><div =
style=3D"orphans: 2; widows: 2;" class=3D""><font color=3D"#0d0a0b" =
face=3D"monospace" class=3D""><span style=3D"caret-color: rgb(13, 10, =
11); font-size: 14.399999618530273px; background-color: rgb(255, 255, =
255);" class=3D"">Current version of these settings are described =
here:&nbsp;</span></font><a =
href=3D"https://www.postgresql.org/docs/12/runtime-config-logging.html" =
class=3D"">https://www.postgresql.org/docs/12/runtime-config-logging.html<=
/a></div></body></html>=

--Apple-Mail=_51950DFA-76A3-43FB-A5F7-B72B1B83A4A9--