Skip to content

Instantly share code, notes, and snippets.

@syntaxTerr0r

syntaxTerr0r/pg_search_slow.psql

Last active October 28, 2016 01:14
Show Gist options
  • Save syntaxTerr0r/14324302a459df9322ac74cd914e4626 to your computer and use it in GitHub Desktop.
Save syntaxTerr0r/14324302a459df9322ac74cd914e4626 to your computer and use it in GitHub Desktop.
Download ZIP
pg_search slow query on RDS
Raw
pg_search_slow.psql
SELECT "pg_search_documents".*
FROM "pg_search_documents"
INNER JOIN (
SELECT "pg_search_documents"."id" AS pg_search_id, (ts_rank((to_tsvector('simple',
unaccent(coalesce("pg_search_documents"."content"::text, '')))), (to_tsquery('simple', ''' ' || unaccent('XXX') || ' ''' ||
':*')), 0)) AS rank
FROM "pg_search_documents"
WHERE (((to_tsvector('simple', unaccent(coalesce("pg_search_documents"."content"::text, '')))) @@ (to_tsquery('simple', ''' ' || unaccent('XXX') || ' ''' || ':*'))))
) AS pg_search_ce9b9dd18c5c0023f2116f
ON "pg_search_documents"."id" = pg_search_ce9b9dd18c5c0023f2116f.pg_search_id
WHERE "pg_search_documents"."searchable_type" = 'Mission'
ORDER BY pg_search_ce9b9dd18c5c0023f2116f.rank DESC, "pg_search_documents"."id" ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment