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

Re: Finalizing commit taking very long

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Giulio Cesare Solaroli" <giulio(dot)cesare(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Finalizing commit taking very long
Date: 2007-10-24 14:03:36
Message-ID: 2051.1193234616@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"Giulio Cesare Solaroli" <giulio(dot)cesare(at)gmail(dot)com> writes:
> How can I try to isolate the trigger taking so long, in oder to
> understand which is/are the missing index(es)?

Try SET CONSTRAINTS ALL IMMEDIATE and then EXPLAIN ANALYZE the
delete.  This should cause all the triggers to run within the
scope of the EXPLAIN ANALYZE, and you'll be able to see which
one(s) are slow.  (This assumes you're running a recent release
of PG; I think EXPLAIN shows trigger times since 8.1 or so.)

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Giulio Cesare SolaroliDate: 2007-10-24 14:25:53
Subject: Re: Finalizing commit taking very long
Previous:From: Giulio Cesare SolaroliDate: 2007-10-24 13:37:07
Subject: Re: Finalizing commit taking very long

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