def get_status(): status = {} info = redis_connection.info() status['redis_used_memory'] = info['used_memory_human'] status['version'] = __version__ status['queries_count'] = models.Query.select().count() status['query_results_count'] = models.QueryResult.select().count() status['unused_query_results_count'] = models.QueryResult.unused().count() status['dashboards_count'] = models.Dashboard.select().count() status['widgets_count'] = models.Widget.select().count() status['workers'] = [] manager_status = redis_connection.hgetall('redash:status') status['manager'] = manager_status status['manager']['outdated_queries_count'] = len(models.Query.outdated_queries()) queues = {} for ds in models.DataSource.select(): for queue in (ds.queue_name, ds.scheduled_queue_name): queues.setdefault(queue, set()) queues[queue].add(ds.name) status['manager']['queues'] = {} for queue, sources in queues.iteritems(): status['manager']['queues'][queue] = { 'data_sources': ', '.join(sources), 'size': redis_connection.llen(queue) } return status
def get_status(): status = {} info = redis_connection.info() status['redis_used_memory'] = info['used_memory_human'] status['version'] = __version__ status['queries_count'] = models.Query.select().count() status['query_results_count'] = models.QueryResult.select().count() status['unused_query_results_count'] = models.QueryResult.unused().count() status['dashboards_count'] = models.Dashboard.select().count() status['widgets_count'] = models.Widget.select().count() status['workers'] = [] manager_status = redis_connection.hgetall('redash:status') status['manager'] = manager_status status['manager']['outdated_queries_count'] = len( models.Query.outdated_queries()) queues = {} for ds in models.DataSource.select(): for queue in (ds.queue_name, ds.scheduled_queue_name): queues.setdefault(queue, set()) queues[queue].add(ds.name) status['manager']['queues'] = {} for queue, sources in queues.iteritems(): status['manager']['queues'][queue] = { 'data_sources': ', '.join(sources), 'size': redis_connection.llen(queue) } return status
def get_status(): status = {} info = redis_connection.info() status['redis_used_memory'] = info['used_memory_human'] status['version'] = __version__ status['queries_count'] = models.db.session.query(models.Query).count() if settings.FEATURE_SHOW_QUERY_RESULTS_COUNT: status['query_results_count'] = models.db.session.query(models.QueryResult).count() status['unused_query_results_count'] = models.QueryResult.unused().count() status['dashboards_count'] = models.Dashboard.query.count() status['widgets_count'] = models.Widget.query.count() status['workers'] = [] status['manager'] = redis_connection.hgetall('redash:status') queues = {} for ds in models.DataSource.query: for queue in (ds.queue_name, ds.scheduled_queue_name): queues.setdefault(queue, set()) queues[queue].add(ds.name) status['manager']['queues'] = {} for queue, sources in queues.iteritems(): status['manager']['queues'][queue] = { 'data_sources': ', '.join(sources), 'size': redis_connection.llen(queue) } return status
def get_status(): status = {} info = redis_connection.info() status['Redis使用内存'] = info['used_memory_human'] status['版本号'] = __version__ status['查询数'] = models.db.session.query(models.Query).count() if settings.FEATURE_SHOW_QUERY_RESULTS_COUNT: status['查询结果数'] = models.db.session.query(models.QueryResult).count() status['未使用查询结果数'] = models.QueryResult.unused().count() status['仪表盘数'] = models.Dashboard.query.count() status['控件数'] = models.Widget.query.count() status['workers'] = [] manager_status = redis_connection.hgetall('redash:status') status['manager'] = manager_status status['manager']['outdated_queries_count'] = len( models.Query.outdated_queries()) queues = {} for ds in models.DataSource.query: for queue in (ds.queue_name, ds.scheduled_queue_name): queues.setdefault(queue, set()) queues[queue].add(ds.name) status['manager']['queues'] = {} for queue, sources in queues.iteritems(): status['manager']['queues'][queue] = { 'data_sources': ', '.join(sources), 'size': redis_connection.llen(queue) } return status
def get_status(): status = {} info = redis_connection.info() status['redis_used_memory'] = info['used_memory'] status['redis_used_memory_human'] = info['used_memory_human'] status['version'] = __version__ status['queries_count'] = models.db.session.query(models.Query).count() if settings.FEATURE_SHOW_QUERY_RESULTS_COUNT: status['query_results_count'] = models.db.session.query( models.QueryResult).count() status['unused_query_results_count'] = models.QueryResult.unused( ).count() status['dashboards_count'] = models.Dashboard.query.count() status['widgets_count'] = models.Widget.query.count() status['workers'] = [] status['manager'] = redis_connection.hgetall('redash:status') queues = {} for ds in models.DataSource.query: for queue in (ds.queue_name, ds.scheduled_queue_name): queues.setdefault(queue, set()) queues[queue].add(ds.name) status['manager']['queues'] = {} for queue, sources in queues.iteritems(): status['manager']['queues'][queue] = { 'data_sources': ', '.join(sources), 'size': redis_connection.llen(queue) } status['manager']['queues']['celery'] = { 'size': redis_connection.llen('celery'), 'data_sources': '' } status['database_metrics'] = [] # have to include the fake FROM in the SQL to prevent an IndexError queries = [ [ 'Query Results Size', "pg_size_pretty(pg_total_relation_size('query_results')) as size from (select 1) as a" ], [ 'Redash DB Size', "pg_size_pretty(pg_database_size('postgres')) as size from (select 1) as a" ] ] for query_name, query in queries: result = models.db.session.query(query).first() status['database_metrics'].append([query_name, result[0]]) return status
def status_api(): status = {} info = redis_connection.info() status['redis_used_memory'] = info['used_memory_human'] status['version'] = __version__ status['queries_count'] = models.Query.select().count() status['query_results_count'] = models.QueryResult.select().count() status['dashboards_count'] = models.Dashboard.select().count() status['widgets_count'] = models.Widget.select().count() status['workers'] = [] manager_status = redis_connection.hgetall('redash:status') status['manager'] = manager_status status['manager']['queue_size'] = 'Unknown'#redis_connection.zcard('jobs') return jsonify(status)
def status_api(): status = {} info = redis_connection.info() status['redis_used_memory'] = info['used_memory_human'] status['queries_count'] = models.Query.select().count() status['query_results_count'] = models.QueryResult.select().count() status['dashboards_count'] = models.Dashboard.select().count() status['widgets_count'] = models.Widget.select().count() status['workers'] = [ redis_connection.hgetall(w) for w in redis_connection.smembers('workers') ] manager_status = redis_connection.hgetall('manager:status') status['manager'] = manager_status status['manager']['queue_size'] = redis_connection.zcard('jobs') return jsonify(status)
def get_redis_status(): info = redis_connection.info() return { "redis_used_memory": info["used_memory"], "redis_used_memory_human": info["used_memory_human"], }
def get_redis_status(): info = redis_connection.info() return {'redis_used_memory': info['used_memory'], 'redis_used_memory_human': info['used_memory_human']}
def get_redis_status(): info = redis_connection.info() return { 'Redis内存大小': info['used_memory'], 'Redis使用内存大小': info['used_memory_human'] }