| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_stat_statements and planning time |
| Date: | 2012-03-08 13:09:54 |
| Message-ID: | CA+Tgmobq3BVLghTu9XBjkxQ6adyfP+ppv+WKwybE+sL7cH9Wpg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Mar 7, 2012 at 9:59 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2012-03-08 13:11:36 | Re: [PATCH] Support for foreign keys with arrays |
| Previous Message | Martin Pihlak | 2012-03-08 12:34:05 | Re: Patch review for logging hooks (CF 2012-01) |