From: | byme(at)byme(dot)email |
---|---|
To: | Wim Bertels <wim(dot)bertels(at)ucll(dot)be> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: pg_stat_statements IN problem |
Date: | 2023-10-03 08:05:26 |
Message-ID: | 9o10Aeez9I_z3V3wCkp9jmm7sbI5JaySNUqBl44FoDvLz7RaPpYTxF6ZifZH7YKkWaWfM3XeFpDDFsHzMfb3koq8S51Z0NjbRJ6TT0_Hu0g=@byme.email |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you for response. Unfortunately, I have to update one section which I wrote wrong, it should have
been this way:
"This obfuscates our monitoring because the same query with different amount of arguments gets translated into this:
IN ($1, $2)
and so on."
The questions are:
1. Shouldnt IN behave so that the query in pg_stat_statements would look like this:
IN $1
2. Shouldnt there be at least some flag to aggregate such queries into one?
3. Is there any workaround how to aggregate those queries except the "= ANY"?
4. How come no one is bothered by this if this makes pg_stat_statements unusable with lots of queries using IN, what others do with this problem?
5. what do you mean by changing pg_stat_statements with another view/table?
LJ
P.S.: The only serious discussion I was able to find about it was from 2015 here, everyone basically stating that the improvement would be useful. https://postgrespro.com/list/thread-id/1880012
Sent with Proton Mail secure email.
------- Original Message -------
On Monday, October 2nd, 2023 at 8:50 PM, Wim Bertels <wim(dot)bertels(at)ucll(dot)be> wrote:
> byme(at)byme(dot)email schreef op ma 02-10-2023 om 16:19 [+0000]:
>
> > Is there a possibility the pg_stat_statements will be improved with
> > handling IN? This problem makes it so much less useful right now.
>
>
> not sure what the question is,
> but if you change pg_stat_statements with another view/table,
> the problem/answer would be the same
>
> https://www.postgresql.org/docs/current/functions-comparisons.html#FUNCTIONS-COMPARISONS-IN-SCALAR
From | Date | Subject | |
---|---|---|---|
Next Message | David Rowley | 2023-10-03 08:22:55 | Re: pg_stat_statements IN problem |
Previous Message | Dominique Devienne | 2023-10-03 07:29:14 | Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION? |