I have the following query:
Code:
(SELECT extract(hour from request_time) || ':00-' || ((extract(hour from request_time))+1) || ':00' AS time, count(*) as hits FROM log_request GROUP BY extract(hour from request_time) ORDER BY extract(hour from request_time)) UNION ALL (SELECT 'Total', count(*) FROM log_request);