Postgres 15

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 data$$1(
  codes int
);

CREATE TABLE

INSERT INTO data$$1(codes)
VALUES
(100),
(100),
(007),
(100),
(004),
(004),
(000)

INSERT 0 7

select * from data$$1

codes

100

100

7

100

4

4

0

SELECT 7

CREATE PROCEDURE insert_data(a integer, b integer)
LANGUAGE SQL
BEGIN ATOMIC
  INSERT INTO data$$1 VALUES (a);
  INSERT INTO data$$1 VALUES (b);
END;

CREATE PROCEDURE

CALL insert_data(1, 2);

CALL

select * from data$$1

codes

100

100

7

100

4

4

0

1

2

SELECT 9