chainlink-testing-framework icon indicating copy to clipboard operation
chainlink-testing-framework copied to clipboard

Enable statio user indexes collector for postgres exporter

Open emate opened this issue 1 year ago • 1 comments

Enable statio user indexes collector for prometheus-postgres-exporter to improve visibility for indexes usage.


Below is a summarization created by an LLM (gpt-4-0125-preview). Be mindful of hallucinations and verify accuracy.

Why

The changes update the Chainlink Helm chart for better customization and monitoring enhancements. Specifically, upgrading the chart version facilitates tracking of improvements or fixes. The addition of arguments for the Prometheus PostgreSQL exporter allows for more detailed database performance monitoring, crucial for maintaining the health and efficiency of the Chainlink node's database.

What

  • charts/chainlink/Chart.yaml
    • Incremented the chart version from 0.2.11 to 0.2.12. This change marks an update or improvement in the Helm chart.
  • charts/chainlink/templates/pg-deployment.yaml
    • Added an argument --collector.statio_user_indexes to the Prometheus PostgreSQL exporter container. This enables the collection of statistics about user-defined indexes, which can help in database performance tuning.

emate avatar Apr 09 '24 14:04 emate