Commands
SHOW PARAMETERS
SQL reference
- Overview
- Commands
- Overview
- ALTER CONNECTION
- ALTER DATABASE
- ALTER FUNCTION
- ALTER INDEX
- ALTER MATERIALIZED VIEW
- ALTER SCHEMA
- ALTER SINK
- ALTER SOURCE
- ALTER SUBSCRIPTION
- ALTER SWAP
- ALTER SYSTEM
- ALTER TABLE
- ALTER USER
- ALTER VIEW
- AS CHANGELOG
- BEGIN
- CANCEL JOBS
- COMMENT ON
- COMMIT
- CREATE AGGREGATE
- CREATE CONNECTION
- CREATE DATABASE
- CREATE FUNCTION
- CREATE INDEX
- CREATE MATERIALIZED VIEW
- CREATE SCHEMA
- CREATE SECRET
- CREATE SINK INTO
- CREATE SINK
- CREATE SOURCE
- CREATE TABLE
- CREATE USER
- CREATE VIEW
- DELETE
- DESCRIBE
- DISCARD
- DROP AGGREGATE
- DROP CONNECTION
- DROP DATABASE
- DROP FUNCTION
- DROP INDEX
- DROP MATERIALIZED VIEW
- DROP SCHEMA
- DROP SECRET
- DROP SINK
- DROP SOURCE
- DROP TABLE
- DROP USER
- DROP VIEW
- EXPLAIN
- FLUSH
- GRANT
- INSERT
- RECOVER
- REVOKE
- SELECT
- SET BACKGROUND_DDL
- SET RW_IMPLICIT_FLUSH
- SET TIME ZONE
- SET
- SHOW CLUSTER
- SHOW COLUMNS
- SHOW CONNECTIONS
- SHOW CREATE INDEX
- SHOW CREATE MATERIALIZED VIEW
- SHOW CREATE SINK
- SHOW CREATE SOURCE
- SHOW CREATE TABLE
- SHOW CREATE VIEW
- SHOW CURSORS
- SHOW DATABASES
- SHOW FUNCTIONS
- SHOW INDEXES
- SHOW INTERNAL TABLES
- SHOW JOBS
- SHOW MATERIALIZED VIEWS
- SHOW PARAMETERS
- SHOW PROCESSLIST
- SHOW SCHEMAS
- SHOW SINKS
- SHOW SOURCES
- SHOW SUBSCRIPTION CURSORS
- SHOW TABLES
- SHOW VIEWS
- START TRANSACTION
- UPDATE
- Query syntax
- Data types
- Functions and operators
- Identifiers
- System catalogs
- Psql commands
Commands
SHOW PARAMETERS
You can use the SHOW PARAMETERS
command to view the system parameters, along with their current values.
Examples
Copy
SHOW PARAMETERS;
----RESULT
Name | Value | Mutable
----------------------------------------+----------------+---------
barrier_interval_ms | 1000 | t
checkpoint_frequency | 1 | t
sstable_size_mb | 256 | f
parallel_compact_size_mb | 512 | f
block_size_kb | 64 | f
bloom_false_positive | 0.001 | f
state_store | hummock+memory | f
data_directory | hummock_001 | f
backup_storage_url | memory | t
backup_storage_directory | hummock_001/backup | t
max_concurrent_creating_streaming_jobs | 1 | t
pause_on_next_bootstrap | false | t
enable_tracing | false | t
Was this page helpful?