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

Поиск
Список
Период
Сортировка
От Craig Jackson
Тема Re: Table/log file name which store the queries which got executed inlast 1 month
Дата
Msg-id CA+R1LV4vGSqh345SWCgzpMXt8qXjGTSt5dVnZA3wRee2nzZSjw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Table/log file name which store the queries which got executedin last 1 month  (legrand legrand <legrand_legrand@hotmail.com>)
Список pgsql-sql
Дерево обсуждения
Going forward you might consider enabling  the parameter 

track_commit_timestamp

This would allow you to view the latest transaction commit times for rows in a table, but be aware that there will be some performance overhead by enabling this. 

Regards,

Craig

On Fri, May 1, 2020 at 1:55 AM legrand legrand <legrand_legrand@hotmail.com> wrote:
If thoses users are connected with distinct accounts from application into
the database, maybe that pg_stat_statements may help see
https://www.postgresql.org/docs/current/pgstatstatements.html

Regards
PAscal




--
Sent from: https://www.postgresql-archive.org/PostgreSQL-sql-f2142323.html




--
Craig 

В списке pgsql-sql по дате отправления: