mamitech/laravel-slow-query-log

There is no license information available for the latest version (v1.1) of this package.

v1.1 2023-11-08 07:42 UTC

This package is auto-updated.

Last update: 2024-05-14 08:41:35 UTC


README

Usage

Publish config

The first time you use this package, publish the configuration by typing php artisan vendor:publish --provider=Mamitech\SlowQueryLog\ServiceProvider

Enable it by settings environment variable SLOW_QUERY_LOG_ENABLED to true.

Set your minimum threshold of query execution to be considered slow by setting environment variable SLOW_QUERY_MIN_THRESHOLD to a number (in millisecond unit).

If you only want to trace certain files, set your environment variable SLOW_QUERY_TRACE_ONLY to some string. For example if you want to only keep the trace data of all files within app/ folder, set SLOW_QUERY_TRACE_ONLY to app/

Run Test

Before running test, make sure you have installed all the dependencies by running:

composer install

Then, make sure you have php-sqlite3 installed in your system because use sqlite to run the test.

In debian based system:

sudo apt install php-sqlite3

Now run the test using:

./vendor/bin/phpunit