explain_boguk

Update on authors  (cost=35264302.23..35268994.63 rows=181677 width=1207)
  CTE t1
    ->  Result  (cost=67.12..67.13 rows=1 width=8)
          InitPlan 1 (returns $0)
            ->  Limit  (cost=0.43..67.12 rows=1 width=8)
                  ->  Index Scan Backward using authors_moment_idx on authors authors_1  (cost=0.43..1764308.59 rows=26457 width=8)
                        Index Cond: (moment IS NOT NULL)
                        Filter: interesting
  CTE t2
    ->  GroupAggregate  (cost=0.57..25401348.02 rows=8595 width=19)
          Group Key: videos.author
          Filter: (count(*) >= 50)
          ->  Index Only Scan using videos_author_idx on videos  (cost=0.57..24523213.46 rows=175562448 width=19)
  CTE t3
    ->  HashAggregate  (cost=9862172.92..9862495.23 rows=8595 width=19)
          Group Key: videos_1.author
          Filter: (count(*) > 1)
          ->  Index Scan using videos_loaded_idx on videos videos_1  (cost=0.57..9827996.76 rows=6835232 width=19)
                Index Cond: (loaded IS NOT NULL)
  InitPlan 5 (returns $4)
    ->  CTE Scan on t1  (cost=0.00..0.02 rows=1 width=8)
  ->  Hash Join  (cost=391.83..5084.24 rows=181677 width=1207)
        Hash Cond: ((authors.user_id)::text = (t3.author)::text)
        ->  Nested Loop  (cost=193.94..1911.39 rows=363354 width=1182)
              ->  HashAggregate  (cost=193.39..195.39 rows=200 width=572)
                    Group Key: (t2.author)::text
                    ->  CTE Scan on t2  (cost=0.00..171.90 rows=8595 width=572)
              ->  Index Scan using authors_user_id_key on authors  (cost=0.56..8.57 rows=1 width=610)
                    Index Cond: ((user_id)::text = (t2.author)::text)
                    Filter: (videos AND (moment > $4))
        ->  Hash  (cost=195.39..195.39 rows=200 width=572)
              ->  HashAggregate  (cost=193.39..195.39 rows=200 width=572)
                    Group Key: (t3.author)::text
                    ->  CTE Scan on t3  (cost=0.00..171.90 rows=8595 width=572)