explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rbti

Settings
# exclusive inclusive rows x rows loops node
1. 5.089 4,556.935 ↑ 80.3 100 1

Subquery Scan on t (cost=374,562.32..375,345.15 rows=8,029 width=61) (actual time=4,491.250..4,556.935 rows=100 loops=1)

  • Filter: (t.dr <= 100)
  • Rows Removed by Filter: 72126
  • Planning time: 1.281 ms
  • Execution time: 4559.622 ms
2. 37.299 4,551.846 ↓ 3.0 72,226 1

WindowAgg (cost=374,562.32..375,044.06 rows=24,087 width=61) (actual time=4,491.242..4,551.846 rows=72,226 loops=1)

3. 103.988 4,514.547 ↓ 3.0 72,226 1

Sort (cost=374,562.32..374,622.54 rows=24,087 width=53) (actual time=4,491.212..4,514.547 rows=72,226 loops=1)

  • Sort Key: vbf.file_name, vbf.id
  • Sort Method: quicksort Memory: 12851kB
4. 552.206 4,410.559 ↓ 3.0 72,226 1

Hash Join (cost=231,257.10..372,809.27 rows=24,087 width=53) (actual time=1,837.749..4,410.559 rows=72,226 loops=1)

  • Hash Cond: (vbf.id = vbe.version_bom_file_id)
5. 2,029.186 2,029.186 ↑ 1.0 1,270,730 1

Seq Scan on version_bom_file vbf (cost=0.00..136,624.30 rows=1,270,730 width=21) (actual time=2.505..2,029.186 rows=1,270,730 loops=1)

6. 37.431 1,829.167 ↓ 3.0 72,226 1

Hash (cost=230,956.02..230,956.02 rows=24,087 width=40) (actual time=1,829.167..1,829.167 rows=72,226 loops=1)

  • Buckets: 131072 (originally 32768) Batches: 1 (originally 1) Memory Usage: 6506kB
7. 312.042 1,791.736 ↓ 3.0 73,043 1

Hash Join (cost=10,629.03..230,956.02 rows=24,087 width=40) (actual time=96.534..1,791.736 rows=73,043 loops=1)

  • Hash Cond: (vbe.version_bom_component_id = vbc.id)
8. 1,384.214 1,384.214 ↓ 1.0 1,885,033 1

Seq Scan on version_bom_entry vbe (cost=0.00..213,028.18 rows=1,882,118 width=33) (actual time=0.028..1,384.214 rows=1,885,033 loops=1)

9. 0.891 95.480 ↑ 1.0 2,623 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 176kB
10. 94.589 94.589 ↑ 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.145..94.589 rows=2,623 loops=1)

  • Filter: (version_bom_id = 1125)
  • Rows Removed by Filter: 207648