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?.
ALTER TABLE
schemaname | tablename | attname | inherited | null_frac | avg_width | n_distinct | most_common_vals | most_common_freqs | histogram_bounds | correlation | most_common_elems | most_common_elem_freqs | elem_count_histogram |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
pg_temp_1 | dir_process | parent_id | f | 0 | 8 | -1 | null | null | null | null | null | null | null |
SELECT 1
schemaname | tablename | attname | inherited | null_frac | avg_width | n_distinct | most_common_vals | most_common_freqs | histogram_bounds | correlation | most_common_elems | most_common_elem_freqs | elem_count_histogram |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
pg_temp_1 | dir_process | parent_id | f | 0 | 8 | 1000 | null | null | null | null | null | null | null |
SELECT 1