search

patsevanton / postgresql_overview_postgres_exporter

Postgresql overview dashboard for postgres_exporter
Apache License 2.0
19 stars 13 forks source link

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

Open iosifnicolae2 opened 3 years ago

iosifnicolae2 commented 3 years ago

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..

image

iosifnicolae2 commented 3 years ago

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 commented 3 years ago

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

c4710n commented 1 year ago

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 commented 1 year ago

@patsevanton Thank you for providing this cool stuff. 👍

patsevanton commented 1 year ago

I am sorry. I am not currently monitoring postgresql.

patsevanton commented 1 year ago

I can merge Pull request )