Hi, I was wondering whether anyone has any insight with regards to measuring and reporting the overhead of maintaining indexes on relations. If an UPDATE is issued to a table with, say, 6 indexes, it would be useful to determine how much time is spent updating each of those indexes. And perhaps such timings would not be confined to indexes, but also other dependants that add overhead, such as triggers, rules, and in future, eager incremental materialised view updates.
One use case I had in mind is observing whether any index is particularly burdensome to the overall plan. Then an analysis of those numbers could show that, for example, 25% of the time spent on DML on table my_table were spent on maintaining index idx_my_table_a... and index that's not often used. Is that something that could be provided in an EXPLAIN ANALYSE node? Thom -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
