Re: Order of pg_stat_activity timestamp columns

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Bruce Momjian" <bruce(at)momjian(dot)us>, "PostgreSQL-development" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Order of pg_stat_activity timestamp columns
Date: 2010-03-17 21:17:49
Message-ID: 4BA100AD020000250002FE70@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <bruce(at)momjian(dot)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.

And paint it red.

-Kevin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-03-17 21:20:00 Re: An idle thought
Previous Message Tom Lane 2010-03-17 21:17:42 Re: Order of pg_stat_activity timestamp columns