Re: how can i show constraint checks in explain ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jonathan Vanasco <postgres(at)2xlp(dot)com>
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: how can i show constraint checks in explain ?
Date: 2007-03-17 19:43:32
Message-ID: 15100.1174160612@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jonathan Vanasco <postgres(at)2xlp(dot)com> writes:
> However-- explain doesn't pull in the planner's scanning info in
> regards to the fkey constraints. is there any function or argument
> that will ?

Not directly --- but in reasonably recent PG versions, EXPLAIN ANALYZE
shows the runtime for trigger functions, including fkey triggers.
That would let you figure out which fkey is the problem.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2007-03-17 19:51:09 Re: Postgres Database size
Previous Message Alain Roger 2007-03-17 19:19:53 issue with SELECT settval(..);