explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5IyO

Settings
# exclusive inclusive rows x rows loops node
1. 139.472 6,309.533 ↑ 20.2 4,933 1

Unique (cost=435,235.57..435,460.43 rows=99,561 width=103) (actual time=6,066.220..6,309.533 rows=4,933 loops=1)

2. 2,868.709 6,170.061 ↓ 5.3 1,187,272 1

Sort (cost=435,235.57..435,348.00 rows=224,853 width=103) (actual time=6,066.218..6,170.061 rows=1,187,272 loops=1)

  • Sort Key: sku, date DESC
  • Sort Method: quicksort Memory: 247091kB
3. 2,898.733 3,301.352 ↓ 5.3 1,187,272 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals (cost=5,673.52..431,238.00 rows=224,853 width=103) (actual time=463.644..3,301.352 rows=1,187,272 loops=1)

  • Recheck Cond: (((seller_id)::text = 'A1LMQBEOGTEVAC'::text) AND ((marketplace_id)::text = 'ATVPDKIKX0DER'::text) AND (date <= '2019-06-07 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=253347
4. 402.619 402.619 ↓ 5.3 1,187,272 1

Bitmap Index Scan on dpm_ongoing_totals__sellerid__marketplaceid__date__parent_asin (cost=0.00..5,662.27 rows=224,853 width=0) (actual time=402.619..402.619 rows=1,187,272 loops=1)

  • Index Cond: (((seller_id)::text = 'A1LMQBEOGTEVAC'::text) AND ((marketplace_id)::text = 'ATVPDKIKX0DER'::text) AND (date <= '2019-06-07 00:00:00'::timestamp without time zone))
Planning time : 4.141 ms
Execution time : 6,327.273 ms