The SET MAXCPU statement restricts the maximum CPU usage per query on the database. The MAXCPU value must be less than or equal to the session's value for query_cpu_limit. If no query_cpu_limit is set, there is no limit on CPU usage per query. To set query_cpu_limit for a user, use the GRANT statement.

When MAXCPU is set, it remains in effect until another SET MAXCPU or SET NOMAXCPU statement is issued or the session terminates.

For more information, see query_cpu_limit in the description of Grant (privilege) (see page GRANT (privilege)).