Real-time top 10 slow queries (last 10 minutes) - Updated: 5/9/2025 11:00:52 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
160 ROWS FETCH NEXT 10 ROWS ONLY
|
0.134 |
0.112 |
0.775 |
S
ELECT TOP(10) * FROM tbl_system_
treasury ORDER BY local_utc_unix
|
0.131 |
0.058 |
13.602 |
SELECT TOP 1 tnx_id FR
OM tbl_tallybox_sign_buffer WHER
E archive_id='2' order by tnx_id
|
0.097 |
0.023 |
115.986 |
SELECT TOP 1 tnx_id FR
OM tbl_tallybox_sign_buffer WHER
E archive_id='1' order by tnx_id
|
0.091 |
0.025 |
9.841 |
SELECT the_
sign FROM tbl_order_dispatcher_1
|
0.088 |
0.015 |
299.665 |
SELECT TOP 1
tnx_id FROM tbl_tallybox_book_a
rchive_1 WHERE tally_hash_dag='1
87b984ced93e9e0cf178531409814448
dd123c8a34528a11201d8d2e56d9808'
|
0.066 |
0.044 |
0.070 |
SELECT TOP 1
tnx_id FROM tbl_tallybox_book_a
rchive_1 WHERE tally_hash_dag='9
de70fafbdd90a2524be2389c99b5a4e0
efd07f2f1070dd816aeb782091f5416'
|
0.060 |
0.059 |
0.064 |
SELECT the_
sign FROM tbl_order_dispatcher_9
|
0.055 |
0.015 |
320.553 |
SELECT TOP 1
tnx_id FROM tbl_tallybox_book_a
rchive_1 WHERE tally_hash_dag='3
ec40fdf7f7d8827bd32068a8a71111f1
259a276b43f8d217ec59082662498f8'
|
0.050 |
0.050 |
0.053 |
SELECT the_
sign FROM tbl_order_dispatcher_3
|
0.050 |
0.015 |
81.477 |
Real-time top 10 quick queries (last 10 seconds) - Updated: 5/9/2025 11:00:52 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.036 |
0.021 |
497.915 |
SELECT the_
sign FROM tbl_order_dispatcher_2
|
0.039 |
0.015 |
262.682 |
SELECT the_
sign FROM tbl_order_dispatcher_0
|
0.042 |
0.016 |
233.967 |
SELECT the_
sign FROM tbl_order_dispatcher_7
|
0.044 |
0.015 |
342.156 |
SELECT the_
sign FROM tbl_order_dispatcher_8
|
0.044 |
0.014 |
124.173 |
SELECT the_
sign FROM tbl_order_dispatcher_4
|
0.044 |
0.014 |
457.904 |
SELECT the_
sign FROM tbl_order_dispatcher_6
|
0.048 |
0.015 |
430.753 |
SELECT the_
sign FROM tbl_order_dispatcher_5
|
0.050 |
0.015 |
100.080 |
SELECT the_
sign FROM tbl_order_dispatcher_3
|
0.050 |
0.015 |
81.477 |
SELECT the_
sign FROM tbl_order_dispatcher_9
|
0.055 |
0.015 |
320.553 |