Feedback

×

• Feedback
• Was this page helpful?*
  • Yes
  • No
• Do you have any additional feedback?
  • Yes
  • No
• Additional Feedback

verticapy.performance.vertica.qprof_interface.QueryProfilerInterface.get_table

QueryProfilerInterface.get_table(table_name: str | None = None) → list | vDataFrame

Returns the associated Vertica Table. This function allows easy data exploration of all the performance meta-tables.

Parameters

table_name: str, optional

Vertica DC Table to return. If empty, the list of all the tables is returned to simplify the selection.

Examples:

• dc_requests_issued

• dc_query_executions

• dc_explain_plans

• query_plan_profiles

• query_profiles

• execution_engine_profiles

• resource_pool_status

• host_resources

Returns

vDataFrame

Vertica DC Table.

Examples

First, let’s import the QueryProfiler object.

from verticapy.performance.vertica import QueryProfiler

Then we can create a query:

qprof = QueryProfiler(
    "select transaction_id, statement_id, request, request_duration"
    " from query_requests where start_timestamp > now() - interval'1 hour'"
    " order by request_duration desc limit 10;"
)

We can easily look at any Vertica Performance Tables easily:

qprof.get_table('dc_requests_issued')

	📅 time Timestamptz(35)	Abc node_name Varchar(128)	Abc session_id Varchar(128)	123 user_id Integer	Abc user_name Varchar(128)	123 transaction_id Integer	123 statement_id Integer	123 request_id Integer	Abc request_type Varchar(128)	Abc label Varchar(128)	Abc Varchar(64000)	Abc Varchar(64000)	123 query_start_epoch Integer	Abc Varchar(64000)	010 is_retry Boolean	123 digest Integer
