explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zIKs

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

HashAggregate (cost=3,197.50..3,207.90 rows=832 width=16) (actual rows= loops=)

  • Group Key: date(created_at), country_id
2. 0.000 0.000 ↓ 0.0

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

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