Created
July 14, 2015 21:29
-
-
Save robbat2/ce7b151d06124d4f270b to your computer and use it in GitHub Desktop.
long metabib.suggest_browse_entries
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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