No, Autovacuum is running.
On 2019/04/08 16:18, Igor Neyman wrote:
>
> -----Original Message-----
> From: Krzysztof Plocharz [mailto:plocharz@9livesdata.com]
> Sent: Monday, April 08, 2019 10:11 AM
> To: pgsql-performance@lists.postgresql.org
> Subject: Planning performance problem (67626.278ms)
>
> Hi
>
> We have some very strange query planning problem. Long story short it takes 67626.278ms just to plan. Query execution
takes12ms.
>
> 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
problemonly temporarily.
>
> Question is how can we debug what is going on?
>
> Best Regards,
> Krzysztof Płocharz
>
> _______________________________________________________________________________________________
>
> Why do you have to run Analyze? Did you turn off Autovacuum?
>
> Regards,
> Igor Neyman
>
