Skip to content

Observability

Wait Events (PostgreSQL 17+)

Some operations, such as fetching a key from a KMS, may be delayed by external factors. TCE introduces a TCEFetchKey wait event so that administrators can identify when such operations are waiting. This feature is available starting with PostgreSQL 17.

SELECT * FROM pg_stat_activity WHERE wait_event_type = 'Extension'\gx

-[ RECORD 1 ]----+------------------------------
datid            | 41837
datname          | tce
pid              | 282228
leader_pid       | ø
usesysid         | 10
usename          | benoit
application_name | psql
client_addr      | ::1
client_hostname  | ø
client_port      | 60936
backend_start    | 2026-10-28 10:41:46.909735+01
xact_start       | 2026-10-28 10:41:53.46724+01
query_start      | 2026-10-28 10:41:53.46724+01
state_change     | 2026-10-28 10:41:53.467242+01
wait_event_type  | Extension
wait_event       | TCEFetchKey
state            | active
backend_xid      | ø
backend_xmin     | 30437