explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oIQk

Settings
# exclusive inclusive rows x rows loops node
1. 32.368 2,636.155 ↓ 2.6 525 1

Bitmap Heap Scan on t_normalized_data_monthly ndm (cost=1,363.72..355,325.55 rows=202 width=194) (actual time=65.043..2,636.155 rows=525 loops=1)

  • Filter: (ndm.valuation_date = (SubPlan 1))
  • Heap Blocks: exact=2,358
  • Buffers: shared hit=2,278,631 read=273
2. 8.023 8.023 ↓ 1.1 43,996 1

Bitmap Index Scan on t_normalized_data_monthly_date_local_valuation_date_asset_i_key (cost=0..1,363.67 rows=40,305 width=0) (actual time=8.022..8.023 rows=43,996 loops=1)

  • Index Cond: ((ndm.asset_id = ANY ('{10102,10103,10104,10105,10106,10107,10108,10109,10110,10111,10112,10113,10114,10115,10116,10117,10118,10119,10120}'::bigint[])) AND (ndm.date_local >= '2020-01-01'::date) AND (ndm.date_local <= '2020-09-30'::date))
  • Buffers: shared hit=50 read=273
3.          

SubPlan (for Bitmap Heap Scan)

4. 659.940 2,595.764 ↑ 1.0 1 43,996

Aggregate (cost=8.64..8.65 rows=1 width=4) (actual time=0.059..0.059 rows=1 loops=43,996)

  • Buffers: shared hit=2,276,223
5. 1,935.824 1,935.824 ↓ 163.0 163 43,996

Index Only Scan using t_normalized_data_monthly_date_local_valuation_date_asset_i_key on t_normalized_data_monthly ndm2 (cost=0.42..8.64 rows=1 width=4) (actual time=0.009..0.044 rows=163 loops=43,996)

  • Index Cond: ((ndm2.asset_id = ndm.asset_id) AND (ndm2.date_local = ndm.date_local) AND (ndm2.valuation_date <= '2020-09-09'::date) AND (ndm2.target_data_level_id = ndm.target_data_level_id) AND (ndm2.data_level_id = ndm.data_level_id))
  • Heap Fetches: 2,450,646
  • Buffers: shared hit=2,276,223
Planning time : 0.253 ms
Execution time : 2,636.361 ms