explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uZCi

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on im_flexe_fulfillment (cost=25.97..233.22 rows=221 width=60) (actual rows= loops=)

  • Recheck Cond: (((master_sku)::text = 'VRM010637N'::text) AND (date >= '2020-02-01'::date) AND (date <= '2020-03-23'::date))
2. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_uniq_flexe_fulfillments (cost=0.00..25.91 rows=221 width=0) (actual rows= loops=)

  • Index Cond: (((master_sku)::text = 'VRM010637N'::text) AND (date >= '2020-02-01'::date) AND (date <= '2020-03-23'::date))