pg_stat_monitor: Performance improvement of pg_stat_monitor.
Description
How to document
None
How to test
None
Activity
Show:
Ibrar Ahmed November 15, 2022 at 5:19 PM
is related to that because improve performance.
Won't Do
Details
Details
Assignee
Ibrar Ahmed
Ibrar Ahmed(Deactivated)Reporter
Ibrar Ahmed
Ibrar Ahmed(Deactivated)Labels
Components
Affects versions
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created November 11, 2022 at 12:11 PM
Updated July 10, 2024 at 10:58 AM
Resolved June 6, 2024 at 6:29 PM
As we already have quite a lot in pg_stat_monitor. We need to look back and see what we can do to improve the performance of pg_stat_monitor. There are two aspects of performance improvements.
1 - Query time. The pg_stat_monitor should cause minimum query monitoring overhead.
2 - pg_stat_monitor view: There should be no lag when querying the pg_stat_monitor view.
We need to define acceptance criteria for these items.