image.png
# supportr
Ri Sheng Chen, Sunny
07/29/2024, 4:05 AMimage.png
n
nitya-signoz
07/31/2024, 9:21 AMcan you check your sqlite db and share the status of
select * from feature_status;nitya-signoz
07/31/2024, 9:22 AMoh you have already shared
r
Ri Sheng Chen, Sunny
07/31/2024, 9:23 AMi have found the reason , i was build the image from pkg not ee.
after re build the image with ee path, it can work
n
nitya-signoz
07/31/2024, 9:23 AMOh got it. So you are building your own image.
r
Ri Sheng Chen, Sunny
07/31/2024, 9:23 AMwe want to improve the query performance
n
nitya-signoz
07/31/2024, 9:24 AMCan you share more details ?
r
Ri Sheng Chen, Sunny
07/31/2024, 9:27 AMyeah，Cause we have 100 million a day log, after insert the data.
The query for Dashboard & Alert will be very slow.
We want to add external index for 'app' or 'event' name
n
nitya-signoz
07/31/2024, 9:28 AMBy external indexes you mean clickhouse skip index right ? If thats the case then you can do it in the old explorer page which will materialize the column.
nitya-signoz
07/31/2024, 9:31 AMWe have a new perf improvements coming up for logs. ( check these two pr’s below)
https://github.com/SigNoz/signoz/pull/5528
https://github.com/SigNoz/signoz-otel-collector/pull/348
It will take sometime to be released for everyone, but you can build the images from those branches and try out locally. It has some major changes for filtering on resource attributes without indexing and will make it fast.
🙂 1
r
Ri Sheng Chen, Sunny
08/01/2024, 2:28 AMBy external indexes you mean clickhouse skip index right ? If thats the case then you can do it in the old explorer page which will materialize the column.if new explorer page will build materialize column? like OpenTelemetry resource service.name, or other attribute with our want to custom setting
n
nitya-signoz
08/01/2024, 4:24 PMSo all the resource attributes like
service.name2 Views