search

lstn / misc-grafana-dashboards

Misc collection of grafana dashboards used to visualize Prometheus metrics for Kubernetes Cluster
Apache License 2.0
81 stars 25 forks source link

Usage questions #12

Closed kazazor closed 2 years ago

kazazor commented 2 years ago

Hi, I couldn't add a "Question" label - but that's the intent of this issue:

  1. This dashboard uses postgress-exporter, does it need to be installed on the same machine where my Postgres database is? Or will it work if installed on a different machine and just provide the DB connection details?

I'm asking that mainly for the CPU & Memory usage metrics.. For some reason I see my DB has very low RAM usage, seems wayyy too low IMO (FYI, I installed PG using docker on a k8s pod and postgres-exporter on another pod using docker).

Screen Shot 2022-01-22 at 21 25 39

  1. How can I understand the metrics around CPU time? Usually, you see CPU usage as a percentage, but here it's CPU time. How can one tell if it's low/mid/high? Maybe you can help transfer it to percentage instead of CPU time?

  2. Does it report also the storage of the DB? Meaning how much storage the DB is using. And even better, how much storage it has left on the machine..

  3. I see also the "Start Time" is always NA for me.

    Screen Shot 2022-01-22 at 21 29 16

Is that a problem on my end? Or in the dashboard?

  1. More of a pg-exporter question, but any special instructions on how to create the readonly user so everything will work? I did it this way: https://github.com/prometheus-community/postgres_exporter#running-as-non-superuser

Did I miss anything?

Thank you very much!

Radiergummi commented 1 year ago

@kazazor start time is also N/A for me, and as far as I can see, the related metric pg_postmaster_start_time_seconds is not even collected by postgres_exporter... Did you find a solution?