On 7 December 2013 20:44, Tom Lane <t...@sss.pgh.pa.us> wrote: > Thom Brown <t...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
