)]}'
{
  "commit": "a91fe9b1fa24fa002aea030856f6c9547dabdadf",
  "tree": "e4fe6633a4484c6a012fa133628b167e1a76635f",
  "parents": [
    "60f2040a8ef4514df1b419293928dd29c4b43b2b"
  ],
  "author": {
    "name": "Lalit Maganti",
    "email": "lalitm@google.com",
    "time": "Fri Aug 14 11:57:04 2026 +0100"
  },
  "committer": {
    "name": "Lalit Maganti",
    "email": "lalitm@google.com",
    "time": "Fri Aug 14 12:12:18 2026 +0100"
  },
  "message": "tp: speed up SQLite joins on ID columns\n\nOptimize joins that constrain a table by ID, optionally followed by\nadditional equality predicates. These joins now avoid materializing\nintermediate ranges and allocating index storage for zero-or-one-row\nresults.\n\nAlso reduce repeated SQLite virtual-table filtering overhead.\n",
  "tree_diff": [
    {
      "type": "modify",
      "old_id": "90f43d4e48ebc8a52e498c2815e5603a20b55c4e",
      "old_mode": 33188,
      "old_path": "Android.bp",
      "new_id": "c2f57eec40c3481eb9ee6dbec36aedcf70b22fd3",
      "new_mode": 33188,
      "new_path": "Android.bp"
    },
    {
      "type": "modify",
      "old_id": "fbfe3ebeb0b56dd81b1246e4065815fac32ac6cd",
      "old_mode": 33188,
      "old_path": "BUILD",
      "new_id": "81b56a2a3cac78b3b8560951fff53203e5fe04ae",
      "new_mode": 33188,
      "new_path": "BUILD"
    },
    {
      "type": "modify",
      "old_id": "d0767784111eb4a3a8b3949c46edc8a5ab313530",
      "old_mode": 33188,
      "old_path": "CHANGELOG",
      "new_id": "bec02cc14f3e09b443df61e658a940758160a36a",
      "new_mode": 33188,
      "new_path": "CHANGELOG"
    },
    {
      "type": "modify",
      "old_id": "999cfa2488a92db3f05374acfbbfcf2ba396b6cd",
      "old_mode": 33188,
      "old_path": "src/trace_processor/core/dataframe/cursor.h",
      "new_id": "499c05c8efbcd3302c42674f23299524edfdd16f",
      "new_mode": 33188,
      "new_path": "src/trace_processor/core/dataframe/cursor.h"
    },
    {
      "type": "modify",
      "old_id": "221d0e1d769b21acc95bfd12f28eb998a6e887b0",
      "old_mode": 33188,
      "old_path": "src/trace_processor/core/dataframe/cursor_impl.h",
      "new_id": "c4d7210a1634fd71a42caef894777f24c663d639",
      "new_mode": 33188,
      "new_path": "src/trace_processor/core/dataframe/cursor_impl.h"
    },
    {
      "type": "modify",
      "old_id": "0a01da9f81ec38ab40dd00b6949b33e41072e3a4",
      "old_mode": 33188,
      "old_path": "src/trace_processor/core/dataframe/dataframe_unittest.cc",
      "new_id": "d19b1c3b9308e18a51340ce0c042938e198a0556",
      "new_mode": 33188,
      "new_path": "src/trace_processor/core/dataframe/dataframe_unittest.cc"
    },
    {
      "type": "modify",
      "old_id": "aae03b3cb113261272cd2285eab36c15684a8f1c",
      "old_mode": 33188,
      "old_path": "src/trace_processor/core/dataframe/query_plan.cc",
      "new_id": "8335f60f4b42776f8e136da9170411de9a1db081",
      "new_mode": 33188,
      "new_path": "src/trace_processor/core/dataframe/query_plan.cc"
    },
    {
      "type": "modify",
      "old_id": "938393b1471c7a357e4666f5cd76572392a89dd7",
      "old_mode": 33188,
      "old_path": "src/trace_processor/core/interpreter/BUILD.gn",
      "new_id": "2dbf0a25d6791e489401b482ee90b03911bdeba6",
      "new_mode": 33188,
      "new_path": "src/trace_processor/core/interpreter/BUILD.gn"
    },
    {
      "type": "modify",
      "old_id": "8944d4e4f4eace0ba74a71db7f3366bfc77cde7b",
      "old_mode": 33188,
      "old_path": "src/trace_processor/core/interpreter/bytecode_instructions.h",
      "new_id": "b80c22a099889e0efd6cc3ddf578c590ffe20ea3",
      "new_mode": 33188,
      "new_path": "src/trace_processor/core/interpreter/bytecode_instructions.h"
    },
    {
      "type": "modify",
      "old_id": "137dfa782642b4a56564193d145847c8f43b45c4",
      "old_mode": 33188,
      "old_path": "src/trace_processor/core/interpreter/bytecode_interpreter.h",
      "new_id": "64aad5044c36b09de66273c1f19f947b61d0c7ee",
      "new_mode": 33188,
      "new_path": "src/trace_processor/core/interpreter/bytecode_interpreter.h"
    },
    {
      "type": "modify",
      "old_id": "afd18959943138141c6dc273c348f57297f69bc7",
      "old_mode": 33188,
      "old_path": "src/trace_processor/core/interpreter/bytecode_interpreter_impl.h",
      "new_id": "e3751461bf6822a2c98f423d8f5176d5494ccff2",
      "new_mode": 33188,
      "new_path": "src/trace_processor/core/interpreter/bytecode_interpreter_impl.h"
    },
    {
      "type": "modify",
      "old_id": "a6c16b560a9c6d26afed597ce3bae69a9efb03fe",
      "old_mode": 33188,
      "old_path": "src/trace_processor/core/interpreter/bytecode_interpreter_state.h",
      "new_id": "cf12bb3ab7ef7e61761f3b198416a2258f254193",
      "new_mode": 33188,
      "new_path": "src/trace_processor/core/interpreter/bytecode_interpreter_state.h"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "018fd12aeef5718e2d71da7f9a602cfe521b3f65",
      "new_mode": 33188,
      "new_path": "src/trace_processor/core/interpreter/bytecode_optimizer.cc"
    },
    {
      "type": "add",
      "old_id": "0000000000000000000000000000000000000000",
      "old_mode": 0,
      "old_path": "/dev/null",
      "new_id": "9ad03a013774604b5186a4eca4dad94cf0b9c3a8",
      "new_mode": 33188,
      "new_path": "src/trace_processor/core/interpreter/bytecode_optimizer.h"
    },
    {
      "type": "modify",
      "old_id": "0a218684e8261565c89ea08eb9ff189661119558",
      "old_mode": 33188,
      "old_path": "src/trace_processor/perfetto_sql/engine/dataframe_module.cc",
      "new_id": "faae877611ab09f8236985eb6c2689323da68442",
      "new_mode": 33188,
      "new_path": "src/trace_processor/perfetto_sql/engine/dataframe_module.cc"
    },
    {
      "type": "modify",
      "old_id": "3c5c0dc1a50781ff3e351311ca6ed3c94648dbd8",
      "old_mode": 33188,
      "old_path": "src/trace_processor/perfetto_sql/engine/dataframe_module.h",
      "new_id": "3dff822cb479f16c4d3c65fed312f4dc5873df28",
      "new_mode": 33188,
      "new_path": "src/trace_processor/perfetto_sql/engine/dataframe_module.h"
    },
    {
      "type": "modify",
      "old_id": "e1e2d4b0c7cd7dc6f2d62662ce4c828d6280eff8",
      "old_mode": 33188,
      "old_path": "src/trace_processor/perfetto_sql/engine/perfetto_sql_connection_benchmark.cc",
      "new_id": "04cb49ca228a74fa26b7e1561168406c674106fd",
      "new_mode": 33188,
      "new_path": "src/trace_processor/perfetto_sql/engine/perfetto_sql_connection_benchmark.cc"
    },
    {
      "type": "modify",
      "old_id": "36a16a2e19719be1912723cad88bf004e4b32ae8",
      "old_mode": 33188,
      "old_path": "src/trace_processor/perfetto_sql/engine/perfetto_sql_connection_unittest.cc",
      "new_id": "1f1213ef47339a3d474f9dd86153cd492423bdf7",
      "new_mode": 33188,
      "new_path": "src/trace_processor/perfetto_sql/engine/perfetto_sql_connection_unittest.cc"
    }
  ]
}