sys_query_pattern

«Slow Queries» / Global (global)

Table Details

Name:
sys_query_pattern
Label:
Slow Queries (en)
Created On:
2022.03.18 03:12:00
Created By:
system
Updated On:
2022.03.18 03:12:00
Updated By:
system
Column Updated On:
2022.12.27 15:12:03
Column Updated By:
system
Scope Name:
Global
Scope:
global
Listing:
open
Dictionary:
open

Columns

+ Status Name Label Datatype Length Scope Reference Included By
  average
 Average execution time (ms) decimal 15 Global sys_pattern
  count
 Execution count longint 40 Global sys_pattern
  date_reset
 Date Reset glide_date_time 40 Global sys_query_pattern
  db_name
 Database Name string 40 Global sys_query_pattern
  example
 Example string 8000 Global sys_query_pattern
  first
 First sighting glide_date_time 40 Global sys_pattern
  hash
 Hash integer 40 Global sys_pattern
 
D
label
 Label string 100 Global sys_pattern
  last
 Last sighting glide_date_time 40 Global sys_pattern
  moving_average
 Moving average execution time (ms) decimal 15 Global sys_query_pattern
  moving_count
 Moving execution count longint 40 Global sys_query_pattern
  moving_total
 Moving total execution time glide_duration 40 Global sys_query_pattern
  pool_name
 Pool Name string 40 Global sys_query_pattern
  primary_hash
 Primary Hash integer 40 Global sys_query_pattern
  stack_trace
 Example Java stack trace string 8000 Global sys_pattern
  sys_class_name
 Pattern type sys_class_name[choice] 80 Global sys_pattern
  sys_created_by
 Created by string 40 Global sys_pattern
  sys_created_on
 Created glide_date_time 40 Global sys_pattern
 
K
sys_id
 Sys ID GUID 32 Global sys_query_pattern
  sys_mod_count
 Updates integer 40 Global sys_pattern
  sys_updated_by
 Updated by string 40 Global sys_pattern
  sys_updated_on
 Updated glide_date_time 40 Global sys_pattern
  total
 Total execution time glide_duration 40 Global sys_pattern
  url
 Example URL string 4000 Global sys_pattern
  window_end
 Window End reference 32 Global sys_performance_event sys_pattern
  window_start
 Window Start reference 32 Global sys_performance_event sys_pattern
P
 Passive
M
 Mandatory
D
 Display Value
K
 Key
U
 Unique
X
 Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column Current Environment Washington Vancouver Uta Tokyo (Vanilla) Tokyo
executable_sql missing missing missing missing missing
placeholders missing missing missing missing missing

Referenced

sys_pattern referenced from table:
jrobin_shard_location, sys_stacktrace_pattern
sys_query_pattern referenced from table:
plan_execution, sys_index_suggestion, sys_index_suggestion_exec, v_index_creator
×

Diagram sys_query_pattern  «Slow Queries» / Global (global)

Download PDFDownload PNGDownload DrawIO Download PDFDownload PNGDownload DrawIO
shift+click on node to show path. mouse scroll to zoom, dblclick to zoom in, dblclick+shift to zoom out