dsc=> SELECT time AT TIME ZONE 'UTC', minute,value1,SUM(count) FROM dscng_data2d WHERE time AT TIME ZONE 'UTC' >= '2012-06-14 13:59:00+02:00' AND time AT TIME ZONE 'UTC' <= '2012-06-14 14:59:00+02:00' AND data_type_id = 25 AND count != -1 GROUP BY time,minute,value1 ORDER BY time,minute; timezone | minute | value1 | sum ------------------------+--------+--------+-------- 2012-06-14 14:00:00+02 | 0 | -1 | 1 2012-06-14 14:00:00+02 | 0 | 0 | 273482 2012-06-14 14:00:00+02 | 0 | 2 | 3 2012-06-14 14:00:00+02 | 0 | 3 | 64241 2012-06-14 14:00:00+02 | 0 | 5 | 880 2012-06-14 14:00:00+02 | 1 | -1 | 1 2012-06-14 14:00:00+02 | 1 | 0 | 274390 2012-06-14 14:00:00+02 | 1 | 3 | 62161 2012-06-14 14:00:00+02 | 1 | 5 | 883 2012-06-14 14:00:00+02 | 2 | -1 | 6 2012-06-14 14:00:00+02 | 2 | 0 | 281428 2012-06-14 14:00:00+02 | 2 | 2 | 33 2012-06-14 14:00:00+02 | 2 | 3 | 56955 2012-06-14 14:00:00+02 | 2 | 5 | 1008 2012-06-14 14:00:00+02 | 3 | -1 | 1 2012-06-14 14:00:00+02 | 3 | 0 | 257688 2012-06-14 14:00:00+02 | 3 | 3 | 56091 2012-06-14 14:00:00+02 | 3 | 5 | 920 2012-06-14 14:00:00+02 | 4 | -1 | 5 2012-06-14 14:00:00+02 | 4 | 0 | 254933 2012-06-14 14:00:00+02 | 4 | 2 | 12 2012-06-14 14:00:00+02 | 4 | 3 | 54891 2012-06-14 14:00:00+02 | 4 | 5 | 926 2012-06-14 14:00:00+02 | 5 | 0 | 255418 2012-06-14 14:00:00+02 | 5 | 2 | 3 2012-06-14 14:00:00+02 | 5 | 3 | 55643 2012-06-14 14:00:00+02 | 5 | 5 | 1158 2012-06-14 14:00:00+02 | 6 | -1 | 2 2012-06-14 14:00:00+02 | 6 | 0 | 253643 2012-06-14 14:00:00+02 | 6 | 3 | 49942 2012-06-14 14:00:00+02 | 6 | 5 | 1005 2012-06-14 14:00:00+02 | 7 | -1 | 2 2012-06-14 14:00:00+02 | 7 | 0 | 265224 2012-06-14 14:00:00+02 | 7 | 2 | 12 2012-06-14 14:00:00+02 | 7 | 3 | 54418 2012-06-14 14:00:00+02 | 7 | 5 | 934 2012-06-14 14:00:00+02 | 8 | -1 | 1 2012-06-14 14:00:00+02 | 8 | 0 | 296769 2012-06-14 14:00:00+02 | 8 | 3 | 61313 2012-06-14 14:00:00+02 | 8 | 5 | 935 2012-06-14 14:00:00+02 | 9 | -1 | 1 2012-06-14 14:00:00+02 | 9 | 0 | 309027 2012-06-14 14:00:00+02 | 9 | 2 | 12 2012-06-14 14:00:00+02 | 9 | 3 | 61900 2012-06-14 14:00:00+02 | 9 | 5 | 1007 2012-06-14 14:00:00+02 | 10 | -1 | 1 2012-06-14 14:00:00+02 | 10 | 0 | 307290 2012-06-14 14:00:00+02 | 10 | 2 | 3 2012-06-14 14:00:00+02 | 10 | 3 | 51522 2012-06-14 14:00:00+02 | 10 | 5 | 1013 2012-06-14 14:00:00+02 | 11 | -1 | 3 2012-06-14 14:00:00+02 | 11 | 0 | 298550 2012-06-14 14:00:00+02 | 11 | 2 | 3 2012-06-14 14:00:00+02 | 11 | 3 | 55384 2012-06-14 14:00:00+02 | 11 | 5 | 1069 2012-06-14 14:00:00+02 | 12 | -1 | 1 2012-06-14 14:00:00+02 | 12 | 0 | 299383 2012-06-14 14:00:00+02 | 12 | 2 | 9 2012-06-14 14:00:00+02 | 12 | 3 | 43177 2012-06-14 14:00:00+02 | 12 | 5 | 1087 2012-06-14 14:00:00+02 | 13 | -1 | 1 2012-06-14 14:00:00+02 | 13 | 0 | 289251 2012-06-14 14:00:00+02 | 13 | 3 | 33347 2012-06-14 14:00:00+02 | 13 | 5 | 982 2012-06-14 14:00:00+02 | 14 | -1 | 1 2012-06-14 14:00:00+02 | 14 | 0 | 278758 2012-06-14 14:00:00+02 | 14 | 3 | 55043 2012-06-14 14:00:00+02 | 14 | 5 | 956 2012-06-14 14:00:00+02 | 15 | -1 | 2 2012-06-14 14:00:00+02 | 15 | 0 | 293328 2012-06-14 14:00:00+02 | 15 | 3 | 56484 2012-06-14 14:00:00+02 | 15 | 5 | 950 2012-06-14 14:00:00+02 | 16 | -1 | 1 2012-06-14 14:00:00+02 | 16 | 0 | 296154 2012-06-14 14:00:00+02 | 16 | 2 | 3 2012-06-14 14:00:00+02 | 16 | 3 | 46573 2012-06-14 14:00:00+02 | 16 | 5 | 1032 2012-06-14 14:00:00+02 | 17 | 0 | 289208 2012-06-14 14:00:00+02 | 17 | 2 | 6 2012-06-14 14:00:00+02 | 17 | 3 | 46235 2012-06-14 14:00:00+02 | 17 | 5 | 957 2012-06-14 14:00:00+02 | 18 | 0 | 273045 2012-06-14 14:00:00+02 | 18 | 2 | 3 2012-06-14 14:00:00+02 | 18 | 3 | 54341 2012-06-14 14:00:00+02 | 18 | 5 | 1119 2012-06-14 14:00:00+02 | 19 | 0 | 280802 2012-06-14 14:00:00+02 | 19 | 2 | 9 2012-06-14 14:00:00+02 | 19 | 3 | 47633 2012-06-14 14:00:00+02 | 19 | 5 | 918 2012-06-14 14:00:00+02 | 20 | -1 | 1 2012-06-14 14:00:00+02 | 20 | 0 | 266695 2012-06-14 14:00:00+02 | 20 | 3 | 44421 2012-06-14 14:00:00+02 | 20 | 5 | 981 2012-06-14 14:00:00+02 | 21 | -1 | 4 2012-06-14 14:00:00+02 | 21 | 0 | 265832 2012-06-14 14:00:00+02 | 21 | 3 | 40638 2012-06-14 14:00:00+02 | 21 | 5 | 890 2012-06-14 14:00:00+02 | 22 | 0 | 273509 2012-06-14 14:00:00+02 | 22 | 2 | 6 2012-06-14 14:00:00+02 | 22 | 3 | 44623 2012-06-14 14:00:00+02 | 22 | 5 | 908 2012-06-14 14:00:00+02 | 23 | 0 | 282016 2012-06-14 14:00:00+02 | 23 | 2 | 3 2012-06-14 14:00:00+02 | 23 | 3 | 45014 2012-06-14 14:00:00+02 | 23 | 5 | 982 2012-06-14 14:00:00+02 | 24 | -1 | 1 2012-06-14 14:00:00+02 | 24 | 0 | 287092 2012-06-14 14:00:00+02 | 24 | 2 | 9 2012-06-14 14:00:00+02 | 24 | 3 | 41135 2012-06-14 14:00:00+02 | 24 | 5 | 807 2012-06-14 14:00:00+02 | 25 | 0 | 278397 2012-06-14 14:00:00+02 | 25 | 3 | 43525 2012-06-14 14:00:00+02 | 25 | 5 | 902 2012-06-14 14:00:00+02 | 26 | 0 | 290342 2012-06-14 14:00:00+02 | 26 | 3 | 48592 2012-06-14 14:00:00+02 | 26 | 5 | 990 (116 rows)