dosubot[bot] commented on issue #33283: URL: https://github.com/apache/superset/issues/33283#issuecomment-2839532034
<!-- Greeting --> Hello @ganeshvaidee! I'm [Dosu](https://dosu.dev), a friendly bot here to help you solve bugs, answer questions, and assist with becoming a contributor. I'm here while you wait for a human maintainer. Let's tackle your issue together! <!-- Answer --> Yes, there is a known issue with the logs table growing significantly since the 4.1.10 upgrade. This is due to changes that log more analytics events, potentially doubling the amount of data logged, and a schema change that allows for larger JSON data <sup>[[1]](https://github.com/apache/superset/blob/master/UPDATING.md)</sup><sup>[[2]](https://github.com/apache/superset/blob/master/superset/migrations/versions/2023-08-08_14-14_2e826adca42c_log_json.py)</sup>. To manage the logs table size, Superset provides a command to prune the logs table by deleting rows older than a specified retention period. You can use the `LogPruneCommand` class in `superset/commands/logs/prune.py` to specify the number of days for which records should be retained. Additionally, you can automate this pruning process by configuring the `prune_logs` task in the Celery beat schedule in the `superset/config.py` file to run at a specified interval <sup>[[3]](https://github.com/apache/superset/blob/master/superset/commands/logs/prune.py)</sup><sup>[[4]](https://github.com/apache/superset/blob/master/superset/config.py)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/2726f547-a941-424c-bb1f-b4a418acc847?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/2726f547-a941-424c-bb1f-b4a418acc847?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/2726f547-a941-424c-bb1f-b4a418acc847?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/2726f547-a941-424c-bb1f-b4a418acc847?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/2726f547-a941-424c-bb1f-b4a418acc847?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/2726f547-a941-424c-bb1f-b4a418acc847?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/2726f547-a941-424c-bb1f-b4a418acc847?feedback_type=other)</sup> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
