brenogazzola

# Rails + PostgreSQL Performance Audit Playbook

A field-tested method for finding what's actually burning your database CPU, built for a
Rails monolith on managed PostgreSQL (Cloud SQL / RDS / etc.). It assumes no APM — just
`pg_stat_statements`, `pg_stat_activity`, and discipline. It pairs well with an LLM: point
one at this file plus your query results and let it do the attribution; the queries below
are ordered so a human can run them and paste results back.

## The core idea

jsadoski-rockhall

name	Logging Best Practices
description	Use before implementing logs in a medium to large scale production system.

This skill is adpated from "Logging sucks. And here's how to make it better. by Boris Tane.

When helping with logging, observability, or debugging strategies, follow these principles:

Core Philosophy

bensheldon

<% require_relative File.expand_path("git_worktree", __dir__) %>

default: &default
  adapter: postgresql
  encoding: unicode
  pool: 20
  connect_timeout: 5
  checkout_timeout: 5

development:

mabenson00

# Basic key operators to query the JSON objects :

# #> : Get the JSON object at that path (if you need to do something fancy)
# -> : Get the JSON object at that path (if you don't)
# ->> : Get the JSON object at that path as text
# {obj, n} : Get the nth item in that object

# https://www.postgresql.org/docs/9.4/functions-json.html#FUNCTIONS-JSONB-OP-TABLE
# Date 
# date before today

bennylope

#!/usr/bin/env python

import argparse
import os
import subprocess
import sys
import time

# Required so we don't generate tons of logs during restore
disable_logging_sql = "ALTER USER postgres RESET pgaudit.log;"

r00k

Retro Questions

• KPI dashboard review
• Since our last retro, what's gone well?
• How do we feel about our productivity and work/life balance
• How is the product better than last week?
• How is the company better than last week?
• Is there anything we should ask a consultant about?
• How is the office/ops?
• How can we enjoy the journey more?

searls

The 5-minute backpack demo

Here's what I carry in a Tom Bihn Synapse 19 bag when I travel for 1-to-n days. In general, I optimize for low-weight items, with a secondary focus on reducing maintenance. You can peruse a gallery of pictures, too.

Clothing

solarce

Getting more familiar with Go

• Go through the Go tour
• Get your editor setup for Go development fun times
• Read through Graduating with Go
• Read through some of the presentations in Resources for new Go Programmers
• Do the tutorial chapter from The Go Programming Language book
• Read through Effective Go
• Read through the list of common mistakes in Go
• Poke around Go by example
• come up with a project you'd like to spend 2-3 days hacking on and write up what it is and why it's interesting/appealing to you

sax

# interpolated load tables step
find . -type f -print0 | xargs -0 -n1 -P50 bash -c "psql -U <postgres_user> <mydatabase> < \$0"

rantav

Sends Cloudwatch Event notifications to Slack

What is this?

AWS have released a new featue called CloudWatch Events, which lets you configure events fired by cloudwatch and direct them to SNS, Lambda functions, etc. Here's the blog post

Motivational image:

Here's the motivational image: