MariaDB [mariadb_bug_test]> analyze format=JSON SELECT a.reference_number, b.validation_date FROM table_a a LEFT OUTER JOIN table_b b ON (a.id = b.fk_id);
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ANALYZE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {
  "query_optimization": {
    "r_total_time_ms": 0.126817962
  },
  "query_block": {
    "select_id": 1,
    "cost": 404114.5273,
    "r_loops": 1,
    "r_total_time_ms": 124018.9438,
    "const_condition": "1",
    "nested_loop": [
      {
        "table": {
          "table_name": "a",
          "access_type": "ALL",
          "loops": 1,
          "r_loops": 1,
          "rows": 24879,
          "r_rows": 25000,
          "cost": 4.1481926,
          "r_table_time_ms": 3.194195545,
          "r_other_time_ms": 2.726855351,
          "r_engine_stats": {
            "pages_accessed": 59
          },
          "filtered": 100,
          "r_total_filtered": 100,
          "r_filtered": 100
        }
      },
      {
        "block-nl-join": {
          "table": {
            "table_name": "b",
            "access_type": "ALL",
            "possible_keys": ["idx_fk"],
            "loops": 24879,
            "r_loops": 2,
            "rows": 99484,
            "r_rows": 100000,
            "cost": 404110.3791,
            "r_table_time_ms": 18.49004901,
            "r_other_time_ms": 4.911581442,
            "r_engine_stats": {
              "pages_accessed": 750
            },
            "filtered": 75,
            "r_total_filtered": 100,
            "r_filtered": 100
          },
          "buffer_type": "flat",
          "buffer_size": "256Kb",
          "join_type": "BNL",
          "attached_condition": "trigcond(b.fk_id = a.`id`)",
          "r_loops": 25000,
          "r_filtered": 0.00499996,
          "r_unpack_time_ms": 85976.97167,
          "r_other_time_ms": 38012.64235,
          "r_effective_rows": 100000
        }
      }
    ]
  }
} |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+