Postgres Pro
Downloads
Home   >   mailing lists

EXPLAIN on DELETE statements - Mailing list pgsql-general

From Janning Vygen
Subject EXPLAIN on DELETE statements
Date
Msg-id 200407281341.27409.vygen@gmx.de
Whole thread Raw
Responses Re: EXPLAIN on DELETE statements  (Grant McLean <grant@catalyst.net.nz>)
List pgsql-general
Tree view 
Hi,

EXPLAIN on delete stamements works, but doesn't show me all the subsequent
deletes or checks which has to be done because of foreign keys
cascading/restricting.

Is there a solution to show up which tables are checked and which scans the
planner is going to use to check these related tables?

kind regards,
janning

pgsql-general by date:

Previous
From: val@webtribe.net
Date:
Subject: Indexes on Character Types
Next
From: Prabu Subroto
Date:
Subject: Re: altering a table to set serial function