gistfile1.txt

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
        }
      }
    ]
  }
} |