Hi, What is going on here?
postgres=# create table logs as select generate_series(1, 1000000)::text as data; SELECT 1000000 postgres=# insert into logs select * from logs; INSERT 0 1000000 postgres=# insert into logs select * from logs; INSERT 0 2000000 postgres=# insert into logs select * from logs; INSERT 0 4000000 postgres=# insert into logs select * from logs; INSERT 0 8000000 postgres=# insert into logs select * from logs; INSERT 0 16000000 postgres=# analyze logs; ANALYZE postgres=# set max_parallel_workers_per_gather = 0; SET postgres=# explain select length(data) from logs group by length(data); ┌────────────────────────────────────────────────────────────────────────────┐ │ QUERY PLAN │ ├────────────────────────────────────────────────────────────────────────────┤ │ Group (cost=5843157.07..6005642.13 rows=993989 width=4) │ │ Group Key: (length(data)) │ │ -> Sort (cost=5843157.07..5923157.11 rows=32000018 width=4) │ │ Sort Key: (length(data)) │ │ -> Seq Scan on logs (cost=0.00..541593.22 rows=32000018 width=4) │ └────────────────────────────────────────────────────────────────────────────┘ (5 rows) postgres=# set max_parallel_workers_per_gather = 2; SET postgres=# explain select length(data) from logs group by length(data); ERROR: ORDER/GROUP BY expression not found in targetlist -- Thomas Munro http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
