text: #include <DataTypes/DataTypeString.h>
  #include <DataTypes/DataTypesNumber.h>
  #include <DataTypes/DataTypeArray.h>
  #include <Interpreters/ProcessList.h>
  #include <Storages/System/StorageSystemProcesses.h>
  #include <Interpreters/Context.h>
  #include <Core/Settings.h>
  #include <Interpreters/ProfileEventsExt.h>
  #include <Common/typeid_cast.h>
  #include <Columns/ColumnsNumber.h>
  #include <Columns/ColumnArray.h>
  
  
  namespace DB
  {
  
  NamesAndTypesList StorageSystemProcesses::getNamesAndTypes()
  {
      return {
          {"is_initial_query", std::make_shared<DataTypeUInt8>()},
  
          {"user", std::make_shared<DataTypeString>()},
          {"query_id", std::make_shared<DataTypeString>()},
          {"address", std::make_shared<DataTypeString>()},
          {"port", std::make_shared<DataTypeUInt16>()},
  
          {"initial_user", std::make_shared<DataTypeString>()},
          {"initial_query_id", std::make_shared<DataTypeString>()},
          {"initial_address", std::make_shared<DataTypeString>()},
          {"initial_port", std::make_shared<DataTypeUInt16>()},
  
          {"interface", std::make_shared<DataTypeUInt8>()},
  
          {"os_user", std::make_shared<DataTypeString>()},
          {"client_hostname", std::make_shared<DataTypeString>()},
          {"client_name", std::make_shared<DataTypeString>()},
          {"client_version_major", std::make_shared<DataTypeUInt64>()},
          {"client_version_minor", std::make_shared<DataTypeUInt64>()},
          {"client_version_patch", std::make_shared<DataTypeUInt64>()},
          {"client_revision", std::make_shared<DataTypeUInt64>()},
  
          {"http_method", std::make_shared<DataTypeUInt8>()},
          {"http_user_agent", std::make_shared<DataTypeString>()},
  
          {"quota_key", std::make_shared<DataTypeString>()},
  
          {"elapsed", std::make_shared<DataTypeFloat64>()},
          {"is_cancelled", std::make_shared<DataTypeUInt8>()},
          {"read_rows", std::make_shared<DataTypeUInt64>()},
          {"read_bytes", std::make_shared<DataTypeUInt64>()},
          {"total_rows_approx", std::make_shared<DataTypeUInt64>()},
          {"written_rows", std::make_shared<DataTypeUInt64>()},
          {"written_bytes", std::make_shared<DataTypeUInt64>()},
          {"memory_usage", std::make_shared<DataTypeInt64>()},
          {"peak_memory_usage", std::make_shared<DataTypeInt64>()},
          {"query", std::make_shared<DataTypeString>()},
  
          { "thread_numbers", std::make_shared<DataTypeArray>(std::make_shared<DataTypeUInt32>()) },
          { "ProfileEvents.Names", std::make_shared<DataTypeArray>(std::make_shared<DataTypeString>()) },
          { "ProfileEvents.Values", std::make_shared<DataTypeArray>(std::make_shared<DataTypeUInt64>()) },
          { "Settings.Names", std::make_shared<DataTypeArray>(std::make_shared<DataTypeString>()) },
          { "Settings.Values", std::make_shared<DataTypeArray>(std::make_shared<DataTypeString>()) },
      };
  }
  
  
  void StorageSystemProcesses::fillData(MutableColumns & res_columns, const Context & context, const SelectQueryInfo &) const
  {
      ProcessList::Info info = context.getProcessList().getInfo(true, true, true);
  
      for (const auto & process : info)
      {
          size_t i = 0;
          res_columns[i++]->insert(process.client_info.query_kind == ClientInfo::QueryKind::INITIAL_QUERY);
          res_columns[i++]->insert(process.client_info.current_user);
          res_columns[i++]->insert(process.client_info.current_query_id);
          res_columns[i++]->insert(process.client_info.current_address.host().toString());
          res_columns[i++]->insert(process.client_info.current_address.port());
          res_columns[i++]->insert(process.client_info.initial_user);
          res_columns[i++]->insert(process.client_info.initial_query_id);
          res_columns[i++]->insert(process.client_info.initial_address.host().toString());
          res_columns[i++]->insert(process.client_info.initial_address.port());
          res_columns[i++]->insert(UInt64(process.client_info.interface));
          res_columns[i++]->insert(process.client_info.os_user);
          res_columns[i++]->insert(process.client_info.client_hostname);
          res_columns[i++]->insert(process.client_info.client_name);
          res_columns[i++]->insert(process.client_info.client_version_major);
          res_columns[i++]->insert(process.client_info.client_version_minor);
          res_columns[i++]->insert(process.client_info.client_version_patch);
          res_columns[i++]->insert(process.client_info.client_revision);
          res_columns[i++]->insert(UInt64(process.client_info.http_method));
          res_columns[i++]->insert(process.client_info.http_user_agent);
          res_columns[i++]->insert(process.client_info.quota_key);
          res_columns[i++]->insert(process.elapsed_seconds);
          res_columns[i++]->insert(process.is_cancelled);
          res_columns[i++]->insert(process.read_rows);
          res_columns[i++]->insert(process.read_bytes);
          res_columns[i++]->insert(process.total_rows);
          res_columns[i++]->insert(process.written_rows);
          res_columns[i++]->insert(process.written_bytes);
          res_columns[i++]->insert(process.memory_usage);
          res_columns[i++]->insert(process.peak_memory_usage);
          res_columns[i++]->insert(process.query);
  
          {
              Array threads_array;
              threads_array.reserve(process.thread_numbers.size());
              for (const UInt32 thread_number : process.thread_numbers)
                  threads_array.emplace_back(thread_number);
              res_columns[i++]->insert(threads_array);
          }
  
          {
              IColumn * column_profile_events_names = res_columns[i++].get();
              IColumn * column_profile_events_values = res_columns[i++].get();
  
              if (process.profile_counters)
                  ProfileEvents::dumpToArrayColumns(*process.profile_counters, column_profile_events_names, column_profile_events_values, true);
              else
              {
                  column_profile_events_names->insertDefault();
                  column_profile_events_values->insertDefault();
              }
          }
  
          {
              IColumn * column_settings_names = res_columns[i++].get();
              IColumn * column_settings_values = res_columns[i++].get();
  
              if (process.query_settings)
                  process.query_settings->dumpToArrayColumns(column_settings_names, column_settings_values, true);
              else
              {
                  column_settings_names->insertDefault();
                  column_settings_values->insertDefault();
              }
          }
      }
  }
  
  }
  