gistfile1.txt

{
  "query_optimization": {
    "r_total_time_ms": 0.171497634
  },
  "query_block": {
    "select_id": 1,
    "cost": 0.28237866,
    "r_loops": 1,
    "r_total_time_ms": 1.246360326,
    "nested_loop": [
      {
        "table": {
          "table_name": "A",
          "access_type": "ALL",
          "loops": 1,
          "r_loops": 1,
          "rows": 10,
          "r_rows": 10,
          "cost": 0.0124848,
          "r_table_time_ms": 0.044220078,
          "r_other_time_ms": 0.011891095,
          "r_engine_stats": {
            "pages_accessed": 1
          },
          "filtered": 100,
          "r_filtered": 100
        }
      },
      {
        "block-nl-join": {
          "table": {
            "table_name": "B",
            "access_type": "hash_ALL",
            "key": "#hash#$hj",
            "key_length": "4",
            "used_key_parts": ["a"],
            "ref": ["test.A.a"],
            "loops": 10,
            "r_loops": 1,
            "rows": 1000,
            "r_rows": 1000,
            "cost": 0.26989386,
            "r_table_time_ms": 0.85519374,
            "r_other_time_ms": 0.31530814,
            "r_engine_stats": {
              "pages_accessed": 4
            },
            "filtered": 10,
            "r_filtered": 100
          },
          "buffer_type": "flat",
          "buffer_size": "305",
          "join_type": "BNLH",
          "attached_condition": "B.a = A.a",
          "r_loops": 10,
          "r_filtered": 100,
          "r_unpack_time_ms": 0.002015506,
          "r_other_time_ms": 0.007093041,
          "r_effective_rows": 1
        }
      }
    ]
  }
}