The Ghost in the Database: Why Is This Empty Table Taking 20 Seconds to Query?
SELECT * FROM my_table;
Query execution time: ~5 seconds
Table rows: 0
This made absolutely no sense.
A few years ago, I found myself staring at a performance metric that defied logic. We had a table that was, for all intents and purposes, empty. Yet...
devgeist.com7 min read