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?.
| field3 | field4 |
|---|---|
| svc_lz.fn_abc | {test} |
| svc_lz.fn_cde | {test1,test2} |
| mfg_lz.fn_test | {test3} |
| mfg_j.fn_test4 | {test5} |
| mfg_j.fn_test5 | {x5} |
| mfg_j.fn_test6 | {test7} |
| mfg_j.fn_test5_abc | {5_abc} |
| mfg_j.fn_test6_abc | {6_abc} |
SELECT 8
| field1 | field2 | field3 | field4 | fld | field1 | field2 | fld |
|---|---|---|---|---|---|---|---|
| a | select from svc_lz.fn_abc;svc_lz.fn_cde; | svc_lz.fn_abc | {test} | test | a | select from svc_lz.fn_abc;svc_lz.fn_cde; | test |
| a | select from svc_lz.fn_abc;svc_lz.fn_cde; | svc_lz.fn_cde | {test1,test2} | test1 | a | select from svc_lz.fn_abc;svc_lz.fn_cde; | test1 |
| a | select from svc_lz.fn_abc;svc_lz.fn_cde; | svc_lz.fn_cde | {test1,test2} | test2 | a | select from svc_lz.fn_abc;svc_lz.fn_cde; | test2 |
| b | select *From mfg_lz.fn_test,mfg_a.fn_test1 | mfg_lz.fn_test | {test3} | test3 | b | select *From mfg_lz.fn_test,mfg_a.fn_test1 | test3 |
| c | select *From mfg_j.fn_test2 | null | null | null | c | select *From mfg_j.fn_test2 | null |
| d | select *From mfg_j.fn_test3;mfg_j.fn_test4; | mfg_j.fn_test4 | {test5} | test5 | d | select *From mfg_j.fn_test3;mfg_j.fn_test4; | test5 |
| e | select *From mfg_j.fn_test5(100);mfg_j.fn_test6(1000) | mfg_j.fn_test5 | {x5} | x5 | e | select *From mfg_j.fn_test5(100);mfg_j.fn_test6(1000) | x5 |
| e | select *From mfg_j.fn_test5(100);mfg_j.fn_test6(1000) | mfg_j.fn_test6 | {test7} | test7 | e | select *From mfg_j.fn_test5(100);mfg_j.fn_test6(1000) | test7 |
| f | select *From mfg_j.fn_test5_abc(100);mfg_j.fn_test6_abc(1000) | mfg_j.fn_test5_abc | {5_abc} | 5_abc | f | select *From mfg_j.fn_test5_abc(100);mfg_j.fn_test6_abc(1000) | 5_abc |
| f | select *From mfg_j.fn_test5_abc(100);mfg_j.fn_test6_abc(1000) | mfg_j.fn_test6_abc | {6_abc} | 6_abc | f | select *From mfg_j.fn_test5_abc(100);mfg_j.fn_test6_abc(1000) | 6_abc |
| j | select *From mfg_j.fn_test5_abc;mfg_j.fn_test6_abc | mfg_j.fn_test5_abc | {5_abc} | 5_abc | j | select *From mfg_j.fn_test5_abc;mfg_j.fn_test6_abc | 5_abc |
| j | select *From mfg_j.fn_test5_abc;mfg_j.fn_test6_abc | mfg_j.fn_test6_abc | {6_abc} | 6_abc | j | select *From mfg_j.fn_test5_abc;mfg_j.fn_test6_abc | 6_abc |
SELECT 12
| field1 | field2 | field3 |
|---|---|---|
| a | select from svc_lz.fn_abc;svc_lz.fn_cde; | test,test1,test2 |
| b | select *From mfg_lz.fn_test,mfg_a.fn_test1 | test3 |
| c | select *From mfg_j.fn_test2 | null |
| d | select *From mfg_j.fn_test3;mfg_j.fn_test4; | test5 |
| e | select *From mfg_j.fn_test5(100);mfg_j.fn_test6(1000) | test7,x5 |
| f | select *From mfg_j.fn_test5_abc(100);mfg_j.fn_test6_abc(1000) | 5_abc,6_abc |
| j | select *From mfg_j.fn_test5_abc;mfg_j.fn_test6_abc | 5_abc,6_abc |
SELECT 7