Distinct Log Files For Error,System Queries,Query Debug For Postgresql

Question

Currently I am working on PostgreSQL Performance Analysis where I am using prefix %t %d for logging.

When I try to analysis log files, I found that lots of errors, logs outcome of analyse vaccum and system related process, those logs occupy maximum of the file space, so it's very difficult to find queries need to analyze which from application.

Please help me to suggest a solution, so that can able to maintain each separately in Postgresql Logging. Any suggestions?

Answer 1

You cannot have multiple log files for different event types, but you can tune postgresql.conf so that you only get what you really need.

I use pgBadger for query analysis, it parses your log file and tells you (among many other things) which queries (normalized by ignoring constants) ran most frequently, which took the most time and which individual queries had the longest runtime.