)]}'
{"id":"openstack%2Fcloudkitty~865417","triplet_id":"openstack%2Fcloudkitty~master~I8acbc8946d9e001419f7bf5064fcebe0a0ae907a","project":"openstack/cloudkitty","branch":"master","topic":"optimize-sql-queries","attention_set":{},"removed_from_attention_set":{"28356":{"account":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"last_update":"2023-03-06 14:21:20.000000000","reason":"\u003cGERRIT_ACCOUNT_28356\u003e replied on the change","reason_account":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"}},"30695":{"account":{"_account_id":30695,"name":"Pedro Henrique Pereira Martins","email":"phpm13@gmail.com","username":"pedrohpmartins"},"last_update":"2023-09-18 11:57:04.000000000","reason":"Change was submitted"},"15197":{"account":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"last_update":"2023-02-20 14:39:44.000000000","reason":"\u003cGERRIT_ACCOUNT_15197\u003e replied on the change","reason_account":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"}},"25277":{"account":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"last_update":"2023-02-20 14:33:37.000000000","reason":"\u003cGERRIT_ACCOUNT_25277\u003e replied on the change","reason_account":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"}},"29422":{"account":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"last_update":"2023-09-18 11:57:04.000000000","reason":"Change was submitted"}},"hashtags":[],"change_id":"I8acbc8946d9e001419f7bf5064fcebe0a0ae907a","subject":"Optimizing SQL queries that filter on a time range","status":"MERGED","created":"2022-11-23 11:38:07.000000000","updated":"2023-09-18 11:58:08.000000000","submitted":"2023-09-18 11:57:04.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":18,"unresolved_comment_count":1,"has_review_started":true,"submission_id":"865417-optimize-sql-queries","meta_rev_id":"e3ad8a4597b6e1b617aa068cedf11f98aea1266a","_number":865417,"virtual_id_number":865417,"owner":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},{"value":0,"_account_id":29349,"name":"Simeon Gourlin","email":"simeon.gourlin@infomaniak.com","username":"6meon"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2023-09-18 11:57:04.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},{"value":0,"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","default_value":0,"optional":true},"Code-Review":{"approved":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"all":[{"value":2,"date":"2023-03-06 14:21:20.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},{"value":0,"_account_id":29349,"name":"Simeon Gourlin","email":"simeon.gourlin@infomaniak.com","username":"6meon"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":2,"date":"2023-03-06 11:43:54.000000000","_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},{"value":0,"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"}],"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","default_value":0,"optional":true},"Workflow":{"approved":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"all":[{"value":1,"date":"2023-04-03 13:14:17.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},{"value":0,"_account_id":29349,"name":"Simeon Gourlin","email":"simeon.gourlin@infomaniak.com","username":"6meon"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},{"value":0,"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},{"value":0,"_account_id":29349,"name":"Simeon Gourlin","email":"simeon.gourlin@infomaniak.com","username":"6meon"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},{"value":0,"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"}],"values":{"-1":"Branch Freeze"," 0":"No Priority","+1":"Important Change","+2":"Gate Blocker Fix / Urgent Change"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"CC":[{"_account_id":30695,"name":"Pedro Henrique Pereira Martins","email":"phpm13@gmail.com","username":"pedrohpmartins"}],"REVIEWER":[{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},{"_account_id":29349,"name":"Simeon Gourlin","email":"simeon.gourlin@infomaniak.com","username":"6meon"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2022-11-23 11:47:53.000000000","updated_by":{"_account_id":29349,"name":"Simeon Gourlin","email":"simeon.gourlin@infomaniak.com","username":"6meon"},"reviewer":{"_account_id":29349,"name":"Simeon Gourlin","email":"simeon.gourlin@infomaniak.com","username":"6meon"},"state":"REVIEWER"},{"updated":"2022-11-23 12:23:18.000000000","updated_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"reviewer":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2022-11-28 10:59:44.000000000","updated_by":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"reviewer":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"state":"CC"},{"updated":"2022-11-28 15:30:50.000000000","updated_by":{"_account_id":30695,"name":"Pedro Henrique Pereira Martins","email":"phpm13@gmail.com","username":"pedrohpmartins"},"reviewer":{"_account_id":30695,"name":"Pedro Henrique Pereira Martins","email":"phpm13@gmail.com","username":"pedrohpmartins"},"state":"CC"},{"updated":"2022-11-29 15:35:14.000000000","updated_by":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"reviewer":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"state":"CC"},{"updated":"2022-12-12 13:10:38.000000000","updated_by":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"reviewer":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"state":"REVIEWER"},{"updated":"2022-12-12 13:41:54.000000000","updated_by":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"reviewer":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"state":"REVIEWER"},{"updated":"2023-02-20 14:39:44.000000000","updated_by":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"reviewer":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"state":"REVIEWER"}],"messages":[{"id":"6c651d49f78c758b1dca1b15ce805059b277408f","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-11-23 11:38:07.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"0be03a6be6ed8479bba6564151ef08dc3ef68a55","author":{"_account_id":29349,"name":"Simeon Gourlin","email":"simeon.gourlin@infomaniak.com","username":"6meon"},"date":"2022-11-23 11:47:53.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"92688611a7ff0f3e88b32258d1d87d46f250c5ea","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-11-23 12:23:18.000000000","message":"Patch Set 1: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\nhttps://zuul.opendev.org/t/openstack/buildset/f4b89db81cc245bfbc67120e125d0a37\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/5169941dc108457a9622a23a23b21ad0 : FAILURE in 3m 56s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/498ae96a94874e80ab30146d887cfabe : SUCCESS in 3m 04s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/8f3181d0ebfe421297cc500153f11d2c : FAILURE in 3m 28s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/0f48a08339324f3c94b51eab7363d6f3 : FAILURE in 3m 34s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/5d076bbf50384e518b1f9b0ebe890a56 : SUCCESS in 3m 36s\n- cloudkitty-tempest-full-v2-storage-influxdb https://zuul.opendev.org/t/openstack/build/8064f909f1794fe2a5c4f972a756dda9 : SUCCESS in 37m 30s\n- cloudkitty-tempest-full-v2-storage-elasticsearch https://zuul.opendev.org/t/openstack/build/feae442507f2496e8c629ffe6057425f : SUCCESS in 35m 43s (non-voting)\n- cloudkitty-tempest-full-v1-storage-sqlalchemy https://zuul.opendev.org/t/openstack/build/2a39c99ef62046f29102e3516a352ffa : SUCCESS in 33m 31s\n- cloudkitty-tempest-full-ipv6-only https://zuul.opendev.org/t/openstack/build/00dd19f6096d4f0f89f2a6df22ddc8d8 : SUCCESS in 35m 08s\n- cloudkitty-tox-bandit https://zuul.opendev.org/t/openstack/build/e591ac88a77a4f9ab2f10588e44bdfd7 : SUCCESS in 3m 00s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"8355fae3685bae77bf6dd2f0dcbfd1a6e832688a","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-11-23 12:36:06.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"6199c9acf71a3c8e6271f7d0ffff589727c987d4","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-11-23 13:08:21.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/78117121f0ba4ee187971eecdb45db63\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/3829097caabe4e469e98dc3eec7b2bf7 : SUCCESS in 6m 05s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/96f2b5ea35644b079b0256a1c659b21e : SUCCESS in 3m 49s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/d2f23d0323b444bca8eee28227855e0f : SUCCESS in 4m 19s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/9465cfdf826f45ec9192ebde92e93504 : SUCCESS in 4m 22s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/0c4ac3ae6ef948f6b9a779bfbfdd42be : SUCCESS in 4m 11s\n- cloudkitty-tempest-full-v2-storage-influxdb https://zuul.opendev.org/t/openstack/build/6cc80b1194764ec2891c00d0a16eff2b : SUCCESS in 28m 22s\n- cloudkitty-tempest-full-v2-storage-elasticsearch https://zuul.opendev.org/t/openstack/build/1fe5a17079674fb7960b067294baa344 : SUCCESS in 29m 03s (non-voting)\n- cloudkitty-tempest-full-v1-storage-sqlalchemy https://zuul.opendev.org/t/openstack/build/b5c95c992d5d4fc29513aacb5ea13809 : SUCCESS in 27m 34s\n- cloudkitty-tempest-full-ipv6-only https://zuul.opendev.org/t/openstack/build/10a8ca934ae34d66aeb50e4112f2d8a7 : SUCCESS in 26m 09s\n- cloudkitty-tox-bandit https://zuul.opendev.org/t/openstack/build/7da87474b6d143af874a1ab4d3d45004 : SUCCESS in 3m 33s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"91c65e05c53873c372f1b0a391574b3ee70058a0","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2022-11-28 10:59:44.000000000","message":"Patch Set 2:\n\n(2 comments)","accounts_in_message":[],"_revision_number":2},{"id":"f7f742482f65c81302cb15cc494584a096a05c3a","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-11-28 13:52:46.000000000","message":"Patch Set 2:\n\n(2 comments)","accounts_in_message":[],"_revision_number":2},{"id":"2700782fa5f81c88373b816467521f33ec44da88","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2022-11-28 14:01:33.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"081d57e7ac473b1737468afa94345bb8be6b77a5","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-11-28 14:17:21.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"2ecaa4e377414ca7abc86752c79e1d9b9c77a0b1","author":{"_account_id":30695,"name":"Pedro Henrique Pereira Martins","email":"phpm13@gmail.com","username":"pedrohpmartins"},"date":"2022-11-28 15:30:50.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"e728f7485cc07d081ea474322a5b894c358900ae","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-11-29 08:19:46.000000000","message":"Patch Set 3: Commit message was updated.","accounts_in_message":[],"_revision_number":3},{"id":"a6b958225a46b187ddbef348ff933ccaceaeacd8","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-11-29 08:21:34.000000000","message":"Patch Set 3:\n\n(1 comment)","accounts_in_message":[],"_revision_number":3},{"id":"6fde72e4841419b8f10f3e1db439721a4017be2f","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-11-29 09:06:04.000000000","message":"Patch Set 3: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/f4d93cc7c5bd4e1da0312889bbc74a35\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/d4bfad470a1f4783bea2c6ba3ee2900e : SUCCESS in 4m 18s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/d191b512751542ee83d8ebb58aa681d7 : SUCCESS in 3m 23s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/7f904f075e0346f7b23daeb68d1d7d8a : SUCCESS in 3m 35s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/4c4fed1c54c6495db66c20da1d635e52 : SUCCESS in 3m 43s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/515424662eb0486d8c738d8da6562140 : SUCCESS in 3m 40s\n- cloudkitty-tempest-full-v2-storage-influxdb https://zuul.opendev.org/t/openstack/build/804ac6ae25f44b3b85dbb258d6d578af : SUCCESS in 39m 14s\n- cloudkitty-tempest-full-v2-storage-elasticsearch https://zuul.opendev.org/t/openstack/build/32ac44fdc8034a179345ca50b9c07bf9 : SUCCESS in 38m 03s (non-voting)\n- cloudkitty-tempest-full-v1-storage-sqlalchemy https://zuul.opendev.org/t/openstack/build/e5ac5f3201dd4fc29a6968cb15781e3f : SUCCESS in 33m 32s\n- cloudkitty-tempest-full-ipv6-only https://zuul.opendev.org/t/openstack/build/a27200602cb94f35b205bce7ff367fae : SUCCESS in 33m 51s\n- cloudkitty-tox-bandit https://zuul.opendev.org/t/openstack/build/fc3e661d94f04e98b842c545ce518fcc : SUCCESS in 3m 09s (non-voting)","accounts_in_message":[],"_revision_number":3},{"id":"933eb8c20e8092bca078c8ca43b7448133e5bb31","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2022-11-29 11:00:55.000000000","message":"Patch Set 3:\n\n(1 comment)","accounts_in_message":[],"_revision_number":3},{"id":"3287c15a93a5345efe9c364d8a3150f340c68b70","author":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"date":"2022-11-29 15:35:14.000000000","message":"Patch Set 3:\n\n(1 comment)","accounts_in_message":[],"_revision_number":3},{"id":"bf5a848a3d887597848942aa77e0aee0bb7c87f8","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-11-30 08:46:27.000000000","message":"Uploaded patch set 4.","accounts_in_message":[],"_revision_number":4},{"id":"d0ed1c7f70716a2356ee8ca084a3ca0071ea9013","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-11-30 08:47:29.000000000","message":"Uploaded patch set 5: Commit message was updated.","accounts_in_message":[],"_revision_number":5},{"id":"4b3a2838106895a29ec18974cf3fc102ef902892","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-11-30 09:01:57.000000000","message":"Patch Set 5: Verified-1\n\nThis change depends on a change that failed to merge.\n\nChange https://review.opendev.org/865435 is needed.","accounts_in_message":[],"_revision_number":5},{"id":"6557d5e761fe410f37221074b22c52f9438b341a","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-12-01 09:16:33.000000000","message":"Patch Set 5:\n\n(1 comment)","accounts_in_message":[],"_revision_number":5},{"id":"4f9bf18f94f716fced4910ed2f650b7d614d62b0","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-12-05 12:36:49.000000000","message":"Uploaded patch set 6.","accounts_in_message":[],"_revision_number":6},{"id":"80fcc3a3d75a3e5861933dcbfd6de380143d66a8","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-12-05 12:40:32.000000000","message":"Patch Set 6:\n\n(1 comment)","accounts_in_message":[],"_revision_number":6},{"id":"74f679e79e30a8fb3d16b69e92304c02bcbeab85","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2022-12-05 12:43:09.000000000","message":"Patch Set 6:\n\n(1 comment)","accounts_in_message":[],"_revision_number":6},{"id":"8ff97f17e78417123490546ad5d28b5871439904","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-12-05 12:50:54.000000000","message":"Uploaded patch set 7.","accounts_in_message":[],"_revision_number":7},{"id":"7a728e9f4f0a1c20bef3009d169976ad29c452a1","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-12-05 13:30:11.000000000","message":"Patch Set 7: Verified-1\n\n(1 comment)\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\nhttps://zuul.opendev.org/t/openstack/buildset/16ed8dfcc39e4fbeae6df70f3bc4e5ff\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/4290ae01a07c47d48903ea56b0c8686f : FAILURE in 6m 17s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/652503266aa445e09f1675c86312c96a : FAILURE in 3m 12s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/aa304298172f4fa5bd757439da557fdb : FAILURE in 2m 53s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/9dff9d85d8784f6a8955b010bbf38aec : FAILURE in 6m 53s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/a5b5687bbabc4a82bda94754d83a2689 : SUCCESS in 3m 10s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/9cc80a0a38e54cbfb43f7d08d5460d18 : SUCCESS in 2m 47s\n- cloudkitty-tempest-full-v2-storage-influxdb https://zuul.opendev.org/t/openstack/build/5ab0eee49eab408b9f9ef4b6684376da : SUCCESS in 33m 27s\n- cloudkitty-tempest-full-v2-storage-elasticsearch https://zuul.opendev.org/t/openstack/build/677941e7ae97477fa3b661841576f85f : SUCCESS in 34m 30s (non-voting)\n- cloudkitty-tempest-full-v1-storage-sqlalchemy https://zuul.opendev.org/t/openstack/build/47777655577c452790ad116daee6c4b1 : FAILURE in 27m 20s\n- cloudkitty-tempest-full-ipv6-only https://zuul.opendev.org/t/openstack/build/1027fff91f9b4c26b4e3993e8bcd260e : SUCCESS in 34m 31s\n- cloudkitty-tox-bandit https://zuul.opendev.org/t/openstack/build/1954d957ca104ffd86b9d09fdc3772e0 : SUCCESS in 2m 38s (non-voting)","accounts_in_message":[],"_revision_number":7},{"id":"aad1bb69d7c8ca7d00ae4dedd3d9efc838958759","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-12-05 13:38:16.000000000","message":"Uploaded patch set 8.","accounts_in_message":[],"_revision_number":8},{"id":"86f939a7b3850bb75f06fff11e5af2d4c64db7f1","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-12-05 14:07:09.000000000","message":"Patch Set 8: Verified-1\n\n(1 comment)\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\nhttps://zuul.opendev.org/t/openstack/buildset/6cf0350dbc9b4eb4b558153584320e9b\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/7231714d6908434ab92a5e5728e7b44b : FAILURE in 3m 40s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/af1cf12ee51248eb9cb7513aa8234a01 : FAILURE in 3m 35s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/ad83a5f9f05b4eb08315ca27fd88cae1 : FAILURE in 2m 54s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/faabd63093324f7c88495a819a99b57a : FAILURE in 3m 18s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/22bf8c042bf04ccd8d973fded50cff20 : SUCCESS in 3m 40s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/5b2930fd2fb14c699f4c39174bbf773e : SUCCESS in 2m 50s\n- cloudkitty-tempest-full-v2-storage-influxdb https://zuul.opendev.org/t/openstack/build/7224d4d85f704c79a3d24f388d73ee38 : SUCCESS in 27m 17s\n- cloudkitty-tempest-full-v2-storage-elasticsearch https://zuul.opendev.org/t/openstack/build/29518eadae204712834e6fe977e58e5b : SUCCESS in 27m 09s (non-voting)\n- cloudkitty-tempest-full-v1-storage-sqlalchemy https://zuul.opendev.org/t/openstack/build/c1dcbffe9eb64536bbd35c92935e1a13 : FAILURE in 21m 41s\n- cloudkitty-tempest-full-ipv6-only https://zuul.opendev.org/t/openstack/build/81eda02254724714b87179c28d7020e5 : SUCCESS in 26m 28s\n- cloudkitty-tox-bandit https://zuul.opendev.org/t/openstack/build/aa3820c379594bb2b51b6a00c5f78c08 : SUCCESS in 3m 11s (non-voting)","accounts_in_message":[],"_revision_number":8},{"id":"11383312407662c0863c15fd083fdb5e451cce40","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-12-06 07:43:44.000000000","message":"Patch Set 7:\n\n(1 comment)","accounts_in_message":[],"_revision_number":7},{"id":"6fe6319ada8ead79d161f791918d95ab41780a05","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"date":"2022-12-06 09:26:51.000000000","message":"Uploaded patch set 9.","accounts_in_message":[],"_revision_number":9},{"id":"068ebcc0de006526bef36ef498cd22c2cefd2d5c","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-12-06 10:09:39.000000000","message":"Patch Set 9: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/a908d9226e6e436885079cc2e129e800\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/98f04dd2e6b9416d92604698b5822d29 : SUCCESS in 4m 28s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/da22b7f5f7ca4461960b110b95e17889 : SUCCESS in 3m 16s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/07f7e137035d4eb7861e88ee52d740be : SUCCESS in 3m 38s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/9dc72a2f111d4268935d18a7a40010b7 : SUCCESS in 3m 47s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/b31dbce73ab7453895f1aecc3b377e6c : SUCCESS in 3m 52s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/e66bb59cda1f4b0f9a08526c571768ba : SUCCESS in 2m 50s\n- cloudkitty-tempest-full-v2-storage-influxdb https://zuul.opendev.org/t/openstack/build/274ac1c9a93943edb6d1639c15fc6c22 : SUCCESS in 35m 08s\n- cloudkitty-tempest-full-v2-storage-elasticsearch https://zuul.opendev.org/t/openstack/build/d94e8a5b14df4464a994e362ba9cc2f6 : SUCCESS in 35m 28s (non-voting)\n- cloudkitty-tempest-full-v1-storage-sqlalchemy https://zuul.opendev.org/t/openstack/build/37b113dc61114cefa39d5d53a3495eb2 : SUCCESS in 34m 02s\n- cloudkitty-tempest-full-ipv6-only https://zuul.opendev.org/t/openstack/build/097edfb1b7ed4424bab4d862826bffb1 : SUCCESS in 36m 06s\n- cloudkitty-tox-bandit https://zuul.opendev.org/t/openstack/build/5fc425e493554ae9baeedf89a49c7242 : SUCCESS in 3m 28s (non-voting)","accounts_in_message":[],"_revision_number":9},{"id":"81ac173668c368c31ef71e47446f9ad8dd5ea83f","author":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"date":"2022-12-12 13:10:38.000000000","message":"Patch Set 9: Code-Review+1\n\n(1 comment)","accounts_in_message":[],"_revision_number":9},{"id":"780dd3935ba05ffaa4ddfe5067d4723f20049963","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2022-12-12 13:41:54.000000000","message":"Patch Set 9: Code-Review+2","accounts_in_message":[],"_revision_number":9},{"id":"1a6f431d82c4ce674cf8f81f36de33cd8c0cca5c","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2023-01-26 20:34:38.000000000","message":"Patch Set 9:\n\n(1 comment)","accounts_in_message":[],"_revision_number":9},{"id":"c23a8ccda9ea8082e1ab50dd237f73b2cb951cfc","author":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"date":"2023-02-20 14:33:37.000000000","message":"Patch Set 9: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":9},{"id":"3825841837aa08f2d530ce69adf2c08325ef0149","author":{"_account_id":15197,"name":"Pierre Riteau","email":"pierre@stackhpc.com","username":"priteau","status":"StackHPC"},"date":"2023-02-20 14:39:44.000000000","message":"Patch Set 9: Workflow-1\n\n(1 comment)","accounts_in_message":[],"_revision_number":9},{"id":"108ac1f5701d76cd2e785e19e31c6f123cdd5977","author":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"date":"2023-02-20 14:42:42.000000000","message":"Patch Set 9: -Workflow","accounts_in_message":[],"_revision_number":9},{"id":"96aaa6fc9dbca32d56078171da1ad0d052b992eb","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2023-03-06 11:14:23.000000000","message":"Uploaded patch set 10.","accounts_in_message":[],"_revision_number":10},{"id":"539d379e346e0b5c53398c575189886dff8028f9","author":{"_account_id":25277,"name":"Mariusz Karpiarz","email":"mariusz.karpiarz@codethink.co.uk","username":"mkarpiarz"},"date":"2023-03-06 11:43:54.000000000","message":"Patch Set 10: Code-Review+2","accounts_in_message":[],"_revision_number":10},{"id":"b9b64871e24ee9dcae52f31cdcb02c1c3a3fdbe4","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-03-06 12:04:10.000000000","message":"Patch Set 10: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/ae78a2bae7694c9ba23818b3323d39c9\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/3ac8267af4a241e6a21f41ddd0402489 : SUCCESS in 4m 08s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/f305b3ae82b7436e8bbf0d4df255184c : SUCCESS in 3m 03s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/bf505b2d542a49d2a8532003e6c2b520 : SUCCESS in 4m 46s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/9c4d53debc5d4bfd9c54bd26763ff9f0 : SUCCESS in 4m 38s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/7fd10bfe8d3c40ab9cefbe57eec4ccda : SUCCESS in 3m 35s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/04ba4436b4d6484982ee81277f185c61 : SUCCESS in 2m 52s\n- cloudkitty-tempest-full-v2-storage-influxdb https://zuul.opendev.org/t/openstack/build/691a03631b974aa9ae4d94f34d56c6ec : SUCCESS in 28m 20s\n- cloudkitty-tempest-full-v2-storage-elasticsearch https://zuul.opendev.org/t/openstack/build/a77f67cc01b54886ba80de528e42e2f2 : SUCCESS in 27m 12s (non-voting)\n- cloudkitty-tempest-full-v1-storage-sqlalchemy https://zuul.opendev.org/t/openstack/build/f07db2fbef2e47b5adb13fc0fe18a740 : SUCCESS in 33m 38s\n- cloudkitty-tempest-full-ipv6-only https://zuul.opendev.org/t/openstack/build/e26a9df9a09b44e880f04aa6f32075a5 : SUCCESS in 39m 02s\n- cloudkitty-tox-bandit https://zuul.opendev.org/t/openstack/build/9b4e187539fa4f3ab8b18506769dba55 : SUCCESS in 3m 05s (non-voting)","accounts_in_message":[],"_revision_number":10},{"id":"6cb1cfb5f809095aaeeffdffbf5af7cb48898eca","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2023-03-06 14:21:20.000000000","message":"Patch Set 10: Code-Review+2","accounts_in_message":[],"_revision_number":10},{"id":"f1ce47348b44916f4012e8792fa8604db565eda6","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2023-04-03 13:14:17.000000000","message":"Patch Set 10: Workflow+1","accounts_in_message":[],"_revision_number":10},{"id":"a02ad1715dcbd4fa5e43cd683f4caeb9d5d1fad0","author":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"date":"2023-09-18 11:11:19.000000000","message":"Patch Set 10:\n\n(1 comment)","accounts_in_message":[],"_revision_number":10},{"id":"187400a4bae2d4067cf6015dbc07a75191a25a48","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-18 11:11:57.000000000","message":"Patch Set 10: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":10},{"id":"dafff1080cd8e6baedec4e08815232cbe9423c38","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-18 11:56:17.000000000","message":"Patch Set 10: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/da6fddddf3774ac3a97a4985a1fe17eb\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/3467007642fa4589ad0e7616e80efa7c : SUCCESS in 5m 08s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/51d3358c3c6548f9be0935a0caa15c6f : SUCCESS in 3m 08s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/88b05cb4165e4e60aa5661f378105123 : SUCCESS in 3m 35s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/a9cab8ebbe6841de880e352b7d2b2717 : SUCCESS in 3m 59s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/119386e9bc8c4910810fb693c34fe7ef : SUCCESS in 4m 12s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/6b9e1155cf4d4187880e6a94fd1bd1ba : SUCCESS in 4m 47s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/a9aa3da0b0c74d69bae78eb6c5b11609 : SUCCESS in 3m 42s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/578631c9b5b84d2eb9285e84b02dd402 : SUCCESS in 3m 04s\n- cloudkitty-tempest-full-v2-storage-influxdb https://zuul.opendev.org/t/openstack/build/d7bf05a3d016437d805977898b6a74b5 : SUCCESS in 25m 56s\n- cloudkitty-tempest-full-v2-storage-elasticsearch https://zuul.opendev.org/t/openstack/build/c666d3d91b02414f9d975c907cc45f47 : SUCCESS in 37m 53s (non-voting)\n- cloudkitty-tempest-full-v1-storage-sqlalchemy https://zuul.opendev.org/t/openstack/build/1549c47a64284839a21572614274f049 : SUCCESS in 37m 41s\n- cloudkitty-tempest-full-ipv6-only https://zuul.opendev.org/t/openstack/build/daa6acc28e614466a6fe1a1b92296834 : SUCCESS in 29m 18s\n- cloudkitty-tox-bandit https://zuul.opendev.org/t/openstack/build/49443cd47f3f49e3b643d64e070b4521 : FAILURE in 3m 16s (non-voting)","accounts_in_message":[],"_revision_number":10},{"id":"94078313060f6f5b1835f674757838ac6d468b93","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-18 11:57:04.000000000","message":"Patch Set 10: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/afbe1f0813b0475e8a950f83027c40a4\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/4d56cae6c1fd4c609df2082e6ac530ba : SUCCESS in 3m 22s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/87d345f6238f4c73a68f869888118cc0 : SUCCESS in 3m 44s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/bcc8c705d005449190f6201297b0f43f : SUCCESS in 3m 41s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/da51c5219d3e43cdabb922b2b556c8d3 : SUCCESS in 3m 42s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/84298963db9d43f495ed68d88d256202 : SUCCESS in 3m 43s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/3abbce0e2dd1429ca35e1b24a2723823 : SUCCESS in 3m 04s\n- cloudkitty-tempest-full-v2-storage-influxdb https://zuul.opendev.org/t/openstack/build/2f2eca711fc3485381fc84c2fb7cf4a7 : SUCCESS in 39m 55s\n- cloudkitty-tempest-full-v1-storage-sqlalchemy https://zuul.opendev.org/t/openstack/build/e392a1876c5a4f74b968d68c56ed1cb9 : SUCCESS in 25m 32s\n- cloudkitty-tempest-full-ipv6-only https://zuul.opendev.org/t/openstack/build/8557b5264d0749ec82329ec7138927b6 : SUCCESS in 29m 19s","accounts_in_message":[],"_revision_number":10},{"id":"3c244c7bd3b1e1d9c747e14aff808a01c055ff1e","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-18 11:57:04.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":10},{"id":"e3ad8a4597b6e1b617aa068cedf11f98aea1266a","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-18 11:58:08.000000000","message":"Patch Set 10:\n\nBuild succeeded (promote pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/23750e768d314e28b882394dbc845487\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/783ee80eb58b4b7a8a43fa81f5d3739d : SUCCESS in 45s\n- promote-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/a5fd6a0801404736991dd28737b2262c : SUCCESS in 40s","accounts_in_message":[],"_revision_number":10}],"current_revision_number":10,"current_revision":"10a9482a91ace68c081aa95ffb7fc394f688020c","revisions":{"c5351f0d84db37f78e19faba73034b454745a76c":{"kind":"REWORK","_number":1,"created":"2022-11-23 11:38:07.000000000","uploader":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"ref":"refs/changes/17/865417/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/17/865417/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/1"}}},"commit":{"parents":[{"commit":"0c1eabc364999f02d42978c3dbac961f96eb893a","subject":"Validates the period compatibility of reprocessing dates","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/0c1eabc364999f02d42978c3dbac961f96eb893a"}]}],"author":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-11-23 11:36:04.000000000","tz":60},"committer":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-11-23 11:38:05.000000000","tz":60},"subject":"Rewritting SQL date filters with BETWEEN statement instead of \u003e\u003d AND \u003c\u003d for optimisation","message":"Rewritting SQL date filters with BETWEEN statement instead of \u003e\u003d AND \u003c\u003d for optimisation\n\nChange-Id: I8acbc8946d9e001419f7bf5064fcebe0a0ae907a\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/c5351f0d84db37f78e19faba73034b454745a76c"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/c5351f0d84db37f78e19faba73034b454745a76c"}]},"branch":"refs/heads/master"},"63ad92623fd3e13c19a5ab382d8a55e4b32ec970":{"kind":"REWORK","_number":2,"created":"2022-11-23 12:36:06.000000000","uploader":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"ref":"refs/changes/17/865417/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/17/865417/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/2"}}},"commit":{"parents":[{"commit":"0c1eabc364999f02d42978c3dbac961f96eb893a","subject":"Validates the period compatibility of reprocessing dates","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/0c1eabc364999f02d42978c3dbac961f96eb893a"}]}],"author":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-11-23 11:36:04.000000000","tz":60},"committer":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-11-23 12:35:52.000000000","tz":60},"subject":"Rewritting SQL date filters with BETWEEN statement instead of \u003e\u003d AND \u003c\u003d for optimisation","message":"Rewritting SQL date filters with BETWEEN statement instead of \u003e\u003d AND \u003c\u003d for optimisation\n\nChange-Id: I8acbc8946d9e001419f7bf5064fcebe0a0ae907a\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/63ad92623fd3e13c19a5ab382d8a55e4b32ec970"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/63ad92623fd3e13c19a5ab382d8a55e4b32ec970"}]},"branch":"refs/heads/master"},"eb09ea4b64b3c0fe143e2bea17cb4baba6e649f9":{"kind":"NO_CODE_CHANGE","_number":3,"created":"2022-11-29 08:19:46.000000000","uploader":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"ref":"refs/changes/17/865417/3","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/17/865417/3","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/3 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/3 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/3 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/3"}}},"commit":{"parents":[{"commit":"0c1eabc364999f02d42978c3dbac961f96eb893a","subject":"Validates the period compatibility of reprocessing dates","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/0c1eabc364999f02d42978c3dbac961f96eb893a"}]}],"author":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-11-23 11:36:04.000000000","tz":60},"committer":{"name":"guest","email":"olivier.chaze@infomaniak.com","date":"2022-11-29 08:19:46.000000000","tz":0},"subject":"Optimizing SQL queries that filter on a time range. Narrowing data to process by filtering more on frame_model.begin using `BETWEEN` statement which can also use indexes.","message":"Optimizing SQL queries that filter on a time range.\nNarrowing data to process by filtering more on frame_model.begin\nusing `BETWEEN` statement which can also use indexes.\n\nChange-Id: I8acbc8946d9e001419f7bf5064fcebe0a0ae907a\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/eb09ea4b64b3c0fe143e2bea17cb4baba6e649f9"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/eb09ea4b64b3c0fe143e2bea17cb4baba6e649f9"}]},"branch":"refs/heads/master","description":"Edit commit message"},"4841b70564607ee0ee836b0afa3532d42749b41a":{"kind":"REWORK","_number":4,"created":"2022-11-30 08:46:27.000000000","uploader":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"ref":"refs/changes/17/865417/4","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/17/865417/4","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/4 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/4 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/4 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/4"}}},"commit":{"parents":[{"commit":"0c1eabc364999f02d42978c3dbac961f96eb893a","subject":"Validates the period compatibility of reprocessing dates","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/0c1eabc364999f02d42978c3dbac961f96eb893a"}]}],"author":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-11-23 11:36:04.000000000","tz":60},"committer":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-11-29 02:31:01.000000000","tz":60},"subject":"Optimizing SQL queries that filter on a time range","message":"Optimizing SQL queries that filter on a time range\n\nQueries filtering on date fields are slow as they have to parse each row.\nThere are sometimes millions of rows to parse while only a few thousands\nare necessary.\n\nThe following patch narrows data to process by filtering more on\nframe_model.begin as a firtst step using a `BETWEEN` statement instead\nof \u003e\u003d\n\nChange-Id: I8acbc8946d9e001419f7bf5064fcebe0a0ae907a\nDepends-On: Ia6908d13c91a02c47863ae6ac4b595ac98f9fd91\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/4841b70564607ee0ee836b0afa3532d42749b41a"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/4841b70564607ee0ee836b0afa3532d42749b41a"}]},"branch":"refs/heads/master"},"308f8d652c583e5bfe6c51f4cfba8647aa3ea0a6":{"kind":"NO_CODE_CHANGE","_number":5,"created":"2022-11-30 08:47:29.000000000","uploader":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"ref":"refs/changes/17/865417/5","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/17/865417/5","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/5 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/5 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/5 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/5"}}},"commit":{"parents":[{"commit":"0c1eabc364999f02d42978c3dbac961f96eb893a","subject":"Validates the period compatibility of reprocessing dates","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/0c1eabc364999f02d42978c3dbac961f96eb893a"}]}],"author":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-11-23 11:36:04.000000000","tz":60},"committer":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-11-29 02:31:34.000000000","tz":60},"subject":"Optimizing SQL queries that filter on a time range","message":"Optimizing SQL queries that filter on a time range\n\nQueries filtering on date fields are slow as they have to parse each\nrow. There are sometimes millions of rows to parse while only a few\nthousands are necessary.\n\nThe following patch narrows data to process by filtering more on\nframe_model.begin as a firtst step using a `BETWEEN` statement instead\nof \u003e\u003d\n\nChange-Id: I8acbc8946d9e001419f7bf5064fcebe0a0ae907a\nDepends-On: Ia6908d13c91a02c47863ae6ac4b595ac98f9fd91\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/308f8d652c583e5bfe6c51f4cfba8647aa3ea0a6"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/308f8d652c583e5bfe6c51f4cfba8647aa3ea0a6"}]},"branch":"refs/heads/master"},"0b594698d69ba2b97f478f087f6d390ada322ec3":{"kind":"REWORK","_number":6,"created":"2022-12-05 12:36:49.000000000","uploader":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"ref":"refs/changes/17/865417/6","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/17/865417/6","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/6 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/6 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/6 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/6"}}},"commit":{"parents":[{"commit":"0c1eabc364999f02d42978c3dbac961f96eb893a","subject":"Validates the period compatibility of reprocessing dates","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/0c1eabc364999f02d42978c3dbac961f96eb893a"}]}],"author":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-11-23 11:36:04.000000000","tz":60},"committer":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-12-04 19:02:16.000000000","tz":60},"subject":"Optimizing SQL queries that filter on a time range","message":"Optimizing SQL queries that filter on a time range\n\nQueries filtering on date fields are slow as they have to parse each\nrow. There are sometimes millions of rows to parse while only a few\nthousands are necessary.\n\nThe following patch narrows data to process by filtering more on\nframe_model.begin as a firtst step using a `BETWEEN` statement instead\nof \u003e\u003d\n\nChange-Id: I8acbc8946d9e001419f7bf5064fcebe0a0ae907a\nDepends-On: Ia6908d13c91a02c47863ae6ac4b595ac98f9fd91\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/0b594698d69ba2b97f478f087f6d390ada322ec3"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/0b594698d69ba2b97f478f087f6d390ada322ec3"}]},"branch":"refs/heads/master"},"5b78886244ae659cf82b42c520b203dc3a825107":{"kind":"REWORK","_number":7,"created":"2022-12-05 12:50:54.000000000","uploader":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"ref":"refs/changes/17/865417/7","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/17/865417/7","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/7 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/7 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/7 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/7"}}},"commit":{"parents":[{"commit":"0c1eabc364999f02d42978c3dbac961f96eb893a","subject":"Validates the period compatibility of reprocessing dates","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/0c1eabc364999f02d42978c3dbac961f96eb893a"}]}],"author":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-11-23 11:36:04.000000000","tz":60},"committer":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-12-04 19:16:32.000000000","tz":60},"subject":"Optimizing SQL queries that filter on a time range","message":"Optimizing SQL queries that filter on a time range\n\nQueries filtering on date fields are slow as they have to parse each\nrow. There are sometimes millions of rows to parse while only a few\nthousands are necessary.\n\nThe following patch narrows data to process by filtering more on\nframe_model.begin as a firtst step using a `BETWEEN` statement instead\nof \u003e\u003d\n\nChange-Id: I8acbc8946d9e001419f7bf5064fcebe0a0ae907a\nDepends-On: Ia6908d13c91a02c47863ae6ac4b595ac98f9fd91\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/5b78886244ae659cf82b42c520b203dc3a825107"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/5b78886244ae659cf82b42c520b203dc3a825107"}]},"branch":"refs/heads/master"},"7d388b5ad3b2af56184c0b6ff69c0d648b6c3647":{"kind":"REWORK","_number":8,"created":"2022-12-05 13:38:16.000000000","uploader":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"ref":"refs/changes/17/865417/8","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/17/865417/8","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/8 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/8 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/8 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/8"}}},"commit":{"parents":[{"commit":"0c1eabc364999f02d42978c3dbac961f96eb893a","subject":"Validates the period compatibility of reprocessing dates","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/0c1eabc364999f02d42978c3dbac961f96eb893a"}]}],"author":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-11-23 11:36:04.000000000","tz":60},"committer":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-12-04 20:03:55.000000000","tz":60},"subject":"Optimizing SQL queries that filter on a time range","message":"Optimizing SQL queries that filter on a time range\n\nQueries filtering on date fields are slow as they have to parse each\nrow. There are sometimes millions of rows to parse while only a few\nthousands are necessary.\n\nThe following patch narrows data to process by filtering more on\nframe_model.begin as a firtst step using a `BETWEEN` statement instead\nof \u003e\u003d\n\nChange-Id: I8acbc8946d9e001419f7bf5064fcebe0a0ae907a\nDepends-On: Ia6908d13c91a02c47863ae6ac4b595ac98f9fd91\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/7d388b5ad3b2af56184c0b6ff69c0d648b6c3647"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/7d388b5ad3b2af56184c0b6ff69c0d648b6c3647"}]},"branch":"refs/heads/master"},"581fe3f2e9f6af440e2e2215f573f4c326ca9738":{"kind":"REWORK","_number":9,"created":"2022-12-06 09:26:51.000000000","uploader":{"_account_id":29422,"name":"Olivier Chaze","display_name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","username":"o.chaze"},"ref":"refs/changes/17/865417/9","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/17/865417/9","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/9 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/9 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/9 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/9"}}},"commit":{"parents":[{"commit":"0c1eabc364999f02d42978c3dbac961f96eb893a","subject":"Validates the period compatibility of reprocessing dates","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/0c1eabc364999f02d42978c3dbac961f96eb893a"}]}],"author":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-11-23 11:36:04.000000000","tz":60},"committer":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-12-04 22:26:05.000000000","tz":60},"subject":"Optimizing SQL queries that filter on a time range","message":"Optimizing SQL queries that filter on a time range\n\nQueries filtering on date fields are slow as they have to parse each\nrow. There are sometimes millions of rows to parse while only a few\nthousands are necessary.\n\nThe following patch narrows data to process by filtering more on\nframe_model.begin as a firtst step using a `BETWEEN` statement instead\nof \u003e\u003d\n\nChange-Id: I8acbc8946d9e001419f7bf5064fcebe0a0ae907a\nDepends-On: Ia6908d13c91a02c47863ae6ac4b595ac98f9fd91\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/581fe3f2e9f6af440e2e2215f573f4c326ca9738"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/581fe3f2e9f6af440e2e2215f573f4c326ca9738"}]},"branch":"refs/heads/master"},"10a9482a91ace68c081aa95ffb7fc394f688020c":{"kind":"REWORK","_number":10,"created":"2023-03-06 11:14:23.000000000","uploader":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"},"ref":"refs/changes/17/865417/10","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/cloudkitty","ref":"refs/changes/17/865417/10","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/10 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/10 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/10 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/cloudkitty refs/changes/17/865417/10"}}},"commit":{"parents":[{"commit":"0c1eabc364999f02d42978c3dbac961f96eb893a","subject":"Validates the period compatibility of reprocessing dates","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/0c1eabc364999f02d42978c3dbac961f96eb893a"}]}],"author":{"name":"Olivier Chaze","email":"olivier.chaze@infomaniak.com","date":"2022-11-23 11:36:04.000000000","tz":60},"committer":{"name":"Rafael Weingärtner","email":"rafael@apache.org","date":"2023-03-06 11:14:10.000000000","tz":-180},"subject":"Optimizing SQL queries that filter on a time range","message":"Optimizing SQL queries that filter on a time range\n\nQueries filtering on date fields are slow as they have to parse each\nrow. There are sometimes millions of rows to parse while only a few\nthousands are necessary.\n\nThe following patch narrows data to process by filtering more on\nframe_model.begin as a firtst step using a `BETWEEN` statement instead\nof \u003e\u003d\n\nChange-Id: I8acbc8946d9e001419f7bf5064fcebe0a0ae907a\nDepends-On: Ia6908d13c91a02c47863ae6ac4b595ac98f9fd91\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/10a9482a91ace68c081aa95ffb7fc394f688020c"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/cloudkitty/commit/10a9482a91ace68c081aa95ffb7fc394f688020c"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~DefaultSubmitRule","status":"CLOSED","labels":[{"label":"Verified","status":"MAY","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"MAY","applied_by":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"}},{"label":"Workflow","status":"MAY","applied_by":{"_account_id":28356,"name":"Rafael Weingartner","email":"rafael@apache.org","username":"rafaelweingartner"}},{"label":"Review-Priority","status":"MAY"}]}],"submit_requirements":[{"name":"Verified","description":"Verified in gate by CI","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Verified\u003dMAX AND -label:Verified\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Verified\u003dMAX"],"failing_atoms":["label:Verified\u003dMIN"],"atom_explanations":{}}},{"name":"Code-Review","description":"Code reviewed by core reviewer","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Code-Review\u003dMAX AND -label:Code-Review\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Code-Review\u003dMAX"],"failing_atoms":["label:Code-Review\u003dMIN"],"atom_explanations":{}}},{"name":"Review-Priority","description":"Review priority","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"-label:Review-Priority\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":[],"failing_atoms":["label:Review-Priority\u003dMIN"],"atom_explanations":{}}},{"name":"Workflow","description":"Approved for gate by core reviewer","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Workflow\u003dMAX AND -label:Workflow\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Workflow\u003dMAX"],"failing_atoms":["label:Workflow\u003dMIN"],"atom_explanations":{}}}]}