[ZBX-22583] Agent2 [PostgreSQL] Cannot fetch data: query "all_tables_stat" not found. Created: 2023 Mar 24  Updated: 2023 Mar 27  Resolved: 2023 Mar 27

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Agent (G), Templates (T)
Affects Version/s: 6.0.14
Fix Version/s: None

Type: Incident report Priority: Trivial
Reporter: Arkadiy Assignee: Zabbix Integration Team
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File image-2023-03-24-13-35-39-024.png     PNG File image-2023-03-24-13-37-15-257.png     PNG File image-2023-03-24-13-38-42-628.png    

 Description   

PostgreSQL template works fine.

Steps to reproduce:

Item key in template

pgsql.custom.query["\{$PG.URI}","\{$PG.USER}","\{$PG.PASSWORD}","\{$PG.DATABASE}","all_tables_stat"]


 
/etc/zabbix/zabbix_agent2.conf

 
Custom script permissions and location

 
/var/log/zabbix/zabbix_agent2.log
[PostgreSQL] Cannot fetch data: query "all_tables_stat" not found.

 Comments   
Comment by Arkadiy [ 2023 Mar 27 ]

I have solved this by addding Plugins.Postgres.CustomQueriesPath value into postgres plugin config.

Generated at Mon Feb 02 16:01:38 EET 2026 using Jira 10.3.13#10030013-sha1:56dd970ae30ebfeda3a697d25be1f6388b68a422.