Page MenuHomePhabricator

Show execution time in the Recent Queries page
Closed, ResolvedPublic


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.

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:28 AM
bzimport added a project: Quarry.
bzimport set Reference to bz69264.
bzimport added a subscriber: Unknown Object (MLST).
Framawiki renamed this task from Show the execution time in the table of queries to Show execution time in the Recent Queries page.Oct 21 2018, 6:54 PM
Framawiki reopened this task as Open.
Framawiki updated the task description. (Show Details)
Framawiki added a project: Google-Code-in-2018.
Framawiki added a subscriber: Framawiki.

That could be a Google-Code-in-2018 task. Tagging as it but keep time before creating the task on their site.

Change 473644 had a related patch set uploaded (by Stibba; owner: Stibba):
[analytics/quarry/web@master] Add Execution time to query table of Quarry

Framawiki assigned this task to Stibba.
Framawiki added a subscriber: Stibba.

Change 473644 merged by jenkins-bot:
[analytics/quarry/web@master] Add Execution time to recent queries table of Quarry

Mentioned in SAL (#wikimedia-cloud) [2018-11-16T19:09:22Z] <framawiki> deployed 4f0b830 to quarry-web-01 T71264