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