explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y2cU

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 492.420 ↑ 1.0 1 1

Nested Loop (cost=16,342.31..6,156,106.42 rows=1 width=47) (actual time=60.755..492.420 rows=1 loops=1)

2. 450.808 492.313 ↓ 12.0 12 1

Bitmap Heap Scan on instrument_master_core_inactives (cost=16,341.89..6,156,097.98 rows=1 width=28) (actual time=55.741..492.313 rows=12 loops=1)

  • Recheck Cond: (id_isin IS NOT NULL)
  • Filter: ((NOT called) AND (NOT is_cd) AND (NOT convertible) AND (NOT is_secured) AND (NOT is_emerging_market) AND ((payment_rank)::text <> 'Preferred'::text) AND (amt_outstanding >= '250000'::numeric) AND ((issuer_industry)::text = 'BANK'::text) AND (market_sector = 8) AND (maturity > now()) AND ((instrument_currency)::text = ANY ('{USD,EUR,GBP,AUD,NZD,JPY,CAD,CHF}'::text[])) AND (businessdate = (SubPlan 1)))
  • Rows Removed by Filter: 718,755
  • Heap Blocks: exact=41,937
3. 39.804 39.804 ↓ 1.0 718,767 1

Bitmap Index Scan on test1 (cost=0.00..16,341.89 rows=718,595 width=0) (actual time=39.804..39.804 rows=718,767 loops=1)

  • Index Cond: (id_isin IS NOT NULL)
4.          

SubPlan (for Bitmap Heap Scan)

5. 1.701 1.701 ↓ 0.0 0 243

Index Scan using instrumentmastercoreinactives_idx on instrument_master_core_inactives t (cost=0.42..8.45 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=243)

  • Index Cond: ((id_bpl_instrument)::text = (instrument_master_core_inactives.id_bpl_instrument)::text)
  • Filter: (businessdate <= '2019-10-04'::date)
  • Rows Removed by Filter: 1
6. 0.096 0.096 ↓ 0.0 0 12

Index Scan using instrument_master_fi_inactives_pkey on instrument_master_fi_inactives (cost=0.42..8.45 rows=1 width=13) (actual time=0.008..0.008 rows=0 loops=12)

  • Index Cond: ((businessdate = instrument_master_core_inactives.businessdate) AND ((id_bpl_instrument)::text = (instrument_master_core_inactives.id_bpl_instrument)::text))
  • Filter: (NOT structured_note)
  • Rows Removed by Filter: 1
Planning time : 1.083 ms
Execution time : 492.684 ms