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

pgAdmin III commit: Support new/changed pg_stat_activity fields

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: pgAdmin III commit: Support new/changed pg_stat_activity fields
Date: 2012-01-22 18:15:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackers
Support new/changed pg_stat_activity fields

With 4f42b546fd87a80be30c53a0f2c897acb826ad52, PostgreSQL has a new column in
pg_stat_activity. The state column shows the state of the connection. The
column current_query has been renamed to query. It shows the current query if
the state is active, and the previous query if the state is not active.

This patch adds support for all these changes. The state column is displayed.
The query is displayed too, even if it is the previous one. The query start
column is only displayed when the state is active (either because the state
column is set to active in 9.2, or because there is '<IDLE>' in the beginning
of the query field in previous releases.



Modified Files
CHANGELOG                   |    1 +
pgadmin/frm/frmStatus.cpp   |  112 +++++++++++++++++++++++++++++++++----------
pgadmin/schema/pgServer.cpp |   14 +++--
pgadmin/slony/slCluster.cpp |    3 +-
pgadmin/slony/slNode.cpp    |    8 +++-
5 files changed, 105 insertions(+), 33 deletions(-)

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2012-01-22 21:08:14
Subject: pgAdmin III commit: Use date_trunc to skip the microseconds part
Previous:From: Dave PageDate: 2012-01-19 11:48:12
Subject: pgAdmin III commit: wxWidgets 2.9 fixes

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