explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b8OI

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 490.278 ↑ 1.0 1 1

Nested Loop (cost=16,342.31..6,165,088.86 rows=1 width=47) (actual time=60.950..490.278 rows=1 loops=1)

2. 448.232 490.169 ↓ 12.0 12 1

Bitmap Heap Scan on instrument_master_core_inactives (cost=16,341.89..6,165,080.41 rows=1 width=28) (actual time=55.930..490.169 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.993 39.993 ↓ 1.0 718,767 1

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

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

SubPlan (for Bitmap Heap Scan)

5. 0.000 1.944 ↑ 1.0 1 243

Aggregate (cost=8.45..8.46 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=243)

6. 1.944 1.944 ↓ 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.008..0.008 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
7. 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.137 ms
Execution time : 490.584 ms