1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedMySqlDatabaseSqlData
Oracle Cloud Infrastructure v2.3.0 published on Wednesday, Jul 17, 2024 by Pulumi

oci.DatabaseManagement.getManagedMySqlDatabaseSqlData

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.3.0 published on Wednesday, Jul 17, 2024 by Pulumi

    This data source provides the list of Managed My Sql Database Sql Data in Oracle Cloud Infrastructure Database Management service.

    Retrieves SQL performance data for given MySQL Instance.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as oci from "@pulumi/oci";
    
    const testManagedMySqlDatabaseSqlData = oci.DatabaseManagement.getManagedMySqlDatabaseSqlData({
        endTime: managedMySqlDatabaseSqlDataEndTime,
        managedMySqlDatabaseId: testManagedMySqlDatabase.id,
        startTime: managedMySqlDatabaseSqlDataStartTime,
        filterColumn: managedMySqlDatabaseSqlDataFilterColumn,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_managed_my_sql_database_sql_data = oci.DatabaseManagement.get_managed_my_sql_database_sql_data(end_time=managed_my_sql_database_sql_data_end_time,
        managed_my_sql_database_id=test_managed_my_sql_database["id"],
        start_time=managed_my_sql_database_sql_data_start_time,
        filter_column=managed_my_sql_database_sql_data_filter_column)
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/DatabaseManagement"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := DatabaseManagement.GetManagedMySqlDatabaseSqlData(ctx, &databasemanagement.GetManagedMySqlDatabaseSqlDataArgs{
    			EndTime:                managedMySqlDatabaseSqlDataEndTime,
    			ManagedMySqlDatabaseId: testManagedMySqlDatabase.Id,
    			StartTime:              managedMySqlDatabaseSqlDataStartTime,
    			FilterColumn:           pulumi.StringRef(managedMySqlDatabaseSqlDataFilterColumn),
    		}, nil)
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Oci = Pulumi.Oci;
    
    return await Deployment.RunAsync(() => 
    {
        var testManagedMySqlDatabaseSqlData = Oci.DatabaseManagement.GetManagedMySqlDatabaseSqlData.Invoke(new()
        {
            EndTime = managedMySqlDatabaseSqlDataEndTime,
            ManagedMySqlDatabaseId = testManagedMySqlDatabase.Id,
            StartTime = managedMySqlDatabaseSqlDataStartTime,
            FilterColumn = managedMySqlDatabaseSqlDataFilterColumn,
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.oci.DatabaseManagement.DatabaseManagementFunctions;
    import com.pulumi.oci.DatabaseManagement.inputs.GetManagedMySqlDatabaseSqlDataArgs;
    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 testManagedMySqlDatabaseSqlData = DatabaseManagementFunctions.getManagedMySqlDatabaseSqlData(GetManagedMySqlDatabaseSqlDataArgs.builder()
                .endTime(managedMySqlDatabaseSqlDataEndTime)
                .managedMySqlDatabaseId(testManagedMySqlDatabase.id())
                .startTime(managedMySqlDatabaseSqlDataStartTime)
                .filterColumn(managedMySqlDatabaseSqlDataFilterColumn)
                .build());
    
        }
    }
    
    variables:
      testManagedMySqlDatabaseSqlData:
        fn::invoke:
          Function: oci:DatabaseManagement:getManagedMySqlDatabaseSqlData
          Arguments:
            endTime: ${managedMySqlDatabaseSqlDataEndTime}
            managedMySqlDatabaseId: ${testManagedMySqlDatabase.id}
            startTime: ${managedMySqlDatabaseSqlDataStartTime}
            filterColumn: ${managedMySqlDatabaseSqlDataFilterColumn}
    

    Using getManagedMySqlDatabaseSqlData

    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 getManagedMySqlDatabaseSqlData(args: GetManagedMySqlDatabaseSqlDataArgs, opts?: InvokeOptions): Promise<GetManagedMySqlDatabaseSqlDataResult>
    function getManagedMySqlDatabaseSqlDataOutput(args: GetManagedMySqlDatabaseSqlDataOutputArgs, opts?: InvokeOptions): Output<GetManagedMySqlDatabaseSqlDataResult>
    def get_managed_my_sql_database_sql_data(end_time: Optional[str] = None,
                                             filter_column: Optional[str] = None,
                                             filters: Optional[Sequence[_databasemanagement.GetManagedMySqlDatabaseSqlDataFilter]] = None,
                                             managed_my_sql_database_id: Optional[str] = None,
                                             start_time: Optional[str] = None,
                                             opts: Optional[InvokeOptions] = None) -> GetManagedMySqlDatabaseSqlDataResult
    def get_managed_my_sql_database_sql_data_output(end_time: Optional[pulumi.Input[str]] = None,
                                             filter_column: Optional[pulumi.Input[str]] = None,
                                             filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedMySqlDatabaseSqlDataFilterArgs]]]] = None,
                                             managed_my_sql_database_id: Optional[pulumi.Input[str]] = None,
                                             start_time: Optional[pulumi.Input[str]] = None,
                                             opts: Optional[InvokeOptions] = None) -> Output[GetManagedMySqlDatabaseSqlDataResult]
    func GetManagedMySqlDatabaseSqlData(ctx *Context, args *GetManagedMySqlDatabaseSqlDataArgs, opts ...InvokeOption) (*GetManagedMySqlDatabaseSqlDataResult, error)
    func GetManagedMySqlDatabaseSqlDataOutput(ctx *Context, args *GetManagedMySqlDatabaseSqlDataOutputArgs, opts ...InvokeOption) GetManagedMySqlDatabaseSqlDataResultOutput

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

    public static class GetManagedMySqlDatabaseSqlData 
    {
        public static Task<GetManagedMySqlDatabaseSqlDataResult> InvokeAsync(GetManagedMySqlDatabaseSqlDataArgs args, InvokeOptions? opts = null)
        public static Output<GetManagedMySqlDatabaseSqlDataResult> Invoke(GetManagedMySqlDatabaseSqlDataInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetManagedMySqlDatabaseSqlDataResult> getManagedMySqlDatabaseSqlData(GetManagedMySqlDatabaseSqlDataArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:DatabaseManagement/getManagedMySqlDatabaseSqlData:getManagedMySqlDatabaseSqlData
      arguments:
        # arguments dictionary

    The following arguments are supported:

    EndTime string
    The end time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".
    ManagedMySqlDatabaseId string
    The OCID of the Managed MySQL Database.
    StartTime string
    The start time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".
    FilterColumn string
    The parameter to filter results by key criteria which include :

    • AVG_TIMER_WAIT
    • SUM_TIMER_WAIT
    • COUNT_STAR
    • SUM_ERRORS
    • SUM_ROWS_AFFECTED
    • SUM_ROWS_SENT
    • SUM_ROWS_EXAMINED
    • SUM_CREATED_TMP_TABLES
    • SUM_NO_INDEX_USED
    • SUM_NO_GOOD_INDEX_USED
    • FIRST_SEEN
    • LAST_SEEN
    • HEATWAVE_OFFLOADED
    • HEATWAVE_OUT_OF_MEMORY
    Filters List<GetManagedMySqlDatabaseSqlDataFilter>
    EndTime string
    The end time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".
    ManagedMySqlDatabaseId string
    The OCID of the Managed MySQL Database.
    StartTime string
    The start time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".
    FilterColumn string
    The parameter to filter results by key criteria which include :

    • AVG_TIMER_WAIT
    • SUM_TIMER_WAIT
    • COUNT_STAR
    • SUM_ERRORS
    • SUM_ROWS_AFFECTED
    • SUM_ROWS_SENT
    • SUM_ROWS_EXAMINED
    • SUM_CREATED_TMP_TABLES
    • SUM_NO_INDEX_USED
    • SUM_NO_GOOD_INDEX_USED
    • FIRST_SEEN
    • LAST_SEEN
    • HEATWAVE_OFFLOADED
    • HEATWAVE_OUT_OF_MEMORY
    Filters []GetManagedMySqlDatabaseSqlDataFilter
    endTime String
    The end time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".
    managedMySqlDatabaseId String
    The OCID of the Managed MySQL Database.
    startTime String
    The start time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".
    filterColumn String
    The parameter to filter results by key criteria which include :

    • AVG_TIMER_WAIT
    • SUM_TIMER_WAIT
    • COUNT_STAR
    • SUM_ERRORS
    • SUM_ROWS_AFFECTED
    • SUM_ROWS_SENT
    • SUM_ROWS_EXAMINED
    • SUM_CREATED_TMP_TABLES
    • SUM_NO_INDEX_USED
    • SUM_NO_GOOD_INDEX_USED
    • FIRST_SEEN
    • LAST_SEEN
    • HEATWAVE_OFFLOADED
    • HEATWAVE_OUT_OF_MEMORY
    filters List<GetManagedMySqlDatabaseSqlDataFilter>
    endTime string
    The end time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".
    managedMySqlDatabaseId string
    The OCID of the Managed MySQL Database.
    startTime string
    The start time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".
    filterColumn string
    The parameter to filter results by key criteria which include :

    • AVG_TIMER_WAIT
    • SUM_TIMER_WAIT
    • COUNT_STAR
    • SUM_ERRORS
    • SUM_ROWS_AFFECTED
    • SUM_ROWS_SENT
    • SUM_ROWS_EXAMINED
    • SUM_CREATED_TMP_TABLES
    • SUM_NO_INDEX_USED
    • SUM_NO_GOOD_INDEX_USED
    • FIRST_SEEN
    • LAST_SEEN
    • HEATWAVE_OFFLOADED
    • HEATWAVE_OUT_OF_MEMORY
    filters GetManagedMySqlDatabaseSqlDataFilter[]
    end_time str
    The end time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".
    managed_my_sql_database_id str
    The OCID of the Managed MySQL Database.
    start_time str
    The start time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".
    filter_column str
    The parameter to filter results by key criteria which include :

    • AVG_TIMER_WAIT
    • SUM_TIMER_WAIT
    • COUNT_STAR
    • SUM_ERRORS
    • SUM_ROWS_AFFECTED
    • SUM_ROWS_SENT
    • SUM_ROWS_EXAMINED
    • SUM_CREATED_TMP_TABLES
    • SUM_NO_INDEX_USED
    • SUM_NO_GOOD_INDEX_USED
    • FIRST_SEEN
    • LAST_SEEN
    • HEATWAVE_OFFLOADED
    • HEATWAVE_OUT_OF_MEMORY
    filters Sequence[databasemanagement.GetManagedMySqlDatabaseSqlDataFilter]
    endTime String
    The end time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".
    managedMySqlDatabaseId String
    The OCID of the Managed MySQL Database.
    startTime String
    The start time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'".
    filterColumn String
    The parameter to filter results by key criteria which include :

    • AVG_TIMER_WAIT
    • SUM_TIMER_WAIT
    • COUNT_STAR
    • SUM_ERRORS
    • SUM_ROWS_AFFECTED
    • SUM_ROWS_SENT
    • SUM_ROWS_EXAMINED
    • SUM_CREATED_TMP_TABLES
    • SUM_NO_INDEX_USED
    • SUM_NO_GOOD_INDEX_USED
    • FIRST_SEEN
    • LAST_SEEN
    • HEATWAVE_OFFLOADED
    • HEATWAVE_OUT_OF_MEMORY
    filters List<Property Map>

    getManagedMySqlDatabaseSqlData Result

    The following output properties are available:

    EndTime string
    Id string
    The provider-assigned unique ID for this managed resource.
    ManagedMySqlDatabaseId string
    MySqlDataCollections List<GetManagedMySqlDatabaseSqlDataMySqlDataCollection>
    The list of my_sql_data_collection.
    StartTime string
    FilterColumn string
    Filters List<GetManagedMySqlDatabaseSqlDataFilter>
    EndTime string
    Id string
    The provider-assigned unique ID for this managed resource.
    ManagedMySqlDatabaseId string
    MySqlDataCollections []GetManagedMySqlDatabaseSqlDataMySqlDataCollection
    The list of my_sql_data_collection.
    StartTime string
    FilterColumn string
    Filters []GetManagedMySqlDatabaseSqlDataFilter
    endTime String
    id String
    The provider-assigned unique ID for this managed resource.
    managedMySqlDatabaseId String
    mySqlDataCollections List<GetManagedMySqlDatabaseSqlDataMySqlDataCollection>
    The list of my_sql_data_collection.
    startTime String
    filterColumn String
    filters List<GetManagedMySqlDatabaseSqlDataFilter>
    endTime string
    id string
    The provider-assigned unique ID for this managed resource.
    managedMySqlDatabaseId string
    mySqlDataCollections GetManagedMySqlDatabaseSqlDataMySqlDataCollection[]
    The list of my_sql_data_collection.
    startTime string
    filterColumn string
    filters GetManagedMySqlDatabaseSqlDataFilter[]
    endTime String
    id String
    The provider-assigned unique ID for this managed resource.
    managedMySqlDatabaseId String
    mySqlDataCollections List<Property Map>
    The list of my_sql_data_collection.
    startTime String
    filterColumn String
    filters List<Property Map>

    Supporting Types

    GetManagedMySqlDatabaseSqlDataFilter

    Name string
    Values List<string>
    Regex bool
    Name string
    Values []string
    Regex bool
    name String
    values List<String>
    regex Boolean
    name string
    values string[]
    regex boolean
    name str
    values Sequence[str]
    regex bool
    name String
    values List<String>
    regex Boolean

    GetManagedMySqlDatabaseSqlDataMySqlDataCollection

    items List<Property Map>
    The list of SQLDataSummary records.

    GetManagedMySqlDatabaseSqlDataMySqlDataCollectionItem

    AvgTimerWait double
    The average execution time.
    CountStar double
    The number Of times the query has been executed.
    Digest string
    The digest information of the normalized query.
    DigestText string
    The normalized query.
    FirstSeen string
    The date and time the query was first seen. If the table is truncated, the first seen value is reset.
    HeatWaveOffloaded double
    The number of query executions offloaded to HeatWave.
    HeatWaveOutOfMemory double
    The number of query executions with HeatWave out-of-memory errors.
    LastSeen string
    The date and time the query was last seen.
    MaxTimerWait double
    The slowest the query has been executed.
    MinTimerWait double
    The fastest the query has been executed.
    Quantile95 double
    The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time.
    Quantile99 double
    The 99th percentile of the query latency.
    Quantile999 double
    The 99.9th percentile of the query latency.
    SchemaName string
    The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL.
    SumCreatedTempDiskTables double
    The total number of On-Disk internal temporary tables that have been created by the query.
    SumCreatedTempTables double
    The total number of internal temporary tables (in memory or on disk), which have been created by the query.
    SumErrors double
    The total number of errors that have been encountered executing the query.
    SumLockTime double
    The total amount of time that has been spent waiting for table locks.
    SumNoGoodIndexUsed double
    The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes “Range Checked For Each Record.”
    SumNoIndexUsed double
    The total number of times no index was used to execute the query.
    SumRowsAffected double
    The total number of rows that have been modified by the query.
    SumRowsExamined double
    The total number of rows that have been examined by the query.
    SumRowsSent double
    The total number of rows that have been returned (sent) to the client.
    SumSelectFullJoin double
    The total number of joins that have performed full table scans as there was no join condition or no index for the join condition. This is the same as the select_full_join status variable.
    SumSelectFullRangeJoin double
    The total number of joins that use a full range search. This is the same as the select_full_range_join status variable.
    SumSelectRange double
    The total number of times the query has used a range search. This is the same as the select_range status variable.
    SumSelectRangeCheck double
    The total number of joins by the query where the join does not have an index that checks for the index usage after each row. This is the same as the select_range_check status variable.
    SumSelectScan double
    The total number of times the query has performed a full table scan on the first table in the join. This is the same as the select_scan status variable.
    SumSortMergePasses double
    The total number of sort merge passes that have been done to sort the result of the query. This is the same as the sort_merge_passes status variable.
    SumSortRange double
    The total number of times a sort was done using ranges. This is the same as the sort_range status variable.
    SumSortRows double
    The total number of rows sorted. This is the same as the sort_rowsStatus variable.
    SumSortScan double
    The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable.
    SumTimerWait double
    The total amount of time that has been spent executing the query.
    SumWarnings double
    The total number of warnings that have been encountered executing the query.
    AvgTimerWait float64
    The average execution time.
    CountStar float64
    The number Of times the query has been executed.
    Digest string
    The digest information of the normalized query.
    DigestText string
    The normalized query.
    FirstSeen string
    The date and time the query was first seen. If the table is truncated, the first seen value is reset.
    HeatWaveOffloaded float64
    The number of query executions offloaded to HeatWave.
    HeatWaveOutOfMemory float64
    The number of query executions with HeatWave out-of-memory errors.
    LastSeen string
    The date and time the query was last seen.
    MaxTimerWait float64
    The slowest the query has been executed.
    MinTimerWait float64
    The fastest the query has been executed.
    Quantile95 float64
    The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time.
    Quantile99 float64
    The 99th percentile of the query latency.
    Quantile999 float64
    The 99.9th percentile of the query latency.
    SchemaName string
    The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL.
    SumCreatedTempDiskTables float64
    The total number of On-Disk internal temporary tables that have been created by the query.
    SumCreatedTempTables float64
    The total number of internal temporary tables (in memory or on disk), which have been created by the query.
    SumErrors float64
    The total number of errors that have been encountered executing the query.
    SumLockTime float64
    The total amount of time that has been spent waiting for table locks.
    SumNoGoodIndexUsed float64
    The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes “Range Checked For Each Record.”
    SumNoIndexUsed float64
    The total number of times no index was used to execute the query.
    SumRowsAffected float64
    The total number of rows that have been modified by the query.
    SumRowsExamined float64
    The total number of rows that have been examined by the query.
    SumRowsSent float64
    The total number of rows that have been returned (sent) to the client.
    SumSelectFullJoin float64
    The total number of joins that have performed full table scans as there was no join condition or no index for the join condition. This is the same as the select_full_join status variable.
    SumSelectFullRangeJoin float64
    The total number of joins that use a full range search. This is the same as the select_full_range_join status variable.
    SumSelectRange float64
    The total number of times the query has used a range search. This is the same as the select_range status variable.
    SumSelectRangeCheck float64
    The total number of joins by the query where the join does not have an index that checks for the index usage after each row. This is the same as the select_range_check status variable.
    SumSelectScan float64
    The total number of times the query has performed a full table scan on the first table in the join. This is the same as the select_scan status variable.
    SumSortMergePasses float64
    The total number of sort merge passes that have been done to sort the result of the query. This is the same as the sort_merge_passes status variable.
    SumSortRange float64
    The total number of times a sort was done using ranges. This is the same as the sort_range status variable.
    SumSortRows float64
    The total number of rows sorted. This is the same as the sort_rowsStatus variable.
    SumSortScan float64
    The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable.
    SumTimerWait float64
    The total amount of time that has been spent executing the query.
    SumWarnings float64
    The total number of warnings that have been encountered executing the query.
    avgTimerWait Double
    The average execution time.
    countStar Double
    The number Of times the query has been executed.
    digest String
    The digest information of the normalized query.
    digestText String
    The normalized query.
    firstSeen String
    The date and time the query was first seen. If the table is truncated, the first seen value is reset.
    heatWaveOffloaded Double
    The number of query executions offloaded to HeatWave.
    heatWaveOutOfMemory Double
    The number of query executions with HeatWave out-of-memory errors.
    lastSeen String
    The date and time the query was last seen.
    maxTimerWait Double
    The slowest the query has been executed.
    minTimerWait Double
    The fastest the query has been executed.
    quantile95 Double
    The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time.
    quantile99 Double
    The 99th percentile of the query latency.
    quantile999 Double
    The 99.9th percentile of the query latency.
    schemaName String
    The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL.
    sumCreatedTempDiskTables Double
    The total number of On-Disk internal temporary tables that have been created by the query.
    sumCreatedTempTables Double
    The total number of internal temporary tables (in memory or on disk), which have been created by the query.
    sumErrors Double
    The total number of errors that have been encountered executing the query.
    sumLockTime Double
    The total amount of time that has been spent waiting for table locks.
    sumNoGoodIndexUsed Double
    The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes “Range Checked For Each Record.”
    sumNoIndexUsed Double
    The total number of times no index was used to execute the query.
    sumRowsAffected Double
    The total number of rows that have been modified by the query.
    sumRowsExamined Double
    The total number of rows that have been examined by the query.
    sumRowsSent Double
    The total number of rows that have been returned (sent) to the client.
    sumSelectFullJoin Double
    The total number of joins that have performed full table scans as there was no join condition or no index for the join condition. This is the same as the select_full_join status variable.
    sumSelectFullRangeJoin Double
    The total number of joins that use a full range search. This is the same as the select_full_range_join status variable.
    sumSelectRange Double
    The total number of times the query has used a range search. This is the same as the select_range status variable.
    sumSelectRangeCheck Double
    The total number of joins by the query where the join does not have an index that checks for the index usage after each row. This is the same as the select_range_check status variable.
    sumSelectScan Double
    The total number of times the query has performed a full table scan on the first table in the join. This is the same as the select_scan status variable.
    sumSortMergePasses Double
    The total number of sort merge passes that have been done to sort the result of the query. This is the same as the sort_merge_passes status variable.
    sumSortRange Double
    The total number of times a sort was done using ranges. This is the same as the sort_range status variable.
    sumSortRows Double
    The total number of rows sorted. This is the same as the sort_rowsStatus variable.
    sumSortScan Double
    The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable.
    sumTimerWait Double
    The total amount of time that has been spent executing the query.
    sumWarnings Double
    The total number of warnings that have been encountered executing the query.
    avgTimerWait number
    The average execution time.
    countStar number
    The number Of times the query has been executed.
    digest string
    The digest information of the normalized query.
    digestText string
    The normalized query.
    firstSeen string
    The date and time the query was first seen. If the table is truncated, the first seen value is reset.
    heatWaveOffloaded number
    The number of query executions offloaded to HeatWave.
    heatWaveOutOfMemory number
    The number of query executions with HeatWave out-of-memory errors.
    lastSeen string
    The date and time the query was last seen.
    maxTimerWait number
    The slowest the query has been executed.
    minTimerWait number
    The fastest the query has been executed.
    quantile95 number
    The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time.
    quantile99 number
    The 99th percentile of the query latency.
    quantile999 number
    The 99.9th percentile of the query latency.
    schemaName string
    The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL.
    sumCreatedTempDiskTables number
    The total number of On-Disk internal temporary tables that have been created by the query.
    sumCreatedTempTables number
    The total number of internal temporary tables (in memory or on disk), which have been created by the query.
    sumErrors number
    The total number of errors that have been encountered executing the query.
    sumLockTime number
    The total amount of time that has been spent waiting for table locks.
    sumNoGoodIndexUsed number
    The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes “Range Checked For Each Record.”
    sumNoIndexUsed number
    The total number of times no index was used to execute the query.
    sumRowsAffected number
    The total number of rows that have been modified by the query.
    sumRowsExamined number
    The total number of rows that have been examined by the query.
    sumRowsSent number
    The total number of rows that have been returned (sent) to the client.
    sumSelectFullJoin number
    The total number of joins that have performed full table scans as there was no join condition or no index for the join condition. This is the same as the select_full_join status variable.
    sumSelectFullRangeJoin number
    The total number of joins that use a full range search. This is the same as the select_full_range_join status variable.
    sumSelectRange number
    The total number of times the query has used a range search. This is the same as the select_range status variable.
    sumSelectRangeCheck number
    The total number of joins by the query where the join does not have an index that checks for the index usage after each row. This is the same as the select_range_check status variable.
    sumSelectScan number
    The total number of times the query has performed a full table scan on the first table in the join. This is the same as the select_scan status variable.
    sumSortMergePasses number
    The total number of sort merge passes that have been done to sort the result of the query. This is the same as the sort_merge_passes status variable.
    sumSortRange number
    The total number of times a sort was done using ranges. This is the same as the sort_range status variable.
    sumSortRows number
    The total number of rows sorted. This is the same as the sort_rowsStatus variable.
    sumSortScan number
    The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable.
    sumTimerWait number
    The total amount of time that has been spent executing the query.
    sumWarnings number
    The total number of warnings that have been encountered executing the query.
    avg_timer_wait float
    The average execution time.
    count_star float
    The number Of times the query has been executed.
    digest str
    The digest information of the normalized query.
    digest_text str
    The normalized query.
    first_seen str
    The date and time the query was first seen. If the table is truncated, the first seen value is reset.
    heat_wave_offloaded float
    The number of query executions offloaded to HeatWave.
    heat_wave_out_of_memory float
    The number of query executions with HeatWave out-of-memory errors.
    last_seen str
    The date and time the query was last seen.
    max_timer_wait float
    The slowest the query has been executed.
    min_timer_wait float
    The fastest the query has been executed.
    quantile95 float
    The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time.
    quantile99 float
    The 99th percentile of the query latency.
    quantile999 float
    The 99.9th percentile of the query latency.
    schema_name str
    The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL.
    sum_created_temp_disk_tables float
    The total number of On-Disk internal temporary tables that have been created by the query.
    sum_created_temp_tables float
    The total number of internal temporary tables (in memory or on disk), which have been created by the query.
    sum_errors float
    The total number of errors that have been encountered executing the query.
    sum_lock_time float
    The total amount of time that has been spent waiting for table locks.
    sum_no_good_index_used float
    The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes “Range Checked For Each Record.”
    sum_no_index_used float
    The total number of times no index was used to execute the query.
    sum_rows_affected float
    The total number of rows that have been modified by the query.
    sum_rows_examined float
    The total number of rows that have been examined by the query.
    sum_rows_sent float
    The total number of rows that have been returned (sent) to the client.
    sum_select_full_join float
    The total number of joins that have performed full table scans as there was no join condition or no index for the join condition. This is the same as the select_full_join status variable.
    sum_select_full_range_join float
    The total number of joins that use a full range search. This is the same as the select_full_range_join status variable.
    sum_select_range float
    The total number of times the query has used a range search. This is the same as the select_range status variable.
    sum_select_range_check float
    The total number of joins by the query where the join does not have an index that checks for the index usage after each row. This is the same as the select_range_check status variable.
    sum_select_scan float
    The total number of times the query has performed a full table scan on the first table in the join. This is the same as the select_scan status variable.
    sum_sort_merge_passes float
    The total number of sort merge passes that have been done to sort the result of the query. This is the same as the sort_merge_passes status variable.
    sum_sort_range float
    The total number of times a sort was done using ranges. This is the same as the sort_range status variable.
    sum_sort_rows float
    The total number of rows sorted. This is the same as the sort_rowsStatus variable.
    sum_sort_scan float
    The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable.
    sum_timer_wait float
    The total amount of time that has been spent executing the query.
    sum_warnings float
    The total number of warnings that have been encountered executing the query.
    avgTimerWait Number
    The average execution time.
    countStar Number
    The number Of times the query has been executed.
    digest String
    The digest information of the normalized query.
    digestText String
    The normalized query.
    firstSeen String
    The date and time the query was first seen. If the table is truncated, the first seen value is reset.
    heatWaveOffloaded Number
    The number of query executions offloaded to HeatWave.
    heatWaveOutOfMemory Number
    The number of query executions with HeatWave out-of-memory errors.
    lastSeen String
    The date and time the query was last seen.
    maxTimerWait Number
    The slowest the query has been executed.
    minTimerWait Number
    The fastest the query has been executed.
    quantile95 Number
    The 95th percentile of the query latency. That is, 95% of the queries complete in the time given or in less time.
    quantile99 Number
    The 99th percentile of the query latency.
    quantile999 Number
    The 99.9th percentile of the query latency.
    schemaName String
    The name of the default schema when executing the query. If a schema is not set as the default, then the value is NULL.
    sumCreatedTempDiskTables Number
    The total number of On-Disk internal temporary tables that have been created by the query.
    sumCreatedTempTables Number
    The total number of internal temporary tables (in memory or on disk), which have been created by the query.
    sumErrors Number
    The total number of errors that have been encountered executing the query.
    sumLockTime Number
    The total amount of time that has been spent waiting for table locks.
    sumNoGoodIndexUsed Number
    The total number of times no good index was used. This means that the extra column in The EXPLAIN output includes “Range Checked For Each Record.”
    sumNoIndexUsed Number
    The total number of times no index was used to execute the query.
    sumRowsAffected Number
    The total number of rows that have been modified by the query.
    sumRowsExamined Number
    The total number of rows that have been examined by the query.
    sumRowsSent Number
    The total number of rows that have been returned (sent) to the client.
    sumSelectFullJoin Number
    The total number of joins that have performed full table scans as there was no join condition or no index for the join condition. This is the same as the select_full_join status variable.
    sumSelectFullRangeJoin Number
    The total number of joins that use a full range search. This is the same as the select_full_range_join status variable.
    sumSelectRange Number
    The total number of times the query has used a range search. This is the same as the select_range status variable.
    sumSelectRangeCheck Number
    The total number of joins by the query where the join does not have an index that checks for the index usage after each row. This is the same as the select_range_check status variable.
    sumSelectScan Number
    The total number of times the query has performed a full table scan on the first table in the join. This is the same as the select_scan status variable.
    sumSortMergePasses Number
    The total number of sort merge passes that have been done to sort the result of the query. This is the same as the sort_merge_passes status variable.
    sumSortRange Number
    The total number of times a sort was done using ranges. This is the same as the sort_range status variable.
    sumSortRows Number
    The total number of rows sorted. This is the same as the sort_rowsStatus variable.
    sumSortScan Number
    The total number of times a sort was done by scanning the table. This is the same as the sort_scan status variable.
    sumTimerWait Number
    The total amount of time that has been spent executing the query.
    sumWarnings Number
    The total number of warnings that have been encountered executing the query.

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v2.3.0 published on Wednesday, Jul 17, 2024 by Pulumi