Transaction start in pg_stat_activity - Mailing list pgsql-patches

From Neil Conway
Subject Transaction start in pg_stat_activity
Date
Msg-id 1163904295.23622.16.camel@localhost.localdomain
Whole thread Raw
Responses Re: Transaction start in pg_stat_activity
List pgsql-patches
Attached is a first revision of a patch that adds a column to
pg_stat_activity containing the time at which the backend's current
transaction began, or NULL if the backend is not inside a transaction.
This is useful for finding long-running transactions, and AFAIK this
information is not otherwise easily available from outside the backend's
session.

Naturally, this is for 8.3.

-Neil


Attachment

pgsql-patches by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: Proposed patch for xact-vs-multixact bugs
Next
From: Neil Conway
Date:
Subject: Re: add external pl language section, clean up some links