explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nzGy : Optimization for: plan #LnqG

Settings

Optimization path:

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

Unique (cost=325,595.17..325,761.77 rows=87,170 width=103) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=325,595.17..325,678.47 rows=166,597 width=103) (actual rows= loops=)

  • Sort Key: sku, date DESC
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on daily_product_metrics_ongoing_totals (cost=4,332.26..322,705.38 rows=166,597 width=103) (actual rows= loops=)

  • Recheck Cond: (((seller_id)::text = 'A1LMQBEOGTEVAC'::text) AND ((marketplace_id)::text = 'ATVPDKIKX0DER'::text) AND (date >= '2019-02-09 00:00:00'::timestamp without time zone) AND (date <= '2019-06-08 00:00:00'::timestamp without time zone))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on dpm_ongoing_totals__sellerid__marketplaceid__date__parent_asin (cost=0.00..4,323.93 rows=166,597 width=0) (actual rows= loops=)

  • Index Cond: (((seller_id)::text = 'A1LMQBEOGTEVAC'::text) AND ((marketplace_id)::text = 'ATVPDKIKX0DER'::text) AND (date >= '2019-02-09 00:00:00'::timestamp without time zone) AND (date <= '2019-06-08 00:00:00'::timestamp without time zone))