SQL : Postgres query running very slow

Published --