Re: Odd behavior with pg_stat_statements and queries called from SQL functions

2022-11-17 Thread Ashutosh Bapat
On Thu, Nov 17, 2022 at 2:44 PM Julien Rouhaud wrote: > > Hi, > > On Wed, Nov 16, 2022 at 11:26:09PM -0800, Maciek Sakrejda wrote: > > I noticed an odd behavior today in pg_stat_statements query > > normalization for queries called from SQL-language functions. If I > > have three functions that

Re: Odd behavior with pg_stat_statements and queries called from SQL functions

2022-11-17 Thread Julien Rouhaud
Hi, On Wed, Nov 16, 2022 at 11:26:09PM -0800, Maciek Sakrejda wrote: > I noticed an odd behavior today in pg_stat_statements query > normalization for queries called from SQL-language functions. If I > have three functions that call an essentially identical query (the > functions are only marked

Odd behavior with pg_stat_statements and queries called from SQL functions

2022-11-16 Thread Maciek Sakrejda
I noticed an odd behavior today in pg_stat_statements query normalization for queries called from SQL-language functions. If I have three functions that call an essentially identical query (the functions are only marked SECURITY DEFINER to prevent inlining): maciek=# create or replace function