explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x7zr

Settings
# exclusive inclusive rows x rows loops node
1. 4,560.287 245,107.773 ↓ 8.2 328,488 1

HashAggregate (cost=1,350,890.36..1,352,690.36 rows=40,000 width=226) (actual time=244,653.542..245,107.773 rows=328,488 loops=1)

  • Group Key: d_daily_brand_performance.asin, d_daily_brand_performance.gcid
2. 316.524 240,547.486 ↑ 1.0 1,975,554 1

Result (cost=0.00..1,305,940.96 rows=1,997,751 width=46) (actual time=0.026..240,547.486 rows=1,975,554 loops=1)

3. 189.287 240,230.962 ↑ 1.0 1,975,554 1

Append (cost=0.00..1,285,963.45 rows=1,997,751 width=46) (actual time=0.026..240,230.962 rows=1,975,554 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-04-01 00:00:00'::timestamp without time zone) AND (metrics_date <= '2019-04-30 00:00:00'::timestamp without time zone) AND (marketplace_id = 1) AND (brand_owner_id = 142499351))
5. 240,041.674 240,041.674 ↑ 1.0 1,975,554 1

Index Scan using i_ddbp_201904_1 on ddbp_201904 (cost=0.57..1,285,963.45 rows=1,997,750 width=46) (actual time=0.023..240,041.674 rows=1,975,554 loops=1)

  • Index Cond: ((marketplace_id = 1) AND (brand_owner_id = 142499351) AND (metrics_date >= '2019-04-01 00:00:00'::timestamp without time zone) AND (metrics_date <= '2019-04-30 00:00:00'::timestamp without time zone))
Planning time : 1.581 ms