EXPLAIN on DELETE statements

From: Janning Vygen <vygen(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: EXPLAIN on DELETE statements
Date: 2004-07-28 11:41:27
Message-ID: 200407281341.27409.vygen@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Prabu Subroto 2004-07-28 12:09:33 Re: altering a table to set serial function
Previous Message val 2004-07-28 11:31:00 Indexes on Character Types