ERROR: column "total_exec_time" does not exist in PostgreSQL agent log file (4374980)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

ERROR: column "total_exec_time" does not exist in PostgreSQL agent log file
Beschreibung

Top SQL statements are not collected for a PostgreSQL agent even though the pg_stat_statements extension has been installed.
Ursache

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.
Lösung
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

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: Foglight Cloud
Hosted; Foglight
7.1.0, 6.3.0, 6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2, 5.7.5; Foglight for Databases
7.1.0, 6.3.0, 6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2

Artikelhistorie:: Erstellt am: 2/29/2024
Letzte Aktualisierung am: 2/29/2024

Titel