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 Craig Jackson
Subject Re: Table/log file name which store the queries which got executed inlast 1 month
Date
Msg-id CA+R1LV4vGSqh345SWCgzpMXt8qXjGTSt5dVnZA3wRee2nzZSjw@mail.gmail.com
Whole thread Raw
In response to Re: Table/log file name which store the queries which got executedin last 1 month  (legrand legrand <legrand_legrand@hotmail.com>)
List pgsql-sql
Tree view
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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: pg_dump fails when a table is in ACCESS SHARE MODE
Next
From:
Date:
Subject: Exporting modifications to a table as XML/JSON