TLDR: My postgre db is unresponsive and i can't redeploy.. all my redeploy attempts fail after 20/30 mins with 0 logs from deployment attempt...

I'm trying to debug the memory spike issue in my postgres db and redeployed my db a couple hours ago with no problem. Just about half an hour ago i tried redeploying the db service but it just keeps failing without providing me any single logs.. I can't even see the logs of the attempted deployment...

Some things i did while i was trying to debug my db memory issue was:
- add pg_stat_statements extension to my db with:

CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

• sshed into the db service on Railway and tried monitoring memory usage, for that i manually installed htop there

• used queries like below to understand the open connections and memory consumtions of queries:

  SELECT 
      pid,
      usename,
      datname,
      state,
      query_start,
      now() - query_start as query_duration,
      query,
      -- Memory usage (requires track_activities = on)
      backend_type,
      wait_event_type,
      wait_event
  FROM pg_stat_activity 
  WHERE state = 'active' 
    AND query NOT LIKE '%pg_stat_activity%'
  ORDER BY query_start;

  I don't know if this was dues to the control panel outage Railway had this morning that resulted in deployments being blocked, or my manual attempts of trying to debug my memory problem.... I still currently cant redeploy my db and the db is not responsive right now, rejecting all the connection requests..