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