explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wnHk

Settings
# exclusive inclusive rows x rows loops node
1. 63.537 3,226.104 ↓ 11.0 11 1

GroupAggregate (cost=456,088.91..456,088.93 rows=1 width=24) (actual time=3,158.923..3,226.104 rows=11 loops=1)

  • Group Key: vb.release_id
2. 27.877 3,162.567 ↓ 40,512.0 40,512 1

Sort (cost=456,088.91..456,088.91 rows=1 width=48) (actual time=3,155.629..3,162.567 rows=40,512 loops=1)

  • Sort Key: vb.release_id
  • Sort Method: quicksort Memory: 4702kB
3. 17.901 3,134.690 ↓ 40,512.0 40,512 1

Hash Left Join (cost=36,543.31..456,088.90 rows=1 width=48) (actual time=370.391..3,134.690 rows=40,512 loops=1)

  • Hash Cond: (vbe.id = vbs.id)
  • Filter: (((vbs.review_status = 'REVIEWED'::text) AND (NOT vbs.ignored)) OR (vbs.id IS NULL))
4. 415.637 3,115.847 ↑ 1.1 40,512 1

Hash Right Join (cost=36,447.33..455,831.40 rows=43,010 width=56) (actual time=369.427..3,115.847 rows=40,512 loops=1)

  • Hash Cond: (vbe.version_bom_component_id = vbc.id)
5. 2,330.867 2,330.867 ↑ 1.0 2,781,639 1

Seq Scan on version_bom_entry vbe (cost=0.00..408,492.98 rows=2,789,598 width=16) (actual time=0.025..2,330.867 rows=2,781,639 loops=1)

6. 1.730 369.343 ↑ 1.7 3,023 1

Hash (cost=36,384.31..36,384.31 rows=5,041 width=56) (actual time=369.343..369.343 rows=3,023 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 324kB
7. 55.046 367.613 ↑ 1.7 3,023 1

Hash Right Join (cost=18,450.46..36,384.31 rows=5,041 width=56) (actual time=239.599..367.613 rows=3,023 loops=1)

  • Hash Cond: (vbc.version_bom_id = vb.id)
  • Filter: ((NOT vbc.ignored) OR (vbc.ignored IS NULL))
  • Rows Removed by Filter: 13
8. 73.047 73.047 ↑ 1.0 326,955 1

Seq Scan on version_bom_component vbc (cost=0.00..16,656.57 rows=326,957 width=49) (actual time=0.012..73.047 rows=326,955 loops=1)

9. 0.011 239.520 ↑ 2.8 11 1

Hash (cost=18,450.08..18,450.08 rows=31 width=24) (actual time=239.520..239.520 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.180 239.509 ↑ 2.8 11 1

Merge Semi Join (cost=18,240.19..18,450.08 rows=31 width=24) (actual time=238.654..239.509 rows=11 loops=1)

  • Merge Cond: (vb.release_id = vbc1.release_id)
11. 1.076 3.545 ↑ 1.6 1,240 1

Sort (cost=341.22..346.17 rows=1,980 width=24) (actual time=3.270..3.545 rows=1,240 loops=1)

  • Sort Key: vb.release_id
  • Sort Method: quicksort Memory: 171kB
12. 2.469 2.469 ↑ 1.3 1,568 1

Seq Scan on version_bom vb (cost=0.00..232.80 rows=1,980 width=24) (actual time=0.014..2.469 rows=1,568 loops=1)

13. 0.008 235.784 ↑ 2.8 11 1

Materialize (cost=17,898.98..18,098.82 rows=31 width=32) (actual time=235.355..235.784 rows=11 loops=1)

14. 0.156 235.776 ↑ 2.8 11 1

Merge Semi Join (cost=17,898.98..18,098.74 rows=31 width=32) (actual time=235.350..235.776 rows=11 loops=1)

  • Merge Cond: (vbc1.release_id = vb2.release_id)
15. 0.047 235.288 ↑ 15.0 11 1

Sort (cost=17,898.69..17,899.11 rows=165 width=16) (actual time=235.287..235.288 rows=11 loops=1)

  • Sort Key: vbc1.release_id
  • Sort Method: quicksort Memory: 25kB
16. 54.036 235.241 ↑ 15.0 11 1

Hash Join (cost=8.31..17,892.62 rows=165 width=16) (actual time=43.003..235.241 rows=11 loops=1)

  • Hash Cond: (vbc1.version_bom_id = vb1.id)
17. 181.186 181.186 ↑ 1.0 326,955 1

Seq Scan on version_bom_component vbc1 (cost=0.00..16,656.57 rows=326,957 width=24) (actual time=0.033..181.186 rows=326,955 loops=1)

18. 0.003 0.019 ↑ 1.0 1 1

Hash (cost=8.29..8.29 rows=1 width=8) (actual time=0.019..0.019 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.016 0.016 ↑ 1.0 1 1

Index Scan using version_bom_release_id_idx on version_bom vb1 (cost=0.28..8.29 rows=1 width=8) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: (release_id = 'ba33a539-3fa8-46ce-b808-2ccdd11886cf'::uuid)
20. 0.332 0.332 ↑ 1.6 1,239 1

Index Only Scan using version_bom_release_id_idx on version_bom vb2 (cost=0.28..193.97 rows=1,980 width=16) (actual time=0.043..0.332 rows=1,239 loops=1)

  • Heap Fetches: 61
21. 0.231 0.942 ↑ 1.0 1,155 1

Hash (cost=81.55..81.55 rows=1,155 width=22) (actual time=0.941..0.942 rows=1,155 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 77kB
22. 0.711 0.711 ↑ 1.0 1,155 1

Seq Scan on version_bom_snippet vbs (cost=0.00..81.55 rows=1,155 width=22) (actual time=0.014..0.711 rows=1,155 loops=1)

Planning time : 2.421 ms
Execution time : 3,227.469 ms