Advanced Database Cleaner Premium

Advanced Database Cleaner Premium helps WordPress administrators inspect database records, decide what to remove, and organize recurring maintenance. Preview candidates and estimated space by cleanup type, then review individual records before taking action. Estimates show database space associated with the candidates; they do not predict a specific performance gain.

Review cleanup candidates

Preview tables can be sorted by fields such as name, date, size, or website ID. For supported values, view serialized or JSON data in its original or formatted form. Filters and retention rules help narrow the records under review. Set a keep last X days rule to focus cleanup on older data. Premium also works with keeping a set number of entries per parent, such as revisions per post, or globally.

Choose what to clean

General cleanup covers old post and page revisions, auto-drafts, trashed posts, pending, spam, and trashed comments, pingbacks, trackbacks, unused metadata and relationships, expired transients, duplicated metadata, and oEmbed caches. Metadata cleanup includes post, comment, user, and term meta. WooCommerce cleanup covers orphaned product variations, orphaned customer analytics, and expired customer sessions.

Premium adds cleanup for completed, failed, and canceled Action Scheduler actions, their corresponding logs, and orphan logs.

Inspect database areas and ownership

Management views provide details for tables, settings, cron jobs, post types, metadata, and transients. Depending on the view, you can inspect values, sizes, row counts, expiration, autoload status, schedules, or related records. Table utilities include viewing table contents and structure, optimizing or repairing tables when the plugin identifies a need, converting tables to InnoDB, and cleaning or deleting tables. Options can be reviewed and their autoload status changed. Cron views show scheduled task details and help identify jobs without valid actions. Post type views show counts and visibility and identify orphaned types.

Premium combines local scanning with Remote SmartScan to help identify the owners of tables, options, post meta, user meta, transients, and cron jobs. Ownership results can include multiple possible owners and indicate whether an owner is active, inactive, or not installed. You can edit an ownership assignment when it is misidentified and check remote scan credits. Premium filters can narrow records by properties such as size, value, autoload, expiration, owner type, website ID, or cron frequency, and by states such as duplicated, unused, large, expired, orphaned, or not yet scanned.

Schedule maintenance and track changes

Create cleanup tasks for selected entry types and set retention rules for each task. Schedules can execute once, hourly, twice a day, daily, weekly, or monthly. You can also schedule database optimization and repair, pause or resume tasks, and create multiple routines with different settings. Premium supports unlimited automation tasks and provides per-task event logs with execution times, actions, and item counts.

Database analytics record daily database size and table counts, with daily and monthly growth charts, raw measurements, and table-level size and row changes. Select multiple tables to compare their changes and investigate unusual growth. Addons Activity tracks add-on activations, deactivations, and uninstalls, along with theme switches and uninstalls, in a timeline using local time.

Other administration tools include current database-size information, error logging, access to the WordPress debug log, configurable plugin tabs, and multisite support. From the main site, administrators can run network-wide cleanup and optimization and filter records by site.

Get started

Install and activate Advanced Database Cleaner Premium in WordPress. Open the plugin interface, review the available database records, and select filters or retention rules for the cleanup. Preview candidates before removing them, then use logs and the debug-log view when investigating an issue.