QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------
Nested Loop (cost=52.12..2128.08 rows=1 width=46) (actual time=0.261..1.981 rows=80 loops=1)
Output: i.e, t.v, s.v
Inner Unique: true
Buffers: shared hit=533 read=161
-> Nested Loop (cost=51.70..2127.58 rows=1 width=31) (actual time=0.221..1.223 rows=80 loops=1)
Output: i.e, s.v, s.e
Inner Unique: true
Buffers: shared hit=291 read=83
-> Nested Loop (cost=51.28..2127.12 rows=1 width=8) (actual time=0.141..0.663 rows=80 loops=1)
Output: i.e
Buffers: shared hit=133
-> Bitmap Heap Scan on eav.text email (cost=46.09..1854.19 rows=1 width=8) (actual time=0.114..0.348 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: 1999
Heap Blocks: exact=37
Buffers: shared hit=50
-> Bitmap Index Scan on eav_text_aevt (cost=0.00..46.09 rows=1823 width=0) (actual time=0.104..0.104 rows=2000 loops=1)
Index Cond: (email.a = 1000)
Buffers: shared hit=13
-> Bitmap Heap Scan on eav.ref i (cost=5.18..272.18 rows=74 width=16) (actual time=0.025..0.304 rows=80 loops=1)
Output: i.e, i.a, i.v
Recheck Cond: ((email.e = i.v) AND (i.a = 1005))
Heap Blocks: exact=80
Buffers: shared hit=83
-> Bitmap Index Scan on eav_ref_vaet (cost=0.00..5.17 rows=74 width=0) (actual time=0.016..0.016 rows=80 loops=1)
Index Cond: ((i.v = email.e) AND (i.a = 1005))
Buffers: shared hit=3
-> Index Only Scan using eav_keyword_aevt on eav.keyword s (cost=0.42..0.47 rows=1 width=23) (actual time=0.007..0.007 rows=1 loops=80)
Output: s.a, s.e, s.v
Index Cond: ((s.a = 1003) AND (s.e = i.e))
Heap Fetches: 0
Buffers: shared hit=158 read=83
-> Index Scan using text_pkey on eav.text t (cost=0.42..0.50 rows=1 width=31) (actual time=0.009..0.009 rows=1 loops=80)
Output: t.e, t.a, t.v
Index Cond: ((t.e = i.e) AND (t.a = 1002))
Buffers: shared hit=242 read=78
Planning:
Buffers: shared hit=380
Planning Time: 4.497 ms
Execution Time: 2.134 ms
(42 rows)
