[pgsql-jp: 41125] Re: パーティショニングについて
mitani
mitani ＠ sraw.co.jp
2012年 6月 11日 (月) 17:31:45 JST
$B$3$s$K$A$O!#(B
$B;0C+!w9-Eg$G$9!#(B
postgresql.conf $B$G(B constraint_exclustion = on
$B$K$5$l$F$^$9$+!)(B
On Mon, 11 Jun 2012 17:10:45 +0900
$B-j%d%^%@EE5!!!K!?M;v6HIt!!0eNE%=%j%e!<%7%g%sIt(B $B1J1:(B <nagaura ＠ yamada-denki.jp> wrote:
> $B!!$*@$OC$K$J$j$^$9!#(BNAGAURA$B$H?=$7$^$9!#(B
>
> $B8=:_!"(BUbuntu10.04 32bit$B!!(BPostgresql 8.4.11$B4D6-$G!"(BBytea$B$r4^$`%F!<%V%k$N%Q!<(B
> $B%F%#%7%g%K%s%0$r;n$7$F$$$^$9!#(B
>
> $B%-!<$H$J$k%G!<%?$O?t;z7?$GG/7nF|(B+1$B$+$i$NO"HV$G!"%-!<$r(B50$B$G3d$C$?M>$j(B0$B!A(B49$B$N(B
> $B%F!<%V%k$r;H$&%O%C%7%e$K$h$k(B
> $B%Q!<%F%#%7%g%K%s%0$r9T$C$F$_$^$7$?$,!"(BSELECT$B;~$KA4$F$N%F!<%V%k$K%"%/%;%9$7$F(B
> $B$$$kMM$G%Q!<%F%#%7%g%K%s%0$,(B
> $BF0:n$7$F$$$kMM$K8+$($J$$>uBV$G:$OG$7$F$$$^$9!#(B
>
> $B$I$J$?$+%"%I%P%$%9$r$*4j$$CW$7$^$9!#(B
>
> $B"(%G!<%?$NJ,3dJ}K!$H$7$FG/7nF|$+$i;O$^$k%-!<$G$9$N$G!"%l%s%8%Q!<%F%#%7%g%K%s(B
> $B%0$b9MN8$7$^$7$?$,!"%a%s%F%J%s%9(B
> $B!!@-$r9MN8$9$k$H%O%C%7%e%Q!<%F%#%7%g%K%s%0$r;H$&$Y$-$+$H;W$C$F$^$9!#(B
>
> $B0J2<(BSQL$BJ,$G$9!#(B
>
> 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 ( );
>
>
> $B<B9T7k2L(B
>
> 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"
>
> $B0J>e!"$h$m$7$/$*4j$$$7$^$9!#(B
>
>
> __________ 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 ＠ sraw.co.jp>
pgsql-jp メーリングリストの案内