Analyzing PostgreSQL Database Workloads: Read-Heavy vs Write-Heavy Patterns and Optimization Strategies

A query to find out if Postgres is read heavy or write heavy and tips for optimizing Postgres for both read and write workloads.