Postgres Pro
Downloads
Home   >   mailing lists

Re: Table/log file name which store the queries which got executed inlast 1 month - Mailing list pgsql-sql

From Rob Sargent
Subject Re: Table/log file name which store the queries which got executed inlast 1 month
Date
Msg-id 2C56068A-8E81-4E5B-8926-A7D8F7804BD8@gmail.com
Whole thread Raw
In response to Table/log file name which store the queries which got executed inlast 1 month  (Gaurav Tomar <gauravtomar14@gmail.com>)
List pgsql-sql
Tree view


On Apr 30, 2020, at 9:19 PM, Gaurav Tomar <gauravtomar14@gmail.com> wrote:

Hi All,

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,

Gaurav

+91 876 265 4621

No.
Depending on the system configurations settings such as ‘log_statement’ 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

pgsql-sql by date:

Previous
From: Gaurav Tomar
Date:
Subject: Table/log file name which store the queries which got executed inlast 1 month
Next
From: Rene Romero Benavides
Date:
Subject: Re: Table/log file name which store the queries which got executed inlast 1 month