GIN index on JSONB

sql

CREATE INDEX idx_events_payload_gin ON events USING GIN (payload jsonb_path_ops);

Explanation

GIN is often used for composite or document-like structures such as JSONB and arrays.

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 PostgreSQL index types

Default choice for equality, ranges, and ordering.

Open In sheetsqlsame section

Use BRIN when physical order correlates with query ranges.

Open In sheetsqlsame section

Index the result of an expression used in predicates.

Open In sheetsqlsame section

Index only the rows a hot query actually needs.

Open In sheetsqlsame section

Reduce blocking on busy tables.

Open In sheetsqlsame section

Inspect actual execution behavior.

Open In sheetsql1 tag match