Re: How to know transaction count in hour basic

mallikarjun t <[email protected]> Wed, 30 Oct 2019 20:30:03 +0530
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <CAOA8XiUx3DHp4rVhbd+mDDxYukLty4y4ai+07CCmyJMOVrdznw@mail.gmail.com>
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 <[email protected]>
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 <[email protected]> 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.*
>
>