Resource Management:Overview

Functionalities

• Flexible query conditions

  A traditional query method allows you to query resources based only on fixed rules. However, the advanced search feature allows you to tailor query conditions to your business requirements, which improves the accuracy of query results. For example, you can specify multiple query conditions, which helps narrow the search scope and find the resources that meet the conditions. The advanced search feature is also suitable for complex query scenarios, such as querying associated resources, performing a query based on a combination of multiple conditions, or performing other special queries. The advanced search feature can quickly return accurate query results in these scenarios and help you analyze data in depth.

• Custom query scope

  You can use the advanced search feature to query resources within different scopes. You can query resources within the current account or query resources within multiple members in a resource directory.

• Query templates

  To simplify the query process, Resource Management provides sample query templates. The query templates contain common query statements. You can use a query template to quickly identify the resources that you require. You can also save the query statement that you write as a custom query template, and use the custom query template in your business without the need to repeatedly write query statements. This helps save time and ensures the accuracy and consistency of query results. The advanced search feature can meet your query requirements no matter whether you are a beginner or a user with some experience, and help you quickly and accurately identify the resources that you require. For more information, see Use a sample query template to query resources, Use a custom query template to query resources, and Query templates.

• Visualized charts

  The advanced search feature can be used to present query results in charts. If you want to analyze resources to understand resource distribution and resource proportions, you can present query results for resources in charts. This can help you intuitively view data related to resources. For example, you can view the proportions of different types of resources in pie charts or column charts. Then, you can optimize and adjust resources based on your business requirements. For more information, see Step 3: View the query result.

Query statement

The advanced search feature allows you to execute SQL statements to perform operations such as querying, filtering, and sorting resources. The working principles and operation methods of all operators and functions that are supported by the advanced search feature are based on PostgreSQL. For information about the basic SQL syntax that is supported by the advanced search feature, see Basic SQL syntax.

Table used for queries

The resources table is the core data table used in advanced search. The resources table stores information about resource properties. All queries performed by using the advanced search feature are implemented based on operations such as querying, filtering, and sorting fields in the resources table. For example, you can specify the resource_name field in a query condition to query the resource with this name. You can also specify the resource_type field in a query condition to query a specific type of resource. In addition to the core fields, the properties field in the resources table also stores other properties of a resource, such as the status and billing method. The values of the properties field vary based on the resource type.

The following table describes the fields in the resources table.

Limits

• Limit on the number of data records that can be returned

  By default, a query performed by using the advanced search feature can return a maximum of 1,000 data records.

  If the amount of data on which you want to perform a query is excessively large, you can use the LIMIT clause with the OFFSET keyword specified in an SQL statement to perform a paged query. To ensure the continuity of the query result, you must use an ORDER BY clause in the SQL statement to sort the query result.

• Limit on the query frequency

  You can perform a maximum of three queries within 5 seconds. If you perform more than three queries within 5 seconds, throttling is triggered. The quota for the query frequency is determined by various factors and may be changed.

• Limit on the execution duration of a query

  The maximum execution duration that is allowed for a query is no more than 10 seconds. If no query result is returned within 10 seconds, the system terminates the query and reports an error.

  To ensure that a query result can be returned within 10 seconds, you can use one of the following methods to reduce the complexity of a query:

  • Add a limit condition. For example, if the amount of data on which you want to perform a query is large, you can add an ORDER BY clause to the query statement to sort data based on the resource_type and resource_id fields.

  • Limit the number of data records that can be returned. For example, you can use the LIMIT clause in the query statement to limit the maximum number of data records that can be returned.

  • Enable the query to return the properties field only if necessary.

• Limit on functions that can be used for queries

  For more information, see Supported functions.