Exemple #1
0
 public object Any(ResetConnections request)
 {
     return(Db.Column <bool>(
                @"SELECT pg_terminate_backend(pid)
             FROM pg_stat_activity
             WHERE pid <> pg_backend_pid()
               AND state = 'idle'
               AND state_change < current_timestamp - INTERVAL '5' MINUTE"));
 }
Exemple #2
0
 public object Any(ResetConnections request)
 {
     return Db.Column<bool>(
         @"SELECT pg_terminate_backend(pid)
             FROM pg_stat_activity
             WHERE pid <> pg_backend_pid()
               AND state = 'idle'
               AND state_change < current_timestamp - INTERVAL '5' MINUTE");
 }