Database and storage

In the App Monitor’s “Database” section, you’ll find comprehensive insights into your app’s data statistics and the tools to perform essential maintenance operations. This section is invaluable for managing your app’s database effectively.

Database information #

At the top of the page, you’ll find essential information about your data:

• Total Database Size: This represents the total storage space used by your database, considered for billing and plans.

• App Storage: The space allocated to your app’s data, including records within your entities, associated indexes, and historical logs.

• System Storage: This portion of the database is dedicated to system-related information such as logs, jobs, indexes, and more.

Entities #

The list of entities provides detailed information on each entity:

• Total Data Size: This indicates the overall space used by records within the entity, including associated indexes.

• Data Size: The space used solely by records within the entity, excluding indexes.

• Entries Count: Displays the total number of records stored in the entity.

• Indexes Size: Represents the space used by indexes associated with the entity.

• Number of Indexes: Indicates the total number of indexes configured for the entity.

• Percentage Relative to Data: This provides insight into how much space the entity occupies compared to the total database size.

By clicking on an entity, you can access more detailed information, including index statuses and two critical operations:

• Refresh Relationships: Use this operation if your relationship fields become outdated. Running this action updates relationship fields across all records within the entity.

• Refresh Calculated Fields: When your calculated fields contain outdated values, use this operation. It updates calculated fields across all records within the entity.

Performance #

The “Performance” section is dedicated to monitoring slow queries. This is crucial if you’re experiencing performance issues in your app. You can identify which operations are consuming more time and make informed decisions about creating indexes or making adjustments to enhance your app’s performance.

Suggested indexes #

To help optimize query performance, this section also provides suggested indexes retrieved from the MongoDB Atlas Performance Advisor. These indexes are based on an analysis of slow queries and are designed to enhance efficiency by reducing the number of scanned documents.

How suggested indexes work #

• It recommends indexes that can improve query performance by optimizing how MongoDB searches for data.
• Suggested indexes are displayed in a structured format, specifying the fields that should be indexed and their order.

Using suggested indexes effectively #

• Evaluate query behavior: Ensure that the suggested indexes align with frequently executed queries to maximize their impact.
• Balance performance and storage: While indexes enhance query speed, excessive indexing can increase storage costs and affect write performance.
• Monitor the impact: After implementing an index, track query execution times to validate improvements and adjust as needed.

Leveraging suggested indexes can significantly improve database performance, making applications more efficient and responsive.

Tools #

Under the “Tools” section, you’ll find maintenance utilities for your database:

• Repair Database: Trigger this option to initiate cleanup tasks that can resolve unusual behaviors in your app. For instance, if you notice discrepancies in record counts within an entity, using this tool might rectify the issue.

Files information #

At the top of the page, you’ll find data on your app’s files:

• Total Files Size: This is the cumulative space occupied by both public and private files.

  • Private Files: These files reside in file fields within your app. Learn more about the “File” field type here.

  • Public Files: These files can be managed within the app builder. To learn more about public files, refer to the Public Files documentation.