Solve Operating Trouble

Postgres

The engine perform a full scan rather than using defined indexed for plan execution. You have to add a ANALYZE command in a sql script, in a last step that enables to update postgres statistics to help determine the most efficient execution plans for queries.