Real-time top 10 slow queries (last 10 minutes) - Updated: 6/25/2025 8:22:44 PM
|
| Query |
Last Time (ms) |
Min Time (ms) |
Max Time (ms) |
SELECT tree_id,tnx_id,o
rder_id FROM tbl_tallybox_sign_a
rchive_1 ORDER BY tnx_id OFFSET
120 ROWS FETCH NEXT 10 ROWS ONLY
|
0.241 |
0.241 |
0.241 |
SELECT tree_id,tnx_id,o
rder_id FROM tbl_tallybox_sign_a
rchive_1 ORDER BY tnx_id OFFSET
140 ROWS FETCH NEXT 10 ROWS ONLY
|
0.204 |
0.204 |
0.204 |
SELECT tree_id,tnx_id,o
rder_id FROM tbl_tallybox_sign_a
rchive_1 ORDER BY tnx_id OFFSET
130 ROWS FETCH NEXT 10 ROWS ONLY
|
0.180 |
0.142 |
0.403 |
SELECT tree_id,tnx_id,
order_id FROM tbl_tallybox_sign_
archive_1 ORDER BY tnx_id OFFSET
20 ROWS FETCH NEXT 10 ROWS ONLY
|
0.164 |
0.164 |
0.241 |
SELECT * FROM tbl_tally
box_book_archive_1 where tnx_id=
'1745914116.1' order by tnx_type
|
0.142 |
0.142 |
0.142 |
SELECT tree_id,tnx_id,o
rder_id FROM tbl_tallybox_sign_a
rchive_1 ORDER BY tnx_id OFFSET
160 ROWS FETCH NEXT 10 ROWS ONLY
|
0.139 |
0.139 |
0.760 |
(@1 varchar(800
0))SELECT * FROM [tbl_tallybox_s
ign_archive_1] WHERE [tnx_id]=@1
|
0.135 |
0.029 |
2.670 |
SELECT TOP 1 tnx_id FR
OM tbl_tallybox_sign_buffer WHER
E archive_id='2' order by tnx_id
|
0.122 |
0.031 |
58.289 |
SELECT TOP 1 tnx_id FR
OM tbl_tallybox_sign_buffer WHER
E archive_id='1' order by tnx_id
|
0.096 |
0.065 |
0.355 |
(@1 varchar(8000))SELECT [row_c
ount] FROM [dbo].[tbl_optimize_r
ow_counts] WHERE [table_name]=@1
|
0.072 |
0.028 |
0.356 |
Real-time top 10 quick queries (last 10 seconds) - Updated: 6/25/2025 8:22:44 PM
|
| Query |
Last Time (ms) |
Min Time (ms) |
Max Time (ms) |
(@1 varchar(8
000))SELECT [tnx_id] FROM [tbl_t
allybox_sign_buffer] WHERE [arch
ive_id]=@1 ORDER BY [tnx_id] ASC
|
0.037 |
0.020 |
191.155 |
SELECT TOP 1 th
e_wallet FROM tbl_tallybox_walle
t_archive_1 WHERE wallet_id='31'
|
0.039 |
0.039 |
0.063 |
SELECT the_
sign FROM tbl_order_dispatcher_9
|
0.042 |
0.028 |
5.281 |
SELECT the_
sign FROM tbl_order_dispatcher_6
|
0.045 |
0.025 |
76.331 |
SELECT the_
sign FROM tbl_order_dispatcher_2
|
0.047 |
0.027 |
29.831 |
SELECT the_
sign FROM tbl_order_dispatcher_4
|
0.050 |
0.027 |
51.784 |
SE
LECT TOP 1 graph_domain FROM tbl
_system_graph WHERE graph_id='1'
|
0.050 |
0.028 |
0.912 |
SELECT the_
sign FROM tbl_order_dispatcher_0
|
0.052 |
0.026 |
10.003 |
SELECT the_
sign FROM tbl_order_dispatcher_5
|
0.056 |
0.019 |
75.092 |
SELECT the_
sign FROM tbl_order_dispatcher_8
|
0.057 |
0.026 |
16.187 |