Feature: Dashboard ClickHouse query Query 1: ```SELECT resource_fingerprint FROM signoz_traces.distr...

Dang Huy Nguyen

08/01/2025, 6:02 AM

Feature: Dashboard ClickHouse query Query 1:

Copy code

SELECT resource_fingerprint
FROM signoz_traces.distributed_signoz_index_v3

-> Return result Query 2:

Copy code

SELECT resources_string
FROM signoz_traces.distributed_signoz_index_v3

-> Empty response Is it a bug? How to query by resources_string['deployment.environment'] ?

Hien Le

08/01/2025, 5:03 PM

Just needs a slight tweak from what you had:

Copy code

SELECT resources_string['deployment.environment']
FROM signoz_traces.distributed_signoz_index_v3 limit 100;

This query returned results for me using the Table panel type in Dashboard editor, although it wasn't 100 lines so I believe there's some extra mapping going on.

Dang Huy Nguyen

08/04/2025, 4:05 AM

Hi @Hien Le, thanks for your response. I tried it before but it does not return correct result. Btw have you used SigNoz on production? How it's going? I tried to adopt but seems it's still quite buggy.

Dang Huy Nguyen

08/04/2025, 4:22 AM

I only care 3 features: 1. Fast trace/logs query 2. SQL explorer, where I can slide and dice my telemetry 3. Application performance monitoring SigNoz seems good at 1 only, I tried query builder for 3 but does also got unexpected behavior

Hien Le

08/04/2025, 4:12 PM

I haven't tried much of 2 or 3 since it seems every backend has its own way of storing metrics / traces and writing queries by hand can get complicated. What slicing / dicing are you attempting that's not possible with the built-in query builder?

Hien Le

08/04/2025, 4:36 PM

I think the reason

limit 100

was need above was the

resource_string

attribute might not be on ALL metrics and a full-scan is expensive so the

timestamp

might be vital. If you describe the exact slicing/dicing you're attempting and why Query Builder isn't sufficient, maybe someone from Signoz could provide better guidance (than me) beyond just syntax.

Open in Slack

Previous Next

SigNoz Community

SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.