From 98633058cda60fe72a7bef74bf2d7ff9fe4d47ab Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Thu, 8 May 2008 08:58:59 +0000 Subject: [PATCH] Make the new pg_stat_get_activity use OUT parameters, so you don't have to specify the column names and types. Also simplifies the view. Per comments from Tom. --- src/backend/catalog/system_views.sql | 7 +------ src/include/catalog/catversion.h | 2 +- src/include/catalog/pg_proc.h | 2 +- 3 files changed, 3 insertions(+), 8 deletions(-) diff --git a/src/backend/catalog/system_views.sql b/src/backend/catalog/system_views.sql index 9fa76f1516..0083e44150 100644 --- a/src/backend/catalog/system_views.sql +++ b/src/backend/catalog/system_views.sql @@ -353,12 +353,7 @@ CREATE VIEW pg_stat_activity AS S.backend_start, S.client_addr, S.client_port - FROM pg_database D, - pg_stat_get_activity(NULL) AS S(datid oid, procpid int, - usesysid oid, current_query text, waiting boolean, - xact_start timestamptz, query_start timestamptz, - backend_start timestamptz, client_addr inet, client_port int), - pg_authid U + FROM pg_database D, pg_stat_get_activity(NULL) AS S, pg_authid U WHERE S.datid = D.oid AND S.usesysid = U.oid; diff --git a/src/include/catalog/catversion.h b/src/include/catalog/catversion.h index a75163b438..a340e1c111 100644 --- a/src/include/catalog/catversion.h +++ b/src/include/catalog/catversion.h @@ -53,6 +53,6 @@ */ /* yyyymmddN */ -#define CATALOG_VERSION_NO 200805071 +#define CATALOG_VERSION_NO 200805081 #endif diff --git a/src/include/catalog/pg_proc.h b/src/include/catalog/pg_proc.h index 44c61da118..123eab048f 100644 --- a/src/include/catalog/pg_proc.h +++ b/src/include/catalog/pg_proc.h @@ -2904,7 +2904,7 @@ DATA(insert OID = 2784 ( pg_stat_get_last_autoanalyze_time PGNSP PGUID 12 1 0 f DESCR("statistics: last auto analyze time for a table"); DATA(insert OID = 1936 ( pg_stat_get_backend_idset PGNSP PGUID 12 1 100 f f t t s 0 23 "" _null_ _null_ _null_ pg_stat_get_backend_idset - _null_ _null_ )); DESCR("statistics: currently active backend IDs"); -DATA(insert OID = 2022 ( pg_stat_get_activity PGNSP PGUID 12 1 100 f f f t s 1 2249 "23" _null_ _null_ _null_ pg_stat_get_activity - _null_ _null_ )); +DATA(insert OID = 2022 ( pg_stat_get_activity PGNSP PGUID 12 1 100 f f f t s 1 2249 "23" "{23,26,23,26,25,16,1184,1184,1184,869,23}" "{i,o,o,o,o,o,o,o,o,o,o}" "{pid,datid,procpid,usesysid,current_query,waiting,xact_start,query_start,backend_start,client_addr,client_port}" pg_stat_get_activity - _null_ _null_ )); DESCR("statistics: information about currently active backends"); DATA(insert OID = 2026 ( pg_backend_pid PGNSP PGUID 12 1 0 f f t f s 0 23 "" _null_ _null_ _null_ pg_backend_pid - _null_ _null_ )); DESCR("statistics: current backend PID"); -- 2.39.5