1
vote
Inconsistent query planners between two Postgres 16.4 instances
I can't read Dalibo's plan obfuscator, but in the raw output we can see the difference.
Slow:
-> Index Scan using stations_pkey on stations s (cost=0.28..177.61 rows=14 width=347) (actual time=...
- 54.8k
1
vote
Sqlite fetching speed problem - how to understand explain and compare two queries
I would like to understand the different query plans and how to measure the execution speed and also the "math" reason why one query is faster then the other. Also what am i doing wrong?
I ...
- 904
Only top scored, non community-wiki answers of a minimum length are eligible