Real-time top 10 slow queries (last 10 minutes) - Updated: 12/7/2025 9:28:08 AM
|
| Query |
Last Time (ms) |
Min Time (ms) |
Max Time (ms) |
SELECT TOP 1
tnx_id FROM tbl_tallybox_book_a
rchive_1 WHERE tally_hash_dag='3
0cef6454992a191dfe646ef6ebb45e67
a8766d05b8cdd922e3a5dc4a7ebfad5'
|
0.297 |
0.297 |
0.540 |
SELECT TOP 1
tnx_id FROM tbl_tallybox_book_a
rchive_1 WHERE tally_hash_dag='4
7e8e509c8af263da4da1ed2b9c2ff440
dd60d297325a93c217c551ab4c30f4a'
|
0.292 |
0.265 |
0.510 |
SELECT TOP 1
tnx_id FROM tbl_tallybox_book_a
rchive_1 WHERE tally_hash_dag='1
e9d3775b06c7da878f67dff8a2d4e500
d01418844b7c53169512a90fa0175a9'
|
0.282 |
0.277 |
0.497 |
S
ELECT TOP(10) * FROM tbl_system_
treasury ORDER BY local_utc_unix
|
0.103 |
0.063 |
0.584 |
SELECT * FROM tbl_tally
box_book_archive_1 where tnx_id=
'1742065121.1' order by tnx_type
|
0.095 |
0.070 |
0.121 |
SELECT tree_id,tnx_id
,order_id FROM tbl_tallybox_sign
_archive_1 ORDER BY tnx_id OFFSE
T 0 ROWS FETCH NEXT 10 ROWS ONLY
|
0.088 |
0.069 |
0.110 |
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.073 |
0.071 |
0.118 |
SELECT TOP 1 tnx_id FR
OM tbl_tallybox_sign_buffer WHER
E archive_id='1' order by tnx_id
|
0.065 |
0.028 |
0.181 |
SELECT TOP 1 tnx_id FR
OM tbl_tallybox_sign_buffer WHER
E archive_id='2' order by tnx_id
|
0.062 |
0.017 |
0.213 |
SELECT the_
sign FROM tbl_order_dispatcher_2
|
0.058 |
0.017 |
8.649 |
Real-time top 10 quick queries (last 10 seconds) - Updated: 12/7/2025 9:28:08 AM
|
| Query |
Last Time (ms) |
Min Time (ms) |
Max Time (ms) |
SELECT the_
sign FROM tbl_order_dispatcher_3
|
0.028 |
0.016 |
3.612 |
SELECT the_
sign FROM tbl_order_dispatcher_7
|
0.030 |
0.016 |
0.354 |
SELECT the_
sign FROM tbl_order_dispatcher_8
|
0.030 |
0.015 |
0.980 |
SELECT the_
sign FROM tbl_order_dispatcher_4
|
0.030 |
0.017 |
15.294 |
(@1 varchar(8
000))SELECT [tnx_id] FROM [tbl_t
allybox_sign_buffer] WHERE [arch
ive_id]=@1 ORDER BY [tnx_id] ASC
|
0.030 |
0.014 |
27.890 |
SELECT the_
sign FROM tbl_order_dispatcher_1
|
0.030 |
0.015 |
0.559 |
SELECT the_
sign FROM tbl_order_dispatcher_0
|
0.031 |
0.014 |
5.122 |
SELECT the_
sign FROM tbl_order_dispatcher_6
|
0.032 |
0.016 |
0.376 |
SELECT the_
sign FROM tbl_order_dispatcher_9
|
0.034 |
0.016 |
10.487 |
SELECT the_
sign FROM tbl_order_dispatcher_5
|
0.036 |
0.017 |
4.898 |