Database Integrity Commands

hk@immich:~/immich-app$ docker exec -it immich_postgres psql --dbname=postgres --username=postgres --command="show data_checksums"
 data_checksums 
----------------
 on
(1 row)

hk@immich:~/immich-app$ docker exec -it immich_postgres psql --dbname=postgres --username=postgres --command="SELECT datname, checksum_failures, checksum_last_failure FROM pg_stat_database WHERE datname IS NOT NULL"
  datname  | checksum_failures | checksum_last_failure 
-----------+-------------------+-----------------------
 postgres  |                 0 | 
 immich    |                 0 | 
 template1 |                 0 | 
 template0 |                 0 | 
(4 rows)

hk@immich:~/immich-app$ docker exec -it immich_postgres pg_amcheck --username=postgres --heapallindexed --parent-check --rootdescend --progress --all --install-missing
1074/1074 relations (100%), 11605/11605 pages (100%)