explain analyze SELECT
    COUNT(*)
FROM
    "tubesite_video"
    INNER JOIN "tubesite_object"
        ON ("tubesite_video"."object_ptr_id" = "tubesite_object"."id")
    INNER JOIN "tubesite_objectmeta"
        ON ("tubesite_object"."objectmeta_id" = "tubesite_objectmeta"."id")
    INNER JOIN "tubesite_videometa"
        ON ("tubesite_objectmeta"."id" = "tubesite_videometa"."objectmeta_ptr_id")
    INNER JOIN "tubesite_objectmeta_categories"
        ON ("tubesite_objectmeta"."id" = "tubesite_objectmeta_categories"."objectmeta_id")
    INNER JOIN "tubesite_category"
        ON ("tubesite_objectmeta_categories"."category_id" = "tubesite_category"."id")
WHERE
    ("tubesite_object"."site_id" = 8
    AND "tubesite_videometa"."import_status" = E'ready'
    AND "tubesite_objectmeta"."visibility" = E'site'
    AND UPPER("tubesite_category"."name"::text) = UPPER(E'hardcore')
    AND "tubesite_objectmeta"."removal_status" = E'Active'
    AND NOT ("tubesite_objectmeta"."approval_state" = E'flagged_as_inappropriate' ))


Aggregate  (cost=11656.98..11656.99 rows=1 width=0) (actual time=41799.438..41799.438 rows=1 loops=1)
  ->  Nested Loop  (cost=16.10..11655.74 rows=494 width=0) (actual time=133.067..41797.749 rows=3867 loops=1)
        ->  Nested Loop  (cost=16.10..8878.40 rows=495 width=4) (actual time=133.053..40745.530 rows=3867 loops=1)
              ->  Nested Loop  (cost=16.10..897.77 rows=297 width=12) (actual time=61.185..2123.908 rows=7495 loops=1)
                    ->  Nested Loop  (cost=16.10..610.96 rows=486 width=8) (actual time=61.162..1073.007 rows=7498 loops=1)
                          ->  Nested Loop  (cost=16.10..401.38 rows=495 width=4) (actual time=61.134..87.780 rows=7532 loops=1)
                                ->  Seq Scan on tubesite_category  (cost=0.00..2.79 rows=1 width=4) (actual time=0.248..0.387 rows=1 loops=1)
                                      Filter: (upper((name)::text) = 'HARDCORE'::text)
                                ->  Bitmap Heap Scan on tubesite_objectmeta_categories  (cost=16.10..392.41 rows=495 width=8) (actual time=60.882..84.156 rows=7532 loops=1)
                                      Recheck Cond: (tubesite_objectmeta_categories.category_id = tubesite_category.id)
                                      ->  Bitmap Index Scan on tubesite_objectmeta_categories_category_id  (cost=0.00..15.97 rows=495 width=0) (actual time=60.832..60.832 rows=7532 loops=1)
                                            Index Cond: (tubesite_objectmeta_categories.category_id = tubesite_category.id)
                          ->  Index Scan using tubesite_videometa_pkey on tubesite_videometa  (cost=0.00..0.41 rows=1 width=4) (actual time=0.124..0.126 rows=1 loops=7532)
                                Index Cond: (tubesite_videometa.objectmeta_ptr_id = tubesite_objectmeta_categories.objectmeta_id)
                                Filter: ((tubesite_videometa.import_status)::text = 'ready'::text)
                    ->  Index Scan using tubesite_objectmeta_pkey on tubesite_objectmeta  (cost=0.00..0.58 rows=1 width=4) (actual time=0.131..0.132 rows=1 loops=7498)
                          Index Cond: (tubesite_objectmeta.id = tubesite_videometa.objectmeta_ptr_id)
                          Filter: (((tubesite_objectmeta.approval_state)::text <> 'flagged_as_inappropriate'::text) AND ((tubesite_objectmeta.visibility)::text = 'site'::text) AND ((tubesite_objectmeta.removal_status)::text = 'Active'::text))
              ->  Index Scan using tubesite_object_objectmeta_id on tubesite_object  (cost=0.00..26.86 rows=1 width=8) (actual time=2.546..5.148 rows=1 loops=7495)
                    Index Cond: (tubesite_object.objectmeta_id = tubesite_objectmeta.id)
                    Filter: (tubesite_object.site_id = 8)
        ->  Index Scan using tubesite_video_pkey on tubesite_video  (cost=0.00..5.60 rows=1 width=4) (actual time=0.241..0.241 rows=1 loops=3867)
              Index Cond: (tubesite_video.object_ptr_id = tubesite_object.id)
Total runtime: 41799.632 ms