I have written a long running console command which processes and imports a large XML file. It works great, but I would like to profile it in order to make optimizations for it to run as quickly and efficiently as possible.
I haven't been able to find a great deal of information around approaches people have taken to do this.
I'm familiar with xhprof which will be useful, however I would like to get a little more detail which I'm not sure xhprof could give me, eg number of database queries, the nature of them and the time they take etc. And more if possible.
Does anybody have any suggestions in the context of a Drupal 8 for profiling console commands?