Video: Using a Query Plan to Improve DB Performance with a Simple Table Index

In this video, I show you how I fixed a query problem in Postgres be examining the a query plan provided by our DataDog monitoring tool. Simply adding a single column index to a table eliminates a sequential scan that iterates over 1.3M rows, increasing overall performance of the query without changing any code or SQL.