\timing
Timing is on.
\pset pager always
Pager is always used.
DROP TABLE IF EXISTS deliverynotes CASCADE;
psql:testA_prepare_full_hash.sql:1: NOTICE:  table "deliverynotes" does not exist, skipping
DROP TABLE
Time: 0,439 ms
CREATE TABLE deliverynotes AS (SELECT * FROM albaranescli);
SELECT 333694
Time: 2397,988 ms
ALTER TABLE deliverynotes SET (fillfactor = 60);
ALTER TABLE
Time: 0,457 ms
ALTER TABLE deliverynotes ADD CONSTRAINT deliverynotes_pkey 
	PRIMARY KEY(idalbaran)  WITH (FILLFACTOR=60);
ALTER TABLE
Time: 286,828 ms
CREATE INDEX deliverynotes_codagencia_m1_idx
  ON deliverynotes
  USING hash
  (codagencia );
psql:testA_prepare_full_hash.sql:14: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 5493,989 ms
CREATE INDEX deliverynotes_codagenciaup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codagencia::text) );
psql:testA_prepare_full_hash.sql:19: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 5153,511 ms
CREATE INDEX deliverynotes_codagente2_m1_idx
  ON deliverynotes
  USING hash
  (codagente2 );
psql:testA_prepare_full_hash.sql:24: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 120,368 ms
CREATE INDEX deliverynotes_codagente2up_m1_idx
  ON deliverynotes
  USING hash
  (upper(codagente2::text) );
psql:testA_prepare_full_hash.sql:29: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 121,525 ms
CREATE INDEX deliverynotes_codagente3_m1_idx
  ON deliverynotes
  USING hash
  (codagente3 );
psql:testA_prepare_full_hash.sql:34: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 110,318 ms
CREATE INDEX deliverynotes_codagente3up_m1_idx
  ON deliverynotes
  USING hash
  (upper(codagente3::text) );
psql:testA_prepare_full_hash.sql:39: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 113,314 ms
CREATE INDEX deliverynotes_codagente_m1_idx
  ON deliverynotes
  USING hash
  (codagente );
psql:testA_prepare_full_hash.sql:44: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 1703,009 ms
CREATE INDEX deliverynotes_codagenteup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codagente::text) );
psql:testA_prepare_full_hash.sql:49: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 1841,278 ms
CREATE INDEX deliverynotes_codalmacen_m1_idx
  ON deliverynotes
  USING hash
  (codalmacen );
psql:testA_prepare_full_hash.sql:54: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 26513,901 ms
CREATE INDEX deliverynotes_codalmacenup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codalmacen::text) );
psql:testA_prepare_full_hash.sql:59: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 26551,112 ms
CREATE INDEX deliverynotes_codcentro_m1_idx
  ON deliverynotes
  USING hash
  (codcentro );
psql:testA_prepare_full_hash.sql:64: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 104,839 ms
CREATE INDEX deliverynotes_codcentroup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codcentro::text) );
psql:testA_prepare_full_hash.sql:69: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 113,155 ms
CREATE INDEX deliverynotes_codcliente_m1_idx
  ON deliverynotes
  USING hash
  (codcliente );
psql:testA_prepare_full_hash.sql:74: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 424,544 ms
CREATE INDEX deliverynotes_codclienteup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codcliente::text) );
psql:testA_prepare_full_hash.sql:79: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 609,373 ms
CREATE INDEX deliverynotes_codcondicionentrega_m1_idx
  ON deliverynotes
  USING hash
  (codcondicionentrega );
psql:testA_prepare_full_hash.sql:84: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 1244,554 ms
CREATE INDEX deliverynotes_codcondicionentregaup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codcondicionentrega::text) );
psql:testA_prepare_full_hash.sql:89: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 1291,055 ms
CREATE INDEX deliverynotes_coddir_cobro_m1_idx
  ON deliverynotes
  USING hash
  (coddir_cobro);
psql:testA_prepare_full_hash.sql:94: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 209,936 ms
CREATE INDEX deliverynotes_coddir_envio_m1_idx
  ON deliverynotes
  USING hash
  (coddir_envio);
psql:testA_prepare_full_hash.sql:99: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 233,209 ms
CREATE INDEX deliverynotes_coddir_m1_idx
  ON deliverynotes
  USING hash
  (coddir);
psql:testA_prepare_full_hash.sql:104: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 218,384 ms
CREATE INDEX deliverynotes_coddivisa_m1_idx
  ON deliverynotes
  USING hash
  (coddivisa );
psql:testA_prepare_full_hash.sql:109: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 27176,841 ms
CREATE INDEX deliverynotes_coddivisaup_m1_idx
  ON deliverynotes
  USING hash
  (upper(coddivisa::text) );
psql:testA_prepare_full_hash.sql:114: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 26571,434 ms
CREATE INDEX deliverynotes_codejercicio_m1_idx
  ON deliverynotes
  USING hash
  (codejercicio );
psql:testA_prepare_full_hash.sql:119: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 6061,186 ms
CREATE INDEX deliverynotes_codejercicioup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codejercicio::text) );
psql:testA_prepare_full_hash.sql:128: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 6313,385 ms
CREATE INDEX deliverynotes_codimpuestoportes_m1_idx
  ON deliverynotes
  USING hash
  (codimpuestoportes );
psql:testA_prepare_full_hash.sql:137: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 15946,097 ms
CREATE INDEX deliverynotes_codimpuestoportesup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codimpuestoportes::text) );
psql:testA_prepare_full_hash.sql:146: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 14694,843 ms
CREATE INDEX deliverynotes_codincoterm_m1_idx
  ON deliverynotes
  USING hash
  (codincoterm );
