Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

explain analyze 
select 1+(g-1)/4
from generate_series(1,3e6,1)_(g);

QUERY PLAN

Function Scan on generate_series _  (cost=0.00..17.50 rows=1000 width=32) (actual time=672.741..2096.559 rows=3000000 loops=1)

Planning Time: 0.350 ms

Execution Time: 2201.828 ms

EXPLAIN

explain analyze 
select ceil(g/4.)
from generate_series(1,3e6,1)_(g);

QUERY PLAN

Function Scan on generate_series _  (cost=0.00..15.00 rows=1000 width=32) (actual time=550.641..1647.685 rows=3000000 loops=1)

Planning Time: 0.043 ms

Execution Time: 1753.720 ms

EXPLAIN

explain analyze 
select (3+g)/4
from generate_series(1,3e6,1)_(g);

QUERY PLAN

Function Scan on generate_series _  (cost=0.00..15.00 rows=1000 width=32) (actual time=553.430..1568.447 rows=3000000 loops=1)

Planning Time: 0.040 ms

Execution Time: 1665.407 ms

EXPLAIN