ERROR: column "total_time" does not exist

General
, , ,
1

After upgrading to Postgres 14.6 and enabling pg_stat_statements, it appears in this latest version of Postgres, the column in pg_stat_statements that was named “total_time” is now named “total_exec_time”.

All AES queries used to push data to PDC using “total_time” are now failing. There does not appear to be an AES update for this.

How can I update AES to fix the column name in the Connect SQL rules:

PegaAESRemote-Interface-DBStats.PostgreSQL.PopulateStatsInfoWithQueryID

PegaAESRemote-Interface-DBStats.PostgreSQL.PopulateStatsInfo

2

@Glen Caldwell What is the Pega version installed?

Did you check if Postgres 14.6 is a supported stack on the Platform Support Guide? It is only supported from Pega 8.8 onwards according to the Platform Support Guide

:Please see the limitations described here here, and here.

See Pega Autonomic Event Services FAQ

What are the requirements for installing AES?

You install AES 8.3 on a Pega Platform 8.3 system with multitenancy enabled and the required hotfixes installed. For more information, see Installing Pega Autonomic Event Services 8.3 and Pega Autonomic Event Services hotfixes.

After AES 8.3 we recommend you migrate to PDC

3

@MarijeSchillern I have the same problem with Pega 8.7.5 and Postgres 13.10, how did you solve it?

4

@AleMax225 it sounds like you’re on a supported platform.

sq.png
sq.png1724×590 46 KB

Please log a support issue (see details here) on the MSP if you believe you are encountering a product problem.