{
  "job": {
    "id": "schema_diamond_16_chain_control",
    "kind": "my",
    "keys": [
      "my_old",
      "my_new"
    ],
    "sql": "SELECT JSON_SCHEMA_VALID('{\"type\":\"integer\",\"definitions\":{\"d0\":{\"allOf\":[{\"$ref\":\"#/definitions/d1\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d1\":{\"allOf\":[{\"$ref\":\"#/definitions/d2\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d2\":{\"allOf\":[{\"$ref\":\"#/definitions/d3\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d3\":{\"allOf\":[{\"$ref\":\"#/definitions/d4\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d4\":{\"allOf\":[{\"$ref\":\"#/definitions/d5\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d5\":{\"allOf\":[{\"$ref\":\"#/definitions/d6\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d6\":{\"allOf\":[{\"$ref\":\"#/definitions/d7\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d7\":{\"allOf\":[{\"$ref\":\"#/definitions/d8\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d8\":{\"allOf\":[{\"$ref\":\"#/definitions/d9\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d9\":{\"allOf\":[{\"$ref\":\"#/definitions/d10\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d10\":{\"allOf\":[{\"$ref\":\"#/definitions/d11\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d11\":{\"allOf\":[{\"$ref\":\"#/definitions/d12\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d12\":{\"allOf\":[{\"$ref\":\"#/definitions/d13\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d13\":{\"allOf\":[{\"$ref\":\"#/definitions/d14\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d14\":{\"allOf\":[{\"$ref\":\"#/definitions/d15\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d15\":{\"allOf\":[{\"$ref\":\"#/definitions/d16\"},{\"$ref\":\"#/definitions/terminal\"}]},\"d16\":{\"type\":\"integer\"},\"terminal\":{\"type\":\"integer\"}}}','1')",
    "expected": [
      [
        1
      ]
    ],
    "rounds": 3,
    "per_round": 20,
    "warmup": 3,
    "timeout_s": 10,
    "explain": false,
    "fixture_identity": "unused_definitions_layered_dag_16_False",
    "repeat_reason": "Distinct layered sharing complexity boundary beyond prior flat16/64; matched nonshared root semantics control. Measures whole statement including schema preparation, not table scan."
  },
  "started": "2026-10-21T00:12:01.151106+00:00",
  "rounds": [
    {
      "round": 0,
      "keys": [
        "my_old",
        "my_new"
      ],
      "raw_ms": {
        "my_old": [
          0.7771,
          0.8699,
          0.8333,
          0.7447,
          0.7942,
          0.8197,
          0.7904,
          0.7707,
          0.7623,
          0.8618,
          0.8702,
          0.769,
          0.7884,
          0.8417,
          0.744,
          0.7949,
          0.7959,
          0.8366,
          0.9381,
          0.8133
        ],
        "my_new": [
          0.8088,
          1.1157,
          0.8418,
          0.8108,
          0.8148,
          0.9689,
          0.8294,
          0.9395,
          0.8994,
          0.8461,
          0.8726,
          0.8085,
          0.975,
          0.8322,
          0.8877,
          0.7834,
          1.1887,
          0.9985,
          0.9201,
          0.8278
        ]
      },
      "old": {
        "n": 20,
        "p50": 0.7954000000000001,
        "p95": 0.8702,
        "mad": 0.02975000000000011,
        "minimum": 0.744,
        "maximum": 0.9381
      },
      "new": {
        "n": 20,
        "p50": 0.8593500000000001,
        "p95": 1.1157,
        "mad": 0.049550000000000094,
        "minimum": 0.7834,
        "maximum": 1.1887
      },
      "ratio": 1.0803997988433491,
      "delta_ms": 0.06394999999999995,
      "time": "2026-10-21T00:12:01.497639+00:00"
    },
    {
      "round": 1,
      "keys": [
        "my_old",
        "my_new"
      ],
      "raw_ms": {
        "my_old": [
          0.921,
          0.952,
          0.9319,
          1.1555,
          0.9024,
          0.8156,
          0.8378,
          0.86,
          0.9141,
          1.0091,
          0.8867,
          0.8079,
          0.8852,
          0.8682,
          0.984,
          0.8801,
          0.8654,
          0.9128,
          0.8473,
          0.8617
        ],
        "my_new": [
          0.8902,
          0.9347,
          0.962,
          1.1426,
          0.929,
          0.9914,
          1.1006,
          0.949,
          0.818,
          0.9506,
          1.0258,
          0.9636,
          0.9538,
          0.9398,
          0.9044,
          0.9134,
          0.9042,
          1.2437,
          0.9625,
          0.9142
        ]
      },
      "old": {
        "n": 20,
        "p50": 0.88595,
        "p95": 1.0091,
        "mad": 0.03160000000000002,
        "minimum": 0.8079,
        "maximum": 1.1555
      },
      "new": {
        "n": 20,
        "p50": 0.9498,
        "p95": 1.1426,
        "mad": 0.035999999999999976,
        "minimum": 0.818,
        "maximum": 1.2437
      },
      "ratio": 1.0720695298831762,
      "delta_ms": 0.06384999999999996,
      "time": "2026-10-21T00:12:01.731424+00:00"
    },
    {
      "round": 2,
      "keys": [
        "my_old",
        "my_new"
      ],
      "raw_ms": {
        "my_old": [
          0.8841,
          1.0186,
          0.8615,
          0.8635,
          0.8836,
          0.8842,
          1.1498,
          0.8382,
          0.9823,
          0.9029,
          0.868,
          1.269,
          0.9245,
          0.9189,
          0.8935,
          0.9179,
          0.8338,
          0.9322,
          0.9731,
          0.979
        ],
        "my_new": [
          0.9008,
          1.044,
          1.0159,
          0.9671,
          1.0149,
          0.9065,
          0.9232,
          0.8889,
          1.059,
          0.9803,
          0.9028,
          0.9421,
          0.9877,
          0.8709,
          1.2151,
          1.1282,
          0.931,
          1.0049,
          1.0182,
          0.8664
        ]
      },
      "old": {
        "n": 20,
        "p50": 0.9104000000000001,
        "p95": 1.1498,
        "mad": 0.04465000000000008,
        "minimum": 0.8338,
        "maximum": 1.269
      },
      "new": {
        "n": 20,
        "p50": 0.9737,
        "p95": 1.1282,
        "mad": 0.05885000000000001,
        "minimum": 0.8664,
        "maximum": 1.2151
      },
      "ratio": 1.0695298769771528,
      "delta_ms": 0.06329999999999991,
      "time": "2026-10-21T00:12:01.962027+00:00"
    }
  ],
  "plans": {},
  "preflight": {
    "my_old": {
      "result": [
        [
          1
        ]
      ],
      "signature": {
        "rows": 1,
        "sha256": "080a9ed428559ef602668b4c00f114f1a11c3f6b02a435f0bdc154578e4d7f22"
      },
      "ms": 0.821
    },
    "my_new": {
      "result": [
        [
          1
        ]
      ],
      "signature": {
        "rows": 1,
        "sha256": "080a9ed428559ef602668b4c00f114f1a11c3f6b02a435f0bdc154578e4d7f22"
      },
      "ms": 0.9031
    }
  },
  "finished": "2026-10-21T00:12:01.964658+00:00",
  "ratio_median": 1.0720695298831762,
  "status": "complete"
}