QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Nested Loop Left Join (cost=14.15..249.76 rows=10 width=8) (actual time=9.640..9.654 rows=1 loops=1) Buffers: shared hit=59 read=1 I/O Timings: read=9.334 InitPlan 1 (returns $1) -> Nested Loop (cost=1.00..8.24 rows=1 width=8) (actual time=0.048..0.051 rows=1 loops=1) Buffers: shared hit=9 -> 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.031..0.032 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) Buffers: shared hit=5 -> 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)) Buffers: shared hit=4 -> Nested Loop Left Join (cost=5.48..234.10 rows=10 width=16) (actual time=9.627..9.638 rows=1 loops=1) Buffers: shared hit=56 read=1 I/O Timings: read=9.334 -> Nested Loop Left Join (cost=5.05..193.62 rows=10 width=16) (actual time=9.615..9.626 rows=1 loops=1) Buffers: shared hit=53 read=1 I/O Timings: read=9.334 -> Nested Loop Left Join (cost=4.62..152.99 rows=10 width=16) (actual time=9.600..9.610 rows=1 loops=1) Buffers: shared hit=49 read=1 I/O Timings: read=9.334 -> Nested Loop Left Join (cost=4.18..112.42 rows=10 width=16) (actual time=9.586..9.596 rows=1 loops=1) Buffers: shared hit=46 read=1 I/O Timings: read=9.334 -> Nested Loop Left Join (cost=3.75..107.42 rows=10 width=24) (actual time=9.569..9.577 rows=1 loops=1) Buffers: shared hit=42 read=1 I/O Timings: read=9.334 -> Nested Loop (cost=3.31..102.68 rows=10 width=24) (actual time=9.552..9.559 rows=1 loops=1) Buffers: shared hit=38 read=1 I/O Timings: read=9.334 -> Nested Loop (cost=2.88..97.81 rows=10 width=32) (actual time=9.531..9.538 rows=1 loops=1) Buffers: shared hit=34 read=1 I/O Timings: read=9.334 -> Nested Loop (cost=2.44..92.88 rows=10 width=24) (actual time=9.513..9.519 rows=1 loops=1) Buffers: shared hit=30 read=1 I/O Timings: read=9.334 -> Nested Loop (cost=1.88..86.62 rows=10 width=16) (actual time=9.476..9.481 rows=1 loops=1) Join Filter: (gi.TABLE_A_pk = ii.TABLE_A_pk) Buffers: shared hit=25 read=1 I/O Timings: read=9.334 -> Nested Loop (cost=1.31..80.32 rows=10 width=32) (actual time=0.097..0.101 rows=1 loops=1) Buffers: shared hit=21 -> Nested Loop (cost=0.88..75.43 rows=10 width=24) (actual time=0.079..0.082 rows=1 loops=1) Buffers: shared hit=17 -> 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.064..0.066 rows=1 loops=1) Index Cond: (TABLE_E_pk = ANY ($1)) Filter: (is_deleted = 'N'::bpchar) Buffers: shared hit=13 -> 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.014..0.014 rows=1 loops=1) Index Cond: (TABLE_E_pk = ar.TABLE_E_pk) Filter: (is_deleted = 'N'::bpchar) Buffers: shared hit=4 -> Index Scan using pk_TABLE_A on TABLE_A gi (cost=0.44..0.49 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=1) Index Cond: (TABLE_A_pk = gr.TABLE_A_pk) Filter: (is_deleted = 'N'::bpchar) Buffers: shared hit=4 -> Index Scan using ix_TABLE_C_mida on TABLE_C ii (cost=0.56..0.62 rows=1 width=8) (actual time=9.375..9.376 rows=1 loops=1) Index Cond: (TABLE_A_pk = gr.TABLE_A_pk) Filter: (is_deleted = 'N'::bpchar) Buffers: shared hit=4 read=1 I/O Timings: read=9.334 -> Index Scan using ix_TABLE_F_mida on TABLE_F ir (cost=0.56..0.62 rows=1 width=16) (actual time=0.031..0.031 rows=1 loops=1) Index Cond: (TABLE_D_pk = gr.TABLE_D_pk) Filter: (is_deleted = 'N'::bpchar) Buffers: shared hit=5 -> Index Scan using pk_TABLE_G on TABLE_G mr (cost=0.44..0.49 rows=1 width=16) (actual time=0.015..0.015 rows=1 loops=1) Index Cond: (TABLE_G_pk = ir.TABLE_G_pk) Filter: (is_deleted = 'N'::bpchar) Buffers: shared hit=4 -> Index Scan using ix_TABLE_O_mida on TABLE_O mi (cost=0.44..0.49 rows=1 width=8) (actual time=0.018..0.019 rows=1 loops=1) Index Cond: (TABLE_O_pk = mr.TABLE_O_pk) Filter: (is_deleted = 'N'::bpchar) Buffers: shared hit=4 -> 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.014..0.015 rows=1 loops=1) Index Cond: (TABLE_D_pk = gr.TABLE_D_pk) Filter: (is_deleted = 'N'::bpchar) Buffers: shared hit=4 -> 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.015..0.016 rows=1 loops=1) Index Cond: (TABLE_D_pk = gr.TABLE_D_pk) Filter: (is_deleted = 'N'::bpchar) Buffers: shared hit=4 -> 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.012..0.012 rows=0 loops=1) Index Cond: (TABLE_E_pk = ar.TABLE_E_pk) Filter: (is_deleted = 'N'::bpchar) Buffers: shared hit=3 -> 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.013..0.014 rows=1 loops=1) Index Cond: (TABLE_E_pk = ar.TABLE_E_pk) Filter: (is_deleted = 'N'::bpchar) Buffers: shared hit=4 -> 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.009..0.009 rows=0 loops=1) Index Cond: (TABLE_E_pk = ar.TABLE_E_pk) Filter: (is_deleted = 'N'::bpchar) Buffers: shared hit=3 -> 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.011..0.011 rows=0 loops=1) Index Cond: ((TABLE_G_pk = mr.TABLE_G_pk) AND (is_deleted = 'N'::bpchar)) Heap Fetches: 0 Buffers: shared hit=3 Settings: effective_cache_size = '43806080kB', maintenance_io_concurrency = '1', max_parallel_workers_per_gather = '8', random_page_cost = '1.79769', search_path = dbname, "$user", public', work_mem = '16GB' Planning: Buffers: shared hit=381 Planning Time: 129.736 ms Execution Time: 9.847 ms (104 rows)