From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
---|---|
To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [WIP] showing index maintenance on EXPLAIN |
Date: | 2014-05-09 18:03:35 |
Message-ID: | CAJKUy5hmG-jgsb-iZ0fekn70siQdh+XRNkg4cXBB9yUb6wuhyg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, May 8, 2014 at 10:44 PM, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> On Thu, May 8, 2014 at 12:01 PM, Jaime Casanova <jaime(at)2ndquadrant(dot)com> wrote:
>> On Wed, May 7, 2014 at 10:52 PM, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>>>
>>> Why to capture only for Index Insert/Update and not for Read; is it
>>> because Read will be always fast ot implementation complexity?
>>>
>> EXPLAIN ANALYZE already shows that on any SELECT that uses an index in
>> some way. Or are you thinking on something else?
>
[...]
>
> Are you referring actual time in above print?
>
> The actual time is node execution time which in above kind of cases will
> be: scanning the index + scanning the heap. I think it is not same what
> you are planning to show for Insert/Update case.
>
ah! good point! my current case is because of write performance, but
will look at it a little
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2014-05-09 18:09:31 | Re: Sending out a request for more buildfarm animals? |
Previous Message | Josh Berkus | 2014-05-09 18:01:23 | Re: How can we make beta testing better? |