Skip to content

3.5.0
Compare
Choose a tag to compare
@cuprumtan cuprumtan released this 13 Jul 13:04
· 141 commits to master since this release
3.5.0
c14e564

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.conf

new 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.199513

NOTE: 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.

Assets 2
Loading