Updated on 2025-05-29 GMT+08:00

GLOBAL_STATEMENT_COMPLEX_HISTORY_TABLE

Displays workload management information about completed jobs executed on each node. Data is dumped from the kernel to this system catalog. If the GUC parameter enable_resource_record is set to on, the system imports records from GLOBAL_STATEMENT_COMPLEX_HISTORY to this system catalog every 3 minutes. You are advised not to enable this function, because it occupies storage space and affects performance.

For details about the columns, see GLOBAL_STATEMENT_COMPLEX_HISTORY.