Oh, I'm not generally correct, but my process of "writing" generally goes: - Guess what I think is going to happen - EXPLAIN ANALYZE - Ohhh, it did [

Oh, I'm not generally correct, but my process of "writing" generally goes: - Guess what I think is going to happen - EXPLAIN ANALYZE - Ohhh, it did [thing]. Lemme tweak if I can convince it to do [other thing] that should work better - <Repeat> I'd argue testing against the DB is a core part of the process for writing a query.