current_query stat is idle

Started by mezgani aliover 16 years ago1 messagesgeneral
Jump to latest
#1mezgani ali
handrix@gmail.com

I used pg_top to monitor my database and i'm looking for method to find out
what queries are currently being serviced by the database.
pg_top inform me that the queries are IDLE and the result of select * from
pg_stat_activity return that current_query is always on IDLE status.

Please can you help

--
Ali MEZGANI
Network Engineering/Security
http://securfox.wordpress.com/