Performance Baseline

Establish performance baselines on the new cluster:

Database Performance:

# Check query performance
kubectl exec -it <postgresql-pod> -- psql -U gv -c 'EXPLAIN ANALYZE SELECT * FROM <critical-table> LIMIT 100;'

# Monitor connection counts
kubectl exec -it <postgresql-pod> -- psql -U gv -c 'SELECT count(*) FROM pg_stat_activity;'

Elasticsearch Performance:

# Check search latency
curl -u elastic:<password> http://localhost:9200/<index>/_search?size=100

# Monitor cluster stats
curl -u elastic:<password> http://localhost:9200/_cluster/stats?pretty

Resource Utilization:

# Check CPU and memory usage
kubectl top nodes
kubectl top pods --all-namespaces

# Monitor disk usage
kubectl exec -it <pod> -- df -h