Skip to content

Instantly share code, notes, and snippets.

@tuttle

tuttle/gist:354eb616a02e568068b6eb1696424bb5

Created October 4, 2024 23:04
Show Gist options
  • Save tuttle/354eb616a02e568068b6eb1696424bb5 to your computer and use it in GitHub Desktop.
Save tuttle/354eb616a02e568068b6eb1696424bb5 to your computer and use it in GitHub Desktop.
Download ZIP
mgmt cmd list_table_sizes
Raw
gistfile1.txt
Protože se nam začíná plnit na serveru parcela s databaází,
vyrobil jsem (s pomocí GPT) command pro přehled o velikosti databáze Leady po tabulkách a jejich indexech
vč. odhadu toho, kolik zabírají tzn. dead rows.
Hodlal jsem pustit nějakou údržbu db. Na začátku:
Table Name Table (MiB) Index (MiB) Rows Dead Tuples Dead % Indexes Last Vacuum Last Analyze
----------------------------------------------------------------------------------------------------------------------------------------------------------
people_event 22506 8318 98356997 671439 0.7% 6 N/A 2022-09-10 22:37
actions_action_p0 12184 3870 126693587 895446 0.7% 2 N/A 2022-09-10 22:47
actions_action_p1 8142 2237 68612941 3510439 4.9% 2 N/A 2022-09-10 22:55
leads_externalcompanydata 6797 954 10284952 0 0.0% 3 N/A 2022-09-10 22:52
people_person 5195 1267 6490552 157541 2.4% 4 N/A 2022-09-10 23:01
actions_action_p14 3936 1554 41995886 2398304 5.4% 2 N/A 2022-09-10 23:09
actions_action_p11 3990 1323 40505067 1643244 3.9% 2 N/A 2022-09-10 23:08
actions_action_p8 3782 1410 39025801 2467364 5.9% 2 N/A 2022-09-10 23:03
actions_action_p2 3568 1384 41313782 1882819 4.4% 2 N/A 2022-09-10 22:59
actions_action_p5 3405 1116 33917132 964626 2.8% 2 N/A 2022-09-10 22:57
actions_action_p3 3028 1119 31177226 1710502 5.2% 2 N/A 2022-09-10 23:04
actions_action_p6 2624 953 29917712 403456 1.3% 2 N/A 2022-09-10 23:17
actions_action_p9 2554 981 26744410 1205066 4.3% 2 N/A 2022-09-10 23:14
actions_action_p7 2190 905 26072792 570135 2.1% 2 N/A 2022-09-10 23:12
actions_action_p4 2191 812 23136631 801611 3.3% 2 N/A 2022-09-10 23:13
actions_action_p12 2294 673 20020114 497305 2.4% 2 N/A 2022-09-10 23:06
actions_action_p15 2050 727 21935753 331060 1.5% 2 N/A 2022-09-10 23:10
actions_webhookfire 2639 42 1333756 28610 2.1% 2 N/A 2022-09-10 23:18
actions_action_p13 1914 731 20578181 955907 4.4% 2 N/A 2022-09-10 23:16
common_temporaryjsonstorage 2404 23 1061786 0 0.0% 1 N/A N/A
actions_session_p14 1537 725 12958840 1359911 9.5% 2 N/A 2022-09-10 23:21
actions_session_p0 1440 744 13920620 762568 5.2% 2 N/A 2022-09-10 23:15
integrations_pipedriveorganization_reflead_suggestions 886 1279 20912000 13116 0.1% 4 N/A 2022-09-10 23:16
actions_useragent 618 1415 2900177 323 0.0% 3 N/A 2022-09-10 23:24
actions_action_p10 1446 492 14381316 478730 3.2% 2 N/A 2022-09-10 23:18
actions_session_p8 1119 573 10072311 851493 7.8% 2 N/A 2022-09-10 23:26
actions_session_p7 1043 465 8755119 254501 2.8% 2 N/A 2022-09-10 23:19
actions_session_p1 999 500 8269435 1315837 13.7% 2 N/A 2022-09-10 23:25
actions_session_p9 996 474 8771950 491546 5.3% 2 N/A 2022-09-10 23:21
actions_session_p3 955 478 8908470 528327 5.6% 2 N/A 2022-09-10 23:19
actions_session_p2 898 450 8303686 449298 5.1% 2 N/A 2022-09-10 23:20
actions_path_p1 436 899 5751038 5565 0.1% 3 N/A 2022-09-10 23:30
actions_session_p5 711 342 6261073 399064 6.0% 2 N/A 2022-09-10 23:22
actions_session_p11 670 341 6254843 225132 3.5% 2 N/A 2022-09-10 23:27
people_namesearch 396 580 7910860 102153 1.3% 5 N/A N/A
actions_session_p13 641 323 5484498 589676 9.7% 2 N/A 2022-09-10 23:27
actions_session_p6 647 303 5689464 171176 2.9% 2 N/A 2022-09-10 23:27
actions_path_p7 314 633 3652634 10 0.0% 3 N/A 2022-09-10 23:29
actions_session_p4 621 308 5671498 265293 4.5% 2 N/A 2022-09-10 23:26
leads_reflead 552 372 4365146 324069 6.9% 8 N/A 2022-09-10 23:22
actions_session_p15 618 277 5199214 171434 3.2% 2 N/A 2022-09-10 23:24
actions_session_p12 577 279 5076770 93548 1.8% 2 N/A 2022-09-10 23:27
leads_extra 812 19 810483 11 0.0% 1 N/A 2022-09-10 23:22
visits_leadcounter 358 420 7016583 90531 1.3% 3 N/A 2022-09-10 23:28
actions_url_p1 339 344 5890474 5254 0.1% 3 N/A 2022-09-10 23:32
actions_session_p10 412 205 3814249 117389 3.0% 2 N/A 2022-09-10 23:29
actions_path_p13 203 404 2879034 126 0.0% 3 N/A 2022-09-10 23:31
actions_path_p4 196 410 1881283 139 0.0% 3 N/A 2022-09-10 23:31
integrations_pipedriveactivity 367 194 2341838 204095 8.0% 6 N/A 2022-09-10 23:30
actions_path_p8 174 367 2234982 583 0.0% 3 N/A 2022-09-10 23:35
integrations_pipedriveorganization 226 278 1948777 91767 4.5% 8 N/A 2022-09-10 23:33
crm_labelactivity 284 215 3360421 95585 2.8% 6 N/A 2022-09-10 23:35
actions_path_p14 150 332 1546803 921 0.1% 3 N/A 2022-09-10 23:36
actions_sessionlookup_p0 169 294 3390270 17 0.0% 6 N/A 2022-09-10 23:32
crm_leadpersonlabel 166 279 2748081 94903 3.3% 6 N/A 2022-09-10 23:38
actions_url_p7 211 214 3665084 11 0.0% 3 N/A 2022-09-10 23:31
actions_path_p0 139 281 1847499 195 0.0% 3 N/A 2022-09-10 23:34
actions_path_p2 135 277 1547216 242 0.0% 3 N/A 2022-09-10 23:34
actions_path_p5 123 257 1412413 56 0.0% 3 N/A 2022-09-10 23:35
people_uniqid 187 191 3751563 1635 0.0% 2 N/A 2022-09-10 23:32
li_extra_data_backup 374 0 394490 0 0.0% 0 N/A 2022-09-10 23:29
actions_url_p13 173 176 3001789 127 0.0% 3 N/A 2022-09-10 23:33
actions_sid_p8 119 208 1892526 308381 14.0% 2 N/A 2023-09-14 18:49
actions_path_p6 106 220 1148692 261 0.0% 3 N/A 2022-09-10 23:36
leads_iprange 211 107 4954159 0 0.0% 1 N/A 2022-09-10 23:29
leads_outsourcedorganizationdata 185 132 302294 16067 5.0% 9 N/A 2022-09-10 23:39
actions_path_p11 100 211 1117128 318 0.0% 3 N/A 2022-09-10 23:37
people_useragentstring 95 215 481514 8056 1.6% 3 N/A 2022-09-10 23:37
actions_path_p3 88 196 1055336 605 0.1% 3 N/A 2022-09-10 23:38
actions_path_p15 92 186 1089213 2 0.0% 3 N/A 2022-09-10 23:37
actions_url_p8 137 140 2383610 599 0.0% 3 N/A 2022-09-10 23:36
accounts_exportqueue 221 51 679660 3176 0.5% 5 N/A 2022-09-10 23:33
actions_sid_p1 109 152 2002066 213234 9.6% 2 N/A 2023-09-14 18:45
actions_sid_p14 103 148 1921286 153033 7.4% 2 N/A 2023-09-14 18:51
actions_path_p10 82 166 1027865 282 0.0% 3 N/A 2022-09-10 23:38
actions_url_p4 116 118 2012425 139 0.0% 3 N/A 2022-09-10 23:35
actions_url_p0 115 118 2002924 243 0.0% 3 N/A 2022-09-10 23:36
actions_path_p12 73 150 884705 79 0.0% 3 N/A 2022-09-10 23:38
actions_rescanidentify 135 77 1395327 152990 9.9% 2 N/A 2023-09-14 19:02
actions_path_p9 65 138 723785 18 0.0% 3 N/A 2022-09-10 23:39
actions_subjectlastsession_p8 132 65 1028109 96399 8.6% 3 N/A N/A
actions_sid_p9 103 94 933106 39731 4.1% 2 N/A 2023-09-14 18:49
actions_sessionlookup_p14 71 126 1422422 90 0.0% 6 N/A 2022-09-10 23:40
actions_url_p14 96 98 1660504 741 0.0% 3 N/A 2022-09-10 23:38
actions_url_p2 95 97 1645496 243 0.0% 3 N/A 2022-09-10 23:37
actions_sid_p13 75 116 1274737 45874 3.5% 2 N/A 2023-09-14 18:51
actions_sid_p11 83 108 910330 164228 15.3% 2 N/A 2023-09-14 18:50
actions_sessionlookup_p9 67 118 1342650 1426 0.1% 6 N/A 2022-09-10 23:40
actions_sid_p0 72 108 1394783 50419 3.5% 2 N/A 2023-09-14 18:44
actions_url_p5 87 90 1520150 60 0.0% 3 N/A 2022-09-10 23:37
integrations_pipedrivedeal 106 68 790928 37667 4.5% 5 N/A 2022-09-10 23:37
actions_sid_p3 65 104 879179 172460 16.4% 2 N/A 2023-09-14 18:47
actions_subjectlastsession_p14 112 54 862345 88515 9.3% 3 N/A N/A
actions_subjectlastsession_p11 112 51 841648 74560 8.1% 3 N/A N/A
accounts_loginlog 145 18 597608 0 0.0% 2 N/A 2022-09-10 23:34
actions_subjectlastsession_p1 120 40 639987 124950 16.3% 3 N/A N/A
actions_subjectlastsession_p2 103 55 887452 56181 6.0% 3 N/A N/A
actions_sid_p7 62 91 650510 40462 5.9% 2 N/A 2023-09-14 18:48
actions_subjectlastsession_p5 93 57 934230 41620 4.3% 3 N/A N/A
actions_sessionlookupstring 49 101 773554 126 0.0% 3 N/A 2022-09-10 23:39
actions_subjectlastsession_p9 100 48 769520 82317 9.7% 3 N/A N/A
actions_url_p15 73 75 1269011 2 0.0% 3 N/A 2022-09-10 23:38
actions_sid_p12 64 82 877735 90612 9.4% 2 N/A 2023-09-14 18:50
actions_url_p6 72 74 1255223 263 0.0% 3 N/A 2022-09-10 23:39
actions_sid_p2 51 90 812757 131699 13.9% 2 N/A 2023-09-14 18:45
actions_subjectlastsession_p3 93 45 727251 69821 8.8% 3 N/A N/A
actions_subjectlastsession_p4 85 53 855143 42255 4.7% 3 N/A N/A
actions_url_p11 68 70 1179802 352 0.0% 3 N/A 2022-09-10 23:39
actions_subjectlastsession_p6 88 48 779125 43737 5.3% 3 N/A N/A
actions_subjectlastsession_p13 89 46 739863 60994 7.6% 3 N/A N/A
actions_url_p3 65 67 1137312 986 0.1% 3 N/A 2022-09-10 23:39
actions_url_p10 64 65 1107966 188 0.0% 3 N/A 2022-09-10 23:39
actions_subjectlastsession_p7 78 46 747036 43999 5.6% 3 N/A N/A
actions_subjectlastsession_p0 77 41 668556 45665 6.4% 3 N/A N/A
actions_sessionlookup_p15 43 75 854866 23 0.0% 6 N/A 2022-09-10 23:40
actions_subjectlastsession_p15 72 42 677281 36796 5.2% 3 N/A N/A
actions_sid_p6 51 63 539558 52773 8.9% 2 N/A 2023-09-14 18:48
actions_sessionlookup_p5 41 72 814402 15 0.0% 6 N/A 2022-09-10 23:40
actions_url_p12 56 57 965888 79 0.0% 3 N/A 2022-09-10 23:39
actions_subjectlastsession_p12 72 38 620633 48839 7.3% 3 N/A N/A
actions_subjectlastsession_p10 67 43 687113 30429 4.2% 3 N/A N/A
actions_sessionlookup_p8 38 68 759966 45 0.0% 6 N/A 2022-09-10 23:40
actions_sid_p4 37 64 651092 46817 6.7% 2 N/A 2023-09-14 18:47
actions_url_p9 47 49 820916 33 0.0% 3 N/A 2022-09-10 23:39
actions_netloc 32 63 467649 37 0.0% 3 N/A 2022-09-10 23:40
actions_sessionlookup_p11 33 59 661756 27 0.0% 6 N/A 2022-09-10 23:40
actions_sid_p5 36 56 646559 0 0.0% 2 N/A 2023-09-14 18:48
django_admin_log 81 10 266111 30 0.0% 3 N/A 2022-09-10 23:40
leads_refleadoutsourcedorganization 34 47 587802 0 0.0% 4 N/A 2022-09-10 23:40
accounts_meter 74 6 299258 5 0.0% 1 N/A 2022-09-10 23:39
actions_sid_p10 30 50 416390 63808 13.3% 2 N/A 2023-09-14 18:50
actions_sid_p15 37 42 440709 76732 14.8% 2 N/A 2023-09-14 18:52
actions_sessionlookup_p6 28 50 562253 22 0.0% 6 N/A 2022-09-10 23:40
leads_refleadtoexternalcompanydata 37 41 525240 0 0.0% 4 N/A 2022-09-10 23:39
actions_sessionlookup_p2 26 46 515277 24 0.0% 6 N/A 2022-09-10 23:40
leads_ipaddress 32 35 513612 5960 1.1% 3 N/A 2022-09-10 23:40
actions_sessionlookup_p13 24 43 478537 20 0.0% 6 N/A 2022-09-10 23:40
actions_sessionlookup_p10 22 39 439146 14 0.0% 6 N/A 2022-09-10 23:40
actions_sessionlookup_p7 20 35 397167 12 0.0% 6 N/A 2022-09-10 23:40
actions_sessionlookup_p3 19 34 383843 23 0.0% 6 N/A 2022-09-10 23:40
actions_sessionlookup_p4 19 34 378280 42 0.0% 6 N/A 2022-09-10 23:40
actions_sessionlookup_p1 17 31 344692 34 0.0% 6 N/A 2022-09-10 23:40
crm_leadactivity 34 14 284367 43 0.0% 3 N/A 2022-09-10 23:40
leads_refleadlastupdate 30 12 376606 5456 1.4% 1 N/A 2022-09-10 23:40
actions_sessionlookup_p12 15 27 296051 8 0.0% 6 N/A 2022-09-10 23:40
leads_blacklist 20 13 237677 2150 0.9% 5 N/A 2022-09-10 23:40
accounts_userprofile 13 13 38682 2022 5.0% 9 N/A 2022-09-10 23:40
leads_refleadchangehistory 19 6 110091 0 0.0% 3 N/A 2022-09-10 23:40
accounts_freemail 10 13 143635 0 0.0% 3 N/A 2022-09-10 23:40
actions_collidingidentify 14 8 275506 19 0.0% 2 N/A 2022-09-10 23:40
leads_cufrequestlog 11 8 119396 0 0.0% 3 N/A 2022-09-10 23:40
crm_leadcontactedstatus 11 7 164216 745 0.5% 2 N/A 2022-09-10 23:40
leads_zipcode 8 9 192919 0 0.0% 2 N/A 2022-09-10 23:40
leads_city 6 7 138301 0 0.0% 2 N/A 2022-09-10 23:40
integrations_pipedrivewebhookqueue 9 3 37 24 39.3% 2 N/A 2022-09-10 23:40
leads_inetnumobject 7 6 48558 0 0.0% 7 N/A N/A
accounts_website 5 6 26248 607 2.3% 7 N/A 2022-09-10 23:40
accounts_website_territories 4 7 96445 69 0.1% 4 N/A 2022-09-10 23:40
notifications_notification 5 5 79868 155 0.2% 4 N/A 2022-09-10 23:40
accounts_regemail 5 4 58134 129 0.2% 3 N/A 2022-09-10 23:40
invoices_fakturoidinvoice 6 2 40037 6347 13.7% 3 N/A N/A
accounts_savedfilter 6 2 15360 204 1.3% 4 N/A 2022-09-10 23:40
accounts_registrationlog 7 1 27329 0 0.0% 1 N/A 2022-09-10 23:40
accounts_emailreport 3 4 14859 3 0.0% 5 N/A 2022-09-10 23:40
leads_adformexport 7 0 75 2 2.6% 1 N/A 2022-09-10 23:40
auth_user 5 2 23698 0 0.0% 2 N/A 2022-09-10 23:40
leads_ispcheckqueue 2 4 35370 0 0.0% 8 N/A 2022-09-10 23:40
invoices_fakturoidinvoice_tags 2 3 25760 4921 16.0% 4 N/A N/A
leads_inetnumnetname 2 2 27755 0 0.0% 4 N/A N/A
django_session 3 1 7454 821 9.9% 2 N/A 2022-09-10 23:40
impersonate_impersonationlog 2 1 23682 62 0.3% 3 N/A 2022-09-10 23:40
invoices_fakturoidsubject_assigned_users 1 2 10209 135 1.3% 4 N/A N/A
crm_idealcustomerprofile_ideal_industries 1 1 21739 133 0.6% 4 N/A N/A
accounts_websiteaccess 1 1 14508 99 0.7% 4 N/A 2022-09-10 23:40
leads_industry 1 1 8969 0 0.0% 3 N/A 2022-09-10 23:40
----------------------------------------------------------------------------------------------------------------------------------------------------------
TOTALS (including the <1MiB omitted above) 127180 54540 1023871185 33545204 754
To znamená BTW víc než miliardu db řádků v Leady.
Součet prvních dvou totals odpovídá velikosti 177 GB, kterou ukazoval příkaz \l+ v psql.
Po provedení REINDEX DATABASE klesla velikost indexů na 51134 MiB s odpovídajícím poklesem čísla v \l+
VACUUM FULL VERBOSE ANALYZE byl logicky mnohem delší. Po jeho provedení ukazuje \l+ 168 GB a tabulka vypadá takto:
Table Name Table (MiB) Index (MiB) Rows Dead Tuples Dead % Indexes Last Vacuum Last Analyze
----------------------------------------------------------------------------------------------------------------------------------------------------------
people_event 22116 8164 99102510 0 0.0% 6 N/A 2024-10-05 00:32
actions_action_p0 12093 3833 127232750 84 0.0% 2 N/A 2024-10-04 22:28
actions_action_p1 7825 2077 68769967 263 0.0% 2 N/A 2024-10-04 23:50
leads_externalcompanydata 6798 954 10237574 0 0.0% 3 N/A 2024-10-04 23:36
actions_action_p14 3735 1417 42050982 610 0.0% 2 N/A 2024-10-04 22:36
actions_action_p11 3815 1252 40499166 435 0.0% 2 N/A 2024-10-04 22:40
actions_action_p8 3563 1276 39094757 767 0.0% 2 N/A 2024-10-04 22:55
actions_action_p2 3405 1311 41332009 33 0.0% 2 N/A 2024-10-04 23:54
people_person 3964 728 6489324 0 0.0% 4 N/A 2024-10-04 22:13
actions_action_p5 3321 1073 33991493 108 0.0% 2 N/A 2024-10-04 22:48
actions_action_p3 2874 1051 31194969 392 0.0% 2 N/A 2024-10-04 22:45
actions_action_p6 2514 938 29627649 62 0.0% 2 N/A 2024-10-04 22:58
actions_action_p9 2438 911 26712205 176 0.0% 2 N/A 2024-10-04 22:51
actions_action_p7 2116 885 26060608 5 0.0% 2 N/A 2024-10-05 00:35
actions_action_p12 2236 654 19929941 16 0.0% 2 N/A 2024-10-04 22:30
actions_action_p4 2106 770 23575543 74 0.0% 2 N/A 2024-10-05 00:37
actions_action_p15 1998 715 22142874 354 0.0% 2 N/A 2024-10-04 23:00
actions_action_p13 1833 674 20529737 76 0.0% 2 N/A 2024-10-04 23:56
actions_webhookfire 2446 38 1369310 193 0.0% 2 N/A 2024-10-04 23:25
common_temporaryjsonstorage 2454 23 1063938 0 0.0% 1 N/A 2024-10-04 23:30
integrations_pipedriveorganization_reflead_suggestions 884 1277 20928317 12 0.0% 4 N/A 2024-10-04 23:27
actions_session_p0 1362 694 13947254 32 0.0% 2 N/A 2024-10-05 00:48
actions_session_p14 1397 657 12944625 48 0.0% 2 N/A 2024-10-05 00:51
actions_useragent 617 1366 2911334 0 0.0% 3 N/A 2024-10-04 23:23
actions_action_p10 1389 474 14399233 40 0.0% 2 N/A 2024-10-04 22:42
actions_session_p8 1029 515 10077456 270 0.0% 2 N/A 2024-10-04 23:11
actions_session_p7 1013 449 8742687 17 0.0% 2 N/A 2024-10-04 23:10
actions_session_p9 946 448 8774920 144 0.0% 2 N/A 2024-10-04 23:15
actions_session_p3 901 455 8910432 28 0.0% 2 N/A 2024-10-05 00:49
actions_path_p1 436 854 5753395 0 0.0% 3 N/A 2024-10-04 23:04
actions_session_p1 856 422 8264113 137 0.0% 2 N/A 2024-10-04 23:07
actions_session_p2 851 426 8299986 36 0.0% 2 N/A 2024-10-04 23:17
actions_session_p5 668 322 6269433 113 0.0% 2 N/A 2024-10-04 23:15
actions_session_p11 643 320 6262613 54 0.0% 2 N/A 2024-10-04 23:12
actions_path_p7 314 632 3655883 0 0.0% 3 N/A 2024-10-04 23:06
actions_session_p6 621 291 5698900 55 0.0% 2 N/A 2024-10-04 23:58
actions_session_p4 589 290 5674511 130 0.0% 2 N/A 2024-10-04 23:08
people_namesearch 391 485 7909739 0 0.0% 5 N/A 2024-10-04 23:41
actions_session_p15 597 267 5209843 24 0.0% 2 N/A 2024-10-04 23:16
actions_session_p13 579 281 5485304 38 0.0% 2 N/A 2024-10-04 23:09
leads_reflead 516 337 4367896 274 0.0% 8 N/A 2024-10-04 23:38
actions_session_p12 544 261 5100500 44 0.0% 2 N/A 2024-10-04 23:57
visits_leadcounter 349 409 7017278 30 0.0% 3 N/A 2024-10-05 00:51
leads_extra 675 18 841140 0 0.0% 1 N/A 2024-10-04 23:37
actions_url_p1 338 343 5890582 0 0.0% 3 N/A 2024-10-04 23:19
actions_path_p4 196 406 1867146 0 0.0% 3 N/A 2024-10-04 23:02
actions_path_p13 203 396 2920444 0 0.0% 3 N/A 2024-10-04 23:02
actions_session_p10 396 196 3810743 4 0.0% 2 N/A 2024-10-04 23:06
actions_path_p8 174 348 2237306 0 0.0% 3 N/A 2024-10-04 23:06
integrations_pipedriveactivity 337 171 2339327 17 0.0% 6 N/A 2024-10-04 23:27
actions_sessionlookup_p0 169 294 3390365 0 0.0% 6 N/A 2024-10-04 23:59
crm_labelactivity 271 190 3361418 0 0.0% 6 N/A 2024-10-04 23:23
actions_path_p14 150 308 1546846 0 0.0% 3 N/A 2024-10-04 23:01
actions_url_p7 211 214 3665098 0 0.0% 3 N/A 2024-10-04 23:58
integrations_pipedriveorganization 193 225 1948787 29 0.0% 8 N/A 2024-10-04 23:30
actions_path_p0 139 274 1847503 0 0.0% 3 N/A 2024-10-04 23:03
actions_path_p2 135 272 1545386 0 0.0% 3 N/A 2024-10-04 23:01
people_uniqid 187 193 3751599 0 0.0% 2 N/A 2024-10-04 23:40
li_extra_data_backup 374 0 394560 0 0.0% 0 N/A 2024-10-04 23:40
actions_path_p5 123 249 1405136 0 0.0% 3 N/A 2024-10-04 23:08
crm_leadpersonlabel 158 198 2748085 0 0.0% 6 N/A 2024-10-04 23:23
actions_url_p13 172 175 3001854 0 0.0% 3 N/A 2024-10-04 23:20
actions_path_p6 106 216 1134869 0 0.0% 3 N/A 2024-10-04 23:05
leads_iprange 210 107 4975119 0 0.0% 1 N/A 2024-10-04 23:37
actions_path_p11 100 202 1112115 0 0.0% 3 N/A 2024-10-04 23:00
people_useragentstring 94 206 481528 0 0.0% 3 N/A 2024-10-04 23:39
actions_path_p15 92 186 1088596 0 0.0% 3 N/A 2024-10-04 23:00
actions_url_p8 137 140 2383749 0 0.0% 3 N/A 2024-10-04 23:19
actions_path_p3 88 179 1051688 0 0.0% 3 N/A 2024-10-04 23:59
accounts_exportqueue 217 49 679982 0 0.0% 5 N/A 2024-10-04 22:13
actions_path_p10 82 161 1027879 0 0.0% 3 N/A 2024-10-04 23:03
actions_url_p4 116 118 2012456 0 0.0% 3 N/A 2024-10-04 23:59
actions_url_p0 115 118 2002928 0 0.0% 3 N/A 2024-10-05 00:00
actions_sid_p1 100 120 2002451 0 0.0% 2 N/A 2024-10-04 23:18
actions_path_p12 73 146 880882 0 0.0% 3 N/A 2024-10-04 23:01
actions_sid_p14 96 116 1922510 0 0.0% 2 N/A 2024-10-04 23:19
actions_sid_p8 94 114 1893400 0 0.0% 2 N/A 2024-10-04 23:19
actions_path_p9 65 133 718867 0 0.0% 3 N/A 2024-10-04 23:05
actions_sessionlookup_p14 71 124 1422642 0 0.0% 6 N/A 2024-10-04 23:17
actions_url_p14 95 97 1660567 0 0.0% 3 N/A 2024-10-04 23:20
actions_url_p2 95 96 1645595 0 0.0% 3 N/A 2024-10-04 23:20
actions_sessionlookup_p9 67 117 1342715 0 0.0% 6 N/A 2024-10-04 23:17
actions_url_p5 87 89 1520188 0 0.0% 3 N/A 2024-10-04 23:20
accounts_loginlog 142 17 597611 0 0.0% 2 N/A 2024-10-04 22:13
actions_sid_p0 69 84 1395233 0 0.0% 2 N/A 2024-10-05 00:52
integrations_pipedrivedeal 89 62 790935 1328 0.2% 5 N/A 2024-10-04 23:58
actions_sid_p13 68 82 1370666 0 0.0% 2 N/A 2024-10-04 23:18
actions_url_p15 73 74 1269074 0 0.0% 3 N/A 2024-10-04 23:59
actions_url_p6 72 74 1255268 0 0.0% 3 N/A 2024-10-04 23:20
actions_rescanidentify 104 41 1395601 0 0.0% 2 N/A 2024-10-04 23:41
actions_sessionlookupstring 49 93 773440 0 0.0% 3 N/A 2024-10-04 23:59
actions_subjectlastsession_p8 82 60 1028171 0 0.0% 3 N/A 2024-10-05 00:53
actions_url_p11 68 69 1179853 0 0.0% 3 N/A 2024-10-04 23:18
actions_url_p3 65 67 1137361 0 0.0% 3 N/A 2024-10-04 23:20
actions_url_p10 64 65 1108008 0 0.0% 3 N/A 2024-10-04 23:59
actions_subjectlastsession_p5 72 54 934278 0 0.0% 3 N/A 2024-10-05 00:53
actions_subjectlastsession_p14 70 50 862396 0 0.0% 3 N/A 2024-10-05 00:53
actions_subjectlastsession_p2 68 52 887496 0 0.0% 3 N/A 2024-10-05 00:53
actions_sessionlookup_p15 43 75 854922 0 0.0% 6 N/A 2024-10-04 23:59
actions_subjectlastsession_p4 65 50 855184 0 0.0% 3 N/A 2024-10-05 00:53
actions_subjectlastsession_p11 64 49 841678 0 0.0% 3 N/A 2024-10-05 00:53
actions_url_p12 56 57 965916 0 0.0% 3 N/A 2024-10-04 23:19
actions_sessionlookup_p5 41 71 814555 0 0.0% 6 N/A 2024-10-04 23:17
actions_subjectlastsession_p9 61 45 769558 0 0.0% 3 N/A 2024-10-05 00:54
actions_sessionlookup_p8 38 67 760150 0 0.0% 6 N/A 2024-10-04 23:17
actions_subjectlastsession_p6 59 45 779156 0 0.0% 3 N/A 2024-10-05 00:53
actions_subjectlastsession_p7 57 44 747062 0 0.0% 3 N/A 2024-10-05 00:53
actions_subjectlastsession_p13 58 43 739885 0 0.0% 3 N/A 2024-10-05 00:53
leads_outsourcedorganizationdata 44 56 302316 0 0.0% 9 N/A 2024-10-04 23:38
actions_sid_p11 45 55 910553 0 0.0% 2 N/A 2024-10-05 00:52
actions_sid_p9 45 54 903982 0 0.0% 2 N/A 2024-10-05 00:00
actions_subjectlastsession_p3 57 42 727280 0 0.0% 3 N/A 2024-10-05 00:53
actions_sid_p3 44 53 879420 0 0.0% 2 N/A 2024-10-04 23:19
actions_sid_p12 44 53 877864 0 0.0% 2 N/A 2024-10-04 23:18
actions_url_p9 47 48 820930 0 0.0% 3 N/A 2024-10-04 23:23
actions_netloc 32 62 467667 0 0.0% 3 N/A 2024-10-04 22:42
actions_subjectlastsession_p10 52 40 687147 0 0.0% 3 N/A 2024-10-05 00:52
actions_subjectlastsession_p15 52 39 677318 0 0.0% 3 N/A 2024-10-05 00:54
actions_sessionlookup_p11 33 58 661881 0 0.0% 6 N/A 2024-10-04 23:59
actions_subjectlastsession_p0 52 39 668576 0 0.0% 3 N/A 2024-10-05 00:52
django_admin_log 81 10 266111 0 0.0% 3 N/A 2024-10-04 23:27
actions_sid_p2 40 49 813047 0 0.0% 2 N/A 2024-10-05 00:52
actions_subjectlastsession_p1 50 37 640013 0 0.0% 3 N/A 2024-10-05 00:52
actions_subjectlastsession_p12 48 36 620661 0 0.0% 3 N/A 2024-10-05 00:53
leads_refleadoutsourcedorganization 34 47 587872 0 0.0% 4 N/A 2024-10-04 23:38
accounts_meter 74 6 297918 0 0.0% 1 N/A 2024-10-04 22:13
leads_refleadtoexternalcompanydata 37 41 525306 0 0.0% 4 N/A 2024-10-04 23:38
actions_sessionlookup_p6 28 49 562356 0 0.0% 6 N/A 2024-10-04 23:17
actions_sid_p5 34 41 679388 0 0.0% 2 N/A 2024-10-04 23:19
actions_sid_p4 32 39 651534 0 0.0% 2 N/A 2024-10-04 23:19
actions_sid_p7 32 39 650665 0 0.0% 2 N/A 2024-10-04 23:19
actions_sessionlookup_p2 26 45 515337 0 0.0% 6 N/A 2024-10-04 23:17
leads_ipaddress 32 35 523732 0 0.0% 3 N/A 2024-10-04 23:36
actions_sessionlookup_p13 24 42 478553 0 0.0% 6 N/A 2024-10-04 23:59
actions_sessionlookup_p10 22 39 439161 0 0.0% 6 N/A 2024-10-04 23:08
actions_sid_p6 27 32 539902 0 0.0% 2 N/A 2024-10-04 23:19
actions_sessionlookup_p7 20 35 397243 0 0.0% 6 N/A 2024-10-04 23:59
actions_sessionlookup_p3 19 34 383857 0 0.0% 6 N/A 2024-10-04 23:17
actions_sessionlookup_p4 19 33 378323 0 0.0% 6 N/A 2024-10-04 23:58
actions_sid_p15 22 27 440910 0 0.0% 2 N/A 2024-10-04 23:19
crm_leadactivity 35 13 284372 0 0.0% 3 N/A 2024-10-05 00:00
actions_sessionlookup_p1 17 30 344725 0 0.0% 6 N/A 2024-10-04 23:08
actions_sid_p10 21 25 416534 0 0.0% 2 N/A 2024-10-04 23:18
actions_sessionlookup_p12 15 26 296088 0 0.0% 6 N/A 2024-10-04 23:17
leads_blacklist 18 12 229107 0 0.0% 5 N/A 2024-10-04 23:36
leads_refleadlastupdate 17 9 376606 27670 6.8% 1 N/A 2024-10-04 23:38
accounts_userprofile 12 13 38682 25 0.1% 9 N/A 2024-10-04 22:13
leads_refleadchangehistory 19 6 110112 0 0.0% 3 N/A 2024-10-04 23:38
accounts_freemail 10 13 143665 0 0.0% 3 N/A 2024-10-04 22:13
actions_collidingidentify 14 8 276362 1 0.0% 2 N/A 2024-10-04 22:42
leads_cufrequestlog 11 8 119407 0 0.0% 3 N/A 2024-10-04 23:36
crm_leadcontactedstatus 11 7 164528 0 0.0% 2 N/A 2024-10-04 23:20
leads_zipcode 8 9 192804 0 0.0% 2 N/A 2024-10-04 23:40
leads_city 6 7 138301 0 0.0% 2 N/A 2024-10-04 23:59
leads_inetnumobject 6 6 48378 0 0.0% 7 N/A 2024-10-04 22:13
accounts_website 5 6 26248 0 0.0% 7 N/A 2024-10-04 23:41
accounts_website_territories 4 6 96462 0 0.0% 4 N/A 2024-10-04 22:30
notifications_notification 5 5 79868 0 0.0% 4 N/A 2024-10-04 23:40
accounts_regemail 5 4 58159 0 0.0% 3 N/A 2024-10-04 22:13
accounts_registrationlog 7 1 27532 0 0.0% 1 N/A 2024-10-04 22:13
invoices_fakturoidinvoice 6 2 40037 0 0.0% 3 N/A 2024-10-04 23:41
leads_adformexport 7 0 75 0 0.0% 1 N/A 2024-10-04 23:38
auth_user 5 2 23706 0 0.0% 2 N/A 2024-10-05 00:00
leads_ispcheckqueue 2 4 35367 0 0.0% 8 N/A 2024-10-04 23:36
accounts_emailreport 3 2 14859 0 0.0% 5 N/A 2024-10-04 22:13
accounts_savedfilter 3 1 15360 0 0.0% 4 N/A 2024-10-04 22:13
leads_inetnumnetname 2 2 27424 0 0.0% 4 N/A 2024-10-04 23:25
invoices_fakturoidinvoice_tags 1 2 25760 0 0.0% 4 N/A 2024-10-04 23:41
impersonate_impersonationlog 2 1 23682 0 0.0% 3 N/A 2024-10-04 23:30
django_session 2 1 7615 62 0.8% 2 N/A 2024-10-04 23:25
crm_idealcustomerprofile_ideal_industries 1 1 21739 0 0.0% 4 N/A 2024-10-05 00:53
accounts_websiteaccess 1 1 14508 0 0.0% 4 N/A 2024-10-04 23:41
leads_industry 1 1 9821 0 0.0% 3 N/A 2024-10-04 23:37
----------------------------------------------------------------------------------------------------------------------------------------------------------
TOTALS (including the <1MiB omitted above) 121169 51027 1025967216 34373 754
A je vidět, že sloupec Last Vacuum mi tam nefunguje. :-)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment