From: | Samed YILDIRIM <samed(at)reddoc(dot)net> |
---|---|
To: | jaya kumar <kumardba27(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Table DML status check per day |
Date: | 2024-04-05 09:55:54 |
Message-ID: | CAAo1mbm9nW8_qyfw2d_Qoe6G+gJYa-yqLet1bYwLt40a-jfDZw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2024-04-05 11:10:24 | Re: pgBadger with Pgaudit |
Previous Message | Daulat | 2024-04-05 09:54:51 | pgBadger with Pgaudit |