From: Alex Balashov <abalashov@evaristesys.com>
To: mallikarjun t <mallit333@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to know transaction count in hour basic
Date: Wed, 30 Oct 2019 10:50:49 -0400
Message-ID: <BAFEB557-9BCE-40EE-8BE2-B98641F28F99@evaristesys.com> (raw)
In-Reply-To: <CAOA8XiWyxx_t4rAjhL4O1xNGChhrzbvw1fmaKu78ximj3PeYJQ@mail.gmail.com>
References: <CAOA8XiWyxx_t4rAjhL4O1xNGChhrzbvw1fmaKu78ximj3PeYJQ@mail.gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: abalashov@evaristesys.com, mallit333@gmail.com
Subject: Re: How to know transaction count in hour basic
In-Reply-To: <BAFEB557-9BCE-40EE-8BE2-B98641F28F99@evaristesys.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox