Help Center/ GaussDB/ Feature Guide(Centralized_8.x)/ Partitioned Table/ Partitioned Table Query Optimization/ Collecting Statistics on Partitioned Tables

Updated on 2024-06-07 GMT+08:00

View PDF

Collecting Statistics on Partitioned Tables

For partitioned tables, you can collect partition-level statistics, which can be queried in the pg_partition and pg_statistic system catalogs and in the pg_stats and pg_ext_stats views. Partition-level statistics apply to the scenario where the scanning range of a partitioned table is pruned to a single partition after static pruning is performed on the partitioned table. Partition-level statistics include the number of pages and tuples, single-column statistics, multi-column statistics, and expression index statistics.

You can collect statistics on partitioned tables in either of the following ways:

Collecting statistics in cascading mode
Collecting statistics on a specified partition

Parent topic: Partitioned Table Query Optimization

Previous topic: Partitioned Indexes

Next topic: Collecting Statistics in Cascading Mode

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.