logging statements in PostgreSQL

From: Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: logging statements in PostgreSQL
Date: 2013-09-25 03:18:14
Message-ID: CAFS1N4gZyqR0z97pCbNnDmrj=ycHg66FR3xoO30-th7xoPP3Ng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message François Beausoleil 2013-09-25 03:19:35 Deduplication and transaction isolation level
Previous Message Steve Crawford 2013-09-24 23:45:09 Re: What does \timing measure?