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