What is the best way to do PostgreSQL profiling?

Question

PostgreSQL

Greetings! There is a server on which stand: PHP 4.4 + Apache 1.2 + PostgreSQL 8.4. A rather heavy system of auctions works on this. How can you organize database query profiling, and how best to do it? It's just that sometimes the PostgreSQL process loads the professor at 98%, and you need to figure out what's wrong!

Answer 1

Enables logging of slow queries in postgres in a format suitable for pgfoyun, then you roll on the pgfoyun log and it will report to you

Answer 2

Are you sure that requests?
Determine what the postgres process is, perhaps it is not related to the database requests themselves (vacuum / checkpoint, etc.)
requests for 8.4 can be viewed https://github.com/kshvakov/pgcap or a similar thing