PostgreSQL covering index with INCLUDE

sql

CREATE INDEX idx_orders_status_created_at_inc ON orders (status, created_at DESC) INCLUDE (total_amount, user_id);

Explanation

`INCLUDE` can help PostgreSQL serve some queries directly from the index when conditions are right.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Create index patterns

Index a common lookup column.

Open In sheetsqlsame section

Index fields that are commonly used together.

Open In sheetsqlsame section

Put equality columns first in many B-tree cases.

Open In sheetsqlsame section

Query only indexed columns when possible.

Open In sheetsql1 tag match

Avoid expensive sorts when possible.