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 YILDIRIMOn 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.