Big "public.authentik_tasks_task" table

[Billos]

Hello, my public.authentik_tasks_task table is getting pretty big, around 350 MB, can I safely empty its content, or at least a part of it ?

[rissson]

I'd recommend adjusting the following setting:

• https://docs.goauthentik.io/install-config/configuration/#authentik_worker__task_purge_interval
• https://docs.goauthentik.io/install-config/configuration/#authentik_worker__task_purge_interval
  I'm quite curious by the output of the following queries before you prune that table:

select count(*), actor_name from authentik_tasks_task group by actor_name;
select count(*), date_trunc('day', mtime) as mdate from authentik_tasks_task group by mdate order by mdate;

[Billos]

select count(*), actor_name from authentik_tasks_task group by actor_name;

"count"	"actor_name"
5	"authentik.events.tasks.notification_cleanup"
4	"authentik.enterprise.policies.unique_password.tasks.trim_password_histories"
38	"authentik.admin.tasks.update_latest_version"
12	"authentik.outposts.tasks.outpost_connection_discovery"
3	"authentik.events.tasks.notification_transport"
45	"authentik.blueprints.v1.tasks.blueprints_discovery"
1	"authentik.providers.proxy.tasks.proxy_on_logout"
1	"authentik.providers.oauth2.tasks.backchannel_logout_notification_dispatch"
1	"authentik.tasks.tasks.clean_worker_statuses"
2	"authentik.enterprise.policies.unique_password.tasks.check_and_purge_password_history"
168	"authentik.outposts.tasks.outpost_send_update"
45	"authentik.blueprints.v1.tasks.clear_failed_blueprints"
39	"authentik.crypto.tasks.certificate_discovery"
132	"authentik.events.tasks.event_trigger_handler"
7	"authentik.enterprise.providers.ssf.tasks.ssf_events_dispatch"
17	"authentik.outposts.tasks.outpost_controller"
33	"authentik.events.tasks.event_trigger_dispatch"
5	"authentik.outposts.tasks.outpost_token_ensurer"
1	"authentik.providers.oauth2.tasks.send_backchannel_logout_request"
13	"authentik.sources.oauth.tasks.update_well_known_jwks"
19	"authentik.enterprise.tasks.enterprise_update_usage"
3762	"authentik.outposts.tasks.outpost_service_connection_monitor"
459	"authentik.core.tasks.clean_expired_models"
422	"authentik.core.tasks.clean_temporary_users"
1	"authentik.outposts.tasks.outpost_session_end"

And select count(*), date_trunc('day', mtime) as mdate from authentik_tasks_task group by mdate order by mdate;

"count"	"mdate"
976	"2025-09-26 00:00:00+00"
333	"2025-09-27 00:00:00+00"
1941	"2025-09-28 00:00:00+00"
1985	"2025-09-29 00:00:00+00"

[rissson]

thanks!

[Billos]

The issue was in my worker, that could not access the docker socket.
The tasks are now being processed correctly.