[EXASOL-2932] Introduction of COLUMN STATISTICS in profiling tables Created: 27.07.2021  Updated: 03.08.2021  Resolved: 03.08.2021

Status: Resolved
Project: EXASOL Roadmap
Component/s: None
Fix Version/s: Exasol 7.1.0

Type: Improvement Priority: Minor
Reporter: Captain EXASOL Assignee: Captain EXASOL
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocking

 Description   

Background

The time spent in computing column statistics was previously included in the COMPILE / EXECUTE part of a pipeline in the public profiling tables.

Improvement

The profiling tables

  • EXA_DBA_PROFILE_LAST_DAY
  • EXA_USER_PROFILE_LAST_DAY
  • EXA_DBA_PROFILE_RUNNING
  • EXA_USER_PROFILE_RUNNING

now show an additional profiling part COLUMN STATISTICS, which indicates that the database is computing statistics on a column for internal optimization. When consecutive, these parts are combined by the table with the remarks field having a comma-separated list of the columns over which statistics were computed.


Generated at Fri Jan 28 23:22:48 CET 2022 using Jira 7.13.18#713018-sha1:e1230154f8ff8cc9272975bf568fc732e806fd68.