Re: Suggestion Queries - Mailing list pgadmin-support

From Dave Page
Subject Re: Suggestion Queries
Date
Msg-id 4602B202.6040502@postgresql.org
Whole thread Raw
In response to Suggestion Queries  ("Ezequias R. da Rocha" <ezequias@fastcon.com.br>)
List pgadmin-support
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


pgadmin-support by date:

Previous
From: "Ezequias R. da Rocha"
Date:
Subject: Suggestion Queries
Next
From: "Ezequias R. da Rocha"
Date:
Subject: Re: Timer on Query Editor