pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 11:01:32 -0400
Message-ID: <1890EA7D-5F3B-4E4F-B795-884C84D7645D@evaristesys.com> (raw)
In-Reply-To: <CAOA8XiUx3DHp4rVhbd+mDDxYukLty4y4ai+07CCmyJMOVrdznw@mail.gmail.com>
References: <CAOA8XiUx3DHp4rVhbd+mDDxYukLty4y4ai+07CCmyJMOVrdznw@mail.gmail.com>

It’s not really a concept one can explain. It’s just a mathematical operation to determine a rate of change over time. 

—
Sent from mobile, with due apologies for brevity and errors.

> On Oct 30, 2019, at 11:00 AM, mallikarjun t <mallit333@gmail.com> wrote:
> 
> 
> 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.

view thread (9+ messages)  latest in thread

Message-ID: <1890EA7D-5F3B-4E4F-B795-884C84D7645D@evaristesys.com>
Permalink:  ../1890EA7D-5F3B-4E4F-B795-884C84D7645D@evaristesys.com/
Also on:    postgresql.org/message-id/1890EA7D-5F3B-4E4F-B795-884C84D7645D@evaristesys.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  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: <1890EA7D-5F3B-4E4F-B795-884C84D7645D@evaristesys.com>
  References: <CAOA8XiUx3DHp4rVhbd+mDDxYukLty4y4ai+07CCmyJMOVrdznw@mail.gmail.com> <1890EA7D-5F3B-4E4F-B795-884C84D7645D@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