explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rar1

Settings
# exclusive inclusive rows x rows loops node
1. 367.682 4,267.524 ↑ 1.4 35,876 1

Hash Anti Join (cost=482,596.05..887,756.17 rows=51,412 width=81) (actual time=3,182.359..4,267.524 rows=35,876 loops=1)

  • Hash Cond: (("*SELECT* 1".id = vbf_1.composite_id) AND ("*SELECT* 1".scan_id = vbf_1.scan_id))
2. 419.081 2,325.635 ↑ 1.9 36,483 1

Hash Anti Join (cost=241,375.70..618,412.69 rows=68,550 width=105) (actual time=1,605.183..2,325.635 rows=36,483 loops=1)

  • Hash Cond: (("*SELECT* 1".root_bom_consumer_node_id = vbf.composite_id) AND ("*SELECT* 1".scan_id = vbf.scan_id))
3. 13.004 306.621 ↓ 1.8 160,391 1

Append (cost=155.35..343,273.71 rows=91,400 width=113) (actual time=2.045..306.621 rows=160,391 loops=1)

4. 1.632 35.396 ↓ 2.2 14,516 1

Subquery Scan on *SELECT* 1 (cost=155.35..25,202.29 rows=6,550 width=76) (actual time=2.045..35.396 rows=14,516 loops=1)

5. 31.995 33.764 ↓ 2.2 14,516 1

Bitmap Heap Scan on scan_composite_element sce (cost=155.35..25,136.79 rows=6,550 width=261) (actual time=2.044..33.764 rows=14,516 loops=1)

  • Recheck Cond: (scan_id = '6aba20de-818e-4e18-aff7-bdc0614177af'::uuid)
  • Filter: (type <> 3)
  • Heap Blocks: exact=1962
6. 1.769 1.769 ↓ 2.2 14,516 1

Bitmap Index Scan on scan_id_idx (cost=0.00..153.72 rows=6,554 width=0) (actual time=1.769..1.769 rows=14,516 loops=1)

  • Index Cond: (scan_id = '6aba20de-818e-4e18-aff7-bdc0614177af'::uuid)
7. 16.019 258.221 ↓ 1.7 145,875 1

Subquery Scan on *SELECT* 2 (cost=1,970.16..318,071.42 rows=84,850 width=116) (actual time=19.718..258.221 rows=145,875 loops=1)

8. 225.417 242.202 ↓ 1.7 145,875 1

Bitmap Heap Scan on scan_composite_leaf scl (cost=1,970.16..317,222.92 rows=84,850 width=301) (actual time=19.716..242.202 rows=145,875 loops=1)

  • Recheck Cond: (scan_id = '6aba20de-818e-4e18-aff7-bdc0614177af'::uuid)
  • Heap Blocks: exact=15143
9. 16.785 16.785 ↓ 1.7 145,875 1

Bitmap Index Scan on scan_id_leaf_idx (cost=0.00..1,948.94 rows=84,850 width=0) (actual time=16.785..16.785 rows=145,875 loops=1)

  • Index Cond: (scan_id = '6aba20de-818e-4e18-aff7-bdc0614177af'::uuid)
10. 529.063 1,599.933 ↑ 1.0 1,842,503 1

Hash (cost=201,119.14..201,119.14 rows=1,922,414 width=24) (actual time=1,599.933..1,599.933 rows=1,842,503 loops=1)

  • Buckets: 524288 Batches: 4 Memory Usage: 29277kB
11. 1,070.870 1,070.870 ↑ 1.0 1,842,503 1

Seq Scan on version_bom_file vbf (cost=0.00..201,119.14 rows=1,922,414 width=24) (actual time=0.033..1,070.870 rows=1,842,503 loops=1)

12. 523.931 1,574.207 ↑ 1.0 1,842,503 1

Hash (cost=201,119.14..201,119.14 rows=1,922,414 width=24) (actual time=1,574.207..1,574.207 rows=1,842,503 loops=1)

  • Buckets: 524288 Batches: 4 Memory Usage: 29277kB
13. 1,050.276 1,050.276 ↑ 1.0 1,842,503 1

Seq Scan on version_bom_file vbf_1 (cost=0.00..201,119.14 rows=1,922,414 width=24) (actual time=0.024..1,050.276 rows=1,842,503 loops=1)

Planning time : 0.767 ms
Execution time : 4,274.865 ms