therencemanzo/slowquerylogger

This librabry will logged all slow queries based on the threshold

Maintainers

Details

github.com/therencemanzo/slowquery

Homepage

Source

Issues

Installs: 5

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 1

Forks: 0

Open Issues: 0

v1.0.0 2025-02-18 13:59 UTC

Requires

  • php: >=8.1

MIT 3e44f2808534c67632b1ba0c89fc5cb3561913cf

  • Therence Manzo <therencenielmanzo.woop@gmail.com>

This package is auto-updated.

Last update: 2025-08-18 15:51:19 UTC

README

A Laravel 11 package for logging slow queries and optimizing database performance.

Features

  • Log Slow Queries: Logs slow database queries to the database.
  • Paginated Log Viewer: View slow queries with pagination.
  • Configurable: Allows configuration of slow query thresholds and route name.
  • Migration Publishing: Publishes migration files for easy integration with your application.

Installation

1. Install the Package

Run the following Composer command to install the package:

composer require therencemanzo/slowquerylogger

2. Publish the config

php artisan vendor:publish --provider="TherenceManzo\SlowQueryLogger\SlowQueryLoggerServiceProvider" --tag=config

3. Publish the migration

php artisan vendor:publish --provider="TherenceManzo\SlowQueryLogger\SlowQueryLoggerServiceProvider" --tag=migrations

4. Run the migration

php artisan migrate

5. Configure your .env

APP_DEBUG=true

For security it will disable the routing and viewing if set debug set to false but it will still log and save the slow queries in the background.

Test

Go to web browser and <APP_URL>/slow-queries you can configure the route and threshold in the config(slowquerlogger) file