pgtrace
2024A terminal tool that watches Postgres for slow queries and suggests the index that would fix them. 4.1k stars; used in production at a few hundred companies.
Go · PostgreSQL
$ whoami
Ines Okafor
Staff Software Engineer @ Lisbon, Portugal
I make slow systems fast and confusing ones obvious, mostly in Postgres, Go and TypeScript.
profile.json
{ "name": "Ines Okafor","role": "Staff Software Engineer","location": "Lisbon, Portugal","stack": "Go, TypeScript, PostgreSQL, Kafka","status": "Open to staff and principal roles from January"}
# README.md
About me
I’ve spent eleven years on the unglamorous middle of software: the queue that backs up at 9am, the query that worked fine until the table hit forty million rows, the deploy nobody wants to run on Fridays.
Lately I lead platform work at a payments company, write about database internals, and maintain pgtrace, a small tool that has saved a surprising number of on-call weekends.
$ npm ls --depth=0
Stack
- ├─ Goinstalled
- ├─ TypeScriptinstalled
- ├─ PostgreSQLinstalled
- ├─ Kafkainstalled
- ├─ Kubernetesinstalled
- ├─ Terraforminstalled
- ├─ Reactinstalled
- ├─ Distributed systemsinstalled
- ├─ Observabilityinstalled
- └─ Incident responseinstalled
$ ls projects/
Projects
Ledgerline
2023Rebuilt the cash-position service behind a treasury dashboard. Reports that took 40 seconds now load in under one, on a third of the hardware.
Go · Kafka · React
Transit Live
2021Real-time arrivals for 380 bus stops, built with a team of four in ten weeks and still running on the original architecture.
TypeScript · Redis · MapLibre
$ git log --career
Experience
2022 → Present
Staff Software Engineer @ Northwind Pay
Lead the platform group: payments ledger, event streaming and the internal developer portal. Cut p95 settlement latency from 2.3s to 180ms.
2018 → 2022
Senior Engineer @ Talo
Built the multi-tenant data layer and the on-call practice that took incidents from weekly to quarterly.
2014 → 2018
Software Engineer @ Porto Digital
Public-sector web services, from parking permits to the city’s open-data portal.
# education.md · CHANGELOG
Education & certificates
2009 → 2014
MSc Informatics Engineering
University of Porto
v2024
Indexes you forgot you needed
Talk, PGConf EU
v2023
The boring guide to on-call
Essay, 38k readers
v2024
pgtrace reaches 4,000 stars
Open source
v2022
Speaker, GopherCon Lisbon
Talk
$ ./contact.sh