difmet=> \timing
Chronométrage activé.


difmet=> explain analyse select id,priority,state_date from test_update where state = 2101 and channel like 'FTP' and clef like 'ccfccfccfccfccfccfccfccfccfccfccfccfccfccfccf' LIMIT 10;
				QUERY PLAN
-------------------------------------------------------------------------------
 Limit  (cost=0.00..29.38 rows=10 width=20) (actual time=0.041..0.095 rows=10 loops=1)
   ->  Index Scan using indx_test_update_channel on test_update  (cost=0.00..144633.18 rows=49221 width=20) (actual time=0.037..0.066 rows=10 loops=1)
         Index Cond: ((state = 2101) AND ((channel)::text ~=~ 'FTP'::text) AND ((clef)::text ~=~ 'ccfccfccfccfccfccfccfccfccfccfccfccfccfccfccf'::text))
         Filter: (((channel)::text ~~ 'FTP'::text) AND ((clef)::text ~~ 'ccfccfccfccfccfccfccfccfccfccfccfccfccfccfccf'::text))
 Total runtime: 60.145 ms
(5 lignes)

Temps : 60,692 ms



difmet=> \!date
mer jun  4 06:42:32 GMT 2008

difmet=> explain analyze update test_update set state = 3001 where state = 2101 and channel like 'FTP' and clef like 'ccfccfccfccfccfccfccfccfccfccfccfccfccfccfccf' ;
			QUERY PLAN
-------------------------------------------------------------------------------
 Index Scan using indx_test_update_channel on test_update  (cost=0.00..144633.18 rows=49221 width=572) (actual time=0.043..427392.970 rows=51684 loops=1)
   Index Cond: ((state = 2101) AND ((channel)::text ~=~ 'FTP'::text) AND ((clef)::text ~=~ 'ccfccfccfccfccfccfccfccfccfccfccfccfccfccfccf'::text))
   Filter: (((channel)::text ~~ 'FTP'::text) AND ((clef)::text ~~ 'ccfccfccfccfccfccfccfccfccfccfccfccfccfccfccf'::text))
 Total runtime: 963636.603 ms
(4 lignes)

Temps : 963651,070 ms



difmet=> \!date
mer jun  4 06:58:36 GMT 2008


difmet=> analyse verbose test_update ;
INFO:  analyse « public.test_update »
INFO:  « test_update » : 3000 pages parcourues sur 416265,
  contenant 36069 lignes à conserver et 455 lignes à supprimer,
  3000 lignes dans l'échantillon,
  5004754 lignes totales estimées
ANALYZE
Temps : 21002,088 ms


difmet=> \!date
mer jun  4 06:58:57 GMT 2008



difmet=> explain analyse select id,priority,state_date from test_update where state = 2101 and channel like 'FTP' and clef like 'ccfccfccfccfccfccfccfccfccfccfccfccfccfccfccf' LIMIT 10;
			QUERY PLAN
-------------------------------------------------------------------------------
 Limit  (cost=0.00..30.09 rows=10 width=20) (actual time=414984.422..414984.422 rows=0 loops=1)
   ->  Index Scan using indx_test_update_channel on test_update  (cost=0.00..137550.80 rows=45714 width=20) (actual time=414984.417..414984.417 rows=0 loops=1)
         Index Cond: ((state = 2101) AND ((channel)::text ~=~ 'FTP'::text) AND ((clef)::text ~=~ 'ccfccfccfccfccfccfccfccfccfccfccfccfccfccfccf'::text))
         Filter: (((channel)::text ~~ 'FTP'::text) AND ((clef)::text ~~ 'ccfccfccfccfccfccfccfccfccfccfccfccfccfccfccf'::text))
 Total runtime: 414984.465 ms
(5 lignes)

Temps : 419000,683 ms


difmet=> \!date
mer jun  4 07:05:56 GMT 2008



difmet=> \!date
mer jun  4 07:16:25 GMT 2008


difmet=> explain analyse select id,priority,state_date from test_update where state = 2101 and channel like 'FTP' and clef like 'ccfccfccfccfccfccfccfccfccfccfccfccfccfccfccf' LIMIT 10;
			QUERY PLAN
-------------------------------------------------------------------------------
 Limit  (cost=0.00..30.09 rows=10 width=20) (actual time=52.006..52.006 rows=0 loops=1)
   ->  Index Scan using indx_test_update_channel on test_update  (cost=0.00..137550.80 rows=45714 width=20) (actual time=52.000..52.000 rows=0 loops=1)
         Index Cond: ((state = 2101) AND ((channel)::text ~=~ 'FTP'::text) AND ((clef)::text ~=~ 'ccfccfccfccfccfccfccfccfccfccfccfccfccfccfccf'::text))
         Filter: (((channel)::text ~~ 'FTP'::text) AND ((clef)::text ~~ 'ccfccfccfccfccfccfccfccfccfccfccfccfccfccfccf'::text))
 Total runtime: 52.049 ms
(5 lignes)

Temps : 52,691 ms


difmet=> \!date
mer jun  4 07:16:28 GMT 2008