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