Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17330: EXPLAIN hangs and very long query plans - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #17330: EXPLAIN hangs and very long query plans
Date
Msg-id CAMkU=1wyt1r7yhK8Qvui89rMyqZyATchGdLVB4cPRi7To=3zcA@mail.gmail.com
Whole thread Raw
In response to BUG #17330: EXPLAIN hangs and very long query plans  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #17330: EXPLAIN hangs and very long query plans  (Strahinja Kustudić <strahinjak@nordeus.com>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17332: Cannot read termcap database
Next
From: Peter Geoghegan
Date:
Subject: Re: BUG #17330: EXPLAIN hangs and very long query plans