Postgres Pro
Downloads
Home   >   mailing lists

logging statements in PostgreSQL - Mailing list pgsql-general

From Jayadevan M
Subject logging statements in PostgreSQL
Date
Msg-id CAFS1N4gZyqR0z97pCbNnDmrj=ycHg66FR3xoO30-th7xoPP3Ng@mail.gmail.com
Whole thread Raw
Responses Re: logging statements in PostgreSQL  (Amit Langote <amitlangote09@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Steve Crawford
Date:
Subject: Re: What does \timing measure?
Next
From: François Beausoleil
Date:
Subject: Deduplication and transaction isolation level