Skip to content

Instantly share code, notes, and snippets.

@matsuu

matsuu/slowquery.tsv

Created August 31, 2021 14:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save matsuu/3dde8ef7b47fdb7734faa655a70c8d2c to your computer and use it in GitHub Desktop.
Save matsuu/3dde8ef7b47fdb7734faa655a70c8d2c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
slowquery.tsv
cnt sum min avg max sumLock sumRows avgRows db digest
2652 49.9726991 0.0002634 0.0188434 0.5659351 9.04831 0 0.0000 isucondition INSERT INTO `isu_condition` ( `jia_isu_uuid` , `timestamp` , `is_sitting` , `condition` , `message` ) VALUES (...) /* , ... */
38616 23.6343877 0.0001812 0.000612036 0.0238742 3.517377 770877 19.9626 isucondition SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = ? AND `timestamp` < ? ORDER BY `timestamp` DESC LIMIT ?
22043 7.8235772 0.0001151 0.000354923 0.0676955 1.608543 21699 0.9844 isucondition SELECT `jia_isu_uuid` , `timestamp` , `is_sitting` , `condition` , `condition_level` , `message` FROM `isu_condition` WHERE `jia_isu_uuid` = ? ORDER BY `timestamp` DESC LIMIT ?
4277 5.5938873 0.0001583 0.001307899 0.0202111 0.402669 1463878 342.2675 isucondition SELECT `timestamp` , `condition` , `is_sitting` FROM `isu_condition` WHERE `jia_isu_uuid` = ? AND `timestamp` BETWEEN ? AND ? ORDER BY `timestamp` ASC
13317 4.8538362 0.0001058 0.000364484 0.0196072 0.914678 13141 0.9868 isucondition SELECT `condition_level` , TIMESTAMP FROM `isu_condition` WHERE `jia_isu_uuid` = ? ORDER BY TIMESTAMP DESC LIMIT ?
1669 2.3103069 0.0002554 0.001384246 0.0166092 0.145826 26494 15.8742 isucondition SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = ? AND `condition_level` IN (...) AND `timestamp` < ? ORDER BY `timestamp` DESC LIMIT ?
3264 1.1691396 6.69e-05 0.000358192 0.0155912 0.351073 3156 0.9669 isucondition SELECT `use_default_image` FROM `isu` WHERE `jia_user_id` = ? AND `jia_isu_uuid` = ?
3222 1.048542 7.6e-05 0.000325432 0.0166371 0.26224 3108 0.9646 isucondition SELECT NAME FROM `isu` WHERE `jia_isu_uuid` = ? AND `jia_user_id` = ?
1675 0.7650012 0.0001124 0.000456717 0.0102974 0.14981 16335 9.7522 isucondition SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = ? AND `timestamp` < ? AND ? <= `timestamp` ORDER BY `timestamp` DESC LIMIT ?
1317 0.4637433 9.06e-05 0.00035212 0.0176861 0.119912 1207 0.9165 isucondition SELECT * FROM `isu` WHERE `jia_user_id` = ? AND `jia_isu_uuid` = ?
890 0.3293551 9.65e-05 0.000370061 0.0198561 0.077461 890 1.0000 isucondition SELECT EXISTS ( SELECT ? FROM `isu` WHERE `jia_user_id` = ? AND `jia_isu_uuid` = ? )
631 0.261283 0.0001149 0.000414077 0.0152416 0.055687 2692 4.2662 isucondition SELECT ID , `jia_isu_uuid` , NAME , `character` FROM `isu` WHERE `jia_user_id` = ? ORDER BY `id` DESC
1240 0.2149806 7.71e-05 0.000173371 0.0019834 0.072675 0 0.0000 isucondition INSERT IGNORE INTO SYSTEM_USER ( `jia_user_id` ) VALUES (?)
400 0.1091721 9.33e-05 0.00027293 0.0098416 0.018578 1857 4.6425 isucondition SELECT ID , `jia_isu_uuid` FROM `isu` WHERE `character` = ?
1 0.0659053 0.0659053 0.0659053 0.0659053 0.000243 0 0.0000 isucondition ALTER TABLE `isu` ADD COLUMN `use_default_image` BOOLEAN NOT NULL DEFAULT FALSE AFTER `image`
1 0.0639788 0.0639788 0.0639788 0.0639788 0 0 0.0000 isucondition INSERT INTO `isu` VALUES (...) /* , ... */
143 0.0509803 9.86e-05 0.000356505 0.0094286 0.008649 0 0.0000 isucondition INSERT INTO `isu` ( `jia_isu_uuid` , `name` , `use_default_image` , `jia_user_id` ) VALUES (...)
140 0.0501778 0.0001221 0.000358412 0.0066545 0.008287 0 0.0000 isucondition UPDATE `isu` SET `character` = ? WHERE `jia_isu_uuid` = ?
1 0.041061 0.041061 0.041061 0.041061 3e-05 0 0.0000 isucondition DROP TABLE IF EXISTS `isu_condition`
1 0.0342553 0.0342553 0.0342553 0.0342553 0.033524 0 0.0000 isucondition OPTIMIZE TABLE `isu_condition`
1 0.0287773 0.0287773 0.0287773 0.0287773 0.000298 0 0.0000 isucondition ALTER TABLE `isu_condition` ADD PRIMARY KEY ( `jia_isu_uuid` , TIMESTAMP )
1 0.0255298 0.0255298 0.0255298 0.0255298 0.000316 0 0.0000 isucondition ALTER TABLE `isu_condition` ADD INDEX ( `jia_isu_uuid` , `condition_level` , TIMESTAMP ) , DROP COLUMN `created_at` , DROP COLUMN ID
1 0.0209251 0.0209251 0.0209251 0.0209251 7.4e-05 0 0.0000 isucondition CREATE TABLE `isu` ( `id` INT8 AUTO_INCREMENT , `jia_isu_uuid` CHARACTER (?) NOT NULL UNIQUE , `name` VARCHARACTER (?) NOT NULL , `image` LONGBLOB , `character` VARCHARACTER (?) , `jia_user_id` VARCHARACTER (?) NOT NULL , `created_at` DATETIME (?) DEFAULT NOW (?) , `updated_at` DATETIME (?) DEFAULT NOW (?) ON UPDATE NOW (?) , INDEX ( `character` ) , INDEX ( `jia_user_id` ) , PRIMARY KEY ( `id` ) ) ENGINE = `InnoDB` DEFAULT CHARACTER SET = `utf8mb4`
1 0.0205474 0.0205474 0.0205474 0.0205474 0.000291 0 0.0000 isucondition ALTER TABLE `isu_condition` ADD COLUMN `condition_level` VARCHARACTER (?) AS ( CASE `CHAR_LENGTH` ( `condition` ) WHEN ? THEN ? WHEN ? THEN ? ELSE ? END ) PERSISTENT
1 0.0152741 0.0152741 0.0152741 0.0152741 0 0 0.0000 isucondition INSERT INTO `isu_condition` VALUES (...) /* , ... */
1 0.0106112 0.0106112 0.0106112 0.0106112 0.000173 0 0.0000 isucondition ALTER TABLE `isu` DROP COLUMN `image` , DROP COLUMN `created_at` , DROP COLUMN `updated_at`
1 0.0101728 0.0101728 0.0101728 0.0101728 0.009821 0 0.0000 isucondition OPTIMIZE TABLE `isu`
139 0.0098256 2.7e-05 7.0687e-05 0.0003463 0 0 0.0000 isucondition COMMIT
1 0.0083971 0.0083971 0.0083971 0.0083971 6.2e-05 0 0.0000 isucondition CREATE TABLE `isu_condition` ( `id` INT8 AUTO_INCREMENT , `jia_isu_uuid` CHARACTER (?) NOT NULL , `timestamp` DATETIME NOT NULL , `is_sitting` TINYINT (?) NOT NULL , `condition` VARCHARACTER (?) NOT NULL , `message` VARCHARACTER (?) NOT NULL , `created_at` DATETIME (?) DEFAULT NOW (?) , INDEX ( `jia_isu_uuid` , `timestamp` ) , PRIMARY KEY ( `id` ) ) ENGINE = `InnoDB` DEFAULT CHARACTER SET = `utf8mb4`
1 0.0082236 0.0082236 0.0082236 0.0082236 3.4e-05 0 0.0000 isucondition CREATE TABLE `isu_association_config` ( `name` VARCHARACTER (?) PRIMARY KEY , `url` VARCHARACTER (?) NOT NULL UNIQUE ) ENGINE = `InnoDB` DEFAULT CHARACTER SET = `utf8mb4`
143 0.0065453 1.57e-05 4.5771e-05 0.000482 0 0 0.0000 isucondition START TRANSACTION
36 0.0064794 2.83e-05 0.000179983 0.0025906 0 36 1.0000 isucondition SELECT @@`max_allowed_packet`
1 0.0062129 0.0062129 0.0062129 0.0062129 4.9e-05 0 0.0000 isucondition CREATE TABLE `user` ( `jia_user_id` VARCHARACTER (?) PRIMARY KEY , `created_at` DATETIME (?) DEFAULT NOW (?) ) ENGINE = `InnoDB` DEFAULT CHARACTER SET = `utf8mb4`
15 0.0055917 0.0002027 0.00037278 0.0007201 0.000818 375 25.0000 isucondition SELECT `character` FROM `isu` GROUP BY `character`
1 0.0021825 0.0021825 0.0021825 0.0021825 0.000177 28 28.0000 isucondition SELECT `jia_isu_uuid` , `image` FROM `isu`
6 0.0015425 0.0002311 0.000257083 0.0002897 0.000341 6 1.0000 isucondition SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = ? AND `condition_level` IN (?) AND `timestamp` < ? AND ? <= `timestamp` ORDER BY `timestamp` DESC LIMIT ?
1 0.0011034 0.0011034 0.0011034 0.0011034 4e-05 0 0.0000 isucondition DROP TABLE IF EXISTS `isu`
3 0.000925 0.0003013 0.000308333 0.0003203 0 0 0.0000 isucondition ROLLBACK
1 0.0006063 0.0006063 0.0006063 0.0006063 4.7e-05 0 0.0000 isucondition DROP TABLE IF EXISTS `isu_association_config`
2 0.0005815 0.000271 0.00029075 0.0003105 0.000218 196 98.0000 isucondition SELECT `jia_isu_uuid` FROM `isu`
1 0.0004821 0.0004821 0.0004821 0.0004821 2.6e-05 0 0.0000 isucondition DROP TABLE IF EXISTS `user`
2 0.0003285 0.0001512 0.00016425 0.0001773 7.1e-05 196 98.0000 isucondition SELECT `jia_user_id` FROM `isu`
1 0.0002801 0.0002801 0.0002801 0.0002801 0.000247 0 0.0000 isucondition LOCK TABLES `user` WRITE
4 0.000266 3.56e-05 6.65e-05 0.0001392 0 0 0.0000 isucondition UNLOCK TABLES
1 0.000225 0.000225 0.000225 0.000225 0.000145 0 0.0000 isucondition INSERT INTO `isu_association_config` ( `name` , `url` ) VALUES (...) ON DUPLICATE KEY UPDATE `url` = VALUES ( `url` )
1 0.0001835 0.0001835 0.0001835 0.0001835 0.000153 0 0.0000 isucondition LOCK TABLES `isu` WRITE
1 0.0001753 0.0001753 0.0001753 0.0001753 0.000146 0 0.0000 isucondition LOCK TABLES `isu_association_config` WRITE
1 0.0001466 0.0001466 0.0001466 0.0001466 2.4e-05 1 1.0000 isucondition SELECT * FROM `isu_association_config` WHERE `name` = ?
1 0.000146 0.000146 0.000146 0.000146 0.000119 0 0.0000 isucondition LOCK TABLES `isu_condition` WRITE
1 0.0001236 0.0001236 0.0001236 0.0001236 0 0 0.0000 isucondition INSERT INTO `user` VALUES (...) /* , ... */
1 8.96e-05 8.96e-05 8.96e-05 8.96e-05 0 0 0.0000 isucondition ALTER TABLE `isu_condition` ENABLE KEYS
1 8.48e-05 8.48e-05 8.48e-05 8.48e-05 0 0 0.0000 isucondition ALTER TABLE `isu` ENABLE KEYS
1 5.59e-05 5.59e-05 5.59e-05 5.59e-05 0 0 0.0000 isucondition ALTER TABLE `user` ENABLE KEYS
1 5.52e-05 5.52e-05 5.52e-05 5.52e-05 0 0 0.0000 isucondition ALTER TABLE `isu` DISABLE KEYS
1 5.4e-05 5.4e-05 5.4e-05 5.4e-05 0 0 0.0000 isucondition SET @? = @@`SQL_MODE` , `SQL_MODE` = ?
1 5.32e-05 5.32e-05 5.32e-05 5.32e-05 0 0 0.0000 isucondition SET `SQL_MODE` = @?
1 5.23e-05 5.23e-05 5.23e-05 5.23e-05 0 0 0.0000 isucondition SET @? = @@`CHARACTER_SET_CLIENT`
1 5.06e-05 5.06e-05 5.06e-05 5.06e-05 0 0 0.0000 isucondition ALTER TABLE `user` DISABLE KEYS
1 4.93e-05 4.93e-05 4.93e-05 4.93e-05 0 0 0.0000 isucondition SET @? = @@`FOREIGN_KEY_CHECKS` , `FOREIGN_KEY_CHECKS` = ?
1 4.81e-05 4.81e-05 4.81e-05 4.81e-05 0 0 0.0000 isucondition SET `FOREIGN_KEY_CHECKS` = @?
1 4.74e-05 4.74e-05 4.74e-05 4.74e-05 0 0 0.0000 isucondition ALTER TABLE `isu_association_config` DISABLE KEYS
1 4.7e-05 4.7e-05 4.7e-05 4.7e-05 0 0 0.0000 isucondition SET `CHARACTER_SET_CLIENT` = @?
1 4.41e-05 4.41e-05 4.41e-05 4.41e-05 0 0 0.0000 isucondition SET `TIME_ZONE` = ?
1 4.4e-05 4.4e-05 4.4e-05 4.4e-05 0 0 0.0000 isucondition ALTER TABLE `isu_association_config` ENABLE KEYS
1 4.37e-05 4.37e-05 4.37e-05 4.37e-05 0 0 0.0000 isucondition ALTER TABLE `isu_condition` DISABLE KEYS
1 4.36e-05 4.36e-05 4.36e-05 4.36e-05 0 0 0.0000 isucondition SET `CHARACTER_SET_RESULTS` = @?
1 4.24e-05 4.24e-05 4.24e-05 4.24e-05 0 0 0.0000 isucondition SET `TIME_ZONE` = @?
1 4.21e-05 4.21e-05 4.21e-05 4.21e-05 0 0 0.0000 isucondition SET @? = @@`CHARACTER_SET_RESULTS`
1 4.17e-05 4.17e-05 4.17e-05 4.17e-05 0 0 0.0000 isucondition SET `COLLATION_CONNECTION` = @?
1 3.99e-05 3.99e-05 3.99e-05 3.99e-05 0 0 0.0000 isucondition SET @? = @@`SQL_NOTES` , `SQL_NOTES` = ?
1 3.94e-05 3.94e-05 3.94e-05 3.94e-05 0 0 0.0000 isucondition SET NAMES `utf8mb4`
1 3.93e-05 3.93e-05 3.93e-05 3.93e-05 0 0 0.0000 isucondition SET `SQL_NOTES` = @?
1 3.55e-05 3.55e-05 3.55e-05 3.55e-05 0 0 0.0000 isucondition SET @? = @@`COLLATION_CONNECTION`
1 3.22e-05 3.22e-05 3.22e-05 3.22e-05 0 0 0.0000 isucondition SET @? = @@`TIME_ZONE`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment