Greetings,
I have several similar queries that are all suffering from a dramatic slow down
after upgrading a RDS instance from 9.3 to 10.3. The query time goes from 28
milliseconds to over 70 seconds I could use some help trying to figure out the
problem. This is one of the queries:
SELECT
Have you run an analyze on all your tables after the upgrade to 10? The
estimates are way off.
> Have you run an analyze on all your tables after the upgrade to 10? The
> estimates are way off.
Thank you. I embarrassingly missed that step. That fixed the problem. In the
future, if estimates are way off… I’ll run analyze.
