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

From Kyotaro Horiguchi
Subject Re: Add connection active, idle time to pg_stat_activity
Date
Msg-id 20220128.144024.1520044389939069823.horikyota.ntt@gmail.com
Whole thread Raw
In response to Re: Add connection active, idle time to pg_stat_activity  (Kuntal Ghosh <kuntalghosh.2007@gmail.com>)
List pgsql-hackers
At Mon, 29 Nov 2021 20:34:14 +0530, Kuntal Ghosh <kuntalghosh.2007@gmail.com> wrote in 
> active_time. But, I'm wondering why you need to distinguish between
> idle and idle in transactions - what's the usage? Either the backend
> is doing some work or it sits idle. Another useful information would

I believe many people suffer from mysterious long idle in
transactions, which harm server performance many ways.  In many cases
transactions with unexpectedly long idle time is an omen or a cause of
trouble.

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center



pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: Add connection active, idle time to pg_stat_activity
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Add connection active, idle time to pg_stat_activity