// Sessions
$this->db->query("DELETE FROM ci_sessions WHERE timestamp < DATE_SUB(NOW(), INTERVAL 24 HOUR)");

// Pageviews
$this->db->query("DELETE FROM post_pageviews_month WHERE view_date < DATE_SUB(NOW(), INTERVAL 1 MONTH)");