explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uTTC

Settings
# exclusive inclusive rows x rows loops node
1. 0.072 4,120.117 ↑ 162.6 94 1
→

Sort (cost=430,694.53..430,732.74 rows=15,286 width=12) (actual time=4,120.102..4,120.117 rows=94 loops=1)

  • Sort Key: ((datetime)::date)
  • Sort Method: quicksort Memory: 29kB
2. 590.346 4,120.045 ↑ 162.6 94 1
→

HashAggregate (cost=429,441.08..429,632.16 rows=15,286 width=12) (actual time=4,119.971..4,120.045 rows=94 loops=1)

  • Group Key: (datetime)::date
3. 3,529.699 3,529.699 ↓ 1.6 1,261,964 1
→

Seq Scan on to_school_aot_usage_stats "ToSchoolAotUsageStat" (cost=0.00..425,405.30 rows=807,157 width=12) (actual time=0.033..3,529.699 rows=1,261,964 loops=1)

  • Filter: (is_boarding AND (datetime >= '2018-09-01 00:00:00'::timestamp without time zone) AND (datetime <= '2019-06-30 00:00:00'::timestamp without time zone) AND (usage_result = 'OK'::usage_result_type))
  • Rows Removed by Filter: 11237259