Finding and Fixing Slow Queries with Pg_stat_statements

1 pointsposted 5 hours ago
by jerrypenna

2 Comments

jerrypenna

5 hours ago

I wrote the guide as I've had multiple performance issues after postgres on prem to AWS and oracle to postgres migrations.

I find it easier and more efficient to have the sql ready and a comprehensive performance queries.

One mistake I made was miscalculating the ratio for vacuum threshold and as a result the auto vacuum didn't run.

Any suggestions or corrections, let me know.