2012年6月11日

[pgsql-jp: 41125] Re:パーティショニングについて

こんにちは。
三谷@広島です。

postgresql.conf で constraint_exclustion = on
にされてますか?


On Mon, 11 Jun 2012 17:10:45 +0900

?ヤマダ電機 法人事業部 医療ソリューション部 永浦 <nagaura@xxxxx> wrote:

>  お世話になります。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
>
>


--
mitani <mitani@xxxxx>


投稿者 xml-rpc : 2012年6月11日 17:31
役に立ちました?:
過去のフィードバック 平均:(0) 総合:(0) 投票回数:(0)
本記事へのTrackback: http://hoop.euqset.org/blog/mt-tb2006.cgi/110821
トラックバック
コメント
コメントする




画像の中に見える文字を入力してください。