Analyzing Data in a Workspace Table

When you analyze data in a table, you collect statistics about the table's contents.

Prerequisites

Procedure

  • Within a table, click Analyze.

Result

The results of the analysis are stored in the system table pg_statistic.

The query planner subsequently uses these statistics to help determine the most efficient execution plans for queries. These statistics, including row count, minimum, and so on, can be viewed from the details section for the table.







Caution: Running Analyze on large tables can significantly slow down queries, and so should be used with caution.
Related tasks