SELECT DISTINCT "articles_article"."id","articles_article"."headline","articles_article"."slug","articles_article"."author_id","articles_article"."source_id","articles_article"."stage","articles_article"."summary","articles_article"."date","articles_article"."image_id","articles_article"."file","articles_article"."site_id","articles_article"."type_id","articles_article"."path","articles_article"."marker","articles_article"."old_id","articles_article"."old_wp_id" FROM "articles_article" INNER JOIN "articles_articletype" AS "articles_article__type" ON "articles_article"."type_id" = "articles_article__type"."id" LEFT OUTER JOIN "articles_article_tags" AS "m2m_articles_article__tags" ON "articles_article"."id" = "m2m_articles_article__tags"."article_id" WHERE (("articles_article"."stage" = 'P' AND "articles_article"."date" <= now() AND "articles_article__type"."cover" = True AND ("articles_article"."site_id" = 2 OR "m2m_articles_article__tags"."tag_id" IN (1,1,2,2,3,3)))) ORDER BY "articles_article"."date" DESC;


"Unique  (cost=21924.98..22511.68 rows=78227 width=12) (actual time=2109.462..2112.144 rows=595 loops=1)"
"  ->  Sort  (cost=21924.98..22120.55 rows=78227 width=12) (actual time=2109.455..2110.368 rows=1180 loops=1)"
"        Sort Key: articles_article.date, articles_article.id"
"        ->  Hash Left Join  (cost=350.09..14719.32 rows=78227 width=12) (actual time=83.888..2106.518 rows=1180 loops=1)"
"              Hash Cond: ("outer".id = "inner".article_id)"
"              Filter: (("outer".site_id = 2) OR ("inner".tag_id = 1) OR ("inner".tag_id = 1) OR ("inner".tag_id = 2) OR ("inner".tag_id = 2) OR ("inner".tag_id = 3) OR ("inner".tag_id = 3))"
"              ->  Hash Join  (cost=1.15..6480.33 rows=78227 width=16) (actual time=0.211..1437.220 rows=100928 loops=1)"
"                    Hash Cond: ("outer".type_id = "inner".id)"
"                    ->  Seq Scan on articles_article  (cost=0.00..5188.43 rows=101695 width=20) (actual time=0.137..1097.322 rows=101685 loops=1)"
"                          Filter: (((stage)::text = 'P'::text) AND (date <= now()))"
"                    ->  Hash  (cost=1.13..1.13 rows=10 width=4) (actual time=0.056..0.056 rows=10 loops=1)"
"                          ->  Seq Scan on articles_articletype articles_article__type  (cost=0.00..1.13 rows=10 width=4) (actual time=0.023..0.042 rows=10 loops=1)"
"                                Filter: cover"
"              ->  Hash  (cost=240.95..240.95 rows=15595 width=8) (actual time=74.800..74.800 rows=15608 loops=1)"
"                    ->  Seq Scan on articles_article_tags m2m_articles_article__tags  (cost=0.00..240.95 rows=15595 width=8) (actual time=0.026..32.991 rows=15608 loops=1)"
"Total runtime: 2112.767 ms"