pgadmin-org / pgadmin-org/pgadmin4
Transactions per second on dashboard is incorrect for refresh rates other than 1s
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 3.8k
- Forks
- 891
- Avg merge
- 4d 7h
- Merged PRs (30d)
- 8
Description
On database dashboard, there is chart for "Transactions per second". However, it only shows correct numbers, if you have refresh rate 1s (which is not default, default is 5s). Otherwise it shows transactions per refresh interval.
Steps to reproduce the behavior:
- Start any consistent workload, for example 10 queries/s
- Go to database dashboard for that database
- "Transactions per second" will show 50 (if you have default refresh interval of 5s)
- Go to preferences, dashboard, refresh intervals, set 1s
- Look at dashboard again, it will show correctly 10
Expected behavior
Metric "Transactions per second" should be normalized for sampling rate, so it always show Transactions per second
pgAdmin version 9.16
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No source file or test is named. Reproduce the dashboard behavior with a consistent workload and 5-second versus 1-second refresh intervals, then trace the Transactions per second metric and verify that its displayed value is normalized to the per-second rate at both intervals.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- databases, observability
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 65/100