Title: DBStorage Insights Author: WPExtent Published: June 28, 2026 Last modified: June 28, 2026 --- Search plugins ![](https://ps.w.org/dbstorage-insights/assets/banner-772x250.png?rev=3588442) ![](https://ps.w.org/dbstorage-insights/assets/icon.svg?rev=3588442) # DBStorage Insights By [WPExtent](https://profiles.wordpress.org/wpextent/) [Download](https://downloads.wordpress.org/plugin/dbstorage-insights.1.2.0.zip) * [Details](https://wordpress.org/plugins/dbstorage-insights/#description) * [Reviews](https://wordpress.org/plugins/dbstorage-insights/#reviews) * [Installation](https://wordpress.org/plugins/dbstorage-insights/#installation) * [Development](https://wordpress.org/plugins/dbstorage-insights/#developers) [Support](https://wordpress.org/support/plugin/dbstorage-insights/) ## Description **DBStorage Insights** is a single, no-nonsense audit tool that answers the question_“ why is my WordPress site this big?”_ — both on disk and in the database — and gives you safe, one-click cleanup for the most common culprits. Everything happens inside **Tools -> DBStorage Insights**. No external services. No tracking. No premium upsell. Just real numbers. #### What it shows you The plugin is organized into nine focused tabs: * **Posts & Pages** — database size used by each post (content + revisions + postmeta + comments), sortable, filterable by post type, searchable. Delete revisions per post or site-wide. * **Plugins** — disk size of every plugin in `wp-content/plugins/`, with active/ inactive status and file count. **Click any plugin name** to drill down and see exactly where its disk space goes: top-level folders, file-type breakdown, and the 20 largest individual files. Finally know why that one plugin is 350 MB. * **Themes** — disk size of every theme, with active / parent / inactive status. Same drill-down view as plugins. * **Autoload & Transients** — total autoload weight, the 20 largest autoloaded options (the #1 hidden performance killer in WordPress), and a one-click “Disable autoload” button per option. Core options are flagged so you don’t break the site. Plus: expired and orphaned transient counts with a single-button cleanup. * **Database & Cleanup** — raw `SHOW TABLE STATUS` for every table (rows, data, index, reclaimable overhead) with a per-table **Optimize** button. One-click cleanup for orphaned postmeta, orphaned termmeta, spam comments, trashed comments, trashed posts, and abandoned auto-drafts. Known high-volume plugin tables (WooCommerce sessions, Action Scheduler, Wordfence, WP Statistics, Redirection, etc.) are annotated so you know what’s safe to clear. * **Uploads** — total `wp-content/uploads` size, breakdown per year/month, the 20 largest files, and oversized image detection (anything over 1 MB). * **wp-content** — full disk breakdown of `plugins/`, `themes/`, `uploads/`, `cache/`,` upgrade/`, `mu-plugins/`, `languages/`, and “other” as a visual bar chart. Lists known cache/backup folders (UpdraftPlus, All-in-One WP Migration, BackUpWordPress, WPvivid, W3 Total Cache, LiteSpeed, Divi cache, etc.), must-use plugins, and active drop-ins (`object-cache.php`, `advanced-cache.php`, `db.php`). One-click delete for `wp-content/debug.log`. * **History** — daily WP-Cron snapshots of database size with a trend chart and snapshot log. Spot “the DB grew 500 MB last month” growth before it becomes a crisis. * **System Info** — WordPress version and constants, PHP runtime limits, MySQL server variables (max packet, wait timeout, InnoDB buffer pool), disk free space, loaded PHP extensions, and the plugin’s own schema/cron status. Useful for support requests and for understanding why a particular limit might affect what the plugin can scan or clean up. #### How it works * **Read-only by default.** Every cleanup action is an explicit click with a confirmation dialog. Nothing is deleted in the background. * **Real measurements.** Database content sizes come directly from `LENGTH()` of the underlying columns; on-disk sizes come from `SHOW TABLE STATUS`; plugin, theme, uploads, and wp-content sizes come from a recursive `filesize()` walk. * **Cross-version aware.** Works on WordPress 6.4 and later. Detects both the legacy autoload values (`yes`/`no`) and the WordPress 6.6+ values (`on`, `auto`, `auto- on`). * **Cached scans.** Disk walks are cached for 10 minutes so opening the admin page again is instant. Use the “Recalculate sizes” button on any tab to force a fresh scan. * **No external requests.** The plugin runs entirely on your server and does not send any data to a remote service. * **Front-end untouched.** Nothing runs on the public side of the site. All measurement and cleanup work happens only on the Tools page. #### Configuration There is no settings page. After activation, open **Tools -> DBStorage Insights** and use the tabs along the top. Every destructive action is gated behind a confirmation dialog. For large operations (site-wide revision deletion, orphaned-metadata cleanup, large spam/trash purges) the plugin processes records in batches with a progress indicator so the request never times out. ## Screenshots [⌊Posts & Pages tab -- per-post database size including revisions, postmeta, and comments.⌉⌊Posts & Pages tab -- per-post database size including revisions, postmeta, and comments.⌉[ Posts & Pages tab — per-post database size including revisions, postmeta, and comments. [⌊Plugins tab -- disk size, file count, active status. Click a plugin name to drill down.⌉⌊Plugins tab -- disk size, file count, active status. Click a plugin name to drill down.⌉[ Plugins tab — disk size, file count, active status. Click a plugin name to drill down. [⌊Plugin drill-down -- where the disk space inside a single plugin goes, by folder and file type.⌉⌊Plugin drill-down -- where the disk space inside a single plugin goes, by folder and file type.⌉[ Plugin drill-down — where the disk space inside a single plugin goes, by folder and file type. [⌊Themes tab and theme drill-down.⌉⌊Themes tab and theme drill-down.⌉[ Themes tab and theme drill-down. [⌊Autoload & Transients -- the 20 largest autoloaded options with one-click "Disable autoload".⌉⌊Autoload & Transients -- the 20 largest autoloaded options with one- click "Disable autoload".⌉[ Autoload & Transients — the 20 largest autoloaded options with one-click “Disable autoload”. [⌊Database & Cleanup -- raw table status with per-table Optimize, plus orphan/spam/ trash cleanup.⌉⌊Database & Cleanup -- raw table status with per-table Optimize, plus orphan/spam/trash cleanup.⌉[ Database & Cleanup — raw table status with per-table Optimize, plus orphan/spam/ trash cleanup. [⌊Uploads breakdown -- per year/month sizes and the 20 largest files.⌉⌊Uploads breakdown-- per year/month sizes and the 20 largest files.⌉[ Uploads breakdown — per year/month sizes and the 20 largest files. [⌊wp-content disk breakdown and known cache/backup folders.⌉⌊wp-content disk breakdown and known cache/backup folders.⌉[ wp-content disk breakdown and known cache/backup folders. [⌊History -- daily DB size snapshots with a trend chart.⌉⌊History -- daily DB size snapshots with a trend chart.⌉[ History — daily DB size snapshots with a trend chart. [⌊System Info -- WordPress, server, PHP, MySQL, disk and PHP-extension details in card layout.⌉⌊System Info -- WordPress, server, PHP, MySQL, disk and PHP-extension details in card layout.⌉[ System Info — WordPress, server, PHP, MySQL, disk and PHP-extension details in card layout. ## Installation 1. Upload the `dbstorage-insights/` folder to `wp-content/plugins/`, or install via** Plugins -> Add New** and search for “DBStorage Insights”. 2. Activate **DBStorage Insights** in **Plugins**. 3. Open **Tools -> DBStorage Insights**. Activation creates a small history table (`{prefix}dbsi_history`) and schedules a daily WP-Cron snapshot of database size for the History tab. Requires WordPress 6.4+ and PHP 7.4+. ## FAQ ### Is it safe to delete post revisions? Yes — they are deleted via WordPress’s own `wp_delete_post_revision()`, which fires all the usual hooks. Your published posts are untouched; only the revision history is removed. ### Is it safe to disable autoload on a large option? Almost always, yes — the plugin will simply load the option on demand the next time it needs it, with one extra database query. Options used by WordPress core on every request are flagged with a **core** badge and gated behind an extra confirmation. As a rule of thumb: large autoloaded options from caching/SEO/analytics plugins are safe to disable; tiny WordPress core options should be left alone. ### Will the cleanup actions delete anything I’ll regret? The cleanup actions remove things that are already in the “delete me” state: * **Orphaned postmeta / termmeta** — metadata whose parent post or term no longer exists. By definition, nothing references it. * **Spam / trashed comments** — comments already marked as spam or trash. * **Trashed posts** — posts already in the trash. * **Auto-drafts** — empty rows WordPress creates every time you click “Add New” and never finish. None of this is recoverable from the trash because it’s already past that stage. Take a database backup first if you’re nervous — that’s good practice for any cleanup tool. ### Does it work on multisite? The admin page works on each site individually. Transient figures cover the current site’s `wp_options`; network-wide transients in `wp_sitemeta` are not yet included. ### Does the plugin send any data anywhere? No. Zero external requests. Everything stays on your server. ### How accurate are the sizes? Database content sizes are measured with `LENGTH()` of text columns — the actual stored byte count. On-disk database size comes from `SHOW TABLE STATUS`. Disk size for plugins/themes/uploads is a real recursive `filesize()` walk. Row counts for InnoDB tables are reported as approximate by MySQL itself, so the **Database & Cleanup** tab notes this. ### Will it slow my site down? No. The plugin doesn’t run on the front end at all. Disk scans (plugins, themes, uploads, wp-content) are cached for 10 minutes. Database queries are issued only when you actually open the admin page. ### I activated the plugin but the History tab is empty. The first automatic snapshot runs within 24 hours of activation. You can also click** Take snapshot now** on the History tab to record one immediately. ### How do I uninstall cleanly? Deactivate the plugin from **Plugins**. The scheduled snapshot is unhooked automatically. The history table (`{prefix}dbsi_history`) is left in place so your snapshot data survives re-activation — drop it manually if you want it gone. ## Reviews There are no reviews for this plugin. ## Contributors & Developers “DBStorage Insights” is open source software. The following people have contributed to this plugin. Contributors * [ WPExtent ](https://profiles.wordpress.org/wpextent/) * [ Sajjad Hossain Sajib ](https://profiles.wordpress.org/sajibwap/) [Translate “DBStorage Insights” into your language.](https://translate.wordpress.org/projects/wp-plugins/dbstorage-insights) ### Interested in development? [Browse the code](https://plugins.trac.wordpress.org/browser/dbstorage-insights/), check out the [SVN repository](https://plugins.svn.wordpress.org/dbstorage-insights/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/dbstorage-insights/) by [RSS](https://plugins.trac.wordpress.org/log/dbstorage-insights/?limit=100&mode=stop_on_copy&format=rss). ## Meta * Version **1.2.0** * Last updated **11 hours ago** * Active installations **Fewer than 10** * WordPress version ** 6.4 or higher ** * Tested up to **7.0** * PHP version ** 7.4 or higher ** * Tags * [autoload](https://wordpress.org/plugins/tags/autoload/)[cleanup](https://wordpress.org/plugins/tags/cleanup/) [database](https://wordpress.org/plugins/tags/database/)[optimization](https://wordpress.org/plugins/tags/optimization/) [performance](https://wordpress.org/plugins/tags/performance/) * [Advanced View](https://wordpress.org/plugins/dbstorage-insights/advanced/) ## Ratings No reviews have been submitted yet. [Your review](https://wordpress.org/support/plugin/dbstorage-insights/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/dbstorage-insights/reviews/) ## Contributors * [ WPExtent ](https://profiles.wordpress.org/wpextent/) * [ Sajjad Hossain Sajib ](https://profiles.wordpress.org/sajibwap/) ## Support Got something to say? Need help? [View support forum](https://wordpress.org/support/plugin/dbstorage-insights/)