Skip to content

Instantly share code, notes, and snippets.

@lfdversluis
Created August 14, 2016 13:23
Show Gist options
  • Save lfdversluis/00b27126b9eb0ef4c89101198463ceae to your computer and use it in GitHub Desktop.
Save lfdversluis/00b27126b9eb0ef4c89101198463ceae to your computer and use it in GitHub Desktop.
2016-08-14 Dispersy empty state dir query output
------- commit --------
Times called: 69
total time: 2.758 seconds
avg: 0.03998
min: 0.00000
max: 0.21891
Total amount of functions calling this db function: 10
Top 5 callers issuing the heaviest query:
(218 ms) Function _flush_database at /home/tribler/Documents/tribler/Tribler/dispersy/dispersy.py line 2089
(204 ms) Function _flush_database at /home/tribler/Documents/tribler/Tribler/dispersy/dispersy.py line 2089
(198 ms) Function _flush_database at /home/tribler/Documents/tribler/Tribler/dispersy/dispersy.py line 2089
(186 ms) Function _flush_database at /home/tribler/Documents/tribler/Tribler/dispersy/dispersy.py line 2089
(169 ms) Function _flush_database at /home/tribler/Documents/tribler/Tribler/dispersy/dispersy.py line 2089
-----------------
------- execute --------
Times called: 741633
total time: 29.300 seconds
avg: 0.00004
min: 0.00000
max: 0.14197
Total amount of functions calling this db function: 44
Top 5 callers issuing the heaviest query:
(141 ms) Function get_member at /home/tribler/Documents/tribler/Tribler/dispersy/community.py line 1860
(16 ms) Function check_undo at /home/tribler/Documents/tribler/Tribler/dispersy/community.py line 3370
(13 ms) Function initialize at /home/tribler/Documents/tribler/Tribler/dispersy/community.py line 388
(12 ms) Function get_member at /home/tribler/Documents/tribler/Tribler/dispersy/dispersy.py line 492
(11 ms) Function get_member at /home/tribler/Documents/tribler/Tribler/dispersy/dispersy.py line 492
-----------------
------- executemany --------
Times called: 6781
total time: 0.309 seconds
avg: 0.00005
min: 0.00001
max: 0.01387
Total amount of functions calling this db function: 9
Top 5 callers issuing the heaviest query:
(13 ms) Function on_undo at /home/tribler/Documents/tribler/Tribler/dispersy/community.py line 3476
(9 ms) Function initialize at /home/tribler/Documents/tribler/Tribler/dispersy/community.py line 374
(3 ms) Function initialize at /home/tribler/Documents/tribler/Tribler/dispersy/community.py line 374
(1 ms) Function initialize at /home/tribler/Documents/tribler/Tribler/dispersy/community.py line 374
(1 ms) Function initialize at /home/tribler/Documents/tribler/Tribler/dispersy/community.py line 374
-----------------
------- executescript --------
Times called: 3
total time: 0.000 seconds
avg: 0.00001
min: 0.00001
max: 0.00001
Total amount of functions calling this db function: 8
Top 5 callers issuing the heaviest query:
(0 ms) Function check_database at /home/tribler/Documents/tribler/Tribler/dispersy/dispersydatabase.py line 83
(0 ms) Function check_database at /home/tribler/Documents/tribler/Tribler/community/multichain/database.py line 297
(0 ms) Function check_database at /home/tribler/Documents/tribler/Tribler/community/multichain/database.py line 298
-----------------
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment