explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y8oS

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 10,045.049 ↓ 50.0 100 1

Limit (cost=34,085.19..34,085.19 rows=2 width=375) (actual time=10,045.023..10,045.049 rows=100 loops=1)

  • Planning time: 11.668 ms
  • Execution time: 10046.936 ms
2. 51.863 10,045.037 ↓ 50.0 100 1

Sort (cost=34,085.19..34,085.19 rows=2 width=375) (actual time=10,045.021..10,045.037 rows=100 loops=1)

  • Sort Key: vbf.file_name
  • Sort Method: top-N heapsort Memory: 76kB
3. 64.843 9,993.174 ↓ 36,113.0 72,226 1

Hash Join (cost=13,211.95..34,085.18 rows=2 width=375) (actual time=173.143..9,993.174 rows=72,226 loops=1)

  • Hash Cond: ((vbf.version_bom_id = vbc.version_bom_id) AND (vbe.version_bom_component_id = vbc.id))
4. 36.032 9,757.035 ↓ 35.3 72,226 1

Nested Loop (cost=0.85..20,858.67 rows=2,048 width=378) (actual time=0.223..9,757.035 rows=72,226 loops=1)

5. 29.974 9,143.195 ↓ 54.1 72,226 1

Nested Loop (cost=0.43..10,604.81 rows=1,336 width=343) (actual time=0.185..9,143.195 rows=72,226 loops=1)

6. 0.241 0.241 ↑ 1.0 1 1

Seq Scan on version_bom vb (cost=0.00..35.94 rows=1 width=8) (actual time=0.135..0.241 rows=1 loops=1)

  • Filter: (release_id = '3e6d43b5-0a7e-4181-9bc5-c56f36b7a9be'::uuid)
  • Rows Removed by Filter: 954
7. 9,112.980 9,112.980 ↓ 24.4 72,226 1

Index Scan using idx_version_bom_file_version_bom_id on version_bom_file vbf (cost=0.43..10,539.28 rows=2,959 width=335) (actual time=0.043..9,112.980 rows=72,226 loops=1)

  • Index Cond: (version_bom_id = vb.id)
8. 577.808 577.808 ↑ 1.0 1 72,226

Index Scan using idx_version_bom_entry_version_bom_file_id on version_bom_entry vbe (cost=0.43..7.67 rows=1 width=51) (actual time=0.007..0.008 rows=1 loops=72,226)

  • Index Cond: (version_bom_file_id = vbf.id)
9. 78.841 171.296 ↓ 1.0 210,149 1

Hash (cost=10,064.64..10,064.64 rows=209,764 width=37) (actual time=171.296..171.296 rows=210,149 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 17268kB
10. 92.455 92.455 ↓ 1.0 210,149 1

Seq Scan on version_bom_component vbc (cost=0.00..10,064.64 rows=209,764 width=37) (actual time=0.022..92.455 rows=210,149 loops=1)