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
CREATE EXTENSION
ALTER TABLE
| relname | indisprimary | indisunique | indisclustered | indisvalid | pg_get_indexdef | pg_get_constraintdef | contype | condeferrable | condeferred | indisreplident | reltablespace |
|---|---|---|---|---|---|---|---|---|---|---|---|
| no_overlap_times | f | f | f | t | CREATE INDEX no_overlap_times ON workers_times USING gist (user_id, available) | EXCLUDE USING gist (user_id WITH =, available WITH &&) | x | f | f | f | 0 |
SELECT 1