pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17665: pg_stat_statements useless with variable number of parameters in IN close
2+ messages / 2 participants
[nested] [flat]
* BUG #17665: pg_stat_statements useless with variable number of parameters in IN close
@ 2022-10-27 10:42 PG Bug reporting form <noreply@postgresql.org>
2022-10-27 12:58 ` Re: BUG #17665: pg_stat_statements useless with variable number of parameters in IN close Julien Rouhaud <rjuju123@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2022-10-27 10:42 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: bokanist@gmail.com
The following bug has been logged on the website:
Bug reference: 17665
Logged by: Sebastien Caunes
Email address: bokanist@gmail.com
PostgreSQL version: 15.0
Operating system: all
Description:
Not really a bug, but this issue makes pg_stat_statements almost useless.
One of my customer have queries with variables number of parameters in IN
closes
SELECT * FROM my_table WHERE id IN ($1, $2, $3, $4, ...) -- number of
parameters varies from one to thousands
And some queries have more than one IN close. This bloat the
pg_stat_statement table with all different version of the same query.
I think the parameters in IN close should be merged as one.
By the way, where should I submit this kind of improvement request ?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17665: pg_stat_statements useless with variable number of parameters in IN close
2022-10-27 10:42 BUG #17665: pg_stat_statements useless with variable number of parameters in IN close PG Bug reporting form <noreply@postgresql.org>
@ 2022-10-27 12:58 ` Julien Rouhaud <rjuju123@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Julien Rouhaud @ 2022-10-27 12:58 UTC (permalink / raw)
To: bokanist@gmail.com; pgsql-bugs@lists.postgresql.org
Hi,
On Thu, Oct 27, 2022 at 10:42:52AM +0000, PG Bug reporting form wrote:
>
> Not really a bug, but this issue makes pg_stat_statements almost useless.
>
> One of my customer have queries with variables number of parameters in IN
> closes
>
> SELECT * FROM my_table WHERE id IN ($1, $2, $3, $4, ...) -- number of
> parameters varies from one to thousands
>
> And some queries have more than one IN close. This bloat the
> pg_stat_statement table with all different version of the same query.
>
> I think the parameters in IN close should be merged as one.
> By the way, where should I submit this kind of improvement request ?
I agree, and this is a known problem however it isn't as simple to fix as it
looks. You can find the latest discussion about it at
https://www.postgresql.org/message-id/flat/CA%2Bq6zcWtUbT_Sxj0V6HY6EZ89uv5wuG5aefpe_9n0Jr3VwntFg%40m...
if you want more details or participate.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-10-27 12:58 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-10-27 10:42 BUG #17665: pg_stat_statements useless with variable number of parameters in IN close PG Bug reporting form <noreply@postgresql.org>
2022-10-27 12:58 ` Julien Rouhaud <rjuju123@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox