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

From Alex Balashov
Subject Re: How to know transaction count in hour basic
Date
Msg-id 1890EA7D-5F3B-4E4F-B795-884C84D7645D@evaristesys.com
Whole thread Raw
In response to Re: How to know transaction count in hour basic  (mallikarjun t <mallit333@gmail.com>)
Responses Re: How to know transaction count in hour basic  (mallikarjun t <mallit333@gmail.com>)
List pgsql-admin
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: mallikarjun t
Date:
Subject: Re: How to know transaction count in hour basic
Next
From: mallikarjun t
Date:
Subject: Re: How to know transaction count in hour basic