Database cleanup

Cleanup lists every kind of data the database no longer needs, each with a live count:

  • Post revisions, auto-drafts and trashed posts
  • Spam, trashed and pending comments, pingbacks and trackbacks
  • Orphaned post, comment, term and user meta, and duplicate meta
  • Orphaned term relationships and oEmbed caches
  • Expired transients
  • Content left by post types that no longer exist
  • Finished, failed and canceled Action Scheduler actions and their logs

Preview before you delete

Every type shows exactly which rows a cleanup would remove. Anything with a date can keep the last N days.

Scheduled cleanups

Give each cleanup type its own schedule: hourly, twice daily, daily, weekly or monthly, each with its own keep-the-last-N-days rule. Schedules are off until you turn one on. The riskier cleanups (duplicate meta, unregistered post types) can only be run by hand.

Can I undo a cleanup?

Cleanups of posts, comments, meta and tables are permanent, which is why each one shows a preview and asks first. Take a full database backup before a large cleanup.