Event driven technique for constructing transaction lock wait history

A machine-storage medium embodying instructions that, when executed by a machine, cause the machine to perform operations comprising:

• receiving a first transaction referencing a resource saved in a network-based data warehouse, the first transaction being blocked due to second transaction accessing the resource;
• transmitting a first telemetry event based on the first transaction being blocked;
• acquiring, by the first transaction, lock ownership of the resource;
• transmitting a second telemetry event based on acquiring lock ownership by the first transaction;
• and
• executing the first transaction on the resource.

A system comprising:

• at least one hardware processor;
• and
• at least one memory storing instructions that, when executed by the at least one hardware processor, cause the at least one hardware processor to perform operations comprising:
• receiving a first transaction referencing a resource saved in a network-based data warehouse, the first transaction being blocked due to second transaction accessing the resource;
• transmitting a first telemetry event based on the first transaction being blocked;
• acquiring, by the first transaction, lock ownership of the resource;
• transmitting a second telemetry event based on acquiring lock ownership by the first transaction;
• and
• executing the first transaction on the resource.