Three bugs that made our time-series queries 680 slower (and how we found them)

A SELECT ... ORDER BY ts DESC LIMIT 10 on a 1M-row table took 1.2 seconds. It should have taken...