MySQL Forums
Forum List  »  Optimizer & Parser

Explain features
Posted by: Michael Bialik
Date: March 29, 2020 01:29PM

I'm posting a simple explain:

explain format= json select * from a
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "21.00"
"table": {
"table_name": "a",
"access_type": "ALL",
"rows_examined_per_scan": 200,
"rows_produced_per_join": 200,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "20.00",
"prefix_cost": "21.00",
"data_read_per_join": "54K"
"used_columns": [

As you can see there is no mentioning of schema name [sakila] and the original table name [actor] in the explain text (table alias is used instead.

Is it possible to display these values as part of explain?

Options: ReplyQuote

Written By
Explain features
March 29, 2020 01:29PM
March 29, 2020 02:01PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.