amcheck

A contrib module providing functions to verify the logical consistency of btree indexes

amcheck is a contrib module implemented as an extension providing functions to verify the logical consistency of btree indexes (although it is intended to add support for further access methods in future releases).

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