Thread: log analyzer?

log analyzer?

From
"Neil Conway"
Date:
Hi everyone,

Does a log analyzer for PostgreSQL exist? I'm looking for something
similar to Analog for Apache. I'd like to get an idea of how many
connections are being made to the database, at what times -- and if
possible, more specific information like the length of transactions,
which types of queries (SELECT, INSERT, UPDATE, etc) are being issued,
how many failures there were, etc. (I realize you might need to enable
debugging to get some of this information).

Does such a piece of software exist?

TIA,

Neil Conway