Code: Select all
SELECT COUNT(value) AS count,
TIME_SLICE(time_stamp, 2100) AS time_interval
FROM metrics.metrics
WHERE metric_definition_id = 27060341
AND time_stamp >= '2013-12-18 03:00:00'
GROUP BY TIME_SLICE(time_stamp, 2100)
ORDER BY time_interval;
count | time_interval
-------+---------------------
10 | 2013-12-18 02:35:00
35 | 2013-12-18 03:10:00
35 | 2013-12-18 03:45:00
35 | 2013-12-18 04:20:00
35 | 2013-12-18 04:55:00
35 | 2013-12-18 05:30:00
35 | 2013-12-18 06:05:00
35 | 2013-12-18 06:40:00
35 | 2013-12-18 07:15:00