Improving Explain Text Readability - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Improving Explain Text Readability

To combine multiple ExplainText doc rows with the same query ID into one easily readable document, perform a SELECT request on the QryLogExplainDoc[V] view.


sel queryid,explaintextdoc from qrylogexplaindocv where queryid=307188741814475132;

The result looks like the following partial output:

 *** Query completed. One row found. 2 columns returned.
 *** Total elapsed time was 1 second.
QueryID  ExplainTextDoc
  307188741814475132    1) First, we lock Test_DB.b12 for read on a reserved rowHash to      prevent global deadlock.    2) Next, we lock Test_DB.b3 for read on a reserved rowHash to      prevent global deadlock.    3) We lock Test_DB.b12 for read, and we lock Test_DB.b3 for      read.    4) We do an all-AMPs RETRIEVE step from Test_DB.b3 by way of an all-rows scan with a condition of ("NOT (Test_DB.b3.c2 IS NULL)") into Spool 2 (all_amps), which is redistributed by the hash code of (Test_DB.b3.c2) to all AMPs.  Then we do a SORT to order      Spool 2 by row hash.  The size of Spool 2 is estimated with low confidence to be 4 rows (68 bytes).  The estimated time for this step is 0.03 seconds.    5) We execute the following steps in parallel.... 

Note: Export the result set to a file. On the monitor, some of the lines may truncate.

The memory allocated for the input is 32 MB. To see the memory setting, use the following:

cufconfig -o | grep MallocLimit

To add more memory, adjust the MallocLimit setting using cufconfig. For more information about cufconfig, see Utilities.