Gaetano Mendola wrote:

Torsten Schulz wrote:

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.

I've made it in root-account with psql -U postgres - but i can't see the query

Regards
Torsten Schulz


---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to