Hello, Okay, thank you very much, Mr. David, for your support and the information, Eşref To: Eşref Halıcıoğlu (esref.halicio...@primeit.com.tr);Cc: pgsql-general@lists.postgresql.org;Subject: About PostgreSQL Query Plan;14.01.2025, 13:09, "David Rowley" :On Tue, 14 Jan
would be very grateful if you could help me. Thank you, Eşref Halıcıoğlu To: Eşref Halıcıoğlu (esref.halicio...@primeit.com.tr);Cc: pgsql-general@lists.postgresql.org;Subject: About PostgreSQL Query Plan;13.01.2025, 19:56, "hubert depesz lubaczewski" :On Mon, Jan 13, 2025 at
xecuted) Index Cond: (("Col1" = tmp."Col2") AND ("Col3" >= (CURRENT_DATE - '3 mons'::interval)) AND ("Col3" <= CURRENT_DATE)) Filter: ((NOT "IsDeleted") AND ("Col4" = tmp."Col5"
_DATE - '3 mons'::interval)) AND ("col2" <= CURRENT_DATE)) Filter: ((NOT "col_deleted") AND ("col3" = temp."col_temp3")) -> Index Scan using test_table1_partition_2024_12_pkey on test_table1_partition_2024_12 tt1_sub3 (cost=0.43..4.34 rows=1 width=38) Index Cond: (("col1" = temp."col_temp1") AND ("col2" >= (CURRENT_DATE - '3 mons'::interval)) AND ("col2" <= CURRENT_DATE)) Filter: ((NOT "col_deleted") AND ("col3" = temp."col_temp3")) -> Index Scan using test_table1_partition_2025_01_pkey on test_table1_partition_2025_01 tt1_sub4 (cost=0.43..3.72 rows=1 width=38) Index Cond: (("col1" = temp."col_temp1") AND ("col2" >= (CURRENT_DATE - '3 mons'::interval)) AND ("col2" <= CURRENT_DATE)) Filter: ((NOT "col_deleted") AND ("col3" = temp."col_temp3")) Thank you, Eşref Halıcıoğlu --
