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

From Sergey Dudoladov
Subject Re: Add connection active, idle time to pg_stat_activity
Date
Msg-id CAA8Fd-rj3G2jc3PGNN2xG4K8+H1y1rQtJCMr5f9+BW5d_3q+9w@mail.gmail.com
Whole thread Raw
In response to Re: Add connection active, idle time to pg_stat_activity  (vignesh C <vignesh21@gmail.com>)
Responses Re: Add connection active, idle time to pg_stat_activity
List pgsql-hackers
Hi all,

@Andrei Zubkov 
I've modify the patch to address most of your comments.

>  I have a thought about other possible improvements fitting to this patch.
> I think pg_stat_session view is able to add one more dimension of monitoring - a dimension of sessions

I would like to remind here about the initial scope of this patch. The main goal of it was to ease tracking "idle in transactions" connections, a feature that would really help in my work. The "pg_stat_session" came into play only because the "pg_stat_activity" was seen as an unsuitable place for the relevant counters. With that I still would like to maintaint the focus on committing the "idle in transactions" part of pg_stat_session first.

Regards,
Sergey
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 003_extrafiles.pl test fails on Windows with the newer Perl versions
Next
From: vignesh C
Date:
Subject: Re: Asynchronous execution support for Custom Scan