supabase-postgres.git / summary / log / commit / refs

commit    71630fdfd08870f538233b9f31b9fad9835be9c3
Author:   Beng Eu <beng@bengeu.com>
Date:     Tue Jul 02 23:44:00 2024 +0000

    fix: exclude `pgbouncer`, `supabase_admin` and `supabase_storage_admin` queries from user queries
    
    Previous filters will be cleaned up after this change is validated in
    production.


 common.vars.pkr.hcl                                 | 2 +-
 docker/all-in-one/opt/postgres_exporter/queries.yml | 4 ++--
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/common.vars.pkr.hcl b/common.vars.pkr.hcl
index a21072ab..3d50a2c5 100644
--- a/common.vars.pkr.hcl
+++ b/common.vars.pkr.hcl
@@ -1 +1 @@
-postgres-version = "15.1.1.72"
+postgres-version = "15.1.1.73"
diff --git a/docker/all-in-one/opt/postgres_exporter/queries.yml b/docker/all-in-one/opt/postgres_exporter/queries.yml
index d932c977..45b9058e 100644
--- a/docker/all-in-one/opt/postgres_exporter/queries.yml
+++ b/docker/all-in-one/opt/postgres_exporter/queries.yml
@@ -285,7 +285,7 @@ supabase_usage_metrics:
       and query not like 'DELETE FROM net.http_request_queue%'
       and query not like '%source: project usage%'
       and query not like 'select name, setting from pg_settings where name in ($1, $2)%'
-      and userid <> (select oid from pg_roles where rolname = 'authenticator')
+      and userid not in (select oid from pg_roles where rolname in ('authenticator', 'pgbouncer', 'supabase_admin', 'supabase_storage_admin'))
   metrics:
     - user_queries_total:
         usage: "COUNTER"
@@ -312,7 +312,7 @@ pg_status:
 # specific to read replicas
 # for primary databases, all columns will always return a value of 0
 # ---
-# for checking replication lag (physical_replica_lag_second)
+# for checking replication lag (physical_replication_lag_seconds)
 # we firstly check if the replica is  connected to its primary
 # and if last WAL received is equivalent to last WAL replayed
 # if so return 0


[parent: 241f542b7e94]