Danya Lutsevich
01/22/2024, 3:35 PMpostgres:
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.
Also I've set postgres in receivers section
service:
telemetry:
metrics:
address: localhost:8888
pipelines:
metrics:
receivers: [postgresql, postgresql/all]
processors: [batch]
exporters: [otlp]
this is my current otel config https://www.otelbin.io/s/1013ce74508abb2ff15c4e44482fca5014423e0d
I still have empty dashboard. I restarted docker container with the collector after i updated config.
I imported postgres dashboard from here https://github.com/SigNoz/dashboards/blob/main/postgresql/postgresql.json
What am i doing wrong.Rajat Dabade
01/22/2024, 7:10 PMDanya Lutsevich
01/23/2024, 2:09 PMSrikanth Chekuri
01/23/2024, 2:13 PMDanya Lutsevich
01/23/2024, 2:18 PMSrikanth Chekuri
01/23/2024, 2:22 PMSELECT count() from signoz_metrics.distributed_samples_v2 WHERE metric_name like '%postgres%';
Danya Lutsevich
01/23/2024, 2:22 PMDanya Lutsevich
01/23/2024, 2:24 PMSrikanth Chekuri
01/23/2024, 2:25 PMSELECT toDateTime(intDiv(max(timestamp_ms), 1000)) from signoz_metrics.distributed_samples_v2 WHERE metric_name like '%postgres%';
Danya Lutsevich
01/23/2024, 2:26 PMSrikanth Chekuri
01/23/2024, 2:26 PMDanya Lutsevich
01/23/2024, 2:27 PMDanya Lutsevich
01/23/2024, 2:27 PMDanya Lutsevich
01/23/2024, 2:29 PMSrikanth Chekuri
01/23/2024, 2:29 PMSELECT count() from signoz_metrics.distributed_time_series_v2 WHERE metric_name like '%postgres%';
Danya Lutsevich
01/23/2024, 2:30 PMSrikanth Chekuri
01/23/2024, 2:30 PMSELECT * from signoz_metrics.distributed_time_series_v2 WHERE metric_name like '%postgres%';
Srikanth Chekuri
01/23/2024, 2:30 PMDanya Lutsevich
01/23/2024, 2:31 PMDanya Lutsevich
01/23/2024, 2:36 PMSrikanth Chekuri
01/23/2024, 2:37 PMDanya Lutsevich
01/23/2024, 2:53 PM