QUERY PLAN                                                                    
--------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop  (cost=6.78..193.40 rows=1 width=45) (actual time=0.201..0.733 rows=81 loops=1)
   Output: i.e, t.v, s.v
   Inner Unique: true
   Buffers: shared hit=419
   ->  Nested Loop  (cost=6.49..193.07 rows=1 width=38) (actual time=0.145..0.410 rows=81 loops=1)
         Output: i.e, t.v, t.e
         Inner Unique: true
         Buffers: shared hit=256
         ->  Nested Loop  (cost=6.20..192.71 rows=1 width=8) (actual time=0.111..0.140 rows=81 loops=1)
               Output: i.e
               Buffers: shared hit=13
               ->  Bitmap Heap Scan on eav.text email  (cost=5.79..186.40 rows=1 width=8) (actual time=0.061..0.077 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: 199
                     Heap Blocks: exact=4
                     Buffers: shared hit=9
                     ->  Bitmap Index Scan on eav_text_aevt  (cost=0.00..5.79 rows=200 width=0) (actual time=0.054..0.054 rows=200 loops=1)
                           Index Cond: (email.a = 1000)
                           Buffers: shared hit=5
               ->  Index Only Scan using eav_ref_vaet on eav.ref i  (cost=0.41..5.67 rows=63 width=16) (actual time=0.049..0.055 rows=81 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=30) (actual time=0.003..0.003 rows=1 loops=81)
               Output: t.e, t.a, t.v
               Index Cond: ((t.e = i.e) AND (t.a = 1002))
               Buffers: shared hit=243
   ->  Index Only Scan using eav_keyword_aevt on eav.keyword s  (cost=0.29..0.33 rows=1 width=23) (actual time=0.004..0.004 rows=1 loops=81)
         Output: s.a, s.e, s.v
         Index Cond: ((s.a = 1003) AND (s.e = t.e))
         Heap Fetches: 0
         Buffers: shared hit=163
 Planning:
   Buffers: shared hit=369
 Planning Time: 4.385 ms
 Execution Time: 0.838 ms
(39 rows)