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