On Fri, 2023-02-17 at 13:28 -0500, Tom Lane wrote: > Hotmail <crajac66@xxxxxxxxxxx> writes: > > If it is possible to log long running internal queries as outlined above any guidance would be appreciated. > > Either auto_explain or pg_stat_statements could have helped you > with that, I think. I believe (without having tested) that if > configured to track nested statements they would perceive the > FK enforcement query as a separate statement to track. Yes, they do. You need to set "auto_explain.log_nested_statements = on" or "pg_stat_statements.track = all". Yours, Laurenz Albe
