SweepPress: Website Cleanup and Optimization

SweepPress is an easy-to-use WordPress plugin built around 52 different Sweepers for database cleanup (the Pro version has 57), support for WP-CLI, and WP REST API to perform the cleanup operations. The plugin also features a powerful WordPress Options database table management panel.

Quick Video Overview

Options Management

The WordPress Options database table holds settings for WordPress Core, all the plugins, and themes. This table can grow significantly, especially since records are not auto-deleted when removing a plugin or theme. SweepPress has Sweepers that deal with transient cache records (stored in this table), and now, since version 3.0, it has a full Management panel where you can see all the records in the Options table, detect source for the record and status to help you decide if you should delete the record or not.

SweepPress has two methods to detect the source of the record, and it will mark all the recognized records. This panel doesn’t show transient records (used for cache) or WordPress options (deleting these options is a terrible idea). There is also a Quick Tasks subpanel, which can help you quickly remove options fitting into few standard predefined criteria.

Options deletion process is not automatic! No matter how precise options usage detection is, you need to verify and confirm that you want to delete one or more records.

SweepPress Pro also has advanced management panels for all the WordPress metadata and multisite Sitemeta database tables, including options to track the usage of meta-records, and remove all the entries from the database associated with specific meta.

Modes of Sweeping

• Auto Sweep: available on the dashboard, running many (not all) sweepers without user input.
• Quick Sweep: available on the dashboard, allowing the sweepers to be selected.
• Full Sweep: available on its panel, with detailed information about sweepers and no limit run.
• CLI Sweep: the plugin supports WP-CLI and adds commands to run all the sweepers with the command line.
• REST API Sweep: the plugin supports WP REST API and allows sweeping via the new REST endpoints.

All sweepers use optimized SQL queries to find the data for removal, which is also done using SQL queries. This is the fastest and most efficient way to remove a large amount of data quickly.

List of Sweepers

• Posts: Auto Drafts
• Posts: Spam Content
• Posts: Trashed Content
• Posts: Posts Revisions
• Posts: Posts Orphaned Revisions
• Posts: Draft Posts Revisions
• Posts: Postmeta Locks
• Posts: Postmeta Last Edits
• Posts: Postmeta Oembeds
• Posts: Postmeta Old Data
• Posts: Postmeta Orphans
• Posts: Postmeta Duplicates
• Comments: Spam Comments
• Comments: Trashed Comments
• Comments: Unapproved Comments
• Comments: Orphaned Comments
• Comments: Comments User Agents
• Comments: Commentmeta Orphans
• Comments: Commentmeta Duplicates
• Comments: Pingbacks Cleanup
• Comments: Trackbacks Cleanup
• Comments: Akismet Meta Records
• Terms: Terms Orphans
• Terms: Termmeta Orphans
• Terms: Termmeta Duplicates
• Terms: Term Relationships Taxonomy Orphans
• Terms: Term Relationships Objects Orphans
• Terms: AMP Validation Errors
• Terms: Unused Terms
• Users: Usermeta Orphans
• Users: Usermeta Duplicates
• Options: Expired Transients
• Options: RSS Feeds
• Options: All Transients
• Options: CRON Jobs
• Options: Unhooked CRON Jobs
• Network: Expired Transients
• Network: All Transients
• Network: Inactive Signups
• Database: Optimize Database Tables
• Database: Repair Database Tables
• ActionScheduler: Log Entries
• ActionScheduler: Orphaned Log Entries
• ActionScheduler: Failed Actions
• ActionScheduler: Completed Actions
• ActionScheduler: Canceled Actions
• bbPress: Replies Orphans
• BuddyPress: Activity Meta Orphans
• BuddyPress: Groups Meta Orphans
• BuddyPress: Messages Meta Orphans
• BuddyPress: Notifications Meta Orphans
• Elementor: Trashed Submissions

WP-CLI and WP REST API Support

The plugin registers new CLI commands for running sweep operations from the command line (WP-CLI is required). It also registers the REST API endpoint for the same purpose: running remote sweep operations (only for the administrator role!). CLI and REST API support can be enabled through plugin settings.

Action Scheduler Support

The plugin can clean up the ActionScheduler tables. These tables are used by the Action Schedule plugin and components developed for WooCommerce but also in many other WordPress plugins, including WP Rocket and Rank Math. For these sweepers to be visible, at least one plugin using those tables needs to be active.

Read the full description on the official page →