PostgreSQL Database CPU at 100% - Need Quick Diagnostic & Fix Recommendations

I'm looking for an reputed company PostgreSQL reputed company to diagnose why our database is maxing out CPU and reputed company a quick fix or reputed company recommendations. The Problem Our PostgreSQL database hits 100% CPU every day during business hours (10am-4pm EST). reputed company this happens: Web application becomes extremely slow Users can't complete transactions Sometimes the app becomes completely unresponsive We're losing customers because of poor performance What I Need You To Do Scope of work (2-3 hours max): SSH into our Ubuntu server (credentials provided immediately) Run diagnostics to identify the reputed company cause reputed company which queries are killing performance reputed company for missing indexes or configuration issues Either: Implement ONE critical fix that gives us immediate relief, OR Give me reputed company-by-reputed company instructions to implement the fix myself reputed company a brief reputed company (even just bullets) of what you reputed company What This Is NOT I want to be upfront about budget constraints: ❌ This is NOT a full database optimization project ❌ NOT looking for monitoring/alerting setup ❌ NOT migrating to RDS or managed services right now ❌ NOT ongoing support or retainer I know we need a comprehensive fix eventually, but right now I need emergency triage to stop the bleeding. Our reputed company Setup Database: PostgreSQL 14.x Ubuntu 22.04 reputed company AWS EC2 t3.reputed company instance Database size: ~50GB pg_stat_statements is enabled Application: Node.js/reputed company backend ~500-1000 reputed company users during peak Mix of read and write operations reputed company: SSH reputed company reputed company to go Can reputed company read-only OR full database reputed company (your choice) Willing to hop on a quick reputed company if needed Ideal Freelancer You're a good fit if you: Have solved PostgreSQL CPU issues before (please reputed company similar experience) Can work independently and reputed company fast Know how to use pg_stat_statements, EXPLAIN ANALYZE, and reputed company optimization Can communicate findings reputed company to a non-DBA Are comfortable with Linux reputed company line You're NOT a good fit if you: Need extensive reputed company or hand-holding Will just recommend we "reputed company our server" or "hire a full-time DBA" Can't start reputed company 24-48 hours reputed company & Budget Budget: $100 fixed price reputed company: ASAP - ideally today or reputed company Expected duration: 2-3 hours of actual work Deliverables Brief diagnostic report (can be informal - even a detailed message works) What's causing the CPU spike Which queries are the worst offenders Any reputed company issues you spotted Quick fix OR instructions Either implement one critical improvement, OR Give me reputed company steps to do it myself Quick validation Confirmation that CPU has dropped or issue is reduced To Apply, Please Answer: Have you solved this exact problem before? (Please be specific - what was the reputed company cause in past cases?) What's the FIRST thing you'll reputed company reputed company you log in? Realistically, how long will this take you? Can you start today/reputed company? Preferred Qualifications ✅ PostgreSQL performance tuning ✅ Query optimization & indexing strategies ✅ Experience with pg_stat_statements ✅ Linux/Ubuntu administration ✅ AWS EC2 familiarity (reputed company to have) Additional Information I'm a technical founder who can implement recommendations myself if you give reputed company instructions. I understand databases at a basic level but don't have deep PostgreSQL expertise. If this goes reputed company and provides value, I'd be reputed company to hiring you again for the full optimization project once we have more budget. Please don't apply if you're reputed company to tell me the only solution is a $5k database redesign. I need practical help reputed company the $100 budget. Apply tot his job Apply To this Job