explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n3xc

Settings
# exclusive inclusive rows x rows loops node
1. 319.870 136,731.856 ↑ 223.8 643 1

Seq Scan on version_bom_component vbc (cost=0.00..173,624,962.06 rows=143,894 width=54) (actual time=11,074.043..136,731.856 rows=643 loops=1)

  • Filter: ((ignored = ANY ('{t,f}'::boolean[])) AND (SubPlan 1))
  • Rows Removed by Filter: 287146
2.          

SubPlan (for Seq Scan)

3. 1,112.052 136,411.986 ↓ 0.0 0 287,789

Nested Loop (cost=507.30..603.26 rows=1 width=0) (actual time=0.474..0.474 rows=0 loops=287,789)

4. 33,965.575 130,080.628 ↓ 9.0 9 287,789

Hash Right Join (cost=507.02..594.95 rows=1 width=0) (actual time=0.449..0.452 rows=9 loops=287,789)

  • Hash Cond: (vbs.id = vbe.id)
  • Filter: (((vbs.review_status = 'REVIEWED'::text) AND (NOT vbs.ignored)) OR (vbs.review_status IS NULL))
  • Rows Removed by Filter: 0
5. 39,420.620 39,420.620 ↑ 1.1 1,173 277,610

Seq Scan on version_bom_snippet vbs (cost=0.00..83.03 rows=1,303 width=22) (actual time=0.001..0.142 rows=1,173 loops=277,610)

6. 863.367 56,694.433 ↑ 14.9 9 287,789

Hash (cost=505.35..505.35 rows=134 width=8) (actual time=0.197..0.197 rows=9 loops=287,789)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 55,831.066 55,831.066 ↑ 14.9 9 287,789

Index Scan using idx_version_bom_entry_version_bom_component_id on version_bom_entry vbe (cost=0.43..505.35 rows=134 width=8) (actual time=0.049..0.194 rows=9 loops=287,789)

  • Index Cond: (vbc.id = version_bom_component_id)
8. 5,219.306 5,219.306 ↓ 0.0 0 2,609,653

Index Scan using version_bom_release_id_idx on version_bom vb (cost=0.28..8.30 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=2,609,653)

  • Index Cond: (release_id = 'df23285e-a43d-41cf-a6d8-9462f1c79471'::uuid)
  • Filter: (id = vbc.version_bom_id)
  • Rows Removed by Filter: 1
Planning time : 8.408 ms
Execution time : 136,732.251 ms