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?.
| id | url | regexp_replace |
|---|---|---|
| 1 | https://short/url | https://short/url |
| 2 | https://this/is/a/very/long/url | https://this/is/a/very-long-url |
| 3 | https://this/url/is/even/much/longer/than/the/last/one | https://this/url/is/even-much-longer-than-the-last-one |
| 3 | not/an/url/but/still/many/nested/slashes | not/an/url/but/still/many-nested-slashes |
| 4 | no slash | no slash |
| 5 | ||
| 6 | null | null |
SELECT 7