troubleshooting

-- Basic query debugging with EXPLAIN
EXPLAIN SELECT * FROM users WHERE email = 'test@example.com';

-- Output shows query plan:
-- Seq Scan on users (cost=0.00..25.00 rows=1 width=100)
--   Filter: (email = 'test@example.com'::text)

#!/bin/bash
# Linux system administration commands

# === Process Management ===
ps aux                                # All processes
ps aux | grep nginx                   # Find specific process