Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

PG 17 support by Query Analytics

Description

Fields blk_read_time and blk_write_time renamed to shared_blk_read_time and shared_blk_write_time in both extensions (pg_stat_statements and pg_stat_monitor) for PostgreSQL 17. We have to update our dashboards to support this change.

 

Related links:

How to test

Just check that QAN works the same as before for combinations:

  1. current agent and server (PGSS and PGSM)

  2. old agent and current server (PGSS and PGSM)

    On the API level we still support old m_blk_read_time_cnt, m_blk_read_time_sum, m_blk_write_time_cnt, m_blk_write_time_sum fields, so no UI changed presented for now. However we expose new fields m_<shared/local>_blk_<read/write>_time_<cnt/sum>

How to document

Release notes: PMM supporting PG 17.
Compatibility matrix on website.

Smart Checklist

hide

Activity

Show:

naeem.akhter October 2, 2024 at 3:53 PM
Edited

PGSM-PG 17 is not compatible with PMM at the moment. There is a PR from pending for required changes to support PG 17 in PMM.

Can someone please have a look at above PR and review it?

Done

Details

Assignee

Reporter

Priority

Components

Labels

Needs QA

Yes

Needs Doc

Yes

Planned Version/s

Fix versions

Story Points

Smart Checklist Progress

Smart Checklist

Created June 6, 2024 at 3:01 PM
Updated November 13, 2024 at 8:44 AM
Resolved October 30, 2024 at 10:47 AM