By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TABLE my_table (
data json
);
INSERT INTO my_table VALUES
('{"active":true,"id":"xxxxxxxxxxxxxxxxx","settings":{"secret":"xxxxxxxxxxxxxxxxxxxxxxxxxx","token":"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx","expires":"2019-12-16 01:11:23"},"plan":"Sample"}')
CREATE TABLE
INSERT 0 1
SELECT
(regexp_matches(data::text, '"id":"(.*?)"'))[1]
FROM my_table
| regexp_matches |
|---|
| xxxxxxxxxxxxxxxxx |
SELECT 1