RE: Get stats of deletes ,inserts,trasnactions and updates daily in entire database

Поиск
Список
Период
Сортировка
От Michel SALAIS
Тема RE: Get stats of deletes ,inserts,trasnactions and updates daily in entire database
Дата
Msg-id 007001d74edf$641b1910$2c514b30$@msym.fr
обсуждение исходный текст
Ответ на Get stats of deletes ,inserts,trasnactions and updates daily in entire database  (Yambu <hyambu@gmail.com>)
Список pgsql-admin
Дерево обсуждения

Hello,

 

Have a look at pg_stat_database. Because you want it daily, some extra arrangement is necessary…

 

Michel SALAIS

 

De : Yambu <hyambu@gmail.com>
Envoyé : samedi 22 mai 2021 06:12
À : Pgsql-admin <pgsql-admin@lists.postgresql.org>
Objet : Get stats of deletes ,inserts,trasnactions and updates daily in entire database

 

Hello

 

I would like to know how many records were deleted,updated or inserted per day in the entire database, as well as number of transactions done.  Is there a view or somewhere I can get that without installing anything extra in postgres?

 

regards

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

Предыдущее
От: Yambu
Дата:
Сообщение: Get stats of deletes ,inserts,trasnactions and updates daily in entire database
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: Re: WALWriteLocks