The Teradata Viewpoint system is configured to collect longer-running queries when SQL and Explain collection is enabled. Set the threshold lower to include shorter running queries, which may increase performance overhead.
The explain plan progress for all queries is updated at the collection rate of the Sessions collector. If you want to fetch the latest explain plan progress for a particular query more frequently than that rate, you can do so in the Query Monitor or Query Groups portlets. You can enable this feature per role by granting the Get Explain from DB permission for one or both of these portlets in Roles Manager.
- From the Systems list, click the name of the system you want to update.
- From the Setup list, click Data Collectors.
- Click the Sessions data collector.
- Select the Enable SQL and Explain check box.
Under SQL and Explain Thresholds, set one or more thresholds:
Setting SQL and Explain thresholds too low might impact your system performance.
- Elapsed seconds
- Total CPU seconds
- Click Apply.