[taler-grid5k] 43/189: again without analyze

[gnunet]

This is an automated email from the git hooks/post-receive script.

marco-boss pushed a commit to branch master
in repository grid5k.

commit 8505973091c35edde85a32a1003e83d55105d7da
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Thu Mar 3 17:33:43 2022 +0100

    again without analyze
---
 configs/etc/monitor/postgres-exporter.yaml | 5 +----
 experiment/scripts/database.sh             | 8 ++++----
 2 files changed, 5 insertions(+), 8 deletions(-)

diff --git a/configs/etc/monitor/postgres-exporter.yaml 
b/configs/etc/monitor/postgres-exporter.yaml
index fc98cf8..dc992d1 100644
--- a/configs/etc/monitor/postgres-exporter.yaml
+++ b/configs/etc/monitor/postgres-exporter.yaml
@@ -159,7 +159,7 @@ pg_database:
         description: "Disk space used by the database"
 
 pg_stat_statements:
-  query: "SELECT t2.rolname, t3.datname, substring(query from 1 for 265) as 
query, queryid, calls, total_exec_time / 1000 as total_time_seconds, 
min_exec_time / 1000 as min_time_seconds, max_exec_time / 1000 as 
max_time_seconds, mean_exec_time / 1000 as mean_time_seconds, stddev_exec_time 
/ 1000 as stddev_time_seconds, rows, shared_blks_hit, shared_blks_read, 
shared_blks_dirtied, shared_blks_written, local_blks_hit, local_blks_read, 
local_blks_dirtied, local_blks_written, temp_blks_read, [...]
+  query: "SELECT t2.rolname, t3.datname, substring(query from 1 for 265) as 
query, calls, total_exec_time / 1000 as total_time_seconds, min_exec_time / 
1000 as min_time_seconds, max_exec_time / 1000 as max_time_seconds, 
mean_exec_time / 1000 as mean_time_seconds, stddev_exec_time / 1000 as 
stddev_time_seconds, rows, shared_blks_hit, shared_blks_read, 
shared_blks_dirtied, shared_blks_written, local_blks_hit, local_blks_read, 
local_blks_dirtied, local_blks_written, temp_blks_read, temp_blk [...]
   master: true
   metrics:
     - rolname:
@@ -171,9 +171,6 @@ pg_stat_statements:
     - query:
         usage: "LABEL"
         description: "Query"
-    - queryid:
-        usage: "LABEL"
-        description: "Query ID"
     - calls:
         usage: "COUNTER"
         description: "Number of times executed"
diff --git a/experiment/scripts/database.sh b/experiment/scripts/database.sh
index 0fb70f5..81b47f9 100755
--- a/experiment/scripts/database.sh
+++ b/experiment/scripts/database.sh
@@ -14,7 +14,7 @@ source ~/scripts/helpers.sh
 cd /tmp 
 
 function setup_disks() {
-  if [ -c /dev/disk1 ]; then
+  if [ -b /dev/disk1 ]; then
     echo 'start=2048, type=83' | sfdisk /dev/disk1 || true
     yes | mkfs.ext4 -m 0 /dev/disk1 || true
     mkdir /mnt/disk || true
@@ -82,9 +82,9 @@ function setup_config() {
   # (NOTE: on partitions!)
   # ALTER TABLE known_coins_default
   #  SET (autovacuum_vacuum_scale_factor = 0.0, autovacuum_vacuum_threshold = 
1000);
-  log_autovacuum_min_duration=0
-  autovacuum_vacuum_scale_factor=0
-  autovacuum_vacuum_threshold=1000
+  #log_autovacuum_min_duration=0
+  #autovacuum_vacuum_scale_factor=0
+  #autovacuum_vacuum_threshold=1000
 
   # use 25% of the available memory 
   # (https://www.postgresql.org/docs/13/runtime-config-resource.html)

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.