system.users See Also system.users Contains a list of user accounts configured at the server. Columns:- name (String ) — User name. id (UUID ) — User ID. storage (Stri...

system.tables system.tables Contains metadata of each table that the server knows about. Detached tables are not shown in system.tables . Temporary tables are visible in the...

system.parts system.parts Contains information about parts of MergeTree tables. Each row describes one data part. Columns: partition (String ) – The partition name. To lea...

system.merges system.merges Contains information about merges and part mutations currently in process for tables in the MergeTree family. Columns: database (String) — The na...

system.licenses system.licenses Сontains licenses of third-party libraries that are located in the contrib directory of ClickHouse sources. Columns: library_name (String ) ...

system.events system.events Contains information about the number of events that have occurred in the system. For example, in the table, you can find how many SELECT queries we...

system.disks system.disks Contains information about disks defined in the server configuration . Columns: name (String ) — Name of a disk in the server configuration. path ...

system.dictionaries system.dictionaries Contains information about external dictionaries . Columns: database (String ) — Name of the database containing the dictionary creat...

File system events Concepts Example File system events Concepts Use Deno.watchFs to watch for file system events. Results may vary between operating systems. Example To p...

system.zookeeper Help wanted! The following content of this documentation page has been machine-translated. But unlike other websites, it is not done on the fly. This translated...