Tobias Brox <tobias@nordicbet.com> writes:
> NBET=> explain select * from account_transaction where users_id=123456 order by created desc, id desc limit 10;
> We have indices on the users_id field and the (users_id, created)-tuple.
Neither of those indexes can provide the sort order the query is asking
for.
regards, tom lane