explain

Update on authors  (cost=67.55..20683002928.29 rows=181677 width=611)
  InitPlan 2 (returns $1)
    ->  Result  (cost=67.11..67.12 rows=1 width=8)
          InitPlan 1 (returns $0)
            ->  Limit  (cost=0.43..67.11 rows=1 width=8)
                  ->  Index Scan Backward using authors_moment_idx on authors authors_1  (cost=0.43..1764284.59 rows=26457 width=8)
                        Index Cond: (moment IS NOT NULL)
                        Filter: interesting
  ->  Index Scan using authors_check_new on authors  (cost=0.43..20683002861.17 rows=181677 width=611)
        Index Cond: ((videos = true) AND (moment > $1))
        Filter: (videos AND (SubPlan 3) AND (SubPlan 4))
        SubPlan 3
          ->  Aggregate  (cost=1080.48..1080.50 rows=1 width=32)
                Filter: (count(*) >= 50)
                ->  Index Only Scan using videos_author_idx on videos  (cost=0.57..1063.46 rows=6809 width=0)
                      Index Cond: (author = (authors.user_id)::text)
        SubPlan 4
          ->  Aggregate  (cost=27378.13..27378.14 rows=1 width=32)
                Filter: (count(*) > 1)
                ->  Bitmap Heap Scan on videos videos_1  (cost=399.70..27377.47 rows=265 width=0)
                      Recheck Cond: ((author)::text = (authors.user_id)::text)
                      Filter: (loaded IS NOT NULL)
                      ->  Bitmap Index Scan on videos_author_idx  (cost=0.00..399.64 rows=6809 width=0)
                            Index Cond: ((author)::text = (authors.user_id)::text)