Re: How to know transaction count in hour basic - Mailing list pgsql-admin

From mallikarjun t
Subject Re: How to know transaction count in hour basic
Date
Msg-id CAOA8XiVe+oaNcZaFLngbqzq61sVjb=HPTO+xEAbrmmyBSDE=Yg@mail.gmail.com
Whole thread Raw
In response to Re: How to know transaction count in hour basic  (Alex Balashov <abalashov@evaristesys.com>)
List 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 by date:

Previous
From: Alex Balashov
Date:
Subject: Re: How to know transaction count in hour basic
Next
From: Rui DeSousa
Date:
Subject: Re: How to know transaction count in hour basic