Sitelet https://github.com/cybertec-postgresql/pgwatch/pull/833
Skip to content

[-] fix jsonb null in "Top Tables" and "Health-check" dashboards - #833

Merged
pashagolub merged 2 commits into
cybertec-postgresql:masterfrom
kmoppel:grafana-top-tables-pg-fix-null-handling
Jul 4, 2025
Merged

pashagolub merged 2 commits into
cybertec-postgresql:masterfrom
kmoppel:grafana-top-tables-pg-fix-null-handling

Conversation

@kmoppel

@kmoppel kmoppel commented Jul 4, 2025

Copy link
Copy Markdown
Contributor

Not all NULL metric values were handled correctly and Grafana can give: Status: 500. Message: db query error: pq: cannot cast jsonb null to type bigint

Not all NULL metric values were handled correctly and Grafana can give:
Status: 500. Message: db query error: pq: cannot cast jsonb null to type bigint
@coveralls

coveralls commented Jul 4, 2025 •

Copy link
Copy Markdown

Pull Request Test Coverage Report for Build 16076013282

Details

  • 0 of 0 changed or added relevant lines in 0 files are covered.
  • No unchanged relevant lines lost coverage.
  • Overall coverage remained the same at 61.753%

Totals Coverage Status
Change from base Build 16056308847: 0.0%
Covered Lines: 2769
Relevant Lines: 4484

馃挍 - Coveralls

So replace all "data->$col" with "data->>$col"
@kmoppel kmoppel changed the title [-] PG "Top Tables" fix NULL column handling [-] PG "Top Tables" and "Health-check" dash - fix NULL column handling Jul 4, 2025
@pashagolub pashagolub changed the title [-] PG "Top Tables" and "Health-check" dash - fix NULL column handling [-] fix jsonb null in "Top Tables" and "Health-check" dashboards Jul 4, 2025
@pashagolub
pashagolub merged commit 3c8cd51 into cybertec-postgresql:master Jul 4, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants