Re: Order of pg_stat_activity timestamp columns

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