Squeeze the hell out of the system you have

Re:Squeeze the hell out of the system you have by PeledYuval on Friday August 11, 2023 @04:40PM (#37093728)

What's your recommended way of implementing this in a simple App Server <> Postgres architecture? Is there a good Postgres plugin or do you utilize something on the App side?

[ Parent | on HN ]

Re:Squeeze the hell out of the system you have by sheepz on Friday August 11, 2023 @04:49PM (#37093825)

I've used pganalyze which is a non-free SaaS tool. Gives you a very good overview of where the DB time is spent with index suggestions etc. There are free alternatives, but require more work from you.

[ Parent | on HN ]

Re:Squeeze the hell out of the system you have by clintonb on Friday August 11, 2023 @05:16PM (#37094144)

We use Datadog, which centralizes logs and application traces, allowing us to better pinpoint the exact request/code path making the slow query.

[ Parent | on HN ]