Skip to content

Instantly share code, notes, and snippets.

@ycku
Created January 15, 2021 05:42
Show Gist options
  • Save ycku/322bc9ae71db6c94ba3fdb48771c4f98 to your computer and use it in GitHub Desktop.
Save ycku/322bc9ae71db6c94ba3fdb48771c4f98 to your computer and use it in GitHub Desktop.
Query Plan: pg0206 seq scan
                                                                      QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
 Finalize Aggregate  (cost=8769687.97..8769687.98 rows=1 width=8) (actual time=251075.617..251083.959 rows=1 loops=1)
   ->  Gather  (cost=8769687.55..8769687.96 rows=4 width=8) (actual time=251075.601..251083.948 rows=5 loops=1)
         Workers Planned: 4
         Workers Launched: 4
         ->  Partial Aggregate  (cost=8768687.55..8768687.56 rows=1 width=8) (actual time=251006.759..251006.761 rows=1 loops=5)
               ->  Parallel Seq Scan on pg0206  (cost=0.00..8634469.44 rows=53687244 width=0) (actual time=9.456..245508.069 rows=42873831 loops=5)
 Planning Time: 0.151 ms
 JIT:
   Functions: 12
   Options: Inlining true, Optimization true, Expressions true, Deforming true
   Timing: Generation 3.543 ms, Inlining 225.300 ms, Optimization 45.228 ms, Emission 34.822 ms, Total 308.892 ms
 Execution Time: 251086.270 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment