You've got two references to order_basketitemdetail both aliased to bid and
ALSO a table called order_basketitembatch aliased to bib. I assume that
confuses the planner, but even if it doesn't it certainly confuses any new
developers trying to understand the query's intention.
The biggest thing th
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
Sent: Monday, January 27, 2020 3:57 PM
To: pgsql-performance@lists.postgresql.org
Subject
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
Hello mail group members,
I started a new job as PostgreSQL DBA. This is my first mail, I hope the mail I
sent meets the rules.
There is a query that runs slowly when I look at the logs of the database. When
I check the resources of the system, there is no problem in the resources, but
this qu
