Table Panel

The Table panel displays your queries in tabular form. Use Table panels for quantitative analysis where you want to see actual values instead of visual representations. Similar to a spreadsheet, you can look at a combination of metric values and segments. This is useful when you don’t necessarily care about the change of a metric over time, or want to run reports to download as CSV/JSON for offline analysis.

The metric values are determined by the data source and the query.

Build an Aggregate View of Your Workloads Per Cluster and Namespace

This example shows how to build a Form table panel to view a concatenated list of workloads per cluster and namespace.

When configuring the panel options, choose:

  • Segmentation: kube_cluster_name and kube_namespace_name
  • Metrics/Labels: kube_workload_name
  • Time aggregation: Concat

You can then export the results as CSV for further exploration.

View Resource Utilization of Your Kubernetes Workload Using a PromQL Table Panel

This example shows how to build a PromQL table panel to view resource utilization of your Kubernetes workload.

For demonstration, CPU and memory utilization is evaluated against the given quota in each workload, cluster, and namespace. The query displays top 10 segments that consume highest number of CPU cores and highest amount of memory.

  • CPU Used Percent

    topk(10,avg(avg_over_time(sysdig_container_cpu_used_percent{$__scope}[$__interval])) by (kube_cluster_name, kube_namespace_name, kube_workload_name))
    
  • CPU Quota

    topk(10,avg(avg_over_time(sysdig_container_cpu_cores_quota_limit{$__scope}[$__interval])) by (kube_cluster_name, kube_namespace_name, kube_workload_name))
    
  • Memory Used Percent

    topk(10,avg(avg_over_time(sysdig_container_memory_used_percent{$__scope}[$__interval])) by (kube_cluster_name, kube_namespace_name, kube_workload_name))
    
  • Memory Quota

    topk(10,avg(avg_over_time(sysdig_container_memory_limit_bytes{$__scope}[$__interval])) by (kube_cluster_name, kube_namespace_name, kube_workload_name))
    

Select an appropriate unit of value for each query to return meaningful result. For example, use number for CPU quota, data for memory quota, and percent resource utilization metrics.

To scope down your selection, use the scope variable in combination with Team scope.

In this example, the panel scope is limited to two clusters (netsec-load-data, test-k8s-data), one namespace (kube-system), and one workload (coredns).

Known Limitations

  • The PromQL panel currently doesn’t support exporting results
  • The PromQL panel column order doesn’t honor the query segmentation order

Beta features

  • The PromQL panel show a maximum of 250 rows. This limit can be changed with a beta flag in the settings page: