DEV Community

Qing
Qing

Posted on

MOT JIT Diagnostics

mot_jit_detail
This built-in function is used to query the details about JIT compilation (code generation).

Usage Examples

Image description

Output Description

Image description

mot_jit_profile
This built-in function is used to query the profiling data (performance data) of the query or stored procedure execution.

Usage Examples

Image description

Output Description

Image description

Miscellaneous
Another useful system table to get information about stored procedures and functions is pg_proc.

For example, body of a stored procedure can be queried using the following query:

Image description

Top comments (0)