Postgres 14

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 ("clusterName" text, "clusterNamespace" text);

ALTER TABLE my_table ADD COLUMN resources jsonb 
GENERATED ALWAYS AS (('[{"'||"clusterName"||'":"' || "clusterNamespace" || '"}]')::jsonb) STORED;

CREATE TABLE

ALTER TABLE

INSERT INTO my_table VALUES ('c:cluster-x','ns:cluster-x/namespace-1'),(NULL,NULL);

INSERT 0 2

SELECT * FROM my_table

clusterName
clusterNamespace
resources

c:cluster-x
ns:cluster-x/namespace-1
[{"c:cluster-x": "ns:cluster-x/namespace-1"}]

null
null
null

SELECT 2

clusterName	clusterNamespace	resources
c:cluster-x	ns:cluster-x/namespace-1	[{"c:cluster-x": "ns:cluster-x/namespace-1"}]
null	null	null