Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Tencentcloud Provider
  3. API Docs
  4. getCynosdbInstanceSlowQueries
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack
tencentcloudstack/terraform-provider-tencentcloud

tencentcloud.getCynosdbInstanceSlowQueries

Explore with Pulumi AI

tencentcloud logo
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack
tencentcloudstack/terraform-provider-tencentcloud

    Use this data source to query detailed information of cynosdb instance_slow_queries

    Example Usage

    Query slow queries of instance

    import * as pulumi from "@pulumi/pulumi";
import * as tencentcloud from "@pulumi/tencentcloud";

const config = new pulumi.Config();
const cynosdbClusterId = config.get("cynosdbClusterId") || "default_cynosdb_cluster";
const instanceSlowQueries = tencentcloud.getCynosdbInstanceSlowQueries({
    instanceId: cynosdbClusterId,
    startTime: "2023-06-20 23:19:03",
    endTime: "2023-06-30 23:19:03",
    username: "keep_dts",
    host: "%%",
    database: "tf_ci_test",
    orderBy: "QueryTime",
    orderByType: "desc",
});

    import pulumi
import pulumi_tencentcloud as tencentcloud

config = pulumi.Config()
cynosdb_cluster_id = config.get("cynosdbClusterId")
if cynosdb_cluster_id is None:
    cynosdb_cluster_id = "default_cynosdb_cluster"
instance_slow_queries = tencentcloud.get_cynosdb_instance_slow_queries(instance_id=cynosdb_cluster_id,
    start_time="2023-06-20 23:19:03",
    end_time="2023-06-30 23:19:03",
    username="keep_dts",
    host="%%",
    database="tf_ci_test",
    order_by="QueryTime",
    order_by_type="desc")

    package main

