explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OMWr

Settings
# exclusive inclusive rows x rows loops node
1. 5.252 4,140.865 ↑ 7.4 100 1

Subquery Scan on t (cost=118,561.23..118,633.67 rows=743 width=61) (actual time=4,069.796..4,140.865 rows=100 loops=1)

  • Filter: (t.dr <= 100)
  • Rows Removed by Filter: 72126
  • Planning time: 1.246 ms
  • Execution time: 4142.945 ms
2. 37.871 4,135.613 ↓ 32.4 72,226 1

WindowAgg (cost=118,561.23..118,605.81 rows=2,229 width=61) (actual time=4,069.787..4,135.613 rows=72,226 loops=1)

3.          

Initplan (forWindowAgg)

4. 0.031 0.031 ↑ 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.031..0.031 rows=1 loops=1)

  • Index Cond: (release_id = '3e6d43b5-0a7e-4181-9bc5-c56f36b7a9be'::uuid)
5. 113.511 4,097.711 ↓ 32.4 72,226 1

Sort (cost=118,552.93..118,558.51 rows=2,229 width=53) (actual time=4,069.753..4,097.711 rows=72,226 loops=1)

  • Sort Key: vbf.file_name, vbf.id
  • Sort Method: quicksort Memory: 12851kB
6. 75.306 3,984.200 ↓ 32.4 72,226 1

Nested Loop (cost=0.85..118,428.98 rows=2,229 width=53) (actual time=1.416..3,984.200 rows=72,226 loops=1)

7. 21.935 987.174 ↓ 32.8 73,043 1

Nested Loop (cost=0.43..101,335.83 rows=2,229 width=40) (actual time=1.380..987.174 rows=73,043 loops=1)

8. 83.911 83.911 ↓ 10.5 2,623 1

Seq Scan on version_bom_component vbc (cost=0.00..10,595.39 rows=249 width=23) (actual time=0.159..83.911 rows=2,623 loops=1)

  • Filter: (version_bom_id = $0)
  • Rows Removed by Filter: 207648
9. 881.328 881.328 ↑ 3.5 28 2,623

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.036..0.336 rows=28 loops=2,623)

  • Index Cond: (version_bom_component_id = vbc.id)
10. 2,921.720 2,921.720 ↑ 1.0 1 73,043

Index Scan using version_bom_file_pkey on version_bom_file vbf (cost=0.43..7.66 rows=1 width=21) (actual time=0.040..0.040 rows=1 loops=73,043)

  • Index Cond: (id = vbe.version_bom_file_id)