Cheat Sheets

DBA Cheat Sheet Library

Production-verified queries for daily DBA operations, incident triage, and performance profiling.

Featured Reference Posters

Printable & Offline DBA Cheat Sheets

PDF (A4) · PNG (1920px) · HTML

postgresql

PostgreSQL 16 / 17

psql CLI Quick Reference

Complete PostgreSQL Command Line Reference

Connection Strings & URI Syntax

Complete Meta Commands (\dt+, \dn+, \du)

Output & Formatting Options

View Guide

mysql

MySQL 8.0 / 8.4

InnoDB Tuning Reference

MySQL InnoDB Storage Engine Performance Tuning Guide

Buffer Pool Sizing Formula (70-80%)

Redo Log & O_DIRECT Configuration

Production my.cnf Ready Template

View Guide

postgresql

PostgreSQL 15 / 16 / 17

PostgreSQL Security Hardening

End-to-End Database Hardening Guide for Production Systems

SCRAM-SHA-256 & Secure pg_hba.conf

Least Privilege & public Schema Lockdown

TLS/SSL verify-full Configuration

View Guide

postgresql

PostgreSQL 14 / 15 / 16 / 17

PostgreSQL Backup & Recovery Reference

PostgreSQL Backup, PITR & Disaster Recovery Guide

pg_dump & pg_dumpall Optimal Flags

WAL Archiving & Non-Blocking Physical Backups

Point-in-Time Recovery (PITR) Walkthrough

View Guide

mysql

MySQL 8.0 / 8.4

MySQL Backup & Recovery Reference

MySQL Backup, Binary Log PITR & CLONE Guide

mysqldump --single-transaction & Fast Restore

MySQL Shell Parallel dumpInstance / loadDump

Minute-Accurate PITR with Binary Logs

View Guide

postgresql

PostgreSQL 14 / 15 / 16 / 17

PostgreSQL Indexing & Query Optimization

PostgreSQL Index Types, EXPLAIN ANALYZE & Query Tuning

B-Tree, GIN, GiST & BRIN Index Selection Guide

EXPLAIN (ANALYZE, BUFFERS) Execution Plan Reading

Index Skip Scan, Partial & Expression Indexes

View Guide

mysql

Oracle 1Z0-908 · MySQL 8.0

MySQL OCP 8.0 DBA Exam Topic Map

Comprehensive Study & Quick Reference Guide for Oracle 1Z0-908

All 7 Exam Domains & High-Risk Exam Pitfalls

InnoDB Cluster, Group Replication & Router

Crucial MySQL 8.0 Default Values to Memorize

View Guide

Kategori:

postgresqltroubleshoot Safe / Read-Only

BASIC

Find Long-Running Active Queries & Locks

Lists active queries running longer than 5 minutes, along with client IP, state, and wait event details.

#pg_stat_activity#long queries#troubleshooting

postgresqltroubleshoot Dikkat / Caution

BASIC

Cancel or Terminate a Blocking Backend Query

First attempts graceful query cancellation; if unresponsive, forcefully terminates the backend PID.

#kill query#pg_terminate_backend#emergency

postgresqlperformance Safe / Read-Only

INTERMEDIATE

Identify Top Bloated Tables & Dead Tuple Counts

Identifies tables with high dead tuple ratios requiring manual vacuuming or autovacuum tuning.

#autovacuum#bloat#dead tuples#maintenance

postgresqlperformance Safe / Read-Only

INTERMEDIATE

Find Unused Indexes Wasting Storage and Write I/O

Finds non-primary indexes with zero scans since server restart that degrade INSERT/UPDATE speeds.

#indexes#unused index#optimization

postgresqladmin Safe / Read-Only

BASIC

List Database and Top Table Disk Footprints

Calculates human-readable disk sizes for databases and top 10 individual tables including indexes.

#disk size#storage#admin