Databases: Postgres query not using indexes with conditions from multiple tables

Published --