explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WndB

Settings
# exclusive inclusive rows x rows loops node
1. 4,010.029 4,121.878 ↓ 12.4 9,486 1

Result (cost=781.76..2,701.31 rows=764 width=510) (actual time=110.560..4,121.878 rows=9,486 loops=1)

2. 30.915 111.849 ↓ 12.4 9,486 1

Sort (cost=781.76..783.67 rows=764 width=190) (actual time=108.549..111.849 rows=9,486 loops=1)

  • Sort Key: e.value
  • Sort Method: quicksort Memory: 2850kB
3. 10.783 80.934 ↓ 12.4 9,486 1

Hash Left Join (cost=25.67..745.17 rows=764 width=190) (actual time=0.603..80.934 rows=9,486 loops=1)

  • Hash Cond: (e.c_element_id = ace.c_element_id)
4. 10.319 69.957 ↓ 12.4 9,486 1

Hash Join (cost=18.07..723.36 rows=764 width=152) (actual time=0.387..69.957 rows=9,486 loops=1)

  • Hash Cond: (e.c_element_id = el.c_element_id)
5. 14.769 59.571 ↓ 12.4 9,486 1

Nested Loop (cost=16.30..719.30 rows=764 width=152) (actual time=0.299..59.571 rows=9,486 loops=1)

6. 11.967 16.269 ↓ 11.6 9,511 1

Hash Join (cost=16.01..397.15 rows=818 width=55) (actual time=0.281..16.269 rows=9,511 loops=1)

  • Hash Cond: (t.ad_tree_id = tree.ad_tree_id)
7. 4.054 4.054 ↓ 1.0 11,870 1

Seq Scan on ad_treenode t (cost=0.00..349.69 rows=11,869 width=55) (actual time=0.013..4.054 rows=11,870 loops=1)

8. 0.027 0.248 ↓ 1.0 32 1

Hash (cost=15.62..15.62 rows=31 width=6) (actual time=0.248..0.248 rows=32 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
9. 0.221 0.221 ↓ 1.0 32 1

Seq Scan on ad_tree tree (cost=0.00..15.62 rows=31 width=6) (actual time=0.003..0.221 rows=32 loops=1)

  • Filter: (treetype = 'EV'::bpchar)
  • Rows Removed by Filter: 418
10. 28.533 28.533 ↑ 1.0 1 9,511

Index Scan using c_elementvalue_pkey on c_elementvalue e (cost=0.29..0.39 rows=1 width=97) (actual time=0.003..0.003 rows=1 loops=9,511)

  • Index Cond: (c_elementvalue_id = t.node_id)
11. 0.039 0.067 ↑ 1.0 31 1

Hash (cost=1.39..1.39 rows=31 width=6) (actual time=0.067..0.067 rows=31 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
12. 0.028 0.028 ↑ 1.0 31 1

Seq Scan on c_element el (cost=0.00..1.39 rows=31 width=6) (actual time=0.006..0.028 rows=31 loops=1)

  • Filter: (elementtype = 'A'::bpchar)
13. 0.084 0.194 ↑ 5.3 30 1

Hash (cost=5.60..5.60 rows=160 width=12) (actual time=0.194..0.194 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
14. 0.110 0.110 ↑ 1.0 160 1

Seq Scan on c_acctschema_element ace (cost=0.00..5.60 rows=160 width=12) (actual time=0.004..0.110 rows=160 loops=1)