Chris Wang crwang

Everything I knew to do here, I learned from this pluralsight course:https://app.pluralsight.com/library/courses/postgresql-playbook/table-of-contents and this blog post: http://www.craigkerstiens.com/2012/10/01/understanding-postgres-performance/

I used cg run -e <env> bash and then psql $DATABASE_URL to connect to the DB

I used the postgres query here to find big tables with low rates of using indexes, see “Understanding Index Usage” : http://www.craigkerstiens.com/2012/10/01/understanding-postgres-performance/

googledrivelti=> SELECT
googledrivelti->   relname,
googledrivelti->   100 * idx_scan / (seq_scan + idx_scan) percent_of_times_index_used,

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

MIT License

Copyright (c) [year] [fullname]

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

	resource "random_password" "db_master_pass" {
	length = 40
	special = true
	min_special = 5
	override_special = "!#$%^&*()-_=+[]{}<>:?"
	keepers = {
	pass_version = 1
	}
	}


	# Purpose: reset docker environment
	# Argument (optional): all
	#
	# "docker-reset" will kill and remove all containers (except dinghy-http-proxy),
	# dangling images, and volumes. It won't remove networks.
	#
	# "docker-reset all" will do everything in 'docker-reset' and remove all
	# networks, too.
	#

	# Create all variables used in this Terraform run
	variable "aws_access_key" {}
	variable "aws_access_secret_key" {}
	variable "aws_bucket_name" {}
	variable "aws_region_main" {
	default = "eu-west-1"
	}
	variable "aws_region_replica" {
	default = "eu-central-1"
	}

	# This is a skeleton for testing models including examples of validations, callbacks,
	# scopes, instance & class methods, associations, and more.
	# Pick and choose what you want, as all models don't NEED to be tested at this depth.
	#
	# I'm always eager to hear new tips & suggestions as I'm still new to testing,
	# so if you have any, please share!
	#
	# @kyletcarlson
	#
	# This skeleton also assumes you're using the following gems:

	import android.graphics.Bitmap;
	import android.graphics.Bitmap.Config;
	import android.graphics.BitmapShader;
	import android.graphics.Canvas;
	import android.graphics.Paint;
	import android.graphics.RectF;
	import android.graphics.Shader;

	// enables hardware accelerated rounded corners
	// original idea here : http://www.curious-creature.org/2012/12/11/android-recipe-1-image-with-rounded-corners/

	<div class="wrapper">
	<div class="container">
	<header>

	</header>
	<div id="content">

	</div>
	</div>
	<div class="footer-push"></div>

	<!DOCTYPE html>
	<html>
	<head>
	<script data-main="usage" src="http://requirejs.org/docs/release/1.0.8/comments/require.js"></script>
	</head>
	<body>
	<p>Check your JavaScript console for output!</p>
	</body>
	</head>