When a query is slow, you can now check the table structure and database settings behind it without leaving Atatus. Database monitoring for PostgreSQL and MySQL now collects schema details, such as tables, columns, keys and indexes, along with each database's configuration settings.
Turn it on in the Atatus Infrastructure Agent's database configuration. The agent can discover tables on its own, and you can leave out settings you don't need with ignore patterns.
What you can do
- Table structure: See tables, columns, primary and foreign keys, and indexes for each database.
- Configuration settings: Review settings such as buffer sizes, connection limits and timeouts.
- Context for slow queries: Look up a database's schema and settings while you investigate its slow queries and explain plans.
- Automatic discovery: The agent finds tables on its own, and you choose which settings to skip.