Re: BUG #17330: EXPLAIN hangs and very long query plans

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: BUG #17330: EXPLAIN hangs and very long query plans
Дата
Msg-id CAMkU=1wyt1r7yhK8Qvui89rMyqZyATchGdLVB4cPRi7To=3zcA@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17330: EXPLAIN hangs and very long query plans  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #17330: EXPLAIN hangs and very long query plans  (Strahinja Kustudić <strahinjak@nordeus.com>)
Список pgsql-bugs
Дерево обсуждения
On Thu, Dec 9, 2021 at 10:28 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      17330
Logged by:          Strahinja Kustudic
Email address:      strahinjak@nordeus.com
PostgreSQL version: 10.19
Operating system:   CentOS 7
Description:       
 
 The issue is that in Docker EXPLAIN runs forever, it never
finishes, like the issue we had on the replica. This means I have a 100%
repro of the issue and I can do whatever you tell me to do to find out what
caused it.

Is this 100% CPU bound?  'perf top -p <pid>' would probably be my first tool to use here.

Also, it would be nice to know if an upgrade to a newer major version fixed the problem.

Cheers,

Jeff

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17332: Cannot read termcap database
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #17330: EXPLAIN hangs and very long query plans