Box Anemometer
From
To
Query first seen since
Table Fields
Filter By Host

Group By


Order By


Having


Limit


Where


Query Sample Contains


Reviewed Status

Checksum


Show Raw SQL Permalink 
SELECT checksum AS `checksum`,
  LEFT(dimension.sample,20) AS `snippet`,
  ROUND(SUM(Rows_examined_sum)/SUM(rows_sent_sum),2) AS `index_ratio`,
  SUM(Query_time_sum) / SUM(ts_cnt) AS `query_time_avg`,
  ROUND(SUM(Rows_sent_sum)/SUM(ts_cnt),0) AS `rows_sent_avg`,
  SUM(ts_cnt) AS `ts_cnt`,
  SUM(Query_time_sum) AS `Query_time_sum`,
  SUM(Lock_time_sum) AS `Lock_time_sum`,
  SUM(Rows_sent_sum) AS `Rows_sent_sum`,
  SUM(Rows_examined_sum) AS `Rows_examined_sum`,
  SUM(Tmp_table_sum) AS `Tmp_table_sum`,
  SUM(Filesort_sum) AS `Filesort_sum`,
  SUM(Full_scan_sum) AS `Full_scan_sum`
 FROM `global_query_review` AS `fact` 
 JOIN `global_query_review_history` AS `dimension` USING (`checksum`) 
 WHERE dimension.ts_min >= "2012-04-09 22:00:00"
  AND dimension.ts_min <= "2012-04-10 22:00:00"
 GROUP BY checksum 
 ORDER BY Query_time_sum DESC 
 LIMIT 20
checksum snippet index_ratio query_time_avg rows_sent_avg ts_cnt Query_time_sum Lock_time_sum Rows_sent_sum Rows_examined_sum Tmp_table_sum Filesort_sum Full_scan_sum
10280734369887685528 INSERT INTO `City` V 0.016470703139963263 0 4079 67.18399810791016 0.057468000799417496 0 0 0 0 0
9361318370651369857 select * from City w 0.78 0.000315764100169397 17 103955 32.825257033109665 2.1170240081846714 1775316 1390263 0 0 0
14954866110874212198 INSERT INTO `Country 0.015185771918878323 0 984 14.94279956817627 0.01596900075674057 0 0 0 0 0
11072664168876009544 administrator comman 0.00007853758251669303 0 188869 14.833314672345296 0 0 0 84 0 0
8386735548362950057 SELECT ID from City 1 0.00026307283091104265 0 42455 11.168757036328316 1.0934720188379288 7467 7467 0 0 0
3195008486579250693 select * from Countr 0.88 0.00021851915463609015 4 38509 8.414954125881195 0.8330880030989647 158545 138836 0 0 0
7874975839675641826 INSERT INTO `slow_qu 0.021294042785116967 0 376 8.00656008720398 0.009226999944075942 0 0 0 0 0
9366063919896134931 REPLACE INTO `slow_q 0.020783962087428318 0 376 7.814769744873047 0.01815999997779727 0 0 0 0 0
5988744154716621515 INSERT INTO `Country 0.027576067457638027 0 239 6.590680122375488 0.005776999983936548 0 0 0 0 0
2007580622683486090 SELECT unix_timestam 123.64 0.13457089417497628 2 20 2.6914178834995255 2.6641260811738903 50 6182 17 20 20
14656393659038688553 create database geof 2.3771300315856934 0 1 2.3771300315856934 0 0 0 0 0 0
11933759730616350112 CREATE TABLE `Countr 1.5214799642562866 0 1 1.5214799642562866 0.0001429999974789098 0 0 0 0 0
1233936630691378411 administrator comman 0.00000781827415270366 0 188867 1.476613984398682 0 0 0 84 0 3916
2362606619255509183 SELECT * FROM Countr 25.21 0.0002958849738376128 9 3860 1.1421159990131855 0.10124000161886215 36279 914414 0 0 3826
17375832608889571510 CREATE TABLE `global 0.5734869837760925 0 1 0.5734869837760925 0.00018699999782256782 0 0 0 0 0
9753979876936412992 DROP TABLE IF EXISTS 0.5293329954147339 0 1 0.5293329954147339 0 0 0 0 0 0
11244563016806378505 CREATE TABLE `City` 0.5015270113945007 0 1 0.5015270113945007 0.00009999999747378752 0 0 0 0 0
12050219314212099445 CREATE TABLE `global 0.3727799952030182 0 1 0.3727799952030182 0.00015700000221841037 0 0 0 0 0
5465179719502418416 EXPLAIN SELECT VERSI 0 0.0916527509689331 1 4 0.3666110038757324 0 4 0 0 0 0
17466316031861785707 GRANT ALL PRIVILEGES 0.14871299266815186 0 2 0.2974259853363037 0.0230529997497797 0 0 0 0 0