Thread: Suggestion Queries
Hi list, Would be great if pgAdmin could report the current query of the database in the Server Status (in a new tab) A little help could be here: select current_query from pg_stat_activity; or (more completely) select * from pg_stat_activity; -- Atenciosamente Ezequias Rodrigues da Rocha
Ezequias R. da Rocha wrote: > Hi list, > > Would be great if pgAdmin could report the current query of the database > in the Server Status (in a new tab) > > A little help could be here: > > select current_query from pg_stat_activity; > > or (more completely) > > select * from pg_stat_activity; > It already does, provided you have stats_command_string enabled on the server. http://www.pgadmin.org/docs/1.6/status.html Please check the docs before suggesting new features or asking for help :-) Regards, Dave