explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BPIM : Optimization for: plan #iOCE

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 959,876.807 ↓ 0.0 0 1

Limit (cost=1.56..5,724.21 rows=10 width=2,732) (actual time=959,876.807..959,876.807 rows=0 loops=1)

2. 0.011 959,876.805 ↓ 0.0 0 1

Merge Join (cost=1.56..84,562,395.56 rows=147,768 width=2,732) (actual time=959,876.805..959,876.805 rows=0 loops=1)

  • Merge Cond: (dcshost3_.assembly_series_nr = this_.assembly_series_nr)
3. 13,876.102 959,876.794 ↓ 0.0 0 1

Nested Loop (cost=1.00..65,669,007.79 rows=148,822 width=1,380) (actual time=959,876.794..959,876.794 rows=0 loops=1)

4. 743,358.492 743,358.492 ↓ 1.0 33,773,700 1

Index Scan using dcs_host_pkey on dcs_host dcshost3_ (cost=0.56..18,802,174.56 rows=33,694,883 width=324) (actual time=0.176..743,358.492 rows=33,773,700 loops=1)

5. 202,642.200 202,642.200 ↓ 0.0 0 33,773,700

Index Scan using order_detail_pkey on order_detail o1_ (cost=0.43..1.34 rows=1 width=1,056) (actual time=0.006..0.006 rows=0 loops=33,773,700)

  • Index Cond: (id = dcshost3_.order_detail_id)
  • Filter: (external_id = '6b8eb9d1-ec10-4e84-bc34-bbc7b12f534d'::text)
  • Rows Removed by Filter: 1
6. 0.000 0.000 ↓ 0.0 0

Index Scan using dcs_assembly_series_nr_idx on dcs this_ (cost=0.56..18,801,986.36 rows=33,456,360 width=1,352) (never executed)