EXPLAIN ANALYZE
SELECT contacts.id
FROM contacts
LEFT OUTER JOIN
(SELECT DISTINCT contacts_values.company_id AS company_id,
contacts_values.id AS id
FROM contacts_values
WHERE contacts_values.field_id = '\x000000000000000000000000'
AND contacts_values.field_name = 'twitter'
AND nimble_contact_value_normalize(contacts_values.value) = nimble_contact_value_normalize('devonzuegel')
AND length(contacts_values.value) < 1024) AS anon_2
ON contacts.company_id = '\x4c2118ad54397f271b000000' AND anon_2.company_id = contacts.company_id AND anon_2.id = contacts.id
LEFT OUTER JOIN
(SELECT DISTINCT contacts_values.company_id AS company_id,
contacts_values.id AS id
FROM contacts_values
WHERE contacts_values.field_id = '\x000000000000000000000000'
AND contacts_values.field_name = 'first_name'
AND nimble_contact_value_normalize(contacts_values.value) = nimble_contact_value_normalize('Devon@devonzuegel')
AND length(contacts_values.value) < 1024) AS anon_1
ON anon_1.company_id = contacts.company_id AND anon_1.id = contacts.id
LEFT OUTER JOIN contacts__aggregated AS contacts__aggregated_1
ON contacts__aggregated_1.company_id = contacts.company_id
AND contacts__aggregated_1.contact_id = contacts.id
AND contacts__aggregated_1.field_name = 'names'
AND contacts__aggregated_1.contact_id is not null
AND contacts__aggregated_1.value = nimble_contact_value_normalize('Devon')
WHERE anon_1.id IS NOT NULL OR anon_2.id IS NOT NULL
LIMIT 30
OFFSET 0