MariaDB [m8]> analyze format=json select * from s1 join s2 on(1); +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ANALYZE | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | { "query_optimization": { "r_total_time_ms": 0.137051821 }, "query_block": { "select_id": 1, "cost": 186.3112688, "r_loops": 1, "r_total_time_ms": 2173.863, "nested_loop": [ { "table": { "table_name": "s1", "access_type": "ALL_parallel", "loops": 1, "r_loops": 1, "rows": 1000, "r_rows": 1000, "r_rows_per_worker": ["214", "428", "358", "0"], "r_engine_time_per_worker_ms": [ "0.12247425", "0.142437742", 0.10952579, 0 ], "r_peak_to_average_ratio": 1.521617196, "r_chunks": 3, "r_chunks_resplit": 0, "cost": 0.1764192, "r_engine_stats": { "pages_accessed": 10 }, "filtered": 100, "r_total_filtered": 100, "r_filtered": 100 } }, { "block-nl-join": { "table": { "table_name": "s2", "access_type": "ALL", "loops": 1000, "r_loops": 1000, "rows": 2000, "r_rows": 2000, "r_rows_per_worker": ["428000", "856000", "716000", "0"], "r_engine_time_per_worker_ms": [ "74.29011387", "118.3773955", 118.2047596, 0 ], "r_peak_to_average_ratio": 1.523164429, "cost": 186.1348496, "r_engine_stats": { "pages_accessed": 7000 }, "filtered": 100, "r_total_filtered": 100, "r_filtered": 100 }, "buffer_type": "flat", "buffer_size": "214KiB", "join_type": "BNL", "r_loops": 0, "r_filtered": null, "r_unpack_time_ms": 0, "r_other_time_ms": 0, "r_effective_rows": null } } ] } } | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (2.167 sec) MariaDB [m8]> notee