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
2 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

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