enable_query_trace (boolean) ​

This parameter enables full query statistics to be recorded for queries executed. Full statistics contain data from each node and each thread. Setting this parameter to on will add extra information to EXPLAIN (ANALYZE) queries. Performance will be substantially degraded by enabling this option globally; we recommend just using a session at a time or when necessary for diagnosing performance issues.

Example:

-- Turn on tracing for all future queries (use RESET to disable)
SET enable_query_trace TO ON;

-- Enable tracing for future and all running queries of a current session
ALTER SESSION <session_id> SET enable_query_trace TO ON;

See also EXPLAIN.