Postgres Pro
Downloads
Home   >   mailing lists

Re: Is it possible to log long running recursive/internal postgresql queries? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Is it possible to log long running recursive/internal postgresql queries?
Date
Msg-id 2713826.1676658480@sss.pgh.pa.us
Whole thread Raw
In response to Is it possible to log long running recursive/internal postgresql queries?  (Hotmail <crajac66@hotmail.com>)
Responses Re: Is it possible to log long running recursive/internal postgresql queries?  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view 
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.

            regards, tom lane

pgsql-admin by date:

Previous
From: Hotmail
Date:
Subject: Is it possible to log long running recursive/internal postgresql queries?
Next
From: Lucio Chiessi
Date:
Subject: Re: EOL of Pglogical replication support