[04:27:02] 10Quarry: Show the execution time in the table of queries - https://phabricator.wikimedia.org/T71264 (10zhuyifei1999) [04:27:07] 10Quarry, 10Patch-For-Review: Include query execution time - https://phabricator.wikimedia.org/T126888 (10zhuyifei1999) 05Resolved>03Open @Framawiki: I think using using the time of `cur.execute` to get the execution time is flawed. There is no way [[https://quarry.wmflabs.org/query/17928|this query]] coul... [04:37:56] 10Quarry, 10Patch-For-Review: Include query execution time - https://phabricator.wikimedia.org/T126888 (10zhuyifei1999) Tested with https://quarry.wmflabs.org/query/30399: ``` SELECT SLEEP(10); ``` waits for completion in cur.execute(), while ``` USE enwiki_p; SELECT SLEEP(10); ``` doesn't. [04:45:08] 10Quarry, 10Patch-For-Review: Include query execution time - https://phabricator.wikimedia.org/T126888 (10mahmoud) It would be nice to have both execute time and combined execute + fetch time, as the latter more accurately represents the an application would spend waiting (which would really help with prototyp... [04:53:28] 10Quarry, 10Patch-For-Review: Include query execution time - https://phabricator.wikimedia.org/T126888 (10zhuyifei1999) I guess we could just change to execute + fetch + store. Beware though, that can be heavily lagged due to the use of SQLite on NFS for storing the results, [05:01:16] 10Quarry: Example queries for Quarry - https://phabricator.wikimedia.org/T207098 (10zhuyifei1999) https://wikitech.wikimedia.org/wiki/Help:MySQL_queries#Example_queries ? [17:03:52] yoohoo leila dsaez [17:03:58] coming to hangout? [17:04:19] https://hangouts.google.com/hangouts/_/wikimedia.org/chillout [17:04:51] Yes [17:04:54] ottomata: I am in a board presentation, can't attend (explained in the calendar event) [17:05:00] 1 min [17:05:02] k [17:05:22] ottomata: there is an item we'd like to talk with you about, I've left a note for you all to pick it up on your own (if dsaez) attends, or discuss next time. [17:05:27] ottomata: I'd appreciate good notes, please. :D [17:05:33] yaya luca and i been talking abou tthat too i see it [17:05:49] ottomata: fantastic. I'm sorry that I have to miss it.