Re: pg_stat_statements and planning time - Mailing list pgsql-hackers

From Robert Haas
Subject Re: pg_stat_statements and planning time
Date
Msg-id CA+Tgmobq3BVLghTu9XBjkxQ6adyfP+ppv+WKwybE+sL7cH9Wpg@mail.gmail.com
Whole thread Raw
In response to Re: pg_stat_statements and planning time  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: pg_stat_statements and planning time  (Peter Geoghegan <peter@2ndquadrant.com>)
List pgsql-hackers
On Wed, Mar 7, 2012 at 9:59 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
>> I'd like to have the planning time in a number of other places as
>> well, such as EXPLAIN, and maybe statistics views.
>
> +1 for EXPLAIN. But which statistics views are in your mind?

I don't know.  I'm not sure if it's interesting to be able to count
planning time vs. execution time on a server-wide basis, or even a
per-database basis, but it seems like it might be, if we can do it
cheaply.  Then again, considering that gettimeofday is kinda
expensive, I suppose that would have to be optional if we were to have
it at all.  Just thinking out loud, mostly.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Martin Pihlak
Date:
Subject: Re: Patch review for logging hooks (CF 2012-01)
Next
From: Robert Haas
Date:
Subject: Re: [PATCH] Support for foreign keys with arrays