Postgres Pro
Downloads
Home   >   mailing lists

Re: Add connection active, idle time to pg_stat_activity - Mailing list pgsql-hackers

From Dilip Kumar
Subject Re: Add connection active, idle time to pg_stat_activity
Date
Msg-id CAFiTN-vC8zSdChTR4HSmjH+r4AtyN0J7jPTTbtggKLPa0hi8og@mail.gmail.com
Whole thread Raw
In response to Re: Add connection active, idle time to pg_stat_activity  (Rafia Sabih <rafia.pghackers@gmail.com>)
List pgsql-hackers
Tree view 
On Tue, Nov 16, 2021 at 5:06 PM Rafia Sabih <rafia.pghackers@gmail.com> wrote:
> > I think this change is wrong,  basically, "tsmsg->m_idle_in_xact_time"
> > is used for counting the database level idle in transaction count, you
> > can check "pg_stat_get_db_idle_in_transaction_time" function for that.
> > So "pgStatTransactionIdleTime" is the variable counting the idle in
> > transaction time, pgStatIdleTime is just counting the idle time
> > outside the transaction so if we make this change we are changing the
> > meaning of tsmsg->m_idle_in_xact_time.
>
> Got it.
> Updated

Okay, thanks, I will look into it one more time early next week and if
I see no issues then I will move it to RFC.

-- 
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Nikolay Shaplov
Date:
Subject: Re: Suggestion: Unified options API. Need help from core team
Next
From: Daniel Gustafsson
Date:
Subject: Re: Windows build warnings