Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Done
-
2.17.0, 2.18.0
-
None
-
None
Description
PostgreSQL 13.3
PMM Current version: 2.18.0 (June 01, 2021)
After updating from PG12 to PG13 in the logs:
2021-06-02 15:59:58 MSK [81418]: [4941-1] user=pmm,db=postgres ERROR: column pg_stat_statements.total_exec_time does not exist at character 193 2021-06-02 15:59:58 MSK [81418]: [4942-1] user=pmm,db=postgres STATEMENT: SELECT /* pmm-agent:pgstatstatements */ "pg_stat_statements"."userid", "pg_stat_statements"."dbid", "pg_stat_statements"."queryid", "pg_stat_statements"."query", "pg_stat_statements"."calls", "pg_stat_statements"."total_exec_time", "pg_stat_statements"."rows", "pg_stat_statements"."shared_blks_hit", "pg_stat_statements"."shared_blks_read", "pg_stat_statements"."shared_blks_dirtied", "pg_stat_statements"."shared_blks_written", "pg_stat_statements"."local_blks_hit", "pg_stat_statements"."local_blks_read", "pg_stat_statements"."local_blks_dirtied", "pg_stat_statements"."local_blks_written", "pg_stat_statements"."temp_blks_read", "pg_stat_statements"."temp_blks_written", "pg_stat_statements"."blk_read_time", "pg_stat_statements"."blk_write_time" FROM "pg_stat_statements" WHERE queryid IS NOT NULL AND query IS NOT NULL
And there are no statistics in PMM Query Analytics