Performance Statistics | Teradata FastLoad - 17.10 - Performance Statistics - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)

Teradata FastLoad displays:

1) At the end of the Acquisition Phase

Acquisition Phase statistics:
Elapsed time: 00:07:43 (hh:mm:ss)
CPU time:     94.89 Second(s)
MB/sec:       41.19
MB/cpusec:    200.99

The abbreviation "MB/sec"'s longhand is megabytes (Total data FastLoad sends) per elapsed second.

The abbreviation "MB/cpusec"'s longhand is megabytes( Total data FastLoad sends) per cpu second.

2) At the end of the application phase:

Application Phase statistics:
Elapsed time: 00:02:43 (hh:mm:ss)

These performance statistics could be varied on different platforms.

An example of statistics output:

FastLoad displays at the end of Acquisition:

**** 11:53:09 Acquisition Phase statistics:
              Elapsed time: 00:00:13 (in hh:mm:ss)
              CPU time:     1.69 Seconds
              MB/sec:       4.25
              MB/cpusec:    32.68

FastLoad displays at the end of Application Phase:

**** 11:53:13 Application Phase statistics:
              Elapsed time: 00:00:04 (in hh:mm:ss)