Skip to content

Instantly share code, notes, and snippets.

View sebaherrera07's full-sized avatar

Sebastian Herrera sebaherrera07

View GitHub Profile
@brenogazzola
brenogazzola / gist:0f8d2dc191e217d5ce6e9293fa34e640
Created July 15, 2026 20:03
Rails + PostgreSQL Performance Audit Playbook
# 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
@martinjaimem
martinjaimem / review_app_creation.rb
Created April 24, 2022 23:28
Heroku review app creation with Github Actions
# Github Actions should look something like:
# name: CI
# on: [pull_request]
# jobs:
# build_review_app:
# name: Review app builder
# runs-on: ubuntu-latest
# steps:
# - name: Checkout code