QUERY PLAN -------------------------------------------------------------------------------------------------------------------------------------------------- Finalize GroupAggregate (cost=4031.76..4032.41 rows=5 width=23) (actual time=18.957..19.960 rows=5 loops=1) Output: v, count(*) Group Key: keyword.v Buffers: shared hit=1372 -> Gather Merge (cost=4031.76..4032.34 rows=5 width=23) (actual time=18.951..19.953 rows=10 loops=1) Output: v, (PARTIAL count(*)) Workers Planned: 1 Workers Launched: 1 Buffers: shared hit=1372 -> Sort (cost=3031.75..3031.77 rows=5 width=23) (actual time=16.383..16.384 rows=5 loops=2) Output: v, (PARTIAL count(*)) Sort Key: keyword.v Sort Method: quicksort Memory: 25kB Buffers: shared hit=1372 Worker 0: actual time=14.117..14.118 rows=5 loops=1 Sort Method: quicksort Memory: 25kB Buffers: shared hit=592 -> Partial HashAggregate (cost=3031.65..3031.70 rows=5 width=23) (actual time=16.295..16.296 rows=5 loops=2) Output: v, PARTIAL count(*) Group Key: keyword.v Batches: 1 Memory Usage: 24kB Buffers: shared hit=1364 Worker 0: actual time=14.018..14.019 rows=5 loops=1 Batches: 1 Memory Usage: 24kB Buffers: shared hit=584 -> Parallel Seq Scan on eav.keyword (cost=0.00..2555.18 rows=95294 width=15) (actual time=0.007..6.445 rows=81000 loops=2) Output: e, a, v Filter: (keyword.a = 1003) Buffers: shared hit=1364 Worker 0: actual time=0.007..5.632 rows=69390 loops=1 Buffers: shared hit=584 Planning: Buffers: shared hit=138 Planning Time: 1.342 ms Execution Time: 20.122 ms (35 rows)