This message was deleted SigNoz Community #support

Join Slack

This message was deleted.

# support

Slackbot

02/10/2022, 9:10 AM

This message was deleted.

✅ 1

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 9001

select * from signoz_metrics.time_series

_signoz_metrics.time_series is a table_ 3. Find distinct labels available ( this may not be very accessible so we recommend step 4)

select DISTINCT(labels) from signoz_metrics.time_series

4. If needed, dump in a csv file and parse it locally

select DISTINCT(labels) from signoz_metrics.time_series INTO OUTFILE 'output.csv'

- for dumping into a csv to parse via searching

Pranay

02/10/2022, 10:48 AM

@User do add if you have any more ideas here

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"

Patrik Potocki

02/10/2022, 11:56 AM

Thanks guys gonna give it a try 🙂

Patrik Potocki

02/10/2022, 12:20 PM

worked fine just did:

kubectl port-forward svc/signoz-clickhouse 8123:8123

and used datagrip thanks 🙂

Ankit Nayan

02/10/2022, 12:30 PM

awesome🙌

Patrik Potocki

02/10/2022, 12:40 PM

this query is even better if you want just the labels 🙂

Copy code

select DISTINCT(JSONExtractString(labels,'__name__')) from signoz_metrics.time_series

💯 1

32 Views

Open in Slack

Previous Next