displayRuntime

This procedure provides debug logging and estimated duration for a particular block of code. It accepts two mandatory timestamp parameters: the start of the whole execution and the start of the particular block. This allows to estimate how much time has passed since both timestamps. Additionally, the procedure returns the current timestamp for use in subsequent calls.

Parameters

Parameter	Description
`startTime`	Start timestamp of the whole process execution; mandatory
`blockStartTime`	Start timestamp of the block; mandatory
`context`	Logging context to be appended to com.datavirtuality.connectors
`procedureName`	Procedure name to identify the full procedure (default: the code)
`text`	Text to identify the small data block (default: the block)

Attributes

Attribute	Type	Description
`currentTime`	timestamp	Current timestamp (moment the procedure started)

Example

SQL

DECLARE timestamp currentTime = ...
...
currentTime = SELECT currentTime FROM UTILS.displayRuntime (
	startTime => startTime,
	blockStartTime => currentTime,
	context => 'api.section.particularItems',
	procedureName => 'getApiSectionParticularItems',
	text => 'Starting data parsing...'
);