Thread: [MASSMAIL]Table DML status check per day
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?
+91-9840864439.
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.
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@gmail.com> 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.
+91-9840864439.
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@reddoc.net> 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@gmail.com> 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