explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WGgB

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,713.61..1,715.61 rows=200 width=21) (actual rows= loops=)

  • Group Key: aws_daily_spending_y2019m12p2.tech_family
2. 0.000 0.000 ↓ 0.0

Append (cost=4.17..1,518.26 rows=39,069 width=21) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on aws_daily_spending_y2019m12p2 (cost=4.17..9.51 rows=2 width=40) (actual rows= loops=)

  • Recheck Cond: ((date >= '2020-01-01 00:00:00+08'::timestamp with time zone) AND (date <= '2020-01-10 00:00:00+08'::timestamp with time zone))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on aws_daily_spending_y2019m12p2_pkey (cost=0.00..4.17 rows=2 width=0) (actual rows= loops=)

  • Index Cond: ((date >= '2020-01-01 00:00:00+08'::timestamp with time zone) AND (date <= '2020-01-10 00:00:00+08'::timestamp with time zone))
5. 0.000 0.000 ↓ 0.0

Seq Scan on aws_daily_spending_y2020m01p0 (cost=0.00..1,313.40 rows=39,067 width=21) (actual rows= loops=)

  • Filter: ((date >= '2020-01-01 00:00:00+08'::timestamp with time zone) AND (date <= '2020-01-10 00:00:00+08'::timestamp with time zone))