Add `airflow db clean-all-expired-sessions` ? command

[potiuk]

Body

With #33347 we already can cleanup session table with the same mechanism we have for all tables where --clean-before-timestamp == expiry. This is consistent with other tables, but 'session` table might have a dedicated command that will clean all the already expired sessions.

Committer

• I acknowledge that I am a maintainer/committer of the Apache Airflow project.

[arjunanan6]

I'd like to give this one a try, could you please assign it to me?

[potiuk]

Did.

[arjunanan6]

Will work on this soon.

[SeethalakshmiB]

Any update about this feature's availability. RIght now am experiencing DB Storage outage (95GB over 100GB) for airflow metadata DB, where session table utilized 92GB, This command would really helpful to clear them out.
thanks

[arjunanan6]

Hi @SeethalakshmiB, unfortunately, I've not been able to get started on this - too much going on. However, you can clear this out manually provided you have access to the metadata database. I assume that you are using the default session lifetime configuration of 30 days.

If that's the case, simply back up your session table and run (postgres syntax):

DELETE FROM session
WHERE expiry < NOW() - INTERVAL '30 days';

And of course, remember to run a VACUUM.