explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QMAQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.239 1,389.858 ↑ 14.1 100 1

Subquery Scan on t (cost=221,997.51..222,134.70 rows=1,407 width=61) (actual time=1,387.371..1,389.858 rows=100 loops=1)

  • Filter: (t.dr <= 100)
  • Rows Removed by Filter: 3483
  • Planning time: 0.980 ms
  • Execution time: 1390.034 ms
2. 1.842 1,389.619 ↑ 1.2 3,583 1

WindowAgg (cost=221,997.51..222,081.93 rows=4,221 width=61) (actual time=1,387.366..1,389.619 rows=3,583 loops=1)

3. 7.011 1,387.777 ↑ 1.2 3,583 1

Sort (cost=221,997.51..222,008.07 rows=4,221 width=53) (actual time=1,387.344..1,387.777 rows=3,583 loops=1)

  • Sort Key: vbf.file_name, vbf.id
  • Sort Method: quicksort Memory: 485kB
4. 3.950 1,380.766 ↑ 1.2 3,583 1

Nested Loop (cost=0.98..221,743.34 rows=4,221 width=53) (actual time=0.335..1,380.766 rows=3,583 loops=1)

5. 3.864 452.402 ↑ 1.2 3,583 1

Nested Loop (cost=0.55..189,346.30 rows=4,221 width=40) (actual time=0.234..452.402 rows=3,583 loops=1)

6. 91.810 91.810 ↑ 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.162..91.810 rows=2,623 loops=1)

  • Filter: (version_bom_id = 1125)
  • Rows Removed by Filter: 207648
7. 356.728 356.728 ↑ 17.0 1 2,623

Index Scan using version_bom_match_type_idx on version_bom_entry vbe (cost=0.55..66.26 rows=17 width=33) (actual time=0.122..0.136 rows=1 loops=2,623)

  • Index Cond: ((version_bom_component_id = vbc.id) AND (match_type = 'FILE_EXACT'::text))
8. 924.414 924.414 ↑ 1.0 1 3,583

Index Scan using version_bom_file_pkey on version_bom_file vbf (cost=0.43..7.67 rows=1 width=21) (actual time=0.258..0.258 rows=1 loops=3,583)

  • Index Cond: (id = vbe.version_bom_file_id)