Hi,
today I was trying to figure out, what's going on during a delete on a table
with several foreign key triggers (and "on delete cascade"). But, as found in
the achives,
"EXPLAIN on a delete isn't very interesting.."
because it doesn tell me, what going on behind the scenes, where the triggers
are running.
So my question is: Is there another way besides "explain" to get information
out of postgresql (7.3.1) what's going on during a "delete" on a table with
many foreign key triggers .
The only other option what comes to my mind is to inspect the foreign key
dependencies and check manually, if some index is missing (But I was hoping,
the maching could tell me that...).
Best regards and thanks a lot,
Tilo