import (
	"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi/config"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		cfg := config.New(ctx, "")
		cynosdbClusterId := "default_cynosdb_cluster"
		if param := cfg.Get("cynosdbClusterId"); param != "" {
			cynosdbClusterId = param
		}
		_, err := tencentcloud.GetCynosdbInstanceSlowQueries(ctx, &tencentcloud.GetCynosdbInstanceSlowQueriesArgs{
			InstanceId:  cynosdbClusterId,
			StartTime:   pulumi.StringRef("2023-06-20 23:19:03"),
			EndTime:     pulumi.StringRef("2023-06-30 23:19:03"),
			Username:    pulumi.StringRef("keep_dts"),
			Host:        pulumi.StringRef("%%"),
			Database:    pulumi.StringRef("tf_ci_test"),
			OrderBy:     pulumi.StringRef("QueryTime"),
			OrderByType: pulumi.StringRef("desc"),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Tencentcloud = Pulumi.Tencentcloud;

return await Deployment.RunAsync(() => 
{
    var config = new Config();
    var cynosdbClusterId = config.Get("cynosdbClusterId") ?? "default_cynosdb_cluster";
    var instanceSlowQueries = Tencentcloud.GetCynosdbInstanceSlowQueries.Invoke(new()
    {
        InstanceId = cynosdbClusterId,
        StartTime = "2023-06-20 23:19:03",
        EndTime = "2023-06-30 23:19:03",
        Username = "keep_dts",
        Host = "%%",
        Database = "tf_ci_test",
        OrderBy = "QueryTime",
        OrderByType = "desc",
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.tencentcloud.TencentcloudFunctions;
import com.pulumi.tencentcloud.inputs.GetCynosdbInstanceSlowQueriesArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var config = ctx.config();
        final var cynosdbClusterId = config.get("cynosdbClusterId").orElse("default_cynosdb_cluster");
        final var instanceSlowQueries = TencentcloudFunctions.getCynosdbInstanceSlowQueries(GetCynosdbInstanceSlowQueriesArgs.builder()
            .instanceId(cynosdbClusterId)
            .startTime("2023-06-20 23:19:03")
            .endTime("2023-06-30 23:19:03")
            .username("keep_dts")
            .host("%%")
            .database("tf_ci_test")
            .orderBy("QueryTime")
            .orderByType("desc")
            .build());

    }
}

    configuration:
  cynosdbClusterId:
    type: string
    default: default_cynosdb_cluster
variables:
  instanceSlowQueries:
    fn::invoke:
      function: tencentcloud:getCynosdbInstanceSlowQueries
      arguments:
        instanceId: ${cynosdbClusterId}
        startTime: 2023-06-20 23:19:03
        endTime: 2023-06-30 23:19:03
        username: keep_dts
        host: '%%'
        database: tf_ci_test
        orderBy: QueryTime
        orderByType: desc

    Query slow queries by time range

    import * as pulumi from "@pulumi/pulumi";
import * as tencentcloud from "@pulumi/tencentcloud";

const config = new pulumi.Config();
const cynosdbClusterId = config.get("cynosdbClusterId") || "default_cynosdb_cluster";
const instanceSlowQueries = tencentcloud.getCynosdbInstanceSlowQueries({
    instanceId: cynosdbClusterId,
    startTime: "2023-06-20 23:19:03",
    endTime: "2023-06-30 23:19:03",
    orderBy: "QueryTime",
    orderByType: "desc",
});

    import pulumi
import pulumi_tencentcloud as tencentcloud

config = pulumi.Config()
cynosdb_cluster_id = config.get("cynosdbClusterId")
if cynosdb_cluster_id is None:
    cynosdb_cluster_id = "default_cynosdb_cluster"
instance_slow_queries = tencentcloud.get_cynosdb_instance_slow_queries(instance_id=cynosdb_cluster_id,
    start_time="2023-06-20 23:19:03",
    end_time="2023-06-30 23:19:03",
    order_by="QueryTime",
    order_by_type="desc")

    package main

import (
	"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi/config"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		cfg := config.New(ctx, "")
		cynosdbClusterId := "default_cynosdb_cluster"
		if param := cfg.Get("cynosdbClusterId"); param != "" {
			cynosdbClusterId = param
		}
		_, err := tencentcloud.GetCynosdbInstanceSlowQueries(ctx, &tencentcloud.GetCynosdbInstanceSlowQueriesArgs{
			InstanceId:  cynosdbClusterId,
			StartTime:   pulumi.StringRef("2023-06-20 23:19:03"),
			EndTime:     pulumi.StringRef("2023-06-30 23:19:03"),
			OrderBy:     pulumi.StringRef("QueryTime"),
			OrderByType: pulumi.StringRef("desc"),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Tencentcloud = Pulumi.Tencentcloud;

return await Deployment.RunAsync(() => 
{
    var config = new Config();
    var cynosdbClusterId = config.Get("cynosdbClusterId") ?? "default_cynosdb_cluster";
    var instanceSlowQueries = Tencentcloud.GetCynosdbInstanceSlowQueries.Invoke(new()
    {
        InstanceId = cynosdbClusterId,
        StartTime = "2023-06-20 23:19:03",
        EndTime = "2023-06-30 23:19:03",
        OrderBy = "QueryTime",
        OrderByType = "desc",
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.tencentcloud.TencentcloudFunctions;
import com.pulumi.tencentcloud.inputs.GetCynosdbInstanceSlowQueriesArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var config = ctx.config();
        final var cynosdbClusterId = config.get("cynosdbClusterId").orElse("default_cynosdb_cluster");
        final var instanceSlowQueries = TencentcloudFunctions.getCynosdbInstanceSlowQueries(GetCynosdbInstanceSlowQueriesArgs.builder()
            .instanceId(cynosdbClusterId)
            .startTime("2023-06-20 23:19:03")
            .endTime("2023-06-30 23:19:03")
            .orderBy("QueryTime")
            .orderByType("desc")
            .build());

    }
}

    configuration:
  cynosdbClusterId:
    type: string
    default: default_cynosdb_cluster
variables:
  instanceSlowQueries:
    fn::invoke:
      function: tencentcloud:getCynosdbInstanceSlowQueries
      arguments:
        instanceId: ${cynosdbClusterId}
        startTime: 2023-06-20 23:19:03
        endTime: 2023-06-30 23:19:03
        orderBy: QueryTime
        orderByType: desc

    Query slow queries by user and db name

    import * as pulumi from "@pulumi/pulumi";
import * as tencentcloud from "@pulumi/tencentcloud";

const config = new pulumi.Config();
const cynosdbClusterId = config.get("cynosdbClusterId") || "default_cynosdb_cluster";
const instanceSlowQueries = tencentcloud.getCynosdbInstanceSlowQueries({
    instanceId: cynosdbClusterId,
    username: "keep_dts",
    host: "%%",
    database: "tf_ci_test",
    orderBy: "QueryTime",
    orderByType: "desc",
});

    import pulumi
import pulumi_tencentcloud as tencentcloud

config = pulumi.Config()
cynosdb_cluster_id = config.get("cynosdbClusterId")
if cynosdb_cluster_id is None:
    cynosdb_cluster_id = "default_cynosdb_cluster"
instance_slow_queries = tencentcloud.get_cynosdb_instance_slow_queries(instance_id=cynosdb_cluster_id,
    username="keep_dts",
    host="%%",
    database="tf_ci_test",
    order_by="QueryTime",
    order_by_type="desc")

    package main

import (
	"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi/config"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		cfg := config.New(ctx, "")
		cynosdbClusterId := "default_cynosdb_cluster"
		if param := cfg.Get("cynosdbClusterId"); param != "" {
			cynosdbClusterId = param
		}
		_, err := tencentcloud.GetCynosdbInstanceSlowQueries(ctx, &tencentcloud.GetCynosdbInstanceSlowQueriesArgs{
			InstanceId:  cynosdbClusterId,
			Username:    pulumi.StringRef("keep_dts"),
			Host:        pulumi.StringRef("%%"),
			Database:    pulumi.StringRef("tf_ci_test"),
			OrderBy:     pulumi.StringRef("QueryTime"),
			OrderByType: pulumi.StringRef("desc"),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Tencentcloud = Pulumi.Tencentcloud;

return await Deployment.RunAsync(() => 
{
    var config = new Config();
    var cynosdbClusterId = config.Get("cynosdbClusterId") ?? "default_cynosdb_cluster";
    var instanceSlowQueries = Tencentcloud.GetCynosdbInstanceSlowQueries.Invoke(new()
    {
        InstanceId = cynosdbClusterId,
        Username = "keep_dts",
        Host = "%%",
        Database = "tf_ci_test",
        OrderBy = "QueryTime",
        OrderByType = "desc",
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.tencentcloud.TencentcloudFunctions;
import com.pulumi.tencentcloud.inputs.GetCynosdbInstanceSlowQueriesArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var config = ctx.config();
        final var cynosdbClusterId = config.get("cynosdbClusterId").orElse("default_cynosdb_cluster");
        final var instanceSlowQueries = TencentcloudFunctions.getCynosdbInstanceSlowQueries(GetCynosdbInstanceSlowQueriesArgs.builder()
            .instanceId(cynosdbClusterId)
            .username("keep_dts")
            .host("%%")
            .database("tf_ci_test")
            .orderBy("QueryTime")
            .orderByType("desc")
            .build());

    }
}

    configuration:
  cynosdbClusterId:
    type: string
    default: default_cynosdb_cluster
variables:
  instanceSlowQueries:
    fn::invoke:
      function: tencentcloud:getCynosdbInstanceSlowQueries
      arguments:
        instanceId: ${cynosdbClusterId}
        username: keep_dts
        host: '%%'
        database: tf_ci_test
        orderBy: QueryTime
        orderByType: desc

    Using getCynosdbInstanceSlowQueries

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getCynosdbInstanceSlowQueries(args: GetCynosdbInstanceSlowQueriesArgs, opts?: InvokeOptions): Promise<GetCynosdbInstanceSlowQueriesResult>
function getCynosdbInstanceSlowQueriesOutput(args: GetCynosdbInstanceSlowQueriesOutputArgs, opts?: InvokeOptions): Output<GetCynosdbInstanceSlowQueriesResult>
    def get_cynosdb_instance_slow_queries(database: Optional[str] = None,
                                      end_time: Optional[str] = None,
                                      host: Optional[str] = None,
                                      id: Optional[str] = None,
                                      instance_id: Optional[str] = None,
                                      order_by: Optional[str] = None,
                                      order_by_type: Optional[str] = None,
                                      result_output_file: Optional[str] = None,
                                      start_time: Optional[str] = None,
                                      username: Optional[str] = None,
                                      opts: Optional[InvokeOptions] = None) -> GetCynosdbInstanceSlowQueriesResult
def get_cynosdb_instance_slow_queries_output(database: Optional[pulumi.Input[str]] = None,
                                      end_time: Optional[pulumi.Input[str]] = None,
                                      host: Optional[pulumi.Input[str]] = None,
                                      id: Optional[pulumi.Input[str]] = None,
                                      instance_id: Optional[pulumi.Input[str]] = None,
                                      order_by: Optional[pulumi.Input[str]] = None,
                                      order_by_type: Optional[pulumi.Input[str]] = None,
                                      result_output_file: Optional[pulumi.Input[str]] = None,
                                      start_time: Optional[pulumi.Input[str]] = None,
                                      username: Optional[pulumi.Input[str]] = None,
                                      opts: Optional[InvokeOptions] = None) -> Output[GetCynosdbInstanceSlowQueriesResult]
    func GetCynosdbInstanceSlowQueries(ctx *Context, args *GetCynosdbInstanceSlowQueriesArgs, opts ...InvokeOption) (*GetCynosdbInstanceSlowQueriesResult, error)
func GetCynosdbInstanceSlowQueriesOutput(ctx *Context, args *GetCynosdbInstanceSlowQueriesOutputArgs, opts ...InvokeOption) GetCynosdbInstanceSlowQueriesResultOutput

    > Note: This function is named GetCynosdbInstanceSlowQueries in the Go SDK.

    public static class GetCynosdbInstanceSlowQueries 
{
    public static Task<GetCynosdbInstanceSlowQueriesResult> InvokeAsync(GetCynosdbInstanceSlowQueriesArgs args, InvokeOptions? opts = null)
    public static Output<GetCynosdbInstanceSlowQueriesResult> Invoke(GetCynosdbInstanceSlowQueriesInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetCynosdbInstanceSlowQueriesResult> getCynosdbInstanceSlowQueries(GetCynosdbInstanceSlowQueriesArgs args, InvokeOptions options)
public static Output<GetCynosdbInstanceSlowQueriesResult> getCynosdbInstanceSlowQueries(GetCynosdbInstanceSlowQueriesArgs args, InvokeOptions options)

    fn::invoke:
  function: tencentcloud:index/getCynosdbInstanceSlowQueries:getCynosdbInstanceSlowQueries
  arguments:
    # arguments dictionary

    The following arguments are supported:

    InstanceId string
    Instance ID.
    Database string
    Database name.
    EndTime string
    Latest transaction start time.
    Host string
    Client host.
    Id string
    OrderBy string
    Sort field, optional values: QueryTime, LockTime, RowsExamined, RowsSent.
    OrderByType string
    Sort type, optional values: asc, desc.
    ResultOutputFile string
    Used to save results.
    StartTime string
    Earliest transaction start time.
    Username string
    user name.
    InstanceId string
    Instance ID.
    Database string
    Database name.
    EndTime string
    Latest transaction start time.
    Host string
    Client host.
    Id string
    OrderBy string
    Sort field, optional values: QueryTime, LockTime, RowsExamined, RowsSent.
    OrderByType string
    Sort type, optional values: asc, desc.
    ResultOutputFile string
    Used to save results.
    StartTime string
    Earliest transaction start time.
    Username string
    user name.
    instanceId String
    Instance ID.
    database String
    Database name.
    endTime String
    Latest transaction start time.
    host String
    Client host.
    id String
    orderBy String
    Sort field, optional values: QueryTime, LockTime, RowsExamined, RowsSent.
    orderByType String
    Sort type, optional values: asc, desc.
    resultOutputFile String
    Used to save results.
    startTime String
    Earliest transaction start time.
    username String
    user name.
    instanceId string
    Instance ID.
    database string
    Database name.
    endTime string
    Latest transaction start time.
    host string
    Client host.
    id string
    orderBy string
    Sort field, optional values: QueryTime, LockTime, RowsExamined, RowsSent.
    orderByType string
    Sort type, optional values: asc, desc.
    resultOutputFile string
    Used to save results.
    startTime string
    Earliest transaction start time.
    username string
    user name.
    instance_id str
    Instance ID.
    database str
    Database name.
    end_time str
    Latest transaction start time.
    host str
    Client host.
    id str
    order_by str
    Sort field, optional values: QueryTime, LockTime, RowsExamined, RowsSent.
    order_by_type str
    Sort type, optional values: asc, desc.
    result_output_file str
    Used to save results.
    start_time str
    Earliest transaction start time.
    username str
    user name.
    instanceId String
    Instance ID.
    database String
    Database name.
    endTime String
    Latest transaction start time.
    host String
    Client host.
    id String
    orderBy String
    Sort field, optional values: QueryTime, LockTime, RowsExamined, RowsSent.
    orderByType String
    Sort type, optional values: asc, desc.
    resultOutputFile String
    Used to save results.
    startTime String
    Earliest transaction start time.
    username String
    user name.

    getCynosdbInstanceSlowQueries Result

    The following output properties are available:

    Id string
    InstanceId string
    SlowQueries List<GetCynosdbInstanceSlowQueriesSlowQuery>
    Slow query records.
    Database string
    Database name.
    EndTime string
    Host string
    OrderBy string
    OrderByType string
    ResultOutputFile string
    StartTime string
    Username string
    Id string
    InstanceId string
    SlowQueries []GetCynosdbInstanceSlowQueriesSlowQuery
    Slow query records.
    Database string
    Database name.
    EndTime string
    Host string
    OrderBy string
    OrderByType string
    ResultOutputFile string
    StartTime string
    Username string
    id String
    instanceId String
    slowQueries List<GetCynosdbInstanceSlowQueriesSlowQuery>
    Slow query records.
    database String
    Database name.
    endTime String
    host String
    orderBy String
    orderByType String
    resultOutputFile String
    startTime String
    username String
    id string
    instanceId string
    slowQueries GetCynosdbInstanceSlowQueriesSlowQuery[]
    Slow query records.
    database string
    Database name.
    endTime string
    host string
    orderBy string
    orderByType string
    resultOutputFile string
    startTime string
    username string
    id String
    instanceId String
    slowQueries List<Property Map>
    Slow query records.
    database String
    Database name.
    endTime String
    host String
    orderBy String
    orderByType String
    resultOutputFile String
    startTime String
    username String

    Supporting Types

    GetCynosdbInstanceSlowQueriesSlowQuery

    Database string
    Database name.
    LockTime double
    Lock duration in seconds.
    QueryTime double
    Execution time in seconds.
    RowsExamined double
    Scan Rows.
    RowsSent double
    Return the number of rows.
    SqlMd5 string
    SQL statement md5.
    SqlTemplate string
    SQL template.
    SqlText string
    SQL statement.
    Timestamp double
    Execution timestamp.
    UserHost string
    Client host.
    UserName string
    user name.
    Database string
    Database name.
    LockTime float64
    Lock duration in seconds.
    QueryTime float64
    Execution time in seconds.
    RowsExamined float64
    Scan Rows.
    RowsSent float64
    Return the number of rows.
    SqlMd5 string
    SQL statement md5.
    SqlTemplate string
    SQL template.
    SqlText string
    SQL statement.
    Timestamp float64
    Execution timestamp.
    UserHost string
    Client host.
    UserName string
    user name.
    database String
    Database name.
    lockTime Double
    Lock duration in seconds.
    queryTime Double
    Execution time in seconds.
    rowsExamined Double
    Scan Rows.
    rowsSent Double
    Return the number of rows.
    sqlMd5 String
    SQL statement md5.
    sqlTemplate String
    SQL template.
    sqlText String
    SQL statement.
    timestamp Double
    Execution timestamp.
    userHost String
    Client host.
    userName String
    user name.
    database string
    Database name.
    lockTime number
    Lock duration in seconds.
    queryTime number
    Execution time in seconds.
    rowsExamined number
    Scan Rows.
    rowsSent number
    Return the number of rows.
    sqlMd5 string
    SQL statement md5.
    sqlTemplate string
    SQL template.
    sqlText string
    SQL statement.
    timestamp number
    Execution timestamp.
    userHost string
    Client host.
    userName string
    user name.
    database str
    Database name.
    lock_time float
    Lock duration in seconds.
    query_time float
    Execution time in seconds.
    rows_examined float
    Scan Rows.
    rows_sent float
    Return the number of rows.
    sql_md5 str
    SQL statement md5.
    sql_template str
    SQL template.
    sql_text str
    SQL statement.
    timestamp float
    Execution timestamp.
    user_host str
    Client host.
    user_name str
    user name.
    database String
    Database name.
    lockTime Number
    Lock duration in seconds.
    queryTime Number
    Execution time in seconds.
    rowsExamined Number
    Scan Rows.
    rowsSent Number
    Return the number of rows.
    sqlMd5 String
    SQL statement md5.
    sqlTemplate String
    SQL template.
    sqlText String
    SQL statement.
    timestamp Number
    Execution timestamp.
    userHost String
    Client host.
    userName String
    user name.

    Package Details

    Repository
    tencentcloud tencentcloudstack/terraform-provider-tencentcloud
    License
    Notes
    This Pulumi package is based on the tencentcloud Terraform Provider.
    tencentcloud logo
    tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack
    tencentcloudstack/terraform-provider-tencentcloud