Currently the table has the columns Title, Author, Status and Timestamp, but I think an extra column showing the number of seconds/minutes each query took would also be useful.
Description for Google-Code-in-2018
Python skills are needed to work on Flask and SQLAlchemy frameworks.
Quarry is a simple web interface that can be used to execute queries on sql servers that contain Wikipedia data.
The software has a list of recent executed queries at /query/runs/all. Recently, since T126888: Include query execution time, the execution time of each query_run is stored internally in the database.
This task is about adding a column in the table of recent queries that contains each execution time. It's needed to look at T126888 patch where is stored the execution time, and in the creation of the table for each query decode its value of last query_run and show it in the new column (edit rendered template and amend where it is populated with data).
Patch in gerrit in analytics/quarry/web repo wanted.