explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J1kh

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,708.153 83,185.633 ↑ 1.4 82,880 1

Unique (cost=13,833,614.47..13,846,567.19 rows=116,443 width=103) (actual time=77,811.249..83,185.633 rows=82,880 loops=1)

2. 55,826.684 81,477.480 ↓ 1.2 16,178,143 1

Sort (cost=13,833,614.47..13,840,090.83 rows=12,952,718 width=103) (actual time=77,811.245..81,477.480 rows=16,178,143 loops=1)

  • Sort Key: sku, date DESC
  • Sort Method: external merge Disk: 1489360kB
3. 21,218.690 25,650.796 ↓ 1.2 16,178,143 1

Bitmap Heap Scan on daily_product_metrics_ongoing_totals (cost=327,245.57..13,527,583.82 rows=12,952,718 width=103) (actual time=5,131.723..25,650.796 rows=16,178,143 loops=1)

  • Recheck Cond: (((seller_id)::text = 'A3TUJE1XKIZPOF'::text) AND ((marketplace_id)::text = 'ATVPDKIKX0DER'::text) AND (date <= '2019-06-07 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=2013182
4. 4,432.106 4,432.106 ↓ 1.2 16,178,143 1

Bitmap Index Scan on dpm_ongoing_totals__sellerid__marketplaceid__date__parent_asin (cost=0.00..326,597.94 rows=12,952,718 width=0) (actual time=4,432.106..4,432.106 rows=16,178,143 loops=1)

  • Index Cond: (((seller_id)::text = 'A3TUJE1XKIZPOF'::text) AND ((marketplace_id)::text = 'ATVPDKIKX0DER'::text) AND (date <= '2019-06-07 00:00:00'::timestamp without time zone))
Planning time : 0.381 ms
Execution time : 83,410.627 ms