The tests passed. The plan didn't.

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

TL;DR - RegreSQL 1.0 tested that your queries return the right rows. 2.0 tests that they return them the right way, and it does the checking against production's real statistics instead of your empty dev database, which lies. A migration cleanup dropped an index nobody thought was that important. Every test passed: same rows, same order, green. Three days later the API started timing out on a…

Read on boringsql.com ↗