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
from the workspace menu.- 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.