Re: Is it possible to log long running recursive/internal postgresql queries?

On Fri, 2023-02-17 at 13:28 -0500, Tom Lane wrote:
> Hotmail <crajac66@hotmail.com> 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