Guest User

Untitled

a guest
Jul 17th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. explain analyze SELECT distinct on (documents.id) documents.* FROM "documents" INNER JOIN "full_text" ON full_text.document_id = documents.id WHERE (to_tsvector('english', full_text.text) @@ plainto_tsquery(E'george bush'));
  2. QUERY PLAN
  3. ------------------------------------------------------------------------------------------------------------------------------------------------------------
  4. Unique (cost=0.00..22.83 rows=1 width=462) (actual time=82.013..5671.701 rows=19 loops=1)
  5. -> Nested Loop (cost=0.00..22.83 rows=1 width=462) (actual time=82.008..5671.630 rows=19 loops=1)
  6. -> Index Scan using index_full_text_on_document_id on full_text (cost=0.00..14.55 rows=1 width=4) (actual time=81.995..5671.347 rows=19 loops=1)
  7. Filter: (to_tsvector('english'::regconfig, text) @@ plainto_tsquery('george bush'::text))
  8. -> Index Scan using documents_pkey on documents (cost=0.00..8.27 rows=1 width=462) (actual time=0.008..0.009 rows=1 loops=19)
  9. Index Cond: (documents.id = full_text.document_id)
  10. Total runtime: 5671.778 ms
  11. (7 rows)
Add Comment
Please, Sign In to add comment