int_array_enum2

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
756.769 100.00% 
 Hash Join (cost=25918.99..25919.8 rows=1 width=16) (actual time=756.706..756.769 rows=21 loops=1)
   Hash Cond: (a.fac_id = facet_lookup.fac_id)
755.889 99.88% 
   -> Unique (cost=25909.75..25909.76 rows=1 width=32) (actual time=755.852..755.889 rows=22 loops=1)
755.856 99.88% 
         -> Sort (cost=25909.75..25909.76 rows=1 width=32) (actual time=755.848..755.856 rows=22 loops=1)
               Sort Key: int_array_enum(a.fac_ids)
755.808 99.87% 
               -> Subquery Scan a (cost=25909.72..25909.74 rows=1 width=32) (actual time=755.782..755.808 rows=22 loops=1)
755.755 99.87% 
                     -> Aggregate (cost=25909.72..25909.73 rows=1 width=104) (actual time=755.755..755.755 rows=1 loops=1)
753.757 99.60% 
                           -> Hash Join (cost=2922.11..25909.37 rows=141 width=104) (actual time=75.195..753.757 rows=141 loops=1)
                                 Hash Cond: (entity.entity_id = point_features.entity_id)
600.913 79.41% 
                                 -> Seq Scan on entity (cost=0.0..22376.56 rows=121856 width=108) (actual time=0.095..600.913 rows=121935 loops=1)
70.564 9.32% 
                                 -> Hash (cost=2921.76..2921.76 rows=141 width=4) (actual time=70.564..70.564 rows=141 loops=1)
70.442 9.31% 
                                       -> Seq Scan on point_features (cost=0.0..2921.76 rows=141 width=4) (actual time=70.257..70.442 rows=141 loops=1)
                                             Filter: (featureid = 451)
0.824 0.11% 
   -> Hash (cost=8.19..8.19 rows=419 width=20) (actual time=0.824..0.824 rows=343 loops=1)
0.389 0.05% 
         -> Seq Scan on facet_lookup (cost=0.0..8.19 rows=419 width=20) (actual time=0.062..0.389 rows=343 loops=1)
Run-time
0.756953 seconds (756.953 ms)