amcheck

CREATE EXTENSION amcheck;

-- 轻量级检查（AccessShareLock，适合生产环境）
SELECT bt_index_check('my_index');

-- 带堆全索引验证
SELECT bt_index_check('my_index', heapallindexed => true);

-- 全面检查，包含父/子不变量（ShareLock，阻止写入）
SELECT bt_index_parent_check('my_index');

-- 最全面：rootdescend 从根节点重新查找每个元组
SELECT bt_index_parent_check('my_index',
    heapallindexed => true,
    rootdescend => true,
    checkunique => true);

SELECT bt_index_check(c.oid), c.relname, c.relpages
FROM pg_index i
JOIN pg_opclass op ON i.indclass[0] = op.oid
JOIN pg_am am ON op.opcmethod = am.oid
JOIN pg_class c ON i.indexrelid = c.oid
JOIN pg_namespace n ON c.relnamespace = n.oid
WHERE am.amname = 'btree' AND n.nspname = 'pg_catalog'
  AND c.relpersistence != 't' AND c.relkind = 'i'
  AND i.indisready AND i.indisvalid
ORDER BY c.relpages DESC LIMIT 10;

SELECT gin_index_check('my_gin_index');

-- 基本堆检查
SELECT * FROM verify_heapam('my_table');

-- 带 TOAST 验证（更慢）
SELECT * FROM verify_heapam('my_table', check_toast => true);

-- 检查特定块范围
SELECT * FROM verify_heapam('my_table', startblock => 0, endblock => 1000);

-- 在第一个损坏块处停止
SELECT * FROM verify_heapam('my_table', on_error_stop => true);