Mark Lewis <mark.lewis@xxxxxxxx> writes: > Out of curiosity, how hard would it be to modify the output of EXPLAIN > ANALYZE when doing an insert/update to include the index update times > and/or non-FK constraint checking times and/or the table row update > times? I don't think it'd help much --- in an example like this, other tools like vmstat would be more likely to be useful in investigating the problem. There's also the problem that EXPLAIN ANALYZE overhead is already too high --- another dozen gettimeofday() calls per row processed doesn't sound appetizing. regards, tom lane
