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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hotmail <crajac66(at)hotmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Is it possible to log long running recursive/internal postgresql queries?
Date: 2023-02-17 18:28:00
Message-ID: 2713826.1676658480@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hotmail <crajac66(at)hotmail(dot)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.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lucio Chiessi 2023-02-17 21:00:35 Re: EOL of Pglogical replication support
Previous Message Hotmail 2023-02-17 17:48:42 Is it possible to log long running recursive/internal postgresql queries?