On Mon, Sep 13, 2021 at 9:25 AM Kristjan Mustkivi <sonicmon...@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

Reply via email to