explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iq80

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

GroupAggregate (cost=538,865.29..540,175.37 rows=58,226 width=16) (actual rows= loops=)

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

Sort (cost=538,865.29..539,010.85 rows=58,226 width=8) (actual rows= loops=)

  • Sort Key: country_id
3. 0.000 0.000 ↓ 0.0

Seq Scan on candidates (cost=0.00..534,256.88 rows=58,226 width=8) (actual rows= loops=)

  • Filter: ((deleted_at IS NULL) AND (date(created_at) = '2019-04-11'::date))