explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MPhf

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 294.081 ↓ 0.0 0 1

Nested Loop (cost=0.00..6,424,317.39 rows=1 width=105) (actual time=294.081..294.081 rows=0 loops=1)

  • Join Filter: (((instrument_master_core_inactives.id_bpl_instrument)::text = (market_master_inactives.id_bpl_instrument)::text) AND (instrument_master_core_inactives.businessdate = market_master_inactives.businessdate))
2. 294.080 294.080 ↓ 0.0 0 1

Seq Scan on instrument_master_core_inactives (cost=0.00..6,386,296.09 rows=1 width=77) (actual time=294.080..294.080 rows=0 loops=1)

  • Filter: (((id_isin)::text = 'US51280VAG05'::text) AND (businessdate = (SubPlan 1)))
  • Rows Removed by Filter: 748,329
3.          

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.45..8.46 rows=1 width=4) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Index Scan using instrumentmastercoreinactives_idx on instrument_master_core_inactives t (cost=0.42..8.45 rows=1 width=4) (never executed)

  • Index Cond: ((id_bpl_instrument)::text = (instrument_master_core_inactives.id_bpl_instrument)::text)
  • Filter: (businessdate <= '2019-12-09'::date)
6. 0.000 0.000 ↓ 0.0 0

Seq Scan on market_master_inactives (cost=0.00..26,760.92 rows=750,692 width=22) (never executed)

Planning time : 0.984 ms
Execution time : 294.156 ms