Evgeny evkuzin

## iterm2-solarized.md

      
              2 files
            
          
              1628 forks
            
          
              493 comments
            
          
              8810 stars
            
          
                kevin-smets
                / iterm2-solarized.md
            
            
              Last active
              July 4, 2024 23:40
            
              
                iTerm2 + Oh My Zsh + Solarized color scheme + Source Code Pro Powerline + Font Awesome + [Powerlevel10k] - (macOS)
              
          
    Default


Powerlevel10k


## howto.md

      
              1 file
            
          
              2 forks
            
          
              0 comments
            
          
              5 stars
            
          
                NikolayS
                / howto.md
            
            
              Last active
              January 29, 2023 20:25
            
              
                log_min_duration_statement = 0 and I/O impact
              
          
    How to get an estimate of the impact of writing Postgres logs with log_min_duration_statement = 0:


Do select pg_stat_statements_reset(); and wait N seconds (where N >> 60 – say 1-24 hours, covering typical busy hours). Remember when it was, and write down somewhere – this timestamp will be needed!


Check if select count(*) from pg_stat_statements is lower than pg_stat_statements.max. If it's equal to it, then raise pg_stat_statements.max and restart with the step 1.


Get the estimate:


\set TS_PGSS_RESET 'XXXX-XX-XX XX:XX:XX';