+----------+---------------+------------+---------------------+---------------------+-------+------------+ | duration | current_state | next_state | start_time | end_time | dummy | type | +----------+---------------+------------+---------------------+---------------------+-------+------------+ | 607955 | 0 | 0 | 2012-01-01 00:00:00 | 2012-01-08 00:52:35 | NULL | soft_state | | 608260 | 0 | 0 | 2012-01-01 00:00:00 | 2012-01-08 00:57:40 | NULL | soft_state | | 608565 | 0 | 0 | 2012-01-01 00:00:00 | 2012-01-08 01:02:45 | NULL | soft_state | | 2621404 | 0 | 0 | 2012-01-01 00:00:00 | 2012-01-31 08:10:04 | NULL | soft_state | | 2621706 | 0 | 0 | 2012-01-01 00:00:00 | 2012-01-31 08:15:06 | NULL | soft_state | | 2629588 | 0 | 0 | 2012-01-01 00:00:00 | 2012-01-31 10:26:28 | NULL | soft_state | | 2629899 | 0 | 0 | 2012-01-01 00:00:00 | 2012-01-31 10:31:39 | NULL | soft_state | | 2630213 | 0 | 0 | 2012-01-01 00:00:00 | 2012-01-31 10:36:53 | NULL | soft_state | | 2630518 | 0 | 0 | 2012-01-01 00:00:00 | 2012-01-31 10:41:58 | NULL | soft_state | | 3485328 | 0 | 0 | 2012-01-01 00:00:00 | 2012-02-10 08:08:48 | NULL | soft_state | | 3485633 | 0 | 0 | 2012-01-01 00:00:00 | 2012-02-10 08:13:53 | NULL | soft_state | | 3487458 | 0 | 0 | 2012-01-01 00:00:00 | 2012-02-10 08:44:18 | NULL | soft_state | | 3487763 | 0 | 0 | 2012-01-01 00:00:00 | 2012-02-10 08:49:23 | NULL | soft_state | | 5663968 | 0 | 0 | 2012-01-01 00:00:00 | 2012-03-06 13:19:28 | NULL | soft_state | | 5664273 | 0 | 0 | 2012-01-01 00:00:00 | 2012-03-06 13:24:33 | NULL | soft_state | | 6425039 | 0 | 0 | 2012-01-01 00:00:00 | 2012-03-15 08:43:59 | NULL | soft_state | | 6425344 | 0 | 0 | 2012-01-01 00:00:00 | 2012-03-15 08:49:04 | NULL | soft_state | | 7515996 | 0 | 0 | 2012-01-01 00:00:00 | 2012-03-28 00:46:36 | NULL | soft_state | | 7516301 | 0 | 0 | 2012-01-01 00:00:00 | 2012-03-28 00:51:41 | NULL | soft_state | | 14647673 | 0 | 0 | 2012-01-01 00:00:00 | 2012-06-18 13:47:53 | NULL | soft_state | | 14647978 | 0 | 0 | 2012-01-01 00:00:00 | 2012-06-18 13:52:58 | NULL | soft_state | | 16226046 | 0 | 0 | 2012-01-01 00:00:00 | 2012-07-06 20:14:06 | NULL | soft_state | | 16226351 | 0 | 0 | 2012-01-01 00:00:00 | 2012-07-06 20:19:11 | NULL | soft_state | | 18805054 | 0 | 0 | 2012-01-01 00:00:00 | 2012-08-05 16:37:34 | NULL | soft_state | | 18805359 | 0 | 0 | 2012-01-01 00:00:00 | 2012-08-05 16:42:39 | NULL | soft_state | | 18818074 | 0 | 0 | 2012-01-01 00:00:00 | 2012-08-05 20:14:34 | NULL | soft_state | | 18818379 | 0 | 0 | 2012-01-01 00:00:00 | 2012-08-05 20:19:39 | NULL | soft_state | | 753273 | 0 | 0 | 2012-08-05 20:19:39 | 2012-08-14 13:34:12 | NULL | NULL | +----------+---------------+------------+---------------------+---------------------+-------+------------+ 28 rows in set (0.28 sec)