explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3tEv

Settings
# exclusive inclusive rows x rows loops node
1. 0.090 2,022.197 ↑ 2,329.1 25 1

GroupAggregate (cost=538,877.34..540,187.44 rows=58,227 width=16) (actual time=2,022.061..2,022.197 rows=25 loops=1)

  • Group Key: (date(created_at)), country_id
2. 0.181 2,022.107 ↑ 66.6 874 1

Sort (cost=538,877.34..539,022.90 rows=58,227 width=8) (actual time=2,022.052..2,022.107 rows=874 loops=1)

  • Sort Key: country_id
  • Sort Method: quicksort Memory: 65kB
3. 2,021.926 2,021.926 ↑ 66.6 874 1

Seq Scan on candidates (cost=0.00..534,268.84 rows=58,227 width=8) (actual time=2,017.289..2,021.926 rows=874 loops=1)

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