Signoz postgres database tracing with open telemetry

Question

Im using self hosted version of signoz and i've tried adding

    endpoint: <POSTGRESQL_URL>:<POSTGRESQL_PORT>
    username: <POSTGRESQL_USERNAME>
    password: <POSTGRESQL_PASSWORD>
  postgresql/all:
    endpoint: <POSTGRESQL_URL>:<POSTGRESQL_PORT>
    transport: tcp
        username: <POSTGRESQL_USERNAME>
    password: <POSTGRESQL_PASSWORD>
    databases:
      - <YOUR DATABASE 1>
      - <YOUR DATABASE 2>
            # ... All databases you want to monitor
    collection_interval: 10s
    tls:
      insecure: true
      insecure_skip_verify: true

in otel-collector-config.yaml but it didn't help. I still have empty dashboard. I restarted docker container with the collector after i updated config. What am i doing wrong.

Answer 1

I think you forgot to add Postgresql to the metrics pipelines section. Eg:

service:
  telemetry:
    metrics:
      address: localhost:8888
  pipelines:
    metrics:
      receivers: [postgresql, postgresql/all]
      processors: [batch]
      exporters: [otlp]

Reference to visualization for this config: https://www.otelbin.io/s/180fda380204bfa1f1891415c50bfe0323efbb01