explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AoJh

Settings
# exclusive inclusive rows x rows loops node
1. 0.062 153.476 ↑ 20.0 2 1

GroupAggregate (cost=33,053.01..33,054.15 rows=40 width=48) (actual time=153.463..153.476 rows=2 loops=1)

  • Group Key: (date_trunc('month'::text, month))
2. 0.088 153.414 ↓ 1.2 57 1

Sort (cost=33,053.01..33,053.12 rows=46 width=22) (actual time=153.408..153.414 rows=57 loops=1)

  • Sort Key: (date_trunc('month'::text, month))
  • Sort Method: quicksort Memory: 29kB
3. 153.326 153.326 ↓ 1.2 57 1

Seq Scan on revenue_logs rl (cost=0.00..33,051.74 rows=46 width=22) (actual time=18.738..153.326 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: 789839