From: Tom Lane <tgl@sss.pgh.pa.us>
To: Giulio Cesare Solaroli <giulio.cesare@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Finalizing commit taking very long
Date: Wed, 24 Oct 2007 10:03:36 -0400
Message-ID: <2051.1193234616@sss.pgh.pa.us> (raw)
In-Reply-To: <ff737ac30710240637m39fb0063m466074623d682c38@mail.gmail.com>
References: <ff737ac30710240344v4391d2eeq957e91dca6c2f9e0@mail.gmail.com>
<1302.1193231756@sss.pgh.pa.us>
<ff737ac30710240637m39fb0063m466074623d682c38@mail.gmail.com>
"Giulio Cesare Solaroli" <giulio.cesare@gmail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, giulio.cesare@gmail.com
Subject: Re: Finalizing commit taking very long
In-Reply-To: <2051.1193234616@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox