]> granicus.if.org Git - postgresql/commit
Add a txn_start column to pg_stat_activity. This makes it easier to
authorNeil Conway <neilc@samurai.com>
Wed, 6 Dec 2006 18:06:48 +0000 (18:06 +0000)
committerNeil Conway <neilc@samurai.com>
Wed, 6 Dec 2006 18:06:48 +0000 (18:06 +0000)
commit886a02d1cb19fe25859bd3c2d1f6a64b04cdc710
treea0684de747e49ba23b5c7fead1052d378ecbb4dd
parentdd740e1fd066a5df628ba28dfdaee02d58dee0c5
Add a txn_start column to pg_stat_activity. This makes it easier to
identify long-running transactions. Since we already need to record
the transaction-start time (e.g. for now()), we don't need any
additional system calls to report this information.

Catversion bumped, initdb required.
doc/src/sgml/monitoring.sgml
src/backend/access/transam/xact.c
src/backend/catalog/system_views.sql
src/backend/postmaster/pgstat.c
src/backend/utils/adt/pgstatfuncs.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.h
src/include/pgstat.h
src/test/regress/expected/rules.out