PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE

PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE I was profiling a dashboard that loaded in 3 seconds. The main query filtered by customer_id and selected customer_name, email, and last_order_date. PostgreSQL found 2,000 matching rows...