diff options
| author | Bruce Momjian | 2003-03-20 03:34:57 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2003-03-20 03:34:57 +0000 |
| commit | a18331004a15c4e37fe88312bd882b49edb8228f (patch) | |
| tree | 40ce63073108d5823958c460bc7698fb97423428 /src/bin/initdb | |
| parent | ddd50a0babd9a8ae478eee607108b7ed5675571d (diff) | |
Add start time to pg_stat_activity
Neil Conway
Diffstat (limited to 'src/bin/initdb')
| -rw-r--r-- | src/bin/initdb/initdb.sh | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/bin/initdb/initdb.sh b/src/bin/initdb/initdb.sh index 6bd01db36bc..646b941cfa5 100644 --- a/src/bin/initdb/initdb.sh +++ b/src/bin/initdb/initdb.sh @@ -27,7 +27,7 @@ # Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # -# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.185 2003/03/19 16:08:59 petere Exp $ +# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.186 2003/03/20 03:34:56 momjian Exp $ # #------------------------------------------------------------------------- @@ -953,7 +953,8 @@ CREATE VIEW pg_stat_activity AS \ pg_stat_get_backend_pid(S.backendid) AS procpid, \ pg_stat_get_backend_userid(S.backendid) AS usesysid, \ U.usename AS usename, \ - pg_stat_get_backend_activity(S.backendid) AS current_query \ + pg_stat_get_backend_activity(S.backendid) AS current_query, \ + pg_stat_get_backend_activity_start(S.backendid) AS query_start \ FROM pg_database D, \ (SELECT pg_stat_get_backend_idset() AS backendid) AS S, \ pg_shadow U \ |