| 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: | Whole Thread | Raw Message | 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 |