Re: Table DML status check per day

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


Hi Jaya,

You can use pg_stat_all_tables view for that. But, it provides cumulative statistics. So, you need to take snapshot of the view everyday. Then, you can create daily breakdown of insert/delete/update operations on tables out of snapshots.

Best regards.

On Fri, 5 Apr 2024, 09:54 jaya kumar, <kumardba27@xxxxxxxxx> wrote:

Hi Team,


Application team requesting data like a particular day each table  how many inserts, update and delete activity are happening?

Without enabling the Audit parameter?Hope we will enable the Audit parameter. Huge entry will be written in a log file.


Is it possible to check the status and provide to the end user these details? 

Thanks & Regards,

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux