Untitled

EXPLAIN ANALYZE SELECT "reports_site"."slug","reports_site"."name" FROM "reports_report" INNER JOIN "reports_aspect" AS "reports_report__aspect" ON "reports_report"."aspect_id" = "reports_report__aspect"."id" , "reports_site" WHERE reports_site.id=reports_report.site_id AND ((("reports_report__aspect"."slug" = 'txpower')))  GROUP BY "reports_site"."slug","reports_site"."name";

                                                                      QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------
 HashAggregate  (cost=13272.45..13272.45 rows=33 width=25) (actual time=1556.508..1556.559 rows=33 loops=1)
   ->  Hash Join  (cost=2.60..13155.87 rows=23316 width=25) (actual time=0.499..1278.358 rows=35003 loops=1)
         Hash Cond: ("outer".site_id = "inner".id)
         ->  Hash Join  (cost=1.19..12746.42 rows=23316 width=4) (actual time=0.270..1130.558 rows=35003 loops=1)
               Hash Cond: ("outer".aspect_id = "inner".id)
               ->  Seq Scan on reports_report  (cost=0.00..10763.38 rows=349738 width=8) (actual time=0.060..805.790 rows=349738 loops=1)
               ->  Hash  (cost=1.19..1.19 rows=1 width=4) (actual time=0.113..0.113 rows=0 loops=1)
                     ->  Seq Scan on reports_aspect reports_report__aspect  (cost=0.00..1.19 rows=1 width=4) (actual time=0.099..0.105 rows=1 loops=1)
                           Filter: ((slug)::text = 'txpower'::text)
         ->  Hash  (cost=1.33..1.33 rows=33 width=29) (actual time=0.205..0.205 rows=0 loops=1)
               ->  Seq Scan on reports_site  (cost=0.00..1.33 rows=33 width=29) (actual time=0.098..0.163 rows=33 loops=1)
 Total runtime: 1556.768 ms
(12 rows)