Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-8198

Errors pg_stat_statements usage in PG13

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Done
    • 2.17.0, 2.18.0
    • None
    • Postgres_exporter
    • 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

      Attachments

        Activity

          People

            Unassigned Unassigned
            Lebedev Yaroslav
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist