Event Timeline
Comment Actions
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)