Hi,
You can see doing select * from pg_stat_activity the queries that are currently running on your server, and do a explain analize on it to see which one is the bottleneck. If you are running the 7.4 you can see on the log the total ammount for each query.
with this query I see how much queries running, but the field current_query are free, so i can't see which queries are very slow.
You must perform that query with permission of super_user.
Regards Gaetano Mendola
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
