table - sys_transaction_pattern «Slow Transactions»

Derivation Hierarchy

sys_pattern «Slow Pattern» Global
\| +—	sys_transaction_pattern «Slow Transactions» Global

Subclasses:: No Subclasses
Siblings:: sys_interaction_pattern, sys_cache_build_pattern, sys_query_pattern, sys_script_pattern, sysevent_pattern, sys_stacktrace_pattern, sys_ire_pattern, sys_rte_pattern, sys_mutex_pattern

Table Details

Name:: sys_transaction_pattern
Label:: Slow Transactions (en)

Created On:: 2022.03.18 03:12:05
Created By:: system

Updated On:: 2022.03.18 03:12:05
Updated By:: system

Column Updated On:: 2022.03.18 03:12:05
Column Updated By:: system

Scope Name:: Global
Scope:: global

Listing:: open
Dictionary:: open

Columns

Status	Name	Label	Datatype	Length	Scope	Reference	Included By
	acl_time	Total ACL time (ms)	decimal	15	Global		sys_transaction_pattern
	action	Example UI action	string	400	Global		sys_transaction_pattern
	average	Average execution time (ms)	decimal	15	Global		sys_pattern
	average_acl_time	Average ACL time (ms)	decimal	15	Global		sys_transaction_pattern
	average_browser_time	Average browser time (ms)	decimal	15	Global		sys_transaction_pattern
	average_business_rule_time	Average Business Rule time (ms)	decimal	15	Global		sys_transaction_pattern
	average_client_network_time	Average client network time (ms)	decimal	15	Global		sys_transaction_pattern
	average_client_response_time	Average client time (ms)	decimal	15	Global		sys_transaction_pattern
	average_client_script_time	Average client script time (ms)	decimal	15	Global		sys_transaction_pattern
	average_cpu_time	Average cpu time	decimal	15	Global		sys_transaction_pattern
	average_sql_time	Average SQL time (ms)	decimal	15	Global		sys_transaction_pattern
	average_ui_policy_time	Average UI policy time (ms)	decimal	15	Global		sys_transaction_pattern
	browser_time	Total browser time (ms)	decimal	15	Global		sys_transaction_pattern
	business_rule_time	Total Business Rule time (ms)	decimal	15	Global		sys_transaction_pattern
	client_count	Client execution count	integer	40	Global		sys_transaction_pattern
	client_network_time	Total client network time (ms)	decimal	15	Global		sys_transaction_pattern
	client_response_time	Total client time (ms)	decimal	15	Global		sys_transaction_pattern
	client_script_time	Total client script time (ms)	decimal	15	Global		sys_transaction_pattern
	count	Execution count	longint	40	Global		sys_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
	origin_scope	Origin Application	reference	32	Global	sys_scope	sys_transaction_pattern
	processor	Example processor	string	200	Global		sys_transaction_pattern
	sql_time	Total SQL time (ms)	decimal	15	Global		sys_transaction_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_transaction_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
	table	Example table	table_name	80	Global		sys_transaction_pattern
	total	Total execution time	glide_duration	40	Global		sys_pattern
	total_cpu_time	Total cpu time	decimal	15	Global		sys_transaction_pattern
	type	Example type	string[choice]	40	Global		sys_transaction_pattern
	ui_policy_time	Total UI policy time (ms)	decimal	15	Global		sys_transaction_pattern
	url	Example URL	string	4000	Global		sys_pattern
	view	Example view	string	80	Global		sys_transaction_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

Passive

Mandatory

Display Value

Key

Unique

Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Referenced

sys_pattern referenced from table:: jrobin_shard_location, sys_stacktrace_pattern
sys_transaction_pattern referenced from table:: syslog_transaction, syslog_transaction0000, syslog_transaction0001, syslog_transaction0002, syslog_transaction0003, syslog_transaction0004, syslog_transaction0005, syslog_transaction0006, syslog_transaction0007

Diagram sys_transaction_pattern «Slow Transactions» / Global (global)

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