explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tIMt : Optimization for: plan #J1kh

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 43.398 1,037.858 ↑ 104.1 959 1

Unique (cost=438,840.58..439,067.34 rows=99,835 width=103) (actual time=952.028..1,037.858 rows=959 loops=1)

2. 436.432 994.460 ↑ 1.1 205,698 1

Sort (cost=438,840.58..438,953.96 rows=226,761 width=103) (actual time=951.968..994.460 rows=205,698 loops=1)

  • Sort Key: sku, date DESC
  • Sort Method: quicksort Memory: 38927kB
3. 454.395 558.028 ↑ 1.1 205,698 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals (cost=5,730.38..434,806.32 rows=226,761 width=103) (actual time=113.775..558.028 rows=205,698 loops=1)

  • Recheck Cond: (((seller_id)::text = 'A197WTHT9C3SV1'::text) AND ((marketplace_id)::text = 'ATVPDKIKX0DER'::text) AND (date <= '2019-06-08 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=40521
4. 103.633 103.633 ↑ 1.1 205,698 1

Bitmap Index Scan on dpm_ongoing_totals__sellerid__marketplaceid__date__parent_asin (cost=0.00..5,719.04 rows=226,761 width=0) (actual time=103.632..103.633 rows=205,698 loops=1)

  • Index Cond: (((seller_id)::text = 'A197WTHT9C3SV1'::text) AND ((marketplace_id)::text = 'ATVPDKIKX0DER'::text) AND (date <= '2019-06-08 00:00:00'::timestamp without time zone))
Planning time : 3.776 ms
Execution time : 1,040.867 ms