[pgsql-jp: 41124] パーティショニングについて
=?iso-2022-jp?B?GyRCLWolZCVeJUBFRTUhISFLIT9NO3Y2SEl0ISEwZU5FJT0lahsoQg==?=
=?iso-2022-jp?B?GyRCLWolZCVeJUBFRTUhISFLIT9NO3Y2SEl0ISEwZU5FJT0lahsoQg==?=
2012年 6月 11日 (月) 17:10:45 JST
お世話になります。NAGAURAと申します。
現在、Ubuntu10.04 32bit Postgresql 8.4.11環境で、Byteaを含むテーブルのパー
ティショニングを試しています。
キーとなるデータは数字型で年月日+1からの連番で、キーを50で割った余り0〜49の
テーブルを使うハッシュによる
パーティショニングを行ってみましたが、SELECT時に全てのテーブルにアクセスして
いる様でパーティショニングが
動作している様に見えない状態で困惑しています。
どなたかアドバイスをお願い致します。
※データの分割方法として年月日から始まるキーですので、レンジパーティショニン
グも考慮しましたが、メンテナンス
性を考慮するとハッシュパーティショニングを使うべきかと思ってます。
以下SQL分です。
CREATE TABLE t_test_file
(
file_no numeric(14) NOT NULL,
obj_id integer NOT NULL,
z_order integer,
obj_type integer,
tl_x integer,
tl_y integer,
br_x integer,
br_y integer,
history_no integer NOT NULL,
obj_data bytea,
user_id character varying(32),
write_date date,
write_time time without time zone,
CONSTRAINT t_test_file_primary_key PRIMARY KEY (file_no, obj_id,
history_no)
)
WITHOUT OIDS;
CREATE TABLE T_TEST_FILE_000
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 0 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_001
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 1 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_002
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 2 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_003
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 3 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_004
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 4 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_005
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 5 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_006
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 6 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_007
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 7 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_008
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 8 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_009
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 9 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_010
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 10 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_011
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 11 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_012
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 12 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_013
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 13 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_014
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 14 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_015
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 15 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_016
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 16 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_017
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 17 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_018
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 18 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_019
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 19 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_020
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 20 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_021
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 21 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_022
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 22 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_023
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 23 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_024
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 24 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_025
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 25 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_026
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 26 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_027
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 27 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_028
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 28 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_029
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 29 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_030
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 30 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_031
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 31 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_032
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 32 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_033
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 33 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_034
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 34 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_035
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 35 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_036
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 36 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_037
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 37 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_038
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 38 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_039
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 39 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_040
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 40 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_041
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 41 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_042
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 42 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_043
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 43 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_044
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 44 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_045
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 45 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_046
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 46 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_047
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 47 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_048
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 48 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE TABLE T_TEST_FILE_049
(
LIKE T_TEST_FILE
INCLUDING INDEXES
INCLUDING DEFAULTS
INCLUDING CONSTRAINTS,
CHECK ( 49 = ( FILE_NO % 50 ) )
)
INHERITS (
T_TEST_FILE
);
CREATE OR REPLACE FUNCTION T_TEST_FILE_INS_TRIGGER ( ) RETURNS TRIGGER AS
$_$
DECLARE
BEGIN
EXECUTE 'INSERT INTO T_TEST_FILE_' || TRIM ( TO_CHAR ( ( NEW.FILE_NO
% 50 ), '000' ) ) || ' VALUES ( ( $1 ).* )' USING new;
RETURN NULL;
END;
$_$ LANGUAGE plpgsql;
CREATE TRIGGER INSERT_TEST_FILE_TRIGGER
BEFORE INSERT ON T_TEST_FILE
FOR EACH ROW EXECUTE PROCEDURE T_TEST_FILE_INS_TRIGGER ( );
実行結果
SET constraint_exclusion = partition;
explain analyze
select * from t_test_file
where file_no = 2011062000001;
"Result (cost=4.27..489.97 rows=102 width=157) (actual time=0.173..0.723
rows=2 loops=1)"
" -> Append (cost=4.27..489.97 rows=102 width=157) (actual time=0.169..0.
716 rows=2 loops=1)"
" -> Bitmap Heap Scan on t_test_file (cost=4.27..9.61 rows=2
width=157) (actual time=0.040..0.040 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_primary_key
(cost=0.00..4.27 rows=2 width=0) (actual time=0.037..0.037 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_000 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.012..0.012 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_000_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.010..0.010 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_001 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.115..0.116 rows=2 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_001_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.107..0.107 rows=2 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_002 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.013..0.013 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_002_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.011..0.011 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_003 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.035..0.035 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_003_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.034..0.034 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_004 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.029..0.029 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_004_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.022..0.022 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_005 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.010..0.010 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_005_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.008..0.008 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_006 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.010..0.010 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_006_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_007 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.009..0.009 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_007_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.008..0.008 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_008 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.042..0.042 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_008_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.041..0.041 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_009 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.007..0.007 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_009_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_010 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.009..0.009 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_010_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.009..0.009 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_011 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.004..0.004 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_011_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_012 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.010..0.010 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_012_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.008..0.008 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_013 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.028..0.028 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_013_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.007..0.007 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_014 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.007..0.007 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_014_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_015 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.009..0.009 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_015_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_016 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.004..0.004 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_016_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_017 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.009..0.009 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_017_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_018 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.004..0.004 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_018_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_019 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.009..0.009 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_019_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_020 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.008..0.008 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_020_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.007..0.007 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_021 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.013..0.013 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_021_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.012..0.012 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_022 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.005..0.005 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_022_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_023 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.013..0.013 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_023_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.011..0.011 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_024 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.005..0.005 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_024_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_025 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.012..0.012 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_025_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.011..0.011 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_026 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.006..0.006 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_026_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_027 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.009..0.009 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_027_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.008..0.008 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_028 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.016..0.016 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_028_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_029 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.005..0.005 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_029_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_030 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.008..0.008 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_030_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_031 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.008..0.008 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_031_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.007..0.007 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_032 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.009..0.009 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_032_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_033 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.004..0.004 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_033_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_034 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.010..0.010 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_034_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.008..0.008 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_035 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.005..0.005 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_035_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_036 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.015..0.015 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_036_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.014..0.014 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_037 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.008..0.008 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_037_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_038 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.011..0.011 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_038_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.010..0.010 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_039 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.004..0.004 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_039_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_040 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.012..0.012 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_040_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.011..0.011 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_041 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.010..0.010 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_041_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_042 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.006..0.006 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_042_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_043 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.016..0.016 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_043_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_044 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.006..0.006 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_044_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_045 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.010..0.010 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_045_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_046 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.005..0.005 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_046_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_047 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.009..0.009 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_047_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_048 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.004..0.004 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_048_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Heap Scan on t_test_file_049 t_test_file (cost=4.27..9.
61 rows=2 width=157) (actual time=0.018..0.018 rows=0 loops=1)"
" Recheck Cond: (file_no = 2011062000001::numeric)"
" -> Bitmap Index Scan on t_test_file_049_pkey (cost=0.00..4.
27 rows=2 width=0) (actual time=0.017..0.017 rows=0 loops=1)"
" Index Cond: (file_no = 2011062000001::numeric)"
"Total runtime: 2.467 ms"
以上、よろしくお願いします。
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 7185 (20120531) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
pgsql-jp メーリングリストの案内