title: How to check clickhouse database server live/active connections
body: <p>I am trying to check clickhous database(server) active connections from console.<br />
  In MYSQL there are many commands Like:</p>
  <pre><code>SHOW STATUS WHERE `variable_name` = 'Threads_connected';
  show status like 'Threads_connected';
  SHOW VARIABLES LIKE &quot;max_connections&quot;;
  </code></pre>
  <p>It will return result like this below format.</p>
  <pre><code>'Threads_connected', '2'
  'max_connections', '151'
  </code></pre>
  <p>As well as we can from mysql workbench server status menu.<br />
  I am checking with below query, but it is not returning any appropriate result.</p>
  <blockquote>
  <p>SELECT * FROM system.metrics WHERE metric LIKE '%Connection'</p>
  </blockquote>
  <pre><code>┌─metric────────────────┬─value─┬
  │ TCPConnection         │     1 │
  │ MySQLConnection       │     0 │
  │ HTTPConnection        │     0 │
  │ InterserverConnection │     0 │
  │ PostgreSQLConnection  │     0 │   
  </code></pre>
  <blockquote>
  <p>SELECT * FROM system.events LIMIT 1</p>
  </blockquote>
  <pre><code>Row 1:
  ──────
  event:       Query
  value:       30
  description: Number of queries....
  </code></pre>
  <blockquote>
  <p>SELECT * FROM system.settings WHERE name LIKE 'conn%' LIMIT 1</p>
  </blockquote>
  <pre><code>Row 1:
  ──────
  name:        connect_timeout
  value:       10
  changed:     0
  description: Connection timeout if there are no replicas.
  min:         ᴺᵁᴸᴸ
  max:         ᴺᵁᴸᴸ
  readonly:    0
  type:        Seconds
  </code></pre>
  <p>Please share some idea how can check open session or connection.</p>
  <p>Thank you,<br />
  Bimal.</p>