Re:BUG #17552: pg_stat_statements tracks internal FK check queries when COPY used to load data

Sergei Kornilov <sk@zsrv.org>

From: Sergei Kornilov <sk@zsrv.org>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Julien Rouhaud <rjuju123@gmail.com>, maxim.boguk@gmail.com, pgsql-bugs@lists.postgresql.org, Tomas Vondra <tomas.vondra@enterprisedb.com>

Date: 2023-11-07T20:23:17Z

Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix some issues with tracking nesting level in pg_stat_statements.
- 76db9cb6368e 17.0 landed

Hello

Thannk you! I reviewed v3 patches. Looks good for me. I experimented with different options (track_planning, track top/all, track_utility, simple query and extended query protocols) and did not find any unexpected results in toplevel field.

> BTW, I'm inclined not to back-patch this. While it seems like a bug fix, it's also a behavioral change that might break someone's expectations.

I'm fine with patches only on HEAD.

regards, Sergei