Postgres Pro
Downloads
Home   >   mailing lists

Re: how can i show constraint checks in explain ? - Mailing list pgsql-general

From Tom Lane
Subject Re: how can i show constraint checks in explain ?
Date
Msg-id 15100.1174160612@sss.pgh.pa.us
Whole thread Raw
In response to how can i show constraint checks in explain ?  (Jonathan Vanasco <postgres@2xlp.com>)
List pgsql-general
Tree view 
Jonathan Vanasco <postgres@2xlp.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

pgsql-general by date:

Previous
From: "Alain Roger"
Date:
Subject: issue with SELECT settval(..);
Next
From: Tino Wildenhain
Date:
Subject: Re: Postgres Database size