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

pgsql: Add a txn_start column to pg_stat_activity.

From: neilc(at)postgresql(dot)org (Neil Conway)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add a txn_start column to pg_stat_activity.
Date: 2006-12-06 18:06:48
Message-ID: 20061206180648.5BC7C9FA372@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
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.

Modified Files:
--------------
    pgsql/doc/src/sgml:
        monitoring.sgml (r1.41 -> r1.42)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/monitoring.sgml.diff?r1=1.41&r2=1.42)
    pgsql/src/backend/access/transam:
        xact.c (r1.229 -> r1.230)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xact.c.diff?r1=1.229&r2=1.230)
    pgsql/src/backend/catalog:
        system_views.sql (r1.32 -> r1.33)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/system_views.sql.diff?r1=1.32&r2=1.33)
    pgsql/src/backend/postmaster:
        pgstat.c (r1.140 -> r1.141)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/pgstat.c.diff?r1=1.140&r2=1.141)
    pgsql/src/backend/utils/adt:
        pgstatfuncs.c (r1.34 -> r1.35)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/pgstatfuncs.c.diff?r1=1.34&r2=1.35)
    pgsql/src/include:
        pgstat.h (r1.50 -> r1.51)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/pgstat.h.diff?r1=1.50&r2=1.51)
    pgsql/src/include/catalog:
        catversion.h (r1.360 -> r1.361)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.360&r2=1.361)
        pg_proc.h (r1.429 -> r1.430)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h.diff?r1=1.429&r2=1.430)
    pgsql/src/test/regress/expected:
        rules.out (r1.121 -> r1.122)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out.diff?r1=1.121&r2=1.122)

pgsql-committers by date

Next:From: Tom LaneDate: 2006-12-06 19:40:01
Subject: pgsql: Fix planning of SubLinks to ensure that Vars generated from
Previous:From: Neil ConwayDate: 2006-12-06 17:35:49
Subject: pgsql: Various improvements to the GUC description strings.

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