Re: Table DML status check per day

Поиск
Список
Период
Сортировка
От Samed YILDIRIM
Тема Re: Table DML status check per day
Дата
Msg-id CAAo1mbm9nW8_qyfw2d_Qoe6G+gJYa-yqLet1bYwLt40a-jfDZw@mail.gmail.com
обсуждение исходный текст
Ответ на [MASSMAIL]Table DML status check per day  (jaya kumar <kumardba27@gmail.com>)
Ответы Re: Table DML status check per day  (jaya kumar <kumardba27@gmail.com>)
Список 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.


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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Daulat
Дата:
Сообщение: [MASSMAIL]pgBadger with Pgaudit
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: pgBadger with Pgaudit