Skip to content

pgcrypto

Cryptographic function usage patterns:

Table of Contents

pgexporter_pgcrypto_function_usage_by_category_function_count

The total count of available pgcrypto functions, grouped by their functional category (e.g., encryption, digest).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database being monitored.
function_categoryThe category of the pgcrypto function.

pgexporter_pgcrypto_user_crypto_function_usage_calls

The number of times a specific user-defined function that utilizes pgcrypto functions has been called, based on pg_stat_user_functions.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database being monitored.
schemanameThe schema of the function.
funcnameThe name of the function.

pgexporter_pgcrypto_user_crypto_function_usage_total_time

Total execution time for cryptographic function calls in milliseconds.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseDatabase containing the function.
funcnameName of the cryptographic function.

pgexporter_pgcrypto_user_crypto_function_usage_self_time

Self time (excluding called functions) for cryptographic function execution in milliseconds.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseDatabase containing the function.
funcnameName of the cryptographic function.

pgexporter_pgcrypto_user_crypto_function_usage_avg_time_per_call

Average time per call for cryptographic functions in milliseconds.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseDatabase containing the function.
funcnameName of the cryptographic function.

Note: To see metrics from user_crypto_function_usage, you need to enable function tracking:

sql
ALTER SYSTEM SET track_functions = 'all';
SELECT pg_reload_conf();
ALTER SYSTEM SET track_functions = 'all';
SELECT pg_reload_conf();