explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xdAj

Settings
# exclusive inclusive rows x rows loops node
1. 0.050 0.202 ↑ 50.0 2 1

Nested Loop (cost=0.15..136.92 rows=100 width=88) (actual time=0.101..0.202 rows=2 loops=1)

2. 0.018 0.018 ↑ 1.0 1 1

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

  • Index Cond: (entity_id = 'efdada9a-f25a-4135-9735-47cb5102632e'::uuid)
3. 0.026 0.026 ↑ 50.0 2 1

Function Scan on jsonb_each emoji (cost=0.00..1.00 rows=100 width=64) (actual time=0.014..0.026 rows=2 loops=1)

4.          

SubPlan (for Nested Loop)

5. 0.056 0.108 ↑ 1.0 1 2

Aggregate (cost=1.25..1.26 rows=1 width=8) (actual time=0.049..0.054 rows=1 loops=2)

6. 0.052 0.052 ↑ 25.0 4 2

Function Scan on jsonb_object_keys (cost=0.01..1.00 rows=100 width=0) (actual time=0.009..0.026 rows=4 loops=2)

Planning time : 1.385 ms
Execution time : 0.365 ms