By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TEXT SEARCH DICTIONARY
CREATE TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH CONFIGURATION
CREATE TABLE
INSERT 0 3
| word | ndoc | nentry |
|---|---|---|
| title | 3 | 3 |
| user@gmail.com | 1 | 1 |
| umlaut | 1 | 1 |
| number | 1 | 1 |
| mondays | 1 | 1 |
| like | 1 | 1 |
| finally | 1 | 1 |
| dba.stackexchange.com | 1 | 1 |
| another | 1 | 1 |
| 3rd | 1 | 1 |
| wörd | 1 | 1 |
| 33 | 1 | 1 |
SELECT 12
| token | count |
|---|---|
| title | 3 |
| finally | 1 |
| like | 1 |
| another | 1 |
| number | 1 |
| umlaut | 1 |
| Mondays | 1 |
SELECT 7
| tokid | alias | description |
|---|---|---|
| 1 | asciiword | Word, all ASCII |
| 2 | word | Word, all letters |
| 3 | numword | Word, letters and digits |
| 4 | Email address | |
| 5 | url | URL |
| 6 | host | Host |
| 7 | sfloat | Scientific notation |
| 8 | version | Version number |
| 9 | hword_numpart | Hyphenated word part, letters and digits |
| 10 | hword_part | Hyphenated word part, all letters |
| 11 | hword_asciipart | Hyphenated word part, all ASCII |
| 12 | blank | Space symbols |
| 13 | tag | XML tag |
| 14 | protocol | Protocol head |
| 15 | numhword | Hyphenated word, letters and digits |
| 16 | asciihword | Hyphenated word, all ASCII |
| 17 | hword | Hyphenated word, all letters |
| 18 | url_path | URL path |
| 19 | file | File or path name |
| 20 | float | Decimal notation |
| 21 | int | Signed integer |
| 22 | uint | Unsigned integer |
| 23 | entity | XML entity |
SELECT 23
| tokid | alias | description | dictionary |
|---|---|---|---|
| 1 | asciiword | Word, all ASCII | english_simple_dict |
| 2 | word | Word, all letters | simple |
| 3 | numword | Word, letters and digits | simple |
| 4 | Email address | simple | |
| 5 | url | URL | simple |
| 6 | host | Host | simple |
| 7 | sfloat | Scientific notation | simple |
| 8 | version | Version number | simple |
| 9 | hword_numpart | Hyphenated word part, letters and digits | simple |
| 10 | hword_part | Hyphenated word part, all letters | simple |
| 11 | hword_asciipart | Hyphenated word part, all ASCII | simple |
| 15 | numhword | Hyphenated word, letters and digits | simple |
| 16 | asciihword | Hyphenated word, all ASCII | simple |
| 17 | hword | Hyphenated word, all letters | simple |
| 18 | url_path | URL path | simple |
| 19 | file | File or path name | simple |
| 20 | float | Decimal notation | simple |
| 21 | int | Signed integer | simple |
| 22 | uint | Unsigned integer | simple |
SELECT 19