1 Minute SQL Tips with WoWSQL — 28 May 2026

1 Minute PostgreSQL Tip: Indexing JSONB for Faster Lookups 🚀

Ever struggled with slow queries on your JSONB columns? You're not alone. Many developers treat JSONB like a giant string, forgetting the power of indexing.

Problem: Imagine you have a users table with a profile column storing JSON data like {"city": "London", "interests": ["coding", "music"]}. A query like SELECT * FROM users WHERE profile ->> 'city' = 'London'; can be slow without an index, especially as your table grows.

Solution: PostgreSQL lets you create indexes specifically for JSONB columns! We can use expression indexes to target specific keys within the JSON data.

CREATE INDEX idx_users_profile_city ON users ((profile ->> 'city'));