system.dictionaries

    • (String) — Name of the database containing the dictionary created by DDL query. Empty string for other dictionaries.
    • name () — Dictionary name.
    • status () — Dictionary status. Possible values:
      • NOT_LOADED — Dictionary was not loaded because it was not used.
      • LOADED — Dictionary loaded successfully.
      • FAILED — Unable to load the dictionary as a result of an error.
      • LOADING — Dictionary is loading now.
      • LOADED_AND_RELOADING — Dictionary is loaded successfully, and is being reloaded right now (frequent reasons: SYSTEM RELOAD DICTIONARY query, timeout, dictionary config has changed).
    • () — Path to the configuration file that describes the dictionary.
    • type (String) — Type of a dictionary allocation. .
    • key — Key type: Numeric Key () or Сomposite key (String) — form “(type 1, type 2, …, type n)”.
    • attribute.names ((String)) — Array of provided by the dictionary.
    • attribute.types (Array()) — Corresponding array of attribute types that are provided by the dictionary.
    • bytes_allocated () — Amount of RAM allocated for the dictionary.
    • query_count (UInt64) — Number of queries since the dictionary was loaded or since the last successful reboot.
    • hit_rate () — For cache dictionaries, the percentage of uses for which the value was in the cache.
    • (UInt64) — Number of items stored in the dictionary.
    • load_factor () — Percentage filled in the dictionary (for a hashed dictionary, the percentage filled in the hash table).
    • source (String) — Text describing the for the dictionary.
    • lifetime_min (UInt64) — Minimum of the dictionary in memory, after which ClickHouse tries to reload the dictionary (if invalidate_query is set, then only if it has changed). Set in seconds.
    • lifetime_max (UInt64) — Maximum of the dictionary in memory, after which ClickHouse tries to reload the dictionary (if invalidate_query is set, then only if it has changed). Set in seconds.
    • loading_start_time (DateTime) — Start time for loading the dictionary.
    • last_successful_update_time () — End time for loading or updating the dictionary. Helps to monitor some troubles with external sources and investigate causes.
    • (Float32) — Duration of a dictionary loading.