logging statements in PostgreSQL

Поиск
Список
Период
Сортировка
От Jayadevan M
Тема logging statements in PostgreSQL
Дата
Msg-id CAFS1N4gZyqR0z97pCbNnDmrj=ycHg66FR3xoO30-th7xoPP3Ng@mail.gmail.com
обсуждение исходный текст
Ответы Re: logging statements in PostgreSQL  (Amit Langote <amitlangote09@gmail.com>)
Список pgsql-general
Hi all,
I am planning to use pgbadger for analyzing queries. Documentation for pgbadger says "Do not enable log_statement as their log format will not be parsed by pgBadger. "
I have
log_min_duration_statement = 0 
I do see quite a few SELECTs, INSERTS etc in the log files, function calls too, for example.
 select sp_pg_refresh_alert_data(current_date);
 But the SELECT and INSERT in the function are not getting logged. Is that how PostgreSQL logging works, or I have missed something?
Regards,
Jayadevan

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

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: What does \timing measure?
Следующее
От: François Beausoleil
Дата:
Сообщение: Deduplication and transaction isolation level