Detecting slow database operations in Laravel 9.x — Amit Merchant — A blog on PHP, JavaScript, and more

PHOTO EMBED

Mon Aug 22 2022 15:46:46 GMT+0000 (Coordinated Universal Time)

Saved by @WMOH 

namespace App\Providers;

use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\DB;
use Illuminate\Database\Connection;
use Illuminate\Support\Facades\Log;

class AppServiceProvider extends ServiceProvider
{
    public function boot()
    {
        DB::whenQueryingForLongerThan(500, function (Connection $connection) {
            Log::warning("Database queries exceeded 5 seconds on {$connection->getName()}");

            // or notify the development team...
        });
    }
}
content_copyCOPY

https://www.amitmerchant.com/detecting-slow-database-operations-in-laravel-9x/