QUERY PLAN                                                                                                                                                                                             
                                                                                                                          
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=34879.56..34879.57 rows=1 width=3) (actual time=17022.573..17022.580 rows=3 loops=1)
   ->  Sort  (cost=34879.56..34879.57 rows=1 width=3) (actual time=17022.571..17022.574 rows=3 loops=1)
         Sort Key: (CASE WHEN ((c.sg_status_list)::text = 'prjd'::text) THEN 0 WHEN ((c.sg_status_list)::text = 'awrd'::text) THEN 1 WHEN ((c.sg_status_list)::text = 'hld'::text) THEN 2 WHEN ((c.sg_status_list)::text = 'omt'::text) THEN 3 WHEN ((c.sg_stat
s_list)::text = 'ip'::text) THEN 4 WHEN ((c.sg_status_list)::text = 'cmpt'::text) THEN 5 WHEN ((c.sg_status_list)::text = 'app'::text) THEN 6 WHEN ((c.sg_status_list)::text = 'rdy'::text) THEN 7 WHEN ((c.sg_status_list)::text = 'wtg'::text) THEN 8 WHEN ((
.sg_status_list)::text = 'na'::text) THEN 9 WHEN ((c.sg_status_list)::text = 'del'::text) THEN 10 ELSE NULL::integer END)
         Sort Method:  quicksort  Memory: 25kB
         ->  HashAggregate  (cost=34879.51..34879.55 rows=1 width=3) (actual time=17022.539..17022.543 rows=3 loops=1)
               ->  Nested Loop Left Join  (cost=18104.25..34879.51 rows=1 width=3) (actual time=398.464..17021.967 rows=567 loops=1)
                     Join Filter: ((a.entity_type)::text = 'Asset'::text)
                     ->  Merge Join  (cost=18104.25..34877.66 rows=1 width=9) (actual time=398.406..17017.627 rows=567 loops=1)
                           Merge Cond: (b.entity_id = a.entity_id)
                           Join Filter: ((a.entity_type)::text = (b.entity_type)::text)
                           ->  Index Scan using dneg_dnc_entity_id on display_name_caches b  (cost=0.00..813687.84 rows=53661 width=13) (actual time=0.276..16814.529 rows=13178 loops=1)
                                 Filter: (lower((entity_derived_type)::text) = 'asset'::text)
                           ->  Sort  (cost=18104.25..18111.60 rows=2940 width=9) (actual time=184.779..185.317 rows=568 loops=1)
                                 Sort Key: a.entity_id
                                 Sort Method:  quicksort  Memory: 497kB
                                 ->  Seq Scan on tasks a  (cost=0.00..17934.88 rows=2940 width=9) (actual time=0.185..174.649 rows=6649 loops=1)
                                       Filter: ((task_template_id IS NULL) AND (retirement_date IS NULL) AND (project_id = 103) AND ((lower((sg_status_list)::text) = 'asd'::text) OR (lower((sg_status_list)::text) = 'asm'::text) OR (lower((sg_status_list):
text) = 'cmpt'::text) OR (lower((sg_status_list)::text) = 'ip'::text) OR (sg_status_list IS NULL) OR ((sg_status_list)::text = ''::text) OR (lower((sg_status_list)::text) = 'sch'::text)))
                     ->  Index Scan using assets_pkey on assets c  (cost=0.00..1.83 rows=1 width=7) (actual time=0.003..0.004 rows=1 loops=567)
                           Index Cond: (c.id = a.entity_id)
                           Filter: (c.retirement_date IS NULL)
 Total runtime: 17022.958 ms
(21 rows)