mandelbrot

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
873.248 100.00% 
 GroupAggregate (cost=6271958.76..6394173.36 rows=200 width=8) (actual time=749.458..873.248 rows=102 loops=1)
   InitPlan
334.165 38.27% 
     -> Recursive Union (cost=0.0..3776956.9 rows=12111110 width=44) (actual time=0.080..334.165 rows=209166 loops=1)
50.896 5.83% 
           -> Nested Loop (cost=0.0..62512.5 rows=1000000 width=8) (actual time=0.079..50.896 rows=10404 loops=1)
0.041 0.00% 
                 -> Function Scan on generate_series i (cost=0.0..12.5 rows=1000 width=4) (actual time=0.030..0.041 rows=102 loops=1)
1.428 0.16% 
                 -> Function Scan on generate_series i (cost=0.0..12.5 rows=1000 width=4) (actual time=0.000..0.014 rows=102 loops=102)
215.130 24.64% 
           -> WorkTable Scan on z (cost=0.0..347222.22 rows=1111111 width=44) (actual time=0.004..2.130 rows=1968 loops=101)
                 Filter: ((z.i < 100) AND (((z.x * z.x) + (z.y * z.y)) < 16::double precision))
866.595 99.24% 
   -> GroupAggregate (cost=2495001.86..2616612.96 rows=40000 width=12) (actual time=749.204..866.595 rows=10404 loops=1)
821.477 94.07% 
         -> Sort (cost=2495001.86..2525279.64 rows=12111110 width=12) (actual time=749.195..821.477 rows=209166 loops=1)
               Sort Key: z.iy, z.ix
               Sort Method:  external merge  Disk: 4496kB
490.159 56.13% 
               -> CTE Scan on z (cost=0.0..242222.2 rows=12111110 width=12) (actual time=0.083..490.159 rows=209166 loops=1)
Run-time
0.878452 seconds (878.452 ms)