{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":589213936,"defaultBranch":"main","name":"pg-timeit","ownerLogin":"joelonsql","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-01-15T13:08:44.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/1784776?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1673788616.462572","currentOid":""},"activityList":{"items":[{"before":"7635df12824feb11d1e9bfffa76c31c1b25c788a","after":"0204b2eeadde65e6633f2c8d5b61ae0454298792","ref":"refs/heads/main","pushedAt":"2024-04-07T10:34:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Add overloaded version of cmp() that takes one and the same input_values\n\nAlso let the timeout input param override all other conditions.","shortMessageHtmlLink":"Add overloaded version of cmp() that takes one and the same input_values"}},{"before":"c39e1bc0d618a7ccaa703ab57104dbaf3e849aef","after":"7635df12824feb11d1e9bfffa76c31c1b25c788a","ref":"refs/heads/main","pushedAt":"2023-12-27T07:49:38.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Add significant_figures input param to timeit.cmp()","shortMessageHtmlLink":"Add significant_figures input param to timeit.cmp()"}},{"before":"d50e7e17fb453dbdc198982ea2de958f80d09e00","after":"c39e1bc0d618a7ccaa703ab57104dbaf3e849aef","ref":"refs/heads/main","pushedAt":"2023-11-26T18:23:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Add min_time param to cmp()","shortMessageHtmlLink":"Add min_time param to cmp()"}},{"before":"24cdf21b84f7e48a6ae91e84d537b5d8506e5a9b","after":"d50e7e17fb453dbdc198982ea2de958f80d09e00","ref":"refs/heads/main","pushedAt":"2023-11-10T14:26:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Divide total time with two","shortMessageHtmlLink":"Divide total time with two"}},{"before":"4e74d09d59d2052cc7a3c8b727550749419b7ab3","after":"24cdf21b84f7e48a6ae91e84d537b5d8506e5a9b","ref":"refs/heads/main","pushedAt":"2023-11-10T09:03:33.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Simplify timeit.cmp()","shortMessageHtmlLink":"Simplify timeit.cmp()"}},{"before":"120dc6a646b32426012ed4e71c70dedfd74ceb27","after":"4e74d09d59d2052cc7a3c8b727550749419b7ab3","ref":"refs/heads/main","pushedAt":"2023-11-10T07:42:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Speed-up further","shortMessageHtmlLink":"Speed-up further"}},{"before":"3dc7a176ac0078d4c6729bbdb00f8db055d2ac53","after":"120dc6a646b32426012ed4e71c70dedfd74ceb27","ref":"refs/heads/main","pushedAt":"2023-11-10T07:12:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Speed-up and simplify timeit.cmp()","shortMessageHtmlLink":"Speed-up and simplify timeit.cmp()"}},{"before":"22fb64e6b92e3fb55ecc4dde73668d971e3957ed","after":"3dc7a176ac0078d4c6729bbdb00f8db055d2ac53","ref":"refs/heads/main","pushedAt":"2023-11-09T14:03:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Return NULL on timeout","shortMessageHtmlLink":"Return NULL on timeout"}},{"before":"395c4ce537bc2f2863ba86553ff99ea473313c44","after":"22fb64e6b92e3fb55ecc4dde73668d971e3957ed","ref":"refs/heads/main","pushedAt":"2023-11-09T13:59:38.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Start at significant_figures=1, then go up if necessary to get a difference","shortMessageHtmlLink":"Start at significant_figures=1, then go up if necessary to get a diff…"}},{"before":"b65826e3b7b6ed5bd2212323f62fea1986b4dcfb","after":"395c4ce537bc2f2863ba86553ff99ea473313c44","ref":"refs/heads/main","pushedAt":"2023-11-07T16:40:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Also retrun total execution time with full precision","shortMessageHtmlLink":"Also retrun total execution time with full precision"}},{"before":"2bb6c04fdef830e4238ba3fb1753c4991848ed28","after":"b65826e3b7b6ed5bd2212323f62fea1986b4dcfb","ref":"refs/heads/main","pushedAt":"2023-11-06T18:02:22.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Add timeit.cmp() to compare two functions, intended to be used to benchmark changes of a function","shortMessageHtmlLink":"Add timeit.cmp() to compare two functions, intended to be used to ben…"}},{"before":"ea3d2cec9e49971902807256971dfa6520412251","after":"2bb6c04fdef830e4238ba3fb1753c4991848ed28","ref":"refs/heads/main","pushedAt":"2023-04-27T07:05:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Rename extension to more descriptive name \"timeit\"","shortMessageHtmlLink":"Rename extension to more descriptive name \"timeit\""}},{"before":"64a03f5d57a27a79cfb94359149dcd34f7b57aac","after":"ea3d2cec9e49971902807256971dfa6520412251","ref":"refs/heads/main","pushedAt":"2023-04-05T20:03:31.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Ensure net_time_1 and net_time_2 are larger than min_time","shortMessageHtmlLink":"Ensure net_time_1 and net_time_2 are larger than min_time"}},{"before":"bd15fb335f29d6c173c3ab1e03301b10ea5ef400","after":"64a03f5d57a27a79cfb94359149dcd34f7b57aac","ref":"refs/heads/main","pushedAt":"2023-04-05T19:54:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Ensure net_time_1 and net_time_2 are larger than min_time","shortMessageHtmlLink":"Ensure net_time_1 and net_time_2 are larger than min_time"}},{"before":"ee13f202d414b10e61eedf3f0a962adfda28708a","after":"bd15fb335f29d6c173c3ab1e03301b10ea5ef400","ref":"refs/heads/main","pushedAt":"2023-03-21T18:53:32.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Add pit.measure_cold() to measure the execution time when functions are cold started.\n\nCALL pit.measure_cold('numeric_sqrt','{2}',1,10);\nNOTICE:  (avg 8.6 µs) (median 8.5 µs) (95% CI [6.8 µs, 10 µs]) (σ 3 µs) (n 10) (13 µs 8 µs 9 µs 5 µs 5 µs 11 µs 10 µs 8 µs 5 µs 12 µs)\nCALL\n\nSELECT pit.h('numeric_sqrt','{2}',2);\nNOTICE:  190 ns (40000 executions)\n   h\n--------\n 150 ns\n(1 row)","shortMessageHtmlLink":"Add pit.measure_cold() to measure the execution time when functions a…"}},{"before":"bd15fb335f29d6c173c3ab1e03301b10ea5ef400","after":"ee13f202d414b10e61eedf3f0a962adfda28708a","ref":"refs/heads/main","pushedAt":"2023-03-21T14:48:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Change default min_time from 10 ms to 20 ms.\n\nExperimentation indicates it's a better default.","shortMessageHtmlLink":"Change default min_time from 10 ms to 20 ms."}},{"before":"f9c9e411ef841e3838b58334ecd8e23b7e1247d6","after":"bd15fb335f29d6c173c3ab1e03301b10ea5ef400","ref":"refs/heads/main","pushedAt":"2023-03-21T14:22:03.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Add pit.measure_cold() to measure the execution time when functions are cold started.\n\nCALL pit.measure_cold('numeric_sqrt','{2}',1,10);\nNOTICE:  (avg 8.6 µs) (median 8.5 µs) (95% CI [6.8 µs, 10 µs]) (σ 3 µs) (n 10) (13 µs 8 µs 9 µs 5 µs 5 µs 11 µs 10 µs 8 µs 5 µs 12 µs)\nCALL\n\nSELECT pit.h('numeric_sqrt','{2}',2);\nNOTICE:  190 ns (40000 executions)\n   h\n--------\n 150 ns\n(1 row)","shortMessageHtmlLink":"Add pit.measure_cold() to measure the execution time when functions a…"}},{"before":"1d6a3ff3b1b813c713d3cea50ae1d9bacb660d43","after":"f9c9e411ef841e3838b58334ecd8e23b7e1247d6","ref":"refs/heads/main","pushedAt":"2023-03-19T21:04:41.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Add min_time with a 10 ms default. Also add a new reporting view.\n\nExperimentation have shown that a minimum execution time of 10 ms\nworks good to prevent getting a final result with the requested\nnumbers of significant digits by accident.\n\nAlso move the timeout code to the end of the loop, to consider if\nwe should continue only after first checking if we can produce\na result. Otherwise we could timeout even though already having a\nresult.","shortMessageHtmlLink":"Add min_time with a 10 ms default. Also add a new reporting view."}},{"before":"4d4c6d53a298b35b5b384e37e707e57132787b68","after":"1d6a3ff3b1b813c713d3cea50ae1d9bacb660d43","ref":"refs/heads/main","pushedAt":"2023-03-19T21:01:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Add min_time with a 10 ms default. Also add a new reporting view.\n\nExperimentation have shown that a minimum execution time of 10 ms\nworks good to prevent getting a final result with the requested\nnumbers of significant digits by accident.\n\nAlso move the timeout code to the end of the loop, to consider if\nwe should continue only after first checking if we can produce\na result. Otherwise we could timeout even though already having a\nresult.","shortMessageHtmlLink":"Add min_time with a 10 ms default. Also add a new reporting view."}},{"before":"2cf9d496279c47da25d3d1843e44a4423b822263","after":"4d4c6d53a298b35b5b384e37e707e57132787b68","ref":"refs/heads/main","pushedAt":"2023-03-16T03:00:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Double the min time spent testing also in pit.work()","shortMessageHtmlLink":"Double the min time spent testing also in pit.work()"}},{"before":"6af43048a3c070122852cb5d69d1e053558f6655","after":"2cf9d496279c47da25d3d1843e44a4423b822263","ref":"refs/heads/main","pushedAt":"2023-03-16T00:53:39.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Improve timeout handling with attempts & warm-up.\n\n* Add attempts and remaining_attempts fields to pit.tests and pit.test_params tables\n* Modify pit.async(), pit.h(), and pit.s() functions to support the new attempts field\n* Update pit.work() procedure to handle remaining_attempts and make warm-up calls before measurement","shortMessageHtmlLink":"Improve timeout handling with attempts & warm-up."}},{"before":"9d503cea96bbc418f9c0c5d296e2e93667d873cf","after":"6af43048a3c070122852cb5d69d1e053558f6655","ref":"refs/heads/main","pushedAt":"2023-03-16T00:48:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Improve timeout handling with attempts & warm-up.\n\n* Add attempts and remaining_attempts fields to pit.tests and pit.test_params tables\n* Modify pit.async(), pit.h(), and pit.s() functions to support the new attempts field\n* Update pit.work() procedure to handle remaining_attempts and make warm-up calls before measurement","shortMessageHtmlLink":"Improve timeout handling with attempts & warm-up."}},{"before":"9a9398f905c8333df278ddf1aa126263aaaa46da","after":"9d503cea96bbc418f9c0c5d296e2e93667d873cf","ref":"refs/heads/main","pushedAt":"2023-03-12T18:38:10.825Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Increase the minimum measurement time by a factor of two\n\nField studies have shown some measurements retruns too early,\nand increasing this factor by two fixed the current problem,\nso let's see how far this takes us, and perhaps increase it even\nfurther in the future.","shortMessageHtmlLink":"Increase the minimum measurement time by a factor of two"}},{"before":"0f83298bfeb953a838adff912ed7adb8bd37026b","after":"9a9398f905c8333df278ddf1aa126263aaaa46da","ref":"refs/heads/main","pushedAt":"2023-03-12T14:33:11.813Z","pushType":"push","commitsCount":2,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Change timeout strategy to instead decrease sig. digits. by one.\n\nThe previous strategy of just using the current result didn't work well,\nsince there might or might not be any sig digits in common,\nso better to start over at executions=1 and be slightly less ambitious.","shortMessageHtmlLink":"Change timeout strategy to instead decrease sig. digits. by one."}},{"before":"5ce2378d0d87b0a5a5a29c3c91f33bbff44a0bc9","after":"0f83298bfeb953a838adff912ed7adb8bd37026b","ref":"refs/heads/main","pushedAt":"2023-03-11T13:55:28.017Z","pushType":"push","commitsCount":1,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Add timeout parameter\n\nAlso fix pretty_time() and round_to_sig_figs() so they work with zero and negative inputs.","shortMessageHtmlLink":"Add timeout parameter"}},{"before":"35f3d6136dbf419eadcc2fa061af644fad8e0441","after":"5ce2378d0d87b0a5a5a29c3c91f33bbff44a0bc9","ref":"refs/heads/main","pushedAt":"2023-03-09T14:00:29.973Z","pushType":"push","commitsCount":2,"pusher":{"login":"joelonsql","name":"Joel Jakobsson","path":"/joelonsql","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1784776?s=80&v=4"},"commit":{"message":"Extract pretty formating of time into separate callable function.\n\nSince needed at two places. The other place being a RAISE NOTICE\nalso added in this commit to show the number of executinos so far\nand the intermediate result of the measured execution time,\nuseful to get a feeling for when it's pointless to continue waiting\nfor N number of sig digits, if observing the value doesn't converge.","shortMessageHtmlLink":"Extract pretty formating of time into separate callable function."}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEKg93NQA","startCursor":null,"endCursor":null}},"title":"Activity · joelonsql/pg-timeit"}