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

PostgreSQL metrics disparity between query time and block read/write time

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 2.0.0
    • 2.7.0
    • PMM Agent
    • 1
    • Yes
    • Yes

    Description

      As we discovered in  PMM-5698  + puneet.kala investigation with  PG team : 

      We have metrics in PG and they are cumulative but by the data, we have in QAN - it looks like we treated them as data for current query or something like this  

      • 'blk_read_time',
      • 'blk_write_time',

       

      Because we had 'blk_*_time' metrics bigger than 'query time' 

       

      STR:
      1) Setup PostgreSQL 10.4 version and "create extension pg_stat_statements"
      2) Create database sbtest_pg
      3) run alter database sbtest_pg set track_io_timings=1;
      4) create user sbtest
      5) grant the user all privileges to sbtest_pg
      6) sysbench --db-driver=pgsql --oltp-table-size=100000 --oltp-tables-count=24 --threads=1 --pgsql-db=sbtest_pg --pgsql-user=sbtest --pgsql-host=localhost /usr/share/sysbench/tests/include/oltp_legacy/parallel_prepare.lua run
      7) sysbench --db-driver=pgsql --report-interval=2 --oltp-table-size=100000 --oltp-tables-count=24 --threads=32 --time=60 --pgsql-host=localhost --pgsql-port=5432 --pgsql-user=sbtest --pgsql-db=sbtest_pg /usr/share/sysbench/tests/include/oltp_legacy/oltp.lua run

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              roma.novikov Roma Novikov
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 day, 2 hours
                  1d 2h

                  Smart Checklist