Re: pgbadger issue - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: pgbadger issue
Date
Msg-id CAECtzeWHGr_cPNvRANzWQyznr0muU_FcKJNBRWvjzqQks2Q=pQ@mail.gmail.com
Whole thread Raw
In response to pgbadger issue  (S Bob <sbob@quadratum-braccas.com>)
List pgsql-admin
Hi,

Le ven. 15 janv. 2021 à 02:42, S Bob <sbob@quadratum-braccas.com> a écrit :

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



This log doesn't look like a log_min_duration_statement log. Obviously, it lacks the duration.

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...



The only log you showed us doesn't look like the pattern pgBadger is searching for, so it isn't surprising that pgBadger doesn't detect queries.


--
Guillaume.

pgsql-admin by date:

Previous
From: Yambu
Date:
Subject: Re: Removing second slave server
Next
From: Sachin Kumar
Date:
Subject: PG admin is using too much memory