Thread: Amcheck extension query for tables (verify_heapam)

SELECT verify_heapam('mytable')

Hi

PostgreSQL 14 has the built in function for amcheck extension called "verify_heapam".

I was wondering, is there similar query for that function as well like there is for "bt_index_check" function..?

I do not see that here:

https://www.postgresql.org/docs/14/amcheck.html

I would like to monitor both (tables and indexes) for corruption checks.

Regards

Raul Kaubi

On Mon, May 30, 2022 at 1:00 AM Raul Kaubi <raulkaubi@gmail.com> wrote:
> PostgreSQL 14 has the built in function for amcheck extension called "verify_heapam".
> I was wondering, is there similar query for that function as well like there is for "bt_index_check" function..?

You should probably just use the higher level pg_amcheck utility,
which runs everything from amcheck including verify_heapam() under the
hood.

-- 
Peter Geoghegan