On 2019/04/08 16:33, Pavel Stehule wrote:
po 8. 4. 2019 v 16:11 odesílatel Krzysztof Plocharz
mailto:ploch...@9livesdata.com>> napsal:
Hi
We have some very strange query planning problem. Long story short it
takes 67626.278ms just to plan. Query execution take
On 2019/04/08 16:42, Justin Pryzby wrote:
On Mon, Apr 08, 2019 at 04:33:34PM +0200, Pavel Stehule wrote:
po 8. 4. 2019 v 16:11 odes�latel Krzysztof Plocharz
napsal:
We have some very strange query planning problem. Long story short it
takes 67626.278ms just to plan. Query execution takes
No, Autovacuum is running.
On 2019/04/08 16:18, Igor Neyman wrote:
-Original Message-
From: Krzysztof Plocharz [mailto:ploch...@9livesdata.com]
Sent: Monday, April 08, 2019 10:11 AM
To: pgsql-performance@lists.postgresql.org
Subject: Planning performance problem (67626.278ms)
Hi
We
Hi
We have some very strange query planning problem. Long story short it
takes 67626.278ms just to plan. Query execution takes 12ms.
Query has 7 joins and 2 subselects.
It looks like the issue is not deterministic, sometimes is takes few ms
to plan the query.
One of the tables has 550,485,9
