Re: Table DML status check per day

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?
>
> On Fri, Apr 5, 2024 at 3:26 PM Samed YILDIRIM <samed(at)reddoc(dot)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.
>
> https://www.postgresql.org/docs/16/monitoring-stats.html#MONITORING-PG-STAT-ALL-TABLES-VIEW
>
> Best regards.
> Samed YILDIRIM
>
> On Fri, 5 Apr 2024, 09:54 jaya kumar, <kumardba27(at)gmail(dot)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