Skip site navigation (1) Skip section navigation (2)

Re: Delete query takes exorbitant amount of time

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Delete query takes exorbitant amount of time
Date: 2005-03-28 17:35:50
Message-ID: 1112031350.23412.131.camel@amateljan.mirlogic.com (view raw or flat)
Thread:
Lists: pgsql-performance
Tom Lane Wrote:
> 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


So I got the latest from CVS on Friday night to see how hard it would be
to implement this, but it turns out that Tom has already committed the
improvement, so I'm in Tom's fan club today.  I imported my test dataset
and was almost immediately able to track down the cause of my
performance problem.

Thanks!
Mark Lewis


In response to

Responses

pgsql-performance by date

Next:From: Steve PoeDate: 2005-03-28 17:36:46
Subject: Re: How to improve db performance with $7K?
Previous:From: Karim A NassarDate: 2005-03-28 16:37:01
Subject: Re: Delete query takes exorbitant amount of time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group