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.
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
Change 491284 merged by jenkins-bot:
[analytics/quarry/web@master] view.js: Show query run date above outputs section
Mentioned in SAL (#wikimedia-cloud) [2019-02-18T21:48:00Z] <framawiki> Deployed 6bda39e on -web-01 T215831
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
Change 517145 merged by jenkins-bot:
[analytics/quarry/web@master] view.js: Show full run date in UTC