portnov

explain (analyze, buffers)
SELECT
		pg_get_userbyid(userid) as user,
		pg_database.datname,
		pg_stat_statements.queryid,
		pg_stat_statements.calls as calls_total,
		pg_stat_statements.total_exec_time / 1000.0 as seconds_total,
		pg_stat_statements.rows as rows_total,
		pg_stat_statements.blk_read_time / 1000.0 as block_read_seconds_total,
		pg_stat_statements.blk_write_time / 1000.0 as block_write_seconds_total

Weiyuan-Lane

SELECT
  pg_stat_statements.query as query,
  round(pg_stat_statements.total_exec_time::numeric, 2) AS total_time,
  pg_stat_statements.calls,
  round(pg_stat_statements.mean_exec_time::numeric, 2) AS mean,
  round((100 * pg_stat_statements.total_exec_time /
  sum(pg_stat_statements.total_exec_time::numeric) OVER ())::numeric, 2) AS percentage_cpu,
  round((100 * pg_stat_statements.calls /
  sum(pg_stat_statements.calls::numeric) OVER ())::numeric, 2) AS percentage_calls,
  pg_user.usename as username,

tahoemph

-- table + index sizes
SELECT
    table_name,
    pg_size_pretty(table_size) AS table_size,
    pg_size_pretty(indexes_size) AS indexes_size,
    pg_size_pretty(total_size) AS total_size
FROM (
    SELECT
        table_name,
        pg_table_size(table_name) AS table_size,

jweyrich

psql -h <host> -U <user> -W -d postgres

SELECT * from pg_stat_activity;
SELECT * from pg_stat_database;

# Queries running during >5 minutes
SELECT
  pid,
  datname,
  query,

aanari

sudo yum update
sudo amazon-linux-extras enable postgresql11
sudo yum install postgresql postgresql-devel

ProGM

Arel Cheatsheet on Steroids

A (more) complete cheatsheet for Arel, including NamedFunction functions, raw SQL and window functions.

Tables

posts = Arel::Table.new(:posts)
posts = Post.arel_table # ActiveRecord

Table alias

sukima

# Makefile for PlantUML
# Author: Devin Weaver (@sukima) <suki@tritarget.org>
# GistID: 52eacde54bf7861b19ee66a07b864583
#
# This handles SVGs PNGs and ASCII outputs.
# It handles included files with the .iuml extension: !include foo.iuml
# All diagrams have the .uml extension and reside in the diagrams directory
# All output is saved to the output directory
#
# make svg    - (default) build all diagrams as SVGs

joebew42

Visual Studio Code and Elixir

Here I wanted to share my own configuration of Visual Studio Code that I currently use when programming in Elixir. The section about Tasks and Shortcut is taken from this post: Running Elixir Tests in Visual Studio Code/ElixirLS.

Required extensions

• vscode-elixir

Custom tasks

tuannvm

Kubernetes cheatsheet

• Kubernetes cheatsheet
  • Getting Started
  • Sample yaml
  • Workflow
  • Physical components
    • Master
    • Node
• Everything is an object - persistent entities

brianshumate

If you'd like to experiment with Terraform on macOS locally, a great provider for doing so is the Docker provider. You can get set up in a few simple steps, like so:

1. Install Docker

Install Docker for Mac if you have not already.