Re: Postgres chooses slow query plan from time to time

On Mon, Sep 13, 2021 at 9:25 AM Kristjan Mustkivi <sonicmonkey@gmail.com>
wrote:

>
> I have caught this with AUTOEXPLAIN:
>
>           Index Cond: ((cage_code = $3) AND (cage_player_id = $2) AND
> (modified_time < $5))
>           Filter: (((product_code)::text = ($1)::text) AND
> ((balance_type)::text = ($4)::text))
>
>
Is it always the case that autoexplain shows plans with $1 etc, rather than
real values, for the slow queries?

If so, then it could be that the switch from custom to generic plans is
causing the problem.

Cheers,

Jeff