From: | Sergey Dudoladov <sergey(dot)dudoladov(at)gmail(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Cc: | Andrei Zubkov <zubkov(at)moonset(dot)ru>, Aleksander Alekseev <aleksander(at)timescale(dot)com>, vignesh C <vignesh21(at)gmail(dot)com> |
Subject: | Re: Add connection active, idle time to pg_stat_activity |
Date: | 2024-02-01 17:41:55 |
Message-ID: | CAA8Fd-rj3G2jc3PGNN2xG4K8+H1y1rQtJCMr5f9+BW5d_3q+9w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 | Content-Type | Size |
---|---|---|
0003-Add-pg_stat_session.patch | text/x-patch | 19.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | vignesh C | 2024-02-01 17:42:02 | Re: Asynchronous execution support for Custom Scan |
Previous Message | Tom Lane | 2024-02-01 17:32:00 | Re: 003_extrafiles.pl test fails on Windows with the newer Perl versions |