Re: Logging queries executed by SPI_execute

2025-02-03 Thread Pavel Stehule
út 4. 2. 2025 v 5:09 odesílatel Marcelo Fernandes napsal: > On Mon, Feb 3, 2025 at 6:46 PM Pavel Stehule > wrote: > > The queries executed by SPI are never executed on the top level. These > queries are marked as nested. > > > > So you need to use auto_explain > https://www.postgresql.org/docs/c

Re: Logging queries executed by SPI_execute

2025-02-03 Thread Marcelo Fernandes
On Mon, Feb 3, 2025 at 6:46 PM Pavel Stehule wrote: > The queries executed by SPI are never executed on the top level. These > queries are marked as nested. > > So you need to use auto_explain > https://www.postgresql.org/docs/current/auto-explain.html with active > auto_explain.log_nested_stat

Re: Logging queries executed by SPI_execute

2025-02-02 Thread Pavel Stehule
Hi po 3. 2. 2025 v 0:06 odesílatel Marcelo Fernandes napsal: > Hi there, > > I have been trying to debug what queries an extension is firing. After > reading > the code for the extension, I noticed that all the statements are fired > via the > SPI interface, most specifically, using the SPI_exec

Logging queries executed by SPI_execute

2025-02-02 Thread Marcelo Fernandes
Hi there, I have been trying to debug what queries an extension is firing. After reading the code for the extension, I noticed that all the statements are fired via the SPI interface, most specifically, using the SPI_execute* family of functions. However, the problem is that these statements don'