Bear in mind that the DELETEs issued by the ON DELETE CASCADE trigger will be rewritten by this same rule.
There has been debate in the past whether this behavior is a feature or a bug, but it's unlikely to change soon.
Why postgres does not show this trigger for a better understanding?
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings