explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XhxY

Settings
# exclusive inclusive rows x rows loops node
1. 69.642 8,127.824 ↓ 15.9 72,226 1

Sort (cost=40,079.31..40,090.66 rows=4,537 width=69) (actual time=8,121.384..8,127.824 rows=72,226 loops=1)

  • Sort Key: vbf.file_name DESC
  • Sort Method: quicksort Memory: 13253kB
  • Planning time: 1.093 ms
  • Execution time: 8134.274 ms
2.          

Initplan (forSort)

3. 0.014 0.014 ↑ 1.0 1 1

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

  • Index Cond: (release_id = '3e6d43b5-0a7e-4181-9bc5-c56f36b7a9be'::uuid)
4. 57.247 8,058.168 ↓ 15.9 72,226 1

Hash Join (cost=12,687.92..39,795.46 rows=4,537 width=69) (actual time=162.388..8,058.168 rows=72,226 loops=1)

  • Hash Cond: (vbe.version_bom_component_id = vbc.id)
5. 85.186 7,842.548 ↓ 15.9 72,226 1

Nested Loop (cost=1.23..27,046.38 rows=4,537 width=56) (actual time=2.677..7,842.548 rows=72,226 loops=1)

6. 7,179.554 7,179.554 ↓ 24.5 72,226 1

Index Only Scan Backward using idx_version_bom_file_only on version_bom_file vbf (cost=0.80..3,185.04 rows=2,948 width=21) (actual time=2.614..7,179.554 rows=72,226 loops=1)

  • Index Cond: (version_bom_id = $0)
  • Heap Fetches: 19530
7. 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..8.08 rows=1 width=51) (actual time=0.008..0.008 rows=1 loops=72,226)

  • Index Cond: (version_bom_file_id = vbf.id)
8. 67.217 158.373 ↓ 1.0 210,149 1

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

  • Buckets: 262144 Batches: 1 Memory Usage: 15626kB
9. 91.156 91.156 ↓ 1.0 210,149 1

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