Zum Inhalt
HALOWERK

Technische Prüfungen & Formate

F A NEXT MVCC SNAPSHOT / postgres mvcc snapshot tuple visibility

An offline database-history agent needs which supplied physical tuple versions a PostgreSQL MVCC snapshot can see, including current command boundaries and a deletion that remains active in that snapshot.

POST https://detect.halowerk.com/v1/F-A-NEXT-MVCC_SNAPSHOT/postgres-mvcc-snapshot-tuple-visibility

Eingaben

Felder des veröffentlichten Eingabeschemas
FeldTypPflichtBeschreibung
artifactobjectJa
Vollständiges Eingabeschema anzeigen
{
  "type": "object",
  "additionalProperties": false,
  "required": [
    "artifact"
  ],
  "properties": {
    "artifact": {
      "type": "object",
      "additionalProperties": false,
      "required": [
        "mvcc_snapshot"
      ],
      "properties": {
        "mvcc_snapshot": {
          "type": "object",
          "additionalProperties": false,
          "required": [
            "claim",
            "snapshot",
            "transactions",
            "tuples"
          ],
          "properties": {
            "claim": {
              "type": "number",
              "minimum": -1000000000000,
              "maximum": 1000000000000
            },
            "snapshot": {
              "type": "object",
              "additionalProperties": false,
              "required": [
                "curcid",
                "current",
                "xip",
                "xmax",
                "xmin"
              ],
              "properties": {
                "curcid": {
                  "type": "number",
                  "minimum": -1000000000000,
                  "maximum": 1000000000000
                },
                "current": {
                  "type": "number",
                  "minimum": -1000000000000,
                  "maximum": 1000000000000
                },
                "xip": {
                  "type": "array",
                  "maxItems": 512,
                  "items": {
                    "type": "number",
                    "minimum": -1000000000000,
                    "maximum": 1000000000000
                  }
                },
                "xmax": {
                  "type": "number",
                  "minimum": -1000000000000,
                  "maximum": 1000000000000
                },
                "xmin": {
                  "type": "number",
                  "minimum": -1000000000000,
                  "maximum": 1000000000000
                }
              }
            },
            "transactions": {
              "type": "array",
              "maxItems": 512,
              "items": {
                "type": "object",
                "additionalProperties": false,
                "required": [
                  "id",
                  "status"
                ],
                "properties": {
                  "id": {
                    "type": "number",
                    "minimum": -1000000000000,
                    "maximum": 1000000000000
                  },
                  "status": {
                    "type": "string",
                    "maxLength": 1024
                  }
                }
              }
            },
            "tuples": {
              "type": "array",
              "maxItems": 512,
              "items": {
                "type": "object",
                "additionalProperties": false,
                "required": [
                  "cmax",
                  "cmin",
                  "frozen",
                  "locked",
                  "xmax",
                  "xmin"
                ],
                "properties": {
                  "cmax": {
                    "type": "number",
                    "minimum": -1000000000000,
                    "maximum": 1000000000000
                  },
                  "cmin": {
                    "type": "number",
                    "minimum": -1000000000000,
                    "maximum": 1000000000000
                  },
                  "frozen": {
                    "type": "boolean"
                  },
                  "locked": {
                    "type": "boolean"
                  },
                  "xmax": {
                    "type": "number",
                    "minimum": -1000000000000,
                    "maximum": 1000000000000
                  },
                  "xmin": {
                    "type": "number",
                    "minimum": -1000000000000,
                    "maximum": 1000000000000
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

Originalschema öffnen

Ergebnis & Dokumentation

Maschinenlesbare Dokumentation dieses Hubs

Quelle dieser Seite: der veröffentlichte HALOWERK-Katalog. Stand: 2026-11-01, 15:19 UTC.

Weitere Endpunkte dieses Hubs

Alle Endpunkte dieses Hubs →