El envío de formularios en el sitio de soporte no está disponible temporalmente para programar el mantenimiento. Si necesita asistencia inmediata, comuníquese con el soporte técnico. Disculpe las molestias ocasionadas.
ERROR: column "total_exec_time" does not exist in PostgreSQL agent log file
Descripción
Top SQL statements are not collected for a PostgreSQL agent even though the pg_stat_statements extension has been installed.
Causa
After upgrading to PostgreSQL 13 or higher and enabling pg_stat_statements, the column in pg_stat_statements is renamed from "total_time" to "total_exec_time" as columns were added for planning times as well as execution times.
A PG_STAT_STATEMENTS extension created in the database at a lower version may still be missing the column total_exec_time.
Resolución
Verify that the pg_stat_statements extension has the column total_exec_time.
SELECT
column_name,
data_type,
character_maximum_length,
is_nullable,
column_default
FROM
information_schema.columns
WHERE
table_name = 'pg_stat_statements';
If the column is not present, then delete the extension
DROP EXTENSION pg_stat_statements;.
and then recreate the extension as per Resolution 1 in knowledgebase article 4226972
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Bienvenido al portal de soporte
Puede encontrar ayuda de soporte en línea para el *producto* Quest en un sitio de soporte afiliado. Haga clic en Continuar para ser dirigido al contenido de soporte y a la asistencia adecuados para el *producto*.
Buscar todos los artículos
IE 8, 9 y 10 ya no son compatibles
El portal de Quest Software ya no admite IE 8, 9 ni 10 y se recomienda actualizar el navegador a la última versión de Internet Explorer o Chrome.
