1、查看连接数
docker exec -it postgresql psql -U authentik -d authentik -c "SELECT count(*) FROM pg_stat_activity;"
2、查看处理进度
docker exec -it postgresql psql -U authentik -d authentik -c "SELECT pid, usename, state, query_start, now() - query_start as duration, left(query, 50) as short_query FROM pg_stat_activity WHERE state != 'idle' ORDER BY duration DESC;"
3、查看最大连接数
docker exec -it postgresql psql -U authentik -d authentik -c "SHOW max_connections;"
4、查看表单的情况
docker exec -it postgresql psql -U authentik -d authentik -c "SELECT state, count(*) FROM pg_stat_activity GROUP BY state;"
5、清理表
docker exec -it postgresql psql -U authentik -d authentik -c "VACUUM (VERBOSE, ANALYZE) guardian_roleobjectpermission;"

docker exec -it postgresql psql -U authentik -d authentik -c "VACUUM (VERBOSE, ANALYZE) guardian_rolemodelpermission;"
6、查看索引
docker exec -it postgresql psql -U authentik -d authentik -c "\d guardian_roleobjectpermission"

docker exec -it postgresql psql -U authentik -d authentik -c "\d guardian_rolemodelpermission"

7、创建索引
docker exec -it postgresql psql -U authentik -d authentik -c "CREATE INDEX CONCURRENTLY IF NOT EXISTS guardian_roleobjectpermission_content_type_id_idx ON guardian_roleobjectpermission (content_type_id);"

docker exec -it postgresql psql -U authentik -d authentik -c "CREATE INDEX CONCURRENTLY IF NOT EXISTS guardian_rolemodelpermission_content_type_id_idx ON guardian_rolemodelpermission (content_type_id);"