Is there a way to see what "metrics" you have avai...
# supportp
Patrik Potocki
02/10/2022, 9:10 AMIs there a way to see what "metrics" you have available? cause quite hard to build those dashboard without knowing all metrics available.
For example I tried to find what metrics you get from the
kubeletstats✅ 1
p
Pranay
02/10/2022, 10:43 AM
hey @User Yeah its not the best of experience as of now and we are working on it.
Pranay
02/10/2022, 10:43 AM
Some metrics for kubernetes if you followed the tutorial can be found here - https://signoz.io/docs/tutorial/kubernetes-infra-metrics/#list-of-metrics-from-kubernetes-receiver
Pranay
02/10/2022, 10:45 AM
You can connect to SigNoz'a clickhouse instance and find the metrics SigNoz is storing. You can follow something like below
1. Install Clickhouse client
2. Connect to clickhouse instance in SigNoz
./clickhouse client --host <SigNoz IP> --port 9001select * from signoz_metrics.time_seriesselect DISTINCT(labels) from signoz_metrics.time_seriesselect DISTINCT(labels) from signoz_metrics.time_series INTO OUTFILE 'output.csv'Pranay
02/10/2022, 10:48 AM
@User do add if you have any more ideas here
a
Ankit Nayan
02/10/2022, 11:16 AM
For point 2 to work, you need to expose and map ports in docker-compose somewhere here https://github.com/SigNoz/signoz/blob/main/deploy/docker/clickhouse-setup/docker-compose.yaml#L6
Copy code
ports:
- "9001:9000"p
Patrik Potocki
02/10/2022, 11:56 AMThanks guys gonna give it a try 🙂
Patrik Potocki
02/10/2022, 12:20 PMworked fine just did:
kubectl port-forward svc/signoz-clickhouse 8123:8123a
Ankit Nayan
02/10/2022, 12:30 PM
awesome🙌
p
Patrik Potocki
02/10/2022, 12:40 PMthis query is even better if you want just the labels 🙂
Copy code
select DISTINCT(JSONExtractString(labels,'__name__')) from signoz_metrics.time_series💯 1
14 Views