Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.51 KB | None | 0 0
  1. 2019-07-22 13:02:56.459 CEST [3927] lpo@postgres LOG: duration: 18188.563 ms plan:
  2. Query Text: --explain analyze verbose
  3. select max(name) from lpo
  4. Finalize Aggregate (cost=95935.70..95935.71 rows=1 width=32) (actual time=18188.540..18188.541 rows=1 loops=1)
  5. Output: max((name)::text)
  6. -> Gather (cost=95935.28..95935.69 rows=4 width=32) (actual time=18188.526..18188.529 rows=1 loops=1)
  7. Output: (PARTIAL max((name)::text))
  8. Workers Planned: 4
  9. Workers Launched: 0
  10. -> Partial Aggregate (cost=94935.28..94935.29 rows=1 width=32) (actual time=18188.522..18188.523 rows=1 loops=1)
  11. Output: PARTIAL max((name)::text)
  12. -> Parallel Seq Scan on public.lpo (cost=0.00..88685.23 rows=2500022 width=12) (actual time=0.170..7002.167 rows=10000000 loops=1)
  13. Output: id, name
  14. 2019-07-22 13:03:11.411 CEST [3927] lpo@postgres LOG: duration: 4837.985 ms plan:
  15. Query Text: explain analyze verbose
  16. select max(name) from lpo
  17. Finalize Aggregate (cost=95935.70..95935.71 rows=1 width=32) (actual time=4837.339..4837.340 rows=1 loops=1)
  18. Output: max((name)::text)
  19. -> Gather (cost=95935.28..95935.69 rows=4 width=32) (actual time=4829.581..4837.936 rows=5 loops=1)
  20. Output: (PARTIAL max((name)::text))
  21. Workers Planned: 4
  22. Workers Launched: 4
  23. -> Partial Aggregate (cost=94935.28..94935.29 rows=1 width=32) (actual time=4796.880..4796.881 rows=1 loops=5)
  24. Output: PARTIAL max((name)::text)
  25. Worker 0: actual time=4770.354..4770.356 rows=1 loops=1
  26. Worker 1: actual time=4790.752..4790.753 rows=1 loops=1
  27. Worker 2: actual time=4796.952..4796.953 rows=1 loops=1
  28. Worker 3: actual time=4799.131..4799.132 rows=1 loops=1
  29. -> Parallel Seq Scan on public.lpo (cost=0.00..88685.23 rows=2500022 width=12) (actual time=0.199..1847.132 rows=2000000 loops=5)
  30. Output: id, name
  31. Worker 0: actual time=0.214..1909.002 rows=2022788 loops=1
  32. Worker 1: actual time=0.210..1762.203 rows=2143062 loops=1
  33. Worker 2: actual time=0.209..1883.141 rows=2109945 loops=1
  34. Worker 3: actual time=0.227..1844.104 rows=1854781 loops=1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement