Help Center/ GaussDB/ Feature Guide(Distributed_V2.0-8.x)/ Partitioned Table/ Partitioned Table Query Optimization/ Collecting Statistics on Partitioned Tables

Updated on 2025-05-29 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 scan range is reduced to a single partition after static pruning is performed on a partitioned table. The following statistics can be collected: number of pages and tuples at the partition level, single-column statistics, multi-column statistics, and expression index statistics.

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

Collect statistics in cascading mode.
Collect 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.