Re: Planning performance problem (67626.278ms)

2019-04-08 Thread Krzysztof Plocharz
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

Re: Planning performance problem (67626.278ms)

2019-04-08 Thread Krzysztof Plocharz
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

Re: Planning performance problem (67626.278ms)

2019-04-08 Thread Krzysztof Plocharz
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