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
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
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
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
