explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jODf

Settings
# exclusive inclusive rows x rows loops node
1. 2.158 299,960.729 ↑ 1.0 1 1

Aggregate (cost=1,823.34..1,823.35 rows=1 width=72) (actual time=299,960.728..299,960.729 rows=1 loops=1)

2. 6.614 299,958.571 ↓ 820.0 820 1

Nested Loop (cost=2.38..1,823.34 rows=1 width=35) (actual time=184.023..299,958.571 rows=820 loops=1)

3. 8.216 127,455.545 ↓ 1,518.0 1,518 1

Nested Loop (cost=1.68..1,812.77 rows=1 width=51) (actual time=48.792..127,455.545 rows=1,518 loops=1)

4. 3.147 44,563.011 ↓ 1,518.0 1,518 1

Nested Loop (cost=1.12..1,809.37 rows=1 width=43) (actual time=48.413..44,563.011 rows=1,518 loops=1)

5. 47.037 47.037 ↑ 1.0 1 1

Index Scan using store_id on alf_node pa (cost=0.56..8.58 rows=1 width=8) (actual time=47.034..47.037 rows=1 loops=1)

  • Index Cond: ((store_id = 6) AND ((uuid)::text = 'ecbd44bc-3bcd-47b6-b092-f4fccdd809ee'::text))
6. 44,512.827 44,512.827 ↓ 3.1 1,518 1

Index Scan using parent_node_id on alf_child_assoc a (cost=0.56..1,795.94 rows=485 width=51) (actual time=1.371..44,512.827 rows=1,518 loops=1)

  • Index Cond: ((parent_node_id = pa.id) AND (type_qname_id = 33))
7. 82,884.318 82,884.318 ↑ 1.0 1 1,518

Index Only Scan using alf_node_pkey on alf_node ch (cost=0.56..3.40 rows=1 width=8) (actual time=53.049..54.601 rows=1 loops=1,518)

  • Index Cond: (id = a.child_node_id)
  • Heap Fetches: 1829
8. 172,496.412 172,496.412 ↑ 96.0 1 1,518

Index Only Scan using alf_node_properties_pkey on alf_node_properties p (cost=0.70..9.60 rows=96 width=8) (actual time=113.632..113.634 rows=1 loops=1,518)

  • Index Cond: ((node_id = ch.id) AND (qname_id = 51))
  • Heap Fetches: 820