Slava Kuznetsov smith3v

## HangOps_ru-170512.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                smith3v
                / HangOps_ru-170512.md
            
            
              Created
              May 12, 2017 04:39
            
              
                HangOps_ru 12.05.17 ZFS, openresty - чаты
              
          
    YouTube chat

HangOps_ruПривет всем.
Sergey Ovsienkoхай
Sergey Ovsienkoначинайте, а то трубы горят
Vyacheslav Kuznetsovеще собираемся

  
## pg_stat_activity
select (now() - query_start), datname, pid, usename, client_addr, client_port, state, CASE WHEN char_length(query) > 244 THEN substring(query, 1, 200) || ' .. ' || substring(query FROM '.{200}$') ELSE query END AS short_query from pg_stat_activity;