softwareheritage=> explain select * from snapshot_branches inner join snapshot_branch on (snapshot_branches.branch_id=snapshot_branch.object_id) where name >= 'gggg' and snapshot_id=110650857 order by name limit 1000;
                                                                  QUERY PLAN                                                                  
----------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=93915.87..94032.54 rows=1000 width=67)
   ->  Gather Merge  (cost=93915.87..97631.26 rows=31844 width=67)
         Workers Planned: 2
         ->  Sort  (cost=92915.84..92955.65 rows=15922 width=67)
               Sort Key: snapshot_branch.name
               ->  Nested Loop  (cost=1.15..92042.86 rows=15922 width=67)
                     ->  Parallel Index Only Scan using snapshot_branches_pkey on snapshot_branches  (cost=0.58..5186.90 rows=19196 width=16)
                           Index Cond: (snapshot_id = 110650857)
                     ->  Index Scan using snapshot_branch_pkey on snapshot_branch  (cost=0.57..4.52 rows=1 width=51)
                           Index Cond: (object_id = snapshot_branches.branch_id)
                           Filter: (name >= '\x67676767'::bytea)