Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iPpJJ-0004E8-E6 for pgsql-admin@arkaria.postgresql.org; Wed, 30 Oct 2019 14:50:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iPpJH-0004LO-AZ for pgsql-admin@arkaria.postgresql.org; Wed, 30 Oct 2019 14:50:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iPpJH-0004LH-0n for pgsql-admin@lists.postgresql.org; Wed, 30 Oct 2019 14:50:55 +0000 Received: from allegro-1.evaristesys.com ([209.51.167.66] helo=evaristesys.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iPpJE-0005nk-P9 for pgsql-admin@postgresql.org; Wed, 30 Oct 2019 14:50:54 +0000 Received: from [47.39.145.182] (helo=[172.30.105.236]) by evaristesys.com with esmtpsa (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.92) (envelope-from ) id 1iPpJC-00051o-GD; Wed, 30 Oct 2019 10:50:50 -0400 Content-Type: multipart/alternative; boundary=Apple-Mail-5A753DC6-5887-4A9F-B902-E31538FFAE32 Content-Transfer-Encoding: 7bit From: Alex Balashov Mime-Version: 1.0 (1.0) Subject: Re: How to know transaction count in hour basic Date: Wed, 30 Oct 2019 10:50:49 -0400 Message-Id: References: Cc: pgsql-admin@postgresql.org In-Reply-To: To: mallikarjun t X-Mailer: iPhone Mail (17A878) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail-5A753DC6-5887-4A9F-B902-E31538FFAE32 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable You would just have to accumulate these values in a time-series gauge, right= ? =E2=80=94 Sent from mobile, with due apologies for brevity and errors. > On Oct 30, 2019, at 10:13 AM, mallikarjun t wrote: >=20 > =EF=BB=BF > Dear Team, >=20 > How to check, how many transactions are committed in one hour? >=20 > In database level pg_stat_database xact_commit column is there,this is giv= ing only count. >=20 > How to get count for hour basis and minutes and seconds basis, how many tr= ansactions are committed? >=20 > How to check? >=20 > Regards, > Mallikarjunarao, > +91-8142923383. --Apple-Mail-5A753DC6-5887-4A9F-B902-E31538FFAE32 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable You would just have to accumulate these val= ues in a time-series gauge, right?

=E2=80=94
Sen= t from mobile, with due apologies for brevity and errors.

On Oct 30, 2019, at 10:13 AM, mallik= arjun t <mallit333@gmail.com> wrote:

=EF=BB=BF
Dear Team,
How to check, how many transactions are committed in one hou= r?

In database level pg_stat_database xact_commit column is there,this is giving only count.
=

How to get coun= t for hour basis and minutes and seconds basis, how many transactions are co= mmitted?

How to check?<= /div>

Regards,
Mallikarjunarao,
+91-8142923383.<= br>
= --Apple-Mail-5A753DC6-5887-4A9F-B902-E31538FFAE32--