Previous   Next 

Function stat

For a tsvector column in a table, returns the distinct words along with their frequency. This includes the number of documents (table rows) containing a word and the number of entries for a word which includes multiple occurrences within a row.

stat(txt TEXT) RETURNS SETOF STATINFO

  • 'txt' is a select statement that selects a tsvector column from a table. 
SELECT * 
FROM stat('SELECT ts_vec FROM ts_readme') 
ORDER BY ndoc desc, word 
LIMIT 5;
   
   word   | ndoc | nentry
----------+------+--------
 tsearch  |   18 |     21
 document |   17 |     19
 search   |   17 |     17
 index    |   15 |     15
 use      |   15 |     15
(5 rows)