Skip to content

Instantly share code, notes, and snippets.

@ycku

ycku/count_pg0206_pk.md

Created January 15, 2021 05:37
Show Gist options
  • Save ycku/3a3c15459a83435c412e73ed4795663c to your computer and use it in GitHub Desktop.
Save ycku/3a3c15459a83435c412e73ed4795663c to your computer and use it in GitHub Desktop.
Download ZIP
Query Plan: pg0206_pk
Raw
count_pg0206_pk.md 
                                                                                   QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Finalize Aggregate  (cost=4329749.33..4329749.34 rows=1 width=8) (actual time=1376247.195..1376479.448 rows=1 loops=1)
   ->  Gather  (cost=4329748.91..4329749.32 rows=4 width=8) (actual time=1376246.901..1376479.423 rows=5 loops=1)
         Workers Planned: 4
         Workers Launched: 4
         ->  Partial Aggregate  (cost=4328748.91..4328748.92 rows=1 width=8) (actual time=1376206.398..1376206.405 rows=1 loops=5)
               ->  Parallel Index Only Scan using pg0206_pk on pg0206  (cost=0.57..4194530.80 rows=53687244 width=0) (actual time=0.053..1371797.942 rows=42873650 loops=5)
                     Heap Fetches: 6314
 Planning Time: 0.119 ms
 JIT:
   Functions: 12
   Options: Inlining true, Optimization true, Expressions true, Deforming true
   Timing: Generation 2.713 ms, Inlining 230.752 ms, Optimization 44.989 ms, Emission 34.064 ms, Total 312.518 ms
 Execution Time: 1376481.224 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment