PostgreSQL 监控数据库活动

目录

27.1. 标准 Unix 工具

27.2. 统计收集器

27.2.1. 统计收集配置

27.2.2. 查看统计信息

27.2.3. pg_stat_activity

27.2.4. pg_stat_replication

27.2.5. pg_stat_wal_receiver

27.2.6. pg_stat_subscription

27.2.7. pg_stat_ssl

27.2.8. pg_stat_gssapi

27.2.9. pg_stat_archiver

27.2.10. pg_stat_bgwriter

27.2.11. pg_stat_database

27.2.12. pg_stat_database_conflicts

27.2.13. pg_stat_all_tables

27.2.14. pg_stat_all_indexes

27.2.15. pg_statio_all_tables

27.2.16. pg_statio_all_indexes

27.2.17. pg_statio_all_sequences

27.2.18. pg_stat_user_functions

27.2.19. pg_stat_slru

27.2.20. Statistics Functions

27.3. 查看锁

27.4. Progress Reporting

27.4.1. ANALYZE Progress Reporting

27.4.2. CREATE INDEX Progress Reporting

27.4.3. VACUUM进度报告

27.4.4. CLUSTER进度报告

27.4.5. 基础备份进度报告

27.5. 动态追踪

27.5.1. 动态追踪的编译

27.5.2. 内建探针

27.5.3. 使用探针

27.5.4. 定义新探针