| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org> |
| Subject: | log session end - again |
| Date: | 2004-02-02 19:48:27 |
| Message-ID: | 401EA98B.1040401@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
This patch brings up to date what I did last year (now unfortunately
bitrotted) to allow the logging of the end of a session, enabled by the
config setting "log_session_end - true". It produces lines like these:
for a local connection:
[21340] LOG: session end: duration: 0:00:23.41 user=andrew
database=template1 host=[local]
for a tcp connection:
[21351] LOG: session end: duration: 0:00:20.22 user=andrew
database=template1 host=127.0.0.1 port=33419
for a tcp connection when log_hostname = true:
[21373] LOG: session end: duration: 0:00:02.25 user=andrew
database=template1 host=alphonso port=33421
enjoy
andrew
| Attachment | Content-Type | Size |
|---|---|---|
| log_session_end.patch | text/plain | 7.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2004-02-02 19:54:11 | Re: log session end - again |
| Previous Message | Jan Wieck | 2004-02-02 19:00:38 | Re: pg_stat_activity |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2004-02-02 19:54:11 | Re: log session end - again |
| Previous Message | Joe Conway | 2004-02-02 19:08:05 | Re: pg_generate_sequence and info_schema patch (Was: SE |