Are there limits or quotas in PocketQuery?

To avoid abuse and guarantee PocketQuery always being available for everyone we are required to put limits on some of the resources you can use in PocketQuery. Practically, you should never run into these limits, but in case you do, please contact us so we can evaluate your situation. All limits are subject to change at any point.

Some limits depend on the PocketQuery version installed on your site: version 13 introduced a new query execution service with noticeably higher time limits. You can check your version in Confluence under Settings → Manage apps. If your site is still on an earlier version, ask your Confluence administrator to update PocketQuery there.

Datasources

Resource / Field	Before version 13	Version 13 and later
Maximum number allowed	100	100
Name	200 characters	200 characters
Description	2,000 characters	2,000 characters
Base URL & Test URL	2048 characters	2048 characters
Other fields (username, password, header name, header value, …)	255 characters	255 characters
Number of custom headers	10	10
Number of custom parameters	10	10

Queries

Resource / Field	Before version 13	Version 13 and later
Maximum number allowed	1,000	1,000
Execution Time (Including processing, i.e. Template & Converter)	25 seconds	60 seconds
SQL/JDBC query timeout	30 seconds	60 seconds
Name	200 characters	200 characters
Description	2,000 characters	2,000 characters
Statement / REST URL	20,000 characters	20,000 characters
Number of parameters	10	10
Parameter name	50 characters	50 characters
Maximum result size (all query types)	350 KB (gzipped)	350 KB (gzipped)
Maximum rows (JDBC / SQL only)	2,000 rows	2,000 rows
Nested Queries (via `$PQ.executeQuery` or `$PQ.renderPocketQueryMacro`)	5 per Query execution	5 per Query execution
Nested Query depth (via `$PQ.executeQuery` or `$PQ.renderPocketQueryMacro`)	1 (a nested Query cannot execute another nested Query)	1 (a nested Query cannot execute another nested Query)

Converters

Resource / Field	Before version 13	Version 13 and later
Maximum number allowed	1,000	1,000
Execution Time	5 seconds	15 seconds
Maximum number of instructions per execution	1,000,000	1,000,000
Name	200 characters	200 characters
Description	2,000 characters	2,000 characters
Content (JavaScript code)	20,000 characters	20,000 characters

Templates

Resource / Field	Before version 13	Version 13 and later
Maximum number allowed	1,000	1,000
Execution Time	10 seconds	20 seconds
Name	200 characters	200 characters
Description	2,000 characters	2,000 characters
Content (Velocity code)	20,000 characters	20,000 characters
Nested Templates (via `$PQ.template` or `$PQ.templateByName`)	15 per Query execution	15 per Query execution