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

commit    b96289aecd28a32a03fa50dbed8cbafccc1aba4e
Author:   Bo Lu <lv.patrick@gmail.com>
Commit:   Div Arora <darora@users.noreply.github.com>
Date:     Fri Mar 15 03:41:45 2024 +0000

    fix: remove auth stats collection from postgres_exporter


 .../all-in-one/opt/postgres_exporter/queries.yml   | 24 ----------------------
 1 file changed, 24 deletions(-)

diff --git a/docker/all-in-one/opt/postgres_exporter/queries.yml b/docker/all-in-one/opt/postgres_exporter/queries.yml
index 543268b3..83cfeed4 100644
--- a/docker/all-in-one/opt/postgres_exporter/queries.yml
+++ b/docker/all-in-one/opt/postgres_exporter/queries.yml
@@ -179,30 +179,6 @@ auth_users:
         usage: "GAUGE"
         description: "Number of users in the project db"
 
-auth_stats:
-  master: true
-  cache_seconds: 3600
-  query: |
-    select
-      count(*) filter (
-        where payload ->> 'action' = 'user_invited'
-           or (payload ->> 'action' in ('user_confirmation_requested', 'user_recovery_requested')
-               and payload ->> 'actor_username' like '%@%')
-      ) as total_auth_emails,
-      count(*) filter (
-        where payload ->> 'action' in ('user_confirmation_requested', 'user_recovery_requested')
-          and payload ->> 'actor_username' not like '%@%'
-        ) as total_auth_texts
-    from
-      auth.audit_log_entries
-  metrics:
-    - total_auth_emails:
-        usage: "COUNTER"
-        description: "Total number of auth emails sent"
-    - total_auth_texts:
-        usage: "COUNTER"
-        description: "Total number of auth texts sent"
-
 realtime:
   master: true
   cache_seconds: 60


[parent: 9e1e0bda1e99]