Re: Slow update with simple query

Mark Lewis  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