SELECT t.id, 
       t.final_type_id, 
       t.author_id, 
       t.creator, 
       t.created_date, 
       t.updated_date, 
       t.updated_by_id, 
       t.media_type, 
       t.title, 
       t.date, 
       t.category_id, 
       t.topic_id, 
       t.annotation, 
       t.chars_number, 
       t.source_id, 
       t.original_id, 
       t.duplicates, 
       t.filling_rating, 
       t.attendance, 
       t.deleted, 
       t.artefact_hash, 
       core_source.id, 
       core_source.final_type_id, 
       core_source.name, 
       core_source.region, 
       core_source.attendance, 
       core_source.rating, 
       core_source.subtype 
FROM   (SELECT core_article.* 
        FROM   core_article 
        WHERE  core_article.deleted = false 
               AND core_article.media_type NOT IN (SELECT U0.slug 
                                                   FROM   core_mediatype U0 
                   INNER JOIN core_portal_unused_media_types 
                              U1 
                           ON ( U0.id = U1.mediatype_id ) 
                                                   WHERE  U1.portal_id = 19) 
               AND core_article.id IN (SELECT core_articlekeyword.article_id 
                                       FROM   core_articlekeyword 
                                       WHERE  core_articlekeyword.keyword_id IN 
                                              ( 
                                              141, 142, 143, 144, 
                                              145, 146, 147, 148, 
                                              149, 150, 151, 152, 
                                              153, 154, 155, 156, 
                                              157, 158, 160, 161, 
                                              162, 163, 264, 288, 365 )) 
               AND ( core_article.topic_id IS NULL 
                      OR core_article.topic_id IN (SELECT U0.id 
                                                   FROM   core_articletopic U0 
                         INNER JOIN core_portal_topics 
                                    U1 
                                 ON ( 
                         U0.id = U1.articletopic_id ) 
                                                   WHERE  U1.portal_id = 19) ) 
        ORDER  BY core_article.date DESC, 
                  core_article.created_date DESC 
        LIMIT  10) T 
       INNER JOIN core_source 
               ON ( T.source_id = core_source.id ) 
ORDER  BY T.date DESC, 
          T.created_date DESC; 

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop  (cost=69674.37..69749.34 rows=10 width=719) (actual time=1395.697..1395.807 rows=10 loops=1)
   ->  Limit  (cost=69674.09..69674.11 rows=10 width=1085) (actual time=1395.661..1395.686 rows=10 loops=1)
         ->  Sort  (cost=69674.09..69722.32 rows=19292 width=1085) (actual time=1395.656..1395.665 rows=10 loops=1)
               Sort Key: core_article.date, core_article.created_date
               Sort Method: top-N heapsort  Memory: 43kB
               ->  Hash Join  (cost=6383.54..69257.19 rows=19292 width=1085) (actual time=205.561..1324.690 rows=37031 loops=1)
                     Hash Cond: (core_article.id = core_articlekeyword.article_id)
                     ->  Seq Scan on core_article  (cost=5.62..61434.83 rows=116186 width=1085) (actual time=0.067..573.527 rows=229028 loops=1)
                           Filter: ((NOT deleted) AND (NOT (hashed SubPlan 1)) AND ((topic_id IS NULL) OR (hashed SubPlan 2)))
                           Rows Removed by Filter: 17834
                           SubPlan 1
                             ->  Nested Loop  (cost=0.00..2.17 rows=1 width=7) (actual time=0.012..0.012 rows=0 loops=1)
                                   Join Filter: (u0.id = u1.mediatype_id)
                                   ->  Seq Scan on core_portal_unused_media_types u1  (cost=0.00..1.04 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=1)
                                         Filter: (portal_id = 19)
                                         Rows Removed by Filter: 3
                                   ->  Seq Scan on core_mediatype u0  (cost=0.00..1.06 rows=6 width=11) (never executed)
                           SubPlan 2
                             ->  Nested Loop  (cost=0.00..3.44 rows=1 width=4) (actual time=0.032..0.102 rows=1 loops=1)
                                   Join Filter: (u0_1.id = u1_1.articletopic_id)
                                   Rows Removed by Join Filter: 36
                                   ->  Seq Scan on core_portal_topics u1_1  (cost=0.00..1.61 rows=1 width=4) (actual time=0.017..0.022 rows=1 loops=1)
                                         Filter: (portal_id = 19)
                                         Rows Removed by Filter: 53
                                   ->  Seq Scan on core_articletopic u0_1  (cost=0.00..1.37 rows=37 width=4) (actual time=0.007..0.037 rows=37 loops=1)
                     ->  Hash  (cost=6015.28..6015.28 rows=29011 width=4) (actual time=204.138..204.138 rows=37127 loops=1)
                           Buckets: 4096  Batches: 1  Memory Usage: 1306kB
                           ->  HashAggregate  (cost=5725.17..6015.28 rows=29011 width=4) (actual time=114.478..162.577 rows=37127 loops=1)
                                 ->  Bitmap Heap Scan on core_articlekeyword  (cost=886.40..5623.30 rows=40749 width=4) (actual time=7.923..55.754 rows=42349 loops=1)
                                       Recheck Cond: (keyword_id = ANY ('{141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,160,161,162,163,264,288,365}'::integer[]))
                                       ->  Bitmap Index Scan on core_articlekeyword_keyword_id  (cost=0.00..876.22 rows=40749 width=0) (actual time=7.567..7.567 rows=42361 loops=1)
                                             Index Cond: (keyword_id = ANY ('{141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,160,161,162,163,264,288,365}'::integer[]))
   ->  Index Scan using core_source_pkey on core_source  (cost=0.28..7.50 rows=1 width=60) (actual time=0.005..0.007 rows=1 loops=10)
         Index Cond: (id = core_article.source_id)
 Total runtime: 1396.328 ms
(35 rows)

ERROR:  data type timestamp with time zone has no default operator class for access method "gist"
HINT:  You must specify an operator class for the index or define a default operator class for the data type.