Huge Redash Query Results Size

Hello! Our Redash Query Results Size is becoming really big, is there a recommended way to address this? Is it safe to just go ahead and truncate the query_results table in the Redash metadata DB?

image

Another question: is there a way to pinpoint the exact query which may potentially cause the redash query results size to go that big? Or maybe list top 10 contributors to the query results size

Redash should periodically run a job called cleanup_query_results that deletes results older than QUERY_RESULTS_CLEANUP_MAX_AGE. You should see this in your logs. Are you certain that your scheduler is running?

You can of course truncate the database table. But Redash ought to take care of this on its own.