Skip to content

Instantly share code, notes, and snippets.

@caiquearaujo
Created October 27, 2024 08:25
Show Gist options
  • Save caiquearaujo/bc427849f32dfefcbaa59e7cfb589450 to your computer and use it in GitHub Desktop.
Save caiquearaujo/bc427849f32dfefcbaa59e7cfb589450 to your computer and use it in GitHub Desktop.
CPFS/JSON table_g
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "235662.70"
},
"table": {
"table_name": "table_g",
"access_type": "ALL",
"rows_examined_per_scan": 2255067,
"rows_produced_per_join": 22550,
"filtered": "1.00",
"cost_info": {
"read_cost": "233407.63",
"eval_cost": "2255.07",
"prefix_cost": "235662.70",
"data_read_per_join": "1M"
},
"used_columns": [
"cpf",
"crc32"
],
"attached_condition": "((`cpfs_data`.`table_g`.`cpf` = '99786051285') and (`cpfs_data`.`table_g`.`crc32` = 946011781))"
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment