log session end - again

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

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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