{"id":536,"date":"2023-06-29T17:14:34","date_gmt":"2023-06-29T17:14:34","guid":{"rendered":"https:\/\/www.devopsconsulting.in\/blog\/?p=536"},"modified":"2024-10-01T10:33:14","modified_gmt":"2024-10-01T10:33:14","slug":"how-to-check-the-query-execution-time-in-laravel","status":"publish","type":"post","link":"https:\/\/www.devopsconsulting.in\/blog\/how-to-check-the-query-execution-time-in-laravel\/","title":{"rendered":"how to check the query execution time in Laravel"},"content":{"rendered":"\n<p>Enable query logging: Open your Laravel application&#8217;s .env file and set DB_QUERY_LOG=true. This will enable query logging, allowing Laravel to record the executed queries.<\/p>\n\n\n\n<p>Execute the query: In your code, execute the query you want to measure the execution time for. For example, let&#8217;s say you have the following query:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$users = DB::table('users')-&gt;get();<\/code><\/pre>\n\n\n\n<p>Measure the execution time: After executing the query, you can measure the execution time by using Laravel&#8217;s DB::getQueryLog() method. This method returns an array of all the executed queries and their execution time.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$queryLog = DB::getQueryLog()<\/code><\/pre>\n\n\n\n<p>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:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$executionTime = $queryLog&#91;0]&#91;'time'];<\/code><\/pre>\n\n\n\n<p>Display or log the execution time: You can then display or log the execution time as needed. For example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>echo 'Query execution time: ' . $executionTime . ' milliseconds';<\/code><\/pre>\n\n\n\n<p><strong>Here&#8217;s the complete example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ Enable query logging\nDB::connection()-&gt;enableQueryLog();\n\n\/\/ Execute the query\n$users = DB::table('users')-&gt;get();\n\n\/\/ Measure the execution time\n$queryLog = DB::getQueryLog();\n$executionTime = $queryLog&#91;0]&#91;'time'];\n\n\/\/ Display or log the execution time\necho 'Query execution time: ' . $executionTime . ' milliseconds';<\/code><\/pre>\n\n\n\n<p><br>By following these steps, you can check the query execution time in Laravel and use it to monitor and optimize your database queries.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Enable query logging: Open your Laravel application&#8217;s .env file and set DB_QUERY_LOG=true. This will enable query logging, allowing Laravel to record the executed queries. Execute the query:&#8230; <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[87],"tags":[],"class_list":["post-536","post","type-post","status-publish","format-standard","hentry","category-laravel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>how to check the query execution time in Laravel - DevOps Consulting<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.devopsconsulting.in\/blog\/how-to-check-the-query-execution-time-in-laravel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"how to check the query execution time in Laravel - DevOps Consulting\" \/>\n<meta property=\"og:description\" content=\"Enable query logging: Open your Laravel application&#8217;s .env file and set DB_QUERY_LOG=true. This will enable query logging, allowing Laravel to record the executed queries. Execute the query:...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.devopsconsulting.in\/blog\/how-to-check-the-query-execution-time-in-laravel\/\" \/>\n<meta property=\"og:site_name\" content=\"DevOps Consulting\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-29T17:14:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-01T10:33:14+00:00\" \/>\n<meta name=\"author\" content=\"Abhishek Singh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Abhishek Singh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-check-the-query-execution-time-in-laravel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-check-the-query-execution-time-in-laravel\\\/\"},\"author\":{\"name\":\"Abhishek Singh\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\"},\"headline\":\"how to check the query execution time in Laravel\",\"datePublished\":\"2023-06-29T17:14:34+00:00\",\"dateModified\":\"2024-10-01T10:33:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-check-the-query-execution-time-in-laravel\\\/\"},\"wordCount\":175,\"commentCount\":1,\"articleSection\":[\"Laravel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-check-the-query-execution-time-in-laravel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-check-the-query-execution-time-in-laravel\\\/\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-check-the-query-execution-time-in-laravel\\\/\",\"name\":\"how to check the query execution time in Laravel - DevOps Consulting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#website\"},\"datePublished\":\"2023-06-29T17:14:34+00:00\",\"dateModified\":\"2024-10-01T10:33:14+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/how-to-check-the-query-execution-time-in-laravel\\\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/\",\"name\":\"DevOps Consulting\",\"description\":\"DevOps Consulting | SRE Consulting | DevSecOps Consulting | MLOps Consulting\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\",\"name\":\"Abhishek Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"caption\":\"Abhishek Singh\"},\"description\":\"I\u2019m Abhishek, a DevOps, SRE, DevSecOps, and Cloud expert with a passion for sharing knowledge and real-world experiences. I\u2019ve had the opportunity to work with Cotocus and continue to contribute to multiple platforms where I share insights across different domains: \u2022 DevOps School \u2013 Tech blogs and tutorials \u2022 Holiday Landmark \u2013 Travel stories and guides \u2022 Stocks Mantra \u2013 Stock market strategies and tips \u2022 My Medic Plus \u2013 Health and fitness guidance \u2022 TrueReviewNow \u2013 Honest product reviews \u2022 Wizbrand \u2013 SEO and digital tools for businesses I\u2019m also exploring the fascinating world of Quantum Computing.\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/author\\\/abhishek\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"how to check the query execution time in Laravel - DevOps Consulting","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.devopsconsulting.in\/blog\/how-to-check-the-query-execution-time-in-laravel\/","og_locale":"en_US","og_type":"article","og_title":"how to check the query execution time in Laravel - DevOps Consulting","og_description":"Enable query logging: Open your Laravel application&#8217;s .env file and set DB_QUERY_LOG=true. This will enable query logging, allowing Laravel to record the executed queries. Execute the query:...","og_url":"https:\/\/www.devopsconsulting.in\/blog\/how-to-check-the-query-execution-time-in-laravel\/","og_site_name":"DevOps Consulting","article_published_time":"2023-06-29T17:14:34+00:00","article_modified_time":"2024-10-01T10:33:14+00:00","author":"Abhishek Singh","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Abhishek Singh","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-check-the-query-execution-time-in-laravel\/#article","isPartOf":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-check-the-query-execution-time-in-laravel\/"},"author":{"name":"Abhishek Singh","@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f"},"headline":"how to check the query execution time in Laravel","datePublished":"2023-06-29T17:14:34+00:00","dateModified":"2024-10-01T10:33:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-check-the-query-execution-time-in-laravel\/"},"wordCount":175,"commentCount":1,"articleSection":["Laravel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.devopsconsulting.in\/blog\/how-to-check-the-query-execution-time-in-laravel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.devopsconsulting.in\/blog\/how-to-check-the-query-execution-time-in-laravel\/","url":"https:\/\/www.devopsconsulting.in\/blog\/how-to-check-the-query-execution-time-in-laravel\/","name":"how to check the query execution time in Laravel - DevOps Consulting","isPartOf":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/#website"},"datePublished":"2023-06-29T17:14:34+00:00","dateModified":"2024-10-01T10:33:14+00:00","author":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.devopsconsulting.in\/blog\/how-to-check-the-query-execution-time-in-laravel\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.devopsconsulting.in\/blog\/#website","url":"https:\/\/www.devopsconsulting.in\/blog\/","name":"DevOps Consulting","description":"DevOps Consulting | SRE Consulting | DevSecOps Consulting | MLOps Consulting","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.devopsconsulting.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f","name":"Abhishek Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","caption":"Abhishek Singh"},"description":"I\u2019m Abhishek, a DevOps, SRE, DevSecOps, and Cloud expert with a passion for sharing knowledge and real-world experiences. I\u2019ve had the opportunity to work with Cotocus and continue to contribute to multiple platforms where I share insights across different domains: \u2022 DevOps School \u2013 Tech blogs and tutorials \u2022 Holiday Landmark \u2013 Travel stories and guides \u2022 Stocks Mantra \u2013 Stock market strategies and tips \u2022 My Medic Plus \u2013 Health and fitness guidance \u2022 TrueReviewNow \u2013 Honest product reviews \u2022 Wizbrand \u2013 SEO and digital tools for businesses I\u2019m also exploring the fascinating world of Quantum Computing.","url":"https:\/\/www.devopsconsulting.in\/blog\/author\/abhishek\/"}]}},"_links":{"self":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/comments?post=536"}],"version-history":[{"count":4,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/536\/revisions"}],"predecessor-version":[{"id":1248,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/536\/revisions\/1248"}],"wp:attachment":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/media?parent=536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/categories?post=536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/tags?post=536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}