Finding and Fixing Slow Queries with Pg_stat_statements

[jerrypenna]

https://pginsights.dev/guides/pg-stat-statements-slow-queries

[jerrypenna]

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.