diff options
| author | Bruce Momjian <bruce@momjian.us> | 2010-04-26 14:22:37 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2010-04-26 14:22:37 +0000 |
| commit | 75c57381775e8224d78930622ef25776122a46a3 (patch) | |
| tree | 073518066688f4d1629a9f09dfde899392c9b9a9 /src/backend | |
| parent | 7eb6e6b48adfe89861923e83aee9f697c50275b0 (diff) | |
| download | postgresql-75c57381775e8224d78930622ef25776122a46a3.tar.gz postgresql-75c57381775e8224d78930622ef25776122a46a3.zip | |
Reorder pg_stat_activity columns to be more consistent, using layout
suggested by Tom Lane.
Catalog version bumped due to system view change.
Diffstat (limited to 'src/backend')
| -rw-r--r-- | src/backend/catalog/system_views.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/backend/catalog/system_views.sql b/src/backend/catalog/system_views.sql index 9121e8416e5..8be3defe753 100644 --- a/src/backend/catalog/system_views.sql +++ b/src/backend/catalog/system_views.sql @@ -3,7 +3,7 @@ * * Copyright (c) 1996-2010, PostgreSQL Global Development Group * - * $PostgreSQL: pgsql/src/backend/catalog/system_views.sql,v 1.65 2010/01/02 16:57:36 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/catalog/system_views.sql,v 1.66 2010/04/26 14:22:37 momjian Exp $ */ CREATE VIEW pg_roles AS @@ -335,13 +335,13 @@ CREATE VIEW pg_stat_activity AS S.usesysid, U.rolname AS usename, S.application_name, - S.current_query, - S.waiting, + S.client_addr, + S.client_port, + S.backend_start, S.xact_start, S.query_start, - S.backend_start, - S.client_addr, - S.client_port + S.waiting, + S.current_query FROM pg_database D, pg_stat_get_activity(NULL) AS S, pg_authid U WHERE S.datid = D.oid AND S.usesysid = U.oid; |