how to check the query execution time in Laravel

Enable query logging: Open your Laravel application’s .env file and set DB_QUERY_LOG=true. This will enable query logging, allowing Laravel to record the executed queries.

Execute the query: In your code, execute the query you want to measure the execution time for. For example, let’s say you have the following query:

$users = DB::table('users')->get();

Measure the execution time: After executing the query, you can measure the execution time by using Laravel’s DB::getQueryLog() method. This method returns an array of all the executed queries and their execution time.

$queryLog = DB::getQueryLog()

Access the execution time: The execution time for the last executed query is stored in the time key within the query log array. You can access it like this:

$executionTime = $queryLog[0]['time'];

Display or log the execution time: You can then display or log the execution time as needed. For example:

echo 'Query execution time: ' . $executionTime . ' milliseconds';

Here’s the complete example:

// Enable query logging
DB::connection()->enableQueryLog();

// Execute the query
$users = DB::table('users')->get();

// Measure the execution time
$queryLog = DB::getQueryLog();
$executionTime = $queryLog[0]['time'];

// Display or log the execution time
echo 'Query execution time: ' . $executionTime . ' milliseconds';

By following these steps, you can check the query execution time in Laravel and use it to monitor and optimize your database queries.

Abhishek Singh

I’m Abhishek, a DevOps, SRE, DevSecOps, and Cloud expert with a passion for sharing knowledge and real-world experiences. I’ve had the opportunity to work with Cotocus and continue to contribute to multiple platforms where I share insights across different domains:

• DevOps School – Tech blogs and tutorials

• Holiday Landmark – Travel stories and guides

• Stocks Mantra – Stock market strategies and tips

• My Medic Plus – Health and fitness guidance

• TrueReviewNow – Honest product reviews

• Wizbrand – SEO and digital tools for businesses

I’m also exploring the fascinating world of Quantum Computing.