psql:testA_prepare_full_hash.sql:155: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 28766,727 ms
CREATE INDEX deliverynotes_codincotermup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codincoterm::text) );
psql:testA_prepare_full_hash.sql:164: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 20671,843 ms
CREATE INDEX deliverynotes_codmodotransporte_m1_idx
  ON deliverynotes
  USING hash
  (codmodotransporte );
psql:testA_prepare_full_hash.sql:173: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 1150,600 ms
CREATE INDEX deliverynotes_codmodotransporteup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codmodotransporte::text) );
psql:testA_prepare_full_hash.sql:182: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 1223,117 ms
CREATE INDEX deliverynotes_codnaturaleza_m1_idx
  ON deliverynotes
  USING hash
  (codnaturaleza );
psql:testA_prepare_full_hash.sql:191: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 1320,027 ms
CREATE INDEX deliverynotes_codnaturalezaup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codnaturaleza::text) );
psql:testA_prepare_full_hash.sql:200: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 1289,292 ms
CREATE INDEX deliverynotes_codpacking_m1_idx
  ON deliverynotes
  USING hash
  (codpacking );
psql:testA_prepare_full_hash.sql:209: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 216,403 ms
CREATE INDEX deliverynotes_codpackingup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codpacking::text) );
psql:testA_prepare_full_hash.sql:218: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 270,093 ms
CREATE INDEX deliverynotes_codpago_m1_idx
  ON deliverynotes
  USING hash
  (codpago );
psql:testA_prepare_full_hash.sql:227: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 3162,579 ms
CREATE INDEX deliverynotes_codpagoup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codpago::text) );
psql:testA_prepare_full_hash.sql:236: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 3389,680 ms
CREATE INDEX deliverynotes_codpais_cobro_m1_idx
  ON deliverynotes
  USING hash
  (codpais_cobro );
psql:testA_prepare_full_hash.sql:245: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 18024,466 ms
CREATE INDEX deliverynotes_codpais_cobroup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codpais_cobro::text) );
psql:testA_prepare_full_hash.sql:254: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 20802,489 ms
CREATE INDEX deliverynotes_codpais_envio_m1_idx
  ON deliverynotes
  USING hash
  (codpais_envio );
psql:testA_prepare_full_hash.sql:263: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 20310,725 ms
CREATE INDEX deliverynotes_codpais_envioup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codpais_envio::text) );
psql:testA_prepare_full_hash.sql:272: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 19555,458 ms
CREATE INDEX deliverynotes_codpais_m1_idx
  ON deliverynotes
  USING hash
  (codpais );
psql:testA_prepare_full_hash.sql:281: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 18464,918 ms
CREATE INDEX deliverynotes_codpaisup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codpais::text) );
psql:testA_prepare_full_hash.sql:290: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 18752,407 ms
CREATE INDEX deliverynotes_codpuerto_m1_idx
  ON deliverynotes
  USING hash
  (codpuerto );
psql:testA_prepare_full_hash.sql:299: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 102,428 ms
CREATE INDEX deliverynotes_codpuertoup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codpuerto::text) );
psql:testA_prepare_full_hash.sql:308: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 107,179 ms
CREATE INDEX deliverynotes_codregimen_m1_idx
  ON deliverynotes
  USING hash
  (codregimen );
psql:testA_prepare_full_hash.sql:317: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 1204,392 ms
CREATE INDEX deliverynotes_codregimenup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codregimen::text) );
psql:testA_prepare_full_hash.sql:326: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 1236,950 ms
CREATE INDEX deliverynotes_codserie_m1_idx
  ON deliverynotes
  USING hash
  (codserie );
psql:testA_prepare_full_hash.sql:335: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 8478,570 ms
CREATE INDEX deliverynotes_codserieup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codserie::text) );
psql:testA_prepare_full_hash.sql:344: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 7953,012 ms
CREATE INDEX deliverynotes_codsubcentro_m1_idx
  ON deliverynotes
  USING hash
  (codsubcentro );
psql:testA_prepare_full_hash.sql:353: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 102,854 ms
CREATE INDEX deliverynotes_codsubcentroup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codsubcentro::text) );
psql:testA_prepare_full_hash.sql:362: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 123,518 ms
CREATE INDEX deliverynotes_codtarifa2_m1_idx
  ON deliverynotes
  USING hash
  (codtarifa2 );
psql:testA_prepare_full_hash.sql:371: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 434,853 ms
CREATE INDEX deliverynotes_codtarifa2up_m1_idx
  ON deliverynotes
  USING hash
  (upper(codtarifa2::text) );
psql:testA_prepare_full_hash.sql:380: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 477,286 ms
CREATE INDEX deliverynotes_codtarifa_m1_idx
  ON deliverynotes
  USING hash
  (codtarifa );
psql:testA_prepare_full_hash.sql:389: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 313,339 ms
CREATE INDEX deliverynotes_codtarifaup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codtarifa::text) );
psql:testA_prepare_full_hash.sql:398: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 366,565 ms
CREATE INDEX deliverynotes_codtemporada_m1_idx
  ON deliverynotes
  USING hash
  (codtemporada );
psql:testA_prepare_full_hash.sql:407: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 109,940 ms
CREATE INDEX deliverynotes_codtemporadaup_m1_idx
  ON deliverynotes
  USING hash
  (upper(codtemporada::text) );
psql:testA_prepare_full_hash.sql:416: WARNING:  hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
Time: 118,194 ms
CREATE INDEX deliverynotes_fecha_idalbaran
  ON deliverynotes
  USING hash
  (fecha, idalbaran);
psql:testA_prepare_full_hash.sql:425: WARNING:  hash indexes are not WAL-logged and their use is discouraged
psql:testA_prepare_full_hash.sql:425: ERROR:  access method "hash" does not support multicolumn indexes
Time: 0,248 ms