Out of the box, an official PostgreSQL monitoring solution by "user parameter" contains "slow query count" metric:
Official Zabbix Agent 2 solution does not have it, but it's useful:
Kindly include metric in Zabbix agent 2 solution.