Package com.microstrategy.web.objects.admin.monitors

Interface QueryStats

  • public interface QueryStats
    This interface represents cube query statistics

    • Method Detail

      • getStartTime

        java.util.Date getStartTime()
        Returns the start time
        Returns:
        the start time

      • getFinishTime

        java.util.Date getFinishTime()
        Returns the finish time
        Returns:
        the finish time

      • getSqlDuration

        int getSqlDuration()
        Returns the SQL duration
        Returns:
        the SQL duration

      • getAEDuration

        int getAEDuration()
        Returns the Analytical Engine durations
        Returns:
        the Analytical Engine durations

      • getOtherDuration

        int getOtherDuration()
        Returns the other actions durations
        Returns:
        the other actions durations

      • getNumRows

        int getNumRows()
        Returns the number of rows
        Returns:
        the number of rows

      • getNumCols

        int getNumCols()
        Returns the number of columns
        Returns:
        the number of columns

      • getNumTempTables

        int getNumTempTables()
        Returns the number of temporary tables
        Returns:
        the number of temporary tables

      • getTotalNumPasses

        int getTotalNumPasses()
        Returns the total number of passes
        Returns:
        the total number of passes

      • getNumSQLPasses

        int getNumSQLPasses()
        Returns the number of SQL passes
        Returns:
        the number of SQL passes

      • getNumAEPasses

        int getNumAEPasses()
        Returns the number of analytical engine passes
        Returns:
        the number of analytical engine passes

      • getErrorMessage

        java.lang.String getErrorMessage()
        Returns the error message
        Returns:
        the error message

      • getDataSourceType

        int getDataSourceType()
        Returns the data source type
        Returns:
        the data source type

      • getAccessedTablesCount

        int getAccessedTablesCount()
        Returns the accessed tables count
        Returns:
        the accessed tables count

      • getSqlExecutionDuration

        java.util.OptionalInt getSqlExecutionDuration()
        Returns the sum of query execution time. Unit: ms
        Returns:
        the sum of query execution time The OptionalInt type is set for backward compatibility. When the user uses an old iServer version, the XML response doesn't contain the corresponding attribute, then the function would return OptionalInt.empty().

      • getOtherProcessingDuration

        int getOtherProcessingDuration()
        Returns total other processing time. Unit: ms
        Returns:
        total other processing time

      • getDbUserNames

        java.util.Optional<java.util.List<java.lang.String>> getDbUserNames()
        Returns the db user names of all db instances
        Returns:
        the db user names of all db instances The Optional type is set for backward compatibility. When the user uses an old iServer version, the XML response doesn't contain the corresponding attribute, then the function would return Optional.empty().

      • getDbInstanceNames

        java.util.Optional<java.util.List<java.lang.String>> getDbInstanceNames()
        Returns the names of all db instances
        Returns:
        the names all db instances The Optional type is set for backward compatibility. When the user uses an old iServer version, the XML response doesn't contain the corresponding attribute, then the function would return Optional.empty().

      • getAccesseTable

        @Deprecated
AccessedTable getAccesseTable​(int i)
        Deprecated.
        Not used anymore. Use #getAccessedTable() to get the accessed table instead.
        Returns the accessed table
        Parameters:
        i - index
        Returns:
        the accessed table

      • getAccessedTable

        AccessedTable getAccessedTable​(int i)
        Returns the accessed table
        Parameters:
        i - index
        Returns:
        the accessed table

      • getQueryPass

        QueryPass getQueryPass​(int i)
        Returns the query pass
        Parameters:
        i - index
        Returns:
        the query pass