Database Information and Maintenance
You do not need to setup a cleanup cron anymore as there is now an automatic cleaning process in Invidious. Since this pull request: [https://github.com/iv-org/invidious/pull/3294](https://github.com/iv-org/invidious/pull/3294). But this page is left in case you need to manually cleanup the database.
Invidious needs one PostgreSQL database which has the following tables.
annotationsCaches annotation data if
cache_annotationsis enabled in
channel_videosStores truncated video info, used to create user feeds
channelsStores UCID and author name
noncesKeeps track of tokens issued to prevent CSRF
usersStores user info, such as preferences, username, subscriptions
session_idsKeeps track of user sessions
videosStores video cache, used to create "top" page
videos grows a lot and needs the most storage. You can clean it up using following commands:
$ sudo -i -u postgres $ psql invidious -c "DELETE FROM nonces * WHERE expire < current_timestamp" $ psql invidious -c "TRUNCATE TABLE videos" $ exit
For regular maintenance you should add a cronjob for these commands