amcheck

A contrib module providing functions to verify the logical consistency of relations

amcheck is a contrib module implemented as an extension providing functions to verify the logical consistency of the structure of relations and btree indexes .

amcheck was added in PostgreSQL 10.

Support for PostgreSQL 9.4 ~ PostgreSQL 9.6 is provided via an external repository: amcheck/amcheck_next: functions for verifying PostgreSQL relation integriity.

Usage

Functions

As of PostgreSQL 14, following functions are provided:

  • bt_index_check()
  • bt_index_parent_check()
  • verify_heapam()

Command-line wrapper

From PostgreSQL 14, the core utility pg_amcheck is provided as a command-line convenience wrapper around amcheck functionality.

Change history

  • PostgreSQL documentation: amcheck

Categories

Contrib module, Data consistency and forensics, Extension, Storage

See also

pg_amcheck, REINDEX, pageinspect