Database name in the log

From: Michal Táborský <michal(at)taborsky(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: Database name in the log
Date: 2004-06-21 10:15:34
Message-ID: 40D6B546.3080309@taborsky.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible to put a database name in slow query log? We have many
databases in our cluster and it is sometimes hard to quess which
database was the query run on.

We have:
2004-06-21 12:08:50 [89103] LOG: 00000: duration: 895.794 ms
statement: SELECT id FROM fragment [...query continues...]

I would like to have something like:

2004-06-21 12:08:50 [89103] [dbname] LOG: 00000: duration: 895.794 ms
statement: SELECT id FROM fragment [...query continues...]

Did I overlook something in the docs? Is it possible? And if not, take
it as a feature request :).

Thanks.

--
Michal Taborsky
http://www.taborsky.cz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-06-21 10:19:52 Re: Limit connections per user
Previous Message Heiko Pohl 2004-06-21 06:12:05 Problem while OS-Update