QUERY PLAN                                                                    
--------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop  (cost=17.59..573.18 rows=1 width=46) (actual time=0.194..1.052 rows=85 loops=1)
   Output: i.e, t.v, s.v
   Inner Unique: true
   Buffers: shared hit=532
   ->  Nested Loop  (cost=17.30..572.82 rows=1 width=39) (actual time=0.161..0.622 rows=85 loops=1)
         Output: i.e, t.v, t.e
         Inner Unique: true
         Buffers: shared hit=277
         ->  Nested Loop  (cost=17.01..572.45 rows=1 width=8) (actual time=0.125..0.188 rows=85 loops=1)
               Output: i.e
               Buffers: shared hit=22
               ->  Bitmap Heap Scan on eav.text email  (cost=16.59..565.96 rows=1 width=8) (actual time=0.074..0.123 rows=1 loops=1)
                     Output: email.e, email.a, email.v
                     Recheck Cond: (email.a = 1000)
                     Filter: (email.v = 'user100000@example.com'::text)
                     Rows Removed by Filter: 599
                     Heap Blocks: exact=11
                     Buffers: shared hit=18
                     ->  Bitmap Index Scan on eav_text_aevt  (cost=0.00..16.59 rows=573 width=0) (actual time=0.066..0.067 rows=600 loops=1)
                           Index Cond: (email.a = 1000)
                           Buffers: shared hit=7
               ->  Index Only Scan using eav_ref_vaet on eav.ref i  (cost=0.42..5.80 rows=69 width=16) (actual time=0.049..0.056 rows=85 loops=1)
                     Output: i.v, i.a, i.e
                     Index Cond: ((i.v = email.e) AND (i.a = 1005))
                     Heap Fetches: 0
                     Buffers: shared hit=4
         ->  Index Scan using text_pkey on eav.text t  (cost=0.29..0.37 rows=1 width=31) (actual time=0.005..0.005 rows=1 loops=85)
               Output: t.e, t.a, t.v
               Index Cond: ((t.e = i.e) AND (t.a = 1002))
               Buffers: shared hit=255
   ->  Index Scan using keyword_pkey on eav.keyword s  (cost=0.29..0.36 rows=1 width=23) (actual time=0.005..0.005 rows=1 loops=85)
         Output: s.e, s.a, s.v
         Index Cond: ((s.e = t.e) AND (s.a = 1003))
         Buffers: shared hit=255
 Planning:
   Buffers: shared hit=373
 Planning Time: 4.350 ms
 Execution Time: 1.164 ms
(38 rows)