From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Table DML status check per day
Date: Fri, 5 Apr 2024 19:12:01 +0200
Message-ID: <7a6f0623-7028-bc1c-1d43-bf685f98513f@jakobs.com> (raw)
In-Reply-To: <CACd4L3tYyT1riWZsCmtFg5qQh88C_Un8WMp8eG_8irnfangwLQ@mail.gmail.com>
References: <CACd4L3vjfmqtuT0fGiNRiUNVyvwDpy1W1-RfBEPZGH6GOWL_LA@mail.gmail.com>
<CAAo1mbm9nW8_qyfw2d_Qoe6G+gJYa-yqLet1bYwLt40a-jfDZw@mail.gmail.com>
<CACd4L3tYyT1riWZsCmtFg5qQh88C_Un8WMp8eG_8irnfangwLQ@mail.gmail.com>
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@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.
>
> 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@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
Attachments:
[application/pgp-signature] OpenPGP_signature (202B, ../7a6f0623-7028-bc1c-1d43-bf685f98513f@jakobs.com/3-OpenPGP_signature)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: Table DML status check per day
In-Reply-To: <7a6f0623-7028-bc1c-1d43-bf685f98513f@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox