explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ellL

Settings
# exclusive inclusive rows x rows loops node
1. 11,228.488 18,357.567 ↓ 12.2 487,250 1

HashAggregate (cost=4,988,674.61..4,990,474.61 rows=40,000 width=226) (actual time=17,623.742..18,357.567 rows=487,250 loops=1)

  • Group Key: d_daily_brand_performance.asin, d_daily_brand_performance.gcid
2. 648.259 7,129.079 ↑ 1.1 6,773,885 1

Result (cost=0.00..4,821,954.34 rows=7,409,790 width=46) (actual time=0.029..7,129.079 rows=6,773,885 loops=1)

3. 453.459 6,480.820 ↑ 1.1 6,773,885 1

Append (cost=0.00..4,747,856.44 rows=7,409,790 width=46) (actual time=0.027..6,480.820 rows=6,773,885 loops=1)

4. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on d_daily_brand_performance (cost=0.00..0.00 rows=1 width=262) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone) AND (marketplace_id = 1) AND (brand_owner_id = 142499351))
5. 6,027.360 6,027.360 ↑ 1.1 6,773,885 1

Index Scan using i_ddbp_201902_1 on ddbp_201902 (cost=0.70..4,747,856.44 rows=7,409,789 width=46) (actual time=0.025..6,027.360 rows=6,773,885 loops=1)

  • Index Cond: ((marketplace_id = 1) AND (brand_owner_id = 142499351) AND (metrics_date >= '2019-02-01 00:00:00'::timestamp without time zone) AND (metrics_date <= '2019-02-28 00:00:00'::timestamp without time zone))