explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1gnL

Settings
# exclusive inclusive rows x rows loops node
1. 644.219 750.793 ↓ 1.2 569,837 1

Bitmap Heap Scan on fact_sale fact_sale (cost=13,246.28..262,508.68 rows=471,381 width=230) (actual time=117.025..750.793 rows=569,837 loops=1)

  • Buffers: shared hit=38716
2. 106.574 106.574 ↓ 1.2 569,837 1

Bitmap Index Scan on fact_sale_experiment_idx (cost=0..13,128.43 rows=471,381 width=0) (actual time=106.574..106.574 rows=569,837 loops=1)

  • Index Cond: ((fact_sale.client_sk = 11) AND (fact_sale.sale_reporting_date >= '2017-01-01'::date))
  • Buffers: shared hit=6199