Feb 22, 2019 · I have a simple query like select * from xxx where col is not null limit 10.I don't know why Postgres prefer seq scan which is much slower than partial index (I have analyzed …