\timing
Timing is on.
\pset pager always
Pager is always used.
DROP TABLE IF EXISTS deliverynotes CASCADE;
psql:testA_prepare_nopkey_btree.sql:1: NOTICE:  table "deliverynotes" does not exist, skipping
DROP TABLE
Time: 0,223 ms
CREATE TABLE deliverynotes AS SELECT * FROM albaranescli;
SELECT 333694
Time: 2150,532 ms
ALTER TABLE deliverynotes SET (fillfactor = 60);
ALTER TABLE
Time: 0,417 ms
CREATE INDEX deliverynotes_codagencia_m1_idx
  ON deliverynotes
  USING btree
  (codagencia );
CREATE INDEX
Time: 769,121 ms
CREATE INDEX deliverynotes_codagenciaup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codagencia::text) );
CREATE INDEX
Time: 860,603 ms
CREATE INDEX deliverynotes_codagente2_m1_idx
  ON deliverynotes
  USING btree
  (codagente2 );
CREATE INDEX
Time: 262,319 ms
CREATE INDEX deliverynotes_codagente2up_m1_idx
  ON deliverynotes
  USING btree
  (upper(codagente2::text) );
CREATE INDEX
Time: 269,040 ms
CREATE INDEX deliverynotes_codagente3_m1_idx
  ON deliverynotes
  USING btree
  (codagente3 );
CREATE INDEX
Time: 172,629 ms
CREATE INDEX deliverynotes_codagente3up_m1_idx
  ON deliverynotes
  USING btree
  (upper(codagente3::text) );
CREATE INDEX
Time: 176,333 ms
CREATE INDEX deliverynotes_codagente_m1_idx
  ON deliverynotes
  USING btree
  (codagente );
CREATE INDEX
Time: 485,535 ms
CREATE INDEX deliverynotes_codagenteup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codagente::text) );
CREATE INDEX
Time: 576,758 ms
CREATE INDEX deliverynotes_codalmacen_m1_idx
  ON deliverynotes
  USING btree
  (codalmacen );
CREATE INDEX
Time: 471,998 ms
CREATE INDEX deliverynotes_codalmacenup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codalmacen::text) );
CREATE INDEX
Time: 588,948 ms
CREATE INDEX deliverynotes_codcentro_m1_idx
  ON deliverynotes
  USING btree
  (codcentro );
CREATE INDEX
Time: 171,577 ms
CREATE INDEX deliverynotes_codcentroup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codcentro::text) );
CREATE INDEX
Time: 211,385 ms
CREATE INDEX deliverynotes_codcliente_m1_idx
  ON deliverynotes
  USING btree
  (codcliente );
CREATE INDEX
Time: 430,421 ms
CREATE INDEX deliverynotes_codclienteup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codcliente::text) );
CREATE INDEX
Time: 582,916 ms
CREATE INDEX deliverynotes_codcondicionentrega_m1_idx
  ON deliverynotes
  USING btree
  (codcondicionentrega );
CREATE INDEX
Time: 467,625 ms
CREATE INDEX deliverynotes_codcondicionentregaup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codcondicionentrega::text) );
CREATE INDEX
Time: 359,508 ms
CREATE INDEX deliverynotes_coddir_cobro_m1_idx
  ON deliverynotes
  USING btree
  (coddir_cobro);
CREATE INDEX
Time: 297,575 ms
CREATE INDEX deliverynotes_coddir_envio_m1_idx
  ON deliverynotes
  USING btree
  (coddir_envio);
CREATE INDEX
Time: 280,294 ms
CREATE INDEX deliverynotes_coddir_m1_idx
  ON deliverynotes
  USING btree
  (coddir);
CREATE INDEX
Time: 257,795 ms
CREATE INDEX deliverynotes_coddivisa_m1_idx
  ON deliverynotes
  USING btree
  (coddivisa );
CREATE INDEX
Time: 592,786 ms
CREATE INDEX deliverynotes_coddivisaup_m1_idx
  ON deliverynotes
  USING btree
  (upper(coddivisa::text) );
CREATE INDEX
Time: 741,042 ms
CREATE INDEX deliverynotes_codejercicio_m1_idx
  ON deliverynotes
  USING btree
  (codejercicio );
CREATE INDEX
Time: 593,067 ms
CREATE INDEX deliverynotes_codejercicioup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codejercicio::text) );
CREATE INDEX
Time: 739,136 ms
CREATE INDEX deliverynotes_codimpuestoportes_m1_idx
  ON deliverynotes
  USING btree
  (codimpuestoportes );
CREATE INDEX
Time: 516,050 ms
CREATE INDEX deliverynotes_codimpuestoportesup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codimpuestoportes::text) );
CREATE INDEX
Time: 654,510 ms
CREATE INDEX deliverynotes_codincoterm_m1_idx
  ON deliverynotes
  USING btree
  (codincoterm );
CREATE INDEX
Time: 536,325 ms
CREATE INDEX deliverynotes_codincotermup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codincoterm::text) );
CREATE INDEX
Time: 688,265 ms
CREATE INDEX deliverynotes_codmodotransporte_m1_idx
  ON deliverynotes
  USING btree
  (codmodotransporte );
CREATE INDEX
Time: 321,644 ms
CREATE INDEX deliverynotes_codmodotransporteup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codmodotransporte::text) );
CREATE INDEX
Time: 353,245 ms
CREATE INDEX deliverynotes_codnaturaleza_m1_idx
  ON deliverynotes
  USING btree
  (codnaturaleza );
CREATE INDEX
Time: 320,535 ms
CREATE INDEX deliverynotes_codnaturalezaup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codnaturaleza::text) );
CREATE INDEX
Time: 354,979 ms
CREATE INDEX deliverynotes_codpacking_m1_idx
  ON deliverynotes
  USING btree
  (codpacking );
CREATE INDEX
Time: 476,384 ms
CREATE INDEX deliverynotes_codpackingup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codpacking::text) );
CREATE INDEX
Time: 512,284 ms
CREATE INDEX deliverynotes_codpago_m1_idx
  ON deliverynotes
  USING btree
  (codpago );
CREATE INDEX
Time: 489,683 ms
CREATE INDEX deliverynotes_codpagoup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codpago::text) );
CREATE INDEX
Time: 629,443 ms
CREATE INDEX deliverynotes_codpais_cobro_m1_idx
  ON deliverynotes
  USING btree
  (codpais_cobro );
CREATE INDEX
Time: 504,022 ms
CREATE INDEX deliverynotes_codpais_cobroup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codpais_cobro::text) );
CREATE INDEX
Time: 648,934 ms
CREATE INDEX deliverynotes_codpais_envio_m1_idx
  ON deliverynotes
  USING btree
  (codpais_envio );
CREATE INDEX
Time: 504,089 ms
CREATE INDEX deliverynotes_codpais_envioup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codpais_envio::text) );
CREATE INDEX
Time: 634,368 ms
CREATE INDEX deliverynotes_codpais_m1_idx
  ON deliverynotes
  USING btree
  (codpais );
CREATE INDEX
Time: 486,258 ms
CREATE INDEX deliverynotes_codpaisup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codpais::text) );
CREATE INDEX
Time: 629,375 ms
CREATE INDEX deliverynotes_codpuerto_m1_idx
  ON deliverynotes
  USING btree
  (codpuerto );
CREATE INDEX
Time: 172,010 ms
CREATE INDEX deliverynotes_codpuertoup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codpuerto::text) );
CREATE INDEX
Time: 210,551 ms
CREATE INDEX deliverynotes_codregimen_m1_idx
  ON deliverynotes
  USING btree
  (codregimen );
CREATE INDEX
Time: 322,403 ms
CREATE INDEX deliverynotes_codregimenup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codregimen::text) );
CREATE INDEX
Time: 360,240 ms
CREATE INDEX deliverynotes_codserie_m1_idx
  ON deliverynotes
  USING btree
  (codserie );
CREATE INDEX
Time: 462,936 ms
CREATE INDEX deliverynotes_codserieup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codserie::text) );
CREATE INDEX
Time: 603,029 ms
CREATE INDEX deliverynotes_codsubcentro_m1_idx
  ON deliverynotes
  USING btree
  (codsubcentro );
CREATE INDEX
Time: 200,422 ms
CREATE INDEX deliverynotes_codsubcentroup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codsubcentro::text) );
CREATE INDEX
Time: 180,771 ms
CREATE INDEX deliverynotes_codtarifa2_m1_idx
  ON deliverynotes
  USING btree
  (codtarifa2 );
CREATE INDEX
Time: 322,750 ms
CREATE INDEX deliverynotes_codtarifa2up_m1_idx
  ON deliverynotes
  USING btree
  (upper(codtarifa2::text) );
CREATE INDEX
Time: 348,211 ms
CREATE INDEX deliverynotes_codtarifa_m1_idx
  ON deliverynotes
  USING btree
  (codtarifa );
CREATE INDEX
Time: 330,639 ms
CREATE INDEX deliverynotes_codtarifaup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codtarifa::text) );
CREATE INDEX
Time: 361,978 ms
CREATE INDEX deliverynotes_codtemporada_m1_idx
  ON deliverynotes
  USING btree
  (codtemporada );
CREATE INDEX
Time: 176,283 ms
CREATE INDEX deliverynotes_codtemporadaup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codtemporada::text) );
CREATE INDEX
Time: 174,598 ms
CREATE INDEX deliverynotes_fecha_idalbaran
  ON deliverynotes
  USING btree
  (fecha, idalbaran);
CREATE INDEX
Time: 318,028 ms
CREATE INDEX deliverynotes_idalbaran_m1_idx
  ON deliverynotes
  USING btree
  (idalbaran);
CREATE INDEX
Time: 179,242 ms
CREATE INDEX deliverynotes_idpedido_m1_idx
  ON deliverynotes
  USING btree
  (idpedido);
CREATE INDEX
Time: 275,244 ms
CREATE INDEX deliverynotes_idprealbaran_m1_idx
  ON deliverynotes
  USING btree
  (idprealbaran);
CREATE INDEX
Time: 172,539 ms
CREATE INDEX deliverynotes_idprovincia_cobro_m1_idx
  ON deliverynotes
  USING btree
  (idprovincia_cobro);
CREATE INDEX
Time: 288,095 ms
CREATE INDEX deliverynotes_idprovincia_envio_m1_idx
  ON deliverynotes
  USING btree
  (idprovincia_envio);
CREATE INDEX
Time: 252,984 ms
CREATE INDEX deliverynotes_idprovincia_m1_idx
  ON deliverynotes
  USING btree
  (idprovincia);
CREATE INDEX
Time: 266,216 ms
CREATE INDEX deliverynotes_numerocodseriecodejercicio_m1_idx
  ON deliverynotes
  USING btree
  (numero , codserie , codejercicio );
CREATE INDEX
Time: 566,381 ms
  
  
--VACUUM ANALYZE deliverynotes;
SELECT nspname || '.' || relname AS "relation",
    pg_size_pretty(pg_relation_size(C.oid)) AS "size"
  FROM pg_class C
  LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
  WHERE nspname NOT IN ('pg_catalog', 'information_schema')
	and relname LIKE 'deliverynote%'
  ORDER BY relname;
                        relation                        |  size   
--------------------------------------------------------+---------
 public.deliverynotes                                   | 219 MB
 public.deliverynotes_codagencia_m1_idx                 | 7344 kB
 public.deliverynotes_codagenciaup_m1_idx               | 7344 kB
 public.deliverynotes_codagente2_m1_idx                 | 7344 kB
 public.deliverynotes_codagente2up_m1_idx               | 7344 kB
 public.deliverynotes_codagente3_m1_idx                 | 7344 kB
 public.deliverynotes_codagente3up_m1_idx               | 7344 kB
 public.deliverynotes_codagente_m1_idx                  | 7344 kB
 public.deliverynotes_codagenteup_m1_idx                | 7344 kB
 public.deliverynotes_codalmacen_m1_idx                 | 7344 kB
 public.deliverynotes_codalmacenup_m1_idx               | 7344 kB
 public.deliverynotes_codcentro_m1_idx                  | 7344 kB
 public.deliverynotes_codcentroup_m1_idx                | 7344 kB
 public.deliverynotes_codcliente_m1_idx                 | 7344 kB
 public.deliverynotes_codclienteup_m1_idx               | 7344 kB
 public.deliverynotes_codcondicionentrega_m1_idx        | 7344 kB
 public.deliverynotes_codcondicionentregaup_m1_idx      | 7344 kB
 public.deliverynotes_coddir_cobro_m1_idx               | 7344 kB
 public.deliverynotes_coddir_envio_m1_idx               | 7344 kB
 public.deliverynotes_coddir_m1_idx                     | 7344 kB
 public.deliverynotes_coddivisa_m1_idx                  | 7344 kB
 public.deliverynotes_coddivisaup_m1_idx                | 7344 kB
 public.deliverynotes_codejercicio_m1_idx               | 7344 kB
 public.deliverynotes_codejercicioup_m1_idx             | 7344 kB
 public.deliverynotes_codimpuestoportes_m1_idx          | 7344 kB
 public.deliverynotes_codimpuestoportesup_m1_idx        | 7344 kB
 public.deliverynotes_codincoterm_m1_idx                | 7344 kB
 public.deliverynotes_codincotermup_m1_idx              | 7344 kB
 public.deliverynotes_codmodotransporte_m1_idx          | 7344 kB
 public.deliverynotes_codmodotransporteup_m1_idx        | 7344 kB
 public.deliverynotes_codnaturaleza_m1_idx              | 7344 kB
 public.deliverynotes_codnaturalezaup_m1_idx            | 7344 kB
 public.deliverynotes_codpacking_m1_idx                 | 7928 kB
 public.deliverynotes_codpackingup_m1_idx               | 7928 kB
 public.deliverynotes_codpago_m1_idx                    | 7344 kB
 public.deliverynotes_codpagoup_m1_idx                  | 7344 kB
 public.deliverynotes_codpais_cobro_m1_idx              | 7344 kB
 public.deliverynotes_codpais_cobroup_m1_idx            | 7344 kB
 public.deliverynotes_codpais_envio_m1_idx              | 7344 kB
 public.deliverynotes_codpais_envioup_m1_idx            | 7344 kB
 public.deliverynotes_codpais_m1_idx                    | 7344 kB
 public.deliverynotes_codpaisup_m1_idx                  | 7344 kB
 public.deliverynotes_codpuerto_m1_idx                  | 7344 kB
 public.deliverynotes_codpuertoup_m1_idx                | 7344 kB
 public.deliverynotes_codregimen_m1_idx                 | 7344 kB
 public.deliverynotes_codregimenup_m1_idx               | 7344 kB
 public.deliverynotes_codserie_m1_idx                   | 7344 kB
 public.deliverynotes_codserieup_m1_idx                 | 7344 kB
 public.deliverynotes_codsubcentro_m1_idx               | 7344 kB
 public.deliverynotes_codsubcentroup_m1_idx             | 7344 kB
 public.deliverynotes_codtarifa2_m1_idx                 | 7344 kB
 public.deliverynotes_codtarifa2up_m1_idx               | 7344 kB
 public.deliverynotes_codtarifa_m1_idx                  | 7344 kB
 public.deliverynotes_codtarifaup_m1_idx                | 7344 kB
 public.deliverynotes_codtemporada_m1_idx               | 7344 kB
 public.deliverynotes_codtemporadaup_m1_idx             | 7344 kB
 public.deliverynotes_fecha_idalbaran                   | 7344 kB
 public.deliverynotes_idalbaran_m1_idx                  | 7344 kB
 public.deliverynotes_idpedido_m1_idx                   | 7344 kB
 public.deliverynotes_idprealbaran_m1_idx               | 7344 kB
 public.deliverynotes_idprovincia_cobro_m1_idx          | 7344 kB
 public.deliverynotes_idprovincia_envio_m1_idx          | 7344 kB
 public.deliverynotes_idprovincia_m1_idx                | 7344 kB
 public.deliverynotes_numerocodseriecodejercicio_m1_idx | 10 MB
(64 rows)

Time: 12,417 ms
  
DELETE FROM   deliverynotes;
DELETE 333694
Time: 408,119 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000;
INSERT 0 50000
Time: 9805,186 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 50000;
INSERT 0 50000
Time: 9712,850 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 100000;
INSERT 0 50000
Time: 9761,828 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 150000;
INSERT 0 50000
Time: 9262,881 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 200000;
INSERT 0 50000
Time: 9786,689 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 250000;
INSERT 0 50000
Time: 11998,232 ms
--VACUUM ANALYZE deliverynotes;
UPDATE deliverynotes SET codserie = '*' WHERE codserie = 'VALUE NOT IN TABLE';
UPDATE 0
Time: 11,156 ms
UPDATE deliverynotes SET codserie = '*4' WHERE codserie = '04';
UPDATE 1
Time: 1,275 ms
UPDATE deliverynotes SET codserie = '*3' WHERE codserie = '03';
UPDATE 2258
Time: 461,848 ms
UPDATE deliverynotes SET codserie = '*7' WHERE codserie = '07';
UPDATE 5260
Time: 1192,677 ms
UPDATE deliverynotes SET codserie = '*2' WHERE codserie = '02';
UPDATE 43583
Time: 9596,318 ms
UPDATE deliverynotes SET codserie = '*1' WHERE codserie = '01';
UPDATE 113615
Time: 24883,813 ms