Table DML status check per day

From: jaya kumar <kumardba27(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Table DML status check per day
Date: 2024-04-05 06:53:46
Message-ID: CACd4L3vjfmqtuT0fGiNRiUNVyvwDpy1W1-RfBEPZGH6GOWL_LA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jonathan Schaeffer 2024-04-05 08:07:35 Managing replication lag
Previous Message jwiencek3 2024-04-04 21:53:11 Re: Create Materialized View from postgresql_fdw hang