Prev: PQftype implementation
Next: Order of pg_stat_activity timestamp columns
From: Bruce Momjian on 17 Mar 2010 16:42
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 with time 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(a)momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

 | 
Pages: 1
Prev: PQftype implementation
Next: Order of pg_stat_activity timestamp columns