Re: Order of pg_stat_activity timestamp columns - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Order of pg_stat_activity timestamp columns
Date
Msg-id 201003172124.o2HLOTm29254@momjian.us
Whole thread Raw
In response to Re: Order of pg_stat_activity timestamp columns  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Order of pg_stat_activity timestamp columns
List pgsql-hackers
Kevin Grittner wrote:
> Bruce Momjian <bruce@momjian.us> wrote:
>  
> >  xact_start       | timestamp with time zone |
> >  query_start      | timestamp with time zone |
> >  backend_start    | timestamp with time zone |
>  
> > Should we move query_start?
>  
> It would scan better, to my mind, if we moved backend_start ahead of
> xact_start.

Yes, that is another idea that would work, though Tom's idea that the
query start should be near the query makes sense.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 PG East:  http://www.enterprisedb.com/community/nav-pg-east-2010.do


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: An idle thought
Next
From: Tom Lane
Date:
Subject: Re: Order of pg_stat_activity timestamp columns