Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Gather (cost=859691.05..2582209.07 rows=2913619 width=4) (actual time=39.366..4806.134 rows=184475 loops=1)
- Workers Planned: 4
- Workers Launched: 4
- Buffers: shared hit=227215 read=851034
- I/O Timings: read=1090.406
- -> Hash Join (cost=858691.05..2289847.17 rows=728405 width=4) (actual time=52.909..4738.935 rows=36895 loops=5)
- Hash Cond: (t1.id_house = t2.id)
- Buffers: shared hit=227215 read=851034
- I/O Timings: read=1090.406
- -> Parallel Seq Scan on cache_table t1 (cost=0.00..1332559.84 rows=37560484 width=8) (actual time=0.022..1901.911 rows=30048358 loops=5)
- Buffers: shared hit=105921 read=851034
- I/O Timings: read=1090.406
- -> Hash (cost=846663.75..846663.75 rows=962184 width=4) (actual time=44.153..44.154 rows=71594 loops=5)
- Buckets: 1048576 Batches: 1 Memory Usage: 10709kB
- Buffers: shared hit=121126
- -> Index Scan using houses_index on houses t2 (cost=0.56..846663.75 rows=962184 width=4) (actual time=0.591..30.777 rows=71594 loops=5)
- Index Cond: (id_addresses = ANY ('{21312312312}'::integer[]))
- Buffers: shared hit=121126
- Planning Time: 4.133 ms
- Execution Time: 4813.173 ms
- (20 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement