QUERY PLAN - Nested Loop Left Join (cost=14.15..249.76 rows=10 width=8) (actual time=0.227..0.233 rows=1 loops=1) InitPlan 1 (returns $1) -> Nested Loop (cost=1.00..8.24 rows=1 width=8) (actual time=0.057..0.058 rows=1 loops=1) -> Index Scan using ix_TABLE_N_type_value_case on TABLE_N aa1 (cost=0.56..4.18 rows=1 width=8) (actual time=0.039..0.040 rows=1 loops=1) Index Cond: (((TABLE_N_type)::text = 'ID_TYPE_X'::text) AND ((TABLE_N_value)::text = 'SOME/UNIQUE/VALUE'::text)) Filter: (is_deleted = 'N'::bpchar) -> Index Scan using ix_TABLE_E_TABLE_E_pk on TABLE_E ar1 (cost=0.44..4.06 rows=1 width=8) (actual time=0.016..0.016 rows=1 loops=1) Index Cond: (TABLE_E_pk = aa1.TABLE_E_pk) Filter: ((is_deleted = 'N'::bpchar) AND ((app_case_type)::text = '8'::text)) -> Nested Loop Left Join (cost=5.48..234.10 rows=10 width=16) (actual time=0.217..0.222 rows=1 loops=1) -> Nested Loop Left Join (cost=5.05..193.62 rows=10 width=16) (actual time=0.208..0.213 rows=1 loops=1) -> Nested Loop Left Join (cost=4.62..152.99 rows=10 width=16) (actual time=0.196..0.201 rows=1 loops=1) -> Nested Loop Left Join (cost=4.18..112.42 rows=10 width=16) (actual time=0.186..0.191 rows=1 loops=1) -> Nested Loop Left Join (cost=3.75..107.42 rows=10 width=24) (actual time=0.172..0.176 rows=1 loops=1) -> Nested Loop (cost=3.31..102.68 rows=10 width=24) (actual time=0.159..0.162 rows=1 loops=1) -> Nested Loop (cost=2.88..97.81 rows=10 width=32) (actual time=0.144..0.147 rows=1 loops=1) -> Nested Loop (cost=2.44..92.88 rows=10 width=24) (actual time=0.131..0.134 rows=1 loops=1) -> Nested Loop (cost=1.88..86.62 rows=10 width=16) (actual time=0.118..0.119 rows=1 loops=1) Join Filter: (gi.TABLE_A_pk = ii.TABLE_A_pk) -> Nested Loop (cost=1.31..80.32 rows=10 width=32) (actual time=0.103..0.104 rows=1 loops=1) -> Nested Loop (cost=0.88..75.43 rows=10 width=24) (actual time=0.090..0.091 rows=1 loops=1) -> Index Scan using ix_TABLE_E_TABLE_E_pk on TABLE_E ar (cost=0.44..34.90 rows=10 width=8) (actual time=0.073..0.074 rows=1 loops=1) Index Cond: (TABLE_E_pk = ANY ($1)) Filter: (is_deleted = 'N'::bpchar) -> Index Scan using uk_TABLE_D_TABLE_E_pk on TABLE_D gr (cost=0.44..4.05 rows=1 width=24) (actual time=0.016..0.016 rows=1 loops=1) Index Cond: (TABLE_E_pk = ar.TABLE_E_pk) Filter: (is_deleted = 'N'::bpchar) -> Index Scan using ix_biog_id_biog_id_pk on TABLE_A gi (cost=0.44..0.49 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=1) Index Cond: (TABLE_A_pk = gr.TABLE_A_pk) Filter: (is_deleted = 'N'::bpchar) -> Index Scan using ix_TABLE_C_mida on TABLE_C ii (cost=0.56..0.62 rows=1 width=8) (actual time=0.014..0.014 rows=1 loops=1) Index Cond: (TABLE_A_pk = gr.TABLE_A_pk) Filter: (is_deleted = 'N'::bpchar) -> Index Scan using ix_TABLE_F_mida on TABLE_F ir (cost=0.56..0.62 rows=1 width=16) (actual time=0.013..0.013 rows=1 loops=1) Index Cond: (TABLE_D_pk = gr.TABLE_D_pk) Filter: (is_deleted = 'N'::bpchar) -> Index Scan using pk_TABLE_G on TABLE_G mr (cost=0.44..0.49 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=1) Index Cond: (TABLE_G_pk = ir.TABLE_G_pk) Filter: (is_deleted = 'N'::bpchar) -> Index Scan using ix_TABLE_O_mida on TABLE_O mi (cost=0.44..0.49 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=1) Index Cond: (TABLE_O_pk = mr.TABLE_O_pk) Filter: (is_deleted = 'N'::bpchar) -> Index Scan using ix_TABLE_H_TABLE_D_pk on TABLE_H gm (cost=0.43..0.46 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=1) Index Cond: (TABLE_D_pk = gr.TABLE_D_pk) Filter: (is_deleted = 'N'::bpchar) -> Index Scan using ix_TABLE_I_TABLE_D_pk on TABLE_I gy (cost=0.44..0.49 rows=1 width=8) (actual time=0.014..0.014 rows=1 loops=1) Index Cond: (TABLE_D_pk = gr.TABLE_D_pk) Filter: (is_deleted = 'N'::bpchar) -> Index Scan using ix_TABLE_J_TABLE_E_pk on TABLE_J ac (cost=0.43..4.05 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=1) Index Cond: (TABLE_E_pk = ar.TABLE_E_pk) Filter: (is_deleted = 'N'::bpchar) -> Index Scan using ix_TABLE_N_TABLE_E_pk on TABLE_N aa (cost=0.44..4.05 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=1) Index Cond: (TABLE_E_pk = ar.TABLE_E_pk) Filter: (is_deleted = 'N'::bpchar) -> Index Scan using ix_TABLE_L_TABLE_E_pk on TABLE_L ap (cost=0.42..4.04 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=1) Index Cond: (TABLE_E_pk = ar.TABLE_E_pk) Filter: (is_deleted = 'N'::bpchar) -> Index Only Scan using ix_TABLE_M_TABLE_G_pk on TABLE_M fp (cost=0.43..0.64 rows=10 width=8) (actual time=0.009..0.009 rows=0 loops=1) Index Cond: ((TABLE_G_pk = mr.TABLE_G_pk) AND (is_deleted = 'N'::bpchar)) Heap Fetches: 0 Planning Time: 61.539 ms Execution Time: 0.405 ms (62 rows)