Regarding query execution for long time - Mailing list pgsql-general

Select

distinct ltrim(rtrim(ssnumber)), CL.iInsightClientId, ltrim(rtrim(TFA.client_account_key)) as vchAccountNumber,

concat(TFA.first_name, ' ', TFA.last_name) as vchAccountName,

concat('AP:TIAA', TFA.routing_number) as vchRepLabel,

null as vchOpenDate, TFA.address1 as vchAccountTiteLine2,

TFA.address2 as vchAccountTitleLine3,null as vchAccountType,

TFA.address1 as vchPrimaryContact, 'TIAA-CREF' as Custodian,

TFA.routing_number as vchCustodian_RepId, null as vchCustodianRepName,

CONCAT ('TIAA-CREF:',ltrim(rtrim(client_account_key)),':', ltrim(rtrim(ssnumber))) as vchAccountKey,

null as vchFeedsAccountType

from accounts as TFA

join client3 as CL on ltrim(rtrim(Cl.vchssnumber))=ltrim(rtrim(TFA.ssnumber))

left join account3 as AC on ltrim(rtrim(AC."vchCustodianAccountNumber"))=ltrim(rtrim(TFA.client_account_key))

where AC."iInsightAccountID" is null;