Postgres isn't slow, your storage is: how to find disk waits with pg_stat_io
How to tell if PostgreSQL is waiting on storage with wait events, pg_stat_io and iostat, and what moving to local NVMe costs.
System architecture
Data models, migrations and the decisions that are expensive to reverse.