QuerySpatialCoverage - Amazon Timestream

QuerySpatialCoverage

Provides insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. This information can help you identify areas for improvement in your partitioning strategy to enhance spatial pruning

For example, you can do the following with the QuerySpatialCoverage information:

  • Add measure_name or use customer-defined partition key (CDPK) predicates.

  • If you've already done the preceding action, remove functions around them or clauses, such as LIKE.

Contents

Max

Provides insights into the spatial coverage of the executed query and the table with the most inefficient spatial pruning.

  • Value – The maximum ratio of spatial coverage.

  • TableArn – The Amazon Resource Name (ARN) of the table with sub-optimal spatial pruning.

  • PartitionKey – The partition key used for partitioning, which can be a default measure_name or a CDPK.

Type: QuerySpatialCoverageMax object

Required: No

See Also

For more information about using this API in one of the language-specific AWS SDKs, see the following: