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 BAFEB557-9BCE-40EE-8BE2-B98641F28F99@evaristesys.com
Whole thread Raw
In response to 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
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: How to know transaction count in hour basic
Next
From: mallikarjun t
Date:
Subject: Re: How to know transaction count in hour basic