Query Doctor

Indexing Challenge #1: Find the most efficient way to retrieve the two records for the game "Dig Dug" that have a score between 10,000 and 12,000. "Most efficient" means "the fewest yellow nodes". Deleting records is cheating 🤓 Playground: app.querydoctor.com/ixr/share/ua... Good luck!

This @mattermost.bsky.social article is fascinating, row value comparisons are nifty! Interesting to see IndeX-Ray reveal the unbounded index scan. The other query correctly bounds the index scan to minimize it. mattermost.com/blog/making-... Playground: app.querydoctor.com/ixr/share/Zl...

Can the code underlining approach used by IDEs be applied to show indexing problems directly on SQL text? @simp.engineer thinks so! See how his latest work magically surfaces scan type details from query execution on the relevant clauses in the query itself: app.querydoctor.com/ixr/share/w3...

After 6 years of hoping someone else would write this, I've finally succumbed to the little marketing devil on my shoulder and written about Postgres query plan visualization tools. It's hard to imagine someone more biased about any topic, but here goes: www.pgmustard.com/blog/postgre...