pgbadger issue

From: S Bob <sbob(at)quadratum-braccas(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: pgbadger issue
Date: 2021-01-15 01:42:14
Message-ID: c507f510-d4cf-345f-d0ee-fe394de8bc6f@quadratum-braccas.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

All;

Apologies if this is the wrong list. I have a log file from a PostgreSQL
v10.12 cluster

log_min_duration statement = 0

log_line_prefix = '%t [%p]: [%l-1] '

log_destination = stderr

I see queries in the log, such as this one:

2021-01-14 20:28:20 EST [11486]: [2-1] STATEMENT:  SELECT * FROM BigTab
WHERE cast(value ->> 'pending' as bool) = 'false' order by cast(value ->> '
closeTimestamp' as bigint) desc, cast(value ->> 'openTimestamp' as
bigint) desc

However when I parse the log I get zero queries:

$ pgbadger -o uat.html -f stderr -p '%t [%p]: [%l-1] '  ./postgresql-Thu.log
[========================>] Parsed 10007997 bytes of 10007997 (100.00%),
queries: 0, events: 1
LOG: Ok, generating html report...

Thoughts?

Thanks in advance

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message S Bob 2021-01-15 02:12:54 Odd config issue, cannot set log_min_duration_statement
Previous Message franklin ferreira de lima 2021-01-14 16:02:45 Re: Removing second slave server