explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ccPP : Optimization for: plan #LnqG

Settings

Optimization path:

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

Unique (cost=13,646,135.44..13,658,591.80 rows=113,086 width=103) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=13,646,135.44..13,652,363.62 rows=12,456,362 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=317,575.86..13,352,534.26 rows=12,456,362 width=103) (actual rows= loops=)

  • Recheck Cond: (((seller_id)::text = 'A3TUJE1XKIZPOF'::text) AND ((marketplace_id)::text = 'ATVPDKIKX0DER'::text) 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..316,953.05 rows=12,456,362 width=0) (actual rows= loops=)

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