3 ms·
- Loki doesn't allow queries without stream filters. This may be very inconvenient. For example, try selecting all the logs with the 'error' word in Loki. In Lo
by valyala 2y ago
- Loki doesn't allow queries without stream filters. This may be very inconvenient. For example, try selecting all the logs with the 'error' word in Loki. In LogsQL you just type 'error' and that's it!
- As I know, Loki doesn't allow selecting all the logs on the given time range. For example, try selecting all the logs for the last 5 minutes in Loki query language. In LogsQL this is just '_time:5m'.
- Loki has unreadable syntax for calculating analytics over the selected logs. For example, counting the number of logs with the 'error' word over the last 5 minutes in Loki looks like:
count_over_time({required="stream_filter"} | "error" [5m])
Compare this to LogsQL:
_time:5m error | stats count() as errors
- Loki doesn't allow calculating multiple stats in a single query. For example, try calculating the number of logs with the 'error' word, plus the total number of logs, over the last 5 minutes. In LogsQL this is easy:
_time:5m | stats count() if(error) as errors, count() as total
- As I know, Loki doesn't provide functionality for sorting of the returned logs.
- Loki can return only up to 5000 logs from a single query by default. VictoriaLogs allows returning billions of logs from a single query, without any performance and resource usage issues [1].
[1] https://docs.victoriametrics.com/victorialogs/querying/#command-line https://docs.victoriametrics.com/victorialogs/querying/#comm...
- BillFranklin 2y agoI think we are conflating Loki/VictoriaLogs (the UI, API, and log databases) and LogsQL vs LogQL (the syntax). > Loki doesn't allow calculating multiple stats in a single query Victoria's support for projecting multiple stats in one query is nice, with Loki's LogQL you need to write two separate queries. > Loki doesn't allow queries without stream filters True! I don't mind filtering for e.g. `{env: "production"}` but each to their own :-) --- RE Loki vs Victoria, which I don't really want to get into since I am not a vendor and have not tried Victoria... > Loki doesn't allow selecting all the logs on the given time range True! TBH I don't mind selecting a date from a date picker. One issue is that I guess it's going to be a bit slower to write precise date/time ranges if they're baked into the query language? > Loki doesn't provide functionality for sorting of the returned logs > Loki can return only up to 5000 logs from a single query by default I think these are Grafana UI restrictions -- as I wrote above there are indeed limitations with the Grafana UI, but I don't think they're necessarily syntax related.