Re: [WIP] showing index maintenance on EXPLAIN - Mailing list pgsql-hackers

From Haribabu Kommi
Subject Re: [WIP] showing index maintenance on EXPLAIN
Date
Msg-id CAJrrPGdMFRzgb_ZYDYzoR6Xdh8hNfEV0pVWj9W5GkPzuQkCC4g@mail.gmail.com
Whole thread Raw
In response to [WIP] showing index maintenance on EXPLAIN  (Jaime Casanova <jaime@2ndquadrant.com>)
List pgsql-hackers
On Thu, May 8, 2014 at 10:00 AM, Jaime Casanova <jaime@2ndquadrant.com> wrote:
> Hi,
>
> This patch implements $subject only when ANALYZE and VERBOSE are on.
> I made it that way because for years nobody seemed interested in this
> info (at least no one did it) so i decided that maybe is to much
> information for most people (actually btree indexes are normally very
> fast).
>
> But because we have GiST and GIN this became an interested piece of
> data (there are other cases even when using btree).
>
> Current patch doesn't have docs yet i will add them soon.

This patch provides the Insertion time of an index operation.
This information is useful to the administrator for reorganizing the indexes
based on the insertion time.

Quick review:

Applies to Head.
Regress test is passed.
Coding is fine.

Minor comments:

There is no need of printing the index insertion time as zero in case
of hot update operations.
Please correct the same.

Add the documentation changes.

Regards,
Hari Babu
Fujitsu Australia



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: replication commands and log_statements
Next
From: Michael Paquier
Date:
Subject: Re: replication commands and log_statements