Odoo Monitoring: What to Track and When to Panic

#!/bin/bash
# odoo-health-check.sh
ODOO_URL="http://localhost:8069/web/health"
DB_NAME="odoo_production"
DISK_THRESHOLD=85
MEM_THRESHOLD=90
# Check Odoo HTTP response
HTTP_CODE=$(curl -s -o /dev/null -w "%{http_code}" "$ODOO_URL" --max-time 10)
if [ "$HTTP_CODE" != "200" ]; then
  echo "CRITICAL: Odoo not responding (HTTP $HTTP_CODE)"
  exit 2
fi
# Check disk usage
DISK_PCT=$(df / | awk 'NR==2 {print $5}' | tr -d '%')
if [ "$DISK_PCT" -gt "$DISK_THRESHOLD" ]; then
  echo "WARNING: Disk usage at ${DISK_PCT}%"
  exit 1
fi
# Check memory usage
MEM_PCT=$(free | awk '/^Mem:/ {printf "%.0f", $3/$2*100}')
if [ "$MEM_PCT" -gt "$MEM_THRESHOLD" ]; then
  echo "WARNING: Memory usage at ${MEM_PCT}%"
  exit 1
fi
# Check PostgreSQL connections
PG_CONNS=$(psql -U odoo -d "$DB_NAME" -t -c \
  "SELECT count(*) FROM pg_stat_activity;")
PG_MAX=$(psql -U odoo -d "$DB_NAME" -t -c \
  "SHOW max_connections;")
PG_PCT=$((PG_CONNS * 100 / PG_MAX))
if [ "$PG_PCT" -gt 85 ]; then
  echo "WARNING: PostgreSQL connections at ${PG_PCT}%"
  exit 1
fi
echo "OK: All checks passed"
exit 0

# Log queries slower than 1 second
log_min_duration_statement = 1000
# Log all lock waits
log_lock_waits = on
deadlock_timeout = 5s
# Track query statistics
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.track = all

-- Top 10 slowest queries by total time
SELECT
  calls,
  round(total_exec_time::numeric, 2) as total_ms,
  round(mean_exec_time::numeric, 2) as avg_ms,
  substr(query, 1, 80) as query_preview
FROM pg_stat_statements
ORDER BY total_exec_time DESC
LIMIT 10;