Stack Overflow
Stack Overflow

Questions tagged [prometheus-postgres-exporter]

8 questions
1
vote
0 answers

metrics from the postgres_exporter

I am working on postgres monitoring by referring to page, and my postgres_exporter version is v0.8.0, and found some metrics missing, for example: pg_stat_user_tables_n_tup_hot_upd pg_stat_user_tables_idx_scan pg_stat_user_tables_seq_scan Is there…
Eric
  • 11
  • 2
1
vote
1 answer

How to get pg_stat_user_tables n_tup_ins for timescale's compressed table?

We have a Prometheus Postgres Exporter set up and expect we can get stats of rows inserted into table pg_stat_user_tables: query: | SELECT current_database() datname, schemaname, relname, seq_scan, …
Eljah
  • 4,188
  • 4
  • 41
  • 85
0
votes
1 answer

Postgres Exporter unable to parse my customized queries.yaml file

I am helplessly trying to get my postgres exporter running but in vain. After running my postgres container and then running my postgres exporter container as the following : terminal1%docker network create --subnet=192.168.1.0/24…
javaistaucheineinsel
  • 421
  • 6
  • 14
0
votes
0 answers

I need a sample postgres_exporter.yml file for postgres exporter binary

I have a running instance of in my local centos/linux environment. I want to connect this postgres with prometheus using postgres exporter. The postgres exporter has a flag --config.file="path-to-config/postgres_exporter.yml" I am not able to get…
sitendra Nagesh
  • 1
0
votes
0 answers

using zlando postgres operator how to add custom labels and annotations to postgresql pod in kubernetes environment

In our kubernetes environment we deployed zlando postgres operator using helm chart and also deployed two postgres databases in two different namespaces. They are working fine without any issues. Now we got a requirement to add custom labels and…
user21050133
  • 33
  • 3
0
votes
1 answer

postgres_exporter SSL is not enabled on the server

I try to run postgres_exporter version 0.12.0 on my linux machine. And cant figured out the reason of error "SSL is not enabled on the server". Because I already set sslmode = disable. Here is example of my…
Axel HK
  • 75
  • 2
  • 8
0
votes
0 answers

how can I set postgres exporter query interval

Im using postgres exporter - https://github.com/prometheus-community/postgres_exporter/ I increased the scrape interval in servicemonitor in my k8s deploy but it looks like queries.yml is stil running every 15 sec is there any other things I should…
NoamiA
  • 521
  • 4
  • 19
0
votes
0 answers

How to find Memory used percentage by postgres DB using postgres-exporter

I am running postgres, postgres-exporter, prometheus, grafana and cadvisor all as docker containers. I need to find the percentage of memory used by postgres. My requirement is to send an alert when when postgres used more than 85% of memory. I used…
Velan
  • 21
  • 1
  • 3