Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Suggestion Queries



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group