[SalesForce] Batch Apex to trim leading zeros

In the Developer Console, there is an option to view the Execution Overview. The way I went about getting to it was opening my debug log in the console, then -> Edit -> View Log Panels (CTRL +P). A 'Select Panels' window appears and I checked Execution Overview. I selected Executed Units, then made only the Queries show as in the image below.

Hope this helps!

Based on your code, it's clear that there's not much you're going to do to improve performance. However, one major improvement would be to increase the scope size, assuming it does not cause you to violate any governor limits:

Database.executeBatch(new UpdateFields(), 2000); // Process 2000 per execute method

One minor optimization that may improve performance would be as follows:

 List<Contact> contcts = new List<Contact>();
 ...
 for(Contact c: scope) {
   contcts.add(
     new Contact(Id=c.Id, 
       Pardot_End_Date_180_Prior__c = c.End_Date_180_Prior__c,
       // more fields here
     ));
 }

The reason why this improves performance is by reducing the number of statements executed, which means fewer governor limit checks. This can result in a significant amount of savings at some cost to legibility.

From prior experiments, using field assignments instead of a constructor is approximately twice as slow. You'll have to decide if the performance benefit is worth it.