Postgres Pro
Downloads
Home   >   mailing lists

Re: Query optimization advice for beginners - Mailing list pgsql-performance

From Kemal Ortanca
Subject Re: Query optimization advice for beginners
Date
Msg-id AM0PR03MB4211A876D473A21406ECBE6EF80B0@AM0PR03MB4211.eurprd03.prod.outlook.com
Whole thread Raw
In response to Re: Query optimization advice for beginners  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-performance
Tree view
Firstly, thank you for coming back.

PostgreSQL version = 11.5

Is there a resource or postgresql configuration you want me to check in addition?


From: Andreas Kretschmer <andreas@a-kretschmer.de>
Sent: Monday, January 27, 2020 3:57 PM
To: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org>
Subject: Re: Query optimization advice for beginners
 


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 like
problems with autoanalyze.

which version?



Andreas

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



pgsql-performance by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Query optimization advice for beginners
Next
From: Michael Lewis
Date:
Subject: Re: Query optimization advice for beginners