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 (commit 3717dc14).

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

Functions

As of PostgreSQL 12, following functions are provided:

  • bt_index_check()
  • bt_index_parent_check()

Change history

  • PostgreSQL documentation: amcheck

Categories

Contrib module, Data consistency and forensics, Extension, Storage

See also

REINDEX, pageinspect