explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fUJp : Optimization for: plan #FynM

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 39,326.334 48,465.922 ↑ 1.0 90,968 1

Bitmap Heap Scan on nse_data (cost=193,765.75..818,747.94 rows=93,471 width=108) (actual time=9,179.801..48,465.922 rows=90,968 loops=1)

  • Recheck Cond: ((trading_day <= '2020-02-06'::date) AND (trading_day >= '2019-05-06'::date))
  • Rows Removed by Index Recheck: 56,713
  • Filter: ((instrument_type)::text = 'FUT'::text)
  • Rows Removed by Filter: 7,224,982
  • Heap Blocks: exact=48,005 lossy=79,442
2. 9,139.588 9,139.588 ↓ 1.0 7,315,950 1

Bitmap Index Scan on nse_data_trading_day (cost=0.00..193,742.38 rows=7,153,382 width=0) (actual time=9,139.588..9,139.588 rows=7,315,950 loops=1)

  • Index Cond: ((trading_day <= '2020-02-06'::date) AND (trading_day >= '2019-05-06'::date))