Skip to content

Instantly share code, notes, and snippets.

@ycku

ycku/count_pg0206_idx1.md

Created January 15, 2021 05:44
Show Gist options
  • Save ycku/463f65a113ce4fecbe0d311a4223280c to your computer and use it in GitHub Desktop.
Save ycku/463f65a113ce4fecbe0d311a4223280c to your computer and use it in GitHub Desktop.
Download ZIP
Query Plan: pg0206 idx1 (n_distict: 13433907)
Raw
count_pg0206_idx1.md 
                                                                                   QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Finalize Aggregate  (cost=2631471.56..2631471.57 rows=1 width=8) (actual time=22078.116..22178.107 rows=1 loops=1)
   ->  Gather  (cost=2631471.14..2631471.55 rows=4 width=8) (actual time=22077.746..22178.083 rows=5 loops=1)
         Workers Planned: 4
         Workers Launched: 4
         ->  Partial Aggregate  (cost=2630471.14..2630471.15 rows=1 width=8) (actual time=21974.459..21974.460 rows=1 loops=5)
               ->  Parallel Index Only Scan using pg0206_idx1 on pg0206  (cost=0.57..2496490.09 rows=53592420 width=0) (actual time=10.389..19741.532 rows=42874035 loops=5)
                     Heap Fetches: 12451
 Planning Time: 0.126 ms
 JIT:
   Functions: 12
   Options: Inlining true, Optimization true, Expressions true, Deforming true
   Timing: Generation 2.912 ms, Inlining 235.643 ms, Optimization 43.697 ms, Emission 41.494 ms, Total 323.745 ms
 Execution Time: 22179.966 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment