tencentcloud 1.81.189, Apr 30 25

tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

tencentcloudstack/terraform-provider-tencentcloud

tencentcloud.getDcdbSlowLogs

Explore with Pulumi AI

tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

tencentcloudstack/terraform-provider-tencentcloud

Example Usage

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

const slowLogs = tencentcloud.getDcdbSlowLogs({
    instanceId: local.dcdb_id,
    startTime: "%s",
    endTime: "%s",
    shardId: "shard-1b5r04az",
    db: "tf_test_db",
    orderBy: "query_time_sum",
    orderByType: "desc",
    slave: 0,
});

import pulumi
import pulumi_tencentcloud as tencentcloud

slow_logs = tencentcloud.get_dcdb_slow_logs(instance_id=local["dcdb_id"],
    start_time="%s",
    end_time="%s",
    shard_id="shard-1b5r04az",
    db="tf_test_db",
    order_by="query_time_sum",
    order_by_type="desc",
    slave=0)

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := tencentcloud.GetDcdbSlowLogs(ctx, &tencentcloud.GetDcdbSlowLogsArgs{
			InstanceId:  local.Dcdb_id,
			StartTime:   "%s",
			EndTime:     pulumi.StringRef("%s"),
			ShardId:     "shard-1b5r04az",
			Db:          pulumi.StringRef("tf_test_db"),
			OrderBy:     pulumi.StringRef("query_time_sum"),
			OrderByType: pulumi.StringRef("desc"),
			Slave:       pulumi.Float64Ref(0),
		}, 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 slowLogs = Tencentcloud.GetDcdbSlowLogs.Invoke(new()
    {
        InstanceId = local.Dcdb_id,
        StartTime = "%s",
        EndTime = "%s",
        ShardId = "shard-1b5r04az",
        Db = "tf_test_db",
        OrderBy = "query_time_sum",
        OrderByType = "desc",
        Slave = 0,
    });

});

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.GetDcdbSlowLogsArgs;
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 slowLogs = TencentcloudFunctions.getDcdbSlowLogs(GetDcdbSlowLogsArgs.builder()
            .instanceId(local.dcdb_id())
            .startTime("%s")
            .endTime("%s")
            .shardId("shard-1b5r04az")
            .db("tf_test_db")
            .orderBy("query_time_sum")
            .orderByType("desc")
            .slave(0)
            .build());

    }
}

variables:
  slowLogs:
    fn::invoke:
      function: tencentcloud:getDcdbSlowLogs
      arguments:
        instanceId: ${local.dcdb_id}
        startTime: '%s'
        endTime: '%s'
        shardId: shard-1b5r04az
        db: tf_test_db
        orderBy: query_time_sum
        orderByType: desc
        slave: 0

Using getDcdbSlowLogs

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 getDcdbSlowLogs(args: GetDcdbSlowLogsArgs, opts?: InvokeOptions): Promise<GetDcdbSlowLogsResult>
function getDcdbSlowLogsOutput(args: GetDcdbSlowLogsOutputArgs, opts?: InvokeOptions): Output<GetDcdbSlowLogsResult>

def get_dcdb_slow_logs(db: Optional[str] = None,
                       end_time: 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,
                       shard_id: Optional[str] = None,
                       slave: Optional[float] = None,
                       start_time: Optional[str] = None,
                       opts: Optional[InvokeOptions] = None) -> GetDcdbSlowLogsResult
def get_dcdb_slow_logs_output(db: Optional[pulumi.Input[str]] = None,
                       end_time: 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,
                       shard_id: Optional[pulumi.Input[str]] = None,
                       slave: Optional[pulumi.Input[float]] = None,
                       start_time: Optional[pulumi.Input[str]] = None,
                       opts: Optional[InvokeOptions] = None) -> Output[GetDcdbSlowLogsResult]

func GetDcdbSlowLogs(ctx *Context, args *GetDcdbSlowLogsArgs, opts ...InvokeOption) (*GetDcdbSlowLogsResult, error)
func GetDcdbSlowLogsOutput(ctx *Context, args *GetDcdbSlowLogsOutputArgs, opts ...InvokeOption) GetDcdbSlowLogsResultOutput

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

public static class GetDcdbSlowLogs 
{
    public static Task<GetDcdbSlowLogsResult> InvokeAsync(GetDcdbSlowLogsArgs args, InvokeOptions? opts = null)
    public static Output<GetDcdbSlowLogsResult> Invoke(GetDcdbSlowLogsInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDcdbSlowLogsResult> getDcdbSlowLogs(GetDcdbSlowLogsArgs args, InvokeOptions options)
public static Output<GetDcdbSlowLogsResult> getDcdbSlowLogs(GetDcdbSlowLogsArgs args, InvokeOptions options)

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

The following arguments are supported:

InstanceId string: Instance ID in the format of tdsqlshard-ow728lmc.
ShardId string: Instance shard ID in the format of shard-rc754ljk.
StartTime string: Query start time in the format of 2016-07-23 14:55:20.
Db string: Specific name of the database to be queried.
EndTime string: Query end time in the format of 2016-08-22 14:55:20.
Id string
OrderBy string: Sorting metric. Valid values: query_time_sum, query_count.
OrderByType string: Sorting order. Valid values: desc, asc.
ResultOutputFile string: Used to save results.
Slave double: Query slow queries from either the primary or the replica. Valid values: 0 (primary), 1 (replica).

InstanceId string: Instance ID in the format of tdsqlshard-ow728lmc.
ShardId string: Instance shard ID in the format of shard-rc754ljk.
StartTime string: Query start time in the format of 2016-07-23 14:55:20.
Db string: Specific name of the database to be queried.
EndTime string: Query end time in the format of 2016-08-22 14:55:20.
Id string
OrderBy string: Sorting metric. Valid values: query_time_sum, query_count.
OrderByType string: Sorting order. Valid values: desc, asc.
ResultOutputFile string: Used to save results.
Slave float64: Query slow queries from either the primary or the replica. Valid values: 0 (primary), 1 (replica).

instanceId String: Instance ID in the format of tdsqlshard-ow728lmc.
shardId String: Instance shard ID in the format of shard-rc754ljk.
startTime String: Query start time in the format of 2016-07-23 14:55:20.
db String: Specific name of the database to be queried.
endTime String: Query end time in the format of 2016-08-22 14:55:20.
id String
orderBy String: Sorting metric. Valid values: query_time_sum, query_count.
orderByType String: Sorting order. Valid values: desc, asc.
resultOutputFile String: Used to save results.
slave Double: Query slow queries from either the primary or the replica. Valid values: 0 (primary), 1 (replica).

instanceId string: Instance ID in the format of tdsqlshard-ow728lmc.
shardId string: Instance shard ID in the format of shard-rc754ljk.
startTime string: Query start time in the format of 2016-07-23 14:55:20.
db string: Specific name of the database to be queried.
endTime string: Query end time in the format of 2016-08-22 14:55:20.
id string
orderBy string: Sorting metric. Valid values: query_time_sum, query_count.
orderByType string: Sorting order. Valid values: desc, asc.
resultOutputFile string: Used to save results.
slave number: Query slow queries from either the primary or the replica. Valid values: 0 (primary), 1 (replica).

instance_id str: Instance ID in the format of tdsqlshard-ow728lmc.
shard_id str: Instance shard ID in the format of shard-rc754ljk.
start_time str: Query start time in the format of 2016-07-23 14:55:20.
db str: Specific name of the database to be queried.
end_time str: Query end time in the format of 2016-08-22 14:55:20.
id str
order_by str: Sorting metric. Valid values: query_time_sum, query_count.
order_by_type str: Sorting order. Valid values: desc, asc.
result_output_file str: Used to save results.
slave float: Query slow queries from either the primary or the replica. Valid values: 0 (primary), 1 (replica).

instanceId String: Instance ID in the format of tdsqlshard-ow728lmc.
shardId String: Instance shard ID in the format of shard-rc754ljk.
startTime String: Query start time in the format of 2016-07-23 14:55:20.
db String: Specific name of the database to be queried.
endTime String: Query end time in the format of 2016-08-22 14:55:20.
id String
orderBy String: Sorting metric. Valid values: query_time_sum, query_count.
orderByType String: Sorting order. Valid values: desc, asc.
resultOutputFile String: Used to save results.
slave Number: Query slow queries from either the primary or the replica. Valid values: 0 (primary), 1 (replica).

getDcdbSlowLogs Result

The following output properties are available:

Datas List<GetDcdbSlowLogsData>: Slow query log data.
Id string
InstanceId string
LockTimeSum double: Total statement lock time.
QueryCount double: Total number of statement queries.
QueryTimeSum double: Total statement query time.
ShardId string
StartTime string
Db string: Database name.
EndTime string
OrderBy string
OrderByType string
ResultOutputFile string
Slave double

Datas []GetDcdbSlowLogsData: Slow query log data.
Id string
InstanceId string
LockTimeSum float64: Total statement lock time.
QueryCount float64: Total number of statement queries.
QueryTimeSum float64: Total statement query time.
ShardId string
StartTime string
Db string: Database name.
EndTime string
OrderBy string
OrderByType string
ResultOutputFile string
Slave float64

datas List<GetDcdbSlowLogsData>: Slow query log data.
id String
instanceId String
lockTimeSum Double: Total statement lock time.
queryCount Double: Total number of statement queries.
queryTimeSum Double: Total statement query time.
shardId String
startTime String
db String: Database name.
endTime String
orderBy String
orderByType String
resultOutputFile String
slave Double

datas GetDcdbSlowLogsData[]: Slow query log data.
id string
instanceId string
lockTimeSum number: Total statement lock time.
queryCount number: Total number of statement queries.
queryTimeSum number: Total statement query time.
shardId string
startTime string
db string: Database name.
endTime string
orderBy string
orderByType string
resultOutputFile string
slave number

datas Sequence[GetDcdbSlowLogsData]: Slow query log data.
id str
instance_id str
lock_time_sum float: Total statement lock time.
query_count float: Total number of statement queries.
query_time_sum float: Total statement query time.
shard_id str
start_time str
db str: Database name.
end_time str
order_by str
order_by_type str
result_output_file str
slave float

datas List<Property Map>: Slow query log data.
id String
instanceId String
lockTimeSum Number: Total statement lock time.
queryCount Number: Total number of statement queries.
queryTimeSum Number: Total statement query time.
shardId String
startTime String
db String: Database name.
endTime String
orderBy String
orderByType String
resultOutputFile String
slave Number

Supporting Types

GetDcdbSlowLogsData

CheckSum string: Statement checksum for querying details.
Db string: Specific name of the database to be queried.
ExampleSql string: Sample SQLNote: This field may return null, indicating that no valid values can be obtained.
FingerPrint string: Abstracted SQL statement.
Host string: Host address of account.
LockTimeAvg string: Average lock time.
LockTimeMax string: Maximum lock time.
LockTimeMin string: Minimum lock time.
LockTimeSum string: Total statement lock time.
QueryCount string: Total number of statement queries.
QueryTimeAvg string: Average query time.
QueryTimeMax string: Maximum query time.
QueryTimeMin string: Minimum query time.
QueryTimeSum string: Total statement query time.
RowsExaminedSum string: Number of scanned rows.
RowsSentSum string: Number of sent rows.
TsMax string: Last execution time.
TsMin string: First execution time.
User string: Account.

CheckSum string: Statement checksum for querying details.
Db string: Specific name of the database to be queried.
ExampleSql string: Sample SQLNote: This field may return null, indicating that no valid values can be obtained.
FingerPrint string: Abstracted SQL statement.
Host string: Host address of account.
LockTimeAvg string: Average lock time.
LockTimeMax string: Maximum lock time.
LockTimeMin string: Minimum lock time.
LockTimeSum string: Total statement lock time.
QueryCount string: Total number of statement queries.
QueryTimeAvg string: Average query time.
QueryTimeMax string: Maximum query time.
QueryTimeMin string: Minimum query time.
QueryTimeSum string: Total statement query time.
RowsExaminedSum string: Number of scanned rows.
RowsSentSum string: Number of sent rows.
TsMax string: Last execution time.
TsMin string: First execution time.
User string: Account.

checkSum String: Statement checksum for querying details.
db String: Specific name of the database to be queried.
exampleSql String: Sample SQLNote: This field may return null, indicating that no valid values can be obtained.
fingerPrint String: Abstracted SQL statement.
host String: Host address of account.
lockTimeAvg String: Average lock time.
lockTimeMax String: Maximum lock time.
lockTimeMin String: Minimum lock time.
lockTimeSum String: Total statement lock time.
queryCount String: Total number of statement queries.
queryTimeAvg String: Average query time.
queryTimeMax String: Maximum query time.
queryTimeMin String: Minimum query time.
queryTimeSum String: Total statement query time.
rowsExaminedSum String: Number of scanned rows.
rowsSentSum String: Number of sent rows.
tsMax String: Last execution time.
tsMin String: First execution time.
user String: Account.

checkSum string: Statement checksum for querying details.
db string: Specific name of the database to be queried.
exampleSql string: Sample SQLNote: This field may return null, indicating that no valid values can be obtained.
fingerPrint string: Abstracted SQL statement.
host string: Host address of account.
lockTimeAvg string: Average lock time.
lockTimeMax string: Maximum lock time.
lockTimeMin string: Minimum lock time.
lockTimeSum string: Total statement lock time.
queryCount string: Total number of statement queries.
queryTimeAvg string: Average query time.
queryTimeMax string: Maximum query time.
queryTimeMin string: Minimum query time.
queryTimeSum string: Total statement query time.
rowsExaminedSum string: Number of scanned rows.
rowsSentSum string: Number of sent rows.
tsMax string: Last execution time.
tsMin string: First execution time.
user string: Account.

check_sum str: Statement checksum for querying details.
db str: Specific name of the database to be queried.
example_sql str: Sample SQLNote: This field may return null, indicating that no valid values can be obtained.
finger_print str: Abstracted SQL statement.
host str: Host address of account.
lock_time_avg str: Average lock time.
lock_time_max str: Maximum lock time.
lock_time_min str: Minimum lock time.
lock_time_sum str: Total statement lock time.
query_count str: Total number of statement queries.
query_time_avg str: Average query time.
query_time_max str: Maximum query time.
query_time_min str: Minimum query time.
query_time_sum str: Total statement query time.
rows_examined_sum str: Number of scanned rows.
rows_sent_sum str: Number of sent rows.
ts_max str: Last execution time.
ts_min str: First execution time.
user str: Account.

checkSum String: Statement checksum for querying details.
db String: Specific name of the database to be queried.
exampleSql String: Sample SQLNote: This field may return null, indicating that no valid values can be obtained.
fingerPrint String: Abstracted SQL statement.
host String: Host address of account.
lockTimeAvg String: Average lock time.
lockTimeMax String: Maximum lock time.
lockTimeMin String: Minimum lock time.
lockTimeSum String: Total statement lock time.
queryCount String: Total number of statement queries.
queryTimeAvg String: Average query time.
queryTimeMax String: Maximum query time.
queryTimeMin String: Minimum query time.
queryTimeSum String: Total statement query time.
rowsExaminedSum String: Number of scanned rows.
rowsSentSum String: Number of sent rows.
tsMax String: Last execution time.
tsMin String: First execution time.
user String: Account.

Package Details

Repository: tencentcloud tencentcloudstack/terraform-provider-tencentcloud
License
Notes: This Pulumi package is based on the tencentcloud Terraform Provider.

tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

tencentcloudstack/terraform-provider-tencentcloud

tencentcloud.getDcdbSlowLogs

On this page

On this page

Example Usage

Using getDcdbSlowLogs

getDcdbSlowLogs Result

Supporting Types

GetDcdbSlowLogsData

Package Details

On this page

On this page