Re: Delete query takes exorbitant amount of time

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Delete query takes exorbitant amount of time
Дата
Msg-id 424387BD.3070909@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Delete query takes exorbitant amount of time  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
> 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.  We couldn't break down the time *within* the
> triggers, but even this info would help a lot in terms of finger
> pointing ...
>
>     Seq Scan on ... (nn.nnn ms)
>     Trigger foo: nn.mmm ms
>     Trigger bar: nn.mmm ms
>     Total time: nn.mmm ms

That would be really cool...

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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Delete query takes exorbitant amount of time
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: Delete query takes exorbitant amount of time