Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres chooses slow query plan from time to time - Mailing list pgsql-performance

From Jeff Janes
Subject Re: Postgres chooses slow query plan from time to time
Date
Msg-id CAMkU=1yAuQ3N_jkwdxbcjH-j2-a-ZV34sAkdUyT4C=cNiAkOXQ@mail.gmail.com
Whole thread Raw
In response to Postgres chooses slow query plan from time to time  (Kristjan Mustkivi <sonicmonkey@gmail.com>)
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Postgres chooses slow query plan from time to time
Next
From: Andrew Dunstan
Date:
Subject: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4