Re: Delete query takes exorbitant amount of time

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Delete query takes exorbitant amount of time
Дата
Msg-id 20491.1111731317@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Delete query takes exorbitant amount of time  (Karim Nassar <Karim.Nassar@acm.org>)
Список pgsql-performance
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> Hmm ... I wonder how hard it would be to teach EXPLAIN ANALYZE to show
>> the runtime expended in each trigger when the statement is of a kind
>> that has triggers.

> Could SPI "know" that an explain analyze is being run and add their
> output and timings to the output?

If it did, we'd be double-counting the time.

            regards, tom lane

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

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: Delete query takes exorbitant amount of time
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Delete query takes exorbitant amount of time