Man I was cooking the DB's CPU with an index typo.

CREATE INDEX IF NOT EXISTS some_idx ON some_table(some_value DESC NULLS LAST) is NOT equivalent to CREATE INDEX IF NOT EXISTS some_idx ON some_table(some_value DESC).