From a783ac33976d1efa428eecf1b1cec4a16dd5742e Mon Sep 17 00:00:00 2001 From: Stan Hu Date: Tue, 16 Nov 2021 13:34:33 -0800 Subject: demo: Activate PostgreSQL slow logs This commit will cause PostgreSQL to log any database statements taking longer than 500 ms. This is useful to flag any slow queries running in Praefect. --- _support/terraform/terraform/main.tf | 5 +++++ 1 file changed, 5 insertions(+) (limited to '_support') diff --git a/_support/terraform/terraform/main.tf b/_support/terraform/terraform/main.tf index 92c38127b..283214279 100644 --- a/_support/terraform/terraform/main.tf +++ b/_support/terraform/terraform/main.tf @@ -47,6 +47,11 @@ resource "google_sql_database_instance" "praefect_sql" { settings { tier = "db-f1-micro" + database_flags { + name = "log_min_duration_statement" + value = "500" + } + ip_configuration{ ipv4_enabled = true -- cgit v1.2.3