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?.
| QUERY PLAN |
|---|
| Aggregate (cost=31.54..31.55 rows=1 width=8) (actual time=0.011..0.012 rows=1 loops=1) |
| -> Nested Loop (cost=0.00..31.54 rows=1 width=8) (actual time=0.007..0.008 rows=0 loops=1) |
| Join Filter: (a.household_entity_proxy_id = c.household_entity_proxy_id) |
| -> Nested Loop (cost=0.00..21.36 rows=1 width=16) (actual time=0.006..0.007 rows=0 loops=1) |
| Join Filter: (a.individual_entity_proxy_id = b.individual_entity_proxy_id) |
| -> Seq Scan on prospect a (cost=0.00..10.82 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=1) |
| Filter: (((last_contacted_anychannel_dttm IS NULL) OR (last_contacted_anychannel_dttm < '2020-11-23 00:00:00'::timestamp without time zone)) AND (shared_paddr_with_customer_ind = 'N'::bpchar) AND (profane_wrd_ind = 'N'::bpchar) AND (tmo_ofnsv_name_ind = 'N'::bpchar) AND (has_individual_address = 'Y'::bpchar) AND (has_last_name = 'Y'::bpchar) AND (has_first_name = 'Y'::bpchar)) |
| -> Seq Scan on individual_demographic b (cost=0.00..10.53 rows=1 width=8) (never executed) |
| Filter: ((tax_bnkrpt_dcsd_ind = 'N'::bpchar) AND (govt_prison_ind = 'N'::bpchar) AND ((cstmr_prspct_ind)::text = 'Prospect'::text)) |
| -> Seq Scan on household_demographic c (cost=0.00..10.14 rows=3 width=8) (never executed) |
| Filter: (((hspnc_lang_prfrnc_cval)::text = ANY ('{B,E,X}'::text[])) OR (hspnc_lang_prfrnc_cval IS NULL)) |
| Planning Time: 2.031 ms |
| Execution Time: 0.250 ms |