explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JjaT

Settings
# exclusive inclusive rows x rows loops node
1. 367.309 73,301.794 ↓ 93,543.0 93,543 1

Nested Loop Left Join (cost=2.69..33,165.26 rows=1 width=432) (actual time=3.649..73,301.794 rows=93,543 loops=1)

2. 424.784 67,696.077 ↓ 93,543.0 93,543 1

Nested Loop Left Join (cost=2.12..33,156.66 rows=1 width=432) (actual time=3.515..67,696.077 rows=93,543 loops=1)

3. 30,067.086 63,155.401 ↓ 93,543.0 93,543 1

Nested Loop Left Join (cost=1.56..33,148.08 rows=1 width=424) (actual time=3.442..63,155.401 rows=93,543 loops=1)

  • Join Filter: (vbs.id = vbe.id)
  • Rows Removed by Join Filter: 151726746
4. 289.317 5,118.958 ↓ 93,543.0 93,543 1

Nested Loop (cost=1.56..33,045.59 rows=1 width=403) (actual time=0.833..5,118.958 rows=93,543 loops=1)

  • Join Filter: (vbf.version_bom_id = vbc.version_bom_id)
5. 208.102 3,613.582 ↓ 56.0 93,543 1

Nested Loop (cost=1.13..18,953.90 rows=1,669 width=405) (actual time=0.772..3,613.582 rows=93,543 loops=1)

6. 109.915 1,160.448 ↓ 84.1 93,543 1

Nested Loop (cost=0.71..9,560.79 rows=1,112 width=361) (actual time=0.629..1,160.448 rows=93,543 loops=1)

7. 0.030 0.030 ↑ 1.0 1 1

Index Scan using version_bom_release_id_idx on version_bom vb (cost=0.28..8.29 rows=1 width=8) (actual time=0.026..0.030 rows=1 loops=1)

  • Index Cond: (release_id = '3e6d43b5-0a7e-4181-9bc5-c56f36b7a9be'::uuid)
8. 1,050.503 1,050.503 ↓ 32.9 93,543 1

Index Scan using idx_version_bom_file_version_bom_id on version_bom_file vbf (cost=0.43..9,524.10 rows=2,839 width=353) (actual time=0.598..1,050.503 rows=93,543 loops=1)

  • Index Cond: (version_bom_id = vb.id)
9. 2,245.032 2,245.032 ↑ 1.0 1 93,543

Index Scan using idx_version_bom_entry_version_bom_file_id on version_bom_entry vbe (cost=0.43..8.44 rows=1 width=60) (actual time=0.023..0.024 rows=1 loops=93,543)

  • Index Cond: (version_bom_file_id = vbf.id)
10. 1,216.059 1,216.059 ↑ 1.0 1 93,543

Index Scan using version_bom_component_pkey on version_bom_component vbc (cost=0.42..8.43 rows=1 width=38) (actual time=0.012..0.013 rows=1 loops=93,543)

  • Index Cond: (id = vbe.version_bom_component_id)
11. 27,969.357 27,969.357 ↑ 1.0 1,622 93,543

Seq Scan on version_bom_snippet vbs (cost=0.00..82.22 rows=1,622 width=37) (actual time=0.003..0.299 rows=1,622 loops=93,543)

12. 4,115.892 4,115.892 ↓ 0.0 0 93,543

Index Scan using scan_composite_element_pkey on scan_composite_element sce (cost=0.56..8.57 rows=1 width=32) (actual time=0.044..0.044 rows=0 loops=93,543)

  • Index Cond: ((vbf.composite_id = id) AND (vbf.scan_id = scan_id))
13. 5,238.408 5,238.408 ↑ 1.0 1 93,543

Index Scan using scan_composite_leaf_pkey on scan_composite_leaf scl (cost=0.57..8.58 rows=1 width=50) (actual time=0.056..0.056 rows=1 loops=93,543)

  • Index Cond: ((vbf.composite_id = id) AND (vbf.scan_id = scan_id))
Planning time : 13.254 ms
Execution time : 73,341.308 ms