I vacuum 7.4.3 postgres often.
Our application uses pgxx library (no odbc).
I can log transactions and generally look at stats
BUT what I really need to do is to see which queries are slowing down postgres. I get to a point where postgres is using 90% of the CPU (linux), but the test I am running is repetitive (expect postgres to remain constant).