search

zubkov-andrei / pg_profile

Postgres historic workload reports
Other
236 stars 33 forks source link

Grafana dashboard annotations query non existent relation #75

Open Alexchertkov opened 1 year ago

Alexchertkov commented 1 year ago

Hi!

There are two annotations on Grafana dashboards. I get an error like this when I open the dashboard: image

If we check the query of both annotations - we can find out, that it queries metric_table, that is absent in the pg_profile schema

Query: SELECT extract(epoch from time_column) AS time, text_column as text, tags_column as tags FROM metric_table WHERE $__timeFilter(time_column) Found in version - Release 4.2

zubkov-andrei commented 1 year ago

Hello!

It looks strange. I can't find any mention of the "metric_table" anywhere in the dashboards provided in github repo. There was some changes in the dashboards since 4.2, you can try dashboards from the master branch. What is your grafana version?

Alexchertkov commented 1 year ago

Hi!

Grafna version is 9.2.0 image

What Grafana version do you recommend? Thanks.

zubkov-andrei commented 1 year ago

I've started development on v9.3.1.