{"id":6462,"date":"2026-06-16T13:36:02","date_gmt":"2026-06-16T04:36:02","guid":{"rendered":"https:\/\/route-zero.com\/recruit\/?post_type=route&#038;p=6462"},"modified":"2026-10-16T13:36:08","modified_gmt":"2026-10-16T04:36:08","slug":"mysql-explain-analyze-actual-rows-loops","status":"publish","type":"route","link":"https:\/\/route-zero.com\/recruit\/route\/6462\/","title":{"rendered":"MySQL EXPLAIN ANALYZE\u306e\u8aad\u307f\u65b9"},"content":{"rendered":"<p>MySQL\u306eEXPLAIN ANALYZE\u3092\u8aad\u3080\u3068\u304d\u306f\u3001\u307e\u305a\u300crows\u306e\u63a8\u5b9a\u5024\u300d\u3068\u300cactual rows\u306e\u5b9f\u6e2c\u5024\u300d\u3001\u6b21\u306b\u300cactual time\u300d\u3068\u300cloops\u300d\u3092\u6bd4\u3079\u307e\u3059\u3002EXPLAIN ANALYZE\u306f\u30af\u30a8\u30ea\u3092\u5b9f\u969b\u306b\u5b9f\u884c\u3057\u3066TREE\u5f62\u5f0f\u306e\u5b9f\u884c\u8a08\u753b\u3092\u8fd4\u3059\u305f\u3081\u3001\u5358\u306a\u308bEXPLAIN\u3088\u308a\u5b9f\u884c\u6642\u306e\u6319\u52d5\u3092\u78ba\u8a8d\u3057\u3084\u3059\u304f\u306a\u308a\u307e\u3059\u3002\u305f\u3060\u3057\u5b9f\u969b\u306bSQL\u3092\u52d5\u304b\u3059\u306e\u3067\u3001\u672c\u756a\u30c7\u30fc\u30bf\u3067\u306f\u8ca0\u8377\u3068\u5bfe\u8c61\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n<h2>EXPLAIN ANALYZE\u304c\u5206\u304b\u308b\u3053\u3068<\/h2>\n<p>\u5b9f\u884c\u8a08\u753b\u306b\u306f\u300cMySQL\u304c\u3069\u306e\u51e6\u7406\u3092\u3001\u3069\u306e\u9806\u756a\u3067\u3001\u4f55\u4ef6\u307b\u3069\u6271\u3046\u3068\u898b\u7a4d\u3082\u3063\u305f\u304b\u300d\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002EXPLAIN ANALYZE\u3067\u306f\u3001\u5404\u51e6\u7406\uff08\u30a4\u30c6\u30ec\u30fc\u30bf\uff09\u304c\u5b9f\u969b\u306b\u8fd4\u3057\u305f\u884c\u6570\u3084\u7d4c\u904e\u6642\u9593\u3001\u53cd\u5fa9\u56de\u6570\u3082\u8868\u793a\u3055\u308c\u308b\u305f\u3081\u3001\u898b\u7a4d\u3082\u308a\u3068\u306e\u5dee\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n<table>\n<thead>\n<tr>\n<th>\u8868\u793a\u9805\u76ee<\/th>\n<th>\u610f\u5473<\/th>\n<th>\u898b\u308b\u3079\u304d\u30dd\u30a4\u30f3\u30c8<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>cost<\/td>\n<td>\u30aa\u30d7\u30c6\u30a3\u30de\u30a4\u30b6\u306e\u63a8\u5b9a\u30b3\u30b9\u30c8<\/td>\n<td>\u5b9f\u6642\u9593ms\u3067\u306f\u306a\u3044<\/td>\n<\/tr>\n<tr>\n<td>rows<\/td>\n<td>\u63a8\u5b9a\u3055\u308c\u308b\u884c\u6570<\/td>\n<td>actual rows\u3068\u306e\u5dee<\/td>\n<\/tr>\n<tr>\n<td>actual time=a..b<\/td>\n<td>\u6700\u521d\u306e\u884c\u3068\u51e6\u7406\u5b8c\u4e86\u307e\u3067\u306e\u5b9f\u6e2c\u6642\u9593\uff08\u30df\u30ea\u79d2\uff09<\/td>\n<td>\u6642\u9593\u306e\u5927\u304d\u3044\u51e6\u7406\u3092\u63a2\u3059<\/td>\n<\/tr>\n<tr>\n<td>actual rows<\/td>\n<td>\u5b9f\u969b\u306b\u8fd4\u3057\u305f\u884c\u6570<\/td>\n<td>\u63a8\u5b9a\u3068\u3069\u308c\u3060\u3051\u9055\u3046\u304b<\/td>\n<\/tr>\n<tr>\n<td>loops<\/td>\n<td>\u305d\u306e\u51e6\u7406\u3092\u5b9f\u884c\u3057\u305f\u56de\u6570<\/td>\n<td>\u7e70\u308a\u8fd4\u3057\u30b3\u30b9\u30c8\u3092\u898b\u9003\u3055\u306a\u3044<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<blockquote>\n<p><strong>\u7528\u8a9e\u89e3\u8aac\uff1a\u30a4\u30c6\u30ec\u30fc\u30bf<\/strong><br \/>\u5b9f\u884c\u8a08\u753b\u306eTable scan\u3001Filter\u3001Index lookup\u3001Join\u306a\u3069\u500b\u3005\u306e\u51e6\u7406\u5358\u4f4d\u3002TREE\u306e\u5165\u308c\u5b50\u3067\u89aa\u5b50\u95a2\u4fc2\u3092\u8868\u3057\u307e\u3059\u3002<\/p>\n<\/blockquote>\n<hr>\n<h2>\u307e\u305aSELECT\u306b\u4ed8\u3051\u3066\u5b9f\u884c\u3059\u308b<\/h2>\n<p>MySQL 8.4\u306e\u4f8b\u3067\u3059\u3002\u691c\u8a3c\u53ef\u80fd\u306a\u74b0\u5883\u3067\u3001\u307e\u305a\u901a\u5e38\u306eEXPLAIN\u3067\u5b9f\u884c\u8a08\u753b\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\u305d\u306e\u5f8c\u3001\u5b9f\u884c\u8ca0\u8377\u3092\u628a\u63e1\u3057\u305f\u3046\u3048\u3067EXPLAIN ANALYZE\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<pre><code>EXPLAIN\r\nSELECT id, customer_id, ordered_at\r\nFROM orders\r\nWHERE customer_id = 42\r\nORDER BY ordered_at DESC\r\nLIMIT 20;\r\n\r\nEXPLAIN ANALYZE FORMAT=TREE\r\nSELECT id, customer_id, ordered_at\r\nFROM orders\r\nWHERE customer_id = 42\r\nORDER BY ordered_at DESC\r\nLIMIT 20;<\/code><\/pre>\n<p>orders\u306f\u30b5\u30f3\u30d7\u30eb\u306e\u4eee\u60f3\u30c6\u30fc\u30d6\u30eb\u540d\u3067\u3059\u3002\u5b9f\u74b0\u5883\u306e\u30c6\u30fc\u30d6\u30eb\u30fb\u5217\u540d\u306b\u7f6e\u304d\u63db\u3048\u307e\u3059\u3002EXPLAIN ANALYZE\u306fSQL\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002\u66f4\u65b0\u3092\u4f34\u3046\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3078\u7121\u6761\u4ef6\u306b\u4f7f\u7528\u305b\u305a\u3001\u5b9f\u884c\u6a29\u9650\u30fb\u8ca0\u8377\u30fb\u74b0\u5883\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>MySQL 8.4\u3067\u306fEXPLAIN ANALYZE\u306e\u51fa\u529b\u306fTREE\u5f62\u5f0f\u3067\u3059\u3002FORMAT=JSON\u307e\u305f\u306fFORMAT=TRADITIONAL\u3092\u6307\u5b9a\u3059\u308b\u3068\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<hr>\n<h2>\u63a8\u5b9arows\u3068actual rows\u306e\u5dee\u3092\u8aad\u3080<\/h2>\n<p>\u8868\u793a\u4f8b\u306e\u30a4\u30e1\u30fc\u30b8\u306f\u6b21\u306e\u5f62\u3067\u3059\u3002\u4ee5\u4e0b\u306e\u884c\u6570\u3068\u6642\u9593\u306f\u8aac\u660e\u7528\u306e\u67b6\u7a7a\u5024\u3067\u3042\u308a\u3001\u5b9f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u8a08\u6e2c\u3057\u305f\u7d50\u679c\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<pre><code>-&gt; Filter: (orders.customer_id = 42)\r\n   (cost=420 rows=100)\r\n   (actual time=0.5..35.0 rows=5000 loops=1)\r\n    -&gt; Table scan on orders\r\n       (cost=1200 rows=100000)\r\n       (actual time=0.3..25.0 rows=100000 loops=1)<\/code><\/pre>\n<p>\u3053\u3053\u3067\u306fFilter\u304c\u8fd4\u3059\u884c\u6570\u306e\u898b\u7a4d\u3082\u308a\u304c100\u4ef6\u3001\u5b9f\u6e2c\u304c5000\u4ef6\u3067\u3059\u3002\u898b\u7a4d\u3082\u308a\u306e\u305a\u308c\u304c\u5927\u304d\u3044\u5834\u5408\u3001\u7d71\u8a08\u60c5\u5831\u306e\u9bae\u5ea6\u3084\u5217\u306e\u5024\u306e\u504f\u308a\u3001\u7d5e\u308a\u8fbc\u307f\u6761\u4ef6\u3068\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u9069\u5408\u3092\u8abf\u3079\u308b\u624b\u639b\u304b\u308a\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u305f\u3060\u3057\u300c\u305a\u308c\u304c\u5927\u304d\u3044\uff1d\u5fc5\u305a\u305d\u306eSQL\u304c\u9045\u3044\u300d\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002\u307e\u305a\u5b9f\u884c\u8ca0\u8377\u306e\u5927\u304d\u3044\u51e6\u7406\u3092\u628a\u63e1\u3057\u3001\u884c\u6570\u5dee\u306f\u539f\u56e0\u5019\u88dc\u3092\u7d5e\u308a\u8fbc\u3080\u6307\u6a19\u3068\u3057\u3066\u4f7f\u3044\u307e\u3059\u3002<\/p>\n<hr>\n<h2>actual time\u306f\u89aa\u5b50\u3068loops\u3082\u78ba\u8a8d\u3059\u308b<\/h2>\n<p>actual time\u306f\u5404\u30a4\u30c6\u30ec\u30fc\u30bf\u3067\u6700\u521d\u306e\u884c\u3092\u8fd4\u3059\u307e\u3067\u3068\u3001\u51e6\u7406\u5b8c\u4e86\u307e\u3067\u306b\u304b\u304b\u3063\u305f\u6642\u9593\u3092\u30df\u30ea\u79d2\u3067\u793a\u3057\u307e\u3059\u3002loops\u304c\u8907\u6570\u3042\u308b\u5834\u5408\u3001\u6642\u9593\u306f1\u56de\u3042\u305f\u308a\u306e\u5e73\u5747\u3068\u3057\u3066\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<table>\n<thead>\n<tr>\n<th>\u8868\u793a<\/th>\n<th>\u8aad\u3080\u30dd\u30a4\u30f3\u30c8<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>actual time=0.2..12.0<\/td>\n<td>\u6700\u521d\u306e\u884c\u304c\u8fd4\u308b\u307e\u3067\u7d040.2ms\u3001\u5b8c\u4e86\u307e\u3067\u7d0412ms<\/td>\n<\/tr>\n<tr>\n<td>rows=20 loops=1<\/td>\n<td>\u305d\u306e\u51e6\u7406\u304c\u8fd4\u3057\u305f\u884c\u6570\u3068\u53cd\u5fa9\u56de\u6570<\/td>\n<\/tr>\n<tr>\n<td>rows=2 loops=1000<\/td>\n<td>\u53cd\u5fa9\u51e6\u7406\u304c\u591a\u3044\u3002\u884c\u6570\u3084\u6642\u9593\u30921\u56de\u5206\u3060\u3051\u3067\u5224\u65ad\u3057\u306a\u3044<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>TREE\u306f\u5165\u308c\u5b50\u69cb\u9020\u3067\u3059\u3002\u5b50\u51e6\u7406\u3092\u542b\u3080\u89aa\u51e6\u7406\u306e\u6642\u9593\u3068\u5b50\u51e6\u7406\u306e\u6642\u9593\u3092\u3001\u5358\u7d14\u306b\u3059\u3079\u3066\u8db3\u3057\u3066SQL\u5168\u4f53\u306e\u6240\u8981\u6642\u9593\u3060\u3068\u5224\u65ad\u3057\u306a\u3044\u3088\u3046\u306b\u3057\u307e\u3059\u3002\u30cd\u30b9\u30c8\u3057\u305f\u30eb\u30fc\u30d7\u3067\u306floops\u306e\u591a\u3044\u5185\u5074\u306eIndex lookup\u306a\u3069\u3082\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<h2>Table scan\u3068Index lookup\u3067\u5224\u65ad\u3059\u308b<\/h2>\n<p>\u5b9f\u884c\u8a08\u753b\u306bTable scan\u304c\u3042\u308b\u3068\u5373\u5ea7\u306b\u60aa\u3044\u3068\u8003\u3048\u304c\u3061\u3067\u3059\u304c\u3001\u30c6\u30fc\u30d6\u30eb\u304c\u5c0f\u3055\u3044\u5834\u5408\u3084\u591a\u304f\u306e\u884c\u3092\u8aad\u3080\u5fc5\u8981\u304c\u3042\u308b\u5834\u5408\u3001\u5168\u8868\u8d70\u67fb\u304c\u59a5\u5f53\u306a\u3053\u3068\u3082\u3042\u308a\u307e\u3059\u3002\u307e\u305a\u691c\u7d22\u6761\u4ef6\u3067\u7d5e\u3063\u305f\u884c\u6570\u3068\u5b9f\u6e2c\u6642\u9593\u3092\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n<ul>\n<li>WHERE\u3067\u4f7f\u3046\u5217\u306b\u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u5b58\u5728\u3059\u308b\u304b\u78ba\u8a8d\u3059\u308b\u3002<\/li>\n<li>ORDER BY\u3068WHERE\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u5408\u3046\u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304b\u8003\u3048\u308b\u3002<\/li>\n<li>SELECT *\u3067\u4e0d\u8981\u306a\u5217\u3092\u5927\u91cf\u306b\u8aad\u307f\u8fbc\u3093\u3067\u3044\u306a\u3044\u304b\u78ba\u8a8d\u3059\u308b\u3002<\/li>\n<li>LIMIT\u304c\u3042\u3063\u3066\u3082\u4e26\u3073\u66ff\u3048\u3084\u524d\u6bb5\u306e\u8d70\u67fb\u306b\u6642\u9593\u304c\u639b\u304b\u3063\u3066\u3044\u306a\u3044\u304b\u898b\u308b\u3002<\/li>\n<li>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u5897\u3084\u3059\u524d\u306b\u66f4\u65b0\u51e6\u7406\u30fb\u5bb9\u91cf\u30fb\u65e2\u5b58\u30af\u30a8\u30ea\u3078\u306e\u5f71\u97ff\u3092\u691c\u8a3c\u3059\u308b\u3002<\/li>\n<\/ul>\n<p>\u6761\u4ef6\u304ccustomer_id\u3067\u7d5e\u308a\u8fbc\u307f\u3001ordered_at\u3067\u4e26\u3073\u66ff\u3048\u306a\u3089\u3001(customer_id, ordered_at) \u306e\u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u691c\u8a0e\u5019\u88dc\u3067\u3059\u3002\u305f\u3060\u3057\u6700\u9069\u89e3\u306f\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u30fb\u30c7\u30fc\u30bf\u5206\u5e03\u30fb\u5b9f\u969b\u306e\u5b9f\u884c\u8a08\u753b\u306b\u4f9d\u5b58\u3057\u307e\u3059\u3002<\/p>\n<h2>\u63a8\u5b9a\u5024\u304c\u5916\u308c\u308b\u3068\u304d\u306e\u8abf\u67fb\u9806<\/h2>\n<ul>\n<li>\u5b9f\u969b\u306e\u5b9f\u884c\u74b0\u5883\u3067SQL\u6761\u4ef6\u3068\u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u78ba\u8a8d\u3059\u308b\u3002<\/li>\n<li>EXPLAIN\u3068EXPLAIN ANALYZE\u306eTREE\u51fa\u529b\u304b\u3089\u3001\u5927\u304d\u306a\u884c\u6570\u5dee\u30fbloops\u30fb\u6642\u9593\u3092\u78ba\u8a8d\u3059\u308b\u3002<\/li>\n<li>\u8a72\u5f53\u5217\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3001\u578b\u3001WHERE\u6761\u4ef6\u3001ORDER BY\u3092\u78ba\u8a8d\u3059\u308b\u3002<\/li>\n<li>\u7d71\u8a08\u60c5\u5831\u304c\u53e4\u3044\u53ef\u80fd\u6027\u3092\u691c\u8a0e\u3057\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066ANALYZE TABLE\u306e\u9069\u7528\u5f71\u97ff\u3092\u8abf\u3079\u308b\u3002<\/li>\n<li>SQL\u3084\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u5909\u66f4\u3059\u308b\u306a\u3089\u3001\u5909\u66f4\u524d\u5f8c\u3067\u540c\u3058\u5165\u529b\u6761\u4ef6\u306e\u5b9f\u6e2c\u5024\u3092\u6bd4\u8f03\u3059\u308b\u3002<\/li>\n<\/ul>\n<p>\u672c\u756a\u3067EXPLAIN ANALYZE\u3092\u7e70\u308a\u8fd4\u3059\u3068\u8ca0\u8377\u306b\u3064\u306a\u304c\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u65e2\u77e5\u306e\u91cd\u3044SQL\u306f\u691c\u8a3c\u74b0\u5883\u3067\u518d\u73fe\u3059\u308b\u304b\u3001\u5b9f\u884c\u30bf\u30a4\u30df\u30f3\u30b0\u3092\u7ba1\u7406\u3057\u305f\u3046\u3048\u3067\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<h2>\u95a2\u9023\u3059\u308bSQL\u306e\u8a18\u4e8b<\/h2>\n<p>\u5b9f\u884c\u8a08\u753b\u3092\u8aad\u3093\u3060\u5f8c\u3001SQL\u306e\u6539\u5584\u624b\u9806\u306b\u9032\u307f\u305f\u3044\u5834\u5408\u306fSQL\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u306e\u5168\u4f53\u50cf\u304c\u53c2\u8003\u306b\u306a\u308a\u307e\u3059\u3002\u307e\u305fJOIN\u306e\u7d50\u5408\u6761\u4ef6\u304c\u30cd\u30c3\u30af\u306a\u3089\u3001\u57fa\u672c\u7684\u306aJOIN\u306e\u4ed5\u7d44\u307f\u3092\u6574\u7406\u3059\u308b\u3068\u539f\u56e0\u3092\u7d5e\u308a\u3084\u3059\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\uff08SQL\u6539\u5584\u306e\u624b\u9806\u306b\u3064\u3044\u3066\u306f\u300e<a href=\"https:\/\/route-zero.com\/recruit\/route\/1650\/\">SQL\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u3068\u306f\uff1f\u9045\u3044SQL\u3092\u6700\u77ed\u3067\u6539\u5584\u3059\u308b3\u3064\u306e\u624b\u9806<\/a>\u300f\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\uff09<\/p>\n<p>\uff08JOIN\u306e\u4ed5\u7d44\u307f\u306b\u3064\u3044\u3066\u306f\u300e<a href=\"https:\/\/route-zero.com\/recruit\/route\/1119\/\">SQL JOIN\u306e\u57fa\u672c\u304b\u3089\u5b9f\u8df5\u307e\u3067\uff5cINNER\u30fbLEFT\u30fbRIGHT\u30fbOUTER JOIN\u306e\u9055\u3044\u3092\u308f\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac<\/a>\u300f\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\uff09<\/p>\n<h2>\u3088\u304f\u3042\u308b\u7591\u554f<\/h2>\n<h3>EXPLAIN\u3068EXPLAIN ANALYZE\u306f\u4f55\u304c\u9055\u3046\uff1f<\/h3>\n<p>EXPLAIN\u306f\u4e3b\u306b\u30aa\u30d7\u30c6\u30a3\u30de\u30a4\u30b6\u306e\u5b9f\u884c\u8a08\u753b\u3092\u8868\u793a\u3057\u307e\u3059\u3002EXPLAIN ANALYZE\u306f\u5bfe\u8c61SQL\u3092\u5b9f\u884c\u3057\u3066\u5b9f\u6e2c\u5024\u3092\u52a0\u3048\u307e\u3059\u3002<\/p>\n<h3>rows\u3068actual rows\u304c\u9055\u3046\u3068\u5fc5\u305a\u9045\u3044\uff1f<\/h3>\n<p>\u3044\u3044\u3048\u3002\u898b\u7a4d\u3082\u308a\u3068\u306e\u5dee\u306f\u8abf\u67fb\u306e\u624b\u639b\u304b\u308a\u3067\u3059\u304c\u3001\u6642\u9593\u3001loops\u3001\u5b9f\u969b\u306e\u51e6\u7406\u5185\u5bb9\u3068\u4f75\u305b\u3066\u5224\u65ad\u3057\u307e\u3059\u3002<\/p>\n<h3>EXPLAIN ANALYZE\u306fSELECT\u3060\u3051\uff1f<\/h3>\n<p>MySQL 8.4\u306e\u516c\u5f0f\u30de\u30cb\u30e5\u30a2\u30eb\u3067\u306f\u3001SELECT\u306e\u307b\u304b\u8907\u6570\u30c6\u30fc\u30d6\u30ebUPDATE\u30fbDELETE\u3001TABLE\u6587\u3082\u5bfe\u8c61\u306b\u542b\u307e\u308c\u307e\u3059\u3002\u66f4\u65b0\u7cfb\u306f\u5b9f\u969b\u306b\u51e6\u7406\u3092\u52d5\u304b\u3059\u70b9\u306b\u7279\u306b\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u9045\u3044SQL\u306e\u539f\u56e0\u3092\u63a2\u308b\u3068\u304d\u306f\u3001\u63a8\u5b9arows\u3068actual rows\u3001actual time\u3001loops\u3092\u30bb\u30c3\u30c8\u3067\u8aad\u3080\u3053\u3068\u304c\u57fa\u672c\u3067\u3059\u3002\u6700\u521d\u304b\u3089\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u8ffd\u52a0\u3059\u308b\u306e\u3067\u306f\u306a\u304f\u3001\u3069\u306e\u30a4\u30c6\u30ec\u30fc\u30bf\u306b\u6642\u9593\u304c\u304b\u304b\u308a\u3001\u898b\u7a4d\u3082\u308a\u3068\u5b9f\u6e2c\u304c\u3069\u3053\u3067\u305a\u308c\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3059\u308b\u3068\u3053\u308d\u304b\u3089\u59cb\u3081\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u307e\u305a\u306f\u691c\u8a3c\u7528\u306eSELECT\u306bEXPLAIN\u3092\u4ed8\u3051\u3001\u5b9f\u884c\u8a08\u753b\u306e\u8aad\u307f\u65b9\u3092\u4e00\u3064\u305a\u3064\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n","protected":false},"featured_media":6465,"template":"","meta":{"ssp_meta_title":"MySQL EXPLAIN ANALYZE\u306e\u8aad\u307f\u65b9\uff5cactual rows\u3068\u5b9f\u884c\u6642\u9593","ssp_meta_description":"MySQL EXPLAIN ANALYZE\u306e\u5b9f\u884c\u8a08\u753b\u3092\u8aad\u307f\u89e3\u304f\u624b\u9806\u3002\u63a8\u5b9arows\u3068actual rows\u306e\u9055\u3044\u3001actual time\u3001loops\u3001Table scan\u3068Index lookup\u306e\u5224\u65ad\u30dd\u30a4\u30f3\u30c8\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002","ssp_meta_keyword":"MySQL EXPLAIN ANALYZE actual rows,EXPLAIN ANALYZE \u8aad\u307f\u65b9,MySQL \u5b9f\u884c\u8a08\u753b,actual time loops,SQL \u30c1\u30e5\u30fc\u30cb\u30f3\u30b0,\u63a8\u5b9a rows \u5b9f\u6e2c","ssp_meta_canonical":""},"route_category":[9],"_links":{"self":[{"href":"https:\/\/route-zero.com\/recruit\/wp-json\/wp\/v2\/route\/6462"}],"collection":[{"href":"https:\/\/route-zero.com\/recruit\/wp-json\/wp\/v2\/route"}],"about":[{"href":"https:\/\/route-zero.com\/recruit\/wp-json\/wp\/v2\/types\/route"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/route-zero.com\/recruit\/wp-json\/wp\/v2\/media\/6465"}],"wp:attachment":[{"href":"https:\/\/route-zero.com\/recruit\/wp-json\/wp\/v2\/media?parent=6462"}],"wp:term":[{"taxonomy":"route_category","embeddable":true,"href":"https:\/\/route-zero.com\/recruit\/wp-json\/wp\/v2\/route_category?post=6462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}