)]}'
{"id":"depot~13240","triplet_id":"depot~canon~I5a1929bd9c81ea0031e512d01897c0e460ded077","project":"depot","branch":"canon","hashtags":[],"change_id":"I5a1929bd9c81ea0031e512d01897c0e460ded077","subject":"fix(users/Profpatsch/whatcd-resolver): speed up artist_ids lookups","status":"MERGED","created":"2025-03-10 16:50:13.000000000","updated":"2025-03-10 16:55:15.000000000","submitted":"2025-03-10 16:55:15.000000000","submitter":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"13240","meta_rev_id":"948ea8abfa00752798112ab51abaf164ebe38e8b","_number":13240,"virtual_id_number":13240,"owner":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"actions":{},"labels":{"Code-Review":{"approved":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"all":[{"value":0,"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},{"tag":"autogenerated:gerrit:merged","value":2,"date":"2025-03-10 16:55:15.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}],"values":{"-2":"This shall not be merged","-1":"I would prefer this is not merged as is"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me, approved"},"description":"","default_value":0},"Verified":{"approved":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:gerrit:merged","value":1,"date":"2025-03-10 16:55:15.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},{"value":0,"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}],"values":{"-1":"Fails"," 0":"No score","+1":"Verified"},"description":"","default_value":0},"Autosubmit":{"all":[{"value":0,"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},{"value":0,"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}],"values":{" 0":"Submit manually","+1":"Submit automatically"},"description":"","default_value":0,"optional":true},"All-Comments-Resolved":{"approved":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"all":[{"value":0,"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},{"value":0,"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}]},"Conformant-Commit-Message":{"approved":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"all":[{"value":0,"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},{"value":0,"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}]}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2025-03-10 16:50:15.000000000","updated_by":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"reviewer":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"state":"CC"},{"updated":"2025-03-10 16:54:09.000000000","updated_by":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"reviewer":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"state":"REVIEWER"}],"messages":[{"id":"5c963b27a416aba819b3436f4d2afb12c51297e6","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"date":"2025-03-10 16:50:13.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"25b28a358ef7835191cf866810383a46f721bbf7","tag":"autogenerated:buildkite~trigger","author":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"date":"2025-03-10 16:50:15.000000000","message":"Patch Set 1:\n\nStarted build for patchset #1 on: https://buildkite.com/tvl/depot/builds/38937","accounts_in_message":[],"_revision_number":1},{"id":"dc94ad4ac79b32974f7c3a0b174d420294483cfb","author":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"date":"2025-03-10 16:52:40.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"ded67b0634bd137aa528661cd0afda32bbab1e44","tag":"autogenerated:buildkite~result","author":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"date":"2025-03-10 16:54:09.000000000","message":"Patch Set 1: Verified+1\n\nBuild of patchset 1 passed: https://buildkite.com/tvl/depot/builds/38937","accounts_in_message":[],"_revision_number":1},{"id":"948ea8abfa00752798112ab51abaf164ebe38e8b","tag":"autogenerated:gerrit:merged","author":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"date":"2025-03-10 16:55:15.000000000","message":"Change has been successfully rebased and submitted as cb5a74523339dc796584dc68b7ebc2c33e01056f","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"cb5a74523339dc796584dc68b7ebc2c33e01056f","revisions":{"78371ba395d79fecded2bd211986d9a5fea8ca23":{"kind":"REWORK","_number":1,"created":"2025-03-10 16:50:13.000000000","uploader":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"ref":"refs/changes/40/13240/1","fetch":{"anonymous http":{"url":"https://cl.tvl.fyi/depot","ref":"refs/changes/40/13240/1","commands":{"Checkout":"git fetch https://cl.tvl.fyi/depot refs/changes/40/13240/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://cl.tvl.fyi/depot refs/changes/40/13240/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://cl.tvl.fyi/depot refs/changes/40/13240/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://cl.tvl.fyi/depot refs/changes/40/13240/1"}}},"commit":{"parents":[{"commit":"0088d195d76887190c83abd41aa1641ca83fda7b","subject":"fix(users/Profpatsch/whatcd-resolver): speed up artistName query","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d0088d195d76887190c83abd41aa1641ca83fda7b"}]}],"author":{"name":"Profpatsch","email":"mail@profpatsch.de","date":"2025-03-10 16:47:36.000000000","tz":60},"committer":{"name":"Profpatsch","email":"mail@profpatsch.de","date":"2025-03-10 16:47:36.000000000","tz":60},"subject":"fix(users/Profpatsch/whatcd-resolver): speed up artist_ids lookups","message":"fix(users/Profpatsch/whatcd-resolver): speed up artist_ids lookups\n\nWe need `artist_ids` in most of the queries, so let’s make them a\ngenerated column and put an index on them.\n\nThis reduces times for getArtistNameById from ~300ms to ~20ms and for\nthe main “latest” table from ~250ms to ~60ms.\n\nThe `artist_has_been_snatched` logic moves into the torrent filter, so\nwe don’t have to work on such large records further down.\n\nChange-Id: I5a1929bd9c81ea0031e512d01897c0e460ded077\n","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d78371ba395d79fecded2bd211986d9a5fea8ca23"}],"resolve_conflicts_web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d78371ba395d79fecded2bd211986d9a5fea8ca23"}]},"parents_data":[{"branch_name":"refs/heads/canon","commit_id":"0088d195d76887190c83abd41aa1641ca83fda7b","is_merged_in_target_branch":false,"change_id":"I28f6546353e2930156eaeb427ba5122559aea49b","change_number":13239,"patch_set_number":1,"change_status":"MERGED"}],"branch":"refs/heads/canon"},"cb5a74523339dc796584dc68b7ebc2c33e01056f":{"kind":"REWORK","_number":2,"created":"2025-03-10 16:55:15.000000000","uploader":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"ref":"refs/changes/40/13240/2","fetch":{"anonymous http":{"url":"https://cl.tvl.fyi/depot","ref":"refs/changes/40/13240/2","commands":{"Checkout":"git fetch https://cl.tvl.fyi/depot refs/changes/40/13240/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://cl.tvl.fyi/depot refs/changes/40/13240/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://cl.tvl.fyi/depot refs/changes/40/13240/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://cl.tvl.fyi/depot refs/changes/40/13240/2"}}},"commit":{"parents":[{"commit":"5efe6cefe81951649923e6179a095f5f8ec22105","subject":"fix(users/Profpatsch/whatcd-resolver): speed up artistName query","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d5efe6cefe81951649923e6179a095f5f8ec22105"}]}],"author":{"name":"Profpatsch","email":"mail@profpatsch.de","date":"2025-03-10 16:47:36.000000000","tz":60},"committer":{"name":"Profpatsch","email":"mail@profpatsch.de","date":"2025-03-10 16:55:15.000000000","tz":0},"subject":"fix(users/Profpatsch/whatcd-resolver): speed up artist_ids lookups","message":"fix(users/Profpatsch/whatcd-resolver): speed up artist_ids lookups\n\nWe need `artist_ids` in most of the queries, so let’s make them a\ngenerated column and put an index on them.\n\nThis reduces times for getArtistNameById from ~300ms to ~20ms and for\nthe main “latest” table from ~250ms to ~60ms.\n\nThe `artist_has_been_snatched` logic moves into the torrent filter, so\nwe don’t have to work on such large records further down.\n\nChange-Id: I5a1929bd9c81ea0031e512d01897c0e460ded077\nReviewed-on: https://cl.tvl.fyi/c/depot/+/13240\nTested-by: BuildkiteCI\nReviewed-by: Profpatsch \u003cmail@profpatsch.de\u003e\n","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003dcb5a74523339dc796584dc68b7ebc2c33e01056f"}],"resolve_conflicts_web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003dcb5a74523339dc796584dc68b7ebc2c33e01056f"}]},"parents_data":[{"branch_name":"refs/heads/canon","commit_id":"5efe6cefe81951649923e6179a095f5f8ec22105","is_merged_in_target_branch":true,"change_id":"I28f6546353e2930156eaeb427ba5122559aea49b","change_number":13239,"patch_set_number":2,"change_status":"MERGED"}],"branch":"refs/heads/canon","description":"Rebase"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~PrologRule","status":"CLOSED","labels":[{"label":"Autosubmit","status":"MAY"},{"label":"Conformant-Commit-Message","status":"OK","applied_by":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}},{"label":"All-Comments-Resolved","status":"OK","applied_by":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}},{"label":"Verified","status":"OK","applied_by":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"OK","applied_by":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}}]},{"rule_name":"Code-Owners","status":"CLOSED"}],"submit_requirements":[{"name":"All-Comments-Resolved","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:All-Comments-Resolved\u003dgerrit~PrologRule","fulfilled":true,"status":"PASS","passing_atoms":["label:All-Comments-Resolved\u003dgerrit~PrologRule"],"failing_atoms":[]}},{"name":"Verified","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Verified\u003dgerrit~PrologRule","fulfilled":true,"status":"PASS","passing_atoms":["label:Verified\u003dgerrit~PrologRule"],"failing_atoms":[]}},{"name":"Code-Owners","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"rule:Code-Owners","fulfilled":true,"status":"PASS","passing_atoms":["Code-Owners"],"failing_atoms":[]}},{"name":"Conformant-Commit-Message","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Conformant-Commit-Message\u003dgerrit~PrologRule","fulfilled":true,"status":"PASS","passing_atoms":["label:Conformant-Commit-Message\u003dgerrit~PrologRule"],"failing_atoms":[]}},{"name":"Code-Review","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Code-Review\u003dgerrit~PrologRule","fulfilled":true,"status":"PASS","passing_atoms":["label:Code-Review\u003dgerrit~PrologRule"],"failing_atoms":[]}}]}