Skip to content

Instantly share code, notes, and snippets.

@ridhoperdana

ridhoperdana/test-result-fts-govtech.md

Created October 14, 2022 07:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ridhoperdana/1cb27495acdbd1c9fd73b8d4156702ed to your computer and use it in GitHub Desktop.
Save ridhoperdana/1cb27495acdbd1c9fd73b8d4156702ed to your computer and use it in GitHub Desktop.
Download ZIP
test result fts govtech
Raw
test-result-fts-govtech.md
query use index planning time exec time
where name ilike '%Shandeigh%'; false <=0.1ms ~300ms
where name ilike '%Shandeigh%'; true ~0.1ms 0.05ms < x < 0.1ms
where name ilike '%Shandeigh%' and created_at > '2022-07-01 08:41:14.515 +0700'; true ~0.1ms 0.05ms < x < 0.1ms
where ts @@ to_tsquery('Shandeigh'); false <= 0.09ms ~700ms
where ts @@ to_tsquery('Shandeigh'); true ~0.1ms ~0.05ms
where ts @@ to_tsquery('Shandeigh') and created_at > '2022-07-01 08:41:14.515 +0700'; true ~0.1ms ~0.05ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment