jsoc_sums=> select * from sum_arch_group order by group_id; group_id | cadence_days | sec1970_start | date_arch_start | name ----------+--------------+---------------+---------------------+-------------- 0 | 30 | 1304958584 | 2011-05-09 00:00:00 | various 1 | 30 | 1304958584 | 2011-05-09 00:00:00 | various 2 | 1 | 1305033531 | 2011-05-10 06:18:51 | hmi.lev0 3 | 1 | 1305033553 | 2011-05-10 06:19:13 | aia.lev0 4 | 1 | 1305033573 | 2011-05-10 06:19:33 | hmi.tlm 5 | 1 | 1304974916 | 2011-05-09 14:01:56 | aia.tlm 6 | 1 | 1304974935 | 2011-05-09 14:02:15 | hmi > lev1 7 | 30 | 1304972369 | 2011-05-09 13:19:29 | aia > lev1 8 | 30 | 1304958584 | 2011-05-09 00:00:00 | sha 9 | 30 | 1304958584 | 2011-05-09 00:00:00 | dsds 10 | 1 | 1305033791 | 2011-05-10 06:23:11 | hmi.lev1 310 | 1 | 1305033769 | 2011-05-10 06:22:49 | hmi.rdVtrack 311 | 1 | 1305033750 | 2011-05-10 06:22:30 | hmi.rdVpspec (13 rows)