pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedTable DML status check per day
4+ messages / 3 participants
[nested] [flat]
* Table DML status check per day
@ 2024-04-05 06:53 jaya kumar <kumardba27@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: jaya kumar @ 2024-04-05 06:53 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Table DML status check per day
@ 2024-04-05 09:55 Samed YILDIRIM <samed@reddoc.net>
parent: jaya kumar <kumardba27@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Samed YILDIRIM @ 2024-04-05 09:55 UTC (permalink / raw)
To: jaya kumar <kumardba27@gmail.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
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.
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Table DML status check per day
@ 2024-04-05 16:29 jaya kumar <kumardba27@gmail.com>
parent: Samed YILDIRIM <samed@reddoc.net>
0 siblings, 1 reply; 4+ messages in thread
From: jaya kumar @ 2024-04-05 16:29 UTC (permalink / raw)
To: Samed YILDIRIM <samed@reddoc.net>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Table DML status check per day
@ 2024-04-05 17:12 Holger Jakobs <holger@jakobs.com>
parent: jaya kumar <kumardba27@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Holger Jakobs @ 2024-04-05 17:12 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-04-05 17:12 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-04-05 06:53 Table DML status check per day jaya kumar <kumardba27@gmail.com>
2024-04-05 09:55 ` Samed YILDIRIM <samed@reddoc.net>
2024-04-05 16:29 ` jaya kumar <kumardba27@gmail.com>
2024-04-05 17:12 ` Holger Jakobs <holger@jakobs.com>
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