Order of pg_stat_activity timestamp columns

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Order of pg_stat_activity timestamp columns
Дата
Msg-id 201003172042.o2HKgQv23693@momjian.us
обсуждение исходный текст
Ответы Re: Order of pg_stat_activity timestamp columns  (Magnus Hagander <magnus@hagander.net>)
Re: Order of pg_stat_activity timestamp columns  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
Has anyone ever noticed that the order of pg_stat_activity timestamp
columns is illogical:
xact_start       | timestamp with time zone |query_start      | timestamp with time zone |backend_start    | timestamp
withtime zone |
 

query_start is always between the other two timestamps.  Moving
query_start before xact_start would make the most sense.  I wouldn't
bring this up except we just added application_name before these
columns, so we are already going to have different column locations for
these fields in 9.0.

Should we move query_start?

--  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 по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Getting to beta1
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: An idle thought