Skip to content

Instantly share code, notes, and snippets.

@ycku

ycku/count_pg0206_idx2.md

Created January 15, 2021 05:45
Show Gist options
  • Save ycku/2a4b815eaf114ed21303dd4f40aad228 to your computer and use it in GitHub Desktop.
Save ycku/2a4b815eaf114ed21303dd4f40aad228 to your computer and use it in GitHub Desktop.
Download ZIP
Query Plan: pg0206 idx2 (n_distinct: 1)
Raw
count_pg0206_idx2.md 
                                                                                  QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Finalize Aggregate  (cost=1944764.47..1944764.48 rows=1 width=8) (actual time=5411.797..5446.435 rows=1 loops=1)
   ->  Gather  (cost=1944764.05..1944764.46 rows=4 width=8) (actual time=5411.520..5446.421 rows=5 loops=1)
         Workers Planned: 4
         Workers Launched: 4
         ->  Partial Aggregate  (cost=1943764.05..1943764.06 rows=1 width=8) (actual time=5361.116..5361.117 rows=1 loops=5)
               ->  Parallel Index Only Scan using pg0206_idx2 on pg0206  (cost=0.57..1809782.59 rows=53592584 width=0) (actual time=0.308..3485.449 rows=42874123 loops=5)
                     Heap Fetches: 16004
 Planning Time: 0.081 ms
 JIT:
   Functions: 12
   Options: Inlining true, Optimization true, Expressions true, Deforming true
   Timing: Generation 1.933 ms, Inlining 225.162 ms, Optimization 47.457 ms, Emission 35.056 ms, Total 309.609 ms
 Execution Time: 5447.446 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment