PostgreSQL integration
Connect PostgreSQL so Annie can query application data, slow queries and database health read-only, and correlate them with your infrastructure graph.
Availability
- Available in beta.
Capabilities
- Discover schemas, tables and indexes
- Run EXPLAIN and find slow queries with pg_stat_statements
- Check connections, locks, replication and table bloat
- Connect multiple databases, each with its own read-only credentials
- Strictly read-only: queries run in read-only transactions
Connect and verify
- Check the intended project's existing integration before adding a connection.
- Verify that the resources and time window needed for the task are covered. Connection status alone does not establish that the evidence is available.
Use cases
- Check the application data behind a customer report during an incident
- Tie a slow-query spike to the deploy or infrastructure change that caused it
- Get index recommendations backed by real query plans