In the "Classic Console" worksheet, at the bottom right you could see the query history, which was great for jumping around results set, and comparing SQL performance times.
How is this type of thing done in the new UI, I feel I have clicked on all the UI elements, but cannot find a history.
you could click on the history at the top right hand corner , it will show the different version of SQL executed, may be this is what you want.
The closest to the classic console history would be Home-->Compute-->History. At least you won't have to toggle between versions to look at query durations. Luckily, it opens on a separate tab and can be refreshed. TBH, the classic console has it better.
From the top corner history you can mouseover a certain row to get a preview of the executed query.
Another option is to go to Query details and user the three dots and View Query Profile to get to the Activity/Query page
And from there go to Query history where you can view the SQL code
