Re: Table/log file name which store the queries which got executed in last 1 month

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>

In response to

Browse pgsql-sql by date

  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