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

From: "Michel SALAIS" <msalais(at)msym(dot)fr>
To: "'Yambu'" <hyambu(at)gmail(dot)com>, "'Pgsql-admin'" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: RE: Get stats of deletes ,inserts,trasnactions and updates daily in entire database
Date: 2021-05-22 07:52:18
Message-ID: 007001d74edf$641b1910$2c514b30$@msym.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com>
Envoyé : samedi 22 mai 2021 06:12
À : Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vijaykumar Jain 2021-05-24 14:13:15 Re: WALWriteLocks
Previous Message Yambu 2021-05-22 04:11:57 Get stats of deletes ,inserts,trasnactions and updates daily in entire database