1	2024-03-14 18:08:14.442377+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	5	66190	QUERY				83306		❌	806487162735703196
2	2024-03-14 18:08:14.465958+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	6	66191	QUERY	_version			83306		❌	8903476768692993780
3	2024-03-14 18:08:14.485541+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	7	66192	QUERY				83306		❌	806487162735703196
4	2024-03-14 18:08:14.513034+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	8	66193	QUERY	_version			83306		❌	8903476768692993780
5	2024-03-14 18:08:14.533344+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	9	66194	QUERY				83306		❌	806487162735703196
6	2024-03-14 18:08:14.558524+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	10	66195	QUERY	_version			83306		❌	8903476768692993780
7	2024-03-14 18:08:14.580659+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	11	66196	QUERY				83306		❌	806487162735703196
8	2024-03-14 18:08:14.607386+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	12	66197	QUERY	_version			83306		❌	8903476768692993780
9	2024-03-14 18:08:14.626347+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	13	66198	QUERY				83306		❌	806487162735703196
10	2024-03-14 18:08:14.655108+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	14	66199	QUERY	_version			83306		❌	8903476768692993780
11	2024-03-14 18:08:14.675759+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	15	66200	QUERY				83306		❌	806487162735703196
12	2024-03-14 18:08:14.706953+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	16	66201	QUERY	_version			83306		❌	8903476768692993780
13	2024-03-14 18:08:14.727490+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	17	66202	QUERY				83306		❌	806487162735703196
14	2024-03-14 18:08:14.755884+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	18	66203	QUERY	_version			83306		❌	8903476768692993780
15	2024-03-14 18:08:14.776627+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	19	66204	QUERY				83306		❌	806487162735703196
16	2024-03-14 18:08:14.802138+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	20	66205	QUERY	_version			83306		❌	8903476768692993780
17	2024-03-14 18:08:14.823421+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	21	66206	QUERY				83306		❌	806487162735703196
18	2024-03-14 18:08:14.848783+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	22	66207	QUERY	_version			83306		❌	8903476768692993780
19	2024-03-14 18:08:14.867163+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	23	66208	QUERY	learn.VerticaModel.__repr__			83306		❌	-8887346284077529213
20	2024-03-14 18:08:14.964337+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	24	66209	QUERY	verticapy_json			83306		❌	-2739771977645684132
21	2024-03-14 18:08:14.983991+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	25	66210	QUERY	verticapy_json			83306		❌	-2739771977645684132
22	2024-03-14 18:08:15.003144+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	26	66211	QUERY				83306		❌	1173375758661070897
23	2024-03-14 18:08:15.030401+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	27	66212	QUERY	get_data_types			83306		❌	-6803372202362044141
24	2024-03-14 18:08:15.074542+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	28	66213	QUERY	verticapy_json			83306		❌	-2739771977645684132
25	2024-03-14 18:08:15.094655+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	29	66214	QUERY				83306		❌	7011138784295650856
26	2024-03-14 18:08:15.119530+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	30	66215	QUERY	learn.tools._is_already_stored			83306		❌	5835180282835082858
27	2024-03-14 18:08:15.153132+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	31	66216	QUERY				83306		❌	7011138784295650856
28	2024-03-14 18:08:15.173929+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	32	66217	QUERY				83306		❌	3109024326454217980
29	2024-03-14 18:08:15.220744+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	33	66218	QUERY	_version			83306		❌	8903476768692993780
30	2024-03-14 18:08:15.242456+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	34	66219	QUERY	verticapy_json			83306		❌	-2739771977645684132
31	2024-03-14 18:08:15.266791+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	35	66220	QUERY				83306		❌	6749285220492401136
32	2024-03-14 18:08:15.369751+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	36	66221	QUERY	verticapy_json			83306		❌	-2739771977645684132
33	2024-03-14 18:08:15.391335+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	37	66222	QUERY	verticapy_json			83306		❌	-2739771977645684132
34	2024-03-14 18:08:15.413806+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	38	66223	QUERY				83306		❌	1173375758661070897
35	2024-03-14 18:08:15.434886+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	39	66224	QUERY	get_data_types			83306		❌	-6803372202362044141
36	2024-03-14 18:08:15.468739+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	40	66225	QUERY	verticapy_json			83306		❌	-2739771977645684132
37	2024-03-14 18:08:15.489438+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	41	66226	QUERY	_version			83306		❌	8903476768692993780
38	2024-03-14 18:08:15.512750+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	42	66227	QUERY	vDataframe.train_test_split			83306		❌	5551329239234976887
39	2024-03-14 18:08:15.535806+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	43	66228	QUERY	verticapy_json			83306		❌	-2739771977645684132
40	2024-03-14 18:08:15.557237+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	44	66229	QUERY				83306		❌	-8884034717893991551
41	2024-03-14 18:08:15.583585+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	45	66230	QUERY	verticapy_json			83306		❌	-2739771977645684132
42	2024-03-14 18:08:15.602941+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	46	66231	QUERY				83306		❌	-1011520196416268869
43	2024-03-14 18:08:15.633132+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	47	66232	QUERY	verticapy_json			83306		❌	-2739771977645684132
44	2024-03-14 18:08:15.652513+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	48	66233	QUERY				83306		❌	7011138784295650856
45	2024-03-14 18:08:15.676953+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	49	66234	QUERY	learn.tools._is_already_stored			83306		❌	5835180282835082858
46	2024-03-14 18:08:15.709652+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	50	66235	QUERY				83306		❌	7011138784295650856
47	2024-03-14 18:08:15.732660+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	51	66236	QUERY				83306		❌	-4293459230001215180
48	2024-03-14 18:08:15.776958+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	52	66237	QUERY	verticapy_json			83306		❌	-2739771977645684132
49	2024-03-14 18:08:15.798542+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	53	66238	QUERY				83306		❌	4892056614916329937
50	2024-03-14 18:08:15.820171+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	54	66239	QUERY				83306		❌	-6494634706701554542
51	2024-03-14 18:08:15.887920+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	55	66240	QUERY	verticapy_json			83306		❌	-2739771977645684132
52	2024-03-14 18:08:15.908410+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	56	66241	QUERY	verticapy_json			83306		❌	-2739771977645684132
53	2024-03-14 18:08:15.927625+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	57	66242	QUERY				83306		❌	1173375758661070897
54	2024-03-14 18:08:15.949842+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	58	66243	QUERY	get_data_types			83306		❌	-6803372202362044141
55	2024-03-14 18:08:15.985830+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	59	66244	QUERY	verticapy_json			83306		❌	-2739771977645684132
56	2024-03-14 18:08:16.006242+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	60	66245	QUERY	_version			83306		❌	8903476768692993780
57	2024-03-14 18:08:16.026298+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	61	66246	QUERY	vDataframe.train_test_split			83306		❌	5551329239234976887
58	2024-03-14 18:08:16.052125+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	62	66247	QUERY	verticapy_json			83306		❌	-2739771977645684132
59	2024-03-14 18:08:16.074106+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	63	66248	QUERY				83306		❌	-8884034717893991551
60	2024-03-14 18:08:16.096516+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	64	66249	QUERY	verticapy_json			83306		❌	-2739771977645684132
61	2024-03-14 18:08:16.116088+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	65	66250	QUERY				83306		❌	-1011520196416268869
62	2024-03-14 18:08:16.147190+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	66	66251	QUERY	verticapy_json			83306		❌	-2739771977645684132
63	2024-03-14 18:08:16.167523+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	67	66252	QUERY				83306		❌	7011138784295650856
64	2024-03-14 18:08:16.192197+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	68	66253	QUERY	learn.tools._is_already_stored			83306		❌	5835180282835082858
65	2024-03-14 18:08:16.224842+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	69	66254	QUERY				83306		❌	7011138784295650856
66	2024-03-14 18:08:16.247963+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	70	66255	QUERY				83306		❌	-4293459230001215180
67	2024-03-14 18:08:16.293294+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	71	66256	QUERY	verticapy_json			83306		❌	-2739771977645684132
68	2024-03-14 18:08:16.313925+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	72	66257	QUERY				83306		❌	247689392616137863
69	2024-03-14 18:08:16.330427+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	73	66258	QUERY	verticapy_json			83306		❌	-2739771977645684132
70	2024-03-14 18:08:16.352269+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	74	66259	QUERY				83306		❌	-7645496191171572853
71	2024-03-14 18:08:16.370868+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	75	66260	QUERY	verticapy_json			83306		❌	-2739771977645684132
72	2024-03-14 18:08:16.394503+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	76	66261	QUERY				83306		❌	2497958035241366679
73	2024-03-14 18:08:16.419120+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	77	66262	QUERY				83306		❌	2641900196224620659
74	2024-03-14 18:08:16.530099+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	78	66263	QUERY	verticapy_json			83306		❌	-2739771977645684132
75	2024-03-14 18:08:16.550386+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	79	66264	QUERY	verticapy_json			83306		❌	-2739771977645684132
76	2024-03-14 18:08:16.569549+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	80	66265	QUERY				83306		❌	1173375758661070897
77	2024-03-14 18:08:16.591070+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	81	66266	QUERY	get_data_types			83306		❌	-6803372202362044141
78	2024-03-14 18:08:16.621965+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	82	66267	QUERY	verticapy_json			83306		❌	-2739771977645684132
79	2024-03-14 18:08:16.643345+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	83	66268	QUERY	_version			83306		❌	8903476768692993780
80	2024-03-14 18:08:16.663228+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	84	66269	QUERY	vDataframe.train_test_split			83306		❌	5551329239234976887
81	2024-03-14 18:08:16.686826+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	85	66270	QUERY	verticapy_json			83306		❌	-2739771977645684132
82	2024-03-14 18:08:16.706219+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	86	66271	QUERY				83306		❌	-8884034717893991551
83	2024-03-14 18:08:16.730863+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	87	66272	QUERY	verticapy_json			83306		❌	-2739771977645684132
84	2024-03-14 18:08:16.749452+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	88	66273	QUERY				83306		❌	-1011520196416268869
85	2024-03-14 18:08:16.787786+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	89	66274	QUERY	verticapy_json			83306		❌	-2739771977645684132
86	2024-03-14 18:08:16.808948+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	90	66275	QUERY				83306		❌	7011138784295650856
87	2024-03-14 18:08:16.833553+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	91	66276	QUERY	learn.tools._is_already_stored			83306		❌	5835180282835082858
88	2024-03-14 18:08:16.865485+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	92	66277	QUERY				83306		❌	7011138784295650856
89	2024-03-14 18:08:16.888262+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	93	66278	QUERY				83306		❌	-4293459230001215180
90	2024-03-14 18:08:16.936651+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	94	66279	QUERY	verticapy_json			83306		❌	-2739771977645684132
91	2024-03-14 18:08:16.956804+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	95	66280	QUERY	_version			83306		❌	8903476768692993780
92	2024-03-14 18:08:16.978326+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	96	66281	QUERY	verticapy_json			83306		❌	-2739771977645684132
93	2024-03-14 18:08:17.002317+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	97	66282	QUERY				83306		❌	-125179491804461608
94	2024-03-14 18:08:17.033710+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	98	66283	QUERY	verticapy_json			83306		❌	-2739771977645684132
95	2024-03-14 18:08:17.056041+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	99	66284	QUERY	verticapy_json			83306		❌	-2739771977645684132
96	2024-03-14 18:08:17.078710+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	100	66285	QUERY				83306		❌	-1991255985308434521
97	2024-03-14 18:08:17.177648+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	101	66286	QUERY	verticapy_json			83306		❌	-2739771977645684132
98	2024-03-14 18:08:17.198292+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	102	66287	QUERY	verticapy_json			83306		❌	-2739771977645684132
99	2024-03-14 18:08:17.219421+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	103	66288	QUERY				83306		❌	3791173225426651648
100	2024-03-14 18:08:17.273144+00:00	v_demo_node0001	v_demo_node0001-144:0xbe	45035996273704962	dbadmin	45035996274860006	104	66289	QUERY	verticapy_json			83306		❌	-2739771977645684132

Rows: 1-100 | Columns: 16

Note

For more details, please look at QueryProfiler.