Re: Index overhead cost reporting

On 7 December 2013 20:44, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Thom Brown <thom@linux.com> writes:
>> So in essence, I'd only be looking for a breakdown of anything that
>> adds to the duration of the DML statement.  However, it sounds like
>> even that isn't straightforward from what you've written.
>
> I think that would be reasonably straightforward, though perhaps too
> expensive depending on the speed of clock reading.  My larger point was
> that I don't think that that alone is a fair measure of the cost of
> maintaining an index, which is what you had claimed to be interested in.

Point taken.  Yes, I don't believe I was that clear.  This was a "how
much of my DML statement time was spent updating indexes" rather than
a "give me stats on index maintenance times for these indexes".

It's a shame that it comes at a non-trivial price.

Thom