Hi Samed,
Thanks for your update. Daily or weekly database growth cheek soption are available?
On Fri, Apr 5, 2024 at 3:26 PM Samed YILDIRIM <samed@xxxxxxxxxx> wrote:
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
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.
--
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
Attachment:
OpenPGP_signature
Description: OpenPGP digital signature
