{
  "job": {
    "id": "schema_diamond_12_shared",
    "kind": "my",
    "keys": [
      "my_old",
      "my_new"
    ],
    "sql": "SELECT JSON_SCHEMA_VALID('{\"type\":\"integer\",\"definitions\":{\"d0\":{\"allOf\":[{\"$ref\":\"#/definitions/d1\"},{\"$ref\":\"#/definitions/d1\"}]},\"d1\":{\"allOf\":[{\"$ref\":\"#/definitions/d2\"},{\"$ref\":\"#/definitions/d2\"}]},\"d2\":{\"allOf\":[{\"$ref\":\"#/definitions/d3\"},{\"$ref\":\"#/definitions/d3\"}]},\"d3\":{\"allOf\":[{\"$ref\":\"#/definitions/d4\"},{\"$ref\":\"#/definitions/d4\"}]},\"d4\":{\"allOf\":[{\"$ref\":\"#/definitions/d5\"},{\"$ref\":\"#/definitions/d5\"}]},\"d5\":{\"allOf\":[{\"$ref\":\"#/definitions/d6\"},{\"$ref\":\"#/definitions/d6\"}]},\"d6\":{\"allOf\":[{\"$ref\":\"#/definitions/d7\"},{\"$ref\":\"#/definitions/d7\"}]},\"d7\":{\"allOf\":[{\"$ref\":\"#/definitions/d8\"},{\"$ref\":\"#/definitions/d8\"}]},\"d8\":{\"allOf\":[{\"$ref\":\"#/definitions/d9\"},{\"$ref\":\"#/definitions/d9\"}]},\"d9\":{\"allOf\":[{\"$ref\":\"#/definitions/d10\"},{\"$ref\":\"#/definitions/d10\"}]},\"d10\":{\"allOf\":[{\"$ref\":\"#/definitions/d11\"},{\"$ref\":\"#/definitions/d11\"}]},\"d11\":{\"allOf\":[{\"$ref\":\"#/definitions/d12\"},{\"$ref\":\"#/definitions/d12\"}]},\"d12\":{\"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_12_True",
    "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:11:55.741157+00:00",
  "rounds": [
    {
      "round": 0,
      "keys": [
        "my_old",
        "my_new"
      ],
      "raw_ms": {
        "my_old": [
          0.828,
          1.0284,
          0.8356,
          0.8533,
          0.8231,
          0.8429,
          0.9902,
          0.7806,
          0.8115,
          0.8627,
          0.8805,
          0.8597,
          0.7748,
          0.8299,
          0.8545,
          0.8638,
          0.8044,
          0.948,
          0.8057,
          0.8726
        ],
        "my_new": [
          3.7539,
          3.9459,
          4.0834,
          3.8898,
          3.9348,
          3.7486,
          3.8828,
          3.772,
          3.9367,
          4.2968,
          4.2098,
          4.0712,
          3.7895,
          4.3799,
          4.1489,
          4.1684,
          4.003,
          3.9218,
          3.8794,
          4.1102
        ]
      },
      "old": {
        "n": 20,
        "p50": 0.8481,
        "p95": 0.9902,
        "mad": 0.024749999999999994,
        "minimum": 0.7748,
        "maximum": 1.0284
      },
      "new": {
        "n": 20,
        "p50": 3.9413,
        "p95": 4.2968,
        "mad": 0.14695000000000014,
        "minimum": 3.7486,
        "maximum": 4.3799
      },
      "ratio": 4.647211413748379,
      "delta_ms": 3.0932,
      "time": "2026-10-21T00:11:56.153597+00:00"
    },
    {
      "round": 1,
      "keys": [
        "my_old",
        "my_new"
      ],
      "raw_ms": {
        "my_old": [
          0.9206,
          0.7689,
          0.8118,
          0.8076,
          0.9715,
          1.0173,
          0.8826,
          0.8419,
          0.9224,
          0.8633,
          0.9507,
          0.9121,
          0.9133,
          0.8152,
          0.9818,
          0.7828,
          0.9774,
          0.8509,
          0.9046,
          0.9862
        ],
        "my_new": [
          3.7768,
          4.3597,
          3.8885,
          3.867,
          4.1259,
          3.8299,
          4.0895,
          3.8503,
          4.152,
          3.9581,
          4.103,
          3.8879,
          4.1103,
          3.7517,
          3.7544,
          3.9328,
          3.7372,
          3.9815,
          3.8175,
          3.8916
        ]
      },
      "old": {
        "n": 20,
        "p50": 0.90835,
        "p95": 0.9862,
        "mad": 0.06480000000000002,
        "minimum": 0.7689,
        "maximum": 1.0173
      },
      "new": {
        "n": 20,
        "p50": 3.89005,
        "p95": 4.152,
        "mad": 0.10234999999999994,
        "minimum": 3.7372,
        "maximum": 4.3597
      },
      "ratio": 4.282545274398635,
      "delta_ms": 2.9817,
      "time": "2026-10-21T00:11:56.445812+00:00"
    },
    {
      "round": 2,
      "keys": [
        "my_old",
        "my_new"
      ],
      "raw_ms": {
        "my_old": [
          0.9665,
          0.8504,
          0.7824,
          0.8054,
          0.7686,
          0.9247,
          0.8066,
          1.0221,
          0.8149,
          0.8676,
          1.0169,
          0.9797,
          0.8748,
          0.8653,
          0.7885,
          0.915,
          1.0499,
          1.0316,
          0.8247,
          0.8522
        ],
        "my_new": [
          4.0109,
          3.8759,
          4.3697,
          3.8416,
          4.0867,
          3.812,
          3.9652,
          3.8135,
          3.9832,
          3.9653,
          4.3574,
          4.3576,
          4.8578,
          3.9894,
          3.8785,
          3.8844,
          3.945,
          4.2914,
          3.9203,
          4.9772
        ]
      },
      "old": {
        "n": 20,
        "p50": 0.8664499999999999,
        "p95": 1.0316,
        "mad": 0.06044999999999995,
        "minimum": 0.7686,
        "maximum": 1.0499
      },
      "new": {
        "n": 20,
        "p50": 3.97425,
        "p95": 4.8578,
        "mad": 0.10540000000000016,
        "minimum": 3.812,
        "maximum": 4.9772
      },
      "ratio": 4.586819781868544,
      "delta_ms": 3.1078,
      "time": "2026-10-21T00:11:56.760190+00:00"
    }
  ],
  "plans": {},
  "preflight": {
    "my_old": {
      "result": [
        [
          1
        ]
      ],
      "signature": {
        "rows": 1,
        "sha256": "080a9ed428559ef602668b4c00f114f1a11c3f6b02a435f0bdc154578e4d7f22"
      },
      "ms": 0.8423
    },
    "my_new": {
      "result": [
        [
          1
        ]
      ],
      "signature": {
        "rows": 1,
        "sha256": "080a9ed428559ef602668b4c00f114f1a11c3f6b02a435f0bdc154578e4d7f22"
      },
      "ms": 4.0965
    }
  },
  "finished": "2026-10-21T00:11:56.762292+00:00",
  "ratio_median": 4.586819781868544,
  "status": "complete"
}