Skip to content

Instantly share code, notes, and snippets.

@spetrunia
Created June 22, 2020 11:42
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 spetrunia/257c929b0c04a866faf6428e733999ad to your computer and use it in GitHub Desktop.
Save spetrunia/257c929b0c04a866faf6428e733999ad to your computer and use it in GitHub Desktop.
+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+---------------------------------------------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+---------------------------------------------+
| 1 | SIMPLE | T | NULL | ALL | NULL | NULL | NULL | NULL | 2 | 100.00 | Table function: json_table; Using temporary |
+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+---------------------------------------------+
| {
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.72"
},
"table": {
"table_name": "T",
"access_type": "ALL",
"rows_examined_per_scan": 2,
"rows_produced_per_join": 2,
"filtered": "100.00",
"table_function": "json_table",
"using_temporary_table": true,
"cost_info": {
"read_cost": "2.52",
"eval_cost": "0.20",
"prefix_cost": "2.73",
"data_read_per_join": "864"
},
"used_columns": [
"color",
"price",
"seq"
]
}
}
} |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment