The query plan is only as good as the statistics behind it. When those statistics are wrong, the planner makes confident decisions based on a false reality.

We run a field technician dispatch system on PostgreSQL 14. The core query — find technicians matching specific dispatch criteria near a job site — ran in 3ms at 10am and 42ms at 2pm the same...