Re: Query optimization advice for beginners

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Query optimization advice for beginners
From: Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx>
Date: Mon, 27 Jan 2020 14:57:11 +0100
In-reply-to: <AM0PR03MB4211FF22D3D161031EAC359AF80B0@AM0PR03MB4211.eurprd03.prod.outlook.com>
References: <AM0PR03MB4211FF22D3D161031EAC359AF80B0@AM0PR03MB4211.eurprd03.prod.outlook.com>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.4.1



Am 27.01.20 um 14:15 schrieb Kemal Ortanca:


https://explain.depesz.com/s/G4vq

the estimates and the real values are very different, seems likeproblems with autoanalyze.


which version?



Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

Follow-Ups:
- Re: Query optimization advice for beginners
  - From: Kemal Ortanca

References:
- Query optimization advice for beginners
  - From: Kemal Ortanca

Prev by Date: Query optimization advice for beginners
Next by Date: Re: Query optimization advice for beginners
Previous by thread: Query optimization advice for beginners
Next by thread: Re: Query optimization advice for beginners
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux