Zum Inhalt
HALOWERK

Datenvertragswerk

hot index root audit

A PostgreSQL storage/index fixture maintainer checks which supplied page tuple an initial index-root HOT search may actually return,rather than treating every snapshot-visible physical tuple as reachable from that index entry. PostgreSQL18 first_call=true model only. Visibility and resolved updater are supplied. No MVCC execution,page validity or security diagnosis. Unknown/revisit limits explicit. Fixed price also for successful unknown;invalid profile HTTP400 before settlement. A.

POST https://datenvertrag.halowerk.com/v1/hot-index-root-audit

Eingaben

Felder des veröffentlichten Eingabeschemas
FeldTypPflichtBeschreibung
max_offsetintegerJa
slotsarrayJa
queriesarrayJa
Vollständiges Eingabeschema anzeigen
{
  "type": "object",
  "additionalProperties": false,
  "properties": {
    "max_offset": {
      "type": "integer",
      "minimum": 0,
      "maximum": 16
    },
    "slots": {
      "type": "array",
      "items": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "offset": {
            "type": "integer",
            "minimum": 1,
            "maximum": 16
          },
          "kind": {
            "enum": [
              "NORMAL",
              "REDIRECT",
              "DEAD",
              "UNUSED",
              null
            ]
          },
          "redirect_to": {
            "anyOf": [
              {
                "type": "integer",
                "minimum": 0,
                "maximum": 17
              },
              {
                "type": "null"
              }
            ]
          },
          "heap_only": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "xmin": {
            "anyOf": [
              {
                "type": "integer",
                "minimum": 0,
                "maximum": 4294967295
              },
              {
                "type": "null"
              }
            ]
          },
          "update_xid": {
            "anyOf": [
              {
                "type": "integer",
                "minimum": 0,
                "maximum": 4294967295
              },
              {
                "type": "null"
              }
            ]
          },
          "visible": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "hot_updated": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "next_offset": {
            "anyOf": [
              {
                "type": "integer",
                "minimum": 0,
                "maximum": 17
              },
              {
                "type": "null"
              }
            ]
          },
          "same_page": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          }
        },
        "required": [
          "offset",
          "kind",
          "redirect_to",
          "heap_only",
          "xmin",
          "update_xid",
          "visible",
          "hot_updated",
          "next_offset",
          "same_page"
        ]
      },
      "minItems": 0,
      "maxItems": 16
    },
    "queries": {
      "type": "array",
      "items": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "root": {
            "type": "integer",
            "minimum": 0,
            "maximum": 17
          },
          "claimed_offset": {
            "anyOf": [
              {
                "type": "integer",
                "minimum": 1,
                "maximum": 16
              },
              {
                "type": "null"
              }
            ]
          }
        },
        "required": [
          "root",
          "claimed_offset"
        ]
      },
      "minItems": 1,
      "maxItems": 16
    }
  },
  "required": [
    "max_offset",
    "slots",
    "queries"
  ]
}

Originalschema öffnen

Veröffentlichtes Eingabebeispiel

{
  "max_offset": 3,
  "slots": [
    {
      "offset": 1,
      "kind": "NORMAL",
      "redirect_to": null,
      "heap_only": false,
      "xmin": 10,
      "update_xid": 20,
      "visible": false,
      "hot_updated": true,
      "next_offset": 2,
      "same_page": true
    },
    {
      "offset": 2,
      "kind": "NORMAL",
      "redirect_to": null,
      "heap_only": true,
      "xmin": 20,
      "update_xid": 20,
      "visible": true,
      "hot_updated": false,
      "next_offset": 2,
      "same_page": true
    },
    {
      "offset": 3,
      "kind": "NORMAL",
      "redirect_to": null,
      "heap_only": true,
      "xmin": 20,
      "update_xid": 20,
      "visible": true,
      "hot_updated": false,
      "next_offset": 2,
      "same_page": true
    }
  ],
  "queries": [
    {
      "root": 1,
      "claimed_offset": 2
    }
  ]
}

Ergebnis & Dokumentation

Maschinenlesbare Dokumentation dieses Hubs

Quelle dieser Seite: der veröffentlichte HALOWERK-Katalog. Stand: 2026-11-07, 02:42 UTC.

Weitere Endpunkte dieses Hubs

Alle Endpunkte dieses Hubs →