Box Anemometer

Query 12050219314212099445

First Seen: 2012-04-10 14:29:14
Last Seen: 2012-04-10 14:29:14
Fingerprint
create table `global_query_review` ( `checksum` bigint(?) unsigned not ?, `fingerprint` text not ?, `sample` text not ?, `first_seen` datetime default ?, `last_seen` datetime default ?, `reviewed_by` varchar(?) default ?, `reviewed_on` datetime default ?, `comments` text, `reviewed_status` varchar(?) default ?, primary key (`checksum`) ) engine=innodb default charset=utf?
Last Sample on host mysql.geoffreyanderson.net at 2012-04-10 14:29:14
More Samples 
CREATE TABLE `global_query_review` (
  `checksum` bigint(20) unsigned NOT NULL,
  `fingerprint` text NOT NULL,
  `sample` text NOT NULL,
  `first_seen` datetime DEFAULT NULL,
  `last_seen` datetime DEFAULT NULL,
  `reviewed_by` varchar(20) DEFAULT NULL,
  `reviewed_on` datetime DEFAULT NULL,
  `comments` text,
  `reviewed_status` varchar(24) DEFAULT NULL,
  PRIMARY KEY (`checksum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
comments
Status:

Reviewed By:

90 Day History

Show Raw SQL Permalink 
SELECT DATE(ts_min) AS `date`,
  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 checksum = "12050219314212099445"
  AND dimension.ts_min >= "2026-02-23 17:39:02"
  AND dimension.ts_min <= "2026-05-24 17:39:02"
 GROUP BY date 
 ORDER BY date DESC 
 LIMIT 90
date 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