I have one table with columns that are used as foreign-keys from
several other tables. Sometimes deletion from this table takes +5
seconds for a single row. Are there any utilities that can be used to
figure out why the deletion takes so long? "ANALYZE DELETE FROM foo
WHERE bar=gazonk" doesn't really help as it only explains how the
where statement is resolved, and not what postgres has to do to
preserve database integrity.
Regards,