(SELECT max(id) AS id, payload FROM t

WHERE id % 101 = 0 GROUP BY (payload)) AS q2

WHERE q1.id = q2.id;') AS str

WHERE str NOT LIKE '%Workers%' AND str NOT LIKE '%Sort Method%';

WHERE str NOT LIKE '%Workers%' AND str NOT LIKE '%Sort Method%'

AND str NOT LIKE '%Gather Merge%';

str

--------------------------------------------------------------------------------------------------

Aggregate (actual rows=1 loops=1)

-> Finalize GroupAggregate (actual rows=1 loops=1)

AQO not used

Group Key: t.payload

-> Gather Merge (actual rows=3 loops=1)

AQO not used

-> Partial GroupAggregate (actual rows=1 loops=3)

AQO not used

-> Group (actual rows=1000 loops=1)

AQO not used

Group Key: t_1.id

-> Gather Merge (actual rows=1000 loops=1)

AQO not used

-> Group (actual rows=333 loops=3)

AQO not used

Using aqo: true

AQO mode: LEARN

JOINS: 1

(42 rows)

(40 rows)

RESET parallel_tuple_cost;

RESET parallel_setup_cost;

WHERE q1.id = q2.id;')AS str

WHERE str NOTLIKE'%Workers%'AND str NOTLIKE'%Sort Method%';

WHERE str NOTLIKE'%Workers%'AND str NOTLIKE'%Sort Method%'

AND str NOTLIKE'%Gather Merge%';

RESET parallel_tuple_cost;