As the sun sets on what was meant to be Sir Keir’s honeymoon period, we put his record under the microscope