https://signoz.io logo
Join Slack
Powered by
This message was deleted.
# support
s
This message was deleted.
r
@Srikanth Chekuri Can you please have a look to this. Thank you.
❤️ 1
d
any ideas?
s
Are you sure postgres metrics are getting collected properly? Do you see any error logs in collector container?
d
no error logs, i saw errors when i accidentally typed unwanted space in otel-config.yaml, i got syntax error but now syntax is ok
s
Can you exec into clickhouse and check it there are prostgres metrics there?
Copy code
SELECT count() from signoz_metrics.distributed_samples_v2 WHERE metric_name like '%postgres%';
d
yes one sec
s
Copy code
SELECT toDateTime(intDiv(max(timestamp_ms), 1000)) from signoz_metrics.distributed_samples_v2 WHERE metric_name like '%postgres%';
Can you select the longer time range 6hrs in charts and check again?
d
no data still
even in 1 week range
s
Copy code
SELECT count() from signoz_metrics.distributed_time_series_v2 WHERE metric_name like '%postgres%';
Copy code
SELECT * from signoz_metrics.distributed_time_series_v2 WHERE metric_name like '%postgres%';
Can you share output
d
yes, but i will remove db names
s
Ok, you don't have any metrics in the table that are used in the dashboard. There is only a table and db count. Please check why other metrics are not getting collected.
👀 1
d
https://signoz.io/blog/opentelemetry-postgresql-metrics-monitoring/#metrics I wonder why these metrics are not enabled by default
63 Views
Open in Slack
PreviousNext
Powered by