pgbadger looks cool

Friday, May 18. 2012

The biggest thing that piqued my interest yesterday at pgCon was the lightning talk on pgbadger. I'm certainly going to take a look at this as a substitute for pgfouine, which I have sadly found largely unusable in most cases where I want it.

Posted by Andrew Dunstan in PostgreSQL at 16:24 | Comments (8) | Trackbacks (0)

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

The link is broken 
 
Here's the correct URL to the projet : 
https://github.com/dalibo/pgbadger

#1 damien on 2012-05-18 16:15 (Reply)

Thanks, fixed

#1.1 Andrew Dunstan on 2012-05-18 16:26 (Reply)

Interesting enough there has been a much better alternative to pgFouine for years -- mk-query-digest from Maatkit, now pt-query-digest from Percona Toolkit. But it never became widely used, perhaps because it was too closely associated with MySQL. The PostgreSQL log-parser is still part of pt-query-digest but because this isn't widely used, at some point I plan to remove that code to simplify maintenance and testing.

#2 Baron Schwartz (Homepage) on 2012-05-22 05:26 (Reply)

Oh, interesting. I am about to go on vacation and don't have time to look at it right now, but I'm going to ask some of my PGX colleagues to check it out. Don't remove that support just yet, please!

#2.1 Anonymous on 2012-05-27 04:19 (Reply)

Hi Everybody, 
pgbadger is really nice, but here we are facing an issue or might be we are missing something that pgbadger report works fins but in report it doesn't shows any statement or graph even a full page get created. 
Statement used: 
./pgbadger -p -g -l /tmp/postgresql-2012-07-08_000000.log -f stderr -o /home/enterprisedb/pgbadger_graph_08-Jul.html 
 
Please suggest.

#3 Ankur Agrawal on 2012-07-10 14:29 (Reply)

This is not a pgbadger help forum, as a little cursory examination would have showed you. So if you expect to get help here you entirely on the wrong track.

#3.1 Andrew Dunstan on 2012-07-19 18:07 (Reply)

Hi, 
 
I’ve been using Pgbadger1.2 on EDB9 the issue is that sometimes the log is parsed ie the time taken to parse the log is shown in the report but its an empty report.. Is that a bug with the version . 
Also i was looking at using zcat for .tgz log files but its not parsing the logs instead getting the following error: 
FATAL: unable to detect log file format from /pg_log/edb-2012-11-15.tgz, please use -f option. 
 
even after using -f the issue still remains .. 
 
Thanks

#4 Sumit on 2012-12-12 12:21 (Reply)

Why on earth are you asking questions here on an old blog entry? Ask questions somewhere that you might actually get some help. That's not here.

#4.1 Andrew Dunstan on 2012-12-12 16:20 (Reply)

Add Comment

Name
Email
Homepage
In reply to
Comment	Enclosing asterisks marks text as bold (word), underscore are made via _word_. Standard emoticons like :-) and ;-) are converted to images. Wiki format allowed
	Remember Information? Subscribe to this entry