Advertisement
daniilak

Untitled

Jun 4th, 2021
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.54 KB | None | 0 0
  1. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Gather (cost=859691.05..2582209.07 rows=2913619 width=4) (actual time=39.366..4806.134 rows=184475 loops=1)
  2. Workers Planned: 4
  3. Workers Launched: 4
  4. Buffers: shared hit=227215 read=851034
  5. I/O Timings: read=1090.406
  6. -> Hash Join (cost=858691.05..2289847.17 rows=728405 width=4) (actual time=52.909..4738.935 rows=36895 loops=5)
  7. Hash Cond: (t1.id_house = t2.id)
  8. Buffers: shared hit=227215 read=851034
  9. I/O Timings: read=1090.406
  10. -> 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)
  11. Buffers: shared hit=105921 read=851034
  12. I/O Timings: read=1090.406
  13. -> Hash (cost=846663.75..846663.75 rows=962184 width=4) (actual time=44.153..44.154 rows=71594 loops=5)
  14. Buckets: 1048576 Batches: 1 Memory Usage: 10709kB
  15. Buffers: shared hit=121126
  16. -> 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)
  17. Index Cond: (id_addresses = ANY ('{21312312312}'::integer[]))
  18. Buffers: shared hit=121126
  19. Planning Time: 4.133 ms
  20. Execution Time: 4813.173 ms
  21. (20 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement