{"id":361078,"date":"2026-09-02T18:07:48","date_gmt":"2026-09-02T18:07:48","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/aplext-dbplus\/"},"modified":"2026-09-02T18:49:36","modified_gmt":"2026-09-02T18:49:36","slug":"aparimitlabs-database-metrics","status":"publish","type":"plugin","link":"https:\/\/bho.wordpress.org\/plugins\/aparimitlabs-database-metrics\/","author":23527608,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"1.0.0","stable_tag":"1.0.0","tested":"7.1","requires":"5.8","requires_php":"8.2","requires_plugins":null,"header_name":"Aparimitlabs Database Metrics","header_author":"Aparimit Labs","header_description":"Monitors database query counts, total execution time, autoloaded options size, and orphan transients.","assets_banners_color":"123d5b","last_updated":"2026-09-02 18:49:36","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"https:\/\/github.com\/aparimitlabs\/aparimitlabs-database-metrics","header_author_uri":"","rating":0,"author_block_rating":0,"active_installs":0,"downloads":44,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"1.0.0":{"tag":"1.0.0","author":"aparimitlabs","date":"2026-09-02 18:49:36","revision":3678551}},"upgrade_notice":{"1.0.0":"<p>Initial release of Aparimitlabs Database Metrics performance and monitoring suite.<\/p>"},"ratings":[],"assets_icons":{"icon-256x256.jpg":{"filename":"icon-256x256.jpg","revision":3678512,"resolution":"256x256","location":"assets","locale":"","width":1024,"height":1024}},"assets_banners":{"banner-772x250.jpg":{"filename":"banner-772x250.jpg","revision":3678512,"resolution":"772x250","location":"assets","locale":"","width":1376,"height":768}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0.0"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":3678519,"resolution":"1","location":"assets","locale":"","width":1076,"height":642},"screenshot-2.png":{"filename":"screenshot-2.png","revision":3678519,"resolution":"2","location":"assets","locale":"","width":1070,"height":483},"screenshot-3.png":{"filename":"screenshot-3.png","revision":3678519,"resolution":"3","location":"assets","locale":"","width":1135,"height":429},"screenshot-4.png":{"filename":"screenshot-4.png","revision":3678512,"resolution":"4","location":"assets","locale":"","width":1135,"height":429}},"screenshots":{"1":"Autoloaded Options Size Analyzer highlighting memory usage thresholds and bloated options.","2":"Transient Purger module for safely identifying and batch-cleaning expired transients.","3":"Database Query Monitor settings and performance configuration interface."}},"plugin_section":[],"plugin_tags":[1328,153,187,247,12113],"plugin_category":[52,54,59],"plugin_contributors":[278917],"plugin_business_model":[],"class_list":["post-361078","plugin","type-plugin","status-publish","hentry","plugin_tags-autoload","plugin_tags-database","plugin_tags-optimization","plugin_tags-performance","plugin_tags-transients","plugin_category-performance","plugin_category-security-and-spam-protection","plugin_category-utilities-and-tools","plugin_contributors-aparimitlabs","plugin_committers-aparimitlabs"],"banners":{"banner":"https:\/\/ps.w.org\/aparimitlabs-database-metrics\/assets\/banner-772x250.jpg?rev=3678512","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/aparimitlabs-database-metrics\/assets\/icon-256x256.jpg?rev=3678512","icon_2x":"https:\/\/ps.w.org\/aparimitlabs-database-metrics\/assets\/icon-256x256.jpg?rev=3678512","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/aparimitlabs-database-metrics\/assets\/screenshot-1.png?rev=3678519","caption":"Autoloaded Options Size Analyzer highlighting memory usage thresholds and bloated options."},{"src":"https:\/\/ps.w.org\/aparimitlabs-database-metrics\/assets\/screenshot-2.png?rev=3678519","caption":"Transient Purger module for safely identifying and batch-cleaning expired transients."},{"src":"https:\/\/ps.w.org\/aparimitlabs-database-metrics\/assets\/screenshot-3.png?rev=3678519","caption":"Database Query Monitor settings and performance configuration interface."},{"src":"https:\/\/ps.w.org\/aparimitlabs-database-metrics\/assets\/screenshot-4.png?rev=3678512","caption":""}],"raw_content":"<!--section=description-->\n<p>Aparimitlabs Database Metrics is a lightweight, high-performance database optimization, cleaner, and monitoring plugin engineered for WordPress site owners, developers, WooCommerce store owners, and administrators wanting to speed up their website.<\/p>\n\n<p>A slow WordPress database is the primary cause of high server CPU load, database overhead, and delayed Time to First Byte (TTFB). Common issues like bloated wp_options autoload size, accumulated expired transients, orphan database records, and hidden slow queries degrade site performance across every single page load.<\/p>\n\n<p>This plugin provides clear diagnostic visibility into database health and performance directly inside your WordPress dashboard - with zero performance overhead or background process bloat.<\/p>\n\n<h4>Why Choose Aparimitlabs Database Metrics?<\/h4>\n\n<p>Unlike heavy database cleaner or query monitor plugins that constantly write to your database or run resource-intensive background tasks, Aparimitlabs Database Metrics uses a Zero-Footprint Execution Model. It executes diagnostics on-demand only when an authorized administrator views the dashboard.<\/p>\n\n<h4>Key Features<\/h4>\n\n<ul>\n<li><strong>Zero-Footprint Performance:<\/strong> Completely lightweight database cleaner and optimizer. No background processes, cron tracking, or external API calls dragging down site speed.<\/li>\n<li><strong>Autoloaded Options Analyzer:<\/strong> Instantly detects total memory size of wp_options autoloaded data. Automatically alerts you when autoload size exceeds recommended limits (800 KB) to prevent database bloat and RAM spikes.<\/li>\n<li><strong>Safe Transient Purger &amp; Cleaner:<\/strong> Identifies expired transients clogging your database and allows safe, one-click batch cleanup with native nonce verification.<\/li>\n<li><strong>Query Execution &amp; Latency Tracker:<\/strong> Monitors total wpdb query count and execution time per page load to pinpoint slow database queries during development, debugging, or speed optimization.<\/li>\n<li><strong>Database Health Diagnostic:<\/strong> Gives instant health status on database tables, options overhead, and query performance.<\/li>\n<li><strong>WooCommerce &amp; E-Commerce Compatible:<\/strong> Works seamlessly with WooCommerce stores by preventing transient build-up and monitoring autoloaded options.<\/li>\n<li><strong>Strict Security Standards:<\/strong> Built according to strict WordPress coding standards with full capability checks (manage_options), nonces, and prepared SQL queries.<\/li>\n<\/ul>\n\n<!--section=installation-->\n<ol>\n<li>Upload the <code>aparimitlabs-database-metrics<\/code> folder to <code>\/wp-content\/plugins\/<\/code>, or install directly via Plugins &gt; Add New in WordPress.<\/li>\n<li>Activate the plugin.<\/li>\n<li>Navigate to Tools &gt; Aparimitlabs Database Metrics to inspect real-time database health, autoload size, and transient metrics.<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt id=\"how%20do%20autoloaded%20options%20affect%20my%20wordpress%20site%20speed%3F\"><h3>How do autoloaded options affect my WordPress site speed?<\/h3><\/dt>\n<dd><p>WordPress loads every autoload=yes option in wp_options into memory on every single page request. When autoload size grows beyond 800 KB (often caused by uninstalled plugins or large options), site loading times and server memory consumption spike dramatically. This plugin alerts you before it slows down your site.<\/p><\/dd>\n<dt id=\"is%20this%20a%20safe%20database%20cleaner%20and%20transient%20optimizer%3F\"><h3>Is this a safe database cleaner and transient optimizer?<\/h3><\/dt>\n<dd><p>Yes. Transients are temporary cached data (such as temporary API responses or expired session caches). Deleting expired transients safely reclaims database storage without affecting your site content, posts, pages, users, or settings.<\/p><\/dd>\n<dt id=\"how%20does%20this%20help%20reduce%20ttfb%20and%20speed%20up%20database%20queries%3F\"><h3>How does this help reduce TTFB and speed up database queries?<\/h3><\/dt>\n<dd><p>By identifying slow database queries, alerting on bloated wp_options autoload size, and purging expired transients, you reduce database execution latency and memory usage on every page load.<\/p><\/dd>\n<dt id=\"can%20this%20plugin%20be%20used%20alongside%20woocommerce%20or%20other%20caching%20plugins%3F\"><h3>Can this plugin be used alongside WooCommerce or other caching plugins?<\/h3><\/dt>\n<dd><p>Yes! It is fully compatible with WooCommerce, object cache plugins (Redis\/Memcached), and page caching plugins.<\/p><\/dd>\n<dt id=\"does%20this%20plugin%20run%20background%20tasks%20or%20write%20data%20to%20my%20database%3F\"><h3>Does this plugin run background tasks or write data to my database?<\/h3><\/dt>\n<dd><p>No. Aparimitlabs Database Metrics is designed with a zero-footprint philosophy. It only executes analysis when you open the tools page in the dashboard.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>1.0.0<\/h4>\n\n<ul>\n<li>Initial public release. Fully compliance-checked with Aparimitlabs architectural standards.<\/li>\n<\/ul>","raw_excerpt":"Monitors real-time DB queries, execution time, autoloaded wp_options size, and safely purges expired transients with zero performance footprint.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bho.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/361078","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bho.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/bho.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/bho.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=361078"}],"author":[{"embeddable":true,"href":"https:\/\/bho.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/aparimitlabs"}],"wp:attachment":[{"href":"https:\/\/bho.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=361078"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/bho.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=361078"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/bho.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=361078"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/bho.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=361078"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/bho.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=361078"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/bho.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=361078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}