概要
PGroongaの実力を確認するために「続・PostgreSQL全文検索のざっくり性能比較 - pg_bigmとpg_trgmとPGroonga（Wikipediaの本文を検索する）」という記事を書きました。
ただ、pg_bigm、pg_trgm、PGroongaそれぞれが本気を出せていなかったので、改めて検証します。
本気を出せていなかったポイント
-
work_memが不足していた（特にpg_bigmとpg_trgm）- 参考: https://qiita.com/abetomo/items/8c61b1fdc2522f8f642d
- =>
work_memを増やして再検証
- 初期化処理分も加味されている
- ミリ秒の世界だと初期化処理の占める割合が多くなる
- （1セッションで1selectだと初期化処理の割合が多くなる）
- => 同じセッション内で10回selectしてその合計で再検証
- ミリ秒の世界だと初期化処理の占める割合が多くなる
-
select * from ...だと検索結果の出力に時間がかかっているかも？- つまり純粋な検索処理の時間計測になってないかも？
- =>
select count(*) from ...で再検証
-
maintenance_work_memが少なかった- これが足りないと
create indexに時間がかかる - =>
maintenance_work_memを増やして再検証
- これが足りないと
ということで検証していきます。
さっそく結論: 測定結果
インデックスの作成時間とサイズ
| 名前 | create index | index size |
|---|---|---|
| PGroonga | 約7.5分 | 約21GB |
| pg_bigm | 約32.5分 | 5672 MB |
| pg_trgm | 約40.5分 | 8989 MB |
PGroongaはインデックスの作成がかなりはやいけど、サイズはかなりでかい。
日本語の検索
10回合計版
10回同じselectを実行した合計の時間。1回あたりは1/10する。
| 名前 | 象 | 東京 | 技術者 | ロケット | データベース |
|---|---|---|---|---|---|
| PGroonga | 2567.14 ms | 2325.76 ms | 415.46 ms | 269.031 ms | 783.204 ms |
| pg_bigm | 1786.2 ms | 1929.62 ms | 9952.98 ms | 28093.4 ms | 22070.2 ms |
| pg_trgm | 316958 ms | 309122 ms | 10383.8 ms | 18080.2 ms | 22735.1 ms |
PGroongaは安定してはやそう。
中央値版（外れ値を除いて確認できる）:
| 名前 | 象 | 東京 | 技術者 | ロケット | データベース |
|---|---|---|---|---|---|
| PGroonga | 149.543 ms | 211.7625 ms | 36.6385 ms | 21.4175 ms | 75.2175 ms |
| pg_bigm | 173.649 ms | 188.83 ms | 989.861 ms | 2800.9115 ms | 2208.6955 ms |
| pg_trgm | 31450.7795 ms | 30901.3795 ms | 1049.4795 ms | 1811.9505 ms | 2235.6755 ms |
PGroongaは安定してはやそう。
アルファベットで検索
10回合計版
10回同じselectを実行した合計の時間。1回あたりは1/10する。
| 名前 | DB | test | PostgreSQL |
|---|---|---|---|
| PGroonga | 717.332 ms | 108.276 ms | 39.107 ms |
| pg_bigm | 498.294 ms | 283371 ms | 405.627 ms |
| pg_trgm | 331171 ms | 74479.5 ms | 148.271 ms |
PGroongaは安定してはやそう。
中央値版（外れ値を除いて確認できる）:
| 名前 | DB | test | PostgreSQL |
|---|---|---|---|
| PGroonga | 66.031 ms | 6.5615 ms | 2.21 ms |
| pg_bigm | 45.655 ms | 28336.0265 ms | 38.706 ms |
| pg_trgm | 33216.9575 ms | 7421.1585 ms | 13.558 ms |
PGroongaは安定してはやそう。
まとめ
それぞれ得意・不得意があるっぽいので要件に応じて使い分けると良いと思います！
参考: 短めのテキスト（Wikipediaのタイトル）で検証
以降にどのように確認したか掲載します。
環境と準備
ざっくり測定
PGroonga
#!/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=$(sudo -u postgres psql -d test_articles \
--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"
}
sudo -u postgres psql -d test_articles \
--command 'drop index if exists wikipedia_index' \
--command "set maintenance_work_mem = '8GB'" \
--command "\timing" \
--command "create index wikipedia_index on wikipedia using pgroonga (title, text);"
run_select "象"
run_select "東京"
run_select "技術者"
run_select "ロケット"
run_select "データベース"
run_select "DB"
run_select "test"
run_select "PostgreSQL"
sudo -u postgres psql -d test_articles --command "select pg_size_pretty(pg_relation_size('wikipedia_index'));"
db_oid=$(sudo -u postgres psql -d test_articles \
--no-align \
--tuples-only \
--command "SELECT oid FROM pg_database where datname = 'test_articles';")
sudo -u postgres psql -d test_articles --command "vacuum;"
ls -l /var/lib/postgresql/17/main/base/${db_oid}/pgrn* | awk '{ size += $5 } END { print size }
$ ./article/run-pgroonga.sh 2> log
DROP INDEX
SET
Timing is on.
CREATE INDEX
Time: 453309.235 ms (07:33.309)
Query: 象, Total 2567.14 ms
Query: 東京, Total 2325.76 ms
Query: 技術者, Total 415.46 ms
Query: ロケット, Total 269.031 ms
Query: データベース, Total 783.204 ms
Query: DB, Total 717.332 ms
Query: test, Total 108.276 ms
Query: PostgreSQL, Total 39.107 ms
pg_size_pretty
----------------
0 bytes
(1 row)
VACUUM
23021187072
log
= 象 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=962.05..962.06 rows=1 width=8) (actual time=1156.674..1156.675 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..958.39 rows=1464 width=0) (actual time=29.522..1151.832 rows=192783 loops=1)
Index Cond: (text &@ '象'::text)
Planning Time: 44.773 ms
Execution Time: 1157.333 ms
(5 rows)
Time: 1209.693 ms (00:01.210)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=962.05..962.06 rows=1 width=8) (actual time=153.812..153.813 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..958.39 rows=1464 width=0) (actual time=22.167..148.743 rows=192783 loops=1)
Index Cond: (text &@ '象'::text)
Planning Time: 1.328 ms
Execution Time: 154.135 ms
(5 rows)
Time: 155.644 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=962.05..962.06 rows=1 width=8) (actual time=158.373..158.374 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..958.39 rows=1464 width=0) (actual time=22.698..153.666 rows=192783 loops=1)
Index Cond: (text &@ '象'::text)
Planning Time: 1.154 ms
Execution Time: 158.787 ms
(5 rows)
Time: 160.103 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=962.05..962.06 rows=1 width=8) (actual time=146.715..146.716 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..958.39 rows=1464 width=0) (actual time=22.655..142.801 rows=192783 loops=1)
Index Cond: (text &@ '象'::text)
Planning Time: 1.225 ms
Execution Time: 147.030 ms
(5 rows)
Time: 148.452 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=962.05..962.06 rows=1 width=8) (actual time=145.922..145.922 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..958.39 rows=1464 width=0) (actual time=22.337..141.775 rows=192783 loops=1)
Index Cond: (text &@ '象'::text)
Planning Time: 1.191 ms
Execution Time: 146.240 ms
(5 rows)
Time: 147.645 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=962.05..962.06 rows=1 width=8) (actual time=146.380..146.381 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..958.39 rows=1464 width=0) (actual time=22.531..142.293 rows=192783 loops=1)
Index Cond: (text &@ '象'::text)
Planning Time: 1.218 ms
Execution Time: 146.710 ms
(5 rows)
Time: 148.107 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=962.05..962.06 rows=1 width=8) (actual time=148.324..148.325 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..958.39 rows=1464 width=0) (actual time=22.714..143.950 rows=192783 loops=1)
Index Cond: (text &@ '象'::text)
Planning Time: 1.223 ms
Execution Time: 148.817 ms
(5 rows)
Time: 150.258 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=962.05..962.06 rows=1 width=8) (actual time=147.739..147.740 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..958.39 rows=1464 width=0) (actual time=23.086..143.583 rows=192783 loops=1)
Index Cond: (text &@ '象'::text)
Planning Time: 1.210 ms
Execution Time: 148.057 ms
(5 rows)
Time: 149.477 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=962.05..962.06 rows=1 width=8) (actual time=147.946..147.947 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..958.39 rows=1464 width=0) (actual time=22.696..143.666 rows=192783 loops=1)
Index Cond: (text &@ '象'::text)
Planning Time: 1.188 ms
Execution Time: 148.263 ms
(5 rows)
Time: 149.609 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=962.05..962.06 rows=1 width=8) (actual time=146.441..146.441 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..958.39 rows=1464 width=0) (actual time=22.127..142.161 rows=192783 loops=1)
Index Cond: (text &@ '象'::text)
Planning Time: 1.218 ms
Execution Time: 146.759 ms
(5 rows)
Time: 148.157 ms
= 東京 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=379434.99..379435.00 rows=1 width=8) (actual time=291.904..291.905 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..379431.33 rows=1464 width=0) (actual time=62.541..284.660 rows=371644 loops=1)
Recheck Cond: (text &@ '東京'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=371646 width=0) (actual time=34.891..34.891 rows=371644 loops=1)
Index Cond: (text &@ '東京'::text)
Planning Time: 17.520 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.311 ms (Deform 0.032 ms), Inlining 0.000 ms, Optimization 2.628 ms, Emission 16.755 ms, Total 19.694 ms
Execution Time: 402.802 ms
(12 rows)
Time: 420.817 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=379434.99..379435.00 rows=1 width=8) (actual time=212.328..212.330 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..379431.33 rows=1464 width=0) (actual time=43.211..205.268 rows=371644 loops=1)
Recheck Cond: (text &@ '東京'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=371646 width=0) (actual time=33.806..33.806 rows=371644 loops=1)
Index Cond: (text &@ '東京'::text)
Planning Time: 0.176 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.102 ms (Deform 0.029 ms), Inlining 0.000 ms, Optimization 0.118 ms, Emission 1.096 ms, Total 1.317 ms
Execution Time: 212.859 ms
(12 rows)
Time: 213.223 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=379434.99..379435.00 rows=1 width=8) (actual time=211.132..211.133 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..379431.33 rows=1464 width=0) (actual time=42.319..204.097 rows=371644 loops=1)
Recheck Cond: (text &@ '東京'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=371646 width=0) (actual time=32.900..32.900 rows=371644 loops=1)
Index Cond: (text &@ '東京'::text)
Planning Time: 0.192 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.110 ms (Deform 0.031 ms), Inlining 0.000 ms, Optimization 0.116 ms, Emission 1.078 ms, Total 1.304 ms
Execution Time: 211.661 ms
(12 rows)
Time: 212.025 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=379434.99..379435.00 rows=1 width=8) (actual time=210.341..210.342 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..379431.33 rows=1464 width=0) (actual time=41.800..203.292 rows=371644 loops=1)
Recheck Cond: (text &@ '東京'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=371646 width=0) (actual time=32.379..32.379 rows=371644 loops=1)
Index Cond: (text &@ '東京'::text)
Planning Time: 0.184 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.111 ms (Deform 0.036 ms), Inlining 0.000 ms, Optimization 0.112 ms, Emission 1.079 ms, Total 1.302 ms
Execution Time: 210.866 ms
(12 rows)
Time: 211.279 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=379434.99..379435.00 rows=1 width=8) (actual time=209.616..209.617 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..379431.33 rows=1464 width=0) (actual time=41.181..202.563 rows=371644 loops=1)
Recheck Cond: (text &@ '東京'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=371646 width=0) (actual time=31.843..31.843 rows=371644 loops=1)
Index Cond: (text &@ '東京'::text)
Planning Time: 0.229 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.114 ms (Deform 0.032 ms), Inlining 0.000 ms, Optimization 0.119 ms, Emission 1.094 ms, Total 1.328 ms
Execution Time: 210.149 ms
(12 rows)
Time: 210.547 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=379434.99..379435.00 rows=1 width=8) (actual time=210.588..210.589 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..379431.33 rows=1464 width=0) (actual time=42.870..203.546 rows=371644 loops=1)
Recheck Cond: (text &@ '東京'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=371646 width=0) (actual time=33.392..33.392 rows=371644 loops=1)
Index Cond: (text &@ '東京'::text)
Planning Time: 0.187 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.129 ms (Deform 0.031 ms), Inlining 0.000 ms, Optimization 0.116 ms, Emission 1.118 ms, Total 1.363 ms
Execution Time: 211.135 ms
(12 rows)
Time: 211.500 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=379434.99..379435.00 rows=1 width=8) (actual time=209.942..209.942 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..379431.33 rows=1464 width=0) (actual time=42.384..202.917 rows=371644 loops=1)
Recheck Cond: (text &@ '東京'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=371646 width=0) (actual time=33.002..33.002 rows=371644 loops=1)
Index Cond: (text &@ '東京'::text)
Planning Time: 0.183 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.099 ms (Deform 0.028 ms), Inlining 0.000 ms, Optimization 0.115 ms, Emission 1.156 ms, Total 1.370 ms
Execution Time: 210.486 ms
(12 rows)
Time: 210.862 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=379434.99..379435.00 rows=1 width=8) (actual time=211.577..211.578 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..379431.33 rows=1464 width=0) (actual time=42.404..204.511 rows=371644 loops=1)
Recheck Cond: (text &@ '東京'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=371646 width=0) (actual time=33.076..33.076 rows=371644 loops=1)
Index Cond: (text &@ '東京'::text)
Planning Time: 0.187 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.116 ms (Deform 0.031 ms), Inlining 0.000 ms, Optimization 0.117 ms, Emission 1.073 ms, Total 1.305 ms
Execution Time: 212.173 ms
(12 rows)
Time: 212.526 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=379434.99..379435.00 rows=1 width=8) (actual time=211.125..211.125 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..379431.33 rows=1464 width=0) (actual time=41.877..204.062 rows=371644 loops=1)
Recheck Cond: (text &@ '東京'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=371646 width=0) (actual time=32.584..32.585 rows=371644 loops=1)
Index Cond: (text &@ '東京'::text)
Planning Time: 0.204 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.110 ms (Deform 0.032 ms), Inlining 0.000 ms, Optimization 0.115 ms, Emission 1.088 ms, Total 1.312 ms
Execution Time: 211.645 ms
(12 rows)
Time: 212.030 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=379434.99..379435.00 rows=1 width=8) (actual time=210.059..210.059 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..379431.33 rows=1464 width=0) (actual time=41.624..203.009 rows=371644 loops=1)
Recheck Cond: (text &@ '東京'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=371646 width=0) (actual time=32.375..32.375 rows=371644 loops=1)
Index Cond: (text &@ '東京'::text)
Planning Time: 0.189 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.109 ms (Deform 0.029 ms), Inlining 0.000 ms, Optimization 0.114 ms, Emission 1.081 ms, Total 1.304 ms
Execution Time: 210.586 ms
(12 rows)
Time: 210.949 ms
= 技術者 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=61150.85..61150.86 rows=1 width=8) (actual time=59.364..59.365 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..61147.19 rows=1464 width=0) (actual time=11.662..58.898 rows=19974 loops=1)
Recheck Cond: (text &@ '技術者'::text)
Heap Blocks: exact=16545
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=18767 width=0) (actual time=10.136..10.137 rows=19974 loops=1)
Index Cond: (text &@ '技術者'::text)
Planning Time: 21.395 ms
Execution Time: 59.674 ms
(8 rows)
Time: 81.611 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=61150.85..61150.86 rows=1 width=8) (actual time=37.075..37.076 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..61147.19 rows=1464 width=0) (actual time=8.774..36.681 rows=19974 loops=1)
Recheck Cond: (text &@ '技術者'::text)
Heap Blocks: exact=16545
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=18767 width=0) (actual time=7.354..7.355 rows=19974 loops=1)
Index Cond: (text &@ '技術者'::text)
Planning Time: 0.232 ms
Execution Time: 37.355 ms
(8 rows)
Time: 37.730 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=61150.85..61150.86 rows=1 width=8) (actual time=38.692..38.692 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..61147.19 rows=1464 width=0) (actual time=9.503..38.286 rows=19974 loops=1)
Recheck Cond: (text &@ '技術者'::text)
Heap Blocks: exact=16545
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=18767 width=0) (actual time=8.084..8.084 rows=19974 loops=1)
Index Cond: (text &@ '技術者'::text)
Planning Time: 0.256 ms
Execution Time: 38.983 ms
(8 rows)
Time: 39.450 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=61150.85..61150.86 rows=1 width=8) (actual time=37.531..37.531 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..61147.19 rows=1464 width=0) (actual time=8.982..37.126 rows=19974 loops=1)
Recheck Cond: (text &@ '技術者'::text)
Heap Blocks: exact=16545
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=18767 width=0) (actual time=7.570..7.570 rows=19974 loops=1)
Index Cond: (text &@ '技術者'::text)
Planning Time: 0.255 ms
Execution Time: 37.813 ms
(8 rows)
Time: 38.221 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=61150.85..61150.86 rows=1 width=8) (actual time=35.897..35.897 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..61147.19 rows=1464 width=0) (actual time=8.654..35.503 rows=19974 loops=1)
Recheck Cond: (text &@ '技術者'::text)
Heap Blocks: exact=16545
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=18767 width=0) (actual time=7.335..7.335 rows=19974 loops=1)
Index Cond: (text &@ '技術者'::text)
Planning Time: 0.241 ms
Execution Time: 36.163 ms
(8 rows)
Time: 36.568 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=61150.85..61150.86 rows=1 width=8) (actual time=35.416..35.416 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..61147.19 rows=1464 width=0) (actual time=8.414..35.019 rows=19974 loops=1)
Recheck Cond: (text &@ '技術者'::text)
Heap Blocks: exact=16545
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=18767 width=0) (actual time=7.105..7.105 rows=19974 loops=1)
Index Cond: (text &@ '技術者'::text)
Planning Time: 0.229 ms
Execution Time: 35.677 ms
(8 rows)
Time: 36.058 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=61150.85..61150.86 rows=1 width=8) (actual time=35.717..35.718 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..61147.19 rows=1464 width=0) (actual time=8.423..35.303 rows=19974 loops=1)
Recheck Cond: (text &@ '技術者'::text)
Heap Blocks: exact=16545
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=18767 width=0) (actual time=7.097..7.097 rows=19974 loops=1)
Index Cond: (text &@ '技術者'::text)
Planning Time: 0.227 ms
Execution Time: 35.986 ms
(8 rows)
Time: 36.361 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=61150.85..61150.86 rows=1 width=8) (actual time=36.040..36.041 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..61147.19 rows=1464 width=0) (actual time=8.431..35.629 rows=19974 loops=1)
Recheck Cond: (text &@ '技術者'::text)
Heap Blocks: exact=16545
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=18767 width=0) (actual time=7.065..7.066 rows=19974 loops=1)
Index Cond: (text &@ '技術者'::text)
Planning Time: 0.238 ms
Execution Time: 36.312 ms
(8 rows)
Time: 36.709 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=61150.85..61150.86 rows=1 width=8) (actual time=35.779..35.779 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..61147.19 rows=1464 width=0) (actual time=8.296..35.383 rows=19974 loops=1)
Recheck Cond: (text &@ '技術者'::text)
Heap Blocks: exact=16545
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=18767 width=0) (actual time=6.981..6.981 rows=19974 loops=1)
Index Cond: (text &@ '技術者'::text)
Planning Time: 0.239 ms
Execution Time: 36.055 ms
(8 rows)
Time: 36.454 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=61150.85..61150.86 rows=1 width=8) (actual time=35.609..35.609 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..61147.19 rows=1464 width=0) (actual time=8.376..35.212 rows=19974 loops=1)
Recheck Cond: (text &@ '技術者'::text)
Heap Blocks: exact=16545
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=18767 width=0) (actual time=7.065..7.065 rows=19974 loops=1)
Index Cond: (text &@ '技術者'::text)
Planning Time: 0.275 ms
Execution Time: 35.878 ms
(8 rows)
Time: 36.298 ms
= ロケット ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=94741.34..94741.35 rows=1 width=8) (actual time=58.646..58.647 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..94737.68 rows=1464 width=0) (actual time=21.196..58.245 rows=18083 loops=1)
Recheck Cond: (text &@ 'ロケット'::text)
Heap Blocks: exact=14982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=34310 width=0) (actual time=19.927..19.927 rows=18083 loops=1)
Index Cond: (text &@ 'ロケット'::text)
Planning Time: 15.860 ms
Execution Time: 58.917 ms
(8 rows)
Time: 75.170 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=94741.34..94741.35 rows=1 width=8) (actual time=22.228..22.228 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..94737.68 rows=1464 width=0) (actual time=16.580..21.913 rows=18083 loops=1)
Recheck Cond: (text &@ 'ロケット'::text)
Heap Blocks: exact=14982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=34310 width=0) (actual time=15.396..15.396 rows=18083 loops=1)
Index Cond: (text &@ 'ロケット'::text)
Planning Time: 0.214 ms
Execution Time: 22.457 ms
(8 rows)
Time: 22.804 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=94741.34..94741.35 rows=1 width=8) (actual time=21.335..21.335 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..94737.68 rows=1464 width=0) (actual time=16.283..21.017 rows=18083 loops=1)
Recheck Cond: (text &@ 'ロケット'::text)
Heap Blocks: exact=14982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=34310 width=0) (actual time=15.094..15.094 rows=18083 loops=1)
Index Cond: (text &@ 'ロケット'::text)
Planning Time: 0.223 ms
Execution Time: 21.584 ms
(8 rows)
Time: 21.916 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=94741.34..94741.35 rows=1 width=8) (actual time=20.906..20.907 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..94737.68 rows=1464 width=0) (actual time=16.085..20.587 rows=18083 loops=1)
Recheck Cond: (text &@ 'ロケット'::text)
Heap Blocks: exact=14982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=34310 width=0) (actual time=14.885..14.885 rows=18083 loops=1)
Index Cond: (text &@ 'ロケット'::text)
Planning Time: 0.259 ms
Execution Time: 21.129 ms
(8 rows)
Time: 21.535 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=94741.34..94741.35 rows=1 width=8) (actual time=20.674..20.675 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..94737.68 rows=1464 width=0) (actual time=16.058..20.359 rows=18083 loops=1)
Recheck Cond: (text &@ 'ロケット'::text)
Heap Blocks: exact=14982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=34310 width=0) (actual time=14.879..14.879 rows=18083 loops=1)
Index Cond: (text &@ 'ロケット'::text)
Planning Time: 0.242 ms
Execution Time: 20.888 ms
(8 rows)
Time: 21.242 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=94741.34..94741.35 rows=1 width=8) (actual time=20.522..20.522 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..94737.68 rows=1464 width=0) (actual time=15.917..20.207 rows=18083 loops=1)
Recheck Cond: (text &@ 'ロケット'::text)
Heap Blocks: exact=14982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=34310 width=0) (actual time=14.705..14.705 rows=18083 loops=1)
Index Cond: (text &@ 'ロケット'::text)
Planning Time: 0.224 ms
Execution Time: 20.731 ms
(8 rows)
Time: 21.064 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=94741.34..94741.35 rows=1 width=8) (actual time=21.052..21.052 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..94737.68 rows=1464 width=0) (actual time=16.365..20.732 rows=18083 loops=1)
Recheck Cond: (text &@ 'ロケット'::text)
Heap Blocks: exact=14982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=34310 width=0) (actual time=15.180..15.180 rows=18083 loops=1)
Index Cond: (text &@ 'ロケット'::text)
Planning Time: 0.232 ms
Execution Time: 21.278 ms
(8 rows)
Time: 21.625 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=94741.34..94741.35 rows=1 width=8) (actual time=20.554..20.554 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..94737.68 rows=1464 width=0) (actual time=16.064..20.235 rows=18083 loops=1)
Recheck Cond: (text &@ 'ロケット'::text)
Heap Blocks: exact=14982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=34310 width=0) (actual time=14.867..14.867 rows=18083 loops=1)
Index Cond: (text &@ 'ロケット'::text)
Planning Time: 0.234 ms
Execution Time: 20.775 ms
(8 rows)
Time: 21.120 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=94741.34..94741.35 rows=1 width=8) (actual time=20.673..20.673 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..94737.68 rows=1464 width=0) (actual time=16.010..20.358 rows=18083 loops=1)
Recheck Cond: (text &@ 'ロケット'::text)
Heap Blocks: exact=14982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=34310 width=0) (actual time=14.836..14.836 rows=18083 loops=1)
Index Cond: (text &@ 'ロケット'::text)
Planning Time: 0.225 ms
Execution Time: 20.893 ms
(8 rows)
Time: 21.255 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=94741.34..94741.35 rows=1 width=8) (actual time=20.707..20.708 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..94737.68 rows=1464 width=0) (actual time=16.096..20.388 rows=18083 loops=1)
Recheck Cond: (text &@ 'ロケット'::text)
Heap Blocks: exact=14982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=34310 width=0) (actual time=14.906..14.906 rows=18083 loops=1)
Index Cond: (text &@ 'ロケット'::text)
Planning Time: 0.265 ms
Execution Time: 20.921 ms
(8 rows)
Time: 21.300 ms
= データベース ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=83191.26..83191.27 rows=1 width=8) (actual time=89.908..89.909 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..83187.60 rows=1464 width=0) (actual time=29.843..89.117 rows=39439 loops=1)
Recheck Cond: (text &@ 'データベース'::text)
Heap Blocks: exact=28991
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=28435 width=0) (actual time=27.376..27.376 rows=39439 loops=1)
Index Cond: (text &@ 'データベース'::text)
Planning Time: 14.796 ms
Execution Time: 90.284 ms
(8 rows)
Time: 105.378 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=83191.26..83191.27 rows=1 width=8) (actual time=73.870..73.870 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..83187.60 rows=1464 width=0) (actual time=26.233..73.086 rows=39439 loops=1)
Recheck Cond: (text &@ 'データベース'::text)
Heap Blocks: exact=28991
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=28435 width=0) (actual time=23.785..23.785 rows=39439 loops=1)
Index Cond: (text &@ 'データベース'::text)
Planning Time: 0.335 ms
Execution Time: 74.289 ms
(8 rows)
Time: 74.842 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=83191.26..83191.27 rows=1 width=8) (actual time=74.472..74.473 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..83187.60 rows=1464 width=0) (actual time=26.921..73.668 rows=39439 loops=1)
Recheck Cond: (text &@ 'データベース'::text)
Heap Blocks: exact=28991
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=28435 width=0) (actual time=24.466..24.466 rows=39439 loops=1)
Index Cond: (text &@ 'データベース'::text)
Planning Time: 0.472 ms
Execution Time: 74.890 ms
(8 rows)
Time: 75.526 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=83191.26..83191.27 rows=1 width=8) (actual time=74.203..74.204 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..83187.60 rows=1464 width=0) (actual time=26.346..73.411 rows=39439 loops=1)
Recheck Cond: (text &@ 'データベース'::text)
Heap Blocks: exact=28991
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=28435 width=0) (actual time=23.901..23.901 rows=39439 loops=1)
Index Cond: (text &@ 'データベース'::text)
Planning Time: 0.429 ms
Execution Time: 74.614 ms
(8 rows)
Time: 75.159 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=83191.26..83191.27 rows=1 width=8) (actual time=77.284..77.285 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..83187.60 rows=1464 width=0) (actual time=26.865..76.498 rows=39439 loops=1)
Recheck Cond: (text &@ 'データベース'::text)
Heap Blocks: exact=28991
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=28435 width=0) (actual time=24.194..24.194 rows=39439 loops=1)
Index Cond: (text &@ 'データベース'::text)
Planning Time: 0.390 ms
Execution Time: 77.800 ms
(8 rows)
Time: 78.345 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=83191.26..83191.27 rows=1 width=8) (actual time=74.512..74.512 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..83187.60 rows=1464 width=0) (actual time=25.956..73.736 rows=39439 loops=1)
Recheck Cond: (text &@ 'データベース'::text)
Heap Blocks: exact=28991
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=28435 width=0) (actual time=23.502..23.503 rows=39439 loops=1)
Index Cond: (text &@ 'データベース'::text)
Planning Time: 0.393 ms
Execution Time: 74.979 ms
(8 rows)
Time: 75.591 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=83191.26..83191.27 rows=1 width=8) (actual time=73.336..73.337 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..83187.60 rows=1464 width=0) (actual time=25.745..72.558 rows=39439 loops=1)
Recheck Cond: (text &@ 'データベース'::text)
Heap Blocks: exact=28991
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=28435 width=0) (actual time=23.312..23.312 rows=39439 loops=1)
Index Cond: (text &@ 'データベース'::text)
Planning Time: 0.387 ms
Execution Time: 73.733 ms
(8 rows)
Time: 74.322 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=83191.26..83191.27 rows=1 width=8) (actual time=74.308..74.308 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..83187.60 rows=1464 width=0) (actual time=25.579..73.504 rows=39439 loops=1)
Recheck Cond: (text &@ 'データベース'::text)
Heap Blocks: exact=28991
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=28435 width=0) (actual time=23.130..23.130 rows=39439 loops=1)
Index Cond: (text &@ 'データベース'::text)
Planning Time: 0.377 ms
Execution Time: 74.772 ms
(8 rows)
Time: 75.276 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=83191.26..83191.27 rows=1 width=8) (actual time=73.711..73.712 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..83187.60 rows=1464 width=0) (actual time=25.912..72.932 rows=39439 loops=1)
Recheck Cond: (text &@ 'データベース'::text)
Heap Blocks: exact=28991
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=28435 width=0) (actual time=23.459..23.459 rows=39439 loops=1)
Index Cond: (text &@ 'データベース'::text)
Planning Time: 0.399 ms
Execution Time: 74.116 ms
(8 rows)
Time: 74.672 ms
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=83191.26..83191.27 rows=1 width=8) (actual time=73.144..73.145 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..83187.60 rows=1464 width=0) (actual time=25.513..72.366 rows=39439 loops=1)
Recheck Cond: (text &@ 'データベース'::text)
Heap Blocks: exact=28991
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=28435 width=0) (actual time=23.063..23.063 rows=39439 loops=1)
Index Cond: (text &@ 'データベース'::text)
Planning Time: 0.388 ms
Execution Time: 73.549 ms
(8 rows)
Time: 74.093 ms
= DB ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=113754.09..113754.10 rows=1 width=8) (actual time=87.136..87.137 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..113750.43 rows=1464 width=0) (actual time=15.562..86.121 rows=45440 loops=1)
Recheck Cond: (text &@ 'DB'::text)
Heap Blocks: exact=31857
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=45442 width=0) (actual time=10.642..10.643 rows=45440 loops=1)
Index Cond: (text &@ 'DB'::text)
Planning Time: 17.672 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.111 ms (Deform 0.033 ms), Inlining 0.000 ms, Optimization 0.142 ms, Emission 1.776 ms, Total 2.028 ms
Execution Time: 101.232 ms
(12 rows)
Time: 119.430 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=113754.09..113754.10 rows=1 width=8) (actual time=66.635..66.636 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..113750.43 rows=1464 width=0) (actual time=12.615..65.717 rows=45440 loops=1)
Recheck Cond: (text &@ 'DB'::text)
Heap Blocks: exact=31857
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=45442 width=0) (actual time=8.630..8.630 rows=45440 loops=1)
Index Cond: (text &@ 'DB'::text)
Planning Time: 0.200 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.102 ms (Deform 0.028 ms), Inlining 0.000 ms, Optimization 0.103 ms, Emission 1.126 ms, Total 1.331 ms
Execution Time: 67.023 ms
(12 rows)
Time: 67.410 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=113754.09..113754.10 rows=1 width=8) (actual time=65.189..65.190 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..113750.43 rows=1464 width=0) (actual time=11.544..64.273 rows=45440 loops=1)
Recheck Cond: (text &@ 'DB'::text)
Heap Blocks: exact=31857
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=45442 width=0) (actual time=7.652..7.652 rows=45440 loops=1)
Index Cond: (text &@ 'DB'::text)
Planning Time: 0.193 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.109 ms (Deform 0.030 ms), Inlining 0.000 ms, Optimization 0.091 ms, Emission 1.060 ms, Total 1.260 ms
Execution Time: 65.600 ms
(12 rows)
Time: 66.006 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=113754.09..113754.10 rows=1 width=8) (actual time=65.217..65.218 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..113750.43 rows=1464 width=0) (actual time=11.778..64.298 rows=45440 loops=1)
Recheck Cond: (text &@ 'DB'::text)
Heap Blocks: exact=31857
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=45442 width=0) (actual time=7.866..7.867 rows=45440 loops=1)
Index Cond: (text &@ 'DB'::text)
Planning Time: 0.203 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.107 ms (Deform 0.030 ms), Inlining 0.000 ms, Optimization 0.091 ms, Emission 1.073 ms, Total 1.271 ms
Execution Time: 65.625 ms
(12 rows)
Time: 66.019 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=113754.09..113754.10 rows=1 width=8) (actual time=65.479..65.480 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..113750.43 rows=1464 width=0) (actual time=11.797..64.559 rows=45440 loops=1)
Recheck Cond: (text &@ 'DB'::text)
Heap Blocks: exact=31857
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=45442 width=0) (actual time=7.877..7.877 rows=45440 loops=1)
Index Cond: (text &@ 'DB'::text)
Planning Time: 0.195 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.133 ms (Deform 0.059 ms), Inlining 0.000 ms, Optimization 0.102 ms, Emission 1.089 ms, Total 1.325 ms
Execution Time: 65.885 ms
(12 rows)
Time: 66.261 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=113754.09..113754.10 rows=1 width=8) (actual time=65.269..65.270 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..113750.43 rows=1464 width=0) (actual time=11.976..64.327 rows=45440 loops=1)
Recheck Cond: (text &@ 'DB'::text)
Heap Blocks: exact=31857
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=45442 width=0) (actual time=8.038..8.038 rows=45440 loops=1)
Index Cond: (text &@ 'DB'::text)
Planning Time: 0.209 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.107 ms (Deform 0.035 ms), Inlining 0.000 ms, Optimization 0.130 ms, Emission 1.111 ms, Total 1.348 ms
Execution Time: 65.653 ms
(12 rows)
Time: 66.043 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=113754.09..113754.10 rows=1 width=8) (actual time=64.420..64.420 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..113750.43 rows=1464 width=0) (actual time=11.364..63.501 rows=45440 loops=1)
Recheck Cond: (text &@ 'DB'::text)
Heap Blocks: exact=31857
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=45442 width=0) (actual time=7.534..7.534 rows=45440 loops=1)
Index Cond: (text &@ 'DB'::text)
Planning Time: 0.202 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.095 ms (Deform 0.027 ms), Inlining 0.000 ms, Optimization 0.091 ms, Emission 1.040 ms, Total 1.225 ms
Execution Time: 64.800 ms
(12 rows)
Time: 65.211 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=113754.09..113754.10 rows=1 width=8) (actual time=68.697..68.698 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..113750.43 rows=1464 width=0) (actual time=11.885..67.757 rows=45440 loops=1)
Recheck Cond: (text &@ 'DB'::text)
Heap Blocks: exact=31857
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=45442 width=0) (actual time=7.937..7.937 rows=45440 loops=1)
Index Cond: (text &@ 'DB'::text)
Planning Time: 0.192 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.104 ms (Deform 0.030 ms), Inlining 0.000 ms, Optimization 0.113 ms, Emission 1.146 ms, Total 1.364 ms
Execution Time: 69.090 ms
(12 rows)
Time: 69.467 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=113754.09..113754.10 rows=1 width=8) (actual time=64.652..64.652 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..113750.43 rows=1464 width=0) (actual time=11.598..63.722 rows=45440 loops=1)
Recheck Cond: (text &@ 'DB'::text)
Heap Blocks: exact=31857
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=45442 width=0) (actual time=7.700..7.700 rows=45440 loops=1)
Index Cond: (text &@ 'DB'::text)
Planning Time: 0.204 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.111 ms (Deform 0.031 ms), Inlining 0.000 ms, Optimization 0.108 ms, Emission 1.076 ms, Total 1.296 ms
Execution Time: 65.073 ms
(12 rows)
Time: 65.476 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=113754.09..113754.10 rows=1 width=8) (actual time=65.265..65.266 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..113750.43 rows=1464 width=0) (actual time=11.694..64.351 rows=45440 loops=1)
Recheck Cond: (text &@ 'DB'::text)
Heap Blocks: exact=31857
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=45442 width=0) (actual time=7.836..7.836 rows=45440 loops=1)
Index Cond: (text &@ 'DB'::text)
Planning Time: 0.182 ms
JIT:
Functions: 5
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.109 ms (Deform 0.030 ms), Inlining 0.000 ms, Optimization 0.097 ms, Emission 1.042 ms, Total 1.248 ms
Execution Time: 65.652 ms
(12 rows)
Time: 66.009 ms
= test ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=34044.82..34044.83 rows=1 width=8) (actual time=29.499..29.499 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..34041.16 rows=1464 width=0) (actual time=6.080..29.285 rows=9149 loops=1)
Recheck Cond: (text &@ 'test'::text)
Heap Blocks: exact=8306
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=9151 width=0) (actual time=5.312..5.312 rows=9149 loops=1)
Index Cond: (text &@ 'test'::text)
Planning Time: 17.001 ms
Execution Time: 29.780 ms
(8 rows)
Time: 47.274 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=34044.82..34044.83 rows=1 width=8) (actual time=7.613..7.613 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..34041.16 rows=1464 width=0) (actual time=4.472..7.444 rows=9149 loops=1)
Recheck Cond: (text &@ 'test'::text)
Heap Blocks: exact=8306
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=9151 width=0) (actual time=3.803..3.803 rows=9149 loops=1)
Index Cond: (text &@ 'test'::text)
Planning Time: 0.169 ms
Execution Time: 7.825 ms
(8 rows)
Time: 8.123 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=34044.82..34044.83 rows=1 width=8) (actual time=7.696..7.697 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..34041.16 rows=1464 width=0) (actual time=4.836..7.521 rows=9149 loops=1)
Recheck Cond: (text &@ 'test'::text)
Heap Blocks: exact=8306
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=9151 width=0) (actual time=4.171..4.171 rows=9149 loops=1)
Index Cond: (text &@ 'test'::text)
Planning Time: 0.135 ms
Execution Time: 7.924 ms
(8 rows)
Time: 8.244 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=34044.82..34044.83 rows=1 width=8) (actual time=6.304..6.304 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..34041.16 rows=1464 width=0) (actual time=3.901..6.135 rows=9149 loops=1)
Recheck Cond: (text &@ 'test'::text)
Heap Blocks: exact=8306
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=9151 width=0) (actual time=3.233..3.233 rows=9149 loops=1)
Index Cond: (text &@ 'test'::text)
Planning Time: 0.127 ms
Execution Time: 6.496 ms
(8 rows)
Time: 6.783 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=34044.82..34044.83 rows=1 width=8) (actual time=5.960..5.961 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..34041.16 rows=1464 width=0) (actual time=3.686..5.787 rows=9149 loops=1)
Recheck Cond: (text &@ 'test'::text)
Heap Blocks: exact=8306
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=9151 width=0) (actual time=3.022..3.022 rows=9149 loops=1)
Index Cond: (text &@ 'test'::text)
Planning Time: 0.123 ms
Execution Time: 6.147 ms
(8 rows)
Time: 6.427 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=34044.82..34044.83 rows=1 width=8) (actual time=5.872..5.872 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..34041.16 rows=1464 width=0) (actual time=3.622..5.704 rows=9149 loops=1)
Recheck Cond: (text &@ 'test'::text)
Heap Blocks: exact=8306
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=9151 width=0) (actual time=2.961..2.961 rows=9149 loops=1)
Index Cond: (text &@ 'test'::text)
Planning Time: 0.113 ms
Execution Time: 6.055 ms
(8 rows)
Time: 6.272 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=34044.82..34044.83 rows=1 width=8) (actual time=6.128..6.128 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..34041.16 rows=1464 width=0) (actual time=3.859..5.956 rows=9149 loops=1)
Recheck Cond: (text &@ 'test'::text)
Heap Blocks: exact=8306
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=9151 width=0) (actual time=3.198..3.199 rows=9149 loops=1)
Index Cond: (text &@ 'test'::text)
Planning Time: 0.128 ms
Execution Time: 6.473 ms
(8 rows)
Time: 6.696 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=34044.82..34044.83 rows=1 width=8) (actual time=5.831..5.831 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..34041.16 rows=1464 width=0) (actual time=3.605..5.665 rows=9149 loops=1)
Recheck Cond: (text &@ 'test'::text)
Heap Blocks: exact=8306
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=9151 width=0) (actual time=2.962..2.962 rows=9149 loops=1)
Index Cond: (text &@ 'test'::text)
Planning Time: 0.120 ms
Execution Time: 6.005 ms
(8 rows)
Time: 6.256 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=34044.82..34044.83 rows=1 width=8) (actual time=5.774..5.774 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..34041.16 rows=1464 width=0) (actual time=3.577..5.602 rows=9149 loops=1)
Recheck Cond: (text &@ 'test'::text)
Heap Blocks: exact=8306
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=9151 width=0) (actual time=2.911..2.911 rows=9149 loops=1)
Index Cond: (text &@ 'test'::text)
Planning Time: 0.109 ms
Execution Time: 5.955 ms
(8 rows)
Time: 6.119 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=34044.82..34044.83 rows=1 width=8) (actual time=5.725..5.725 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=0.37..34041.16 rows=1464 width=0) (actual time=3.579..5.552 rows=9149 loops=1)
Recheck Cond: (text &@ 'test'::text)
Heap Blocks: exact=8306
-> Bitmap Index Scan on wikipedia_index (cost=0.00..0.00 rows=9151 width=0) (actual time=2.917..2.917 rows=9149 loops=1)
Index Cond: (text &@ 'test'::text)
Planning Time: 0.129 ms
Execution Time: 5.905 ms
(8 rows)
Time: 6.082 ms
= PostgreSQL ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1054.28..1054.29 rows=1 width=8) (actual time=3.531..3.532 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..1050.62 rows=1464 width=0) (actual time=2.211..3.523 rows=260 loops=1)
Index Cond: (text &@ 'PostgreSQL'::text)
Planning Time: 15.582 ms
Execution Time: 3.790 ms
(5 rows)
Time: 19.744 ms
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1054.28..1054.29 rows=1 width=8) (actual time=2.107..2.107 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..1050.62 rows=1464 width=0) (actual time=1.980..2.101 rows=260 loops=1)
Index Cond: (text &@ 'PostgreSQL'::text)
Planning Time: 0.118 ms
Execution Time: 2.309 ms
(5 rows)
Time: 2.572 ms
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1054.28..1054.29 rows=1 width=8) (actual time=1.851..1.852 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..1050.62 rows=1464 width=0) (actual time=1.784..1.845 rows=260 loops=1)
Index Cond: (text &@ 'PostgreSQL'::text)
Planning Time: 0.089 ms
Execution Time: 2.018 ms
(5 rows)
Time: 2.235 ms
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1054.28..1054.29 rows=1 width=8) (actual time=1.825..1.825 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..1050.62 rows=1464 width=0) (actual time=1.758..1.819 rows=260 loops=1)
Index Cond: (text &@ 'PostgreSQL'::text)
Planning Time: 0.093 ms
Execution Time: 1.991 ms
(5 rows)
Time: 2.208 ms
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1054.28..1054.29 rows=1 width=8) (actual time=1.889..1.889 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..1050.62 rows=1464 width=0) (actual time=1.816..1.883 rows=260 loops=1)
Index Cond: (text &@ 'PostgreSQL'::text)
Planning Time: 0.086 ms
Execution Time: 2.057 ms
(5 rows)
Time: 2.264 ms
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1054.28..1054.29 rows=1 width=8) (actual time=1.844..1.844 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..1050.62 rows=1464 width=0) (actual time=1.773..1.837 rows=260 loops=1)
Index Cond: (text &@ 'PostgreSQL'::text)
Planning Time: 0.083 ms
Execution Time: 2.009 ms
(5 rows)
Time: 2.214 ms
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1054.28..1054.29 rows=1 width=8) (actual time=1.685..1.685 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..1050.62 rows=1464 width=0) (actual time=1.622..1.679 rows=260 loops=1)
Index Cond: (text &@ 'PostgreSQL'::text)
Planning Time: 0.076 ms
Execution Time: 1.833 ms
(5 rows)
Time: 2.068 ms
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1054.28..1054.29 rows=1 width=8) (actual time=1.634..1.635 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..1050.62 rows=1464 width=0) (actual time=1.574..1.629 rows=260 loops=1)
Index Cond: (text &@ 'PostgreSQL'::text)
Planning Time: 0.076 ms
Execution Time: 1.781 ms
(5 rows)
Time: 1.962 ms
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1054.28..1054.29 rows=1 width=8) (actual time=1.635..1.635 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..1050.62 rows=1464 width=0) (actual time=1.574..1.630 rows=260 loops=1)
Index Cond: (text &@ 'PostgreSQL'::text)
Planning Time: 0.069 ms
Execution Time: 1.785 ms
(5 rows)
Time: 1.930 ms
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=1054.28..1054.29 rows=1 width=8) (actual time=1.618..1.618 rows=1 loops=1)
-> Index Scan using wikipedia_index on wikipedia (cost=0.00..1050.62 rows=1464 width=0) (actual time=1.557..1.613 rows=260 loops=1)
Index Cond: (text &@ 'PostgreSQL'::text)
Planning Time: 0.065 ms
Execution Time: 1.772 ms
(5 rows)
Time: 1.910 ms
pg_bigm
#!/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 like '%${query}%';")
done
result=$(sudo -u postgres psql -d test_articles \
--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"
}
sudo -u postgres psql -d test_articles \
--command 'drop index if exists wikipedia_index' \
--command "set maintenance_work_mem = '8GB'" \
--command "\timing" \
--command "create index wikipedia_index on wikipedia using gin (title gin_bigm_ops, text gin_bigm_ops);"
run_select "象"
run_select "東京"
run_select "技術者"
run_select "ロケット"
run_select "データベース"
run_select "DB"
run_select "test"
run_select "PostgreSQL"
sudo -u postgres psql -d test_articles --command "select pg_size_pretty(pg_relation_size('wikipedia_index'));"
$ ./article/run-pg_bigm.sh 2> log
DROP INDEX
SET
Timing is on.
CREATE INDEX
Time: 1944111.098 ms (32:24.111)
Query: 象, Total 1786.2 ms
Query: 東京, Total 1929.62 ms
Query: 技術者, Total 9952.98 ms
Query: ロケット, Total 28093.4 ms
Query: データベース, Total 22070.2 ms
Query: DB, Total 498.294 ms
Query: test, Total 283371 ms
Query: PostgreSQL, Total 405.627 ms
pg_size_pretty
----------------
5672 MB
(1 row)
log
= 象 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=39859.20..39859.21 rows=1 width=8) (actual time=214.410..214.410 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=190.38..39822.23 rows=14788 width=0) (actual time=39.880..210.587 rows=192783 loops=1)
Recheck Cond: (text ~~ '%象%'::text)
Heap Blocks: exact=73033
-> Bitmap Index Scan on wikipedia_index (cost=0.00..186.68 rows=14788 width=0) (actual time=32.696..32.697 rows=192783 loops=1)
Index Cond: (text ~~ '%象%'::text)
Planning Time: 1.216 ms
Execution Time: 214.799 ms
(8 rows)
Time: 216.628 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=39859.20..39859.21 rows=1 width=8) (actual time=164.186..164.188 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=190.38..39822.23 rows=14788 width=0) (actual time=36.144..160.515 rows=192783 loops=1)
Recheck Cond: (text ~~ '%象%'::text)
Heap Blocks: exact=73033
-> Bitmap Index Scan on wikipedia_index (cost=0.00..186.68 rows=14788 width=0) (actual time=29.432..29.433 rows=192783 loops=1)
Index Cond: (text ~~ '%象%'::text)
Planning Time: 0.208 ms
Execution Time: 164.725 ms
(8 rows)
Time: 165.250 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=39859.20..39859.21 rows=1 width=8) (actual time=171.308..171.309 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=190.38..39822.23 rows=14788 width=0) (actual time=37.715..167.681 rows=192783 loops=1)
Recheck Cond: (text ~~ '%象%'::text)
Heap Blocks: exact=73033
-> Bitmap Index Scan on wikipedia_index (cost=0.00..186.68 rows=14788 width=0) (actual time=30.708..30.708 rows=192783 loops=1)
Index Cond: (text ~~ '%象%'::text)
Planning Time: 0.191 ms
Execution Time: 171.875 ms
(8 rows)
Time: 172.252 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=39859.20..39859.21 rows=1 width=8) (actual time=164.724..164.726 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=190.38..39822.23 rows=14788 width=0) (actual time=35.555..161.086 rows=192783 loops=1)
Recheck Cond: (text ~~ '%象%'::text)
Heap Blocks: exact=73033
-> Bitmap Index Scan on wikipedia_index (cost=0.00..186.68 rows=14788 width=0) (actual time=28.706..28.707 rows=192783 loops=1)
Index Cond: (text ~~ '%象%'::text)
Planning Time: 0.188 ms
Execution Time: 165.321 ms
(8 rows)
Time: 165.718 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=39859.20..39859.21 rows=1 width=8) (actual time=198.747..198.749 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=190.38..39822.23 rows=14788 width=0) (actual time=38.208..194.396 rows=192783 loops=1)
Recheck Cond: (text ~~ '%象%'::text)
Heap Blocks: exact=73033
-> Bitmap Index Scan on wikipedia_index (cost=0.00..186.68 rows=14788 width=0) (actual time=31.072..31.072 rows=192783 loops=1)
Index Cond: (text ~~ '%象%'::text)
Planning Time: 0.190 ms
Execution Time: 199.435 ms
(8 rows)
Time: 199.792 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=39859.20..39859.21 rows=1 width=8) (actual time=166.290..166.291 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=190.38..39822.23 rows=14788 width=0) (actual time=35.472..162.549 rows=192783 loops=1)
Recheck Cond: (text ~~ '%象%'::text)
Heap Blocks: exact=73033
-> Bitmap Index Scan on wikipedia_index (cost=0.00..186.68 rows=14788 width=0) (actual time=28.570..28.570 rows=192783 loops=1)
Index Cond: (text ~~ '%象%'::text)
Planning Time: 0.181 ms
Execution Time: 166.853 ms
(8 rows)
Time: 167.253 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=39859.20..39859.21 rows=1 width=8) (actual time=180.249..180.250 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=190.38..39822.23 rows=14788 width=0) (actual time=34.736..176.134 rows=192783 loops=1)
Recheck Cond: (text ~~ '%象%'::text)
Heap Blocks: exact=73033
-> Bitmap Index Scan on wikipedia_index (cost=0.00..186.68 rows=14788 width=0) (actual time=28.102..28.102 rows=192783 loops=1)
Index Cond: (text ~~ '%象%'::text)
Planning Time: 0.188 ms
Execution Time: 180.919 ms
(8 rows)
Time: 181.277 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=39859.20..39859.21 rows=1 width=8) (actual time=164.823..164.824 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=190.38..39822.23 rows=14788 width=0) (actual time=36.102..161.164 rows=192783 loops=1)
Recheck Cond: (text ~~ '%象%'::text)
Heap Blocks: exact=73033
-> Bitmap Index Scan on wikipedia_index (cost=0.00..186.68 rows=14788 width=0) (actual time=29.488..29.489 rows=192783 loops=1)
Index Cond: (text ~~ '%象%'::text)
Planning Time: 0.187 ms
Execution Time: 165.385 ms
(8 rows)
Time: 165.729 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=39859.20..39859.21 rows=1 width=8) (actual time=173.796..173.797 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=190.38..39822.23 rows=14788 width=0) (actual time=38.348..170.008 rows=192783 loops=1)
Recheck Cond: (text ~~ '%象%'::text)
Heap Blocks: exact=73033
-> Bitmap Index Scan on wikipedia_index (cost=0.00..186.68 rows=14788 width=0) (actual time=31.211..31.211 rows=192783 loops=1)
Index Cond: (text ~~ '%象%'::text)
Planning Time: 0.189 ms
Execution Time: 174.692 ms
(8 rows)
Time: 175.046 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=39859.20..39859.21 rows=1 width=8) (actual time=176.344..176.346 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=190.38..39822.23 rows=14788 width=0) (actual time=44.432..172.559 rows=192783 loops=1)
Recheck Cond: (text ~~ '%象%'::text)
Heap Blocks: exact=73033
-> Bitmap Index Scan on wikipedia_index (cost=0.00..186.68 rows=14788 width=0) (actual time=36.541..36.542 rows=192783 loops=1)
Index Cond: (text ~~ '%象%'::text)
Planning Time: 0.223 ms
Execution Time: 176.911 ms
(8 rows)
Time: 177.258 ms
= 東京 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=89660.95..89660.96 rows=1 width=8) (actual time=225.010..225.011 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=427.05..89513.07 rows=59154 width=0) (actual time=28.380..216.113 rows=371644 loops=1)
Recheck Cond: (text ~~ '%東京%'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..412.26 rows=59154 width=0) (actual time=19.733..19.734 rows=371644 loops=1)
Index Cond: (text ~~ '%東京%'::text)
Planning Time: 0.746 ms
Execution Time: 225.272 ms
(8 rows)
Time: 226.597 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=89660.95..89660.96 rows=1 width=8) (actual time=193.432..193.433 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=427.05..89513.07 rows=59154 width=0) (actual time=23.806..185.176 rows=371644 loops=1)
Recheck Cond: (text ~~ '%東京%'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..412.26 rows=59154 width=0) (actual time=15.716..15.716 rows=371644 loops=1)
Index Cond: (text ~~ '%東京%'::text)
Planning Time: 0.192 ms
Execution Time: 193.446 ms
(8 rows)
Time: 193.815 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=89660.95..89660.96 rows=1 width=8) (actual time=188.759..188.760 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=427.05..89513.07 rows=59154 width=0) (actual time=22.213..181.965 rows=371644 loops=1)
Recheck Cond: (text ~~ '%東京%'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..412.26 rows=59154 width=0) (actual time=13.928..13.928 rows=371644 loops=1)
Index Cond: (text ~~ '%東京%'::text)
Planning Time: 0.180 ms
Execution Time: 188.775 ms
(8 rows)
Time: 189.188 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=89660.95..89660.96 rows=1 width=8) (actual time=189.088..189.088 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=427.05..89513.07 rows=59154 width=0) (actual time=22.033..182.183 rows=371644 loops=1)
Recheck Cond: (text ~~ '%東京%'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..412.26 rows=59154 width=0) (actual time=13.878..13.878 rows=371644 loops=1)
Index Cond: (text ~~ '%東京%'::text)
Planning Time: 0.224 ms
Execution Time: 189.103 ms
(8 rows)
Time: 189.501 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=89660.95..89660.96 rows=1 width=8) (actual time=188.062..188.063 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=427.05..89513.07 rows=59154 width=0) (actual time=21.988..181.238 rows=371644 loops=1)
Recheck Cond: (text ~~ '%東京%'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..412.26 rows=59154 width=0) (actual time=13.819..13.819 rows=371644 loops=1)
Index Cond: (text ~~ '%東京%'::text)
Planning Time: 0.182 ms
Execution Time: 188.077 ms
(8 rows)
Time: 188.432 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=89660.95..89660.96 rows=1 width=8) (actual time=188.049..188.050 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=427.05..89513.07 rows=59154 width=0) (actual time=21.855..181.247 rows=371644 loops=1)
Recheck Cond: (text ~~ '%東京%'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..412.26 rows=59154 width=0) (actual time=13.630..13.630 rows=371644 loops=1)
Index Cond: (text ~~ '%東京%'::text)
Planning Time: 0.186 ms
Execution Time: 188.065 ms
(8 rows)
Time: 188.443 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=89660.95..89660.96 rows=1 width=8) (actual time=188.461..188.462 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=427.05..89513.07 rows=59154 width=0) (actual time=21.851..181.633 rows=371644 loops=1)
Recheck Cond: (text ~~ '%東京%'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..412.26 rows=59154 width=0) (actual time=13.632..13.632 rows=371644 loops=1)
Index Cond: (text ~~ '%東京%'::text)
Planning Time: 0.195 ms
Execution Time: 188.477 ms
(8 rows)
Time: 188.839 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=89660.95..89660.96 rows=1 width=8) (actual time=186.918..186.919 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=427.05..89513.07 rows=59154 width=0) (actual time=21.901..180.123 rows=371644 loops=1)
Recheck Cond: (text ~~ '%東京%'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..412.26 rows=59154 width=0) (actual time=13.725..13.726 rows=371644 loops=1)
Index Cond: (text ~~ '%東京%'::text)
Planning Time: 0.180 ms
Execution Time: 186.933 ms
(8 rows)
Time: 187.284 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=89660.95..89660.96 rows=1 width=8) (actual time=188.495..188.496 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=427.05..89513.07 rows=59154 width=0) (actual time=21.804..181.637 rows=371644 loops=1)
Recheck Cond: (text ~~ '%東京%'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..412.26 rows=59154 width=0) (actual time=13.701..13.701 rows=371644 loops=1)
Index Cond: (text ~~ '%東京%'::text)
Planning Time: 0.186 ms
Execution Time: 188.511 ms
(8 rows)
Time: 188.831 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=89660.95..89660.96 rows=1 width=8) (actual time=188.283..188.284 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=427.05..89513.07 rows=59154 width=0) (actual time=21.887..181.397 rows=371644 loops=1)
Recheck Cond: (text ~~ '%東京%'::text)
Heap Blocks: exact=89235
-> Bitmap Index Scan on wikipedia_index (cost=0.00..412.26 rows=59154 width=0) (actual time=13.814..13.814 rows=371644 loops=1)
Index Cond: (text ~~ '%東京%'::text)
Planning Time: 0.180 ms
Execution Time: 188.298 ms
(8 rows)
Time: 188.695 ms
= 技術者 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=625.57..625.58 rows=1 width=8) (actual time=1040.038..1040.038 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=56.38..625.21 rows=146 width=0) (actual time=5.611..1039.229 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 411
Heap Blocks: exact=16842
-> Bitmap Index Scan on wikipedia_index (cost=0.00..56.34 rows=146 width=0) (actual time=3.723..3.723 rows=20385 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.549 ms
Execution Time: 1040.188 ms
(9 rows)
Time: 1041.308 ms (00:01.041)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=625.57..625.58 rows=1 width=8) (actual time=987.531..987.531 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=56.38..625.21 rows=146 width=0) (actual time=4.053..986.822 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 411
Heap Blocks: exact=16842
-> Bitmap Index Scan on wikipedia_index (cost=0.00..56.34 rows=146 width=0) (actual time=2.570..2.570 rows=20385 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.183 ms
Execution Time: 987.664 ms
(9 rows)
Time: 988.066 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=625.57..625.58 rows=1 width=8) (actual time=988.516..988.516 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=56.38..625.21 rows=146 width=0) (actual time=4.454..987.797 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 411
Heap Blocks: exact=16842
-> Bitmap Index Scan on wikipedia_index (cost=0.00..56.34 rows=146 width=0) (actual time=3.028..3.029 rows=20385 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.175 ms
Execution Time: 988.647 ms
(9 rows)
Time: 988.987 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=625.57..625.58 rows=1 width=8) (actual time=997.888..997.889 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=56.38..625.21 rows=146 width=0) (actual time=4.220..997.163 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 411
Heap Blocks: exact=16842
-> Bitmap Index Scan on wikipedia_index (cost=0.00..56.34 rows=146 width=0) (actual time=2.779..2.779 rows=20385 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.177 ms
Execution Time: 998.018 ms
(9 rows)
Time: 998.365 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=625.57..625.58 rows=1 width=8) (actual time=984.837..984.838 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=56.38..625.21 rows=146 width=0) (actual time=4.222..984.119 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 411
Heap Blocks: exact=16842
-> Bitmap Index Scan on wikipedia_index (cost=0.00..56.34 rows=146 width=0) (actual time=2.777..2.778 rows=20385 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.196 ms
Execution Time: 985.073 ms
(9 rows)
Time: 985.437 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=625.57..625.58 rows=1 width=8) (actual time=992.183..992.184 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=56.38..625.21 rows=146 width=0) (actual time=4.288..991.468 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 411
Heap Blocks: exact=16842
-> Bitmap Index Scan on wikipedia_index (cost=0.00..56.34 rows=146 width=0) (actual time=2.829..2.829 rows=20385 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.179 ms
Execution Time: 992.314 ms
(9 rows)
Time: 992.684 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=625.57..625.58 rows=1 width=8) (actual time=987.879..987.880 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=56.38..625.21 rows=146 width=0) (actual time=4.525..987.166 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 411
Heap Blocks: exact=16842
-> Bitmap Index Scan on wikipedia_index (cost=0.00..56.34 rows=146 width=0) (actual time=3.095..3.095 rows=20385 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.207 ms
Execution Time: 988.081 ms
(9 rows)
Time: 988.415 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=625.57..625.58 rows=1 width=8) (actual time=984.268..984.269 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=56.38..625.21 rows=146 width=0) (actual time=4.308..983.578 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 411
Heap Blocks: exact=16842
-> Bitmap Index Scan on wikipedia_index (cost=0.00..56.34 rows=146 width=0) (actual time=2.886..2.886 rows=20385 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.182 ms
Execution Time: 984.395 ms
(9 rows)
Time: 984.705 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=625.57..625.58 rows=1 width=8) (actual time=990.133..990.134 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=56.38..625.21 rows=146 width=0) (actual time=4.555..989.107 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 411
Heap Blocks: exact=16842
-> Bitmap Index Scan on wikipedia_index (cost=0.00..56.34 rows=146 width=0) (actual time=3.027..3.027 rows=20385 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.202 ms
Execution Time: 990.352 ms
(9 rows)
Time: 990.735 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=625.57..625.58 rows=1 width=8) (actual time=993.810..993.811 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=56.38..625.21 rows=146 width=0) (actual time=4.443..992.767 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 411
Heap Blocks: exact=16842
-> Bitmap Index Scan on wikipedia_index (cost=0.00..56.34 rows=146 width=0) (actual time=2.925..2.925 rows=20385 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.220 ms
Execution Time: 993.954 ms
(9 rows)
Time: 994.281 ms
= ロケット ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=2868.070..2868.071 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=10.665..2867.400 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 7485
Heap Blocks: exact=20186
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=8.192..8.192 rows=25567 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.594 ms
Execution Time: 2868.187 ms
(9 rows)
Time: 2869.361 ms (00:02.869)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=2795.312..2795.314 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=8.460..2794.652 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 7485
Heap Blocks: exact=20186
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=6.462..6.462 rows=25567 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.214 ms
Execution Time: 2795.461 ms
(9 rows)
Time: 2795.842 ms (00:02.796)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=2820.248..2820.249 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=8.597..2819.567 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 7485
Heap Blocks: exact=20186
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=6.571..6.571 rows=25567 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.218 ms
Execution Time: 2820.417 ms
(9 rows)
Time: 2820.805 ms (00:02.821)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=2788.344..2788.345 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=8.630..2787.657 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 7485
Heap Blocks: exact=20186
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=6.641..6.641 rows=25567 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.217 ms
Execution Time: 2788.471 ms
(9 rows)
Time: 2788.841 ms (00:02.789)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=2794.260..2794.261 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=8.526..2793.554 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 7485
Heap Blocks: exact=20186
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=6.543..6.543 rows=25567 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.241 ms
Execution Time: 2794.448 ms
(9 rows)
Time: 2794.869 ms (00:02.795)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=2811.462..2811.462 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=8.508..2810.777 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 7485
Heap Blocks: exact=20186
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=6.500..6.501 rows=25567 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.219 ms
Execution Time: 2811.604 ms
(9 rows)
Time: 2811.970 ms (00:02.812)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=2790.988..2790.989 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=8.587..2790.251 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 7485
Heap Blocks: exact=20186
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=6.610..6.610 rows=25567 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.240 ms
Execution Time: 2791.160 ms
(9 rows)
Time: 2791.569 ms (00:02.792)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=2822.797..2822.797 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=8.600..2822.130 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 7485
Heap Blocks: exact=20186
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=6.597..6.597 rows=25567 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.224 ms
Execution Time: 2822.976 ms
(9 rows)
Time: 2823.372 ms (00:02.823)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=2790.164..2790.165 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=8.543..2789.422 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 7485
Heap Blocks: exact=20186
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=6.553..6.553 rows=25567 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.242 ms
Execution Time: 2790.384 ms
(9 rows)
Time: 2790.776 ms (00:02.791)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=2805.447..2805.447 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=8.556..2804.666 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 7485
Heap Blocks: exact=20186
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=6.528..6.529 rows=25567 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.213 ms
Execution Time: 2805.609 ms
(9 rows)
Time: 2805.981 ms (00:02.806)
= データベース ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=702.80..702.81 rows=1 width=8) (actual time=2211.362..2211.363 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=133.61..702.44 rows=146 width=0) (actual time=18.592..2209.916 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 536
Heap Blocks: exact=29278
-> Bitmap Index Scan on wikipedia_index (cost=0.00..133.57 rows=146 width=0) (actual time=14.687..14.687 rows=39974 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.871 ms
Execution Time: 2211.543 ms
(9 rows)
Time: 2212.948 ms (00:02.213)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=702.80..702.81 rows=1 width=8) (actual time=2204.355..2204.356 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=133.61..702.44 rows=146 width=0) (actual time=15.071..2202.892 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 536
Heap Blocks: exact=29278
-> Bitmap Index Scan on wikipedia_index (cost=0.00..133.57 rows=146 width=0) (actual time=11.591..11.591 rows=39974 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.224 ms
Execution Time: 2204.656 ms
(9 rows)
Time: 2205.036 ms (00:02.205)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=702.80..702.81 rows=1 width=8) (actual time=2211.739..2211.740 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=133.61..702.44 rows=146 width=0) (actual time=17.147..2210.358 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 536
Heap Blocks: exact=29278
-> Bitmap Index Scan on wikipedia_index (cost=0.00..133.57 rows=146 width=0) (actual time=13.148..13.148 rows=39974 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.226 ms
Execution Time: 2211.951 ms
(9 rows)
Time: 2212.355 ms (00:02.212)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=702.80..702.81 rows=1 width=8) (actual time=2192.198..2192.199 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=133.61..702.44 rows=146 width=0) (actual time=15.905..2190.771 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 536
Heap Blocks: exact=29278
-> Bitmap Index Scan on wikipedia_index (cost=0.00..133.57 rows=146 width=0) (actual time=12.333..12.334 rows=39974 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.214 ms
Execution Time: 2192.449 ms
(9 rows)
Time: 2192.828 ms (00:02.193)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=702.80..702.81 rows=1 width=8) (actual time=2193.685..2193.686 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=133.61..702.44 rows=146 width=0) (actual time=15.378..2192.245 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 536
Heap Blocks: exact=29278
-> Bitmap Index Scan on wikipedia_index (cost=0.00..133.57 rows=146 width=0) (actual time=11.862..11.862 rows=39974 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.236 ms
Execution Time: 2193.862 ms
(9 rows)
Time: 2194.251 ms (00:02.194)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=702.80..702.81 rows=1 width=8) (actual time=2196.556..2196.557 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=133.61..702.44 rows=146 width=0) (actual time=15.197..2195.132 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 536
Heap Blocks: exact=29278
-> Bitmap Index Scan on wikipedia_index (cost=0.00..133.57 rows=146 width=0) (actual time=11.755..11.755 rows=39974 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.221 ms
Execution Time: 2196.797 ms
(9 rows)
Time: 2197.185 ms (00:02.197)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=702.80..702.81 rows=1 width=8) (actual time=2199.983..2199.984 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=133.61..702.44 rows=146 width=0) (actual time=15.505..2198.525 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 536
Heap Blocks: exact=29278
-> Bitmap Index Scan on wikipedia_index (cost=0.00..133.57 rows=146 width=0) (actual time=12.008..12.009 rows=39974 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.210 ms
Execution Time: 2200.234 ms
(9 rows)
Time: 2200.615 ms (00:02.201)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=702.80..702.81 rows=1 width=8) (actual time=2212.567..2212.567 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=133.61..702.44 rows=146 width=0) (actual time=15.410..2211.060 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 536
Heap Blocks: exact=29278
-> Bitmap Index Scan on wikipedia_index (cost=0.00..133.57 rows=146 width=0) (actual time=11.933..11.934 rows=39974 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.211 ms
Execution Time: 2212.751 ms
(9 rows)
Time: 2213.136 ms (00:02.213)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=702.80..702.81 rows=1 width=8) (actual time=2227.866..2227.866 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=133.61..702.44 rows=146 width=0) (actual time=16.017..2226.456 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 536
Heap Blocks: exact=29278
-> Bitmap Index Scan on wikipedia_index (cost=0.00..133.57 rows=146 width=0) (actual time=12.349..12.350 rows=39974 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.227 ms
Execution Time: 2228.122 ms
(9 rows)
Time: 2228.507 ms (00:02.229)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=702.80..702.81 rows=1 width=8) (actual time=2212.653..2212.654 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=133.61..702.44 rows=146 width=0) (actual time=16.044..2210.780 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 536
Heap Blocks: exact=29278
-> Bitmap Index Scan on wikipedia_index (cost=0.00..133.57 rows=146 width=0) (actual time=12.337..12.337 rows=39974 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.224 ms
Execution Time: 2212.903 ms
(9 rows)
Time: 2213.332 ms (00:02.213)
= DB ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=599.83..599.84 rows=1 width=8) (actual time=71.500..71.501 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=30.64..599.47 rows=146 width=0) (actual time=7.276..70.573 rows=31892 loops=1)
Recheck Cond: (text ~~ '%DB%'::text)
Heap Blocks: exact=24942
-> Bitmap Index Scan on wikipedia_index (cost=0.00..30.60 rows=146 width=0) (actual time=4.152..4.152 rows=31892 loops=1)
Index Cond: (text ~~ '%DB%'::text)
Planning Time: 0.808 ms
Execution Time: 71.661 ms
(8 rows)
Time: 73.017 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=599.83..599.84 rows=1 width=8) (actual time=56.978..56.978 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=30.64..599.47 rows=146 width=0) (actual time=5.473..56.096 rows=31892 loops=1)
Recheck Cond: (text ~~ '%DB%'::text)
Heap Blocks: exact=24942
-> Bitmap Index Scan on wikipedia_index (cost=0.00..30.60 rows=146 width=0) (actual time=3.033..3.034 rows=31892 loops=1)
Index Cond: (text ~~ '%DB%'::text)
Planning Time: 0.220 ms
Execution Time: 56.993 ms
(8 rows)
Time: 57.455 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=599.83..599.84 rows=1 width=8) (actual time=49.824..49.824 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=30.64..599.47 rows=146 width=0) (actual time=4.976..49.095 rows=31892 loops=1)
Recheck Cond: (text ~~ '%DB%'::text)
Heap Blocks: exact=24942
-> Bitmap Index Scan on wikipedia_index (cost=0.00..30.60 rows=146 width=0) (actual time=2.352..2.352 rows=31892 loops=1)
Index Cond: (text ~~ '%DB%'::text)
Planning Time: 0.236 ms
Execution Time: 49.841 ms
(8 rows)
Time: 50.423 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=599.83..599.84 rows=1 width=8) (actual time=45.536..45.536 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=30.64..599.47 rows=146 width=0) (actual time=3.894..44.890 rows=31892 loops=1)
Recheck Cond: (text ~~ '%DB%'::text)
Heap Blocks: exact=24942
-> Bitmap Index Scan on wikipedia_index (cost=0.00..30.60 rows=146 width=0) (actual time=1.821..1.821 rows=31892 loops=1)
Index Cond: (text ~~ '%DB%'::text)
Planning Time: 0.190 ms
Execution Time: 45.547 ms
(8 rows)
Time: 45.883 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=599.83..599.84 rows=1 width=8) (actual time=45.076..45.077 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=30.64..599.47 rows=146 width=0) (actual time=3.680..44.440 rows=31892 loops=1)
Recheck Cond: (text ~~ '%DB%'::text)
Heap Blocks: exact=24942
-> Bitmap Index Scan on wikipedia_index (cost=0.00..30.60 rows=146 width=0) (actual time=1.711..1.711 rows=31892 loops=1)
Index Cond: (text ~~ '%DB%'::text)
Planning Time: 0.179 ms
Execution Time: 45.088 ms
(8 rows)
Time: 45.427 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=599.83..599.84 rows=1 width=8) (actual time=44.569..44.569 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=30.64..599.47 rows=146 width=0) (actual time=3.709..43.926 rows=31892 loops=1)
Recheck Cond: (text ~~ '%DB%'::text)
Heap Blocks: exact=24942
-> Bitmap Index Scan on wikipedia_index (cost=0.00..30.60 rows=146 width=0) (actual time=1.744..1.744 rows=31892 loops=1)
Index Cond: (text ~~ '%DB%'::text)
Planning Time: 0.167 ms
Execution Time: 44.579 ms
(8 rows)
Time: 44.893 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=599.83..599.84 rows=1 width=8) (actual time=44.360..44.360 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=30.64..599.47 rows=146 width=0) (actual time=3.667..43.723 rows=31892 loops=1)
Recheck Cond: (text ~~ '%DB%'::text)
Heap Blocks: exact=24942
-> Bitmap Index Scan on wikipedia_index (cost=0.00..30.60 rows=146 width=0) (actual time=1.714..1.714 rows=31892 loops=1)
Index Cond: (text ~~ '%DB%'::text)
Planning Time: 0.168 ms
Execution Time: 44.370 ms
(8 rows)
Time: 44.739 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=599.83..599.84 rows=1 width=8) (actual time=44.799..44.800 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=30.64..599.47 rows=146 width=0) (actual time=3.751..44.153 rows=31892 loops=1)
Recheck Cond: (text ~~ '%DB%'::text)
Heap Blocks: exact=24942
-> Bitmap Index Scan on wikipedia_index (cost=0.00..30.60 rows=146 width=0) (actual time=1.729..1.730 rows=31892 loops=1)
Index Cond: (text ~~ '%DB%'::text)
Planning Time: 0.168 ms
Execution Time: 44.811 ms
(8 rows)
Time: 45.113 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=599.83..599.84 rows=1 width=8) (actual time=45.940..45.941 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=30.64..599.47 rows=146 width=0) (actual time=3.686..45.255 rows=31892 loops=1)
Recheck Cond: (text ~~ '%DB%'::text)
Heap Blocks: exact=24942
-> Bitmap Index Scan on wikipedia_index (cost=0.00..30.60 rows=146 width=0) (actual time=1.748..1.748 rows=31892 loops=1)
Index Cond: (text ~~ '%DB%'::text)
Planning Time: 0.170 ms
Execution Time: 45.952 ms
(8 rows)
Time: 46.259 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=599.83..599.84 rows=1 width=8) (actual time=44.693..44.694 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=30.64..599.47 rows=146 width=0) (actual time=3.698..44.050 rows=31892 loops=1)
Recheck Cond: (text ~~ '%DB%'::text)
Heap Blocks: exact=24942
-> Bitmap Index Scan on wikipedia_index (cost=0.00..30.60 rows=146 width=0) (actual time=1.722..1.722 rows=31892 loops=1)
Index Cond: (text ~~ '%DB%'::text)
Planning Time: 0.175 ms
Execution Time: 44.705 ms
(8 rows)
Time: 45.085 ms
= test ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=28374.463..28374.464 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=87.521..28372.593 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 994832
Heap Blocks: exact=96604
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=75.500..75.500 rows=1036230 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.775 ms
Execution Time: 28374.768 ms
(9 rows)
Time: 28376.143 ms (00:28.376)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=28305.919..28305.920 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=78.394..28304.199 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 994832
Heap Blocks: exact=96604
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=67.452..67.453 rows=1036230 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.179 ms
Execution Time: 28306.356 ms
(9 rows)
Time: 28306.696 ms (00:28.307)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=28287.735..28287.736 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=79.577..28285.911 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 994832
Heap Blocks: exact=96604
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=68.714..68.714 rows=1036230 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.187 ms
Execution Time: 28288.263 ms
(9 rows)
Time: 28288.610 ms (00:28.289)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=28256.452..28256.454 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=79.424..28254.665 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 994832
Heap Blocks: exact=96604
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=68.600..68.600 rows=1036230 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.173 ms
Execution Time: 28256.890 ms
(9 rows)
Time: 28257.251 ms (00:28.257)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=28353.772..28353.773 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=78.589..28351.971 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 994832
Heap Blocks: exact=96604
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=67.736..67.736 rows=1036230 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.198 ms
Execution Time: 28354.351 ms
(9 rows)
Time: 28354.717 ms (00:28.355)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=28365.556..28365.557 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=78.766..28363.776 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 994832
Heap Blocks: exact=96604
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=67.925..67.925 rows=1036230 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.174 ms
Execution Time: 28366.000 ms
(9 rows)
Time: 28366.325 ms (00:28.366)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=28460.414..28460.415 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=79.632..28458.689 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 994832
Heap Blocks: exact=96604
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=68.823..68.823 rows=1036230 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.175 ms
Execution Time: 28461.004 ms
(9 rows)
Time: 28461.407 ms (00:28.461)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=28286.809..28286.810 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=79.236..28285.095 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 994832
Heap Blocks: exact=96604
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=68.171..68.172 rows=1036230 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.182 ms
Execution Time: 28287.250 ms
(9 rows)
Time: 28287.706 ms (00:28.288)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=28330.552..28330.553 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=81.308..28328.772 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 994832
Heap Blocks: exact=96604
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=70.396..70.397 rows=1036230 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.181 ms
Execution Time: 28331.212 ms
(9 rows)
Time: 28331.544 ms (00:28.332)
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=651.32..651.33 rows=1 width=8) (actual time=28339.621..28339.622 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=82.12..650.95 rows=146 width=0) (actual time=78.831..28337.810 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 994832
Heap Blocks: exact=96604
-> Bitmap Index Scan on wikipedia_index (cost=0.00..82.08 rows=146 width=0) (actual time=68.044..68.044 rows=1036230 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.168 ms
Execution Time: 28340.147 ms
(9 rows)
Time: 28340.509 ms (00:28.341)
= PostgreSQL ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=809.90..809.91 rows=1 width=8) (actual time=54.697..54.698 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=240.70..809.53 rows=146 width=0) (actual time=18.740..54.678 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 46
Heap Blocks: exact=304
-> Bitmap Index Scan on wikipedia_index (cost=0.00..240.66 rows=146 width=0) (actual time=18.594..18.594 rows=305 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.882 ms
Execution Time: 54.834 ms
(9 rows)
Time: 56.232 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=809.90..809.91 rows=1 width=8) (actual time=38.826..38.827 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=240.70..809.53 rows=146 width=0) (actual time=11.558..38.814 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 46
Heap Blocks: exact=304
-> Bitmap Index Scan on wikipedia_index (cost=0.00..240.66 rows=146 width=0) (actual time=11.508..11.508 rows=305 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.178 ms
Execution Time: 38.837 ms
(9 rows)
Time: 39.136 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=809.90..809.91 rows=1 width=8) (actual time=38.422..38.422 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=240.70..809.53 rows=146 width=0) (actual time=11.166..38.413 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 46
Heap Blocks: exact=304
-> Bitmap Index Scan on wikipedia_index (cost=0.00..240.66 rows=146 width=0) (actual time=11.115..11.115 rows=305 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.159 ms
Execution Time: 38.429 ms
(9 rows)
Time: 38.714 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=809.90..809.91 rows=1 width=8) (actual time=38.079..38.079 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=240.70..809.53 rows=146 width=0) (actual time=11.104..38.070 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 46
Heap Blocks: exact=304
-> Bitmap Index Scan on wikipedia_index (cost=0.00..240.66 rows=146 width=0) (actual time=11.055..11.055 rows=305 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.161 ms
Execution Time: 38.086 ms
(9 rows)
Time: 38.402 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=809.90..809.91 rows=1 width=8) (actual time=37.865..37.865 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=240.70..809.53 rows=146 width=0) (actual time=11.016..37.856 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 46
Heap Blocks: exact=304
-> Bitmap Index Scan on wikipedia_index (cost=0.00..240.66 rows=146 width=0) (actual time=10.967..10.967 rows=305 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.146 ms
Execution Time: 37.872 ms
(9 rows)
Time: 38.206 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=809.90..809.91 rows=1 width=8) (actual time=38.027..38.028 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=240.70..809.53 rows=146 width=0) (actual time=11.134..38.019 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 46
Heap Blocks: exact=304
-> Bitmap Index Scan on wikipedia_index (cost=0.00..240.66 rows=146 width=0) (actual time=11.084..11.084 rows=305 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.147 ms
Execution Time: 38.035 ms
(9 rows)
Time: 38.362 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=809.90..809.91 rows=1 width=8) (actual time=38.352..38.352 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=240.70..809.53 rows=146 width=0) (actual time=11.132..38.343 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 46
Heap Blocks: exact=304
-> Bitmap Index Scan on wikipedia_index (cost=0.00..240.66 rows=146 width=0) (actual time=11.083..11.083 rows=305 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.153 ms
Execution Time: 38.360 ms
(9 rows)
Time: 38.698 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=809.90..809.91 rows=1 width=8) (actual time=39.702..39.702 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=240.70..809.53 rows=146 width=0) (actual time=11.768..39.693 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 46
Heap Blocks: exact=304
-> Bitmap Index Scan on wikipedia_index (cost=0.00..240.66 rows=146 width=0) (actual time=11.716..11.716 rows=305 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.152 ms
Execution Time: 39.709 ms
(9 rows)
Time: 40.021 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=809.90..809.91 rows=1 width=8) (actual time=38.316..38.317 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=240.70..809.53 rows=146 width=0) (actual time=11.106..38.308 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 46
Heap Blocks: exact=304
-> Bitmap Index Scan on wikipedia_index (cost=0.00..240.66 rows=146 width=0) (actual time=11.057..11.057 rows=305 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.159 ms
Execution Time: 38.324 ms
(9 rows)
Time: 38.639 ms
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=809.90..809.91 rows=1 width=8) (actual time=38.965..38.965 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=240.70..809.53 rows=146 width=0) (actual time=11.376..38.956 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 46
Heap Blocks: exact=304
-> Bitmap Index Scan on wikipedia_index (cost=0.00..240.66 rows=146 width=0) (actual time=11.325..11.325 rows=305 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.153 ms
Execution Time: 38.972 ms
(9 rows)
Time: 39.217 ms
pg_trgm
#!/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 like '%${query}%';")
done
result=$(sudo -u postgres psql -d test_articles \
--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"
}
sudo -u postgres psql -d test_articles \
--command 'drop index if exists wikipedia_index' \
--command "set maintenance_work_mem = '8GB'" \
--command "\timing" \
--command "create index wikipedia_index on wikipedia using gin (title gin_bigm_ops, text gin_trgm_ops);"
run_select "象"
run_select "東京"
run_select "技術者"
run_select "ロケット"
run_select "データベース"
run_select "DB"
run_select "test"
run_select "PostgreSQL"
sudo -u postgres psql -d test_articles --command "select pg_size_pretty(pg_relation_size('wikipedia_index'));"
$ ./article/run-pg_trgm.sh 2> log
DROP INDEX
SET
Timing is on.
CREATE INDEX
Time: 2424316.325 ms (40:24.316)
Query: 象, Total 316958 ms
Query: 東京, Total 309122 ms
Query: 技術者, Total 10383.8 ms
Query: ロケット, Total 18080.2 ms
Query: データベース, Total 22735.1 ms
Query: DB, Total 331171 ms
Query: test, Total 74479.5 ms
Query: PostgreSQL, Total 148.271 ms
pg_size_pretty
----------------
8989 MB
(1 row)
log
= 象 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115317.70..115317.71 rows=1 width=8) (actual time=33922.476..33922.477 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=14788 width=0) (actual time=2.294..33913.012 rows=192783 loops=1)
Filter: (text ~~ '%象%'::text)
Rows Removed by Filter: 1271275
Planning Time: 0.833 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.118 ms (Deform 0.038 ms), Inlining 0.000 ms, Optimization 0.153 ms, Emission 1.871 ms, Total 2.142 ms
Execution Time: 33932.653 ms
(10 rows)
Time: 33933.856 ms (00:33.934)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115317.70..115317.71 rows=1 width=8) (actual time=30919.359..30919.359 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=14788 width=0) (actual time=1.289..30910.220 rows=192783 loops=1)
Filter: (text ~~ '%象%'::text)
Rows Removed by Filter: 1271275
Planning Time: 0.177 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.101 ms (Deform 0.032 ms), Inlining 0.000 ms, Optimization 0.105 ms, Emission 1.078 ms, Total 1.284 ms
Execution Time: 30919.500 ms
(10 rows)
Time: 30919.859 ms (00:30.920)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115317.70..115317.71 rows=1 width=8) (actual time=31383.184..31383.184 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=14788 width=0) (actual time=1.292..31374.033 rows=192783 loops=1)
Filter: (text ~~ '%象%'::text)
Rows Removed by Filter: 1271275
Planning Time: 0.188 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.109 ms (Deform 0.035 ms), Inlining 0.000 ms, Optimization 0.089 ms, Emission 1.089 ms, Total 1.288 ms
Execution Time: 31383.323 ms
(10 rows)
Time: 31383.632 ms (00:31.384)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115317.70..115317.71 rows=1 width=8) (actual time=31517.279..31517.280 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=14788 width=0) (actual time=1.367..31507.651 rows=192783 loops=1)
Filter: (text ~~ '%象%'::text)
Rows Removed by Filter: 1271275
Planning Time: 0.205 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.115 ms (Deform 0.038 ms), Inlining 0.000 ms, Optimization 0.092 ms, Emission 1.157 ms, Total 1.363 ms
Execution Time: 31517.434 ms
(10 rows)
Time: 31517.927 ms (00:31.518)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115317.70..115317.71 rows=1 width=8) (actual time=31192.465..31192.465 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=14788 width=0) (actual time=1.915..31183.295 rows=192783 loops=1)
Filter: (text ~~ '%象%'::text)
Rows Removed by Filter: 1271275
Planning Time: 0.275 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.141 ms (Deform 0.046 ms), Inlining 0.000 ms, Optimization 0.123 ms, Emission 1.613 ms, Total 1.877 ms
Execution Time: 31192.646 ms
(10 rows)
Time: 31193.088 ms (00:31.193)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115317.70..115317.71 rows=1 width=8) (actual time=31274.862..31274.863 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=14788 width=0) (actual time=1.328..31265.671 rows=192783 loops=1)
Filter: (text ~~ '%象%'::text)
Rows Removed by Filter: 1271275
Planning Time: 0.175 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.107 ms (Deform 0.034 ms), Inlining 0.000 ms, Optimization 0.085 ms, Emission 1.117 ms, Total 1.308 ms
Execution Time: 31275.001 ms
(10 rows)
Time: 31275.319 ms (00:31.275)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115317.70..115317.71 rows=1 width=8) (actual time=32329.173..32329.174 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=14788 width=0) (actual time=1.555..32319.542 rows=192783 loops=1)
Filter: (text ~~ '%象%'::text)
Rows Removed by Filter: 1271275
Planning Time: 0.257 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.126 ms (Deform 0.042 ms), Inlining 0.000 ms, Optimization 0.102 ms, Emission 1.318 ms, Total 1.546 ms
Execution Time: 32329.336 ms
(10 rows)
Time: 32329.729 ms (00:32.330)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115317.70..115317.71 rows=1 width=8) (actual time=31769.247..31769.248 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=14788 width=0) (actual time=1.438..31759.518 rows=192783 loops=1)
Filter: (text ~~ '%象%'::text)
Rows Removed by Filter: 1271275
Planning Time: 0.209 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.107 ms (Deform 0.034 ms), Inlining 0.000 ms, Optimization 0.093 ms, Emission 1.216 ms, Total 1.416 ms
Execution Time: 31769.386 ms
(10 rows)
Time: 31769.719 ms (00:31.770)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115317.70..115317.71 rows=1 width=8) (actual time=30823.935..30823.935 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=14788 width=0) (actual time=1.353..30814.826 rows=192783 loops=1)
Filter: (text ~~ '%象%'::text)
Rows Removed by Filter: 1271275
Planning Time: 0.193 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.113 ms (Deform 0.037 ms), Inlining 0.000 ms, Optimization 0.092 ms, Emission 1.137 ms, Total 1.342 ms
Execution Time: 30824.080 ms
(10 rows)
Time: 30824.381 ms (00:30.824)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115317.70..115317.71 rows=1 width=8) (actual time=31810.297..31810.298 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=14788 width=0) (actual time=1.302..31800.822 rows=192783 loops=1)
Filter: (text ~~ '%象%'::text)
Rows Removed by Filter: 1271275
Planning Time: 0.181 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.096 ms (Deform 0.031 ms), Inlining 0.000 ms, Optimization 0.087 ms, Emission 1.107 ms, Total 1.290 ms
Execution Time: 31810.428 ms
(10 rows)
Time: 31810.724 ms (00:31.811)
= 東京 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115428.61..115428.62 rows=1 width=8) (actual time=30349.402..30349.403 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=59154 width=0) (actual time=3.225..30334.605 rows=371644 loops=1)
Filter: (text ~~ '%東京%'::text)
Rows Removed by Filter: 1092414
Planning Time: 1.184 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.124 ms (Deform 0.042 ms), Inlining 0.000 ms, Optimization 0.139 ms, Emission 2.059 ms, Total 2.322 ms
Execution Time: 30360.294 ms
(10 rows)
Time: 30362.008 ms (00:30.362)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115428.61..115428.62 rows=1 width=8) (actual time=30020.320..30020.321 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=59154 width=0) (actual time=1.775..30005.973 rows=371644 loops=1)
Filter: (text ~~ '%東京%'::text)
Rows Removed by Filter: 1092414
Planning Time: 0.186 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.095 ms (Deform 0.030 ms), Inlining 0.000 ms, Optimization 0.085 ms, Emission 1.109 ms, Total 1.289 ms
Execution Time: 30020.450 ms
(10 rows)
Time: 30020.858 ms (00:30.021)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115428.61..115428.62 rows=1 width=8) (actual time=30605.271..30605.272 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=59154 width=0) (actual time=1.788..30590.583 rows=371644 loops=1)
Filter: (text ~~ '%東京%'::text)
Rows Removed by Filter: 1092414
Planning Time: 0.215 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.095 ms (Deform 0.029 ms), Inlining 0.000 ms, Optimization 0.084 ms, Emission 1.104 ms, Total 1.283 ms
Execution Time: 30605.413 ms
(10 rows)
Time: 30605.767 ms (00:30.606)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115428.61..115428.62 rows=1 width=8) (actual time=31135.320..31135.321 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=59154 width=0) (actual time=2.387..31120.437 rows=371644 loops=1)
Filter: (text ~~ '%東京%'::text)
Rows Removed by Filter: 1092414
Planning Time: 0.278 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.156 ms (Deform 0.053 ms), Inlining 0.000 ms, Optimization 0.132 ms, Emission 1.473 ms, Total 1.761 ms
Execution Time: 31135.523 ms
(10 rows)
Time: 31135.934 ms (00:31.136)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115428.61..115428.62 rows=1 width=8) (actual time=31069.056..31069.057 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=59154 width=0) (actual time=1.826..31054.356 rows=371644 loops=1)
Filter: (text ~~ '%東京%'::text)
Rows Removed by Filter: 1092414
Planning Time: 0.179 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.101 ms (Deform 0.036 ms), Inlining 0.000 ms, Optimization 0.087 ms, Emission 1.152 ms, Total 1.340 ms
Execution Time: 31069.189 ms
(10 rows)
Time: 31069.521 ms (00:31.070)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115428.61..115428.62 rows=1 width=8) (actual time=30328.145..30328.146 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=59154 width=0) (actual time=1.786..30313.384 rows=371644 loops=1)
Filter: (text ~~ '%東京%'::text)
Rows Removed by Filter: 1092414
Planning Time: 0.187 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.112 ms (Deform 0.036 ms), Inlining 0.000 ms, Optimization 0.089 ms, Emission 1.117 ms, Total 1.318 ms
Execution Time: 30328.290 ms
(10 rows)
Time: 30328.639 ms (00:30.329)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115428.61..115428.62 rows=1 width=8) (actual time=30732.603..30732.604 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=59154 width=0) (actual time=2.114..30717.899 rows=371644 loops=1)
Filter: (text ~~ '%東京%'::text)
Rows Removed by Filter: 1092414
Planning Time: 0.242 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.121 ms (Deform 0.040 ms), Inlining 0.000 ms, Optimization 0.102 ms, Emission 1.301 ms, Total 1.523 ms
Execution Time: 30732.756 ms
(10 rows)
Time: 30733.238 ms (00:30.733)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115428.61..115428.62 rows=1 width=8) (actual time=31196.697..31196.697 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=59154 width=0) (actual time=1.997..31181.927 rows=371644 loops=1)
Filter: (text ~~ '%東京%'::text)
Rows Removed by Filter: 1092414
Planning Time: 0.233 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.122 ms (Deform 0.039 ms), Inlining 0.000 ms, Optimization 0.104 ms, Emission 1.278 ms, Total 1.505 ms
Execution Time: 31196.854 ms
(10 rows)
Time: 31197.207 ms (00:31.197)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115428.61..115428.62 rows=1 width=8) (actual time=31251.673..31251.674 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=59154 width=0) (actual time=1.865..31236.634 rows=371644 loops=1)
Filter: (text ~~ '%東京%'::text)
Rows Removed by Filter: 1092414
Planning Time: 0.182 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.095 ms (Deform 0.030 ms), Inlining 0.000 ms, Optimization 0.086 ms, Emission 1.161 ms, Total 1.342 ms
Execution Time: 31251.801 ms
(10 rows)
Time: 31252.233 ms (00:31.252)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115428.61..115428.62 rows=1 width=8) (actual time=32415.960..32415.961 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=59154 width=0) (actual time=2.383..32400.185 rows=371644 loops=1)
Filter: (text ~~ '%東京%'::text)
Rows Removed by Filter: 1092414
Planning Time: 0.260 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.145 ms (Deform 0.045 ms), Inlining 0.000 ms, Optimization 0.123 ms, Emission 1.444 ms, Total 1.712 ms
Execution Time: 32416.157 ms
(10 rows)
Time: 32416.584 ms (00:32.417)
= 技術者 ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=604.09..604.10 rows=1 width=8) (actual time=1094.260..1094.261 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=34.89..603.72 rows=146 width=0) (actual time=4.573..1093.347 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 1
Heap Blocks: exact=16546
-> Bitmap Index Scan on wikipedia_index (cost=0.00..34.85 rows=146 width=0) (actual time=2.600..2.600 rows=19975 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 1.366 ms
Execution Time: 1094.530 ms
(9 rows)
Time: 1096.477 ms (00:01.096)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=604.09..604.10 rows=1 width=8) (actual time=1069.770..1069.770 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=34.89..603.72 rows=146 width=0) (actual time=3.849..1068.868 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 1
Heap Blocks: exact=16546
-> Bitmap Index Scan on wikipedia_index (cost=0.00..34.85 rows=146 width=0) (actual time=1.973..1.973 rows=19975 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.240 ms
Execution Time: 1069.926 ms
(9 rows)
Time: 1070.516 ms (00:01.071)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=604.09..604.10 rows=1 width=8) (actual time=1102.333..1102.334 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=34.89..603.72 rows=146 width=0) (actual time=4.353..1101.220 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 1
Heap Blocks: exact=16546
-> Bitmap Index Scan on wikipedia_index (cost=0.00..34.85 rows=146 width=0) (actual time=2.413..2.413 rows=19975 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.235 ms
Execution Time: 1102.557 ms
(9 rows)
Time: 1102.926 ms (00:01.103)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=604.09..604.10 rows=1 width=8) (actual time=1018.012..1018.013 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=34.89..603.72 rows=146 width=0) (actual time=3.607..1017.084 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 1
Heap Blocks: exact=16546
-> Bitmap Index Scan on wikipedia_index (cost=0.00..34.85 rows=146 width=0) (actual time=2.012..2.012 rows=19975 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.210 ms
Execution Time: 1018.235 ms
(9 rows)
Time: 1018.566 ms (00:01.019)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=604.09..604.10 rows=1 width=8) (actual time=963.255..963.256 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=34.89..603.72 rows=146 width=0) (actual time=3.276..962.460 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 1
Heap Blocks: exact=16546
-> Bitmap Index Scan on wikipedia_index (cost=0.00..34.85 rows=146 width=0) (actual time=1.790..1.790 rows=19975 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.193 ms
Execution Time: 963.484 ms
(9 rows)
Time: 963.842 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=604.09..604.10 rows=1 width=8) (actual time=967.673..967.674 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=34.89..603.72 rows=146 width=0) (actual time=3.132..966.888 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 1
Heap Blocks: exact=16546
-> Bitmap Index Scan on wikipedia_index (cost=0.00..34.85 rows=146 width=0) (actual time=1.719..1.719 rows=19975 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.210 ms
Execution Time: 967.843 ms
(9 rows)
Time: 968.309 ms
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=604.09..604.10 rows=1 width=8) (actual time=1081.629..1081.630 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=34.89..603.72 rows=146 width=0) (actual time=3.522..1080.797 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 1
Heap Blocks: exact=16546
-> Bitmap Index Scan on wikipedia_index (cost=0.00..34.85 rows=146 width=0) (actual time=1.918..1.918 rows=19975 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.197 ms
Execution Time: 1081.773 ms
(9 rows)
Time: 1082.198 ms (00:01.082)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=604.09..604.10 rows=1 width=8) (actual time=1029.493..1029.494 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=34.89..603.72 rows=146 width=0) (actual time=3.277..1028.666 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 1
Heap Blocks: exact=16546
-> Bitmap Index Scan on wikipedia_index (cost=0.00..34.85 rows=146 width=0) (actual time=1.791..1.791 rows=19975 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.213 ms
Execution Time: 1029.695 ms
(9 rows)
Time: 1030.020 ms (00:01.030)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=604.09..604.10 rows=1 width=8) (actual time=1068.201..1068.202 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=34.89..603.72 rows=146 width=0) (actual time=4.077..1067.411 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 1
Heap Blocks: exact=16546
-> Bitmap Index Scan on wikipedia_index (cost=0.00..34.85 rows=146 width=0) (actual time=2.327..2.328 rows=19975 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.218 ms
Execution Time: 1068.430 ms
(9 rows)
Time: 1068.939 ms (00:01.069)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=604.09..604.10 rows=1 width=8) (actual time=981.463..981.464 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=34.89..603.72 rows=146 width=0) (actual time=3.372..980.672 rows=19974 loops=1)
Recheck Cond: (text ~~ '%技術者%'::text)
Rows Removed by Index Recheck: 1
Heap Blocks: exact=16546
-> Bitmap Index Scan on wikipedia_index (cost=0.00..34.85 rows=146 width=0) (actual time=1.893..1.894 rows=19975 loops=1)
Index Cond: (text ~~ '%技術者%'::text)
Planning Time: 0.226 ms
Execution Time: 981.634 ms
(9 rows)
Time: 981.981 ms
= ロケット ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=1811.806..1811.807 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=6.138..1811.003 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 1349
Heap Blocks: exact=15982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=3.809..3.809 rows=19431 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.901 ms
Execution Time: 1811.965 ms
(9 rows)
Time: 1813.324 ms (00:01.813)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=1821.894..1821.894 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=5.236..1821.108 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 1349
Heap Blocks: exact=15982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=3.133..3.133 rows=19431 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.255 ms
Execution Time: 1822.038 ms
(9 rows)
Time: 1822.558 ms (00:01.823)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=1810.760..1810.761 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=4.746..1809.966 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 1349
Heap Blocks: exact=15982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=2.982..2.982 rows=19431 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.237 ms
Execution Time: 1810.923 ms
(9 rows)
Time: 1811.293 ms (00:01.811)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=1817.228..1817.229 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=5.117..1816.098 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 1349
Heap Blocks: exact=15982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=3.143..3.144 rows=19431 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.231 ms
Execution Time: 1817.349 ms
(9 rows)
Time: 1817.896 ms (00:01.818)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=1772.479..1772.479 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=5.010..1771.680 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 1349
Heap Blocks: exact=15982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=3.069..3.070 rows=19431 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.250 ms
Execution Time: 1772.689 ms
(9 rows)
Time: 1773.124 ms (00:01.773)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=1812.009..1812.010 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=4.728..1811.199 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 1349
Heap Blocks: exact=15982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=2.945..2.946 rows=19431 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.253 ms
Execution Time: 1812.124 ms
(9 rows)
Time: 1812.608 ms (00:01.813)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=1809.121..1809.121 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=4.681..1808.308 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 1349
Heap Blocks: exact=15982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=2.920..2.920 rows=19431 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.254 ms
Execution Time: 1809.228 ms
(9 rows)
Time: 1809.622 ms (00:01.810)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=1821.639..1821.640 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=4.662..1820.891 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 1349
Heap Blocks: exact=15982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=2.886..2.887 rows=19431 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.231 ms
Execution Time: 1821.741 ms
(9 rows)
Time: 1822.124 ms (00:01.822)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=1800.892..1800.893 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=4.919..1800.059 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 1349
Heap Blocks: exact=15982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=3.150..3.150 rows=19431 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.245 ms
Execution Time: 1801.031 ms
(9 rows)
Time: 1801.509 ms (00:01.802)
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=1795.695..1795.696 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=4.681..1794.927 rows=18082 loops=1)
Recheck Cond: (text ~~ '%ロケット%'::text)
Rows Removed by Index Recheck: 1349
Heap Blocks: exact=15982
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=2.916..2.917 rows=19431 loops=1)
Index Cond: (text ~~ '%ロケット%'::text)
Planning Time: 0.230 ms
Execution Time: 1795.813 ms
(9 rows)
Time: 1796.164 ms (00:01.796)
= データベース ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=694.08..694.09 rows=1 width=8) (actual time=2329.291..2329.292 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=124.88..693.71 rows=146 width=0) (actual time=12.598..2327.590 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 21
Heap Blocks: exact=29004
-> Bitmap Index Scan on wikipedia_index (cost=0.00..124.85 rows=146 width=0) (actual time=8.557..8.557 rows=39459 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.818 ms
Execution Time: 2329.490 ms
(9 rows)
Time: 2330.718 ms (00:02.331)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=694.08..694.09 rows=1 width=8) (actual time=2232.473..2232.474 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=124.88..693.71 rows=146 width=0) (actual time=11.735..2230.903 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 21
Heap Blocks: exact=29004
-> Bitmap Index Scan on wikipedia_index (cost=0.00..124.85 rows=146 width=0) (actual time=7.863..7.864 rows=39459 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.297 ms
Execution Time: 2232.704 ms
(9 rows)
Time: 2233.329 ms (00:02.233)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=694.08..694.09 rows=1 width=8) (actual time=2256.994..2256.995 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=124.88..693.71 rows=146 width=0) (actual time=11.805..2255.333 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 21
Heap Blocks: exact=29004
-> Bitmap Index Scan on wikipedia_index (cost=0.00..124.85 rows=146 width=0) (actual time=7.959..7.959 rows=39459 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.235 ms
Execution Time: 2257.203 ms
(9 rows)
Time: 2257.679 ms (00:02.258)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=694.08..694.09 rows=1 width=8) (actual time=2350.076..2350.077 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=124.88..693.71 rows=146 width=0) (actual time=10.889..2348.356 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 21
Heap Blocks: exact=29004
-> Bitmap Index Scan on wikipedia_index (cost=0.00..124.85 rows=146 width=0) (actual time=7.254..7.255 rows=39459 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.239 ms
Execution Time: 2350.330 ms
(9 rows)
Time: 2350.689 ms (00:02.351)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=694.08..694.09 rows=1 width=8) (actual time=2488.078..2488.079 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=124.88..693.71 rows=146 width=0) (actual time=14.677..2486.272 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 21
Heap Blocks: exact=29004
-> Bitmap Index Scan on wikipedia_index (cost=0.00..124.85 rows=146 width=0) (actual time=8.619..8.620 rows=39459 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.261 ms
Execution Time: 2488.320 ms
(9 rows)
Time: 2488.841 ms (00:02.489)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=694.08..694.09 rows=1 width=8) (actual time=2220.921..2220.922 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=124.88..693.71 rows=146 width=0) (actual time=11.221..2219.178 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 21
Heap Blocks: exact=29004
-> Bitmap Index Scan on wikipedia_index (cost=0.00..124.85 rows=146 width=0) (actual time=7.576..7.577 rows=39459 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.284 ms
Execution Time: 2221.218 ms
(9 rows)
Time: 2221.658 ms (00:02.222)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=694.08..694.09 rows=1 width=8) (actual time=2227.500..2227.501 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=124.88..693.71 rows=146 width=0) (actual time=11.051..2225.880 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 21
Heap Blocks: exact=29004
-> Bitmap Index Scan on wikipedia_index (cost=0.00..124.85 rows=146 width=0) (actual time=7.431..7.431 rows=39459 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.225 ms
Execution Time: 2227.754 ms
(9 rows)
Time: 2228.100 ms (00:02.228)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=694.08..694.09 rows=1 width=8) (actual time=2160.925..2160.926 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=124.88..693.71 rows=146 width=0) (actual time=11.260..2159.358 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 21
Heap Blocks: exact=29004
-> Bitmap Index Scan on wikipedia_index (cost=0.00..124.85 rows=146 width=0) (actual time=7.580..7.580 rows=39459 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.244 ms
Execution Time: 2161.199 ms
(9 rows)
Time: 2161.574 ms (00:02.162)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=694.08..694.09 rows=1 width=8) (actual time=2223.892..2223.893 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=124.88..693.71 rows=146 width=0) (actual time=11.031..2222.321 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 21
Heap Blocks: exact=29004
-> Bitmap Index Scan on wikipedia_index (cost=0.00..124.85 rows=146 width=0) (actual time=7.285..7.286 rows=39459 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.231 ms
Execution Time: 2224.135 ms
(9 rows)
Time: 2224.531 ms (00:02.225)
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=694.08..694.09 rows=1 width=8) (actual time=2237.397..2237.398 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=124.88..693.71 rows=146 width=0) (actual time=11.224..2235.718 rows=39438 loops=1)
Recheck Cond: (text ~~ '%データベース%'::text)
Rows Removed by Index Recheck: 21
Heap Blocks: exact=29004
-> Bitmap Index Scan on wikipedia_index (cost=0.00..124.85 rows=146 width=0) (actual time=7.608..7.608 rows=39459 loops=1)
Index Cond: (text ~~ '%データベース%'::text)
Planning Time: 0.234 ms
Execution Time: 2237.664 ms
(9 rows)
Time: 2238.022 ms (00:02.238)
= DB ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115281.09..115281.10 rows=1 width=8) (actual time=32994.525..32994.526 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=146 width=0) (actual time=4.062..32991.831 rows=31892 loops=1)
Filter: (text ~~ '%DB%'::text)
Rows Removed by Filter: 1432166
Planning Time: 0.748 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.118 ms (Deform 0.039 ms), Inlining 0.000 ms, Optimization 0.141 ms, Emission 1.949 ms, Total 2.208 ms
Execution Time: 33004.644 ms
(10 rows)
Time: 33005.861 ms (00:33.006)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115281.09..115281.10 rows=1 width=8) (actual time=33173.811..33173.811 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=146 width=0) (actual time=2.725..33171.257 rows=31892 loops=1)
Filter: (text ~~ '%DB%'::text)
Rows Removed by Filter: 1432166
Planning Time: 0.206 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.153 ms (Deform 0.047 ms), Inlining 0.000 ms, Optimization 0.093 ms, Emission 1.101 ms, Total 1.347 ms
Execution Time: 33173.995 ms
(10 rows)
Time: 33174.388 ms (00:33.174)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115281.09..115281.10 rows=1 width=8) (actual time=33259.068..33259.068 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=146 width=0) (actual time=2.679..33256.593 rows=31892 loops=1)
Filter: (text ~~ '%DB%'::text)
Rows Removed by Filter: 1432166
Planning Time: 0.185 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.105 ms (Deform 0.034 ms), Inlining 0.000 ms, Optimization 0.089 ms, Emission 1.113 ms, Total 1.308 ms
Execution Time: 33259.208 ms
(10 rows)
Time: 33259.527 ms (00:33.260)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115281.09..115281.10 rows=1 width=8) (actual time=33458.433..33458.434 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=146 width=0) (actual time=2.935..33455.804 rows=31892 loops=1)
Filter: (text ~~ '%DB%'::text)
Rows Removed by Filter: 1432166
Planning Time: 0.192 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.101 ms (Deform 0.034 ms), Inlining 0.000 ms, Optimization 0.086 ms, Emission 1.229 ms, Total 1.416 ms
Execution Time: 33458.567 ms
(10 rows)
Time: 33458.946 ms (00:33.459)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115281.09..115281.10 rows=1 width=8) (actual time=33345.040..33345.041 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=146 width=0) (actual time=2.706..33342.422 rows=31892 loops=1)
Filter: (text ~~ '%DB%'::text)
Rows Removed by Filter: 1432166
Planning Time: 0.181 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.098 ms (Deform 0.032 ms), Inlining 0.000 ms, Optimization 0.084 ms, Emission 1.082 ms, Total 1.263 ms
Execution Time: 33345.168 ms
(10 rows)
Time: 33345.468 ms (00:33.345)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115281.09..115281.10 rows=1 width=8) (actual time=33382.860..33382.861 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=146 width=0) (actual time=2.723..33380.521 rows=31892 loops=1)
Filter: (text ~~ '%DB%'::text)
Rows Removed by Filter: 1432166
Planning Time: 0.178 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.099 ms (Deform 0.031 ms), Inlining 0.000 ms, Optimization 0.084 ms, Emission 1.142 ms, Total 1.325 ms
Execution Time: 33382.990 ms
(10 rows)
Time: 33383.320 ms (00:33.383)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115281.09..115281.10 rows=1 width=8) (actual time=32766.671..32766.672 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=146 width=0) (actual time=2.632..32764.313 rows=31892 loops=1)
Filter: (text ~~ '%DB%'::text)
Rows Removed by Filter: 1432166
Planning Time: 0.174 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.104 ms (Deform 0.040 ms), Inlining 0.000 ms, Optimization 0.085 ms, Emission 1.072 ms, Total 1.261 ms
Execution Time: 32766.809 ms
(10 rows)
Time: 32767.099 ms (00:32.767)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115281.09..115281.10 rows=1 width=8) (actual time=32842.069..32842.070 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=146 width=0) (actual time=2.858..32839.735 rows=31892 loops=1)
Filter: (text ~~ '%DB%'::text)
Rows Removed by Filter: 1432166
Planning Time: 0.211 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.124 ms (Deform 0.034 ms), Inlining 0.000 ms, Optimization 0.090 ms, Emission 1.159 ms, Total 1.372 ms
Execution Time: 32842.228 ms
(10 rows)
Time: 32842.674 ms (00:32.843)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115281.09..115281.10 rows=1 width=8) (actual time=33616.861..33616.862 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=146 width=0) (actual time=2.793..33614.310 rows=31892 loops=1)
Filter: (text ~~ '%DB%'::text)
Rows Removed by Filter: 1432166
Planning Time: 0.208 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.129 ms (Deform 0.040 ms), Inlining 0.000 ms, Optimization 0.116 ms, Emission 1.172 ms, Total 1.417 ms
Execution Time: 33617.032 ms
(10 rows)
Time: 33617.409 ms (00:33.617)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=115281.09..115281.10 rows=1 width=8) (actual time=32315.487..32315.488 rows=1 loops=1)
-> Seq Scan on wikipedia (cost=0.00..115280.73 rows=146 width=0) (actual time=2.872..32313.214 rows=31892 loops=1)
Filter: (text ~~ '%DB%'::text)
Rows Removed by Filter: 1432166
Planning Time: 0.213 ms
JIT:
Functions: 4
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.127 ms (Deform 0.043 ms), Inlining 0.000 ms, Optimization 0.104 ms, Emission 1.223 ms, Total 1.453 ms
Execution Time: 32315.675 ms
(10 rows)
Time: 32316.024 ms (00:32.316)
= test ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=7448.363..7448.364 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=32.692..7446.376 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 110068
Heap Blocks: exact=66351
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=22.873..22.873 rows=151466 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.826 ms
Execution Time: 7448.698 ms
(9 rows)
Time: 7449.958 ms (00:07.450)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=7567.294..7567.295 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=29.142..7565.179 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 110068
Heap Blocks: exact=66351
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=20.025..20.025 rows=151466 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.201 ms
Execution Time: 7567.788 ms
(9 rows)
Time: 7568.305 ms (00:07.568)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=7844.645..7844.646 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=27.024..7842.450 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 110068
Heap Blocks: exact=66351
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=18.822..18.822 rows=151466 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.207 ms
Execution Time: 7845.161 ms
(9 rows)
Time: 7845.497 ms (00:07.845)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=7327.588..7327.589 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=30.589..7325.630 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 110068
Heap Blocks: exact=66351
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=21.859..21.859 rows=151466 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.223 ms
Execution Time: 7328.125 ms
(9 rows)
Time: 7328.478 ms (00:07.328)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=7409.730..7409.731 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=33.786..7407.611 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 110068
Heap Blocks: exact=66351
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=24.439..24.439 rows=151466 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.227 ms
Execution Time: 7410.230 ms
(9 rows)
Time: 7410.589 ms (00:07.411)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=7430.924..7430.925 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=27.346..7429.045 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 110068
Heap Blocks: exact=66351
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=19.101..19.101 rows=151466 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.203 ms
Execution Time: 7431.347 ms
(9 rows)
Time: 7431.728 ms (00:07.432)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=7362.801..7362.802 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=27.213..7360.894 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 110068
Heap Blocks: exact=66351
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=18.569..18.569 rows=151466 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.190 ms
Execution Time: 7363.308 ms
(9 rows)
Time: 7363.658 ms (00:07.364)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=7318.508..7318.509 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=25.610..7316.555 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 110068
Heap Blocks: exact=66351
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=17.748..17.748 rows=151466 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.182 ms
Execution Time: 7319.004 ms
(9 rows)
Time: 7319.316 ms (00:07.319)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=7250.268..7250.269 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=31.572..7248.459 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 110068
Heap Blocks: exact=66351
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=22.252..22.252 rows=151466 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.427 ms
Execution Time: 7250.742 ms
(9 rows)
Time: 7251.349 ms (00:07.251)
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=634.08..634.09 rows=1 width=8) (actual time=7509.881..7509.882 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=64.89..633.72 rows=146 width=0) (actual time=29.269..7507.923 rows=41398 loops=1)
Recheck Cond: (text ~~ '%test%'::text)
Rows Removed by Index Recheck: 110068
Heap Blocks: exact=66351
-> Bitmap Index Scan on wikipedia_index (cost=0.00..64.85 rows=146 width=0) (actual time=20.271..20.271 rows=151466 loops=1)
Index Cond: (text ~~ '%test%'::text)
Planning Time: 0.197 ms
Execution Time: 7510.310 ms
(9 rows)
Time: 7510.631 ms (00:07.511)
= PostgreSQL ===============================================
SET
SET
Pager usage is off.
Timing is on.
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=814.07..814.08 rows=1 width=8) (actual time=23.398..23.399 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=244.87..813.70 rows=146 width=0) (actual time=7.791..23.382 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 2
Heap Blocks: exact=260
-> Bitmap Index Scan on wikipedia_index (cost=0.00..244.84 rows=146 width=0) (actual time=7.637..7.637 rows=261 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 1.109 ms
Execution Time: 23.543 ms
(9 rows)
Time: 25.127 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=814.07..814.08 rows=1 width=8) (actual time=15.407..15.407 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=244.87..813.70 rows=146 width=0) (actual time=5.470..15.396 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 2
Heap Blocks: exact=260
-> Bitmap Index Scan on wikipedia_index (cost=0.00..244.84 rows=146 width=0) (actual time=5.408..5.408 rows=261 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.229 ms
Execution Time: 15.418 ms
(9 rows)
Time: 15.873 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=814.07..814.08 rows=1 width=8) (actual time=13.398..13.398 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=244.87..813.70 rows=146 width=0) (actual time=4.316..13.389 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 2
Heap Blocks: exact=260
-> Bitmap Index Scan on wikipedia_index (cost=0.00..244.84 rows=146 width=0) (actual time=4.264..4.264 rows=261 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.181 ms
Execution Time: 13.411 ms
(9 rows)
Time: 13.730 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=814.07..814.08 rows=1 width=8) (actual time=13.723..13.723 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=244.87..813.70 rows=146 width=0) (actual time=4.665..13.713 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 2
Heap Blocks: exact=260
-> Bitmap Index Scan on wikipedia_index (cost=0.00..244.84 rows=146 width=0) (actual time=4.610..4.610 rows=261 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.159 ms
Execution Time: 13.729 ms
(9 rows)
Time: 14.017 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=814.07..814.08 rows=1 width=8) (actual time=14.110..14.111 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=244.87..813.70 rows=146 width=0) (actual time=4.599..14.101 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 2
Heap Blocks: exact=260
-> Bitmap Index Scan on wikipedia_index (cost=0.00..244.84 rows=146 width=0) (actual time=4.547..4.547 rows=261 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.162 ms
Execution Time: 14.118 ms
(9 rows)
Time: 14.405 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=814.07..814.08 rows=1 width=8) (actual time=12.979..12.979 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=244.87..813.70 rows=146 width=0) (actual time=4.290..12.969 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 2
Heap Blocks: exact=260
-> Bitmap Index Scan on wikipedia_index (cost=0.00..244.84 rows=146 width=0) (actual time=4.240..4.240 rows=261 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.167 ms
Execution Time: 12.987 ms
(9 rows)
Time: 13.386 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=814.07..814.08 rows=1 width=8) (actual time=12.731..12.731 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=244.87..813.70 rows=146 width=0) (actual time=4.317..12.722 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 2
Heap Blocks: exact=260
-> Bitmap Index Scan on wikipedia_index (cost=0.00..244.84 rows=146 width=0) (actual time=4.267..4.267 rows=261 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.162 ms
Execution Time: 12.738 ms
(9 rows)
Time: 13.097 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=814.07..814.08 rows=1 width=8) (actual time=12.450..12.450 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=244.87..813.70 rows=146 width=0) (actual time=4.262..12.442 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 2
Heap Blocks: exact=260
-> Bitmap Index Scan on wikipedia_index (cost=0.00..244.84 rows=146 width=0) (actual time=4.218..4.218 rows=261 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.157 ms
Execution Time: 12.455 ms
(9 rows)
Time: 12.697 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=814.07..814.08 rows=1 width=8) (actual time=12.485..12.485 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=244.87..813.70 rows=146 width=0) (actual time=4.107..12.476 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 2
Heap Blocks: exact=260
-> Bitmap Index Scan on wikipedia_index (cost=0.00..244.84 rows=146 width=0) (actual time=4.060..4.060 rows=261 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.147 ms
Execution Time: 12.492 ms
(9 rows)
Time: 12.802 ms
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=814.07..814.08 rows=1 width=8) (actual time=12.803..12.803 rows=1 loops=1)
-> Bitmap Heap Scan on wikipedia (cost=244.87..813.70 rows=146 width=0) (actual time=4.286..12.794 rows=259 loops=1)
Recheck Cond: (text ~~ '%PostgreSQL%'::text)
Rows Removed by Index Recheck: 2
Heap Blocks: exact=260
-> Bitmap Index Scan on wikipedia_index (cost=0.00..244.84 rows=146 width=0) (actual time=4.237..4.237 rows=261 loops=1)
Index Cond: (text ~~ '%PostgreSQL%'::text)
Planning Time: 0.157 ms
Execution Time: 12.811 ms
(9 rows)
Time: 13.137 ms