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

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Table/log file name which store the queries which got executed inlast 1 month
Дата
Msg-id 2C56068A-8E81-4E5B-8926-A7D8F7804BD8@gmail.com
обсуждение исходный текст
Ответ на Table/log file name which store the queries which got executed inlast 1 month  (Gaurav Tomar <gauravtomar14@gmail.com>)
Список pgsql-sql
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: Gaurav Tomar
Дата:
Сообщение: Table/log file name which store the queries which got executed inlast 1 month
Следующее
От: Rene Romero Benavides
Дата:
Сообщение: Re: Table/log file name which store the queries which got executed inlast 1 month