Re: How to know transaction count in hour basic
| От | mallikarjun t |
|---|---|
| Тема | Re: How to know transaction count in hour basic |
| Дата | |
| Msg-id | CAOA8XiVe+oaNcZaFLngbqzq61sVjb=HPTO+xEAbrmmyBSDE=Yg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How to know transaction count in hour basic (Alex Balashov <abalashov@evaristesys.com>) |
| Список | pgsql-admin |
Dear Team,
Begin;
select version();
commit;
This is one transaction committed. In this one query type is select query, I want how many update and insert and delete queries are committed in one hour?
That's the concept I want. Kindly help me?
Regards,
Mallikarjunarao,
+91-8142923383.
On Wed, Oct 30, 2019 at 8:31 PM Alex Balashov <abalashov@evaristesys.com> wrote:
It’s not really a concept one can explain. It’s just a mathematical operation to determine a rate of change over time.—Sent from mobile, with due apologies for brevity and errors.On Oct 30, 2019, at 11:00 AM, mallikarjun t <mallit333@gmail.com> wrote:Dear Team,I can't understand how to accumulate time series gauge?Kindly explain.Regards,Mallikarjunarao,+91-8142923383.On Wed, Oct 30, 2019 at 8:20 PM Alex Balashov <abalashov@evaristesys.com> wrote:You would just have to accumulate these values in a time-series gauge, right?—Sent from mobile, with due apologies for brevity and errors.On Oct 30, 2019, at 10:13 AM, mallikarjun t <mallit333@gmail.com> wrote:Dear Team,How to check, how many transactions are committed in one hour?In database level pg_stat_database xact_commit column is there,this is giving only count.How to get count for hour basis and minutes and seconds basis, how many transactions are committed?How to check?Regards,Mallikarjunarao,+91-8142923383.
В списке pgsql-admin по дате отправления: