What should be the content of queries.yaml from postgres-exporter?

[iosifnicolae2]

Hi.

I've tried to use this dashboard but most of the graphs are without data.

Most likely, your queries.yaml file is different than the default one..

[iosifnicolae2]

I've managed to fix most of the graphs by updating some of the metrics to be compatible with the default queries.yaml file.
https://gist.github.com/iosifnicolae2/054be1ab581735d4d8c9b199bc57cfb0

[patsevanton]

Hello! Now i dont monitoring PostgreSQL. You can create Pull request for fix this issue. Thanks for help.

[c4710n]

For guys who want to use this dashboard:

1. PostgreSQL: install pg_stat_statements
2. postgres-exporter: set option - --extend.query-path= with queries.yaml
3. (optionial): if you are using PostgreSQL >= 13, then above queries.yaml should be modified by following content:
   • total_time -> total_exec_time
   • min_time -> min_exec_time
   • max_time -> max_exec_time
   • mean_time -> mean_exec_time
   • stddev_time -> stddev_exec_time

All panels should work as expected, now. ;)

[c4710n]

@patsevanton Thank you for providing this cool stuff. 👍

[patsevanton]

I am sorry. I am not currently monitoring postgresql.

[patsevanton]

I can merge Pull request )