Re: PostgreSQL 9.2 Logging

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: PostgreSQL 9.2 Logging
Дата
Msg-id CAKoxK+6GVY-0HnyGO8uR+sKk0E7kNPJ+KwJmwt9KL4Gz8de4eA@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL 9.2 Logging  ("carlosinfl ." <carlos.mennens@gmail.com>)
Список pgsql-general
On Wed, Aug 21, 2013 at 9:55 PM, carlosinfl . <carlos.mennens@gmail.com> wrote:

> #debug_print_parse = off
> #debug_print_rewritten = off
> #debug_print_plan = off
> #debug_pretty_print = on
> #log_checkpoints = off
> #log_connections = off
> #log_disconnections = off
>

The debug_* will log, well, debug information (e.g., the query being
rewritten and the query tree).
The log_*connections can be useful to see who is using the system.

I would also evaluate:
#log_min_messages = warning


Also
#log_statement = 'none'

that can be used to log all commands (query and utility), only ddl
(e.g., alter table),  and so on.

Hope this helps.

Luca


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

Предыдущее
От: Luca Ferrari
Дата:
Сообщение: Re: How to know detailed information about HOT(Heap-Only Tuples)?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Bug in psql (\dd query)