explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bn47

Settings
# exclusive inclusive rows x rows loops node
1. 1.333 3,017.686 ↑ 7.4 100 1

Subquery Scan on t (cost=118,561.23..118,633.67 rows=743 width=61) (actual time=3,002.370..3,017.686 rows=100 loops=1)

  • Filter: (t.dr <= 100)
  • Rows Removed by Filter: 18357
  • Planning time: 1.399 ms
  • Execution time: 3018.251 ms
2. 9.354 3,016.353 ↓ 8.3 18,457 1

WindowAgg (cost=118,561.23..118,605.81 rows=2,229 width=61) (actual time=3,002.364..3,016.353 rows=18,457 loops=1)

3.          

Initplan (forWindowAgg)

4. 0.023 0.023 ↑ 1.0 1 1

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

  • Index Cond: (release_id = '0bed55c0-6eac-45f0-9992-40745ebe2fbe'::uuid)
5. 33.462 3,006.976 ↓ 8.3 18,457 1

Sort (cost=118,552.93..118,558.51 rows=2,229 width=53) (actual time=3,002.355..3,006.976 rows=18,457 loops=1)

  • Sort Key: vbf.file_name, vbf.id
  • Sort Method: quicksort Memory: 3150kB
6. 30.280 2,973.514 ↓ 8.3 18,457 1

Nested Loop (cost=0.85..118,428.98 rows=2,229 width=53) (actual time=16.478..2,973.514 rows=18,457 loops=1)

7. 7.165 335.454 ↓ 8.4 18,627 1

Nested Loop (cost=0.43..101,335.83 rows=2,229 width=40) (actual time=8.749..335.454 rows=18,627 loops=1)

8. 89.231 89.231 ↓ 1.9 466 1

Seq Scan on version_bom_component vbc (cost=0.00..10,595.39 rows=249 width=23) (actual time=4.564..89.231 rows=466 loops=1)

  • Filter: (version_bom_id = $0)
  • Rows Removed by Filter: 209805
9. 239.058 239.058 ↑ 2.5 40 466

Index Scan using idx_version_bom_entry_version_bom_component_id on version_bom_entry vbe (cost=0.43..363.44 rows=98 width=33) (actual time=0.196..0.513 rows=40 loops=466)

  • Index Cond: (version_bom_component_id = vbc.id)
10. 2,607.780 2,607.780 ↑ 1.0 1 18,627

Index Scan using version_bom_file_pkey on version_bom_file vbf (cost=0.43..7.66 rows=1 width=21) (actual time=0.140..0.140 rows=1 loops=18,627)

  • Index Cond: (id = vbe.version_bom_file_id)