Advanced Database Cleaner Premium helps WordPress administrators inspect database records and select what to clean. It covers unused, duplicated, expired, and orphaned data across posts, comments, metadata, transients, settings, tables, and cron jobs.

Review records and estimates before cleanup

Cleanup previews show available items by type, the database space associated with each type, and an estimate of the total space that may be freed. Sort preview rows by values such as name, date, size, or website ID. For supported values, view serialized or JSON content in its original or formatted form.

Filters narrow the records under review. The “Keep last X days” rule limits cleanup to data older than the specified number of days. Premium also supports “Keep last X items” rules, retaining a set number per parent, such as revisions for each post, or globally. These entry limits can be combined with day-based retention.

Choose cleanup areas

• Posts and comments: Clean old post and page revisions, auto-drafts, trashed posts, pending, spam, and trashed comments, pingbacks, and trackbacks.
• Metadata and relationships: Clean unused post, comment, user, and term metadata; unused relationships; and duplicated post, user, comment, and term metadata.
• Temporary data: Clean expired transients and oEmbed caches.
• WooCommerce: Clean orphaned product variations, orphaned customer analytics, and expired customer sessions.
• Action Scheduler: Premium cleanup covers completed, failed, and canceled actions, their corresponding logs, and orphan logs.

Inspect records and ownership

Management views provide details for tables, options, cron jobs, post and user metadata, transients, and post types. Depending on the record type, details include size, row count, value, autoload status, expiration, schedule, associated post or user, columns, and indexes. The plugin can flag items such as large autoloaded options, invalid table prefixes, cron jobs without valid actions, unused metadata, and duplicate metadata.

Premium combines a local scan with Remote SmartScan to help identify the owners of tables, options, metadata, transients, and cron jobs. Ownership results can indicate whether a plugin or theme is active, inactive, or not installed. Administrators can edit a misidentified owner, review multiple possible owners where applicable, and check remote scan credits. Premium filters can narrow records by owner, website ID, size, value, autoload status, expiration, cron frequency, and item status, including duplicated, unused, large, not yet scanned, or expired.

Schedule maintenance and review changes

Create scheduled cleanup tasks with separate item selections and retention rules. Premium supports any number of tasks, including schedules for database optimization or repair. Tasks can run once, hourly, twice daily, daily, weekly, monthly, or at another supported frequency; pause, resume, or delete them while keeping their settings. Per-task event logs record when a task ran, what it cleaned, and how many items it processed.

Database analytics track daily size and table counts, with daily and monthly charts, raw measurements, and per-table size and row changes. Addons Activity records plugin activations, deactivations, and uninstalls, along with theme switches and uninstalls, in a color-coded timeline using local time. Other administration tools include current database-size information, general logging, direct access to the WordPress debug log, configurable tabs, and multisite cleanup. Premium can clean one site or all sites in a network and filter records by site ID across management modules.