QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Gather (cost=3018.20..7342.81 rows=2686 width=39) (actual time=8.007..43.065 rows=13080 loops=1)
Output: s_1.e, t.v, p.v
Workers Planned: 2
Workers Launched: 2
Buffers: shared hit=149174 read=1669 written=229
-> Nested Loop (cost=2018.20..6074.21 rows=1119 width=39) (actual time=4.088..36.829 rows=4360 loops=3)
Output: s_1.e, t.v, p.v
Inner Unique: true
Buffers: shared hit=149174 read=1669 written=229
Worker 0: actual time=1.976..34.967 rows=4319 loops=1
Buffers: shared hit=49509 read=549 written=74
Worker 1: actual time=2.736..35.365 rows=4360 loops=1
Buffers: shared hit=49674 read=559 written=75
-> Nested Loop (cost=2017.78..5415.18 rows=1127 width=32) (actual time=4.026..25.743 rows=4360 loops=3)
Output: s.e, p.v, p.e, s_1.e
Inner Unique: true
Buffers: shared hit=98521
Worker 0: actual time=1.909..23.893 rows=4319 loops=1
Buffers: shared hit=32781
Worker 1: actual time=2.678..24.310 rows=4360 loops=1
Buffers: shared hit=32792
-> Parallel Hash Join (cost=2017.36..3897.86 rows=2811 width=16) (actual time=3.933..7.723 rows=10855 loops=3)
Output: s.e, s_1.e
Inner Unique: true
Hash Cond: (s.e = s_1.e)
Buffers: shared hit=821
Worker 0: actual time=1.826..5.673 rows=10856 loops=1
Buffers: shared hit=211
Worker 1: actual time=2.548..6.346 rows=10856 loops=1
Buffers: shared hit=219
-> Parallel Index Only Scan using eav_keyword_vaet on eav.keyword s (cost=0.42..1844.76 rows=13775 width=8) (actual time=0.281..1.727 rows=10855 loops=3)
Output: s.v, s.a, s.e
Index Cond: ((s.v = ':state/open'::text) AND (s.a = 1003))
Heap Fetches: 0
Buffers: shared hit=363
Worker 0: actual time=0.067..1.574 rows=10856 loops=1
Buffers: shared hit=126
Worker 1: actual time=0.393..1.855 rows=10856 loops=1
Buffers: shared hit=119
-> Parallel Hash (cost=1844.76..1844.76 rows=13775 width=8) (actual time=3.137..3.137 rows=10855 loops=3)
Output: s_1.e
Buckets: 65536 Batches: 1 Memory Usage: 1824kB
Buffers: shared hit=362
Worker 0: actual time=1.117..1.118 rows=3400 loops=1
Buffers: shared hit=37
Worker 1: actual time=1.685..1.686 rows=4692 loops=1
Buffers: shared hit=52
-> Parallel Index Only Scan using eav_keyword_vaet on eav.keyword s_1 (cost=0.42..1844.76 rows=13775 width=8) (actual time=0.035..1.532 rows=10855 loops=3)
Output: s_1.e
Index Cond: ((s_1.v = ':state/open'::text) AND (s_1.a = 1003))
Heap Fetches: 0
Buffers: shared hit=362
Worker 0: actual time=0.018..0.559 rows=3400 loops=1
Buffers: shared hit=37
Worker 1: actual time=0.023..0.724 rows=4692 loops=1
Buffers: shared hit=52
-> Index Only Scan using eav_long_aevt on eav.long p (cost=0.42..0.54 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=32564)
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=97700
Worker 0: actual time=0.001..0.001 rows=0 loops=10856
Buffers: shared hit=32570
Worker 1: actual time=0.001..0.001 rows=0 loops=10856
Buffers: shared hit=32573
-> Index Scan using text_pkey on eav.text t (cost=0.42..0.58 rows=1 width=31) (actual time=0.002..0.002 rows=1 loops=13080)
Output: t.e, t.a, t.v
Index Cond: ((t.e = p.e) AND (t.a = 1002))
Buffers: shared hit=50653 read=1669 written=229
Worker 0: actual time=0.002..0.002 rows=1 loops=4319
Buffers: shared hit=16728 read=549 written=74
Worker 1: actual time=0.002..0.002 rows=1 loops=4360
Buffers: shared hit=16882 read=559 written=75
Planning:
Buffers: shared hit=394
Planning Time: 4.846 ms
Execution Time: 43.681 ms
(79 rows)
