Re: logging statements in PostgreSQL

Поиск
Список
Период
Сортировка
От Jayadevan M
Тема Re: logging statements in PostgreSQL
Дата
Msg-id CAFS1N4iYGtnRTjJKrvghRZMkSHtQ5H-B6HQwvATcGe_L6HgULg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: logging statements in PostgreSQL  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-general
Дерево обсуждения
Hi,
I was looking for options to make sure SQLs executed as part of functions also get logged. Since this is a production system, I wanted to do it without the EXPLAIN also written to the logs. May be that is not possible?
Regards,
Jayadevan


On Mon, Sep 30, 2013 at 5:08 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Jayadevan M wrote:
> Thanks for the pointer. I do not really want to log the plans of queries, just the queries, execution
> time and a couple of other details (database,user). If I use the auto-explain module, it will end up
> printing the plan for all query execution in the log files?

You can configure it so that only statements exceeding a certain
duration will be logged.

Yours,
Laurenz Albe

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

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: Postgres replication question :- One master 2 slaves 9.0.10
Следующее
От: akp geek
Дата:
Сообщение: Re: Postgres replication question :- One master 2 slaves 9.0.10