On Mon, 2006-11-20 at 10:58 -0500, Tom Lane wrote:
> "Simon Riggs" <simon@2ndquadrant.com> writes:
> > Great idea. Would it be appropriate to show the time the current
> > snapshot was taken also/instead?
>
> There is no way we are putting a gettimeofday() call into
> GetSnapshotData. I thought you were focused on performance??
LOL.
My understanding was there was already a gettimeofday() call per
statement which is displayed in pg_stat_activity. It seems relatively
straightforward to have another column which is *not* updated for each
statement when we are in SERIALIZABLE mode and CommandId > 1.
So I wasn't talking about issuing any additional gettimeofday() calls at
all. :-)
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com