Re: pgbadger issue

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: pgbadger issue
Дата
Msg-id CAECtzeWHGr_cPNvRANzWQyznr0muU_FcKJNBRWvjzqQks2Q=pQ@mail.gmail.com
обсуждение исходный текст
Ответ на pgbadger issue  (S Bob <sbob@quadratum-braccas.com>)
Список 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 по дате отправления:

Предыдущее
От: Yambu
Дата:
Сообщение: Re: Removing second slave server
Следующее
От: Sachin Kumar
Дата:
Сообщение: PG admin is using too much memory