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 * from pg_proc where proname ~ 'pg_get_function_sqlbody';
| oid | proname | pronamespace | proowner | prolang | procost | prorows | provariadic | prosupport | prokind | prosecdef | proleakproof | proisstrict | proretset | provolatile | proparallel | pronargs | pronargdefaults | prorettype | proargtypes | proallargtypes | proargmodes | proargnames | proargdefaults | protrftypes | prosrc | probin | prosqlbody | proconfig | proacl |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6197 | pg_get_function_sqlbody | 11 | 10 | 12 | 1 | 0 | 0 | - | f | f | f | t | f | s | s | 1 | 0 | 25 | 26 | null | null | null | null | null | pg_get_function_sqlbody | null | null | null | null |
SELECT 1