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

pmm@postgres ERROR: relation "pg_stat_statements" does not exist at character 753

    XMLWordPrintable

    Details

      Description

      Hello, 

      I got the error

      2021-01-02 11:49:00.003 WIB [8337] pmm@postgres ERROR: relation "pg_stat_statements" does not exist at character 753
      2021-01-02 11:49:00.003 WIB [8337] pmm@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_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

       

      then is my pmm-admin version

      root@webfarmcli:/var/log/postgresql# pmm-admin --version
      ProjectName: pmm-admin
      Version: 2.13.0
      PMMVersion: 2.13.0
      Timestamp: 2020-12-29 11:01:24 (UTC)
      FullCommit: d59c04db689ae0bc7eff55b7bd717a54a63ad550
      root@webfarmcli:/var/log/postgresql#

       

      it's bug?

        Attachments

          Activity

            People

            Assignee:
            jobin.augustine Jobin Augustine
            Reporter:
            agung agung
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist