QUERY PLAN                                                                            
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop  (cost=1.41..2459.29 rows=781 width=39) (actual time=0.254..22.387 rows=4041 loops=1)
   Output: s_1.e, t.v, p.v
   Inner Unique: true
   Buffers: shared hit=32065
   ->  Nested Loop  (cost=1.12..2099.94 rows=789 width=32) (actual time=0.218..16.090 rows=4041 loops=1)
         Output: s.e, p.v, p.e, s_1.e
         Inner Unique: true
         Buffers: shared hit=19942
         ->  Merge Join  (cost=0.83..1287.19 rows=1974 width=16) (actual time=0.159..4.518 rows=9859 loops=1)
               Output: s.e, s_1.e
               Inner Unique: true
               Merge Cond: (s.e = s_1.e)
               Buffers: shared hit=223
               ->  Index Only Scan using eav_keyword_vaet on eav.keyword s  (cost=0.41..609.13 rows=9836 width=8) (actual time=0.109..1.471 rows=9859 loops=1)
                     Output: s.v, s.a, s.e
                     Index Cond: ((s.v = ':state/open'::text) AND (s.a = 1003))
                     Heap Fetches: 0
                     Buffers: shared hit=113
               ->  Index Only Scan using eav_keyword_vaet on eav.keyword s_1  (cost=0.41..609.13 rows=9836 width=8) (actual time=0.048..1.129 rows=9859 loops=1)
                     Output: s_1.v, s_1.a, s_1.e
                     Index Cond: ((s_1.v = ':state/open'::text) AND (s_1.a = 1003))
                     Heap Fetches: 0
                     Buffers: shared hit=110
         ->  Index Only Scan using eav_long_aevt on eav.long p  (cost=0.29..0.41 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=9859)
               Output: p.a, p.e, p.v
               Index Cond: ((p.a = 1004) AND (p.e = s.e))
               Filter: (p.v >= 4)
               Rows Removed by Filter: 1
               Heap Fetches: 0
               Buffers: shared hit=19719
   ->  Index Scan using text_pkey on eav.text t  (cost=0.29..0.46 rows=1 width=31) (actual time=0.001..0.001 rows=1 loops=4041)
         Output: t.e, t.a, t.v
         Index Cond: ((t.e = p.e) AND (t.a = 1002))
         Buffers: shared hit=12123
 Planning:
   Buffers: shared hit=373
 Planning Time: 4.710 ms
 Execution Time: 22.643 ms
(38 rows)