lrwxrwxrwx 1 postgres dba 32 Jul 26 07:21 check_postgres_database_size -> /usr/local/bin/check_postgres.pl lrwxrwxrwx 1 postgres dba 32 Jul 26 07:21 check_postgres_dbstats -> /usr/local/bin/check_postgres.pl lrwxrwxrwx 1 postgres dba 32 Jul 26 07:21 check_postgres_disabled_trig...
lrwxrwxrwx 1 postgres dba 32 Jul 26 07:21 check_postgres_custom_query -> /usr/local/bin/check_postgres.pl lrwxrwxrwx 1 postgres dba 32 Jul 26 07:21 check_postgres_database_size -> /usr/local/bin/check_postgres.pl lrwxrwxrwx 1 postgres dba 32 Jul 26 07:21 check_postgres_dbstats...
此仓库是为了提升国内下载速度的镜像仓库,每日同步一次。 原始仓库:https://gitlab.com/postgres-ai/postgres-checkup master 克隆/下载 git config --global user.name userName git config --global user.email userEmail 分支51 标签15 Artyom Kartasovfix: Support pg_stat_statements for Postgr...02e4fc91...
lrwxrwxrwx 1 postgres dba 32 Jul 26 07:21 check_postgres_custom_query -> /usr/local/bin/check_postgres.pl lrwxrwxrwx 1 postgres dba 32 Jul 26 07:21 check_postgres_database_size -> /usr/local/bin/check_postgres.pl lrwxrwxrwx 1 postgres dba 32 Jul 26 07:21 check_postgres_dbstats...
Check the most important settings. Warning and Critical thresholds are ignored. Specific parameters are : --work_mem, --maintenance_work_mem, --shared_buffers,--wal_buffers, --checkpoint_segments, --effective_cache_size, --no_check_autovacuum, --no_check_fsync, --no_check_enable, --no_...
The 'postgres' database and templates are always excluded. Required privileges: unprivileged role able to log in all databases. last_vacuum (8.2+) Check that the oldest vacuum (from autovacuum or otherwise) in each database in the cluster is not older than the given threshold. This service ...
$ docker container run --name pg1 -d -v psql:/var/lib/postgresql/data postgres:9.6.1-alpine $ docker container stop pg1 $ docker container run --name pg2 -d -v psql:/var/lib/postgresql/data postgres:9.6.2-alpine $ docker volume ls DRIVER VOLUME NAME local psql $ docker containe...
可能的类型是 autovacuum launcher, autovacuum worker, logical replication launcher, logical replication worker, parallel worker, background writer, client backend, checkpointer, startup, walreceiver, walsender 以及 walwriter。 除此以外,由扩展注册的后台Worker可能有额外的类型。 SQL查询 常用阻塞查询SQL -...
This service supports both--dbexcludeand--dbincludeparameters. The 'postgres' database and templates are always excluded. Required privileges: unprivileged role able to log in all databases. last_vacuum(8.2+) Check that the oldest vacuum (from autovacuum or otherwise) in each database in the cl...
$ docker container run --name pg1 -d -v psql:/var/lib/postgresql/data postgres:9.6.1-alpine $ docker container stop pg1 $ docker container run --name pg2 -d -v psql:/var/lib/postgresql/data postgres:9.6.2-alpine $ docker volume ls DRIVER VOLUME NAME local psql $ docker containe...