Postgres 11

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 function f() returns text language sql as $$
  SELECT string_agg (substr('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', ceil (random() * 62)::integer, 1), '')
  FROM generate_series(1, 20)
$$;

CREATE FUNCTION

create table foo(id serial primary key, url_prefix text not null default f());

CREATE TABLE

insert into foo default values;

INSERT 0 1

select * from foo;

id
url_prefix

1
x00rUvHg6SaSvIxMgANJ

SELECT 1