Re: Slow update with simple query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Slow update with simple query
Дата
Msg-id 21627.1166115026@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Slow update with simple query  (Mark Lewis <mark.lewis@mir3.com>)
Список pgsql-performance
Mark Lewis <mark.lewis@mir3.com> 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: EXPLAIN ANALYZE on 8.2
Следующее
От: "Rohit Prakash Khare"
Дата:
Сообщение: unsubscribe