Changes between Version 1 and Version 2 of queryDerby

Timestamp:

05/02/14 10:35:42 (11 years ago)

Author:

niles

Comment:

--

queryDerby

@@ -18 +18 @@
 7          |OFLN|MIRROR
 81         |OFLN|USER
+}}}
+
+
+{{{
+ij> select SERIES_NAME, STATE, REQUEST_TYPE, count(*) from drms.su_cache group by series_name, STATE, REQUEST_TYPE order by count(*) DESC;
+SERIES_NAME                                                                                                                     |STA&|REQUE&|4
+--------------------------------------------------------------------------------------------------------------------------------------------------------
+hmi.ic_45s                                                                                                                      |OFLN|USER  |6168
+hmi.m_45s                                                                                                                       |OFLN|USER  |1826
+hmi_test.v_45s                                                                                                                  |OFLN|USER  |78
+hmi.v_45s                                                                                                                       |OFLN|USER  |73
+aia.lev1                                                                                                                        |DONE|USER  |14
+aia_test.lev1                                                                                                                   |OFLN|MIRROR|5
+hmi.rdvflows_fd15_frame                                                                                                         |OFLN|MIRROR|1
+aia_test.synoptic2                                                                                                              |OFLN|MIRROR|1
 }}}