A new item has been added to PostgreSQL plugin for Zabbix agent 2. The metric pgsql.queries is used for monitoring query execution time.
Templates
The following templates have been updated:
The template Generic Java JMX now contains discovery rules for low-level discovery of memory pools and garbage collectors.
The templates Template Module Windows services by Zabbix agent and Template Module Windows services by Zabbix agent active now contain a new macro {$SERVICE.NAME.NOT_MATCHES.EXTENDED}, which is used to filter out additional services.
The template PostgreSQL by Zabbix agent 2 now will check the number of slow queries and generate a problem if the amount exceeds a threshold.
You can get these templates:
In Configuration → Templates in new installations;
When upgrading from previous versions, the latest templates can be downloaded from the Zabbix Git repository and manually imported into Zabbix in the Configuration → Templates section. If a template with the same name already exists, check the Delete missing option before importing to achieve a clean import. This way the items that have been excluded from the updated template will be removed (note, that history of the deleted items will be lost).