Page MenuHomeSoftware Heritage
Paste P702

(An Untitled Masterwork)
ActivePublic

Authored by vlorentz on Jun 19 2020, 4:50 PM.
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)