Am 05.04.24 um 18:29 schrieb jaya kumar:
Hi
Samed,
Thanks for your update. Daily or weekly database growth cheek soption are available?
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
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.
--
Thanks & Regards,
Jayakumar.S
+91-9840864439.
Obviously not, the statistics are - as mentioned earlier - cumulative.
So you have to do the math yourself. Compute the difference between yesterday's and today's numbers.
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012