explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r4rj

Settings
# exclusive inclusive rows x rows loops node
1. 4.556 6,573.584 ↑ 25.6 100 1

Subquery Scan on t (cost=291,111.14..291,361.10 rows=2,564 width=61) (actual time=6,513.605..6,573.584 rows=100 loops=1)

  • Filter: (t.dr <= 100)
  • Rows Removed by Filter: 66826
2. 33.257 6,569.028 ↓ 8.7 66,926 1

WindowAgg (cost=291,111.14..291,264.96 rows=7,691 width=61) (actual time=6,513.598..6,569.028 rows=66,926 loops=1)

3. 102.124 6,535.771 ↓ 8.7 66,926 1

Sort (cost=291,111.14..291,130.37 rows=7,691 width=53) (actual time=6,513.586..6,535.771 rows=66,926 loops=1)

  • Sort Key: vbf.file_name, vbf.id
  • Sort Method: quicksort Memory: 12238kB
4. 61.143 6,433.647 ↓ 8.7 66,926 1

Nested Loop (cost=10,629.45..290,614.73 rows=7,691 width=53) (actual time=72.271..6,433.647 rows=66,926 loops=1)

5. 96.195 1,486.906 ↓ 8.7 66,926 1

Hash Join (cost=10,629.03..231,612.82 rows=7,691 width=40) (actual time=72.224..1,486.906 rows=66,926 loops=1)

  • Hash Cond: (vbe.version_bom_component_id = vbc.id)
6. 1,319.278 1,319.278 ↑ 1.0 589,805 1

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

  • Filter: (match_type = 'FILE_EXACT_FILE_MATCH'::text)
  • Rows Removed by Filter: 1295228
7. 0.705 71.433 ↑ 1.0 2,623 1

Hash (cost=10,595.39..10,595.39 rows=2,691 width=23) (actual time=71.433..71.433 rows=2,623 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 176kB
8. 70.728 70.728 ↑ 1.0 2,623 1

Seq Scan on version_bom_component vbc (cost=0.00..10,595.39 rows=2,691 width=23) (actual time=0.092..70.728 rows=2,623 loops=1)

  • Filter: (version_bom_id = 1125)
  • Rows Removed by Filter: 207648
9. 4,885.598 4,885.598 ↑ 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.072..0.073 rows=1 loops=66,926)

  • Index Cond: (id = vbe.version_bom_file_id)
Planning time : 0.897 ms
Execution time : 6,575.203 ms