list number of entries to be delete in cascading deletes

From: Eildert Groeneveld <eildert(dot)groeneveld(at)fli(dot)bund(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: list number of entries to be delete in cascading deletes
Date: 2014-02-11 20:54:04
Message-ID: 1392152044.4823.9.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dear All

this probably not the best list to post this question:

I use cascading deletes but would like to first inform the user what she
is about to do.
Something like : explain delete from PANEL where panel_id=21;
-- you are about to delete 32144 records in tables abc aaa wewew

This is clearly something that can be programmed but as all information
is available in the database schema, there should be a generalized
procedure available.

Is there someone who has heard about this problem?

greetings

Eildert

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Claudio Freire 2014-02-11 20:58:03 Re: list number of entries to be delete in cascading deletes
Previous Message Claudio Freire 2014-02-11 19:51:36 Re: [PERFORM] encouraging index-only scans