pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpgbadger question
4+ messages / 3 participants
[nested] [flat]
* pgbadger question
@ 2020-02-26 20:17 S.Bob <sbob@quadratum-braccas.com>
0 siblings, 2 replies; 4+ messages in thread
From: S.Bob @ 2020-02-26 20:17 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
All;
Sorry if this is OT:
We have a client that logs all statements with :
log_statement = 'all'
However they also have left log_min_duration_statement disabled:
log_min_duration_statement = -1
When I attempt to parse a report with pgbadger like this:
pgbadger -o postgres-Mon.html ./postgres-Mon.log
It parses zero queries, even though the query data is there, just that
it was logged via log_statement = 'all' instead of via setting
log_min_duration_statement = x
Is there any way to force pgbadger to pick up / reckognize the logges
queries?
Thanks in advance
--
`When you say "I wrote a program that crashed Windows", people just stare at you blankly and say "Hey, I got those with the system, *for free*".' (By Linus Torvalds)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pgbadger question
@ 2020-02-26 20:26 Julien Rouhaud <rjuju123@gmail.com>
parent: S.Bob <sbob@quadratum-braccas.com>
1 sibling, 0 replies; 4+ messages in thread
From: Julien Rouhaud @ 2020-02-26 20:26 UTC (permalink / raw)
To: S.Bob <sbob@quadratum-braccas.com>; +Cc: pgsql-admin@lists.postgresql.org
Hi,
On Wed, Feb 26, 2020 at 9:17 PM S.Bob <sbob@quadratum-braccas.com> wrote:
>
> We have a client that logs all statements with :
>
> log_statement = 'all'
>
> However they also have left log_min_duration_statement disabled:
>
> log_min_duration_statement = -1
>
>
> When I attempt to parse a report with pgbadger like this:
>
> pgbadger -o postgres-Mon.html ./postgres-Mon.log
>
>
> It parses zero queries, even though the query data is there, just that
> it was logged via log_statement = 'all' instead of via setting
> log_min_duration_statement = x
>
>
> Is there any way to force pgbadger to pick up / reckognize the logges
> queries?
According to https://github.com/darold/pgbadger/, it's not possible:
"Do not enable log_statement as its log format will not be parsed by pgBadger.".
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pgbadger question
@ 2020-02-27 04:22 manish yadav <manishy174@yahoo.co.in>
parent: S.Bob <sbob@quadratum-braccas.com>
1 sibling, 1 reply; 4+ messages in thread
From: manish yadav @ 2020-02-27 04:22 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org, "S.Bob" <sbob@quadratum-braccas.com>
Hi,
Please try with passing parameter log_line_prefix using --prefix
pgbadger --prefix <value in log_line_prefix> -o postgres-Mon.html ./postgres-Mon.log
Note : copy/paste exact value from PostgreSQL.conf file/show all and paste in the command above.
Thanks and Regards,
Manish Yadav
Mobile : +91 8527607945
On Thursday, 27 February 2020, 1:47:43 AM IST, S.Bob <sbob@quadratum-braccas.com> wrote:
All;
Sorry if this is OT:
We have a client that logs all statements with :
log_statement = 'all'
However they also have left log_min_duration_statement disabled:
log_min_duration_statement = -1
When I attempt to parse a report with pgbadger like this:
pgbadger -o postgres-Mon.html ./postgres-Mon.log
It parses zero queries, even though the query data is there, just that
it was logged via log_statement = 'all' instead of via setting
log_min_duration_statement = x
Is there any way to force pgbadger to pick up / reckognize the logges
queries?
Thanks in advance
--
`When you say "I wrote a program that crashed Windows", people just stare at you blankly and say "Hey, I got those with the system, *for free*".' (By Linus Torvalds)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pgbadger question
@ 2020-02-27 16:02 S.Bob <sbob@quadratum-braccas.com>
parent: manish yadav <manishy174@yahoo.co.in>
0 siblings, 0 replies; 4+ messages in thread
From: S.Bob @ 2020-02-27 16:02 UTC (permalink / raw)
To: manish yadav <manishy174@yahoo.co.in>; pgsql-admin@lists.postgresql.org
Already tried that, no luck
On 2/26/20 9:22 PM, manish yadav wrote:
> Hi,
>
> Please try with passing parameter log_line_prefix using --prefix
>
> pgbadger --prefix <value in log_line_prefix> -o postgres-Mon.html
> ./postgres-Mon.log
>
> Note : copy/paste exact value from PostgreSQL.conf file/show all and
> paste in the command above.
>
>
> Thanks and Regards,
>
> Manish Yadav
> Mobile : +91 8527607945
>
>
> On Thursday, 27 February 2020, 1:47:43 AM IST, S.Bob
> <sbob@quadratum-braccas.com> wrote:
>
>
> All;
>
>
> Sorry if this is OT:
>
>
> We have a client that logs all statements with :
>
> log_statement = 'all'
>
> However they also have left log_min_duration_statement disabled:
>
> log_min_duration_statement = -1
>
>
> When I attempt to parse a report with pgbadger like this:
>
> pgbadger -o postgres-Mon.html ./postgres-Mon.log
>
>
> It parses zero queries, even though the query data is there, just that
> it was logged via log_statement = 'all' instead of via setting
> log_min_duration_statement = x
>
>
> Is there any way to force pgbadger to pick up / reckognize the logges
> queries?
>
>
> Thanks in advance
>
>
>
> --
> `When you say "I wrote a program that crashed Windows", people just
> stare at you blankly and say "Hey, I got those with the system, *for
> free*".' (By Linus Torvalds)
>
>
>
--
`When you say "I wrote a program that crashed Windows", people just stare at you blankly and say "Hey, I got those with the system, *for free*".' (By Linus Torvalds)
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2020-02-27 16:02 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-02-26 20:17 pgbadger question S.Bob <sbob@quadratum-braccas.com>
2020-02-26 20:26 ` Julien Rouhaud <rjuju123@gmail.com>
2020-02-27 04:22 ` manish yadav <manishy174@yahoo.co.in>
2020-02-27 16:02 ` S.Bob <sbob@quadratum-braccas.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox