Postgres Pro
Downloads
Home   >   mailing lists

Re: Table DML status check per day - Mailing list pgsql-admin

From jaya kumar
Subject Re: Table DML status check per day
Date
Msg-id CACd4L3tYyT1riWZsCmtFg5qQh88C_Un8WMp8eG_8irnfangwLQ@mail.gmail.com
Whole thread Raw
In response to Re: Table DML status check per day  (Samed YILDIRIM <samed@reddoc.net>)
Responses Re: Table DML status check per day
List pgsql-admin
Tree view
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 YILDIRIM

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

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: server log error on conflict do nothing
Next
From: Holger Jakobs
Date:
Subject: Re: Table DML status check per day