You have a table with a jsonb column but your query is slow when filtering by keys. What is the most likely cause?

medium📝 Debug Q14 of 15

PostgreSQL - JSON and JSONB

You have a table with a jsonb column but your query is slow when filtering by keys. What is the most likely cause?

ANo GIN or BTREE index on the <code>jsonb</code> column

BUsing <code>json</code> type instead of <code>jsonb</code>

CThe JSON data is stored as plain text

DThe query uses <code>LIKE</code> operator on the <code>jsonb</code> column

Step-by-Step Solution

Solution:

Step 1: Understand indexing for jsonb
jsonb supports GIN or BTREE indexes to speed up key/value lookups.
Step 2: Identify cause of slow queries
If no index exists on the jsonb column, queries filtering by keys must scan all rows, causing slowness.
Final Answer:
No GIN or BTREE index on the jsonb column -> Option A
Quick Check:
Missing index on jsonb = slow queries [OK]

Quick Trick: Add GIN index on jsonb for fast key lookups [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free