Page MenuHomeSoftware Heritage
Paste P270

(An Untitled Masterwork)
ActivePublic

Authored by seirl on Jun 18 2018, 7:03 PM.
select *
from snapshot tablesample system (0.0002) repeatable (564)
inner join snapshot_branches on snapshot_branches.snapshot_id = snapshot.object_id
inner join snapshot_branch on snapshot_branch.object_id = snapshot_branches.branch_id

Event Timeline

                                                        QUERY PLAN                                                        
--------------------------------------------------------------------------------------------------------------------------
 Hash Join  (cost=7012248.05..31114369.73 rows=706244736 width=95)
   Hash Cond: (snapshot_branches.branch_id = snapshot_branch.object_id)
   ->  Nested Loop  (cost=0.57..1196682.49 rows=706244736 width=45)
         ->  Sample Scan on snapshot  (cost=0.00..3.11 rows=111 width=29)
               Sampling: system ('0.0002'::real) REPEATABLE ('564'::double precision)
         ->  Index Only Scan using snapshot_branches_pkey on snapshot_branches  (cost=0.57..10642.27 rows=13863 width=16)
               Index Cond: (snapshot_id = snapshot.object_id)
   ->  Hash  (cost=3422068.88..3422068.88 rows=161243088 width=50)
         ->  Seq Scan on snapshot_branch  (cost=0.00..3422068.88 rows=161243088 width=50)