Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Slow & Semi-Accurate Full-Text Search in PostgreSQL
SELECT story_url, count(*) as count, max(updated_at) as updated_at
FROM "comments"
WHERE ("comments"."updated_at" BETWEEN '2018-01-01' AND '2018-07-06')
AND (comment_text LIKE '%google%')
GROUP BY story_url, story_title HAVING (count(*) > '7')
ORDER BY count DESC LIMIT 15;
Planning time: 0.472 ms
Execution time: 42839.333 ms
/* WHERE ("comments"."updated_at" BETWEEN '2018-07-01' AND '2018-07-06') */
https://medium.com/@serverpunch/why-you-should-not-use-google-cloud-75ea2aec00de | 34 |
2018-07-01 01:39:39 | 2018-07-01 12:30:09
https://github.com/harababurel/gcsf | 9 | 2018-07-01 02:35:09 | 2018-07-01 17:30:11
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.