Skip to content

Instantly share code, notes, and snippets.

@amalloy

amalloy/gist:2b463fa92df50bf872f77edb2bd9937d

Created January 16, 2019 20:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save amalloy/2b463fa92df50bf872f77edb2bd9937d to your computer and use it in GitHub Desktop.
Save amalloy/2b463fa92df50bf872f77edb2bd9937d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
query plan for `lm *`:
------------------------------------------------------------------------------------------------------------------------------------------------------
Finalize Aggregate (cost=2406794.84..2406794.85 rows=1 width=8) (actual time=47772.901..47772.901 rows=1 loops=1)
-> Gather (cost=2406794.62..2406794.83 rows=2 width=8) (actual time=47772.832..47774.309 rows=3 loops=1)
Workers Planned: 2
Workers Launched: 2
-> Partial Aggregate (cost=2405794.62..2405794.63 rows=1 width=8) (actual time=47769.615..47769.615 rows=1 loops=3)
-> Parallel Seq Scan on milestone (cost=0.00..2356329.70 rows=19785970 width=0) (actual time=0.121..45652.718 rows=15828777 loops=3)
Planning time: 0.488 ms
Execution time: 47774.356 ms
(8 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment