Postgres Pro
Downloads
Home   >   mailing lists

Re: Delete query takes exorbitant amount of time - Mailing list pgsql-performance

From Tom Lane
Subject Re: Delete query takes exorbitant amount of time
Date
Msg-id 20491.1111731317@sss.pgh.pa.us
Whole thread Raw
In response to Delete query takes exorbitant amount of time  (Karim Nassar <Karim.Nassar@acm.org>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Delete query takes exorbitant amount of time
Next
From: Tom Lane
Date:
Subject: Re: Delete query takes exorbitant amount of time