Recent content on explain, analyze
pg_glimpse pg_glimpse is a TUI Postgres monitoring application. Think of pg_activity, with a slicker UI and a few extra tools. Before I built this tool I was constantly using ad hoc queries to monitor production databases. Now I have something that fits in my terminal-based workflow. It started as a proof of concept I built with Claude Code in a couple of afternoons, and grew from there. It…
“Are there any recent errors in production?” “Let’s triage the unresolved errors.” “Ignore all Stripe errors.” “Investigate error #13 and write a test that reproduces it.” These are all prompts my coding agent understands when I work on projects that use Faultline. A few months ago I wrote my own error tracking Rails engine. It all started when…
Para quem é este texto Conceitos Básicos Como os dados são armazenados em disco Como os índices aceleram o acesso aos dados Custos associados a índices Espaço em disco Operações de escrita Planejador de queries Uso de memória Tipos de índices Btree Usando múltiplos índices Índices compostos Índices parciais Hash BRIN GIN GiST & SP-GiST Conclusão Para quem é este texto Este texto é para…
Who’s this for Basics How data is stored in disk How indexes speedup access to data Costs associated with indexes Disk Space Write operations Query planner Memory usage Types of Indexes Btree Hash BRIN GIN GiST & SP-GiST Conclusion Who’s this for This text is for developers that have an intuitive knowledge of what database indexes are, but don’t necessarily know how they work…
I’m a Backend Engineer with 15+ years of experience designing and managing high-volume backend systems. I’m particularly interested in PostgreSQL optimization, database performance tuning, and building systems that scale. My favorite languages are Ruby, Python, Go, and Rust. Currently working at Paag. Contact GitHub LinkedIn