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.
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.
Best Cardiac Hospitals Near You
Discover top heart hospitals, cardiology centers & cardiac care services by city.
Advanced Heart Care • Trusted Hospitals • Expert Teams
View Best Hospitals
[…] how to check the query execution time in Laravel […]