GroupAggregate (cost=28944.11..351698.49 rows=1479720 width=53) (actual time=998.937..10008.509 rows=1500000 loops=1) |
Group Key: ids.id1, groupst.grid |
Buffers: shared hit=530 read=2779 dirtied=2950 written=2679, temp read=1713 written=1724 |
-> Incremental Sort (cost=28944.11..310697.49 rows=3000600 width=26) (actual time=998.915..8144.854 rows=3000000 loops=1) |
Sort Key: ids.id1, groupst.grid |
Presorted Key: ids.id1 |
Full-sort Groups: 50000 Sort Method: quicksort Average Memory: 29kB Peak Memory: 29kB |
Buffers: shared hit=530 read=2779 dirtied=2950 written=2679, temp read=1713 written=1724 |
-> Nested Loop (cost=28941.70..143426.43 rows=3000600 width=26) (actual time=998.694..2617.400 rows=3000000 loops=1) |
Buffers: shared hit=530 read=2779 dirtied=2950 written=2679, temp read=1713 written=1724 |
-> Gather Merge (cost=28941.55..87174.79 rows=500000 width=17) (actual time=998.572..1623.716 rows=500000 loops=1) |
Workers Planned: 2 |
Workers Launched: 2 |
Buffers: shared hit=523 read=2777 dirtied=2949 written=2679, temp read=1713 written=1724 |
-> Sort (cost=27941.52..28462.36 rows=208333 width=17) (actual time=855.203..973.654 rows=166667 loops=3) |
Sort Key: ids.id1 |
Sort Method: external merge Disk: 5432kB |
Buffers: shared hit=523 read=2777 dirtied=2949 written=2679, temp read=1713 written=1724 |
Worker 0: Sort Method: external merge Disk: 4304kB |
Worker 1: Sort Method: external merge Disk: 3968kB |
-> Parallel Seq Scan on ids (cost=0.00..5263.33 rows=208333 width=17) (actual time=0.049..197.055 rows=166667 loops=3) |
Buffers: shared hit=405 read=2775 dirtied=2949 written=2679 |
-> Memoize (cost=0.15..0.29 rows=8 width=14) (actual time=0.000..0.001 rows=6 loops=500000) |
Cache Key: ids.id2 |
Cache Mode: logical |
Hits: 499995 Misses: 5 Evictions: 0 Overflows: 0 Memory Usage: 2kB |
Buffers: shared hit=7 read=2 dirtied=1 |
-> Index Only Scan using groupst_pkey on groupst (cost=0.14..0.28 rows=8 width=14) (actual time=0.021..0.024 rows=6 loops=5) |
Index Cond: (id2 = (ids.id2)::text) |
Heap Fetches: 30 |
Buffers: shared hit=7 read=2 dirtied=1 |
Planning: |
Buffers: shared hit=133 read=8 |
Planning Time: 1.014 ms |
Execution Time: 10112.083 ms |