github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/delegate/show_queries.go (about)

     1  // Copyright 2017 The Cockroach Authors.
     2  //
     3  // Use of this software is governed by the Business Source License
     4  // included in the file licenses/BSL.txt.
     5  //
     6  // As of the Change Date specified in that file, in accordance with
     7  // the Business Source License, use of this software will be governed
     8  // by the Apache License, Version 2.0, included in the file
     9  // licenses/APL.txt.
    10  
    11  package delegate
    12  
    13  import (
    14  	"github.com/cockroachdb/cockroach/pkg/sql/sem/tree"
    15  	"github.com/cockroachdb/cockroach/pkg/sql/sqlbase"
    16  	"github.com/cockroachdb/cockroach/pkg/sql/sqltelemetry"
    17  )
    18  
    19  func (d *delegator) delegateShowQueries(n *tree.ShowQueries) (tree.Statement, error) {
    20  	sqltelemetry.IncrementShowCounter(sqltelemetry.Queries)
    21  	const query = `SELECT query_id, node_id, session_id, user_name, start, query, client_address, application_name, distributed, phase FROM crdb_internal.`
    22  	table := `node_queries`
    23  	if n.Cluster {
    24  		table = `cluster_queries`
    25  	}
    26  	var filter string
    27  	if !n.All {
    28  		filter = " WHERE application_name NOT LIKE '" + sqlbase.InternalAppNamePrefix + "%'"
    29  	}
    30  	return parse(query + table + filter)
    31  }