Re: Order of pg_stat_activity timestamp columns

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Order of pg_stat_activity timestamp columns
Дата
Msg-id 201003172124.o2HLOTm29254@momjian.us
обсуждение исходный текст
Ответ на Re: Order of pg_stat_activity timestamp columns  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Order of pg_stat_activity timestamp columns  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: An idle thought
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Order of pg_stat_activity timestamp columns