Postgres monitoring

stitch data pour faire de la réplication dans la DWH

Postgre replication

stitch data to replicate in the DWH Postgre replication

Helm chart: https://github.com/prometheus-community/helm-charts/tree/main/charts/prometheus-postgres-exporter

All metrics: https://github.com/prometheus-community/postgres_exporter/blob/master/queries.yaml

Elasticsearch monitoring

JVM Pressure + average response time

Elasticsearch Heap

Average response time can use the metrics:

I think it can be calculated by:

• elasticsearch_indices_search_query_time_seconds (Total search query time in seconds) / elasticsearch_indices_search_query_total (Total number of queries)

These metrics are not supported by Elasticsearch_exporter (see more in the below link

• JVM Pressure
• Elasticsearch Heap

Helm chart: https://github.com/helm/charts/tree/master/stable/elasticsearch-exporter

Elasticsearch_exporter: https://github.com/prometheus-community/elasticsearch_exporter

List of supported metrics: https://github.com/prometheus-community/elasticsearch_exporter#metrics

Top metrics:

• https://sematext.com/blog/top-10-elasticsearch-metrics-to-watch/