From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
---|---|
To: | Gaurav Tomar <gauravtomar14(at)gmail(dot)com> |
Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Table/log file name which store the queries which got executed in last 1 month |
Date: | 2020-05-01 03:33:10 |
Message-ID: | 2C56068A-8E81-4E5B-8926-A7D8F7804BD8@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> On Apr 30, 2020, at 9:19 PM, Gaurav Tomar <gauravtomar14(at)gmail(dot)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 <https://www.postgresql.org/docs/12/runtime-config-logging.html>
From | Date | Subject | |
---|---|---|---|
Next Message | Rene Romero Benavides | 2020-05-01 03:34:29 | Re: Table/log file name which store the queries which got executed in last 1 month |
Previous Message | Gaurav Tomar | 2020-05-01 03:19:45 | Table/log file name which store the queries which got executed in last 1 month |