explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5qgg

Settings
# exclusive inclusive rows x rows loops node
1. 0.251 5,515.974 ↑ 65.1 100 1

Subquery Scan on t (cost=314,087.78..314,722.44 rows=6,509 width=61) (actual time=5,513.588..5,515.974 rows=100 loops=1)

  • Filter: (t.dr <= 100)
  • Rows Removed by Filter: 3483
  • Planning time: 0.908 ms
  • Execution time: 5518.565 ms
2. 1.777 5,515.723 ↑ 5.5 3,583 1

WindowAgg (cost=314,087.78..314,478.34 rows=19,528 width=61) (actual time=5,513.582..5,515.723 rows=3,583 loops=1)

3. 4.951 5,513.946 ↑ 5.5 3,583 1

Sort (cost=314,087.78..314,136.60 rows=19,528 width=53) (actual time=5,513.569..5,513.946 rows=3,583 loops=1)

  • Sort Key: vbf.file_name, vbf.id
  • Sort Method: quicksort Memory: 485kB
4. 4.545 5,508.995 ↑ 5.5 3,583 1

Hash Join (cost=92,410.54..312,696.09 rows=19,528 width=53) (actual time=4,279.291..5,508.995 rows=3,583 loops=1)

  • Hash Cond: (vbe.version_bom_component_id = vbc.id)
5. 102.080 5,359.222 ↑ 5.5 3,583 1

Hash Join (cost=79,712.44..299,729.48 rows=19,528 width=46) (actual time=4,132.624..5,359.222 rows=3,583 loops=1)

  • Hash Cond: (vbe.version_bom_file_id = vbf.id)
6. 1,127.207 1,127.207 ↑ 1.1 310,901 1

Seq Scan on version_bom_entry vbe (cost=0.00..218,653.19 rows=329,861 width=33) (actual time=0.024..1,127.207 rows=310,901 loops=1)

  • Filter: (match_type = 'FILE_EXACT'::text)
  • Rows Removed by Filter: 1574132
7. 43.778 4,129.935 ↑ 1.0 72,226 1

Hash (cost=78,772.10..78,772.10 rows=75,227 width=21) (actual time=4,129.935..4,129.935 rows=72,226 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5114kB
8. 4,086.157 4,086.157 ↑ 1.0 72,226 1

Index Only Scan using idx_version_bom_file_only on version_bom_file vbf (cost=0.80..78,772.10 rows=75,227 width=21) (actual time=0.081..4,086.157 rows=72,226 loops=1)

  • Index Cond: (version_bom_id = 1125)
  • Heap Fetches: 25703
9. 59.642 145.228 ↑ 1.0 210,271 1

Hash (cost=10,069.71..10,069.71 rows=210,271 width=23) (actual time=145.228..145.228 rows=210,271 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 14213kB
10. 85.586 85.586 ↑ 1.0 210,271 1

Seq Scan on version_bom_component vbc (cost=0.00..10,069.71 rows=210,271 width=23) (actual time=0.049..85.586 rows=210,271 loops=1)