Use Query Insights to Understand OCI Database with PostgreSQL Performance

You can use query insights to gain valuable information about performance and monitoring for tasks such as capacity planning, forecasting, query tuning, and general database administration.

Query insights is a PostgreSQL feature that provides visibility into database query performance. The feature helps you identify long-running or resource-intensive SQL statements and understand session activity over time. You can use these insights for query tuning, capacity planning, forecasting, and daily database administration.

Query insights provides the following capabilities to help you evaluate and manage PostgreSQL performance:

• Identify performance bottlenecks by finding SQL statements with high resource usage.
• Improve application performance by tuning queries and data models.
• Support capacity planning and scaling decisions using recent activity trends.

For more information, see Understanding OCI Database with PostgreSQL.