AminPG Jaffer <aminjaffer.pg@xxxxxxxxx> writes: > Is there an explanation why it is using incorrect index? > SQL: > SELECT count(*) FROM tc WHERE ((tc.a_id = $1)) AND ((tc.m_id = $2)) AND > ((tc.ag_id is not null)) AND ((tc.id in ($3))) AND ((tc.pt in ($4, $5, $6))) What data types are these columns? For that matter, could we see the whole schema for the table (psql \d+ output or equivalent)? regards, tom lane
