Finding the Missing Indexes Your Queries Are Begging For

PostgreSQL will not tell you when an index is missing. It will dutifully execute a sequential scan across 50 million rows, return the correct result in 3.2 seconds, and move on. No error. No warning. Just a query that could run in 5 milliseconds taki...