Planning performance problem (67626.278ms)

From: Krzysztof Plocharz <plocharz(at)9livesdata(dot)com>
To: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Planning performance problem (67626.278ms)
Date: 2019-04-08 14:10:52
Message-ID: 6d58f68e-ed1a-c48e-1440-691554f6e1e7@9livesdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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,942 live tuples and 743,504,012 dead
tuples. Running ANALYZE on that tables solves the problem only temporarily.

Question is how can we debug what is going on?

Best Regards,
Krzysztof Płocharz

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Igor Neyman 2019-04-08 14:18:11 RE: Planning performance problem (67626.278ms)
Previous Message Rick Otten 2019-04-08 12:24:39 Re: Oracle to postgres migration