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
devgeist.hashnode.dev8 min read