Post-hoc Performance Analyst

The Post-hoc Performance Analyst (PPA) is a tool for probing 1010data query performance after the queries of interest have been executed in a session.

The PPA takes advantage of the timing information stored along with the cached state of queries. The analysis is post-hoc because it is meant to be invoked after the queries of interest have been executed in a session, for example, from TRS, MLW, or a QuickApp. It allows you to browse and search cached queries and explore detailed breakdowns of where the time went when executing those queries, and to examine how your session is distributing table data over subprocesses.

The Post-hoc Performance Analyst is accessed by selecting Tools > Post-hoc Performance Analyst from the workspace menu.

Figure: Post-hoc Performance Analyst

Finished queries
Click here to view finished queries for which data was fetched.
MDB state cache
Click here to browse the cache in which MDB stores completed queries.
Temporary table cache
Click here to browse the cache in which the MDB stores temporary in-memory tables, such as worksheets in links.
Physical tables
Click here to view information about a specific physical table.
Microtiming is enabled
Select this to display detailed timing information.