What tools or systems have you used for error tracking, server resource control, and heavy SQL query analysis in your projects?

To track errors in Python projects, tools like Sentry or Rollbar are often used. They automatically collect and group exceptions, and also send notifications about critical errors.

For server resource monitoring, system monitoring tools such as Prometheus with Grafana for visualization, or built-in OS tools (top, htop, vmstat) are used. Specialized Application Performance Monitoring (APM) tools like New Relic or Datadog can also be employed.

For analyzing heavy SQL queries, profilers and database logging tools are typically used. In PostgreSQL, for example, auto_explain logs slow queries, and EXPLAIN ANALYZE is used for detailed execution plan analysis. MySQL has a slow query log. In Python projects, ORM query logging or external tools like pgAdmin or MySQL Workbench can be additionally used.