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 CAOA8XiUx3DHp4rVhbd+mDDxYukLty4y4ai+07CCmyJMOVrdznw@mail.gmail.com
Whole thread Raw
In response to Re: How to know transaction count in hour basic  (Alex Balashov <abalashov@evaristesys.com>)
Responses Re: How to know transaction count in hour basic  (Alex Balashov <abalashov@evaristesys.com>)
List pgsql-admin
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: Alex Balashov
Date:
Subject: Re: How to know transaction count in hour basic