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?.

select version();


version


PostgreSQL 14.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit


create table test_nu (
  vp_id int,
  system_activ int,
  vpm_activ int
);

with expand as (
  select (j->>'vp_id')::int as vp_ip,
         (j->>'system_activ')::int as system_activ,
         (j->>'vpm_activ')::int as vpm_activ
    from jsonb_array_elements(('[{"vp_id":1,"system_activ":1,"vpm_activ":1},{"vp_id":2,"system_activ":2,"vpm_activ":2}]
')::jsonb) as el(j)
)
insert into test_nu (vp_id, system_activ, vpm_activ)
select vp_ip, system_activ, vpm_activ
  from expand;
2 rows affected

select * from test_nu;


vp_id
system_activ
vpm_activ


1
1
1

2
2
2