explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oOWZ

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

HashAggregate (cost=62,491.46..62,738.89 rows=14,139 width=40) (actual rows= loops=)

  • Group Key: to_char(account_moneys.date_at, 'YYYY-MM-DD HH24'::text)
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..61,520.29 rows=129,489 width=40) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Only Scan using generate_dates_date_at_uindex on generate_dates (cost=0.29..19.28 rows=634 width=8) (actual rows= loops=)

  • Index Cond: ((date_at >= '2020-01-01 00:00:00'::timestamp without time zone) AND (date_at <= '2020-01-27 23:00:00'::timestamp without time zone))
4. 0.000 0.000 ↓ 0.0

Index Only Scan using account_moneys_date_at_btree_index on account_moneys (cost=0.56..76.23 rows=2,026 width=8) (actual rows= loops=)

  • Index Cond: (date_at = generate_dates.date_at)