postgres=# show server_version;
 server_version 
----------------
 9.6.23
(1 row)



postgres=# \d pg_stat_activity;
           View "pg_catalog.pg_stat_activity"
      Column      |           Type           | Modifiers 
------------------+--------------------------+-----------
 datid            | oid                      | 
 datname          | name                     | 
 pid              | integer                  | 
 usesysid         | oid                      | 
 usename          | name                     | 
 application_name | text                     | 
 client_addr      | inet                     | 
 client_hostname  | text                     | 
 client_port      | integer                  | 
 backend_start    | timestamp with time zone | 
 xact_start       | timestamp with time zone | 
 query_start      | timestamp with time zone | 
 state_change     | timestamp with time zone | 
 wait_event_type  | text                     | 
 wait_event       | text                     | 
 state            | text                     | 
 backend_xid      | xid                      | 
 backend_xmin     | xid                      | 
 query            | text                     |
 
 
 
# zabbix_get -s postgresql96 -k pgsql.transactions[127.0.0.1,,zabbix,postgres]
psql:/var/lib/zabbix/externalscripts/postgresql/pgsql.transactions.sql:28: ERROR:  column "backend_type" does not exist
LINE 8:             FROM pg_stat_activity WHERE backend_type='client...
                                                ^
QUERY:  SELECT row_to_json(T)          from (
            SELECT
                coalesce(extract(epoch FROM max(CASE WHEN state = 'idle in transaction' THEN age(now(), query_start) END)), 0) AS idle,
                coalesce(extract(epoch FROM max(CASE WHEN state <> 'idle in transaction' AND state <> 'idle' THEN age(now(), query_start) END)), 0) AS active,
                coalesce(extract(epoch FROM max(CASE WHEN wait_event IS NOT NULL AND state='active' THEN age(now(), query_start) END)), 0) AS waiting,
                (SELECT coalesce(extract(epoch FROM max(age(now(), prepared))), 0) FROM pg_prepared_xacts) AS prepared,
                max(age(backend_xmin)) AS xmin_age
            FROM pg_stat_activity WHERE backend_type='client backend') T
CONTEXT:  PL/pgSQL function inline_code_block line 9 at SQL statement
psql:/var/lib/zabbix/externalscripts/postgresql/pgsql.transactions.sql:30: ERROR:  unrecognized configuration parameter "zbx_tmp.trans_json_res"