Example: Logging Requests by Summary Completion Time in Subsecond Intervals - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
Summarize requests for all users into the following subsecond intervals set in DBQLSummaryTbl:
  • 0 - 0.05 seconds
  • 0.05 - 0.50 seconds
  • 0.50 - 1.00 seconds
  •  > 1 second

Quantify requests in the subsecond range:

BEGIN QUERY LOGGING LIMIT SUMMARY=5,50,100 ELAPSEDTIME ON ALL;