explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SyG3

Settings
# exclusive inclusive rows x rows loops node
1. 0.052 114.809 ↑ 27.0 2 1

GroupAggregate (cost=40,773.40..40,774.97 rows=54 width=48) (actual time=114.801..114.809 rows=2 loops=1)

  • Group Key: (date_trunc('month'::text, month))
2. 0.038 114.757 ↑ 1.1 57 1

Sort (cost=40,773.40..40,773.56 rows=65 width=22) (actual time=114.752..114.757 rows=57 loops=1)

  • Sort Key: (date_trunc('month'::text, month))
  • Sort Method: quicksort Memory: 29kB
3. 114.719 114.719 ↑ 1.1 57 1

Seq Scan on revenue_logs rl (cost=0.00..40,771.44 rows=65 width=22) (actual time=25.986..114.719 rows=57 loops=1)

  • Filter: ((cid = 1346) AND (month >= date_trunc('month'::text, (now() - '2 mons'::interval))) AND (month <= (date_trunc('month'::text, now()) - '1 day'::interval)))
  • Rows Removed by Filter: 796444