Databases: optimizing Postgresql query with left join and indexes

Published --