| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Strahinja Kustudić <strahinjak(at)nordeus(dot)com>, pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #17330: EXPLAIN hangs and very long query plans |
| Date: | 2021-12-10 01:31:15 |
| Message-ID: | CAMkU=1wyt1r7yhK8Qvui89rMyqZyATchGdLVB4cPRi7To=3zcA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thu, Dec 9, 2021 at 10:28 AM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 17330
> Logged by: Strahinja Kustudic
> Email address: strahinjak(at)nordeus(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2021-12-10 01:35:47 | Re: BUG #17330: EXPLAIN hangs and very long query plans |
| Previous Message | PG Bug reporting form | 2021-12-10 01:26:13 | BUG #17332: Cannot read termcap database |