Re: Postgres chooses slow query plan from time to time

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Postgres chooses slow query plan from time to time
Дата
Msg-id CAMkU=1yAuQ3N_jkwdxbcjH-j2-a-ZV34sAkdUyT4C=cNiAkOXQ@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres chooses slow query plan from time to time  (Kristjan Mustkivi <sonicmonkey@gmail.com>)
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Postgres chooses slow query plan from time to time
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4