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 JSON
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 >= "2019-08-14 03:44:12"
  AND dimension.ts_min <= "2019-08-15 03:44:12"
 GROUP BY checksum 
 ORDER BY Query_time_sum DESC 
 LIMIT 20 
Showing 0 results
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