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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgadmin-support by date

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