analyzer_output

/** Disk-Space Utilization Report For /var/urbackup/backup_server.db

Page size in bytes................................ 4096
Pages in the whole file (measured)................ 690
Pages in the whole file (calculated).............. 690
Pages that store data............................. 690        100.0%
Pages on the freelist (per header)................ 0            0.0%
Pages on the freelist (calculated)................ 0            0.0%
Pages of auto-vacuum overhead..................... 0            0.0%
Number of tables in the database.................. 21
Number of indices................................. 9
Number of defined indices......................... 8
Number of implied indices......................... 1
Size of the file in bytes......................... 2826240
Bytes of user payload stored...................... 2506811     88.7%

*** Page counts for all tables with their indices *****************************

LOG_DATA.......................................... 570         82.6%
CLIENTS_HIST...................................... 45           6.5%
ORIG_CLIENT_SETTINGS.............................. 24           3.5%
TOKENS_ON_CLIENT.................................. 10           1.4%
USER_TOKENS....................................... 10           1.4%
CLIENTS_HIST_ID................................... 6            0.87%
BACKUPS........................................... 4            0.58%
LOGS.............................................. 4            0.58%
SQLITE_MASTER..................................... 3            0.43%
MOVED_CLIENTS..................................... 2            0.29%
USERS_ON_CLIENT................................... 2            0.29%
ALERT_SCRIPT_PARAMS............................... 1            0.14%
ALERT_SCRIPTS..................................... 1            0.14%
ASSOC_IMAGES...................................... 1            0.14%
BACKUP_IMAGES..................................... 1            0.14%
CLIENTS........................................... 1            0.14%
DEL_STATS......................................... 1            0.14%
MAIL_QUEUE........................................ 1            0.14%
MISC.............................................. 1            0.14%
MOUNTED_BACKUP_IMAGES............................. 1            0.14%
RESTORES.......................................... 1            0.14%

*** Page counts for all tables and indices separately *************************

LOG_DATA.......................................... 569         82.5%
CLIENTS_HIST...................................... 33           4.8%
ORIG_CLIENT_SETTINGS.............................. 23           3.3%
CLIENTS_HIST_CREATED_IDX.......................... 12           1.7%
USER_TOKENS....................................... 6            0.87%
TOKENS_ON_CLIENT.................................. 5            0.72%
TOKENS_ON_CLIENT_UNIQUE........................... 5            0.72%
BACKUPS........................................... 4            0.58%
USER_TOKENS_UNIQUE................................ 4            0.58%
CLIENTS_HIST_ID................................... 3            0.43%
CLIENTS_HIST_ID_CREATED_IDX....................... 3            0.43%
LOGS.............................................. 3            0.43%
SQLITE_MASTER..................................... 3            0.43%
ALERT_SCRIPT_PARAMS............................... 1            0.14%
ALERT_SCRIPTS..................................... 1            0.14%
ASSOC_IMAGES...................................... 1            0.14%
BACKUP_IMAGES..................................... 1            0.14%
CLIENTS........................................... 1            0.14%
DEL_STATS......................................... 1            0.14%
LOG_DATA_IDX...................................... 1            0.14%
LOGS_CREATED_IDX.................................. 1            0.14%
MAIL_QUEUE........................................ 1            0.14%
MISC.............................................. 1            0.14%
MOUNTED_BACKUP_IMAGES............................. 1            0.14%
MOVED_CLIENTS..................................... 1            0.14%
MOVED_CLIENTS_FROM_IDX............................ 1            0.14%
RESTORES.......................................... 1            0.14%
SQLITE_AUTOINDEX_ORIG_CLIENT_SETTINGS_1........... 1            0.14%
USERS_ON_CLIENT................................... 1            0.14%
USERS_ON_CLIENT_UNIQUE............................ 1            0.14%

*** All tables and indices ****************************************************

Percentage of total database...................... 100.0%
Number of entries................................. 5387
Bytes of storage consumed......................... 2826240
Bytes of payload.................................. 2577089     91.2%
Bytes of metadata................................. 28008        0.99%
Average payload per entry......................... 478.39
Average unused bytes per entry.................... 41.41
Average metadata per entry........................ 5.20
Average fanout.................................... 11.00
Maximum payload per entry......................... 1560746
Entries that use overflow......................... 29           0.54%
Index pages used.................................. 13
Primary pages used................................ 159
Overflow pages used............................... 518
Total pages used.................................. 690
Unused bytes on index pages....................... 51598       96.9%
Unused bytes on primary pages..................... 171354      26.3%
Unused bytes on overflow pages.................... 147          0.007%
Unused bytes on all pages......................... 223099       7.9%

*** All tables ****************************************************************

Percentage of total database......................  95.8%
Number of entries................................. 2811
Bytes of storage consumed......................... 2707456
Bytes of payload.................................. 2512436     92.8%
Bytes of metadata................................. 19968        0.74%
Average payload per entry......................... 893.79
Average unused bytes per entry.................... 62.97
Average metadata per entry........................ 7.10
Average fanout.................................... 13.00
Maximum payload per entry......................... 1560746
Entries that use overflow......................... 29           1.0%
Index pages used.................................. 9
Primary pages used................................ 134
Overflow pages used............................... 518
Total pages used.................................. 661
Unused bytes on index pages....................... 35814       97.2%
Unused bytes on primary pages..................... 141047      25.7%
Unused bytes on overflow pages.................... 147          0.007%
Unused bytes on all pages......................... 177008       6.5%

*** All indices ***************************************************************

Percentage of total database......................   4.2%
Number of entries................................. 2576
Bytes of storage consumed......................... 118784
Bytes of payload.................................. 64653       54.4%
Bytes of metadata................................. 8040         6.8%
Average payload per entry......................... 25.10
Average unused bytes per entry.................... 17.89
Average metadata per entry........................ 3.12
Average fanout.................................... 7.00
Maximum payload per entry......................... 78
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 4
Primary pages used................................ 25
Overflow pages used............................... 0
Total pages used.................................. 29
Unused bytes on index pages....................... 15784       96.3%
Unused bytes on primary pages..................... 30307       29.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 46091       38.8%

*** Table ALERT_SCRIPT_PARAMS *************************************************

Percentage of total database......................   0.14%
Number of entries................................. 22
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 1163        28.4%
Bytes of metadata................................. 96           2.3%
B-tree depth...................................... 1
Average payload per entry......................... 52.86
Average unused bytes per entry.................... 128.95
Average metadata per entry........................ 4.36
Maximum payload per entry......................... 83
Entries that use overflow......................... 0            0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 2837        69.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 2837        69.3%

*** Table ALERT_SCRIPTS *******************************************************

Percentage of total database......................   0.14%
Number of entries................................. 2
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 30           0.73%
Bytes of metadata................................. 18           0.44%
B-tree depth...................................... 1
Average payload per entry......................... 15.00
Average unused bytes per entry.................... 2024.00
Average metadata per entry........................ 9.00
Maximum payload per entry......................... 17
Entries that use overflow......................... 0            0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4048        98.8%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4048        98.8%

*** Table ASSOC_IMAGES ********************************************************

Percentage of total database......................   0.14%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0            0.0%
Bytes of metadata................................. 8            0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088        99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088        99.80%

*** Table BACKUP_IMAGES *******************************************************

Percentage of total database......................   0.14%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0            0.0%
Bytes of metadata................................. 8            0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088        99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088        99.80%

*** Table BACKUPS *************************************************************

Percentage of total database......................   0.58%
Number of entries................................. 117
Bytes of storage consumed......................... 16384
Bytes of payload.................................. 9315        56.9%
Bytes of metadata................................. 552          3.4%
B-tree depth...................................... 2
Average payload per entry......................... 79.62
Average unused bytes per entry.................... 55.70
Average metadata per entry........................ 4.72
Average fanout.................................... 3.00
Non-sequential pages.............................. 2           66.7%
Maximum payload per entry......................... 82
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 1
Primary pages used................................ 3
Overflow pages used............................... 0
Total pages used.................................. 4
Unused bytes on index pages....................... 4070        99.37%
Unused bytes on primary pages..................... 2447        19.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 6517        39.8%

*** Table CLIENTS *************************************************************

Percentage of total database......................   0.14%
Number of entries................................. 17
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 2919        71.3%
Bytes of metadata................................. 93           2.3%
B-tree depth...................................... 1
Average payload per entry......................... 171.71
Average unused bytes per entry.................... 63.76
Average metadata per entry........................ 5.47
Maximum payload per entry......................... 188
Entries that use overflow......................... 0            0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 1084        26.5%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 1084        26.5%

*** Table CLIENTS_HIST and all its indices ************************************

Percentage of total database......................   6.5%
Number of entries................................. 2718
Bytes of storage consumed......................... 184320
Bytes of payload.................................. 143157      77.7%
Bytes of metadata................................. 11528        6.3%
Average payload per entry......................... 52.67
Average unused bytes per entry.................... 10.90
Average metadata per entry........................ 4.24
Average fanout.................................... 22.00
Maximum payload per entry......................... 91
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 2
Primary pages used................................ 43
Overflow pages used............................... 0
Total pages used.................................. 45
Unused bytes on index pages....................... 7610        92.9%
Unused bytes on primary pages..................... 22025       12.5%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 29635       16.1%

*** Table CLIENTS_HIST w/o any indices ****************************************

Percentage of total database......................   4.8%
Number of entries................................. 1359
Bytes of storage consumed......................... 135168
Bytes of payload.................................. 110541      81.8%
Bytes of metadata................................. 7311         5.4%
B-tree depth...................................... 2
Average payload per entry......................... 81.34
Average unused bytes per entry.................... 12.74
Average metadata per entry........................ 5.38
Average fanout.................................... 32.00
Non-sequential pages.............................. 25          78.1%
Maximum payload per entry......................... 91
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 1
Primary pages used................................ 32
Overflow pages used............................... 0
Total pages used.................................. 33
Unused bytes on index pages....................... 3836        93.7%
Unused bytes on primary pages..................... 13480       10.3%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 17316       12.8%

*** Index CLIENTS_HIST_CREATED_IDX of table CLIENTS_HIST **********************

Percentage of total database......................   1.7%
Number of entries................................. 1359
Bytes of storage consumed......................... 49152
Bytes of payload.................................. 32616       66.4%
Bytes of metadata................................. 4217         8.6%
B-tree depth...................................... 2
Average payload per entry......................... 24.00
Average unused bytes per entry.................... 9.06
Average metadata per entry........................ 3.10
Average fanout.................................... 12.00
Non-sequential pages.............................. 9           81.8%
Maximum payload per entry......................... 24
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 1
Primary pages used................................ 11
Overflow pages used............................... 0
Total pages used.................................. 12
Unused bytes on index pages....................... 3774        92.1%
Unused bytes on primary pages..................... 8545        19.0%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 12319       25.1%

*** Table CLIENTS_HIST_ID and all its indices *********************************

Percentage of total database......................   0.87%
Number of entries................................. 414
Bytes of storage consumed......................... 24576
Bytes of payload.................................. 9522        38.7%
Bytes of metadata................................. 1724         7.0%
Average payload per entry......................... 23.00
Average unused bytes per entry.................... 32.20
Average metadata per entry........................ 4.16
Average fanout.................................... 2.00
Maximum payload per entry......................... 24
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 2
Primary pages used................................ 4
Overflow pages used............................... 0
Total pages used.................................. 6
Unused bytes on index pages....................... 8129        99.23%
Unused bytes on primary pages..................... 5201        31.7%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 13330       54.2%

*** Table CLIENTS_HIST_ID w/o any indices *************************************

Percentage of total database......................   0.43%
Number of entries................................. 207
Bytes of storage consumed......................... 12288
Bytes of payload.................................. 4554        37.1%
Bytes of metadata................................. 1071         8.7%
B-tree depth...................................... 2
Average payload per entry......................... 22.00
Average unused bytes per entry.................... 32.19
Average metadata per entry........................ 5.17
Average fanout.................................... 2.00
Non-sequential pages.............................. 2          100.0%
Maximum payload per entry......................... 22
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 1
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 3
Unused bytes on index pages....................... 4076        99.51%
Unused bytes on primary pages..................... 2587        31.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 6663        54.2%

*** Index CLIENTS_HIST_ID_CREATED_IDX of table CLIENTS_HIST_ID ****************

Percentage of total database......................   0.43%
Number of entries................................. 207
Bytes of storage consumed......................... 12288
Bytes of payload.................................. 4968        40.4%
Bytes of metadata................................. 653          5.3%
B-tree depth...................................... 2
Average payload per entry......................... 24.00
Average unused bytes per entry.................... 32.21
Average metadata per entry........................ 3.15
Average fanout.................................... 3.00
Non-sequential pages.............................. 2          100.0%
Maximum payload per entry......................... 24
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 1
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 3
Unused bytes on index pages....................... 4053        99.0%
Unused bytes on primary pages..................... 2614        31.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 6667        54.3%

*** Table DEL_STATS ***********************************************************

Percentage of total database......................   0.14%
Number of entries................................. 44
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 2286        55.8%
Bytes of metadata................................. 184          4.5%
B-tree depth...................................... 1
Average payload per entry......................... 51.95
Average unused bytes per entry.................... 36.95
Average metadata per entry........................ 4.18
Maximum payload per entry......................... 54
Entries that use overflow......................... 0            0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 1626        39.7%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 1626        39.7%

*** Table LOG_DATA and all its indices ****************************************

Percentage of total database......................  82.6%
Number of entries................................. 304
Bytes of storage consumed......................... 2334720
Bytes of payload.................................. 2261612     96.9%
Bytes of metadata................................. 6289         0.27%
Average payload per entry......................... 7439.51
Average unused bytes per entry.................... 226.23
Average metadata per entry........................ 20.69
Average fanout.................................... 68.00
Maximum payload per entry......................... 1560746
Entries that use overflow......................... 12           3.9%
Index pages used.................................. 1
Primary pages used................................ 68
Overflow pages used............................... 501
Total pages used.................................. 570
Unused bytes on index pages....................... 3612        88.2%
Unused bytes on primary pages..................... 65016       23.3%
Unused bytes on overflow pages.................... 147          0.007%
Unused bytes on all pages......................... 68775        2.9%

*** Table LOG_DATA w/o any indices ********************************************

Percentage of total database......................  82.5%
Number of entries................................. 152
Bytes of storage consumed......................... 2330624
Bytes of payload.................................. 2260804     97.0%
Bytes of metadata................................. 5825         0.25%
B-tree depth...................................... 2
Average payload per entry......................... 14873.71
Average unused bytes per entry.................... 433.89
Average metadata per entry........................ 38.32
Average fanout.................................... 67.00
Non-sequential pages.............................. 30           5.3%
Maximum payload per entry......................... 1560746
Entries that use overflow......................... 12           7.9%
Index pages used.................................. 1
Primary pages used................................ 67
Overflow pages used............................... 501
Total pages used.................................. 569
Unused bytes on index pages....................... 3612        88.2%
Unused bytes on primary pages..................... 62192       22.7%
Unused bytes on overflow pages.................... 147          0.007%
Unused bytes on all pages......................... 65951        2.8%

*** Index LOG_DATA_IDX of table LOG_DATA **************************************

Percentage of total database......................   0.14%
Number of entries................................. 152
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 808         19.7%
Bytes of metadata................................. 464         11.3%
B-tree depth...................................... 1
Average payload per entry......................... 5.32
Average unused bytes per entry.................... 18.58
Average metadata per entry........................ 3.05
Maximum payload per entry......................... 7
Entries that use overflow......................... 0            0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 2824        68.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 2824        68.9%

*** Table LOGS and all its indices ********************************************

Percentage of total database......................   0.58%
Number of entries................................. 304
Bytes of storage consumed......................... 16384
Bytes of payload.................................. 8755        53.4%
Bytes of metadata................................. 1132         6.9%
Average payload per entry......................... 28.80
Average unused bytes per entry.................... 21.37
Average metadata per entry........................ 3.72
Average fanout.................................... 3.00
Maximum payload per entry......................... 37
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 1
Primary pages used................................ 3
Overflow pages used............................... 0
Total pages used.................................. 4
Unused bytes on index pages....................... 4077        99.54%
Unused bytes on primary pages..................... 2420        19.7%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 6497        39.7%

*** Table LOGS w/o any indices ************************************************

Percentage of total database......................   0.43%
Number of entries................................. 152
Bytes of storage consumed......................... 12288
Bytes of payload.................................. 5235        42.6%
Bytes of metadata................................. 668          5.4%
B-tree depth...................................... 2
Average payload per entry......................... 34.44
Average unused bytes per entry.................... 42.01
Average metadata per entry........................ 4.39
Average fanout.................................... 2.00
Non-sequential pages.............................. 1           50.0%
Maximum payload per entry......................... 37
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 1
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 3
Unused bytes on index pages....................... 4077        99.54%
Unused bytes on primary pages..................... 2308        28.2%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 6385        52.0%

*** Index LOGS_CREATED_IDX of table LOGS **************************************

Percentage of total database......................   0.14%
Number of entries................................. 152
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 3520        85.9%
Bytes of metadata................................. 464         11.3%
B-tree depth...................................... 1
Average payload per entry......................... 23.16
Average unused bytes per entry.................... 0.74
Average metadata per entry........................ 3.05
Maximum payload per entry......................... 24
Entries that use overflow......................... 0            0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 112          2.7%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 112          2.7%

*** Table MAIL_QUEUE **********************************************************

Percentage of total database......................   0.14%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0            0.0%
Bytes of metadata................................. 8            0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088        99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088        99.80%

*** Table MISC ****************************************************************

Percentage of total database......................   0.14%
Number of entries................................. 4
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 79           1.9%
Bytes of metadata................................. 24           0.59%
B-tree depth...................................... 1
Average payload per entry......................... 19.75
Average unused bytes per entry.................... 998.25
Average metadata per entry........................ 6.00
Maximum payload per entry......................... 25
Entries that use overflow......................... 0            0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3993        97.5%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3993        97.5%

*** Table MOUNTED_BACKUP_IMAGES ***********************************************

Percentage of total database......................   0.14%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0            0.0%
Bytes of metadata................................. 8            0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088        99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088        99.80%

*** Table MOVED_CLIENTS and all its indices ***********************************

Percentage of total database......................   0.29%
Number of entries................................. 0
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 0            0.0%
Bytes of metadata................................. 16           0.20%
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 8176        99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 8176        99.80%

*** Table MOVED_CLIENTS w/o any indices ***************************************

Percentage of total database......................   0.14%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0            0.0%
Bytes of metadata................................. 8            0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088        99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088        99.80%

*** Index MOVED_CLIENTS_FROM_IDX of table MOVED_CLIENTS ***********************

Percentage of total database......................   0.14%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0            0.0%
Bytes of metadata................................. 8            0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088        99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088        99.80%

*** Table ORIG_CLIENT_SETTINGS and all its indices ****************************

Percentage of total database......................   3.5%
Number of entries................................. 34
Bytes of storage consumed......................... 98304
Bytes of payload.................................. 84282       85.7%
Bytes of metadata................................. 378          0.38%
Average payload per entry......................... 2478.88
Average unused bytes per entry.................... 401.29
Average metadata per entry........................ 11.12
Average fanout.................................... 6.00
Maximum payload per entry......................... 5876
Entries that use overflow......................... 17          50.0%
Index pages used.................................. 1
Primary pages used................................ 6
Overflow pages used............................... 17
Total pages used.................................. 24
Unused bytes on index pages....................... 4053        99.0%
Unused bytes on primary pages..................... 9591        39.0%
Unused bytes on overflow pages.................... 0            0.0%
Unused bytes on all pages......................... 13644       13.9%

*** Table ORIG_CLIENT_SETTINGS w/o any indices ********************************

Percentage of total database......................   3.3%
Number of entries................................. 17
Bytes of storage consumed......................... 94208
Bytes of payload.................................. 84183       89.4%
Bytes of metadata................................. 319          0.34%
B-tree depth...................................... 2
Average payload per entry......................... 4951.94
Average unused bytes per entry.................... 570.94
Average metadata per entry........................ 18.76
Average fanout.................................... 5.00
Non-sequential pages.............................. 5           22.7%
Maximum payload per entry......................... 5876
Entries that use overflow......................... 17         100.0%
Index pages used.................................. 1
Primary pages used................................ 5
Overflow pages used............................... 17
Total pages used.................................. 23
Unused bytes on index pages....................... 4053        99.0%
Unused bytes on primary pages..................... 5653        27.6%
Unused bytes on overflow pages.................... 0            0.0%
Unused bytes on all pages......................... 9706        10.3%

*** Index SQLITE_AUTOINDEX_ORIG_CLIENT_SETTINGS_1 of table ORIG_CLIENT_SETTINGS

Percentage of total database......................   0.14%
Number of entries................................. 17
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 99           2.4%
Bytes of metadata................................. 59           1.4%
B-tree depth...................................... 1
Average payload per entry......................... 5.82
Average unused bytes per entry.................... 231.65
Average metadata per entry........................ 3.47
Maximum payload per entry......................... 6
Entries that use overflow......................... 0            0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3938        96.1%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3938        96.1%

*** Table RESTORES ************************************************************

Percentage of total database......................   0.14%
Number of entries................................. 0
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 0            0.0%
Bytes of metadata................................. 8            0.20%
B-tree depth...................................... 1
Average payload per entry......................... 0.0
Average unused bytes per entry.................... 0.0
Average metadata per entry........................ 0.0
Maximum payload per entry......................... 0
Entries that use overflow......................... 0
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 4088        99.80%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 4088        99.80%

*** Table SQLITE_MASTER *******************************************************

Percentage of total database......................   0.43%
Number of entries................................. 29
Bytes of storage consumed......................... 12288
Bytes of payload.................................. 5625        45.8%
Bytes of metadata................................. 272          2.2%
B-tree depth...................................... 2
Average payload per entry......................... 193.97
Average unused bytes per entry.................... 220.38
Average metadata per entry........................ 9.38
Average fanout.................................... 2.00
Non-sequential pages.............................. 1           50.0%
Maximum payload per entry......................... 478
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 1
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 3
Unused bytes on index pages....................... 3977        97.1%
Unused bytes on primary pages..................... 2414        29.5%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 6391        52.0%

*** Table TOKENS_ON_CLIENT and all its indices ********************************

Percentage of total database......................   1.4%
Number of entries................................. 866
Bytes of storage consumed......................... 40960
Bytes of payload.................................. 22472       54.9%
Bytes of metadata................................. 3588         8.8%
Average payload per entry......................... 25.95
Average unused bytes per entry.................... 17.21
Average metadata per entry........................ 4.14
Average fanout.................................... 4.00
Maximum payload per entry......................... 27
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 2
Primary pages used................................ 8
Overflow pages used............................... 0
Total pages used.................................. 10
Unused bytes on index pages....................... 8042        98.2%
Unused bytes on primary pages..................... 6858        20.9%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 14900       36.4%

*** Table TOKENS_ON_CLIENT w/o any indices ************************************

Percentage of total database......................   0.72%
Number of entries................................. 433
Bytes of storage consumed......................... 20480
Bytes of payload.................................. 10803       52.7%
Bytes of metadata................................. 2233        10.9%
B-tree depth...................................... 2
Average payload per entry......................... 24.95
Average unused bytes per entry.................... 17.19
Average metadata per entry........................ 5.16
Average fanout.................................... 4.00
Non-sequential pages.............................. 3           75.0%
Maximum payload per entry......................... 25
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 1
Primary pages used................................ 4
Overflow pages used............................... 0
Total pages used.................................. 5
Unused bytes on index pages....................... 4060        99.12%
Unused bytes on primary pages..................... 3384        20.7%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 7444        36.3%

*** Index TOKENS_ON_CLIENT_UNIQUE of table TOKENS_ON_CLIENT *******************

Percentage of total database......................   0.72%
Number of entries................................. 433
Bytes of storage consumed......................... 20480
Bytes of payload.................................. 11669       57.0%
Bytes of metadata................................. 1355         6.6%
B-tree depth...................................... 2
Average payload per entry......................... 26.95
Average unused bytes per entry.................... 17.22
Average metadata per entry........................ 3.13
Average fanout.................................... 5.00
Non-sequential pages.............................. 3           75.0%
Maximum payload per entry......................... 27
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 1
Primary pages used................................ 4
Overflow pages used............................... 0
Total pages used.................................. 5
Unused bytes on index pages....................... 3982        97.2%
Unused bytes on primary pages..................... 3474        21.2%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 7456        36.4%

*** Table USER_TOKENS and all its indices *************************************

Percentage of total database......................   1.4%
Number of entries................................. 432
Bytes of storage consumed......................... 40960
Bytes of payload.................................. 24097       58.8%
Bytes of metadata................................. 1771         4.3%
Average payload per entry......................... 55.78
Average unused bytes per entry.................... 34.94
Average metadata per entry........................ 4.10
Average fanout.................................... 4.00
Maximum payload per entry......................... 96
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 2
Primary pages used................................ 8
Overflow pages used............................... 0
Total pages used.................................. 10
Unused bytes on index pages....................... 8028        98.0%
Unused bytes on primary pages..................... 7064        21.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 15092       36.8%

*** Table USER_TOKENS w/o any indices *****************************************

Percentage of total database......................   0.87%
Number of entries................................. 216
Bytes of storage consumed......................... 24576
Bytes of payload.................................. 14035       57.1%
Bytes of metadata................................. 1079         4.4%
B-tree depth...................................... 2
Average payload per entry......................... 64.98
Average unused bytes per entry.................... 43.81
Average metadata per entry........................ 5.00
Average fanout.................................... 5.00
Non-sequential pages.............................. 4           80.0%
Maximum payload per entry......................... 96
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 1
Primary pages used................................ 5
Overflow pages used............................... 0
Total pages used.................................. 6
Unused bytes on index pages....................... 4053        99.0%
Unused bytes on primary pages..................... 5409        26.4%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 9462        38.5%

*** Index USER_TOKENS_UNIQUE of table USER_TOKENS *****************************

Percentage of total database......................   0.58%
Number of entries................................. 216
Bytes of storage consumed......................... 16384
Bytes of payload.................................. 10062       61.4%
Bytes of metadata................................. 692          4.2%
B-tree depth...................................... 2
Average payload per entry......................... 46.58
Average unused bytes per entry.................... 26.06
Average metadata per entry........................ 3.20
Average fanout.................................... 4.00
Non-sequential pages.............................. 2           66.7%
Maximum payload per entry......................... 78
Entries that use overflow......................... 0            0.0%
Index pages used.................................. 1
Primary pages used................................ 3
Overflow pages used............................... 0
Total pages used.................................. 4
Unused bytes on index pages....................... 3975        97.0%
Unused bytes on primary pages..................... 1655        13.5%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 5630        34.4%

*** Table USERS_ON_CLIENT and all its indices *********************************

Percentage of total database......................   0.29%
Number of entries................................. 80
Bytes of storage consumed......................... 8192
Bytes of payload.................................. 1775        21.7%
Bytes of metadata................................. 303          3.7%
Average payload per entry......................... 22.19
Average unused bytes per entry.................... 76.42
Average metadata per entry........................ 3.79
Maximum payload per entry......................... 40
Entries that use overflow......................... 0            0.0%
Primary pages used................................ 2
Overflow pages used............................... 0
Total pages used.................................. 2
Unused bytes on primary pages..................... 6114        74.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 6114        74.6%

*** Table USERS_ON_CLIENT w/o any indices *************************************

Percentage of total database......................   0.14%
Number of entries................................. 40
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 864         21.1%
Bytes of metadata................................. 175          4.3%
B-tree depth...................................... 1
Average payload per entry......................... 21.60
Average unused bytes per entry.................... 76.42
Average metadata per entry........................ 4.38
Maximum payload per entry......................... 39
Entries that use overflow......................... 0            0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3057        74.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3057        74.6%

*** Index USERS_ON_CLIENT_UNIQUE of table USERS_ON_CLIENT *********************

Percentage of total database......................   0.14%
Number of entries................................. 40
Bytes of storage consumed......................... 4096
Bytes of payload.................................. 911         22.2%
Bytes of metadata................................. 128          3.1%
B-tree depth...................................... 1
Average payload per entry......................... 22.77
Average unused bytes per entry.................... 76.42
Average metadata per entry........................ 3.20
Maximum payload per entry......................... 40
Entries that use overflow......................... 0            0.0%
Primary pages used................................ 1
Overflow pages used............................... 0
Total pages used.................................. 1
Unused bytes on primary pages..................... 3057        74.6%
Unused bytes on overflow pages.................... 0
Unused bytes on all pages......................... 3057        74.6%

*** Definitions ***************************************************************