theblazehen

## Postgres kill all idle in transaction.md

      
        
          
            
              
              1 file
            
          
          
            
              
              1 fork
            
          
            
              
                
                0 comments
              
            
          
            
              
              24 stars
            
          
        
        
          
              
          
          
            
                danishabdullah
                / Postgres kill all idle in transaction.md
            
            
              Last active
              February 27, 2024 19:55
            
              
                Postgres kill all idle in transaction
              
          
        
      
        
  
      
    given a database named db:
SELECT pg_terminate_backend(pid) 
FROM pg_stat_activity 
WHERE datname='db'
  AND state = 'idle in transaction'