Skip to content

Instantly share code, notes, and snippets.

View vitalca's full-sized avatar

vitalca

3 followers · 2 following
View GitHub Profile
@reytech-dev
reytech-dev / Fix.md
Last active March 20, 2024 10:19
ZONE_CONFLICT: 'docker0' already bound to a zone
  1. Check if docker zone exists in firewall-cmd
$ firewall-cmd --get-active-zones
  1. If "docker" zone is available, change interface to docker0 (not persisted)
$ sudo firewall-cmd --zone=docker --change-interface=docker0
  1. If "docker" zone is available, change interface to docker0 (persisted, thanks rbjorklin)



  


  




    


          
    

      

        
        

          

              @anvk
          

          

            
                anvk
                / psql_useful_stat_queries.sql
            
            

              Last active
              June 1, 2025 16:17
            

              
                List of some useful Stat Queries for PSQL
              
          

        

      

        

  

    
    


        



  


  

        

          
          --- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md
        

        

          
          --- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192
        

        

          
          

        

        

          
          -- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB.
        

        

          
          

        

        

          
          ------------
        

        

          
          -- Basics --
        

        

          
          ------------
        

        

          
          

        

        

          
          -- Get indexes of tables