Skip to content

Instantly share code, notes, and snippets.

@caiquearaujo
Created October 27, 2024 08:25
Show Gist options
  • Save caiquearaujo/78e40084aa952945b3f901b3f93ade68 to your computer and use it in GitHub Desktop.
Save caiquearaujo/78e40084aa952945b3f901b3f93ade68 to your computer and use it in GitHub Desktop.
CPFS/JSON table_e
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "237393.90"
},
"table": {
"table_name": "table_e",
"access_type": "ALL",
"rows_examined_per_scan": 2290949,
"rows_produced_per_join": 229094,
"filtered": "10.00",
"cost_info": {
"read_cost": "214484.41",
"eval_cost": "22909.49",
"prefix_cost": "237393.90",
"data_read_per_join": "10M"
},
"used_columns": [
"cpf"
],
"attached_condition": "(`cpfs_data`.`table_e`.`cpf` = '99786051285')"
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment