\timing
Timing is on.
\pset pager always
Pager is always used.
DROP TABLE IF EXISTS deliverynotes CASCADE;
psql:testA_prepare_full_btree.sql:1: NOTICE:  table "deliverynotes" does not exist, skipping
DROP TABLE
Time: 0,259 ms
CREATE TEMP TABLE deliverynotes AS (SELECT * FROM albaranescli ORDER BY idalbaran);
SELECT 333694
Time: 559,081 ms
ALTER TABLE deliverynotes SET (fillfactor = 60);
ALTER TABLE
Time: 0,393 ms
ALTER TABLE deliverynotes ADD CONSTRAINT deliverynotes_pkey 
	PRIMARY KEY(idalbaran)  WITH (FILLFACTOR=60);
ALTER TABLE
Time: 925,882 ms
CLUSTER deliverynotes USING 	deliverynotes_pkey;
CLUSTER
Time: 1715,057 ms
CREATE INDEX deliverynotes_codagencia_m1_idx
  ON deliverynotes
  USING btree
  (codagencia );
CREATE INDEX
Time: 680,499 ms
CREATE INDEX deliverynotes_codagenciaup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codagencia::text) );
CREATE INDEX
Time: 832,936 ms
CREATE INDEX deliverynotes_codagente2_m1_idx
  ON deliverynotes
  USING btree
  (codagente2 );
CREATE INDEX
Time: 297,703 ms
CREATE INDEX deliverynotes_codagente2up_m1_idx
  ON deliverynotes
  USING btree
  (upper(codagente2::text) );
CREATE INDEX
Time: 298,479 ms
CREATE INDEX deliverynotes_codagente3_m1_idx
  ON deliverynotes
  USING btree
  (codagente3 );
CREATE INDEX
Time: 204,510 ms
CREATE INDEX deliverynotes_codagente3up_m1_idx
  ON deliverynotes
  USING btree
  (upper(codagente3::text) );
CREATE INDEX
Time: 211,650 ms
CREATE INDEX deliverynotes_codagente_m1_idx
  ON deliverynotes
  USING btree
  (codagente );
CREATE INDEX
Time: 492,391 ms
CREATE INDEX deliverynotes_codagenteup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codagente::text) );
CREATE INDEX
Time: 619,822 ms
CREATE INDEX deliverynotes_codalmacen_m1_idx
  ON deliverynotes
  USING btree
  (codalmacen );
CREATE INDEX
Time: 507,410 ms
CREATE INDEX deliverynotes_codalmacenup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codalmacen::text) );
CREATE INDEX
Time: 632,033 ms
CREATE INDEX deliverynotes_codcentro_m1_idx
  ON deliverynotes
  USING btree
  (codcentro );
CREATE INDEX
Time: 208,131 ms
CREATE INDEX deliverynotes_codcentroup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codcentro::text) );
CREATE INDEX
Time: 216,380 ms
CREATE INDEX deliverynotes_codcliente_m1_idx
  ON deliverynotes
  USING btree
  (codcliente );
CREATE INDEX
Time: 485,892 ms
CREATE INDEX deliverynotes_codclienteup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codcliente::text) );
CREATE INDEX
Time: 628,484 ms
CREATE INDEX deliverynotes_codcondicionentrega_m1_idx
  ON deliverynotes
  USING btree
  (codcondicionentrega );
CREATE INDEX
Time: 413,458 ms
CREATE INDEX deliverynotes_codcondicionentregaup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codcondicionentrega::text) );
CREATE INDEX
Time: 397,060 ms
CREATE INDEX deliverynotes_coddir_cobro_m1_idx
  ON deliverynotes
  USING btree
  (coddir_cobro);
CREATE INDEX
Time: 304,521 ms
CREATE INDEX deliverynotes_coddir_envio_m1_idx
  ON deliverynotes
  USING btree
  (coddir_envio);
CREATE INDEX
Time: 316,099 ms
CREATE INDEX deliverynotes_coddir_m1_idx
  ON deliverynotes
  USING btree
  (coddir);
CREATE INDEX
Time: 288,719 ms
CREATE INDEX deliverynotes_coddivisa_m1_idx
  ON deliverynotes
  USING btree
  (coddivisa );
CREATE INDEX
Time: 637,769 ms
CREATE INDEX deliverynotes_coddivisaup_m1_idx
  ON deliverynotes
  USING btree
  (upper(coddivisa::text) );
CREATE INDEX
Time: 782,542 ms
CREATE INDEX deliverynotes_codejercicio_m1_idx
  ON deliverynotes
  USING btree
  (codejercicio );
CREATE INDEX
Time: 640,637 ms
CREATE INDEX deliverynotes_codejercicioup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codejercicio::text) );
CREATE INDEX
Time: 783,519 ms
CREATE INDEX deliverynotes_codimpuestoportes_m1_idx
  ON deliverynotes
  USING btree
  (codimpuestoportes );
CREATE INDEX
Time: 553,397 ms
CREATE INDEX deliverynotes_codimpuestoportesup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codimpuestoportes::text) );
CREATE INDEX
Time: 684,925 ms
CREATE INDEX deliverynotes_codincoterm_m1_idx
  ON deliverynotes
  USING btree
  (codincoterm );
CREATE INDEX
Time: 585,545 ms
CREATE INDEX deliverynotes_codincotermup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codincoterm::text) );
CREATE INDEX
Time: 747,657 ms
CREATE INDEX deliverynotes_codmodotransporte_m1_idx
  ON deliverynotes
  USING btree
  (codmodotransporte );
CREATE INDEX
Time: 359,766 ms
CREATE INDEX deliverynotes_codmodotransporteup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codmodotransporte::text) );
CREATE INDEX
Time: 394,125 ms
CREATE INDEX deliverynotes_codnaturaleza_m1_idx
  ON deliverynotes
  USING btree
  (codnaturaleza );
CREATE INDEX
Time: 356,063 ms
CREATE INDEX deliverynotes_codnaturalezaup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codnaturaleza::text) );
CREATE INDEX
Time: 399,534 ms
CREATE INDEX deliverynotes_codpacking_m1_idx
  ON deliverynotes
  USING btree
  (codpacking );
CREATE INDEX
Time: 511,441 ms
CREATE INDEX deliverynotes_codpackingup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codpacking::text) );
CREATE INDEX
Time: 553,930 ms
CREATE INDEX deliverynotes_codpago_m1_idx
  ON deliverynotes
  USING btree
  (codpago );
CREATE INDEX
Time: 531,323 ms
CREATE INDEX deliverynotes_codpagoup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codpago::text) );
CREATE INDEX
Time: 690,944 ms
CREATE INDEX deliverynotes_codpais_cobro_m1_idx
  ON deliverynotes
  USING btree
  (codpais_cobro );
CREATE INDEX
Time: 557,192 ms
CREATE INDEX deliverynotes_codpais_cobroup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codpais_cobro::text) );
CREATE INDEX
Time: 677,042 ms
CREATE INDEX deliverynotes_codpais_envio_m1_idx
  ON deliverynotes
  USING btree
  (codpais_envio );
CREATE INDEX
Time: 576,360 ms
CREATE INDEX deliverynotes_codpais_envioup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codpais_envio::text) );
CREATE INDEX
Time: 715,659 ms
CREATE INDEX deliverynotes_codpais_m1_idx
  ON deliverynotes
  USING btree
  (codpais );
CREATE INDEX
Time: 541,132 ms
CREATE INDEX deliverynotes_codpaisup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codpais::text) );
CREATE INDEX
Time: 675,340 ms
CREATE INDEX deliverynotes_codpuerto_m1_idx
  ON deliverynotes
  USING btree
  (codpuerto );
CREATE INDEX
Time: 208,124 ms
CREATE INDEX deliverynotes_codpuertoup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codpuerto::text) );
CREATE INDEX
Time: 214,160 ms
CREATE INDEX deliverynotes_codregimen_m1_idx
  ON deliverynotes
  USING btree
  (codregimen );
CREATE INDEX
Time: 359,536 ms
CREATE INDEX deliverynotes_codregimenup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codregimen::text) );
CREATE INDEX
Time: 400,221 ms
CREATE INDEX deliverynotes_codserie_m1_idx
  ON deliverynotes
  USING btree
  (codserie );
CREATE INDEX
Time: 493,850 ms
CREATE INDEX deliverynotes_codserieup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codserie::text) );
CREATE INDEX
Time: 631,314 ms
CREATE INDEX deliverynotes_codsubcentro_m1_idx
  ON deliverynotes
  USING btree
  (codsubcentro );
CREATE INDEX
Time: 205,429 ms
CREATE INDEX deliverynotes_codsubcentroup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codsubcentro::text) );
CREATE INDEX
Time: 213,844 ms
CREATE INDEX deliverynotes_codtarifa2_m1_idx
  ON deliverynotes
  USING btree
  (codtarifa2 );
CREATE INDEX
Time: 349,594 ms
CREATE INDEX deliverynotes_codtarifa2up_m1_idx
  ON deliverynotes
  USING btree
  (upper(codtarifa2::text) );
CREATE INDEX
Time: 386,811 ms
CREATE INDEX deliverynotes_codtarifa_m1_idx
  ON deliverynotes
  USING btree
  (codtarifa );
CREATE INDEX
Time: 358,295 ms
CREATE INDEX deliverynotes_codtarifaup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codtarifa::text) );
CREATE INDEX
Time: 397,318 ms
CREATE INDEX deliverynotes_codtemporada_m1_idx
  ON deliverynotes
  USING btree
  (codtemporada );
CREATE INDEX
Time: 204,975 ms
CREATE INDEX deliverynotes_codtemporadaup_m1_idx
  ON deliverynotes
  USING btree
  (upper(codtemporada::text) );
CREATE INDEX
Time: 219,309 ms
CREATE INDEX deliverynotes_fecha_idalbaran
  ON deliverynotes
  USING btree
  (fecha, idalbaran);
CREATE INDEX
Time: 357,924 ms
CREATE INDEX deliverynotes_idalbaran_m1_idx
  ON deliverynotes
  USING btree
  (idalbaran);
CREATE INDEX
Time: 207,274 ms
CREATE INDEX deliverynotes_idpedido_m1_idx
  ON deliverynotes
  USING btree
  (idpedido);
CREATE INDEX
Time: 272,304 ms
CREATE INDEX deliverynotes_idprealbaran_m1_idx
  ON deliverynotes
  USING btree
  (idprealbaran);
CREATE INDEX
Time: 202,985 ms
CREATE INDEX deliverynotes_idprovincia_cobro_m1_idx
  ON deliverynotes
  USING btree
  (idprovincia_cobro);
CREATE INDEX
Time: 283,924 ms
CREATE INDEX deliverynotes_idprovincia_envio_m1_idx
  ON deliverynotes
  USING btree
  (idprovincia_envio);
CREATE INDEX
Time: 283,491 ms
CREATE INDEX deliverynotes_idprovincia_m1_idx
  ON deliverynotes
  USING btree
  (idprovincia);
CREATE INDEX
Time: 307,080 ms
CREATE INDEX deliverynotes_numerocodseriecodejercicio_m1_idx
  ON deliverynotes
  USING btree
  (numero , codserie , codejercicio );
CREATE INDEX
Time: 606,342 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   
-----------------------------------------------------------+---------
 pg_temp_3.deliverynotes                                   | 380 MB
 pg_temp_3.deliverynotes_codagencia_m1_idx                 | 7344 kB
 pg_temp_3.deliverynotes_codagenciaup_m1_idx               | 7344 kB
 pg_temp_3.deliverynotes_codagente2_m1_idx                 | 7344 kB
 pg_temp_3.deliverynotes_codagente2up_m1_idx               | 7344 kB
 pg_temp_3.deliverynotes_codagente3_m1_idx                 | 7344 kB
 pg_temp_3.deliverynotes_codagente3up_m1_idx               | 7344 kB
 pg_temp_3.deliverynotes_codagente_m1_idx                  | 7344 kB
 pg_temp_3.deliverynotes_codagenteup_m1_idx                | 7344 kB
 pg_temp_3.deliverynotes_codalmacen_m1_idx                 | 7344 kB
 pg_temp_3.deliverynotes_codalmacenup_m1_idx               | 7344 kB
 pg_temp_3.deliverynotes_codcentro_m1_idx                  | 7344 kB
 pg_temp_3.deliverynotes_codcentroup_m1_idx                | 7344 kB
 pg_temp_3.deliverynotes_codcliente_m1_idx                 | 7344 kB
 pg_temp_3.deliverynotes_codclienteup_m1_idx               | 7344 kB
 pg_temp_3.deliverynotes_codcondicionentrega_m1_idx        | 7344 kB
 pg_temp_3.deliverynotes_codcondicionentregaup_m1_idx      | 7344 kB
 pg_temp_3.deliverynotes_coddir_cobro_m1_idx               | 7344 kB
 pg_temp_3.deliverynotes_coddir_envio_m1_idx               | 7344 kB
 pg_temp_3.deliverynotes_coddir_m1_idx                     | 7344 kB
 pg_temp_3.deliverynotes_coddivisa_m1_idx                  | 7344 kB
 pg_temp_3.deliverynotes_coddivisaup_m1_idx                | 7344 kB
 pg_temp_3.deliverynotes_codejercicio_m1_idx               | 7344 kB
 pg_temp_3.deliverynotes_codejercicioup_m1_idx             | 7344 kB
 pg_temp_3.deliverynotes_codimpuestoportes_m1_idx          | 7344 kB
 pg_temp_3.deliverynotes_codimpuestoportesup_m1_idx        | 7344 kB
 pg_temp_3.deliverynotes_codincoterm_m1_idx                | 7344 kB
 pg_temp_3.deliverynotes_codincotermup_m1_idx              | 7344 kB
 pg_temp_3.deliverynotes_codmodotransporte_m1_idx          | 7344 kB
 pg_temp_3.deliverynotes_codmodotransporteup_m1_idx        | 7344 kB
 pg_temp_3.deliverynotes_codnaturaleza_m1_idx              | 7344 kB
 pg_temp_3.deliverynotes_codnaturalezaup_m1_idx            | 7344 kB
 pg_temp_3.deliverynotes_codpacking_m1_idx                 | 7928 kB
 pg_temp_3.deliverynotes_codpackingup_m1_idx               | 7928 kB
 pg_temp_3.deliverynotes_codpago_m1_idx                    | 7344 kB
 pg_temp_3.deliverynotes_codpagoup_m1_idx                  | 7344 kB
 pg_temp_3.deliverynotes_codpais_cobro_m1_idx              | 7344 kB
 pg_temp_3.deliverynotes_codpais_cobroup_m1_idx            | 7344 kB
 pg_temp_3.deliverynotes_codpais_envio_m1_idx              | 7344 kB
 pg_temp_3.deliverynotes_codpais_envioup_m1_idx            | 7344 kB
 pg_temp_3.deliverynotes_codpais_m1_idx                    | 7344 kB
 pg_temp_3.deliverynotes_codpaisup_m1_idx                  | 7344 kB
 pg_temp_3.deliverynotes_codpuerto_m1_idx                  | 7344 kB
 pg_temp_3.deliverynotes_codpuertoup_m1_idx                | 7344 kB
 pg_temp_3.deliverynotes_codregimen_m1_idx                 | 7344 kB
 pg_temp_3.deliverynotes_codregimenup_m1_idx               | 7344 kB
 pg_temp_3.deliverynotes_codserie_m1_idx                   | 7344 kB
 pg_temp_3.deliverynotes_codserieup_m1_idx                 | 7344 kB
 pg_temp_3.deliverynotes_codsubcentro_m1_idx               | 7344 kB
 pg_temp_3.deliverynotes_codsubcentroup_m1_idx             | 7344 kB
 pg_temp_3.deliverynotes_codtarifa2_m1_idx                 | 7344 kB
 pg_temp_3.deliverynotes_codtarifa2up_m1_idx               | 7344 kB
 pg_temp_3.deliverynotes_codtarifa_m1_idx                  | 7344 kB
 pg_temp_3.deliverynotes_codtarifaup_m1_idx                | 7344 kB
 pg_temp_3.deliverynotes_codtemporada_m1_idx               | 7344 kB
 pg_temp_3.deliverynotes_codtemporadaup_m1_idx             | 7344 kB
 pg_temp_3.deliverynotes_fecha_idalbaran                   | 7344 kB
 pg_temp_3.deliverynotes_idalbaran_m1_idx                  | 7344 kB
 pg_temp_3.deliverynotes_idpedido_m1_idx                   | 7344 kB
 pg_temp_3.deliverynotes_idprealbaran_m1_idx               | 7344 kB
 pg_temp_3.deliverynotes_idprovincia_cobro_m1_idx          | 7344 kB
 pg_temp_3.deliverynotes_idprovincia_envio_m1_idx          | 7344 kB
 pg_temp_3.deliverynotes_idprovincia_m1_idx                | 7344 kB
 pg_temp_3.deliverynotes_numerocodseriecodejercicio_m1_idx | 10 MB
 pg_temp_3.deliverynotes_pkey                              | 11 MB
(65 rows)

Time: 3,246 ms
  
DELETE FROM   deliverynotes;
DELETE 333694
Time: 1215,408 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000;
INSERT 0 50000
Time: 6850,466 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 50000;
INSERT 0 50000
Time: 7106,388 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 100000;
INSERT 0 50000
Time: 7032,721 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 150000;
INSERT 0 50000
Time: 7118,923 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 200000;
INSERT 0 50000
Time: 7641,104 ms
INSERT INTO deliverynotes SELECT * FROM albaranescli ORDER BY idalbaran LIMIT 50000 OFFSET 250000;
INSERT 0 50000
Time: 10490,760 ms
--VACUUM ANALYZE deliverynotes;
UPDATE deliverynotes SET codserie = '*' WHERE codserie = 'VALUE NOT IN TABLE';
UPDATE 0
Time: 1,265 ms
UPDATE deliverynotes SET codserie = '*' WHERE codserie IS NULL;
UPDATE 0
Time: 0,468 ms
UPDATE deliverynotes SET codserie = '*' WHERE codserie = 'VALUE ALSO NOT IN TABLE';
UPDATE 0
Time: 0,432 ms
UPDATE deliverynotes SET codserie = '*4' WHERE codserie = '04';
UPDATE 1
Time: 1,010 ms
UPDATE deliverynotes SET codserie = '*3' WHERE codserie = '03';
UPDATE 2258
Time: 403,827 ms
UPDATE deliverynotes SET codserie = '*7' WHERE codserie = '07';
UPDATE 5260
Time: 974,996 ms
UPDATE deliverynotes SET codserie = '*2' WHERE codserie = '02';
UPDATE 43583
Time: 7106,462 ms
SELECT COUNT(*) FROM deliverynotes WHERE codserie = '01';
 count  
--------
 113615
(1 row)

Time: 602,056 ms
SELECT COUNT(*) FROM deliverynotes WHERE codserie = '999';
 count 
-------
     0
(1 row)

Time: 0,498 ms
SELECT COUNT(*) FROM deliverynotes WHERE codserie IS NULL;
 count 
-------
     0
(1 row)

Time: 0,201 ms