Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2019-07-22 13:02:56.459 CEST [3927] lpo@postgres LOG: duration: 18188.563 ms plan:
- Query Text: --explain analyze verbose
- select max(name) from lpo
- Finalize Aggregate (cost=95935.70..95935.71 rows=1 width=32) (actual time=18188.540..18188.541 rows=1 loops=1)
- Output: max((name)::text)
- -> Gather (cost=95935.28..95935.69 rows=4 width=32) (actual time=18188.526..18188.529 rows=1 loops=1)
- Output: (PARTIAL max((name)::text))
- Workers Planned: 4
- Workers Launched: 0
- -> Partial Aggregate (cost=94935.28..94935.29 rows=1 width=32) (actual time=18188.522..18188.523 rows=1 loops=1)
- Output: PARTIAL max((name)::text)
- -> 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)
- Output: id, name
- 2019-07-22 13:03:11.411 CEST [3927] lpo@postgres LOG: duration: 4837.985 ms plan:
- Query Text: explain analyze verbose
- select max(name) from lpo
- Finalize Aggregate (cost=95935.70..95935.71 rows=1 width=32) (actual time=4837.339..4837.340 rows=1 loops=1)
- Output: max((name)::text)
- -> Gather (cost=95935.28..95935.69 rows=4 width=32) (actual time=4829.581..4837.936 rows=5 loops=1)
- Output: (PARTIAL max((name)::text))
- Workers Planned: 4
- Workers Launched: 4
- -> Partial Aggregate (cost=94935.28..94935.29 rows=1 width=32) (actual time=4796.880..4796.881 rows=1 loops=5)
- Output: PARTIAL max((name)::text)
- Worker 0: actual time=4770.354..4770.356 rows=1 loops=1
- Worker 1: actual time=4790.752..4790.753 rows=1 loops=1
- Worker 2: actual time=4796.952..4796.953 rows=1 loops=1
- Worker 3: actual time=4799.131..4799.132 rows=1 loops=1
- -> 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)
- Output: id, name
- Worker 0: actual time=0.214..1909.002 rows=2022788 loops=1
- Worker 1: actual time=0.210..1762.203 rows=2143062 loops=1
- Worker 2: actual time=0.209..1883.141 rows=2109945 loops=1
- Worker 3: actual time=0.227..1844.104 rows=1854781 loops=1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement