Re: How to know transaction count in hour basic

From: Alex Balashov <abalashov(at)evaristesys(dot)com>
To: mallikarjun t <mallit333(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to know transaction count in hour basic
Date: 2019-10-30 15:01:32
Message-ID: 1890EA7D-5F3B-4E4F-B795-884C84D7645D@evaristesys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmail(dot)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(at)evaristesys(dot)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(at)gmail(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message mallikarjun t 2019-10-30 15:10:10 Re: How to know transaction count in hour basic
Previous Message mallikarjun t 2019-10-30 15:00:03 Re: How to know transaction count in hour basic