Mark Lewis <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
