Richard Donkin rdonkin

## README.md

      
              4 files
            
          
              4 forks
            
          
              0 comments
            
          
              11 stars
            
          
                jgreat
                / README.md
            
            
              Last active
              August 28, 2023 19:07
            
              
                Rancher 2.0 Terraform AWS example.
              
          
    Set up a 3 node HA rancher cluster.
This will create and prep nodes for RKE. This uses the default vpc and subnets.
We create:

SSH Key Pair
Security Groups
3 Instances
ELB for 80/443 points to the 3 instances.


## psql_useful_stat_queries.sql
--- 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
	--- 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