docs/content/product/administration/monitoring/pre-aggregations.mdx
The Pre-Aggregations page in Cube Cloud allows you to inspect all pre-aggregations in your deployment at a glance. You can see which pre-aggregations are accelerating queries, if they are being refreshed, along with the last 24 hours of build history.
<InfoBox>Available on all plans.
</InfoBox> <Screenshot src="https://ucarecdn.com/eb10de99-4ff6-4a9f-abd5-736971497583/" />You can switch between pre-aggregations and build history by switching between the <Btn>Pre-Aggregations</Btn> and <Btn>Build History</Btn> tabs.
The <Btn>Pre-Aggregations</Btn> tab shows a list of all configured pre-aggregations for the deployment, and is useful for quickly checking details such as when the last build occurred, how long the build took to complete, the total size of the pre-aggregated data, and how many partitions the data is split across. To see more information about a specific pre-aggregation, click on it.
The <Btn>Partitions</Btn> tab shows all partitions (as specified by
partitionGranularity) of the
pre-aggregation. In the example below, the pre-aggregation has a single
partition:
Pre-aggregations with multiple partitions show a list of all partitions, which is helpful for checking pre-aggregation partition build times and sizes:
<Screenshot src="https://ucarecdn.com/84c2989b-cbd1-469c-aca6-127fc97f074b/" />Ideally partitions should be of a similar size and build time. If a partition is taking significantly longer to build than others, it may be worth investigating why.
If the pre-aggregation requires rebuilding (usually due to the underlying data changing in a significant way), clicking <Btn>Build All</Btn> rebuilds all partitions of the pre-aggregation:
<Screenshot highlight="inset(41% 1% 54% 91% round 10px)" src="https://ucarecdn.com/d65d5910-3561-4101-9317-2c9f8366694e/" />
You can also choose to rebuild specific partitions by selecting them and then clicking the <Btn>Build Selected</Btn> button:
<Screenshot highlight="inset(52% 88% 0% 7% round 10px)" src="https://ucarecdn.com/99c72537-51d4-44ce-8df1-ea1a9cc3feaf/" />
The <Btn>Definition</Btn> tab shows how the pre-aggregation is defined in the data model without having to switch to the <Btn>Data Model</Btn> page:
<Screenshot src="https://ucarecdn.com/4e8f203a-bd6b-4316-86ff-b742ccbc78a4/" />To see a sample of the data contained in the pre-aggregation, click the <Btn>Preview</Btn> tab:
<Screenshot src="https://ucarecdn.com/7f5059bb-3bc9-492e-9c69-3b614f3feca5/" />This can be used to verify that the data within the pre-aggregation is being built correctly.
The <Btn>Used By</Btn> tab shows recent queries that used this pre-aggregation for acceleration:
<Screenshot src="https://ucarecdn.com/1dcef348-af33-434a-9ef7-7a4c5f30c26c/" />This is especially useful for checking that the pre-aggregation is being used as expected by queries sent to the deployment.
Indexes significantly improve the performance of configured pre-aggregations. The <Btn>Indexes</Btn> tab displays any configured indexes for this pre-aggregation:
<Screenshot src="https://ucarecdn.com/f7e306e2-4245-46b4-8785-3e7fc1be518e/" />The <Btn>Build History</Btn> tab shows the last 24 hours of build history for all pre-aggregations in the deployment. From here, you can see if a pre-aggregation build succeeded (or failed), how the build was triggered, when the build started, and how long it took to complete.
<Screenshot src="https://ucarecdn.com/9a9f88fb-9977-4aed-a0a8-52494d1d8e6b/" />To see more information about a specific build, click on it:
<Screenshot src="https://ucarecdn.com/2f2d4366-35a6-42be-aac6-f554d824f8d3/" />