#zincobserve

Metrics Page Support and Improving Multi-Host Filtering

TLDR Gaby wants better support for multiple sources in Metrics with filtering options. Prabhat suggests using charts with host filters. They discuss possible improvements, such as adding filtering controls, limiting capabilities, and better organization methods for metrics across hosts.

Powered by Struct AI
👍 3
🎉 2
🙌 2
😂 1
May 17, 2023 (2 weeks ago)
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
12:54 AM
Does the Metrics page support multiple sources? I'm trying to figure out if sending Metricbeat data from multiple hosts would make any sense but there's no way to filter metrics based on a field (ex hostname).
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
07:24 AM
Currently there is no way to do that on the metrics page. This is bare bones and first version for now. It will get more features slowly and should allow such functionality, For now, you can chart the metrics on the dashboard page with filters. That should work well.
👍 2
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
11:40 AM
I was going to use charts, but the dashboards are unreadable when you have several hosts. The pie chart tries to fit every single value into it even if it has 0.0n%
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
11:42 AM
you can filter it by host in charts
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
11:59 AM
Yeah, but if you have let's say +10 hosts. It splits the chart in weird ways. Unlike Kibana which lets you choose Top N results. I think it defaults to Top 10

Another option would be adding a new chart type that only filters data, like the "Data Control" visualization from Kibana. That way all the charts/visualizations get filtered by the value on the Data Control

See: https://www.elastic.co/guide/en/kibana/current/add-controls.html#filter-the-data-with-options-list-controls
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
12:01 PM
both suggestions make sense.
03:40
Prabhat
03:40 PM
you could also do a limit of 10 in the result dashboards here. limit 10
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
10:54 PM
As in with a custom query?
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
11:03 PM
Claude do you have any suggestion?
Claude
Photo of md5-aff86117ddf518b5b2a48745761e4cf9
Claude
11:03 PM
Here are some suggestions to improve filtering and managing metrics from multiple hosts in Metrics:

1. Add filtering controls like Options List, Range Slider and Time Picker that Kibana has. This will allow filtering metrics by hostname, time range, etc. These controls can filter all visualizations on the dashboard.

2. Add a "top N" option to limit the number of series shown in charts. This can help reduce clutter from too many hosts.

3. Add the ability to save filtered dashboards. For example, a dashboard filtered to only show metrics for host1 and host2. This can make dashboards more manageable.

4. Support filters in queries to limit the number of hosts returned. For example, host: host1 OR host: host2 would only return metrics from host1 and host2.

5. Add a "data source" dashboard which shows a list of hosts reporting metrics. This can act as a filtering control where selecting some hosts will filter the main dashboard.

6. Consider adding multiple "dashboard tabs" for the same data, but with different filters applied. For example, have one tab for hosts 1-5, one for hosts 6-10, etc. This may provide more focused dashboards.

7. Add an option to "group by" host (or other field) to show aggregate metrics and then the ability to drill down into specific hosts. This can provide high-level overviews that still allow drilling into detail.

Overall, more robust filtering options, limiting capabilities and better ways to organize metrics across many reporting hosts will help provide a good experience with large data sets in Metrics. Please let me know if you have any other questions!
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
11:04 PM
Gaby I was just trying claude AI to see if it was any helpful. 🤣 Guess it was not.
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
11:14 PM
😂😂😂!
11:15
Gaby
11:15 PM
I do remember back in v0.3.x there was an option to limit results to N. But it was removed
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
11:16 PM
You could still turn to custom SQL mode and and limit 10 at the end to reduce the output.
11:17
Prabhat
11:17 PM
Image 1 for
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
11:19 PM
Hmmm, ok. May be useful to have an option for that in the X, Y, Filter section 😂
11:19
Gaby
11:19 PM
I'm not a huge fan of the custom sql section, since it doesnt translate an existing Chart into Query
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
11:27 PM
it does translate though. You can take the existing chart and open the custom SQL tab and it shows you the entire SQL.
11:28
Prabhat
11:28 PM
click on custom sql and modify what you want in existing sql
11:28
Prabhat
11:28 PM
you just need to add the fields again in the fields area
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
11:33 PM
Ahhhh, that's why 😂
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
11:35 PM
a minor annoyance I hope. We need to do this as we have no idea what new fields can come up in custom SQL.
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
11:37 PM
Yeah, makes total sense
11:41
Gaby
11:41 PM
ZO is awesome btw. I'm just trying to slowly move everything away from ELK to ZO
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
11:41 PM
Thanks for the feedback. Is it for work or personal stuff?
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
11:41 PM
Already replaced logstash with Vector. In the process of replacing Kibana/ES with ZO
👍 1
11:42
Gaby
11:42 PM
Both work and home lab
🎉 1
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
11:42 PM
We appreciate your constructive honest feedbacks.
🙌 1
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
11:43 PM
ZincLabs should advertise their releases in the #selfhosted reddit https://www.reddit.com/r/selfhosted
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
11:46 PM
Yes. We plan to do that and a lot more. Just waiting on a couple of things. r/devops is also a great sub.
May 18, 2023 (1 week ago)
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
12:08 AM
Awesome! 🙌
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
12:39 AM
QQ -
12:40
Prabhat
12:40 AM
What are the major reasons for you to move from ELK to ZincObserve
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
01:08 AM
ELK uses a ton of resources and relies on legacy tech. ZO on the other hand uses modern tech and techniques like parquet files, zstd compression, Vue, etc
01:08
Gaby
01:08 AM
Right now i'm avg around 500-1GB for ZO + Nginx + Vector, compared to just Logstash using 8GB of ram 😂
01:11
Gaby
01:11 AM
Ease of use was another reason. Setting up ELK requires a lot of manual tasks to get the index, initial accounts, etc setup. ZO is super easy to start (only thing missing is having pre-defined ingest tokens)
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
01:12 AM
Wow, Great points. Thanks a lot.
01:12
Prabhat
01:12 AM
What do you mean by missing predefined ingest tokens? You get them from the UI already. right?
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
01:28 AM
So when I started playing with ZO, I had to constantly stop/start Vector to change the auth token. Since it changes on each brand-new deployment of ZO. Not a big deal to be honest
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
01:29 AM
Ah, got it.
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
01:34 AM
😂 I think the feature i'm most looking forward is Dark Mode, and enhanced dashboards/metrics. But mostly dark mode 😬
😂 1
01:34
Gaby
01:34 AM
At home i'm able to query through 2-4 million syslog events within 1 second, which is amazing
🎉 1
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
01:35 AM
Awesome. BTW, We are getting syslog ingestion directly in ZincObserve without need for vector. API is ready. We just need to build the UI for configuring it.
🙌 1
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
01:39 AM
Looking forward to that! I was going to suggest making the endpoint /syslog instead of `/syslog-server``
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
01:40 AM
It will be a standard log stream for query. You will also have the option to name the stream yourself.
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
01:43 AM
Ahhh, sounds good then :-D
02:29
Gaby
02:29 PM
Prabhat I'm trying to organize data into separate streams. Like:

• Syslog
• Nginx
• Docker Logs
But there's no way to search across multiple streams 🤔
Prabhat
Photo of md5-23052f31f8f3c4b1bb3297fbc3a2aec5
Prabhat
02:54 PM
Not yet. We have an open issue on that. It’s a big effort and big priority item. We will get to it soon.
Gaby
Photo of md5-540a8e08ce1c199c4efaeb0388742259
Gaby
03:07 PM
Thanks! 😁