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

Re: Suggestion Queries

From: Dave Page <dpage(at)postgresql(dot)org>
To: "Ezequias R(dot) da Rocha" <ezequias(at)fastcon(dot)com(dot)br>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Suggestion Queries
Date: 2007-03-22 16:42:42
Message-ID: 4602B202.6040502@postgresql.org (view raw or flat)
Thread:
Lists: 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

In response to

pgadmin-support by date

Next:From: Dave PageDate: 2007-03-22 16:59:56
Subject: Re: Timer on Query Editor
Previous:From: Ezequias R. da RochaDate: 2007-03-22 16:38:25
Subject: Re: Timer on Query Editor

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group