| From: | Kemal Ortanca <kemal(dot)ortanca(at)outlook(dot)com> |
|---|---|
| To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
| Cc: | "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Query optimization advice for beginners |
| Date: | 2020-01-27 15:33:29 |
| Message-ID: | AM0PR03MB4211A876D473A21406ECBE6EF80B0@AM0PR03MB4211.eurprd03.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)a-kretschmer(dot)de>
Sent: Monday, January 27, 2020 3:57 PM
To: pgsql-performance(at)lists(dot)postgresql(dot)org <pgsql-performance(at)lists(dot)postgresql(dot)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<http://www.2ndQuadrant.com>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Lewis | 2020-01-27 16:46:18 | Re: Query optimization advice for beginners |
| Previous Message | Andreas Kretschmer | 2020-01-27 13:57:11 | Re: Query optimization advice for beginners |