Обсуждение: 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