array.Contains(x) run without using pg indexes

[PDarkTemplar]

We have code like this:

var values = data.ToArray(); // [1,2,3]
var res = DbSet<Call>.Where(x => values.Contains(x.Id));

and efcore.pg 3.1 generating sql like this:

select * from calls where COALESCE(id = ANY ([1,2,3]), FALSE)) 

plus sometimes

and array_position(....) is null

Because of COALESCE, pg running fullscan without using id index.
We have around 400 mil rows in partitioned Call table.

In efcore.pg 3.0 when there was IN clause pg was using indexes and all was fine.

[PDarkTemplar]

found in #1152