Skip to content

Instantly share code, notes, and snippets.

@robbat2
Created July 14, 2015 21:29
Show Gist options
  • Select an option

  • Save robbat2/ce7b151d06124d4f270b to your computer and use it in GitHub Desktop.

Select an option

Save robbat2/ce7b151d06124d4f270b to your computer and use it in GitHub Desktop.
long metabib.suggest_browse_entries
evergreen=# EXPLAIN ANALYZE VERBOSE SELECT * FROM metabib.suggest_browse_entries( 'empires', 'keyword', 'StartSel="<span class=''oils_AS''>", StopSel=</span>', '75', '10', '14' ) AS "metabib.suggest_browse_entries" ;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Function Scan on metabib.suggest_browse_entries "metabib.suggest_browse_entries" (cost=0.25..10.25 rows=1000 width=79) (actual time=70389.925..70389.928 rows=10 loops=1)
Output: value, field, buoyant_and_class_match, field_match, field_weight, rank, buoyant, match
Function Call: metabib.suggest_browse_entries('empires'::text, 'keyword'::text, 'StartSel="<span class=''oils_AS''>", StopSel=</span>'::text, 75, 10, 14)
Planning time: 0.036 ms
Execution time: 70389.959 ms
(5 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment