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.
Samed YILDIRIM
Samed YILDIRIM
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,Jayakumar.S
+91-9840864439.