Skip to content
ClickHouse Docs

use_partition_* session settings

Autogenerated from ClickHouse system tables

These settings are available in system.settings and are autogenerated from the ClickHouse snapshot.

use_partition_minmax_for_primary_key_pruning

Use partition minmax index bounds to prune more granules during primary key analysis for MergeTree tables, when a primary key column is also an input column of the partition key.

For example, in a MergeTree table with ORDER BY (id, event_time) and PARTITION BY toYYYYMM(event_time), ClickHouse will use the partition minmax index on event_time during primary key index analysis to make more informed granule-pruning decisions.

Possible values:

  • 0 — Disabled.
  • 1 — Enabled.

use_partition_pruning

Use partition key to prune partitions during query execution for MergeTree tables.

Possible values:

  • 0 — Disabled.
  • 1 — Enabled.