Function ts_debug

Displays debugging information for the supplied text. This includes which configuration was used, how the text was parsed, and which dictionaries processed various tokens.

ts_debug(txt TEXT) RETURNS SETOF TSDEBUG

• 'txt' is the specific text to debug.

SELECT * FROM ts_debug('createdb creates a new PostgreSQL database.');
 
 ts_name | tok_type | description |   token    | dict_name |   tsvector
---------+----------+-------------+------------+-----------+--------------
 default | lword    | Latin word  | createdb   | {en_stem} | 'createdb'
 default | lword    | Latin word  | creates    | {en_stem} | 'creat'
 default | lword    | Latin word  | a          | {en_stem} |
 default | lword    | Latin word  | new        | {en_stem} | 'new'
 default | lword    | Latin word  | PostgreSQL | {en_stem} | 'postgresql'
 default | lword    | Latin word  | database   | {en_stem} | 'databas'
(6 rows)

SELECT set_curcfg('default_english');
 
 set_curcfg
------------

(1 row)

SELECT * FROM ts_debug('createdb creates a new PostgreSQL database.');
     
     ts_name     | tok_type | description |   token    |      dict_name      |   tsvector
-----------------+----------+-------------+------------+---------------------+--------------
 default_english | lword    | Latin word  | createdb   | {en_ispell,en_stem} | 'createdb'
 default_english | lword    | Latin word  | creates    | {en_ispell,en_stem} | 'create'
 default_english | lword    | Latin word  | a          | {en_ispell,en_stem} |
 default_english | lword    | Latin word  | new        | {en_ispell,en_stem} | 'new'
 default_english | lword    | Latin word  | PostgreSQL | {en_ispell,en_stem} | 'postgresql'
 default_english | lword    | Latin word  | database   | {en_ispell,en_stem} | 'database'
(6 rows)