Any way to export the logs from the ui?

[miran248]

Hey

Is there a way to download all logs (preferably in the raw form) within the specified timeframe from the frontend?
At the moment, it seems, one can only do it by setting the limit to some extremely large number, when calling the rest endpoint directly.
That or downloading it from clickhouse directly.

Thanks

[miran248]

Forgot about this thread so here's the late update.

While it's not possible to do it on the frontend, it's perfectly doable by querying clickhouse directly.

Steps

1. port-forward clickhouse (or expose it via ingress / httproute)

> KUBECONFIG=kube-config kubectl port-forward service/coroot-clickhouse -n coroot 8123:8123

2. enter the connection details in some clickhouse client (dbgate, ..)
   2.1. username is default
   2.2. retrieve the password by running the following command

> KUBECONFIG=kube-config kubectl get secrets coroot-clickhouse -n coroot -o json | jq -r ".data.password | @base64d" | pbcopy

3. run the following query (ingress-nginx in this case) to get the logs

SELECT
  "Body"
FROM
  "otel_logs"
WHERE "ServiceName" = '/k8s/ingress-nginx/ingress-nginx-controller'
AND "Timestamp" BETWEEN '2025-03-29' AND '2025-03-29 11:22:33'
ORDER BY "Timestamp" ASC

(note this table contains a shitton of rows so don't run it without filters :)