PHPackages labofgood/module-db-query-log-extended - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Logging & Monitoring](/categories/logging) 4. / 5. labofgood/module-db-query-log-extended ActiveMagento2-module[Logging & Monitoring](/categories/logging) labofgood/module-db-query-log-extended ====================================== The module enhances the DB logger functionality, offering the capability to display DB logs in the xlsx format and produce a report analyzing query similarities. v1.0.4(2y ago)59BSD-3-ClausePHPPHP ^8.1 Since Oct 21Pushed 2y ago1 watchersCompare [ Source](https://github.com/abramchenkoaa/labofgood-module-db-query-log-extended)[ Packagist](https://packagist.org/packages/labofgood/module-db-query-log-extended)[ RSS](/packages/labofgood-module-db-query-log-extended/feed)WikiDiscussions main Synced 3w ago READMEChangelog (4)Dependencies (3)Versions (6)Used By (0) Database Query Log Extended magento2 module =========================================== [](#database-query-log-extended-magento2-module) Overview -------- [](#overview) The `Labofgood_DbQueryLogExtended` module offers enhanced analysis capabilities for the `db.log` generated using Magento's command: ``` php bin/magento dev:query-log:enable ``` This module enriches the standard command functionalities by introducing: - Extended information about queries added the record context (request uri or CLI command), record number, UID of process. - Capability to export the log to an XLSX file format. - A feature to do a similarity analysis of SQL queries and showcase them in a separate XLSX sheet. Example of the report: [![image](https://private-user-images.githubusercontent.com/3831358/277153816-97c52031-3cf2-4522-b0d2-9647687c6c6e.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3ODA5NDczNjQsIm5iZiI6MTc4MDk0NzA2NCwicGF0aCI6Ii8zODMxMzU4LzI3NzE1MzgxNi05N2M1MjAzMS0zY2YyLTQ1MjItYjBkMi05NjQ3Njg3YzZjNmUucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDYwOCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA2MDhUMTkzMTA0WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9YTlhOWZjNjlkNmJmYTY3N2VmZjU5Mzg4YzQ3NTFiZjhlZGYwOTk1MmM0OTAyYzhkYWYzMzBhMjE2ZWEwYWQ1YiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.KnJExR8R4CDQ2XAWEG606g4tVs3cGPjBDJZey2ySuZk)](https://private-user-images.githubusercontent.com/3831358/277153816-97c52031-3cf2-4522-b0d2-9647687c6c6e.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3ODA5NDczNjQsIm5iZiI6MTc4MDk0NzA2NCwicGF0aCI6Ii8zODMxMzU4LzI3NzE1MzgxNi05N2M1MjAzMS0zY2YyLTQ1MjItYjBkMi05NjQ3Njg3YzZjNmUucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDYwOCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA2MDhUMTkzMTA0WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9YTlhOWZjNjlkNmJmYTY3N2VmZjU5Mzg4YzQ3NTFiZjhlZGYwOTk1MmM0OTAyYzhkYWYzMzBhMjE2ZWEwYWQ1YiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.KnJExR8R4CDQ2XAWEG606g4tVs3cGPjBDJZey2ySuZk)[![image](https://private-user-images.githubusercontent.com/3831358/277153916-a250e86a-379e-48b5-89ea-c8e7142094fc.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3ODA5NDczNjQsIm5iZiI6MTc4MDk0NzA2NCwicGF0aCI6Ii8zODMxMzU4LzI3NzE1MzkxNi1hMjUwZTg2YS0zNzllLTQ4YjUtODllYS1jOGU3MTQyMDk0ZmMucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDYwOCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA2MDhUMTkzMTA0WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9NWU3NGExY2VkMTk3ODBjMWFlYzZjNTdjYmRlZjY2MWJjYzYzYjQxYWVkNmI5NzViNDAyZmIxYjY1MjBmZDlkZCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.jop2Os4RZO-VJEWLnAGOElpcXhcxmwq5evdQ4jvP10g)](https://private-user-images.githubusercontent.com/3831358/277153916-a250e86a-379e-48b5-89ea-c8e7142094fc.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3ODA5NDczNjQsIm5iZiI6MTc4MDk0NzA2NCwicGF0aCI6Ii8zODMxMzU4LzI3NzE1MzkxNi1hMjUwZTg2YS0zNzllLTQ4YjUtODllYS1jOGU3MTQyMDk0ZmMucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDYwOCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA2MDhUMTkzMTA0WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9NWU3NGExY2VkMTk3ODBjMWFlYzZjNTdjYmRlZjY2MWJjYzYzYjQxYWVkNmI5NzViNDAyZmIxYjY1MjBmZDlkZCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.jop2Os4RZO-VJEWLnAGOElpcXhcxmwq5evdQ4jvP10g) Example of the similarity analysis report: [![image](https://private-user-images.githubusercontent.com/3831358/278411126-05a154ee-1aef-4b76-a025-76946796e2b9.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3ODA5NDczNjQsIm5iZiI6MTc4MDk0NzA2NCwicGF0aCI6Ii8zODMxMzU4LzI3ODQxMTEyNi0wNWExNTRlZS0xYWVmLTRiNzYtYTAyNS03Njk0Njc5NmUyYjkucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDYwOCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA2MDhUMTkzMTA0WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9Zjk4ZDZmOTY3OTYwZjVkYWE4MWNlZWFjODI2ZTY2ODMyNzNkNmEzZjE3M2FlMTQ1M2NjZTcxYzExYTY3MDg4ZCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.-tu9iV-dOz-SXriPx14M_0Bb-P5zTGEv2CZX_5zVUtc)](https://private-user-images.githubusercontent.com/3831358/278411126-05a154ee-1aef-4b76-a025-76946796e2b9.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3ODA5NDczNjQsIm5iZiI6MTc4MDk0NzA2NCwicGF0aCI6Ii8zODMxMzU4LzI3ODQxMTEyNi0wNWExNTRlZS0xYWVmLTRiNzYtYTAyNS03Njk0Njc5NmUyYjkucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDYwOCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA2MDhUMTkzMTA0WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9Zjk4ZDZmOTY3OTYwZjVkYWE4MWNlZWFjODI2ZTY2ODMyNzNkNmEzZjE3M2FlMTQ1M2NjZTcxYzExYTY3MDg4ZCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.-tu9iV-dOz-SXriPx14M_0Bb-P5zTGEv2CZX_5zVUtc) Prerequisites ------------- [](#prerequisites) - PHP 8.1 or higher - Magento 2.4.5 Dependencies ------------ [](#dependencies) composer.json includes: ``` "magento/module-developer": "100.4.*", "shuchkin/simplexlsxgen": "^1.3" ``` Installation Steps ------------------ [](#installation-steps) Please follow the instructions: - Run `composer require --dev labofgood/module-db-query-log-extended` - Run `bin/magento setup:upgrade` Usage Guide ----------- [](#usage-guide) - To install, please adhere to the following steps: ``` php bin/magento dev:query-log:enable ``` - Browse the website or initiate a CLI command to populate db.log with queries. - Run the following command to transform db.log into a XLSX file ``` php bin/magento labofgood:dev:query-log:convert-to-report --path_to_file=/var/www/html/var/debug/db.log ``` - For grouping similar queries and showcasing them in a separate XLSX sheet, run the following command: ``` php bin/magento labofgood:dev:query-log:similarity-analysis --path_to_file=/var/www/html/var/debug/db.log ``` - When done, deactivate the query log with: ``` php bin/magento dev:query-log:disable ``` Uninstallation -------------- [](#uninstallation) To uninstall the module, run: `bin/magento module:uninstall Labofgood_DbQueryLogExtended` Credits ------- [](#credits) - Anton Abramchenko Licensing --------- [](#licensing) Copyright © 2023 Anton Abramchenko. All rights reserved. This software is under the "3-Clause BSD License" license (see source). ### Health Score 25 — LowBetter than 36% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity9 Limited adoption so far Community7 Small or concentrated contributor base Maturity55 Maturing project, gaining track record Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~3 days Total 5 Last Release 964d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/26646a2ddacab5eb42b247a6b73921c32d5d1b41e624b0faabb1ef4a9974331b?d=identicon)[abramchenkoaa](/maintainers/abramchenkoaa) --- Top Contributors [![abramchenkoaa](https://avatars.githubusercontent.com/u/3831358?v=4)](https://github.com/abramchenkoaa "abramchenkoaa (9 commits)") --- Tags dev ### Embed Badge ![Health badge](/badges/labofgood-module-db-query-log-extended/health.svg) ``` [![Health](https://phpackages.com/badges/labofgood-module-db-query-log-extended/health.svg)](https://phpackages.com/packages/labofgood-module-db-query-log-extended) ``` ### Alternatives [graycore/magento2-stdlogging A Magento 2 module that changes all logging handlers to stdout 2486.3k](/packages/graycore-magento2-stdlogging)[spatie/laravel-error-share Share your Laravel errors to Flare 431.3M5](/packages/spatie-laravel-error-share)[staabm/phpstan-psr3 23567.0k3](/packages/staabm-phpstan-psr3)[fredden/magento2-module-javascript-error-reporting A Magento 2 module which captures JavaScript errors for later review by website administrators 3139.3k](/packages/fredden-magento2-module-javascript-error-reporting)[mage-os/module-admin-activity-log The Admin Activity extension makes it easy to track all admin activity with comprehensive audit logging. 293.3k](/packages/mage-os-module-admin-activity-log)[schuhwerk/php-error-log-viewer A single-file GUI for your php log files which groups similar errors. Written in PHP and Vue.js. 457.9k](/packages/schuhwerk-php-error-log-viewer) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)