Re: Issue in recent pg_stat_statements?
| От | David Christensen |
|---|---|
| Тема | Re: Issue in recent pg_stat_statements? |
| Дата | |
| Msg-id | CAOxo6X+Giy8M31b-dEGFMZrPyLPWeAES6+2uB8wijLRFrbJj9Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Issue in recent pg_stat_statements? (Magnus Hagander <magnus@hagander.net>) |
| Ответы |
Re: Issue in recent pg_stat_statements?
|
| Список | pgsql-hackers |
> Is this an expected change, or is this in fact broken? In previous revisions, this was showing the INSERT and SELECT at the very least. I'm unclear as to why the regression test is still passing, so want to verify that I'm not doing something wrong in the testing.
Yes, you want to look into the queryid functionality. See
https://www.postgresql.org/message-id/flat/35457b09-36f8-add3-1d07-6034fa585ca8%40oss.nttdata.com
Interface changes may still be coming in 14 for that. Or warnings.
Hmm, I'm unclear as to why you would potentially want to use pg_stat_statements *without* this functionality. At the very least, it violates POLA — I spent the better part of a day thinking this was a bug due to the expected behavior being so obvious I wouldn't have expected any different.
In any case, this discussion is better had on a different thread. Thanks at least for explaining what I was seeing.
Best,
David
В списке pgsql-hackers по дате отправления: