Fine-grained query profiling for database systems

A system comprising:

• a memory;
• and
• a processing device, operatively coupled to the memory, to:
• receive a request to analyze a query associated with a dataset;
• analyze the query to generate a representation indicating a plurality of commands within the query;
• generate, based on the representation, a plurality of profile points to analyze a performance of the plurality of commands;
• generate, based on the representation, a transformed query comprising the plurality of commands and the plurality of profile points;
• and
• perform, during an execution of the transformed query, a plurality of measurements on the plurality of commands based on the plurality of profile points to generate a performance report comprising the plurality of measurements,
• wherein the execution of the transformed query comprises executing the transformed query in a profiling mode that suppresses query result data that would otherwise be returned to a client device in response to execution of the transformed query and, during execution, performs event-level measurements at each profile point that correspond to individual commands of the transformed query.

A non-transitory computer-readable medium storing instructions that, when executed by a processing device, cause the processing device to:

• receive a request to analyze a query associated with a dataset;
• analyze the query to generate a representation indicating a plurality of commands within the query;
• generate, by the processing device based on the representation, a plurality of profile points to analyze a performance of the plurality of commands;
• generate, based on the representation, a transformed query comprising the plurality of commands and the plurality of profile points;
• and
• perform, during an execution of the transformed query, a plurality of measurements on the plurality of commands based on the plurality of profile points to generate a performance report comprising the plurality of measurements,
• wherein the execution of the transformed query comprises executing the transformed query in a profiling mode that suppresses query result data that would otherwise be returned to a client device in response to execution of the transformed query and, during execution, performs event-level measurements at each profile point that correspond to individual commands of the transformed query.