Show execution time in the Recent Queries page
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	He7d3r
	Aug 7 2014, 9:12 PM

Description

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.

Details

Reference: bz69264

	Subject	Repo	Branch	Lines +/-
	Add Execution time to recent queries table of Quarry	analytics/quarry/web	master	+6 -0

Customize query in gerrit

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		Stibba	T71264 Show execution time in the Recent Queries page
		Resolved		Framawiki	T126888 Include query execution time

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).

He7d3r created this task.Aug 7 2014, 9:12 PM

yuvipanda moved this task from Backlog to Planning on the Quarry board.Jul 4 2015, 5:25 PM

• Capt_Swing moved this task from Planning to Bugs on the Quarry board.Jul 17 2015, 7:12 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 17 2015, 7:12 PM

Reedy removed a subscriber: • wikibugs-l-list.Dec 10 2015, 11:01 PM

Restricted Application added a subscriber: StudiesWorld. · View Herald TranscriptDec 10 2015, 11:01 PM

matej_suchanek added a subtask: T126888: Include query execution time.May 28 2016, 8:44 PM

matej_suchanek updated the task description. (Show Details)

• Phabricator_maintenance removed a subscriber: yuvipanda.Jun 7 2017, 6:58 PM

Framawiki closed this task as a duplicate of T126888: Include query execution time.Apr 16 2018, 9:49 PM

Framawiki closed subtask T126888: Include query execution time as Resolved.Oct 15 2018, 6:54 PM

zhuyifei1999 reopened subtask T126888: Include query execution time as Open.Oct 16 2018, 4:26 AM

zhuyifei1999 closed subtask T126888: Include query execution time as Resolved.Oct 21 2018, 4:19 PM

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

Framawiki moved this task from Bugs to Backlog on the Quarry board.Oct 21 2018, 6:56 PM

Framawiki updated the task description. (Show Details)Oct 28 2018, 8:01 PM

Imported as https://codein.withgoogle.com/tasks/4789965222313984/. I'll mentor this task, with the help of @zhuyifei1999 .

Framawiki updated the task description. (Show Details)Nov 4 2018, 5:40 PM

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

https://gerrit.wikimedia.org/r/473644

gerritbot added a project: Patch-For-Review.Nov 15 2018, 12:14 AM

Framawiki closed this task as Resolved.Nov 16 2018, 7:07 PM

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