| From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
|---|---|
| To: | "PostgreSQL-patches" <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Added columns to pg_stat_activity |
| Date: | 2005-05-02 21:24:44 |
| Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCE6C73DD@algol.sollentuna.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
This patch ticks off the following TODO items:
* Add session start time and last statement time to pg_stat_activity
(we already had last-statement-time, provided command string stats were
enabled)
* Add the client IP address and port to pg_stat_activity
I have tested on Linux (both IPV4 and Unix sockets for the address/port)
and Win32 (naturally only IPV4). I don't have a machine around with IPV6
support, so I haven't tested that. The code to handle it is stolen from
inet_client_addr() though, so it should hopefully be ok.
//Magnus
| Attachment | Content-Type | Size |
|---|---|---|
| pgstat2.patch | application/octet-stream | 12.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2005-05-02 21:35:25 | Re: Feature freeze date for 8.1 |
| Previous Message | Hannu Krosing | 2005-05-02 21:00:36 | Re: Feature freeze date for 8.1 |