PHPackages consilience/laravel-slow-query-logger - 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. [Database & ORM](/categories/database) 4. / 5. consilience/laravel-slow-query-logger ActiveLibrary[Database & ORM](/categories/database) consilience/laravel-slow-query-logger ===================================== Slow Query Logger for Laravel 2.0.1(4y ago)02.5k↑21.3%1[1 PRs](https://github.com/consilience/laravel-slow-query-logger/pulls)MITPHP Since Jun 28Pushed 2mo agoCompare [ Source](https://github.com/consilience/laravel-slow-query-logger)[ Packagist](https://packagist.org/packages/consilience/laravel-slow-query-logger)[ RSS](/packages/consilience-laravel-slow-query-logger/feed)WikiDiscussions master Synced 2w ago READMEChangelog (2)Dependencies (2)Versions (7)Used By (0) Slow Query Logger for Laravel ============================= [](#slow-query-logger-for-laravel) [![Latest Stable Version](https://camo.githubusercontent.com/1b52181c9b5d55bde0b677028f8ae7c98b301155bdd387c38e60b7d023eb3c77/68747470733a2f2f706f7365722e707567782e6f72672f636f6e73696c69656e63652f6c61726176656c2d736c6f772d71756572792d6c6f676765722f762f737461626c652e737667)](https://packagist.org/packages/consilience/laravel-slow-query-logger) [![Latest Unstable Version](https://camo.githubusercontent.com/9dadb5acb9a9d9a379fe4603ddd905b80d0ba646d53da19526abc85b093753b8/68747470733a2f2f706f7365722e707567782e6f72672f636f6e73696c69656e63652f6c61726176656c2d736c6f772d71756572792d6c6f676765722f762f756e737461626c652e737667)](https://packagist.org/packages/consilience/laravel-slow-query-logger) [![License](https://camo.githubusercontent.com/a6ea05475733301d302d611815fded576e28746ba4e89438c6a8876441c147e8/68747470733a2f2f706f7365722e707567782e6f72672f636f6e73696c69656e63652f6c61726176656c2d736c6f772d71756572792d6c6f676765722f6c6963656e73652e737667)](https://packagist.org/packages/consilience/laravel-slow-query-logger) [![Total Downloads](https://camo.githubusercontent.com/a3d35bc01d7645d8fafa59d2f83b60213921246f0899f154393acd2338f4df4d/68747470733a2f2f706f7365722e707567782e6f72672f636f6e73696c69656e63652f6c61726176656c2d736c6f772d71756572792d6c6f676765722f646f776e6c6f6164732e737667)](https://packagist.org/packages/consilience/laravel-slow-query-logger) Installation/Quickstart ----------------------- [](#installationquickstart) ``` composer require consilience/laravel-slow-query-logger ``` or add the following line to `composer.json` then run `composer update`: ``` "require": { "consilience/laravel-slow-query-logger": "^2.0" } ``` Turn on slow query logging: ``` LARAVEL_SLOW_QUERY_LOGGER_ENABLED=true ``` Look into your log file to see your slow queries. Configuration ------------- [](#configuration) The configuration file can be published with the following command: ``` php artisan vendor:publish --provider="Consilience\Laravel\SlowQueryLogger\SlowQueryLoggerProvider" ``` You will likely not need to publish the config; just set required environment variables as listed below. ### `enabled` [](#enabled) Enable the slow queries logger. You can set this value through environment variable `LARAVEL_SLOW_QUERY_LOGGER_ENABLED`. It is `false` by default. ### `channel` [](#channel) Sets the channel to log in. This can be handy if you want to keep all query logs separate from other log messages. You can set this value through environment variable `LARAVEL_SLOW_QUERY_LOGGER_CHANNEL`. By default, the application default logging channel will be used. ### `level` [](#level) Set the log-level for logging the slow queries. You can set this value through environment variable `LARAVEL_SLOW_QUERY_LOGGER_LEVEL`. It is `debug` by default. ### `threshold-ms` [](#threshold-ms) Only log queries that take longer than this number of milliseconds to complete. You can set this value through environment variable `LARAVEL_SLOW_QUERY_LOGGER_THRESHOLD_MS`. It is `700` by default. A value of 0 will log all queries. Usage ----- [](#usage) By default, bind variables are not included in the logged details. Just the core query is logged: > \[20\[2022-08-02 22:15:33\] production.DEBUG: SQL 6663.970 mS: update `users` set `name` = ?, `users`.`updated_at` = ? where `id` = ? By setting `LARAVEL_SLOW_QUERY_LOGGER_REPLACE_BINDINGS=true` the query will have its bind variables substituted with the matching values: > \[2022-08-02 16:17:13\] production.DEBUG: SQL 784.200 mS: update `users` set `name` = 'JJ', `users`.`updated_at` = '2022-08-02 16:17:05' where `id` = '1' You can also (or alternatively) list the bind data separately in the context of the log by setting `LARAVEL_SLOW_QUERY_LOGGER_SHOW_BINDINGS=true`. This may be useful to observe the data types in more detail, since substituting the bindings will treat all values as strings. > \[2022-08-02 22:22:35\] production.DEBUG: SQL 413.910 mS: update `users` set `name` = 'JJ', `users`.`updated_at` = '2022-08-02 22:21:50' where `id` = '1' {"bindings":\["JJ","2022-08-02 22:21:50",1\]} ### Health Score 42 — FairBetter than 88% of packages Maintenance56 Moderate activity, may be stable Popularity22 Limited adoption so far Community7 Small or concentrated contributor base Maturity67 Established project with proven stability 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 ~556 days Total 5 Last Release 1476d ago Major Versions 0.0.1 → 1.0.02018-07-25 1.0.1 → 2.0.02022-06-17 PHP version history (2 changes)0.0.1PHP >=5.5.9 1.0.0PHP ^7.1.3 ### Community Maintainers ![](https://avatars.githubusercontent.com/u/395934?v=4)[Jason Judge](/maintainers/judgej)[@judgej](https://github.com/judgej) --- Top Contributors [![judgej](https://avatars.githubusercontent.com/u/395934?v=4)](https://github.com/judgej "judgej (7 commits)") ### Embed Badge ![Health badge](/badges/consilience-laravel-slow-query-logger/health.svg) ``` [![Health](https://phpackages.com/badges/consilience-laravel-slow-query-logger/health.svg)](https://phpackages.com/packages/consilience-laravel-slow-query-logger) ``` ### Alternatives [mongodb/laravel-mongodb A MongoDB based Eloquent model and Query builder for Laravel 7.1k8.9M110](/packages/mongodb-laravel-mongodb)[psalm/plugin-laravel Psalm plugin for Laravel 3345.4M354](/packages/psalm-plugin-laravel)[yajra/laravel-oci8 Oracle DB driver for Laravel via OCI8 8723.3M27](/packages/yajra-laravel-oci8)[glushkovds/phpclickhouse-laravel Adapter of the most popular library https://github.com/smi2/phpClickHouse to Laravel 2051.6M2](/packages/glushkovds-phpclickhouse-laravel)[api-platform/laravel API Platform support for Laravel 58190.1k21](/packages/api-platform-laravel)[laravel-liberu/laravel-gedcom A package that converts gedcom files to Eloquent models 792.5k1](/packages/laravel-liberu-laravel-gedcom) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)