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