Re: Order of pg_stat_activity timestamp columns

Kevin Grittner <kevin.grittner@wicourts.gov>

From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Bruce Momjian" <bruce@momjian.us>, "PostgreSQL-development" <pgsql-hackers@postgresql.org>
Date: 2010-03-17T21:39:34Z
Lists: pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote:
 
> The current column ordering can be rationalized to some extent as
> 
> 	1. identity info (user id, db id, application name)
> 	2. current query info
> 	3. session info (backend start time, client addr/port)
 
OK.  I guess that trumps my idea, although it would sure be nice if
it were possible to swap 2 and 3 so that we could put the query text
at the end.
 
-Kevin