Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
analyze format=json select count(t2.b) from t1, t2 where t2.a=t1.a;
| {
"query_block": {
"select_id": 1,
"r_loops": 1,
"r_total_time_ms": 579.7733801,
"nested_loop": [
{
"table": {
"table_name": "t2",
"access_type": "ALL",
"r_loops": 1,
"rows": 1,
"r_rows": 1000,
"r_table_time_ms": 5.619124421,
"r_other_time_ms": 0.615788176,
"filtered": 100,
"r_filtered": 100
}
},
{
"block-nl-join": {
"table": {
"table_name": "t1",
"access_type": "ALL",
"r_loops": 77,
"rows": 9,
"r_rows": 1000,
"r_table_time_ms": 363.7647252,
"r_other_time_ms": 8.393784256,
"filtered": 100,
"r_filtered": 100
},
"buffer_type": "flat",
"buffer_size": "119",
"join_type": "BNL",
"attached_condition": "t1.a = t2.a",
"r_filtered": 0.1,
"r_unpack_time_ms": 44.69024173
}
}
]
}
} |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment