Database name in the log

Поиск
Список
Период
Сортировка
От Michal Táborský
Тема Database name in the log
Дата
Msg-id 40D6B546.3080309@taborsky.cz
обсуждение исходный текст
Ответы Re: Database name in the log  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: Heiko Pohl
Дата:
Сообщение: Problem while OS-Update
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Limit connections per user