Re: Query Plan Columns
Roberto Mello <roberto.mello@gmail.com>
From: Roberto Mello <roberto.mello@gmail.com>
To: "David E. Wheeler" <david@kineticode.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2010-11-07T13:24:06Z
Lists: pgsql-hackers
On Sat, Nov 6, 2010 at 6:24 PM, David E. Wheeler <david@kineticode.com> wrote: > > Would I be right that "Node Type" is the only column can be NOT NULL? > > Also, I'm thinking of making the "Actual Startup Time" and ""Actual Total Time" columns into INTERVALs. The times are expressed in milliseconds, yes? I'm wondering if INTERVAL would be more convenient for querying… Yes, but I am wondering whether you should just stick to what would come out of a normal explain, for consistency sake. Maybe provide another function, or parameter that would cast the results to intervals? Not sure. Roberto