explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ta2A

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 0.188 ↑ 1.1 91 1

Bitmap Heap Scan on dim_date dim_date (cost=40.8..177.61 rows=96 width=155) (actual time=0.164..0.188 rows=91 loops=1)

  • Heap Blocks: exact=3
  • Buffers: shared hit=14
2. 0.154 0.154 ↑ 1.1 91 1

Bitmap Index Scan on idx_dim_date_pkey (cost=0..40.78 rows=96 width=0) (actual time=0.154..0.154 rows=91 loops=1)

  • Index Cond: ((dim_date.date > '2025-10-01'::date) AND (dim_date.client_sk = 17))
  • Buffers: shared hit=11
Planning time : 0.137 ms
Execution time : 0.245 ms