概要
ParadeDBというソフトウェアがあります。
参考: https://www.paradedb.com/
Elasticsearchなどの外部サーバーを利用せず、PostgreSQLだけで全文検索や分析機能を実現するためのものです。
（詳細は公式ページをご覧ください。）
最近、pg_bigmとpg_trgmとPGroongaの全文検索の性能をざっくり検証したので、ParadeDBでも同様に検証してみる試みです。
さっそく結論: 測定結果
最近、pg_bigmとpg_trgmとPGroongaの全文検索の性能をざっくり検証したのと、ほぼ同様の検証を行いました。
が、今回はDokceで検証していたり（= ↑の時とは違う環境）だったり、得られる結果がトークナイザーによってだいぶ違ったりするので、参考程度にご覧ください。
トークナイザーが何個かあって、トークナイザーによってヒットするデータが変わるので次の3つで試します。
- 何も指定しないデフォルト
- Ngram
{"type": "ngram", "min_gram": 1, "max_gram": 2, "prefix_only": false}- これら に近いヒット状況
- 「Ngram 1-2」と表記
- Ngram
{"type": "ngram", "min_gram": 2, "max_gram": 3, "prefix_only": false}- これら に近いヒット状況
- ただし「象」とか1文字で検索するとヒットせず
- 「Ngram 2-3」と表記
インデックスの作成時間とサイズ
| Tokenizer | create index | index size |
|---|---|---|
| default | 約2.5分 | 6963 MB |
| Ngram 1-2 | 約7分 | 5872 MB |
| Ngram 2-3 | 約14.5分 | 17 GB |
日本語の検索
10回selectした結果の中央値:
| Tokenizer | 象 | 東京 | 技術者 | ロケット | データベース |
|---|---|---|---|---|---|
| default | 5.8435 ms | 11.783 ms | 6.5745 ms | 6.95149 ms | 8.2265 ms |
| Ngram 1-2 | 17.273 ms | 83.386 ms | 13.7545 ms | 23.7685 ms | 45.387 ms |
| Ngram 2-3 | 0.5885 ms | 50.0259 ms | 11.129 ms | 17.9755 ms | 29.3925 ms |
アルファベットで検索
10回selectした結果の中央値:
| Tokenizer | DB | test | PostgreSQL |
|---|---|---|---|
| default | 10.5045 ms | 7.919 ms | 5.2555 ms |
| Ngram 1-2 | 61.6325 ms | 706.0535 ms | 30.137 ms |
| Ngram 2-3 | 30.7545 ms | 103.7179 ms | 23.7995 ms |
まとめ
速度の検証ということで、得られる結果についてはほぼ追求していないですが、ヒットした件数を見る限り、トークナイザーの設定によってだいぶ変わるっぽいです。
速度だけに注目するとだいぶ速い感じはしますが、トークナイザーをうまく設定しないと雑音が多くて得たい結果が得られなさそうな雰囲気を感じました。
以降にどのように確認したか掲載します。
準備
ParadeDBありのPostgreSQLを起動
Dockerでお手軽に試せるっぽいので、それを活用します。
docker container run --rm \
--name paradedb \
-e POSTGRES_USER=user \
-e POSTGRES_PASSWORD=password \
-e POSTGRES_DB=test \
-v paradedb_data:/var/lib/postgresql/data \
-v ${PWD}:/mydata \
-d \
paradedb/paradedb:latest
参考: https://docs.paradedb.com/documentation/getting-started/install
- ユーザ名とかは少し変えました
- インポート用のデータを
${PWD}に置いているので、-v ${PWD}:/mydataを追加 - コンテナ内の
psqlを使ってlocalhostにつなぐので-p 5432:5432はなし
データのインポート
使うスキーマとデータは これ で作ったデータです。
docker exec -it -e PGPASSWORD=password paradedb bash -c 'psql -U user -d test < /mydata/schema.postgresql.sql'
docker exec -it -e PGPASSWORD=password paradedb bash -c 'psql -U user -d test < /mydata/ja-all-pages.sql'
ざっくり測定
実行したコマンドと結果を記載します。
トークナイザーが何個かあって、トークナイザーによってヒットするデータが変わるので次の3つで試します。
- 何も指定しないデフォルト
- Ngram
{"type": "ngram", "min_gram": 1, "max_gram": 2, "prefix_only": false}- これら に近いヒット状況
- Ngram
{"type": "ngram", "min_gram": 2, "max_gram": 3, "prefix_only": false}- これら に近いヒット状況
- ただし「象」とか1文字で検索するとヒットせず
参考: https://docs.paradedb.com/documentation/indexing/tokenizers
Tokenizer: デフォルト
#!/usr/bin/bash
function run_select() {
query=$1
echo "= ${query} ===============================================" 1>&2
explain_commands=()
for i in {1..10}; do
explain_commands+=("--command" "explain analyze select count(*) from wikipedia where text @@@ '${query}';")
done
result=$(docker exec -it -e PGPASSWORD=password paradedb psql -U user -d test \
--command "set max_parallel_workers_per_gather = 0" \
--command "set work_mem = '16MB'" \
--command "\pset pager off" \
--command "\timing" \
"${explain_commands[@]}")
echo "${result}" 1>&2
total=$(echo "${result}" | grep '^Time:' | awk '{ total += $2 } END { print total }')
echo "Query: ${query}, Total ${total} ms"
}
docker exec -it -e PGPASSWORD=password paradedb psql -U user -d test \
--command "drop index if exists wikipedia_index" \
--command "set maintenance_work_mem = '8GB'" \
--command "\timing" \
--command "create index wikipedia_index on wikipedia using bm25 (id, title, text) with (key_field='id');"
run_select "象"
run_select "東京"
run_select "技術者"
run_select "ロケット"
run_select "データベース"
run_select "DB"
run_select "test"
run_select "PostgreSQL"
docker exec -it -e PGPASSWORD=password paradedb psql -U user -d test \
--command "select pg_size_pretty(pg_relation_size('wikipedia_index'));"
$ ./article/run-paradedb-default.sh 2> log
NOTICE: index "wikipedia_index" does not exist, skipping
DROP INDEX
SET
Timing is on.
WARNING: only 2 parallel workers were available for index build
DETAIL: for large tables, increasing the number of workers can reduce the time it takes to build the index
HINT: `SET max_parallel_maintenance_workers = <number>`
CREATE INDEX
Time: 147363.442 ms (02:27.363)
Query: 象, Total 79.383 ms
Query: 東京, Total 143.384 ms
Query: 技術者, Total 78.737 ms
Query: ロケット, Total 87.016 ms
Query: データベース, Total 98.855 ms
Query: DB, Total 125.364 ms
Query: test, Total 92.506 ms
Query: PostgreSQL, Total 67.919 ms
pg_size_pretty
----------------
6963 MB
(1 row)
log
= 象 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=26.54..26.55 rows=1 width=8) (actual time=20.122..20.124 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..21.02 rows=2205 width=0) (actual time=1.192..20.087 rows=984 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 103
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 4.611 ms
Execution Time: 20.290 ms
(11 rows)
Time: 28.165 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=26.54..26.55 rows=1 width=8) (actual time=5.023..5.024 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..21.02 rows=2205 width=0) (actual time=0.256..4.998 rows=984 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 103
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.581 ms
Execution Time: 5.153 ms
(11 rows)
Time: 5.833 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=26.54..26.55 rows=1 width=8) (actual time=4.681..4.682 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..21.02 rows=2205 width=0) (actual time=0.252..4.657 rows=984 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 103
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.468 ms
Execution Time: 4.808 ms
(11 rows)
Time: 5.359 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=26.54..26.55 rows=1 width=8) (actual time=5.168..5.169 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..21.02 rows=2205 width=0) (actual time=0.254..5.140 rows=984 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 103
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.459 ms
Execution Time: 5.305 ms
(11 rows)
Time: 5.854 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=26.54..26.55 rows=1 width=8) (actual time=4.947..4.948 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..21.02 rows=2205 width=0) (actual time=0.295..4.922 rows=984 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 103
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.547 ms
Execution Time: 5.073 ms
(11 rows)
Time: 5.718 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=26.54..26.55 rows=1 width=8) (actual time=4.439..4.439 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..21.02 rows=2205 width=0) (actual time=0.230..4.415 rows=984 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 103
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.472 ms
Execution Time: 4.568 ms
(11 rows)
Time: 5.125 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=26.54..26.55 rows=1 width=8) (actual time=5.153..5.159 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..21.02 rows=2205 width=0) (actual time=0.236..5.130 rows=984 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 103
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.464 ms
Execution Time: 5.304 ms
(11 rows)
Time: 5.866 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=26.54..26.55 rows=1 width=8) (actual time=5.166..5.167 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..21.02 rows=2205 width=0) (actual time=0.302..5.139 rows=984 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 103
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.559 ms
Execution Time: 5.301 ms
(11 rows)
Time: 5.963 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=26.54..26.55 rows=1 width=8) (actual time=4.639..4.639 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..21.02 rows=2205 width=0) (actual time=0.283..4.612 rows=984 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 103
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.487 ms
Execution Time: 4.837 ms
(11 rows)
Time: 5.416 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=26.54..26.55 rows=1 width=8) (actual time=5.354..5.354 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..21.02 rows=2205 width=0) (actual time=0.301..5.326 rows=984 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 103
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.482 ms
Execution Time: 5.506 ms
(11 rows)
Time: 6.084 ms
= 東京 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=698.88..698.89 rows=1 width=8) (actual time=34.865..34.866 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..469.25 rows=91851 width=0) (actual time=1.105..33.562 rows=59606 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 8781
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 2.294 ms
Execution Time: 35.020 ms
(11 rows)
Time: 37.697 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=698.88..698.89 rows=1 width=8) (actual time=11.114..11.115 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..469.25 rows=91851 width=0) (actual time=0.238..10.020 rows=59606 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 8781
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.588 ms
Execution Time: 11.239 ms
(11 rows)
Time: 11.959 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=698.88..698.89 rows=1 width=8) (actual time=11.073..11.074 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..469.25 rows=91851 width=0) (actual time=0.302..9.967 rows=59606 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 8781
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.463 ms
Execution Time: 11.200 ms
(11 rows)
Time: 11.766 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=698.88..698.89 rows=1 width=8) (actual time=11.160..11.161 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..469.25 rows=91851 width=0) (actual time=0.243..10.065 rows=59606 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 8781
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.394 ms
Execution Time: 11.281 ms
(11 rows)
Time: 11.800 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=698.88..698.89 rows=1 width=8) (actual time=10.973..10.974 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..469.25 rows=91851 width=0) (actual time=0.233..9.870 rows=59606 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 8781
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.407 ms
Execution Time: 11.097 ms
(11 rows)
Time: 11.628 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=698.88..698.89 rows=1 width=8) (actual time=10.903..10.904 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..469.25 rows=91851 width=0) (actual time=0.267..9.812 rows=59606 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 8781
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.476 ms
Execution Time: 11.022 ms
(11 rows)
Time: 11.583 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=698.88..698.89 rows=1 width=8) (actual time=11.216..11.217 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..469.25 rows=91851 width=0) (actual time=0.234..10.116 rows=59606 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 8781
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.361 ms
Execution Time: 11.340 ms
(11 rows)
Time: 11.837 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=698.88..698.89 rows=1 width=8) (actual time=11.180..11.181 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..469.25 rows=91851 width=0) (actual time=0.309..10.064 rows=59606 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 8781
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.510 ms
Execution Time: 11.309 ms
(11 rows)
Time: 11.947 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=698.88..698.89 rows=1 width=8) (actual time=10.789..10.790 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..469.25 rows=91851 width=0) (actual time=0.292..9.694 rows=59606 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 8781
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.411 ms
Execution Time: 10.908 ms
(11 rows)
Time: 11.406 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=698.88..698.89 rows=1 width=8) (actual time=11.170..11.171 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..469.25 rows=91851 width=0) (actual time=0.295..10.044 rows=59606 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 8781
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.360 ms
Execution Time: 11.302 ms
(11 rows)
Time: 11.761 ms
= 技術者 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=50.73..50.74 rows=1 width=8) (actual time=16.693..16.694 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..37.16 rows=5431 width=0) (actual time=1.177..16.590 rows=3469 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 568
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 2.434 ms
Execution Time: 16.872 ms
(11 rows)
Time: 19.587 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=50.73..50.74 rows=1 width=8) (actual time=6.278..6.279 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..37.16 rows=5431 width=0) (actual time=0.257..6.194 rows=3469 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 568
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.544 ms
Execution Time: 6.441 ms
(11 rows)
Time: 7.107 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=50.73..50.74 rows=1 width=8) (actual time=5.817..5.818 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..37.16 rows=5431 width=0) (actual time=0.256..5.736 rows=3469 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 568
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.478 ms
Execution Time: 5.947 ms
(11 rows)
Time: 6.660 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=50.73..50.74 rows=1 width=8) (actual time=5.731..5.732 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..37.16 rows=5431 width=0) (actual time=0.247..5.653 rows=3469 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 568
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.438 ms
Execution Time: 5.874 ms
(11 rows)
Time: 6.409 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=50.73..50.74 rows=1 width=8) (actual time=6.101..6.101 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..37.16 rows=5431 width=0) (actual time=0.338..6.026 rows=3469 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 568
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.534 ms
Execution Time: 6.252 ms
(11 rows)
Time: 6.961 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=50.73..50.74 rows=1 width=8) (actual time=5.506..5.507 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..37.16 rows=5431 width=0) (actual time=0.247..5.435 rows=3469 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 568
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.408 ms
Execution Time: 5.641 ms
(11 rows)
Time: 6.135 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=50.73..50.74 rows=1 width=8) (actual time=5.750..5.751 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..37.16 rows=5431 width=0) (actual time=0.242..5.672 rows=3469 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 568
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.496 ms
Execution Time: 5.895 ms
(11 rows)
Time: 6.489 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=50.73..50.74 rows=1 width=8) (actual time=5.378..5.379 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..37.16 rows=5431 width=0) (actual time=0.248..5.303 rows=3469 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 568
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.476 ms
Execution Time: 5.523 ms
(11 rows)
Time: 6.114 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=50.73..50.74 rows=1 width=8) (actual time=5.640..5.641 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..37.16 rows=5431 width=0) (actual time=0.255..5.565 rows=3469 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 568
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.476 ms
Execution Time: 5.787 ms
(11 rows)
Time: 6.379 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=50.73..50.74 rows=1 width=8) (actual time=6.085..6.086 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..37.16 rows=5431 width=0) (actual time=0.269..6.003 rows=3469 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 568
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.546 ms
Execution Time: 6.240 ms
(11 rows)
Time: 6.896 ms
= ロケット ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=54.04..54.05 rows=1 width=8) (actual time=16.460..16.461 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..39.36 rows=5872 width=0) (actual time=1.201..16.333 rows=4272 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 472
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 2.714 ms
Execution Time: 16.638 ms
(11 rows)
Time: 19.738 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=54.04..54.05 rows=1 width=8) (actual time=11.216..11.217 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..39.36 rows=5872 width=0) (actual time=0.470..11.043 rows=4272 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 472
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.893 ms
Execution Time: 11.475 ms
(11 rows)
Time: 12.542 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=54.04..54.05 rows=1 width=8) (actual time=6.187..6.187 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..39.36 rows=5872 width=0) (actual time=0.305..6.085 rows=4272 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 472
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.847 ms
Execution Time: 6.396 ms
(11 rows)
Time: 7.488 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=54.04..54.05 rows=1 width=8) (actual time=6.045..6.046 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..39.36 rows=5872 width=0) (actual time=0.251..5.940 rows=4272 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 472
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.413 ms
Execution Time: 6.179 ms
(11 rows)
Time: 6.689 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=54.04..54.05 rows=1 width=8) (actual time=5.744..5.745 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..39.36 rows=5872 width=0) (actual time=0.263..5.648 rows=4272 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 472
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.539 ms
Execution Time: 5.880 ms
(11 rows)
Time: 6.534 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=54.04..54.05 rows=1 width=8) (actual time=5.737..5.737 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..39.36 rows=5872 width=0) (actual time=0.257..5.640 rows=4272 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 472
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.424 ms
Execution Time: 5.878 ms
(11 rows)
Time: 6.389 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=54.04..54.05 rows=1 width=8) (actual time=6.212..6.213 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..39.36 rows=5872 width=0) (actual time=0.268..6.114 rows=4272 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 472
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.444 ms
Execution Time: 6.350 ms
(11 rows)
Time: 6.888 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=54.04..54.05 rows=1 width=8) (actual time=5.929..5.929 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..39.36 rows=5872 width=0) (actual time=0.268..5.833 rows=4272 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 472
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.512 ms
Execution Time: 6.075 ms
(11 rows)
Time: 6.701 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=54.04..54.05 rows=1 width=8) (actual time=6.231..6.231 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..39.36 rows=5872 width=0) (actual time=0.290..6.131 rows=4272 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 472
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.506 ms
Execution Time: 6.421 ms
(11 rows)
Time: 7.032 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=54.04..54.05 rows=1 width=8) (actual time=6.202..6.203 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..39.36 rows=5872 width=0) (actual time=0.325..6.104 rows=4272 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 472
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.507 ms
Execution Time: 6.392 ms
(11 rows)
Time: 7.015 ms
= データベース ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=65.52..65.53 rows=1 width=8) (actual time=19.609..19.611 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..47.01 rows=7403 width=0) (actual time=1.602..19.449 rows=5421 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 817
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 3.898 ms
Execution Time: 19.842 ms
(11 rows)
Time: 24.257 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=65.52..65.53 rows=1 width=8) (actual time=7.740..7.741 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..47.01 rows=7403 width=0) (actual time=0.344..7.597 rows=5421 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 817
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.662 ms
Execution Time: 7.923 ms
(11 rows)
Time: 8.842 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=65.52..65.53 rows=1 width=8) (actual time=7.876..7.877 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..47.01 rows=7403 width=0) (actual time=0.333..7.744 rows=5421 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 817
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.580 ms
Execution Time: 8.051 ms
(11 rows)
Time: 8.873 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=65.52..65.53 rows=1 width=8) (actual time=7.162..7.163 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..47.01 rows=7403 width=0) (actual time=0.316..7.031 rows=5421 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 817
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.621 ms
Execution Time: 7.324 ms
(11 rows)
Time: 8.153 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=65.52..65.53 rows=1 width=8) (actual time=7.196..7.197 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..47.01 rows=7403 width=0) (actual time=0.308..7.074 rows=5421 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 817
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.517 ms
Execution Time: 7.360 ms
(11 rows)
Time: 8.119 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=65.52..65.53 rows=1 width=8) (actual time=7.151..7.153 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..47.01 rows=7403 width=0) (actual time=0.325..7.023 rows=5421 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 817
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.608 ms
Execution Time: 7.301 ms
(11 rows)
Time: 8.300 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=65.52..65.53 rows=1 width=8) (actual time=7.275..7.276 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..47.01 rows=7403 width=0) (actual time=0.319..7.156 rows=5421 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 817
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.572 ms
Execution Time: 7.435 ms
(11 rows)
Time: 8.339 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=65.52..65.53 rows=1 width=8) (actual time=6.957..6.957 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..47.01 rows=7403 width=0) (actual time=0.316..6.843 rows=5421 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 817
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.608 ms
Execution Time: 7.102 ms
(11 rows)
Time: 7.912 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=65.52..65.53 rows=1 width=8) (actual time=7.071..7.072 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..47.01 rows=7403 width=0) (actual time=0.284..6.961 rows=5421 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 817
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.559 ms
Execution Time: 7.227 ms
(11 rows)
Time: 8.017 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=65.52..65.53 rows=1 width=8) (actual time=6.958..6.959 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..47.01 rows=7403 width=0) (actual time=0.360..6.848 rows=5421 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 817
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.675 ms
Execution Time: 7.122 ms
(11 rows)
Time: 8.043 ms
= DB ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=464.61..464.62 rows=1 width=8) (actual time=27.205..27.205 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..313.07 rows=60615 width=0) (actual time=1.249..26.469 rows=33401 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6675
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 2.793 ms
Execution Time: 27.414 ms
(11 rows)
Time: 30.692 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=464.61..464.62 rows=1 width=8) (actual time=10.238..10.239 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..313.07 rows=60615 width=0) (actual time=0.261..9.598 rows=33401 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6675
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.605 ms
Execution Time: 10.408 ms
(11 rows)
Time: 11.156 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=464.61..464.62 rows=1 width=8) (actual time=9.790..9.791 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..313.07 rows=60615 width=0) (actual time=0.241..9.155 rows=33401 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6675
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.417 ms
Execution Time: 9.980 ms
(11 rows)
Time: 10.590 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=464.61..464.62 rows=1 width=8) (actual time=9.596..9.597 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..313.07 rows=60615 width=0) (actual time=0.280..8.961 rows=33401 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6675
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.467 ms
Execution Time: 9.711 ms
(11 rows)
Time: 10.309 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=464.61..464.62 rows=1 width=8) (actual time=8.958..8.959 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..313.07 rows=60615 width=0) (actual time=0.216..8.307 rows=33401 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6675
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.394 ms
Execution Time: 9.167 ms
(11 rows)
Time: 9.693 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=464.61..464.62 rows=1 width=8) (actual time=9.450..9.451 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..313.07 rows=60615 width=0) (actual time=0.219..8.827 rows=33401 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6675
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.420 ms
Execution Time: 9.622 ms
(11 rows)
Time: 10.171 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=464.61..464.62 rows=1 width=8) (actual time=9.765..9.765 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..313.07 rows=60615 width=0) (actual time=0.254..9.123 rows=33401 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6675
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.347 ms
Execution Time: 9.939 ms
(11 rows)
Time: 10.419 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=464.61..464.62 rows=1 width=8) (actual time=9.517..9.518 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..313.07 rows=60615 width=0) (actual time=0.225..8.879 rows=33401 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6675
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.420 ms
Execution Time: 9.739 ms
(11 rows)
Time: 10.377 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=464.61..464.62 rows=1 width=8) (actual time=9.794..9.795 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..313.07 rows=60615 width=0) (actual time=0.315..9.177 rows=33401 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6675
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.472 ms
Execution Time: 9.975 ms
(11 rows)
Time: 10.627 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=464.61..464.62 rows=1 width=8) (actual time=10.381..10.381 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..313.07 rows=60615 width=0) (actual time=0.257..9.751 rows=33401 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6675
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.465 ms
Execution Time: 10.569 ms
(11 rows)
Time: 11.330 ms
= test ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=90.06..90.07 rows=1 width=8) (actual time=19.060..19.061 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..63.38 rows=10675 width=0) (actual time=1.164..18.817 rows=8909 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 1678
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 2.400 ms
Execution Time: 19.223 ms
(11 rows)
Time: 21.925 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=90.06..90.07 rows=1 width=8) (actual time=7.375..7.376 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..63.38 rows=10675 width=0) (actual time=0.291..7.149 rows=8909 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 1678
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.607 ms
Execution Time: 7.511 ms
(11 rows)
Time: 8.223 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=90.06..90.07 rows=1 width=8) (actual time=7.585..7.586 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..63.38 rows=10675 width=0) (actual time=0.326..7.366 rows=8909 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 1678
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.421 ms
Execution Time: 7.750 ms
(11 rows)
Time: 8.303 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=90.06..90.07 rows=1 width=8) (actual time=7.268..7.268 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..63.38 rows=10675 width=0) (actual time=0.324..7.059 rows=8909 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 1678
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.576 ms
Execution Time: 7.405 ms
(11 rows)
Time: 8.089 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=90.06..90.07 rows=1 width=8) (actual time=7.512..7.512 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..63.38 rows=10675 width=0) (actual time=0.325..7.286 rows=8909 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 1678
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.471 ms
Execution Time: 7.646 ms
(11 rows)
Time: 8.295 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=90.06..90.07 rows=1 width=8) (actual time=6.817..6.818 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..63.38 rows=10675 width=0) (actual time=0.272..6.616 rows=8909 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 1678
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.473 ms
Execution Time: 6.945 ms
(11 rows)
Time: 7.595 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=90.06..90.07 rows=1 width=8) (actual time=6.966..6.967 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..63.38 rows=10675 width=0) (actual time=0.280..6.763 rows=8909 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 1678
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.433 ms
Execution Time: 7.091 ms
(11 rows)
Time: 7.749 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=90.06..90.07 rows=1 width=8) (actual time=6.632..6.632 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..63.38 rows=10675 width=0) (actual time=0.268..6.430 rows=8909 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 1678
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.458 ms
Execution Time: 6.754 ms
(11 rows)
Time: 7.387 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=90.06..90.07 rows=1 width=8) (actual time=6.590..6.591 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..63.38 rows=10675 width=0) (actual time=0.250..6.397 rows=8909 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 1678
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.451 ms
Execution Time: 6.718 ms
(11 rows)
Time: 7.363 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=90.06..90.07 rows=1 width=8) (actual time=6.770..6.770 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..63.38 rows=10675 width=0) (actual time=0.232..6.587 rows=8909 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 1678
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.482 ms
Execution Time: 6.891 ms
(11 rows)
Time: 7.577 ms
= PostgreSQL ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=12.96..12.97 rows=1 width=8) (actual time=15.226..15.227 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..11.97 rows=395 width=0) (actual time=1.489..15.212 rows=243 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 31
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 3.700 ms
Execution Time: 15.441 ms
(11 rows)
Time: 19.523 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=12.96..12.97 rows=1 width=8) (actual time=5.447..5.447 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..11.97 rows=395 width=0) (actual time=0.316..5.436 rows=243 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 31
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.653 ms
Execution Time: 5.762 ms
(11 rows)
Time: 6.549 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=12.96..12.97 rows=1 width=8) (actual time=5.133..5.134 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..11.97 rows=395 width=0) (actual time=0.321..5.123 rows=243 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 31
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.479 ms
Execution Time: 5.279 ms
(11 rows)
Time: 5.874 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=12.96..12.97 rows=1 width=8) (actual time=4.822..4.823 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..11.97 rows=395 width=0) (actual time=0.304..4.812 rows=243 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 31
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.447 ms
Execution Time: 4.957 ms
(11 rows)
Time: 5.623 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=12.96..12.97 rows=1 width=8) (actual time=4.508..4.509 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..11.97 rows=395 width=0) (actual time=0.266..4.499 rows=243 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 31
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.458 ms
Execution Time: 4.662 ms
(11 rows)
Time: 5.213 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=12.96..12.97 rows=1 width=8) (actual time=4.455..4.456 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..11.97 rows=395 width=0) (actual time=0.277..4.446 rows=243 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 31
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.480 ms
Execution Time: 4.579 ms
(11 rows)
Time: 5.298 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=12.96..12.97 rows=1 width=8) (actual time=4.370..4.371 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..11.97 rows=395 width=0) (actual time=0.251..4.362 rows=243 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 31
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.465 ms
Execution Time: 4.496 ms
(11 rows)
Time: 5.052 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=12.96..12.97 rows=1 width=8) (actual time=4.009..4.009 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..11.97 rows=395 width=0) (actual time=0.253..3.999 rows=243 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 31
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.449 ms
Execution Time: 4.143 ms
(11 rows)
Time: 4.679 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=12.96..12.97 rows=1 width=8) (actual time=4.541..4.543 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..11.97 rows=395 width=0) (actual time=0.255..4.532 rows=243 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 31
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.422 ms
Execution Time: 4.670 ms
(11 rows)
Time: 5.180 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=12.96..12.97 rows=1 width=8) (actual time=4.313..4.314 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..11.97 rows=395 width=0) (actual time=0.252..4.304 rows=243 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 31
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.398 ms
Execution Time: 4.440 ms
(11 rows)
Time: 4.928 ms
Tokenizer: Ngram 1-2
#!/usr/bin/bash
function run_select() {
query=$1
echo "= ${query} ===============================================" 1>&2
explain_commands=()
for i in {1..10}; do
explain_commands+=("--command" "explain analyze select count(*) from wikipedia where text @@@ '${query}';")
done
result=$(docker exec -it -e PGPASSWORD=password paradedb psql -U user -d test \
--command "set max_parallel_workers_per_gather = 0" \
--command "set work_mem = '16MB'" \
--command "\pset pager off" \
--command "\timing" \
"${explain_commands[@]}")
echo "${result}" 1>&2
total=$(echo "${result}" | grep '^Time:' | awk '{ total += $2 } END { print total }')
echo "Query: ${query}, Total ${total} ms"
}
docker exec -it -e PGPASSWORD=password paradedb psql -U user -d test \
--command "drop index if exists wikipedia_index" \
--command "set maintenance_work_mem = '8GB'" \
--command "\timing" \
--command "create index wikipedia_index on wikipedia using bm25 (id, title, text) with (key_field='id', text_fields='{ \"text\": { \"tokenizer\": {\"type\": \"ngram\", \"min_gram\": 1, \"max_gram\": 2, \"prefix_only\": false} } }');"
run_select "象"
run_select "東京"
run_select "技術者"
run_select "ロケット"
run_select "データベース"
run_select "DB"
run_select "test"
run_select "PostgreSQL"
docker exec -it -e PGPASSWORD=password paradedb psql -U user -d test \
--command "select pg_size_pretty(pg_relation_size('wikipedia_index'));"
$ ./article/run-paradedb-ngram-1.sh 2> log
DROP INDEX
SET
Timing is on.
WARNING: only 2 parallel workers were available for index build
DETAIL: for large tables, increasing the number of workers can reduce the time it takes to build the index
HINT: `SET max_parallel_maintenance_workers = <number>`
CREATE INDEX
Time: 431695.898 ms (07:11.696)
Query: 象, Total 217.841 ms
Query: 東京, Total 849.795 ms
Query: 技術者, Total 151.814 ms
Query: ロケット, Total 260.333 ms
Query: データベース, Total 476.817 ms
Query: DB, Total 641.893 ms
Query: test, Total 7091.44 ms
Query: PostgreSQL, Total 329.48 ms
pg_size_pretty
----------------
5872 MB
(1 row)
log
= 象 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=2864.93..2864.94 rows=1 width=8) (actual time=56.698..56.699 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..1913.29 rows=380657 width=0) (actual time=0.425..52.551 rows=192783 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 27828
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 1.924 ms
Execution Time: 56.824 ms
(11 rows)
Time: 59.442 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=2864.93..2864.94 rows=1 width=8) (actual time=18.531..18.532 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..1913.29 rows=380657 width=0) (actual time=0.119..15.038 rows=192783 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 27828
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.318 ms
Execution Time: 18.595 ms
(11 rows)
Time: 19.048 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=2864.93..2864.94 rows=1 width=8) (actual time=18.451..18.451 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..1913.29 rows=380657 width=0) (actual time=0.122..14.952 rows=192783 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 27828
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.227 ms
Execution Time: 18.517 ms
(11 rows)
Time: 18.859 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=2864.93..2864.94 rows=1 width=8) (actual time=16.659..16.660 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..1913.29 rows=380657 width=0) (actual time=0.110..13.222 rows=192783 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 27828
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.228 ms
Execution Time: 16.732 ms
(11 rows)
Time: 17.081 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=2864.93..2864.94 rows=1 width=8) (actual time=16.809..16.810 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..1913.29 rows=380657 width=0) (actual time=0.147..13.316 rows=192783 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 27828
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.220 ms
Execution Time: 16.877 ms
(11 rows)
Time: 17.198 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=2864.93..2864.94 rows=1 width=8) (actual time=16.821..16.821 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..1913.29 rows=380657 width=0) (actual time=0.135..13.340 rows=192783 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 27828
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.223 ms
Execution Time: 16.886 ms
(11 rows)
Time: 17.211 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=2864.93..2864.94 rows=1 width=8) (actual time=16.723..16.723 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..1913.29 rows=380657 width=0) (actual time=0.113..13.223 rows=192783 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 27828
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.212 ms
Execution Time: 16.792 ms
(11 rows)
Time: 17.101 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=2864.93..2864.94 rows=1 width=8) (actual time=16.909..16.909 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..1913.29 rows=380657 width=0) (actual time=0.116..13.410 rows=192783 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 27828
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.213 ms
Execution Time: 16.978 ms
(11 rows)
Time: 17.325 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=2864.93..2864.94 rows=1 width=8) (actual time=16.939..16.939 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..1913.29 rows=380657 width=0) (actual time=0.142..13.398 rows=192783 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 27828
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.218 ms
Execution Time: 17.008 ms
(11 rows)
Time: 17.355 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=2864.93..2864.94 rows=1 width=8) (actual time=16.864..16.865 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..1913.29 rows=380657 width=0) (actual time=0.122..13.367 rows=192783 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 27828
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.196 ms
Execution Time: 16.919 ms
(11 rows)
Time: 17.221 ms
= 東京 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3921.02..3921.03 rows=1 width=8) (actual time=101.508..101.509 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2617.35 rows=521470 width=0) (actual time=0.425..93.472 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 1.900 ms
Execution Time: 101.676 ms
(11 rows)
Time: 104.197 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3921.02..3921.03 rows=1 width=8) (actual time=83.275..83.277 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2617.35 rows=521470 width=0) (actual time=0.201..75.643 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.441 ms
Execution Time: 83.380 ms
(11 rows)
Time: 83.977 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3921.02..3921.03 rows=1 width=8) (actual time=82.039..82.040 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2617.35 rows=521470 width=0) (actual time=0.174..75.088 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.390 ms
Execution Time: 82.155 ms
(11 rows)
Time: 82.795 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3921.02..3921.03 rows=1 width=8) (actual time=88.473..88.475 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2617.35 rows=521470 width=0) (actual time=0.192..81.185 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.517 ms
Execution Time: 88.583 ms
(11 rows)
Time: 89.416 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3921.02..3921.03 rows=1 width=8) (actual time=89.647..89.648 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2617.35 rows=521470 width=0) (actual time=0.212..82.463 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.564 ms
Execution Time: 89.763 ms
(11 rows)
Time: 90.631 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3921.02..3921.03 rows=1 width=8) (actual time=76.027..76.027 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2617.35 rows=521470 width=0) (actual time=0.168..69.313 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.407 ms
Execution Time: 76.100 ms
(11 rows)
Time: 76.703 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3921.02..3921.03 rows=1 width=8) (actual time=84.267..84.268 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2617.35 rows=521470 width=0) (actual time=0.169..77.203 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.298 ms
Execution Time: 84.346 ms
(11 rows)
Time: 84.888 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3921.02..3921.03 rows=1 width=8) (actual time=78.158..78.159 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2617.35 rows=521470 width=0) (actual time=0.165..71.436 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.403 ms
Execution Time: 78.253 ms
(11 rows)
Time: 78.806 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3921.02..3921.03 rows=1 width=8) (actual time=80.374..80.376 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2617.35 rows=521470 width=0) (actual time=0.178..73.634 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.371 ms
Execution Time: 80.458 ms
(11 rows)
Time: 81.010 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3921.02..3921.03 rows=1 width=8) (actual time=76.716..76.717 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2617.35 rows=521470 width=0) (actual time=0.164..70.143 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.336 ms
Execution Time: 76.829 ms
(11 rows)
Time: 77.372 ms
= 技術者 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=299.11..299.12 rows=1 width=8) (actual time=24.843..24.844 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..202.74 rows=38548 width=0) (actual time=0.599..24.325 rows=20385 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2749
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 2.227 ms
Execution Time: 24.942 ms
(11 rows)
Time: 27.783 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=299.11..299.12 rows=1 width=8) (actual time=14.853..14.853 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..202.74 rows=38548 width=0) (actual time=0.254..14.249 rows=20385 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2749
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.431 ms
Execution Time: 14.925 ms
(11 rows)
Time: 15.529 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=299.11..299.12 rows=1 width=8) (actual time=13.914..13.915 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..202.74 rows=38548 width=0) (actual time=0.260..13.322 rows=20385 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2749
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.361 ms
Execution Time: 13.983 ms
(11 rows)
Time: 14.507 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=299.11..299.12 rows=1 width=8) (actual time=12.854..12.854 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..202.74 rows=38548 width=0) (actual time=0.231..12.469 rows=20385 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2749
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.379 ms
Execution Time: 12.934 ms
(11 rows)
Time: 13.488 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=299.11..299.12 rows=1 width=8) (actual time=13.199..13.200 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..202.74 rows=38548 width=0) (actual time=0.275..12.801 rows=20385 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2749
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.416 ms
Execution Time: 13.271 ms
(11 rows)
Time: 13.846 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=299.11..299.12 rows=1 width=8) (actual time=13.271..13.271 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..202.74 rows=38548 width=0) (actual time=0.270..12.842 rows=20385 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2749
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.397 ms
Execution Time: 13.342 ms
(11 rows)
Time: 13.808 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=299.11..299.12 rows=1 width=8) (actual time=12.529..12.529 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..202.74 rows=38548 width=0) (actual time=0.266..12.137 rows=20385 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2749
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.389 ms
Execution Time: 12.595 ms
(11 rows)
Time: 13.136 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=299.11..299.12 rows=1 width=8) (actual time=12.316..12.316 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..202.74 rows=38548 width=0) (actual time=0.285..11.908 rows=20385 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2749
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.383 ms
Execution Time: 12.379 ms
(11 rows)
Time: 12.823 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=299.11..299.12 rows=1 width=8) (actual time=12.518..12.518 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..202.74 rows=38548 width=0) (actual time=0.230..12.108 rows=20385 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2749
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.383 ms
Execution Time: 12.583 ms
(11 rows)
Time: 13.193 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=299.11..299.12 rows=1 width=8) (actual time=13.084..13.084 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..202.74 rows=38548 width=0) (actual time=0.259..12.662 rows=20385 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2749
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.366 ms
Execution Time: 13.179 ms
(11 rows)
Time: 13.701 ms
= ロケット ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=615.38..615.39 rows=1 width=8) (actual time=41.934..41.935 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..413.59 rows=80717 width=0) (actual time=0.804..41.249 rows=25567 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 3098
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 2.597 ms
Execution Time: 42.050 ms
(11 rows)
Time: 45.184 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=615.38..615.39 rows=1 width=8) (actual time=24.326..24.326 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..413.59 rows=80717 width=0) (actual time=0.294..23.839 rows=25567 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 3098
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.529 ms
Execution Time: 24.390 ms
(11 rows)
Time: 25.076 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=615.38..615.39 rows=1 width=8) (actual time=23.800..23.801 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..413.59 rows=80717 width=0) (actual time=0.275..23.316 rows=25567 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 3098
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.385 ms
Execution Time: 23.878 ms
(11 rows)
Time: 24.398 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=615.38..615.39 rows=1 width=8) (actual time=23.987..23.988 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..413.59 rows=80717 width=0) (actual time=0.282..23.510 rows=25567 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 3098
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.467 ms
Execution Time: 24.066 ms
(11 rows)
Time: 24.735 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=615.38..615.39 rows=1 width=8) (actual time=23.069..23.070 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..413.59 rows=80717 width=0) (actual time=0.255..22.603 rows=25567 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 3098
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.477 ms
Execution Time: 23.140 ms
(11 rows)
Time: 23.796 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=615.38..615.39 rows=1 width=8) (actual time=22.683..22.684 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..413.59 rows=80717 width=0) (actual time=0.261..22.220 rows=25567 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 3098
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.376 ms
Execution Time: 22.756 ms
(11 rows)
Time: 23.251 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=615.38..615.39 rows=1 width=8) (actual time=22.696..22.696 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..413.59 rows=80717 width=0) (actual time=0.259..22.200 rows=25567 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 3098
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.368 ms
Execution Time: 22.763 ms
(11 rows)
Time: 23.299 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=615.38..615.39 rows=1 width=8) (actual time=22.894..22.894 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..413.59 rows=80717 width=0) (actual time=0.306..22.420 rows=25567 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 3098
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.374 ms
Execution Time: 22.961 ms
(11 rows)
Time: 23.453 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=615.38..615.39 rows=1 width=8) (actual time=23.089..23.089 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..413.59 rows=80717 width=0) (actual time=0.265..22.608 rows=25567 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 3098
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.373 ms
Execution Time: 23.153 ms
(11 rows)
Time: 23.741 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=615.38..615.39 rows=1 width=8) (actual time=22.833..22.834 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..413.59 rows=80717 width=0) (actual time=0.268..22.359 rows=25567 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 3098
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.398 ms
Execution Time: 22.908 ms
(11 rows)
Time: 23.400 ms
= データベース ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=577.44..577.45 rows=1 width=8) (actual time=65.666..65.667 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..388.30 rows=75659 width=0) (actual time=0.759..64.794 rows=39974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6268
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 2.065 ms
Execution Time: 65.763 ms
(11 rows)
Time: 68.166 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=577.44..577.45 rows=1 width=8) (actual time=45.624..45.625 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..388.30 rows=75659 width=0) (actual time=0.413..44.793 rows=39974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6268
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.721 ms
Execution Time: 45.700 ms
(11 rows)
Time: 46.585 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=577.44..577.45 rows=1 width=8) (actual time=44.423..44.424 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..388.30 rows=75659 width=0) (actual time=0.403..43.636 rows=39974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6268
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.523 ms
Execution Time: 44.499 ms
(11 rows)
Time: 45.259 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=577.44..577.45 rows=1 width=8) (actual time=44.792..44.793 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..388.30 rows=75659 width=0) (actual time=0.366..43.998 rows=39974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6268
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.627 ms
Execution Time: 44.858 ms
(11 rows)
Time: 45.656 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=577.44..577.45 rows=1 width=8) (actual time=44.682..44.683 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..388.30 rows=75659 width=0) (actual time=0.367..43.896 rows=39974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6268
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.634 ms
Execution Time: 44.751 ms
(11 rows)
Time: 45.515 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=577.44..577.45 rows=1 width=8) (actual time=44.355..44.356 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..388.30 rows=75659 width=0) (actual time=0.374..43.569 rows=39974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6268
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.521 ms
Execution Time: 44.416 ms
(11 rows)
Time: 45.153 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=577.44..577.45 rows=1 width=8) (actual time=44.308..44.309 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..388.30 rows=75659 width=0) (actual time=0.379..43.524 rows=39974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6268
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.545 ms
Execution Time: 44.387 ms
(11 rows)
Time: 45.103 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=577.44..577.45 rows=1 width=8) (actual time=46.412..46.413 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..388.30 rows=75659 width=0) (actual time=0.381..45.586 rows=39974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6268
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.552 ms
Execution Time: 46.483 ms
(11 rows)
Time: 47.211 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=577.44..577.45 rows=1 width=8) (actual time=43.887..43.888 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..388.30 rows=75659 width=0) (actual time=0.396..43.077 rows=39974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6268
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.612 ms
Execution Time: 43.947 ms
(11 rows)
Time: 44.719 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=577.44..577.45 rows=1 width=8) (actual time=42.700..42.700 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..388.30 rows=75659 width=0) (actual time=0.350..41.919 rows=39974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6268
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.512 ms
Execution Time: 42.765 ms
(11 rows)
Time: 43.450 ms
= DB ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1473.94..1473.95 rows=1 width=8) (actual time=88.149..88.150 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..985.96 rows=195192 width=0) (actual time=0.442..83.330 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 1.728 ms
Execution Time: 88.273 ms
(11 rows)
Time: 90.421 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1473.94..1473.95 rows=1 width=8) (actual time=72.468..72.470 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..985.96 rows=195192 width=0) (actual time=0.216..69.193 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.568 ms
Execution Time: 72.589 ms
(11 rows)
Time: 73.393 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1473.94..1473.95 rows=1 width=8) (actual time=62.397..62.399 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..985.96 rows=195192 width=0) (actual time=0.203..59.167 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.449 ms
Execution Time: 62.519 ms
(11 rows)
Time: 63.153 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1473.94..1473.95 rows=1 width=8) (actual time=61.631..61.633 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..985.96 rows=195192 width=0) (actual time=0.193..58.424 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.432 ms
Execution Time: 61.748 ms
(11 rows)
Time: 62.431 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1473.94..1473.95 rows=1 width=8) (actual time=56.722..56.723 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..985.96 rows=195192 width=0) (actual time=0.205..53.671 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.471 ms
Execution Time: 56.800 ms
(11 rows)
Time: 57.464 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1473.94..1473.95 rows=1 width=8) (actual time=55.710..55.710 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..985.96 rows=195192 width=0) (actual time=0.172..52.633 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.334 ms
Execution Time: 55.780 ms
(11 rows)
Time: 56.322 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1473.94..1473.95 rows=1 width=8) (actual time=55.444..55.444 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..985.96 rows=195192 width=0) (actual time=0.181..52.375 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.317 ms
Execution Time: 55.509 ms
(11 rows)
Time: 55.955 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1473.94..1473.95 rows=1 width=8) (actual time=62.544..62.545 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..985.96 rows=195192 width=0) (actual time=0.178..59.020 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.311 ms
Execution Time: 62.625 ms
(11 rows)
Time: 63.021 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1473.94..1473.95 rows=1 width=8) (actual time=60.100..60.100 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..985.96 rows=195192 width=0) (actual time=0.250..56.701 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.431 ms
Execution Time: 60.191 ms
(11 rows)
Time: 60.834 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1473.94..1473.95 rows=1 width=8) (actual time=58.304..58.305 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..985.96 rows=195192 width=0) (actual time=0.232..55.105 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.368 ms
Execution Time: 58.378 ms
(11 rows)
Time: 58.899 ms
= test ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=8608.67..8608.68 rows=1 width=8) (actual time=703.427..703.428 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..5742.45 rows=1146490 width=0) (actual time=0.684..683.640 rows=1053755 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 207644
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 2.154 ms
Execution Time: 703.519 ms
(11 rows)
Time: 706.144 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=8608.67..8608.68 rows=1 width=8) (actual time=708.709..708.710 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..5742.45 rows=1146490 width=0) (actual time=0.319..689.025 rows=1053755 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 207644
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.737 ms
Execution Time: 708.785 ms
(11 rows)
Time: 709.762 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=8608.67..8608.68 rows=1 width=8) (actual time=699.760..699.761 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..5742.45 rows=1146490 width=0) (actual time=0.291..680.840 rows=1053755 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 207644
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.575 ms
Execution Time: 699.841 ms
(11 rows)
Time: 700.542 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=8608.67..8608.68 rows=1 width=8) (actual time=702.287..702.287 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..5742.45 rows=1146490 width=0) (actual time=0.295..682.975 rows=1053755 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 207644
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.602 ms
Execution Time: 702.367 ms
(11 rows)
Time: 703.181 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=8608.67..8608.68 rows=1 width=8) (actual time=704.959..704.960 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..5742.45 rows=1146490 width=0) (actual time=0.304..685.277 rows=1053755 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 207644
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.732 ms
Execution Time: 705.050 ms
(11 rows)
Time: 705.963 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=8608.67..8608.68 rows=1 width=8) (actual time=704.484..704.485 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..5742.45 rows=1146490 width=0) (actual time=0.320..684.851 rows=1053755 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 207644
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.584 ms
Execution Time: 704.567 ms
(11 rows)
Time: 705.281 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=8608.67..8608.68 rows=1 width=8) (actual time=711.821..711.821 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..5742.45 rows=1146490 width=0) (actual time=0.341..691.817 rows=1053755 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 207644
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.754 ms
Execution Time: 711.935 ms
(11 rows)
Time: 713.006 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=8608.67..8608.68 rows=1 width=8) (actual time=710.570..710.571 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..5742.45 rows=1146490 width=0) (actual time=0.337..691.444 rows=1053755 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 207644
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.588 ms
Execution Time: 710.657 ms
(11 rows)
Time: 711.433 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=8608.67..8608.68 rows=1 width=8) (actual time=734.430..734.431 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..5742.45 rows=1146490 width=0) (actual time=0.328..714.485 rows=1053755 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 207644
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.824 ms
Execution Time: 734.568 ms
(11 rows)
Time: 735.594 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=8608.67..8608.68 rows=1 width=8) (actual time=699.511..699.512 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..5742.45 rows=1146490 width=0) (actual time=0.353..680.069 rows=1053755 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 207644
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.656 ms
Execution Time: 699.627 ms
(11 rows)
Time: 700.535 ms
= PostgreSQL ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=134.36..134.37 rows=1 width=8) (actual time=50.945..50.946 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..92.91 rows=16581 width=0) (actual time=1.644..50.867 rows=1250 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 283
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 4.667 ms
Execution Time: 51.050 ms
(11 rows)
Time: 56.384 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=134.36..134.37 rows=1 width=8) (actual time=30.489..30.489 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..92.91 rows=16581 width=0) (actual time=0.640..30.416 rows=1250 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 283
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.957 ms
Execution Time: 30.557 ms
(11 rows)
Time: 31.659 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=134.36..134.37 rows=1 width=8) (actual time=30.068..30.068 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..92.91 rows=16581 width=0) (actual time=0.688..29.998 rows=1250 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 283
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.896 ms
Execution Time: 30.144 ms
(11 rows)
Time: 31.145 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=134.36..134.37 rows=1 width=8) (actual time=29.781..29.782 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..92.91 rows=16581 width=0) (actual time=0.596..29.711 rows=1250 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 283
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.808 ms
Execution Time: 29.854 ms
(11 rows)
Time: 30.753 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=134.36..134.37 rows=1 width=8) (actual time=29.142..29.143 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..92.91 rows=16581 width=0) (actual time=0.593..29.073 rows=1250 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 283
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.836 ms
Execution Time: 29.214 ms
(11 rows)
Time: 30.143 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=134.36..134.37 rows=1 width=8) (actual time=28.693..28.694 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..92.91 rows=16581 width=0) (actual time=0.598..28.625 rows=1250 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 283
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.831 ms
Execution Time: 28.764 ms
(11 rows)
Time: 29.732 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=134.36..134.37 rows=1 width=8) (actual time=29.013..29.014 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..92.91 rows=16581 width=0) (actual time=0.585..28.942 rows=1250 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 283
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.832 ms
Execution Time: 29.086 ms
(11 rows)
Time: 30.019 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=134.36..134.37 rows=1 width=8) (actual time=29.143..29.144 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..92.91 rows=16581 width=0) (actual time=0.586..29.074 rows=1250 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 283
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.834 ms
Execution Time: 29.204 ms
(11 rows)
Time: 30.131 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=134.36..134.37 rows=1 width=8) (actual time=28.814..28.814 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..92.91 rows=16581 width=0) (actual time=0.598..28.745 rows=1250 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 283
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.801 ms
Execution Time: 28.876 ms
(11 rows)
Time: 29.773 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=134.36..134.37 rows=1 width=8) (actual time=28.689..28.690 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..92.91 rows=16581 width=0) (actual time=0.618..28.620 rows=1250 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 283
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.850 ms
Execution Time: 28.776 ms
(11 rows)
Time: 29.741 ms
Tokenizer: Ngram 2-3
#!/usr/bin/bash
function run_select() {
query=$1
echo "= ${query} ===============================================" 1>&2
explain_commands=()
for i in {1..10}; do
explain_commands+=("--command" "explain analyze select count(*) from wikipedia where text @@@ '${query}';")
done
result=$(docker exec -it -e PGPASSWORD=password paradedb psql -U user -d test \
--command "set max_parallel_workers_per_gather = 0" \
--command "set work_mem = '16MB'" \
--command "\pset pager off" \
--command "\timing" \
"${explain_commands[@]}")
echo "${result}" 1>&2
total=$(echo "${result}" | grep '^Time:' | awk '{ total += $2 } END { print total }')
echo "Query: ${query}, Total ${total} ms"
}
docker exec -it -e PGPASSWORD=password paradedb psql -U user -d test \
--command "drop index if exists wikipedia_index" \
--command "set maintenance_work_mem = '8GB'" \
--command "\timing" \
--command "create index wikipedia_index on wikipedia using bm25 (id, title, text) with (key_field='id', text_fields='{ \"text\": { \"tokenizer\": {\"type\": \"ngram\", \"min_gram\": 2, \"max_gram\": 3, \"prefix_only\": false} } }');"
run_select "象"
run_select "東京"
run_select "技術者"
run_select "ロケット"
run_select "データベース"
run_select "DB"
run_select "test"
run_select "PostgreSQL"
docker exec -it -e PGPASSWORD=password paradedb psql -U user -d test \
--command "select pg_size_pretty(pg_relation_size('wikipedia_index'));"
$ ./article/run-paradedb-ngram-2.sh 2> log
DROP INDEX
SET
Timing is on.
WARNING: only 2 parallel workers were available for index build
DETAIL: for large tables, increasing the number of workers can reduce the time it takes to build the index
HINT: `SET max_parallel_maintenance_workers = <number>`
CREATE INDEX
Time: 867018.533 ms (14:27.019)
Query: 象, Total 8.171 ms
Query: 東京, Total 548.162 ms
Query: 技術者, Total 129.01 ms
Query: ロケット, Total 215.671 ms
Query: データベース, Total 335.992 ms
Query: DB, Total 334.842 ms
Query: test, Total 1043.31 ms
Query: PostgreSQL, Total 261.885 ms
pg_size_pretty
----------------
17 GB
(1 row)
log
= 象 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=10.01..10.02 rows=1 width=8) (actual time=0.188..0.189 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..10.01 rows=1 width=0) (actual time=0.185..0.185 rows=0 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 0
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 1.791 ms
Execution Time: 0.306 ms
(11 rows)
Time: 2.811 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=10.01..10.02 rows=1 width=8) (actual time=0.127..0.128 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..10.01 rows=1 width=0) (actual time=0.126..0.126 rows=0 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 0
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.308 ms
Execution Time: 0.189 ms
(11 rows)
Time: 0.679 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=10.01..10.02 rows=1 width=8) (actual time=0.119..0.120 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..10.01 rows=1 width=0) (actual time=0.118..0.119 rows=0 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 0
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.303 ms
Execution Time: 0.176 ms
(11 rows)
Time: 0.638 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=10.01..10.02 rows=1 width=8) (actual time=0.123..0.123 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..10.01 rows=1 width=0) (actual time=0.122..0.122 rows=0 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 0
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.254 ms
Execution Time: 0.175 ms
(11 rows)
Time: 0.531 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=10.01..10.02 rows=1 width=8) (actual time=0.118..0.118 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..10.01 rows=1 width=0) (actual time=0.117..0.117 rows=0 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 0
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.254 ms
Execution Time: 0.169 ms
(11 rows)
Time: 0.578 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=10.01..10.02 rows=1 width=8) (actual time=0.119..0.119 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..10.01 rows=1 width=0) (actual time=0.118..0.118 rows=0 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 0
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.261 ms
Execution Time: 0.171 ms
(11 rows)
Time: 0.587 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=10.01..10.02 rows=1 width=8) (actual time=0.125..0.126 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..10.01 rows=1 width=0) (actual time=0.124..0.124 rows=0 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 0
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.251 ms
Execution Time: 0.176 ms
(11 rows)
Time: 0.590 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=10.01..10.02 rows=1 width=8) (actual time=0.120..0.120 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..10.01 rows=1 width=0) (actual time=0.119..0.119 rows=0 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 0
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.255 ms
Execution Time: 0.173 ms
(11 rows)
Time: 0.585 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=10.01..10.02 rows=1 width=8) (actual time=0.122..0.122 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..10.01 rows=1 width=0) (actual time=0.121..0.121 rows=0 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 0
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.268 ms
Execution Time: 0.175 ms
(11 rows)
Time: 0.598 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=10.01..10.02 rows=1 width=8) (actual time=0.118..0.118 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..10.01 rows=1 width=0) (actual time=0.117..0.117 rows=0 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 0
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"象","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.250 ms
Execution Time: 0.169 ms
(11 rows)
Time: 0.574 ms
= 東京 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3306.99..3307.00 rows=1 width=8) (actual time=81.169..81.170 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2207.99 rows=439599 width=0) (actual time=0.698..73.863 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 15.091 ms
Execution Time: 81.325 ms
(11 rows)
Time: 96.781 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3306.99..3307.00 rows=1 width=8) (actual time=49.265..49.266 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2207.99 rows=439599 width=0) (actual time=0.267..42.676 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.367 ms
Execution Time: 49.363 ms
(11 rows)
Time: 49.880 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3306.99..3307.00 rows=1 width=8) (actual time=50.094..50.095 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2207.99 rows=439599 width=0) (actual time=0.199..42.898 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.239 ms
Execution Time: 50.230 ms
(11 rows)
Time: 50.608 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3306.99..3307.00 rows=1 width=8) (actual time=49.669..49.670 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2207.99 rows=439599 width=0) (actual time=0.257..42.847 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.424 ms
Execution Time: 49.798 ms
(11 rows)
Time: 50.406 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3306.99..3307.00 rows=1 width=8) (actual time=49.101..49.102 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2207.99 rows=439599 width=0) (actual time=0.224..42.496 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.311 ms
Execution Time: 49.224 ms
(11 rows)
Time: 49.747 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3306.99..3307.00 rows=1 width=8) (actual time=48.123..48.124 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2207.99 rows=439599 width=0) (actual time=0.240..41.635 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.303 ms
Execution Time: 48.231 ms
(11 rows)
Time: 48.684 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3306.99..3307.00 rows=1 width=8) (actual time=47.442..47.442 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2207.99 rows=439599 width=0) (actual time=0.259..40.960 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.313 ms
Execution Time: 47.542 ms
(11 rows)
Time: 48.000 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3306.99..3307.00 rows=1 width=8) (actual time=47.337..47.337 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2207.99 rows=439599 width=0) (actual time=0.246..40.899 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.259 ms
Execution Time: 47.445 ms
(11 rows)
Time: 47.875 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3306.99..3307.00 rows=1 width=8) (actual time=49.583..49.584 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2207.99 rows=439599 width=0) (actual time=0.215..42.571 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.248 ms
Execution Time: 49.728 ms
(11 rows)
Time: 50.172 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=3306.99..3307.00 rows=1 width=8) (actual time=55.250..55.251 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..2207.99 rows=439599 width=0) (actual time=0.268..47.756 rows=371644 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 59059
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"東京","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.438 ms
Execution Time: 55.409 ms
(11 rows)
Time: 56.009 ms
= 技術者 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=195.86..195.87 rows=1 width=8) (actual time=25.273..25.274 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..133.91 rows=24781 width=0) (actual time=0.780..24.739 rows=19974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2720
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 2.854 ms
Execution Time: 25.503 ms
(11 rows)
Time: 28.959 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=195.86..195.87 rows=1 width=8) (actual time=12.551..12.552 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..133.91 rows=24781 width=0) (actual time=0.304..12.058 rows=19974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2720
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.410 ms
Execution Time: 12.667 ms
(11 rows)
Time: 13.274 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=195.86..195.87 rows=1 width=8) (actual time=9.870..9.870 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..133.91 rows=24781 width=0) (actual time=0.266..9.446 rows=19974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2720
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.416 ms
Execution Time: 9.997 ms
(11 rows)
Time: 10.638 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=195.86..195.87 rows=1 width=8) (actual time=10.252..10.253 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..133.91 rows=24781 width=0) (actual time=0.258..9.811 rows=19974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2720
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.413 ms
Execution Time: 10.363 ms
(11 rows)
Time: 10.962 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=195.86..195.87 rows=1 width=8) (actual time=9.887..9.887 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..133.91 rows=24781 width=0) (actual time=0.237..9.459 rows=19974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2720
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.397 ms
Execution Time: 9.988 ms
(11 rows)
Time: 10.544 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=195.86..195.87 rows=1 width=8) (actual time=9.175..9.175 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..133.91 rows=24781 width=0) (actual time=0.239..8.776 rows=19974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2720
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.421 ms
Execution Time: 9.265 ms
(11 rows)
Time: 9.860 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=195.86..195.87 rows=1 width=8) (actual time=10.457..10.457 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..133.91 rows=24781 width=0) (actual time=0.236..10.000 rows=19974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2720
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.409 ms
Execution Time: 10.598 ms
(11 rows)
Time: 11.141 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=195.86..195.87 rows=1 width=8) (actual time=10.431..10.432 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..133.91 rows=24781 width=0) (actual time=0.234..9.980 rows=19974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2720
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.383 ms
Execution Time: 10.558 ms
(11 rows)
Time: 11.117 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=195.86..195.87 rows=1 width=8) (actual time=10.635..10.636 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..133.91 rows=24781 width=0) (actual time=0.258..10.191 rows=19974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2720
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.385 ms
Execution Time: 10.787 ms
(11 rows)
Time: 11.297 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=195.86..195.87 rows=1 width=8) (actual time=10.529..10.530 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..133.91 rows=24781 width=0) (actual time=0.310..10.105 rows=19974 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2720
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"技術者","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.463 ms
Execution Time: 10.636 ms
(11 rows)
Time: 11.218 ms
= ロケット ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=204.63..204.64 rows=1 width=8) (actual time=31.197..31.198 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..139.75 rows=25951 width=0) (actual time=1.031..30.563 rows=19386 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2379
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 14.681 ms
Execution Time: 31.429 ms
(11 rows)
Time: 46.512 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=204.63..204.64 rows=1 width=8) (actual time=18.174..18.176 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..139.75 rows=25951 width=0) (actual time=0.357..17.694 rows=19386 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2379
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.582 ms
Execution Time: 18.362 ms
(11 rows)
Time: 19.085 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=204.63..204.64 rows=1 width=8) (actual time=23.882..23.883 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..139.75 rows=25951 width=0) (actual time=0.367..23.187 rows=19386 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2379
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.490 ms
Execution Time: 24.073 ms
(11 rows)
Time: 24.704 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=204.63..204.64 rows=1 width=8) (actual time=18.754..18.754 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..139.75 rows=25951 width=0) (actual time=0.397..18.230 rows=19386 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2379
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.623 ms
Execution Time: 18.905 ms
(11 rows)
Time: 19.663 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=204.63..204.64 rows=1 width=8) (actual time=17.273..17.273 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..139.75 rows=25951 width=0) (actual time=0.333..16.796 rows=19386 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2379
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.547 ms
Execution Time: 17.408 ms
(11 rows)
Time: 18.069 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=204.63..204.64 rows=1 width=8) (actual time=17.135..17.136 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..139.75 rows=25951 width=0) (actual time=0.311..16.652 rows=19386 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2379
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.449 ms
Execution Time: 17.287 ms
(11 rows)
Time: 17.882 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=204.63..204.64 rows=1 width=8) (actual time=17.029..17.030 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..139.75 rows=25951 width=0) (actual time=0.335..16.561 rows=19386 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2379
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.543 ms
Execution Time: 17.171 ms
(11 rows)
Time: 17.845 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=204.63..204.64 rows=1 width=8) (actual time=17.008..17.009 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..139.75 rows=25951 width=0) (actual time=0.332..16.542 rows=19386 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2379
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.571 ms
Execution Time: 17.141 ms
(11 rows)
Time: 17.860 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=204.63..204.64 rows=1 width=8) (actual time=16.973..16.974 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..139.75 rows=25951 width=0) (actual time=0.338..16.500 rows=19386 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2379
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.490 ms
Execution Time: 17.105 ms
(11 rows)
Time: 17.703 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=204.63..204.64 rows=1 width=8) (actual time=15.613..15.613 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..139.75 rows=25951 width=0) (actual time=0.333..15.154 rows=19386 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 2379
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"ロケット","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.517 ms
Execution Time: 15.726 ms
(11 rows)
Time: 16.348 ms
= データベース ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=374.51..374.52 rows=1 width=8) (actual time=49.311..49.312 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..253.00 rows=48601 width=0) (actual time=0.983..48.437 rows=39459 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6207
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 16.328 ms
Execution Time: 49.493 ms
(11 rows)
Time: 66.117 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=374.51..374.52 rows=1 width=8) (actual time=31.796..31.798 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..253.00 rows=48601 width=0) (actual time=0.423..30.948 rows=39459 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6207
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.677 ms
Execution Time: 31.939 ms
(11 rows)
Time: 32.825 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=374.51..374.52 rows=1 width=8) (actual time=28.610..28.611 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..253.00 rows=48601 width=0) (actual time=0.409..27.816 rows=39459 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6207
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.623 ms
Execution Time: 28.716 ms
(11 rows)
Time: 29.524 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=374.51..374.52 rows=1 width=8) (actual time=27.149..27.150 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..253.00 rows=48601 width=0) (actual time=0.353..26.382 rows=39459 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6207
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.587 ms
Execution Time: 27.285 ms
(11 rows)
Time: 28.151 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=374.51..374.52 rows=1 width=8) (actual time=29.663..29.663 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..253.00 rows=48601 width=0) (actual time=0.501..28.792 rows=39459 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6207
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.658 ms
Execution Time: 29.809 ms
(11 rows)
Time: 30.699 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=374.51..374.52 rows=1 width=8) (actual time=32.419..32.420 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..253.00 rows=48601 width=0) (actual time=0.446..31.496 rows=39459 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6207
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.819 ms
Execution Time: 32.608 ms
(11 rows)
Time: 33.647 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=374.51..374.52 rows=1 width=8) (actual time=28.063..28.064 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..253.00 rows=48601 width=0) (actual time=0.442..27.262 rows=39459 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6207
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.788 ms
Execution Time: 28.182 ms
(11 rows)
Time: 29.261 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=374.51..374.52 rows=1 width=8) (actual time=27.902..27.903 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..253.00 rows=48601 width=0) (actual time=0.359..27.110 rows=39459 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6207
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.521 ms
Execution Time: 28.026 ms
(11 rows)
Time: 28.750 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=374.51..374.52 rows=1 width=8) (actual time=27.829..27.830 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..253.00 rows=48601 width=0) (actual time=0.389..27.049 rows=39459 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6207
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.578 ms
Execution Time: 27.971 ms
(11 rows)
Time: 28.756 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=374.51..374.52 rows=1 width=8) (actual time=27.339..27.339 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..253.00 rows=48601 width=0) (actual time=0.409..26.562 rows=39459 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 6207
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"データベース","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.598 ms
Execution Time: 27.464 ms
(11 rows)
Time: 28.262 ms
= DB ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1217.61..1217.62 rows=1 width=8) (actual time=49.979..49.980 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..815.07 rows=161014 width=0) (actual time=0.550..46.074 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 1.891 ms
Execution Time: 50.184 ms
(11 rows)
Time: 52.393 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1217.61..1217.62 rows=1 width=8) (actual time=35.060..35.061 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..815.07 rows=161014 width=0) (actual time=0.304..31.110 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.458 ms
Execution Time: 35.199 ms
(11 rows)
Time: 35.801 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1217.61..1217.62 rows=1 width=8) (actual time=36.153..36.155 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..815.07 rows=161014 width=0) (actual time=0.222..31.349 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.456 ms
Execution Time: 36.334 ms
(11 rows)
Time: 36.944 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1217.61..1217.62 rows=1 width=8) (actual time=29.999..30.000 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..815.07 rows=161014 width=0) (actual time=0.255..25.054 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.474 ms
Execution Time: 30.180 ms
(11 rows)
Time: 30.810 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1217.61..1217.62 rows=1 width=8) (actual time=29.489..29.492 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..815.07 rows=161014 width=0) (actual time=0.254..24.536 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.433 ms
Execution Time: 29.685 ms
(11 rows)
Time: 30.294 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1217.61..1217.62 rows=1 width=8) (actual time=29.885..29.886 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..815.07 rows=161014 width=0) (actual time=0.251..25.199 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.455 ms
Execution Time: 30.075 ms
(11 rows)
Time: 30.699 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1217.61..1217.62 rows=1 width=8) (actual time=30.233..30.234 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..815.07 rows=161014 width=0) (actual time=0.314..25.470 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.587 ms
Execution Time: 30.412 ms
(11 rows)
Time: 31.210 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1217.61..1217.62 rows=1 width=8) (actual time=28.804..28.806 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..815.07 rows=161014 width=0) (actual time=0.235..24.107 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.459 ms
Execution Time: 29.000 ms
(11 rows)
Time: 29.617 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1217.61..1217.62 rows=1 width=8) (actual time=27.945..27.946 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..815.07 rows=161014 width=0) (actual time=0.241..23.489 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.439 ms
Execution Time: 28.122 ms
(11 rows)
Time: 28.716 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1217.61..1217.62 rows=1 width=8) (actual time=27.546..27.547 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..815.07 rows=161014 width=0) (actual time=0.247..23.016 rows=175966 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 34561
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"DB","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.448 ms
Execution Time: 27.739 ms
(11 rows)
Time: 28.358 ms
= test ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1344.73..1344.74 rows=1 width=8) (actual time=129.760..129.761 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..899.82 rows=177964 width=0) (actual time=0.906..126.157 rows=151464 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 35831
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 4.992 ms
Execution Time: 129.932 ms
(11 rows)
Time: 135.627 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1344.73..1344.74 rows=1 width=8) (actual time=82.928..82.929 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..899.82 rows=177964 width=0) (actual time=0.413..79.910 rows=151464 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 35831
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.588 ms
Execution Time: 83.090 ms
(11 rows)
Time: 83.813 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1344.73..1344.74 rows=1 width=8) (actual time=105.644..105.645 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..899.82 rows=177964 width=0) (actual time=0.368..101.302 rows=151464 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 35831
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.612 ms
Execution Time: 105.822 ms
(11 rows)
Time: 106.599 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1344.73..1344.74 rows=1 width=8) (actual time=112.585..112.587 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..899.82 rows=177964 width=0) (actual time=0.517..107.774 rows=151464 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 35831
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.653 ms
Execution Time: 112.717 ms
(11 rows)
Time: 113.550 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1344.73..1344.74 rows=1 width=8) (actual time=105.123..105.125 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..899.82 rows=177964 width=0) (actual time=0.504..99.922 rows=151464 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 35831
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.922 ms
Execution Time: 105.391 ms
(11 rows)
Time: 106.532 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1344.73..1344.74 rows=1 width=8) (actual time=104.564..104.565 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..899.82 rows=177964 width=0) (actual time=0.657..100.477 rows=151464 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 35831
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 1.018 ms
Execution Time: 104.785 ms
(11 rows)
Time: 106.041 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1344.73..1344.74 rows=1 width=8) (actual time=100.363..100.364 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..899.82 rows=177964 width=0) (actual time=0.445..96.312 rows=151464 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 35831
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.653 ms
Execution Time: 100.520 ms
(11 rows)
Time: 101.395 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1344.73..1344.74 rows=1 width=8) (actual time=97.695..97.696 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..899.82 rows=177964 width=0) (actual time=0.473..93.923 rows=151464 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 35831
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.605 ms
Execution Time: 97.886 ms
(11 rows)
Time: 98.740 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1344.73..1344.74 rows=1 width=8) (actual time=95.334..95.335 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..899.82 rows=177964 width=0) (actual time=0.608..91.574 rows=151464 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 35831
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.894 ms
Execution Time: 95.511 ms
(11 rows)
Time: 96.591 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1344.73..1344.74 rows=1 width=8) (actual time=93.428..93.429 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..899.82 rows=177964 width=0) (actual time=0.382..89.842 rows=151464 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 35831
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"test","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.611 ms
Execution Time: 93.646 ms
(11 rows)
Time: 94.421 ms
= PostgreSQL ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=21.03..21.04 rows=1 width=8) (actual time=43.098..43.099 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..17.36 rows=1471 width=0) (actual time=1.475..43.070 rows=261 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 33
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 6.713 ms
Execution Time: 43.287 ms
(11 rows)
Time: 50.711 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=21.03..21.04 rows=1 width=8) (actual time=24.654..24.664 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..17.36 rows=1471 width=0) (actual time=1.022..24.640 rows=261 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 33
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 1.111 ms
Execution Time: 24.864 ms
(11 rows)
Time: 26.123 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=21.03..21.04 rows=1 width=8) (actual time=22.354..22.355 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..17.36 rows=1471 width=0) (actual time=0.833..22.336 rows=261 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 33
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.996 ms
Execution Time: 22.580 ms
(11 rows)
Time: 23.743 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=21.03..21.04 rows=1 width=8) (actual time=22.465..22.466 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..17.36 rows=1471 width=0) (actual time=0.790..22.447 rows=261 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 33
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 1.032 ms
Execution Time: 22.677 ms
(11 rows)
Time: 23.856 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=21.03..21.04 rows=1 width=8) (actual time=19.972..19.973 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..17.36 rows=1471 width=0) (actual time=0.876..19.956 rows=261 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 33
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 1.030 ms
Execution Time: 20.064 ms
(11 rows)
Time: 21.254 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=21.03..21.04 rows=1 width=8) (actual time=19.495..19.496 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..17.36 rows=1471 width=0) (actual time=0.709..19.480 rows=261 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 33
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.889 ms
Execution Time: 19.731 ms
(11 rows)
Time: 20.778 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=21.03..21.04 rows=1 width=8) (actual time=20.951..20.952 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..17.36 rows=1471 width=0) (actual time=0.704..20.935 rows=261 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 33
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.926 ms
Execution Time: 21.129 ms
(11 rows)
Time: 22.217 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=21.03..21.04 rows=1 width=8) (actual time=20.726..20.728 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..17.36 rows=1471 width=0) (actual time=0.740..20.710 rows=261 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 33
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.922 ms
Execution Time: 20.938 ms
(11 rows)
Time: 22.148 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=21.03..21.04 rows=1 width=8) (actual time=24.848..24.849 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..17.36 rows=1471 width=0) (actual time=1.101..24.826 rows=261 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 33
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 1.438 ms
Execution Time: 25.061 ms
(11 rows)
Time: 26.718 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=21.03..21.04 rows=1 width=8) (actual time=22.883..22.884 rows=1 loops=1)
-> Custom Scan (ParadeDB Scan) on wikipedia (cost=10.00..17.36 rows=1471 width=0) (actual time=0.783..22.865 rows=261 loops=1)
Table: wikipedia
Index: wikipedia_index
Segment Count: 32
Heap Fetches: 33
Exec Method: NormalScanExecState
Scores: false
Tantivy Query: {"with_index":{"query":{"parse_with_field":{"field":"text","query_string":"PostgreSQL","lenient":null,"conjunction_mode":null}}}}
Planning Time: 0.985 ms
Execution Time: 23.106 ms
(11 rows)
Time: 24.337 ms