Changelog
- divided Instance Rate graph into two graphs - Blocks Rate, Transactions Rate
- divided XLOG plugin into two plugins - WAL, Replication
- changed pg_wait_sampling plugin name to Wait Sampling
- changed pg_stat_statements plugin name to Statements
- changed default agent.conf file permissions: now it read/write only for mamonsu user
- added new Replication plugin metrics: Send Lag, Receive Lag
- added pgpro_stats support to PostgresPro cluster (automatic switch from pg_stat_statements and pg_wait_sampling)
- added new bootstrap features: now the '-x' option also configures pg_stat_statements, pg_wait_sampling and pgpro_stats extensions
- added custom schema check for pg_stat_statements, pg_wait_sampling and pgpro_stats extensions
- added new lock types to the Wait Sampling plugin to fit PostgreSQL 10+: Extension Locks, Client Locks, Other Locks (e.g. IPC Timeout IO), Autovacuum Locks, Logical Replication Locks
- added new System Free/Used Memory graph
- added new active locking queries feature to the report tool
- replaced System Memory Overview graph with System Free/Used Memory in dashboards
- fixed Statements plugin items generation for native zabbix agent
- fixed Rollbacks item delta type
- fixed WAL metrics delta types
- fixed PostgreSQL Uptime trigger
- improved Replication metrics evaluation algorithm
- unified Zabbix objects names
- unified config file sections and parameters names
- set new color scheme
pgpro_stats support
By default mamonsu uses pg_stat_statements and pg_wait_samplings in plugins Statements and Wait Sampling. These extensions need to be installed additionally via shared_preload_libraries. But if mamonsu detects PostgresPro instead of vanilla PostgreSQL, it switched automatically to pgpro_stats for both plugins. This is more convenient because pgpro_stats is going by default with PostgresPro.
agent.conf permissions
Now by default mamonsu sets for agent.conf the following permissions:
permissions user group
-rw------- mamonsu mamonsu jun 16 12:21 agent.confnew report feature
With other PostgreSQL stats, report now evaluates information about current locks:
$ mamonsu report --run-system --run-postgres -U mamonsu
<...>
# CURRENT LOCKS ##################################
blocked_pid database blocked_user blocking_pid blocking_user blocked_statement duration
49934 mamonsu_test_db postgres 91741 postgres update mamonsu_logs set value = 0 where value = 3; 0:00:35.199513NOTE: objects new names
Pay attention to new Zabbix template object names. All mamonsu objects have been unified in template representation, so you should update the template carefully. For example, PostgreSQL: number of user total connections switched to PostgreSQL Connections: Number of Total User Connections. All changes are shown in documentation.