Table Details

Name:
sys_query_pattern
Label:
Slow Queries (en)
Created On:
2022.09.17 02:04:11
Created By:
system
Updated On:
2022.09.17 02:04:11
Updated By:
system
Column Updated On:
2022.09.17 02:04:11
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) Sandiego
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

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