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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello,

 

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

 

Michel SALAIS

 

De : Yambu <hyambu@xxxxxxxxx>
Envoyé : samedi 22 mai 2021 06:12
À : Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux