MariaDB [m8]> analyze format=json select * from s1 join s2 on(1); +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ANALYZE | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | { "query_optimization": { "r_total_time_ms": 0.129160914 }, "query_block": { "select_id": 1, "cost": 186.3112688, "r_loops": 1, "r_total_time_ms": 189.4777384, "nested_loop": [ { "table": { "table_name": "s1", "access_type": "ALL", "loops": 1, "r_loops": 1, "rows": 1000, "r_rows": 1000, "cost": 0.1764192, "r_table_time_ms": 0.272653457, "r_other_time_ms": 0.118454075, "r_engine_stats": { "pages_accessed": 4 }, "filtered": 100, "r_total_filtered": 100, "r_filtered": 100 } }, { "block-nl-join": { "table": { "table_name": "s2", "access_type": "ALL", "loops": 1000, "r_loops": 1, "rows": 2000, "r_rows": 2000, "cost": 186.1348496, "r_table_time_ms": 0.336981606, "r_other_time_ms": 0.059067544, "r_engine_stats": { "pages_accessed": 7 }, "filtered": 100, "r_total_filtered": 100, "r_filtered": 100 }, "buffer_type": "flat", "buffer_size": "214KiB", "join_type": "BNL", "r_loops": 1000, "r_filtered": 100, "r_unpack_time_ms": 83.67562578, "r_other_time_ms": 105.0027352, "r_effective_rows": 2000 } } ] } } | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.190 sec) MariaDB [m8]> notee