[taler-grid5k] 51/73: add auto explain - not tested yet

[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 28618d07a81d3d51e0d76675947fb57e05950974
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Tue Dec 7 11:59:26 2021 +0100

    add auto explain - not tested yet
---
 experiment/TODO                | 1 +
 experiment/scripts/database.sh | 4 ++++
 2 files changed, 5 insertions(+)

diff --git a/experiment/TODO b/experiment/TODO
index 6a03a84..95c06e3 100644
--- a/experiment/TODO
+++ b/experiment/TODO
@@ -3,3 +3,4 @@
 - lsblk -d -o name,rota - dahu ssd
 * fix wallet stop
 * try huge_pages 
https://www.postgresql.org/docs/13/runtime-config-resource.html
+  https://www.postgresql.org/docs/13/kernel-resources.html
diff --git a/experiment/scripts/database.sh b/experiment/scripts/database.sh
index 8f85622..180a406 100755
--- a/experiment/scripts/database.sh
+++ b/experiment/scripts/database.sh
@@ -23,6 +23,10 @@ function setup_config() {
   syslog_ident='taler-database'
   log_min_duration_statement=500
   shared_preload_libraries='pg_stat_statements,auto_explain'
+  auto_explain.log_min_duration='300ms'
+  auto_explain.log_analyze=true
+  auto_explain.log_buffers=true
+  auto_explain.log_wal=true
   
   # 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.