Page MenuHomePhabricator

Show query run date above outputs section
Open, HighPublic

Description

Resultsets are currently static, and can only be updated by query owner. Query page viewers can't know how outdated the results are, as currently no query execution timestamp is shown in the interface.
It results to situations like T213256#4926548.
I purpose to amend "Executed in xx seconds.", above resulsets, by "Executed in xx seconds at [readable timestamp]".

See also T206482: Show query code revisions and runs history for a different and more complicated but complementary approach.

Event Timeline

Change 491284 had a related patch set uploaded (by Framawiki; owner: Framawiki):
[analytics/quarry/web@master] view.js: Show query run date above outputs section

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

Change 491284 merged by jenkins-bot:
[analytics/quarry/web@master] view.js: Show query run date above outputs section

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

LucasWerkmeister added a subscriber: LucasWerkmeister.

Why is this task still open? This was implemented, wasn’t it? (I just noticed that I don’t have to add SELECT NOW() AS as of`;` to my queries anymore ☺)

There is a little planned improvement about timezones:

@zhuyifei1999> my preference is full date in utc in display, and full date in local in hover

Change 517145 had a related patch set uploaded (by Framawiki; owner: Framawiki):
[analytics/quarry/web@master] view.js: Show full run date in UTC

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