Skip to main content
The SHOW statement allows you to view configuration parameter values that control various aspects of your Ditto instance’s behavior.

​
Syntax

DQL
SHOW ALL [LIKE pattern | ILIKE pattern [ESCAPE char]]
SHOW parameter_name
SHOW Syntax Diagram

​
SHOW ALL

Display all configuration parameters and their current values:
DQL
SHOW ALL

​
Filtering with LIKE

You can filter the parameters displayed using pattern matching:
DQL
-- Show all parameters containing "query"
SHOW ALL LIKE '%query%'

-- Show all parameters starting with "dql"
SHOW ALL LIKE 'dql%'

-- Case-insensitive pattern matching
SHOW ALL ILIKE 'DQL%'
The pattern supports:
  • % - Matches zero or more characters
  • _ - Matches exactly one character

​
Escape Characters

If you need to match literal % or _ characters in parameter names, use the ESCAPE clause:
DQL
SHOW ALL LIKE 'param\_%' ESCAPE '\'

​
SHOW Specific Parameter

Display the value of a single configuration parameter:
DQL
SHOW dql_strict_mode

​
Common Configuration Parameters

Some frequently used configuration parameters include:
ParameterDescription
dql_strict_modeControls whether strict mode is enabled for type definitions
max_query_timeMaximum execution time for queries
Use SHOW ALL to see the complete list of available configuration parameters and their current values in your Ditto instance.

​
Usage Examples

// Show all parameters
let result = await ditto.store.execute(
  query: "SHOW ALL"
)

// Show specific parameter
let strictMode = await ditto.store.execute(
  query: "SHOW dql_strict_mode"
)

// Show parameters matching pattern
let dqlParams = await ditto.store.execute(
  query: "SHOW ALL LIKE 'dql%'"
)

​
See Also