From: Michel SALAIS <msalais@msym.fr>
To: 'Yambu' <hyambu@gmail.com>
To: 'Pgsql-admin' <pgsql-admin@lists.postgresql.org>
Subject: RE: Get stats of deletes ,inserts,trasnactions and updates daily in entire database
Date: Sat, 22 May 2021 09:52:18 +0200
Message-ID: <007001d74edf$641b1910$2c514b30$@msym.fr> (raw)
In-Reply-To: <CALhHtcD6orDZwdZCotjRUxPvnW08SrueDc48ge3xBuZNmH0o0Q@mail.gmail.com>
References: <CALhHtcD6orDZwdZCotjRUxPvnW08SrueDc48ge3xBuZNmH0o0Q@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: msalais@msym.fr, hyambu@gmail.com, pgsql-admin@lists.postgresql.org
Subject: RE: Get stats of deletes ,inserts,trasnactions and updates daily in entire database
In-Reply-To: <007001d74edf$641b1910$2c514b30$@msym.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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