Re: LONG delete with LOTS of FK's

Larry Rosenman <ler@lerctr.org> writes:
> On 2013-05-01 10:23, Shaun Thomas wrote:
>> Wow. I really hope every single one of those tables has an index on
>> the listed column, and it's the same datatype (bigint). Otherwise,
>> this is going to take a long, long time.

> Yes, all of them have at least one index that has account_id as the
> first column (we use that to
> separate tenants in a multi-tenant app).

> I still wonder if there is a way to see where it is :(

You could try EXPLAIN ANALYZE on a cut-down query that just deletes
a few hundred or thousand rows.  That would help identify whether
there's a particular table that's causing the bottleneck.

            regards, tom lane