pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Get stats of deletes ,inserts,trasnactions and updates daily in entire database 2+ messages / 2 participants [nested] [flat]
* Get stats of deletes ,inserts,trasnactions and updates daily in entire database @ 2021-05-22 04:11 Yambu <hyambu@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Yambu @ 2021-05-22 04:11 UTC (permalink / raw) To: Pgsql-admin <pgsql-admin@lists.postgresql.org> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: Get stats of deletes ,inserts,trasnactions and updates daily in entire database @ 2021-05-22 07:52 Michel SALAIS <msalais@msym.fr> parent: Yambu <hyambu@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Michel SALAIS @ 2021-05-22 07:52 UTC (permalink / raw) To: 'Yambu' <hyambu@gmail.com>; 'Pgsql-admin' <pgsql-admin@lists.postgresql.org> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-05-22 07:52 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2021-05-22 04:11 Get stats of deletes ,inserts,trasnactions and updates daily in entire database Yambu <hyambu@gmail.com> 2021-05-22 07:52 ` Michel SALAIS <msalais@msym.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox