explain.depesz.com

PostgreSQL's explain analyze made readable

Result: reXS

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.15..136.92 rows=100 width=88) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using reactions_spike_entity_id_uindex on reactions_spike r (cost=0.15..8.17 rows=1 width=48) (actual rows= loops=)

  • Index Cond: (entity_id = 'efdada9a-f25a-4135-9735-47cb5102632e'::uuid)
3. 0.000 0.000 ↓ 0.0

Function Scan on jsonb_each emoji (cost=0.00..1.00 rows=100 width=64) (actual rows= loops=)

4.          

SubPlan (for Nested Loop)

5. 0.000 0.000 ↓ 0.0

Aggregate (cost=1.25..1.26 rows=1 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Function Scan on jsonb_object_keys (cost=0.01..1.00 rows=100 width=0) (actual rows= loops=)