explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qz4x

Settings
# exclusive inclusive rows x rows loops node
1. 5.221 6,194.259 ↓ 1.1 100 1

Subquery Scan on t (cost=224,873.41..224,882.06 rows=89 width=61) (actual time=6,129.502..6,194.259 rows=100 loops=1)

  • Filter: (t.dr <= 100)
  • Rows Removed by Filter: 66826
2. 36.936 6,189.038 ↓ 251.6 66,926 1

WindowAgg (cost=224,873.41..224,878.73 rows=266 width=61) (actual time=6,129.494..6,189.038 rows=66,926 loops=1)

3. 102.929 6,152.102 ↓ 251.6 66,926 1

Sort (cost=224,873.41..224,874.08 rows=266 width=53) (actual time=6,129.474..6,152.102 rows=66,926 loops=1)

  • Sort Key: vbf.file_name, vbf.id
  • Sort Method: quicksort Memory: 12238kB
4. 34.794 6,049.173 ↓ 251.6 66,926 1

Nested Loop (cost=555.46..224,862.70 rows=266 width=53) (actual time=4.767..6,049.173 rows=66,926 loops=1)

5. 49.328 1,597.263 ↓ 251.6 66,926 1

Nested Loop (cost=555.03..222,821.78 rows=266 width=40) (actual time=4.738..1,597.263 rows=66,926 loops=1)

6. 105.645 1,347.157 ↓ 251.6 66,926 1

Hash Semi Join (cost=554.61..220,788.34 rows=266 width=33) (actual time=4.691..1,347.157 rows=66,926 loops=1)

  • Hash Cond: (vbe.code_location_id = cl_main_code_location.id)
7. 1,237.542 1,237.542 ↑ 1.0 589,805 1

Seq Scan on version_bom_entry vbe (cost=0.00..218,653.19 rows=600,985 width=49) (actual time=0.024..1,237.542 rows=589,805 loops=1)

  • Filter: (match_type = 'FILE_EXACT_FILE_MATCH'::text)
  • Rows Removed by Filter: 1295228
8. 0.007 3.970 ↓ 3.5 7 1

Hash (cost=554.59..554.59 rows=2 width=16) (actual time=3.970..3.970 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 3.963 3.963 ↓ 3.5 7 1

Seq Scan on cl_main_code_location (cost=0.00..554.59 rows=2 width=16) (actual time=0.509..3.963 rows=7 loops=1)

  • Filter: (release_id = '3e6d43b5-0a7e-4181-9bc5-c56f36b7a9be'::uuid)
  • Rows Removed by Filter: 9720
10. 200.778 200.778 ↑ 1.0 1 66,926

Index Scan using version_bom_component_pkey on version_bom_component vbc (cost=0.42..7.63 rows=1 width=23) (actual time=0.003..0.003 rows=1 loops=66,926)

  • Index Cond: (id = vbe.version_bom_component_id)
11. 4,417.116 4,417.116 ↑ 1.0 1 66,926

Index Scan using version_bom_file_pkey on version_bom_file vbf (cost=0.43..7.66 rows=1 width=21) (actual time=0.066..0.066 rows=1 loops=66,926)

  • Index Cond: (id = vbe.version_bom_file_id)