Many maintenance jobs can be started from the UI.

• Run all non slow maintenance operations:
  • This option will run all the maintenance jobs except: Reindexing, vaccum, removing orphaned files.
• Run all maintenance operations:
  • This option will run all the maintenance jobs that are listed here.
• Validate folder contents:
• Remove orphaned gold files:
  • Use this option to remove all the gold files that are not more associated with any upload.
• Remove orphaned rows from the database
  • Use this option to remove all the database extras which doesn't have any file information.
• Remove orphaned log files from the system
  • Use this option to remove all the log files that are not more associated with any upload.
• Normalize pirority:
• Remove uploads with no pfiles:
  • Removes uploads where there is not a single file attached to it.
• Remove expired personal access tokens
  • You may want to remove the expired personal tokens.
• Remove orphaned temp tables
  • This option will remove all the temp tables that are not usable anymore.
• Vacuum Analyze the database
  • VACUUM reclaims storage occupied by dead tuples. check this option to run it for whole database.
• Remove orphaned files from the repository: This can take a while
  • This option checks and delete the file which doesn't belong to any upload but still exist in file system.
• Reindexing of database: takes 5-10 minutes, so execute only when the system is not in use
  • To reindex all the indexes that are associated with each table (More time based upon data)
• Verbose: turns on debugging output
  • Check this option to print the output of each running job in job log of maintenance agent.
• Remove older gold files from repository.
  • This option will remove all the gold files before the specified date.
• Remove older log files from repository.
  • This option will remove all the Log files before the specified date.

Once you are ready with the options you may click on "Queue maintenance agent" to start the jobs.