explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GwaS

Settings
# exclusive inclusive rows x rows loops node
1. 0.157 0.945 ↑ 33.3 25 1

HashAggregate (cost=3,197.50..3,207.90 rows=832 width=16) (actual time=0.943..0.945 rows=25 loops=1)

  • Group Key: date(created_at), country_id
2. 0.788 0.788 ↓ 1.1 874 1

Index Scan using index_candidates_on_created_at on candidates (cost=0.43..3,191.26 rows=832 width=8) (actual time=0.010..0.788 rows=874 loops=1)

  • Index Cond: ((created_at >= '2019-04-11'::date) AND (created_at < '2019-04-12'::date))
  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 8