Problem defining new metrics via PG Watch 3 UI

[emreyaniktr]

Hello, I am using the Pgwatch3 docker container version. I want to get metrics from PostgreSQL Clusters. I want to add new metrics via Pgwatch UI but I have not been able to do it. I am trying to add metrics with the New option at http://127.0.0.1:8080/metrics. The metric definitions I added are as follows.

Name: test_emre
gauges: *
SQLS:

select /* pgwatch_generated */
(extract(epoch from now()) * 1e9)::int8 as epoch_ns,
(sum((pg_stat_file('pg_wal/' || name)).size))::int8 as wal_size_b
from pg_ls_waldir()

After adding the metric, I get a Success response, but I can't see this metric on the metrics screen, in metrics.yaml, or in the pgwatch.metric table. Is this feature currently active? Has anyone tested it?

[ondar]

Adding metrics through UI is a bit tricky, you need to add it as YAML, see metrics.yaml.
metrics.yaml is read-only and never changed by pgwatch. But you can change it.

[ondar]

See #530 and #531

[emreyaniktr]

I cannot add or delete metrics via UI. It returns Success but it does not work. The metric I added to the Metric.yaml file is not recorded in the database and does not collect metrics. When I insert the metric into the database myself, it appears in the UI but still does not collect metrics. For example, I duplicated the sequence_health metric and saved it as emre_deneme2. But in reality, I cannot see such a metric in the database or on the UI. What should I do to make this metric active?

[ondar]

See the metric below, you are missing PG version 11: |- assuinng your metrics is the same for all potgreses above and including version 11. If you need different metrics for let say ver 17, then you need 2 blocks one for ver 11-16 with 11: |- and then 17+ with 17: |-.

Another problem might be that you added metric, but did you add it to the metric profile you use for your monitored DB (like exhaustive), or you can skip the profile and add metrics with their run interval directly to monitored DB config.

[ondar]

Sorry, you have the version there, maybe more spaces, but that should be ok. Try checking the profile then 😀

[pashagolub]

Hello. What Docker image do you use?

[emreyaniktr]

Hi, The version of the image I am using: cybertecpostgresql/pgwatch-demo:3.1.0

[pashagolub]

Thanks. I can confirm this is a bug. We are on it! #664

[emreyaniktr]

Thank you, I will continue by temporarily adding an insert to the table.

[ondar]

Modifying metrics.yaml should work too (I have used it already). But you must also modify presets at the end adding your new metrics to the preset you use on your monitored DB.

[pashagolub]

1. metrics.yaml is another way to represent config and, of course, it should work. As well as database config.
2. You MUST NOT add any metrics to any preset. You CAN add metric to preset for your comfort but you CAN use any metric without preset.