int_array_enum

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
102.203 100.00% 
 Nested Loop (cost=3721.77..3728.07 rows=1 width=16) (actual time=102.031..102.203 rows=21 loops=1)
102.042 99.84% 
   -> Unique (cost=3721.77..3721.78 rows=1 width=32) (actual time=102.004..102.042 rows=22 loops=1)
102.013 99.81% 
         -> Sort (cost=3721.77..3721.77 rows=1 width=32) (actual time=102.002..102.013 rows=22 loops=1)
               Sort Key: int_array_enum(a.fac_ids)
101.940 99.74% 
               -> Subquery Scan a (cost=3721.74..3721.76 rows=1 width=32) (actual time=101.915..101.940 rows=22 loops=1)
101.891 99.69% 
                     -> Aggregate (cost=3721.74..3721.75 rows=1 width=104) (actual time=101.890..101.891 rows=1 loops=1)
101.283 99.10% 
                           -> Nested Loop (cost=0.0..3721.38 rows=141 width=104) (actual time=94.156..101.283 rows=141 loops=1)
94.289 92.26% 
                                 -> Seq Scan on point_features (cost=0.0..2921.76 rows=141 width=4) (actual time=94.050..94.289 rows=141 loops=1)
                                       Filter: (featureid = 451)
6.486 6.35% 
                                 -> Index Scan using entity_pkey on entity (cost=0.0..5.66 rows=1 width=108) (actual time=0.045..0.046 rows=1 loops=141)
                                       Index Cond: (entity.entity_id = point_features.entity_id)
0.088 0.09% 
   -> Index Scan using facet_lookup_pkey on facet_lookup (cost=0.0..6.27 rows=1 width=20) (actual time=0.003..0.004 rows=1 loops=22)
         Index Cond: (a.fac_id = facet_lookup.fac_id)
Run-time
0.102402 seconds (102.402 ms)