From: | jaya kumar <kumardba27(at)gmail(dot)com> |
---|---|
To: | Samed YILDIRIM <samed(at)reddoc(dot)net> |
Cc: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Table DML status check per day |
Date: | 2024-04-05 16:29:16 |
Message-ID: | CACd4L3tYyT1riWZsCmtFg5qQh88C_Un8WMp8eG_8irnfangwLQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Jakobs | 2024-04-05 17:12:01 | Re: Table DML status check per day |
Previous Message | Laurenz Albe | 2024-04-05 12:05:29 | Re: server log error on conflict do nothing |