Cheat Sheet logoCheat Sheet Today
PostgreSQL Cheat Sheet/Create partial index

Index only a subset of rows.

Back to sheetBrowse commands
Sign in to save
Section: Indexes and Constraints

Create partial index

sql
sql
CREATE INDEX idx_orders_open_only ON orders (created_at) WHERE status = 'open';
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

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

Compare commandsView fixes

Related commands

Same sheet · prioritizing Indexes and Constraints
Create index
Add a basic B-tree index to speed lookups.
OpenIn sheetsqlsame section
Create index concurrently
Build an index with reduced write blocking.
OpenIn sheetsqlsame section
Create unique index
Enforce uniqueness with an index.
OpenIn sheetsqlsame section
Create expression index
Index an expression for case-insensitive lookups.
OpenIn sheetsqlsame section
Create GIN index on JSONB
Accelerate JSONB containment queries.
OpenIn sheetsqlsame section
Drop index
Remove an index that is no longer needed.
OpenIn sheetsqlsame section