Re: Incorrect index used in few cases..

Tom Lane <[email protected]> Tue, 18 Jun 2019 09:35:08 -0400

Newsgroups	gmane.comp.db.postgresql.performance
Message-ID	<[email protected]>

AminPG Jaffer <[email protected]> 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