#support

Deleting Logs and Traces for Docker

TLDR Vishal asked how to delete logs and traces for Docker. vishal-signoz provided a solution to truncate tables and shared steps to connect for Docker users.

6mo

Join the chat

Mar 06, 2023 (6 months ago)

Photo of md5-025a9ce02e4e73a327256dd5dc0f4401

Vishal

04:56 AM

@support how to delete all logs and traces for the docker ?

Photo of md5-f936d3e5743d23344d6c60813189716f

vishal-signoz

05:46 AM

If you are able to connect to clickhouse then you can truncate tables:

kubectl exec -n platform -it chi-my-release-clickhouse-cluster-0-0-0 -- sh

clickhouse client

// run below clickhouse queries to trunacte

truncate table signoz_logs.logs;

truncate table signoz_traces.signoz_index_v2;
truncate table signoz_traces.signoz_spans;
truncate table signoz_traces.signoz_error_index_v2;
truncate table signoz_traces.durationSort;
truncate table signoz_traces.top_level_operations;
truncate table signoz_traces.usage_explorer;

Vishal

05:47 AM

what about docker then?

vishal-signoz

05:47 AM

If you are using docker then try below commands to connect: https://signoz.io/docs/operate/clickhouse/connect-to-clickhouse/#for-docker-users

SigNoz Community

Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI

Indexed 825 threads (61% resolved)

Join Our Community Manage subscription

Similar Threads

Troubleshooting Full Disk Space and Removing Old Data

Romario faced full disk space issue and wanted to remove old data. Ankit guided them through installing ClickHouse client, truncating tables, and using `docker system prune` to clear space.

4mo

Cleaning Up Signoz Clickhouse Data without Reinstalling

Muhammed wanted to clean up signoz clickhouse data without losing settings. Srikanth provided a list of queries for truncating tables. Issue was resolved after truncating the 'logs' table.

6mo

Removing SigNoz's Own Logs from Dashboard

Geoffrey wanted to remove SigNoz's own logs from the dashboard. nitya-signoz provided a solution referencing an existing issue and a filter for ingesting only desired logs.

3mo