hi There:
I just updated from postgres 9.1.5 to postgres 9.2 which comes with pgAmdin
1.16. Platform is OS-X 10.8.1 that I ran into this issue, so I don't know if
it is universal or not.
Once I connect to a server and go to tools->Server Status to watch the commands
executing or the look at the log files (both are very handy when debugging
code), previous versions of pgAdmin would show a command executing, then when
pgAdmin refreshed the lists later, the column called query would go blank when
the command was done.
In this version of pgAdmin, the query does not update/clear, even though the
state says idle and I know that the command is complete. Effectively, it shows
the last statement executed.
If I run a select a statement against a single row table to get my row back,
the query window shows the results.
Yet the server stats window still shows the completed query and never goes
blank like it used to.
If I close the server status window and re-open it, the last query is still
there for that pgAdmin session
I don't know if this is a pgAdmin issue -- or Postgres 9.2.
as a workaround, I ran some test sql against the pg_stat_activity view and
manipulated it a bit to add a case statement that cleared the query if the
state was idle
SELECT s.datid, d.datname, s.pid, s.usesysid, u.rolname AS usename,
s.application_name, s.client_addr, s.client_hostname, s.client_port,
s.backend_start, s.xact_start, s.query_start, s.state_change, s.waiting,
s.state, case when s.state='idle' then '' else s.query end
FROM pg_database d,
pg_stat_get_activity(NULL::integer) s(datid, pid, usesysid,
application_name, state, query, waiting, xact_start, query_start,
backend_start, state_change, client_addr, client_hostname, client_port),
pg_authid u
WHERE s.datid = d.oid AND s.usesysid = u.oid;
Again, I don't know if the behaviour changed in the pg_admin window or far
deeper in postgres.
I would like to ask for the old behaviour back in the pg_admin server stats
page that shows the currently executing query.
thanks in advance and I hope this helps.
Doug Easterbrook
Arts Management Systems Ltd.
mailto:d...@artsman.com
http://www.artsman.com
Phone (403) 536-1205 Fax (403) 536-1210
