explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bB6d

Settings
# exclusive inclusive rows x rows loops node
1. 0.384 2.673 ↑ 1.0 1,917 1

Bitmap Heap Scan on dim_date dim_date (cost=813.27..2,727.52 rows=1,943 width=155) (actual time=2.311..2.673 rows=1,917 loops=1)

  • Heap Blocks: exact=47
  • Buffers: shared hit=208
2. 2.289 2.289 ↑ 1.0 1,917 1

Bitmap Index Scan on idx_dim_date_pkey (cost=0..812.78 rows=1,943 width=0) (actual time=2.289..2.289 rows=1,917 loops=1)

  • Index Cond: ((dim_date.date > '2020-10-01'::date) AND (dim_date.client_sk = 17))
  • Buffers: shared hit=161
Planning time : 0.184 ms
Execution time : 2.83 ms