Using the pie chart
The pie chart, like the data table, provides a method of navigating SQL activity. You can use the pie chart for navigating data independently of the data table.
You can set the pie chart as the main navigation component (using the Application Menu > View preferences option) and when this is done, the pie chart has its own pagination system and can perform drill downs between tables.
Pie chart actions and components
- Pie slices
- Each slice in the pie chart corresponds to a row in the data table.
- Order of pie slices
- The order of pie slices mirrors the order of the rows in the data table. The first row in the data table corresponds to the pie slice located at the three-o'clock position of the pie chart, and subsequent rows correspond to subsequent pie slices in a counter-clockwise manner.
- Hovering over a pie slice
- When you hover over a pie slice, a popup is displayed that shows the value of the first column in the corresponding row in the data table. The popup also displays the value of the selected pie chart variable (which corresponds to a column in the data table). Additionally, when you hover over a pie slice in the pie chart, the corresponding row in the data table is selected and the details panel is updated.
- Size of a pie slice
- The size of a pie slice reflects the proportion of the pie chart
variable (data table column) for a selected row, with respect to the
total of pie chart variable for all rows in the data table. Note: If there are more rows in the data table than there are slices in the pie chart, the column values for the remaining rows are totaled into a Remainder slice. When that happens, the number of slices in the pie chart will be one greater than the number in the Max Slices Count chooser.
- Clicking on a pie slice
- When you click a pie slice, a popup menu displays the available drill down commands. You can use these drill down commands to perform the same navigation across tables as is available in the data table.
- Drilling down using the pie chart
- In this usage example, you might drill down by a plan and view the data by CPU. If you then see a pie slice that is of interest, for example, a pie slice that is much larger than the other slices. If you want to then see which users were using that plan, you can left click on the relevant slice, and choose a drill down option (in this case, User) from the menu that pops up. Then the resulting pie represents the contribution of each user of that plan to the total plan CPU consumption.
- Viewing the SQL text for different pie slices
- In this usage example, you view the pie chart for an SQL drill down, and then want to see what SQL text corresponds to specific slices. To do this, you first open the details panel, and click on the SQL text tab. Then you hover the mouse over the pie slice of interest and the full SQL text corresponding to that slice appears in the SQL text tab.