QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Nested Loop (cost=1.14..819.45 rows=262 width=38) (actual time=0.248..7.144 rows=1313 loops=1)
Output: s_1.e, t.v, p.v
Inner Unique: true
Buffers: shared hit=10561
-> Nested Loop (cost=0.86..698.46 rows=266 width=32) (actual time=0.213..5.290 rows=1313 loops=1)
Output: s.e, p.v, p.e, s_1.e
Inner Unique: true
Buffers: shared hit=6622
-> Merge Join (cost=0.57..426.50 rows=669 width=16) (actual time=0.151..1.576 rows=3272 loops=1)
Output: s.e, s_1.e
Inner Unique: true
Merge Cond: (s.e = s_1.e)
Buffers: shared hit=77
-> Index Only Scan using eav_keyword_vaet on eav.keyword s (cost=0.29..201.72 rows=3272 width=8) (actual time=0.102..0.534 rows=3272 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=40
-> Index Only Scan using eav_keyword_vaet on eav.keyword s_1 (cost=0.29..201.72 rows=3272 width=8) (actual time=0.047..0.403 rows=3272 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=37
-> 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=3272)
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=6545
-> Index Scan using text_pkey on eav.text t (cost=0.29..0.45 rows=1 width=30) (actual time=0.001..0.001 rows=1 loops=1313)
Output: t.e, t.a, t.v
Index Cond: ((t.e = p.e) AND (t.a = 1002))
Buffers: shared hit=3939
Planning:
Buffers: shared hit=373
Planning Time: 4.655 ms
Execution Time: 7.307 ms
(38 rows)
