| [2022-11-19T18:22:26,903][INFO ][o.e.e.NodeEnvironment ] [l33MNvf] using [1] data paths, mounts [[/usr/share/elasticsearch/data (/dev/nvme0n1p2)]], net usable_space [296.5gb], net total_space [456.8gb], types [ext4] | |
| [2022-11-19T18:22:26,905][INFO ][o.e.e.NodeEnvironment ] [l33MNvf] heap size [512mb], compressed ordinary object pointers [true] | |
| [2022-11-19T18:22:26,906][INFO ][o.e.n.Node ] [l33MNvf] node name derived from node ID [l33MNvfHTrmvQz_De-8vjw]; set [node.name] to override | |
| [2022-11-19T18:22:26,906][INFO ][o.e.n.Node ] [l33MNvf] version[6.8.23], pid[1], build[default/docker/4f67856/2022-01-06T21:30:50.087716Z], OS[Linux/6.0.9-arch1-1/amd64], JVM[AdoptOpenJDK/OpenJDK 64-Bit Server VM/15.0.1/15.0.1+9] | |
| [2022-11-19T18:22:26,907][INFO ][o.e.n.Node ] [l33MNvf] JVM arguments [-Xms1g, -Xmx1g, -XX:+UseG1GC, -XX:G1ReservePercent=25, -XX:InitiatingHeapOccupancyPercent=30, -Des.networkaddress.cache.ttl=60, -Des.networkaddress.cache.negative.ttl=10, -XX:+AlwaysPreTouc |
| from bs4 import BeautifulSoup | |
| import requests | |
| import csv | |
| import json | |
| import os.path | |
| # This file contains the hymnary.org identifiers that we are | |
| # interested in retrieving their data. | |
| file = 'input.txt' |
Realizar cada consulta al servidor puede tomar tiempo y dificultar la experimentación. Si tenemos en cuenta que escribiremos 100 consultas, perderíamos más de 1 minuto.
Como podemos ver abajo, realizar una consulta simple toma casi un segundo.
/usr/bin/time -f '%E' sh -c "PGPASSWORD=<<tu-contrasena>> psql -h <<tu-host>> -p <<tu-puerto>> -U <<tu-usuario>> -d <<tu-base-de-datos>> -c '\dt proyecto.*;' >/dev/null"0:00.90