↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Functions

ts_stat

Executes the query, which must return a single tsvector column, and returns statistics about each distinct lexeme contained in the data. See Section 12.4.4 for details.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

group
textsearch
group label
文本搜索函数和操作符
lang
en
layout
table-new
pages
functions-textsearch.html
prose only
false

Definition PG 18

Executes the query, which must return a single tsvector column, and returns statistics about each distinct lexeme contained in the data. See Section 12.4.4 for details.

Signatures and overloads

ts_stat ( query text [, weights text] ) → setof record ( word text, ndoc integer, nentry integer ) → setof record
Executes the query, which must return a single tsvector column, and returns statistics about each distinct lexeme contained in the data. See Section 12.4.4 for details.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-textsearch.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"2383d74fd6eee4b71e1b97dec9754623081103120b67a9793f8deac5fff77727","version":"18.7"},{"file":"functions-textsearch.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"d8d1661c6d67bb109c5266be16236950471c11d91181aafa96e9055792c4fa78","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:a4754fc2a617a56092483e8cb66bfca51e994403679f60505a75076ebd8b37de

Text language: en · wiki-repair-20261023:a4754fc2a617a56092483e8cb66bfca51e994403679f60505a75076ebd8b37de