OneLinersCommand workbench
Guides
Operational guides

Complete procedures with a way back.

Searchable, versioned procedures with prerequisites, verification, concrete output, and rollback.

Guides
243
Favorites
0
243 launch guides · 2601 reviewed steps
4 of 243 guides

Databases & Data · Observability & Monitoring

Find and fix slow PostgreSQL queries with pg_stat_statements and EXPLAIN

Deploy privacy-aware PostgreSQL 18.4 query statistics, identify normalized high-impact queries, capture safe estimated and actual plans, and validate one reversible fix.
Save to collectionCreate a collection in the sidebar first.
danger300 minadvanced14 stepsPostgreSQL

AI/ML · DevOps & CI/CD · Software Engineering

Optimize LLM cost, latency, caching and context safely

Measure production token economics and user latency, design cacheable prompts and context budgets, and ship only quality-gated optimizations.
Save to collectionCreate a collection in the sidebar first.
caution180 minadvanced12 stepsOpenAI Responses API

Observability & Monitoring · Databases & Data

Enable and analyze the MySQL slow query log safely

Baseline workload, enable bounded slow logging, protect and rotate files, summarize candidates, use EXPLAIN ANALYZE carefully, and prove improvement.
Save to collectionCreate a collection in the sidebar first.
caution75 minadvanced8 stepsMySQL

Observability & Monitoring · Services & Applications

Configure and verify PHP OPcache for production

Measure script inventory, size OPcache deliberately, choose a deployment invalidation strategy, enable observability, and prove cache health.
Save to collectionCreate a collection in the sidebar first.
caution30 minintermediate8 stepsPHP