I am using Magento 2.2.3 it is in production mode. The order listing page in admin loads very slow. I have been facing this issue since long.
To debug this I have also tried enabling query log through terminal using the following command : bin/magento dev:query-log:enable and then cache:flush
But still I cannot see var/log/db.log or var/debug/db.log file.
I have also tried replacing the line in app/etc/di.xml file as shown below:
<!-- <preference for="Magento\Framework\DB\LoggerInterface" type="Magento\Framework\DB\Logger\LoggerProxy"/> --> <preference for="Magento\Framework\DB\LoggerInterface" type="Magento\Framework\DB\Logger\File"/> <type name="Magento\Framework\DB\Logger\File"> <arguments> <argument name="logAllQueries" xsi:type="boolean">true</argument> </arguments> </type>
After this I have executed all three commands setup:upgrade; setup:di:compile; setup:static-content:deploy
But still I didn't get any such log file for queries.