1CREATE TABLE fruits ( 2 id int, 3 items jsonb 4); 5INSERT INTO fruits VALUES (1, '{"apple": true}'); 6INSERT INTO fruits VALUES (2, '{"banana": false}'); 7INSERT INTO fruits VALUES (3, '{"peach": true}'); 8SET enable_seqscan = on; 9SET enable_indexscan = off; 10SET enable_bitmapscan = off; 11SELECT id, items 12 FROM fruits 13 WHERE items &` 'boolean == true' 14 ORDER BY id; 15 id | items 16----+----------------- 17 1 | {"apple": true} 18 3 | {"peach": true} 19(2 rows) 20 21DROP TABLE fruits; 22