Tests

FB_MNEMONA CNT UNIT FB_GDSCODE DTS_BEG DTS_END
deadlock 11 sp_kill_cost_storno 335544336 2016-08-29 23:32 2016-08-30 02:15
deadlock 4 sp_qd_handle_on_invoice_upd_sts 335544336 2016-08-29 23:45 2016-08-30 01:16
lock_conflict 3 sp_kill_cost_storno 335544345 2016-08-29 23:35 2016-08-30 01:30
lock_conflict 1077 sp_lock_selected_doc 335544345 2016-08-29 23:31 2016-08-30 02:30
lock_conflict 22 sp_qd_handle_on_cancel_clo 335544345 2016-08-29 23:32 2016-08-30 02:02
lock_conflict 16 sp_qd_handle_on_invoice_upd_sts 335544345 2016-08-29 23:32 2016-08-30 02:31
lock_conflict 1 sp_qd_handle_on_reserve_upd_sts 335544345 2016-08-29 23:32 2016-08-29 23:32
lock_conflict 73 x_lock_depdocs_on_canc_invoice 335544345 2016-08-29 23:31 2016-08-30 02:12
lock_conflict 21 x_lock_depdocs_on_canc_sup_ord 335544345 2016-08-29 23:36 2016-08-30 02:31
Done for 2540 ms, from 2:35:05.06 to 2:35:07.60.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP25-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 92342
MON$OLDEST_ACTIVE 92343
MON$OLDEST_SNAPSHOT 92343
MON$NEXT_TRANSACTION 92343
MON$PAGE_BUFFERS 384
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2015-12-11 10:02:47.3010
MON$PAGES 173782
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.7.27025 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.7.27025 Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.7.27025 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.7.27025 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
on disk structure version 11.2

Database statistics, full


Database "D:\OLTP-EMUL\oltp25-small.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 96866
Page size 8192
ODS version 11.2
Oldest transaction 92344
Oldest active 92345
Oldest snapshot 92345
Next transaction 92346
Bumped transaction 1
Sequence number 0
Next attachment ID 4446
Implementation ID 24
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 10:02:47
Attributes force write

Variable header data:
Sweep interval: 0
*END*


Database file sequence:
File D:\OLTP-EMUL\oltp25-small.fdb is the only file

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 259, Index root page: 260
Average record length: 34.62, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 32%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_OUR_FIRM (4)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 48
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_SUPPLIER (3)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 47
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 13.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_AGENTS (0)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

BUSINESS_OPS (158)
Primary pointer page: 280, Index root page: 281
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 28%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BO_UNIT_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BUSINESS_OPS_RND_WGTH (2)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 0.84, total dup: 7, max dup: 3
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RDB$1 (0)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 1.63, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

DOC_DATA (141)
Primary pointer page: 199, Index root page: 200
Average record length: 44.56, total records: 473984
Average version length: 46.31, total versions: 16747, max versions: 1
Data pages: 5064, data page slots: 5064, average fill: 73%
Fill distribution:
0 - 19% = 1
20 - 39% = 24
40 - 59% = 77
60 - 79% = 4883
80 - 99% = 79

Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 1552, nodes: 473984
Average data length: 11.74, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 151
20 - 39% = 42
40 - 59% = 592
60 - 79% = 113
80 - 99% = 654

Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 1387, nodes: 473984
Average data length: 5.94, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 25
40 - 59% = 1361
60 - 79% = 1
80 - 99% = 0

Index FK_DOC_DATA_DOC_LIST (3)
Depth: 2, leaf buckets: 460, nodes: 473984
Average data length: 0.88, total dup: 407992, max dup: 49
Fill distribution:
0 - 19% = 3
20 - 39% = 21
40 - 59% = 194
60 - 79% = 12
80 - 99% = 230

DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 58.19, total records: 80223
Average version length: 49.69, total versions: 9182, max versions: 7
Data pages: 1019, data page slots: 1019, average fill: 80%
Fill distribution:
0 - 19% = 4
20 - 39% = 25
40 - 59% = 39
60 - 79% = 208
80 - 99% = 743

Index DOC_LIST_ID_DESC (1)
Depth: 2, leaf buckets: 229, nodes: 80223
Average data length: 6.26, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 9
40 - 59% = 219
60 - 79% = 1
80 - 99% = 0

Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 66, nodes: 80223
Average data length: 0.01, total dup: 80173, max dup: 18457
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 39
60 - 79% = 19
80 - 99% = 8

Index PK_DOC_LIST (0)
Depth: 2, leaf buckets: 165, nodes: 80223
Average data length: 6.26, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 6
20 - 39% = 9
40 - 59% = 80
60 - 79% = 1
80 - 99% = 69

DOC_STATES (153)
Primary pointer page: 257, Index root page: 258
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 13.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_NAME_UNQ (2)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 29.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_DOC_STATES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 1.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

FB_ERRORS (159)
Primary pointer page: 287, Index root page: 288
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 12, data page slots: 12, average fill: 75%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7

Index FB_ERRORS_GDS_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 758
Average data length: 1.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

INVNT_SALDO (147)
Primary pointer page: 216, Index root page: 217
Average record length: 62.64, total records: 400
Average version length: 13.58, total versions: 89345, max versions: 268
Data pages: 354, data page slots: 354, average fill: 96%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 353

Index PK_INVNT_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 278, Index root page: 279
Average record length: 0.01, total records: 178664
Average version length: 68.67, total versions: 178645, max versions: 1
Data pages: 2600, data page slots: 2600, average fill: 87%
Fill distribution:
0 - 19% = 16
20 - 39% = 64
40 - 59% = 110
60 - 79% = 245
80 - 99% = 2165

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 3, leaf buckets: 433, nodes: 178664
Average data length: 8.20, total dup: 21561, max dup: 7
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 85
60 - 79% = 234
80 - 99% = 110

MONEY_SALDO (143)
Primary pointer page: 208, Index root page: 209
Average record length: 15.12, total records: 49
Average version length: 9.00, total versions: 4226, max versions: 340
Data pages: 16, data page slots: 16, average fill: 85%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 14

Index PK_MONEY_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 49
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MONEY_TURNOVER_LOG (142)
Primary pointer page: 206, Index root page: 207
Average record length: 0.03, total records: 8409
Average version length: 44.10, total versions: 8404, max versions: 1
Data pages: 90, data page slots: 90, average fill: 90%
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 0
60 - 79% = 1
80 - 99% = 85

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 2, leaf buckets: 6, nodes: 8409
Average data length: 0.11, total dup: 8315, max dup: 1883
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 2

MON_LOG (164)
Primary pointer page: 303, Index root page: 304
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_DTS (4)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_ROWSET_DESC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_UNIT (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG_TABLE_STATS (165)
Primary pointer page: 316, Index root page: 317
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_DTS (4)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_ROWSET (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG_TABLE_STATS (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

OPTYPES (138)
Primary pointer page: 186, Index root page: 187
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 9%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index OPTYPES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 4.56, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_OPTYPES (0)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 2.11, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PDISTR (150)
Primary pointer page: 241, Index root page: 242
Average record length: 22.68, total records: 148967
Average version length: 32.15, total versions: 109953, max versions: 11
Data pages: 1594, data page slots: 1594, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 15
60 - 79% = 242
80 - 99% = 1330

Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 136, nodes: 148967
Average data length: 0.01, total dup: 148918, max dup: 34065
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 94
60 - 79% = 20
80 - 99% = 19

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 161, nodes: 148967
Average data length: 0.90, total dup: 134031, max dup: 39
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 98
60 - 79% = 37
80 - 99% = 22

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 168, nodes: 148967
Average data length: 0.90, total dup: 134031, max dup: 39
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 108
60 - 79% = 36
80 - 99% = 21

Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 146, nodes: 148967
Average data length: 0.67, total dup: 134031, max dup: 39
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 57
60 - 79% = 67
80 - 99% = 20

PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 27.15, total records: 23253
Average version length: 18.00, total versions: 2, max versions: 1
Data pages: 192, data page slots: 192, average fill: 65%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 191
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 16, nodes: 23253
Average data length: 0.01, total dup: 23063, max dup: 1012
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 5
60 - 79% = 5
80 - 99% = 6

PERF_ISQL_STAT (161)
Primary pointer page: 296, Index root page: 297
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PERF_ISQL_STAT_TRN (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PERF_LOG (162)
Primary pointer page: 299, Index root page: 300
Average record length: 144.05, total records: 1234543
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 28146, data page slots: 28146, average fill: 86%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 28145

Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 1538, nodes: 1234543
Average data length: 0.62, total dup: 677133, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1149
60 - 79% = 264
80 - 99% = 125

Index PERF_LOG_GDSCODE (3)
Depth: 3, leaf buckets: 1218, nodes: 1234543
Average data length: 0.00, total dup: 1234538, max dup: 1201626
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1215
60 - 79% = 2
80 - 99% = 1

Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 1540, nodes: 1234543
Average data length: 0.39, total dup: 1160272, max dup: 3176
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1331
60 - 79% = 115
80 - 99% = 94

Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 1364, nodes: 1234543
Average data length: 0.25, total dup: 1206200, max dup: 137355
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 999
60 - 79% = 165
80 - 99% = 197

PHRASES (145)
Primary pointer page: 212, Index root page: 213
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_ID_DESC (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_NAME (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_PHRASES (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PSTORNED (151)
Primary pointer page: 248, Index root page: 249
Average record length: 50.90, total records: 88153
Average version length: 54.81, total versions: 6208, max versions: 1
Data pages: 1029, data page slots: 1029, average fill: 77%
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 4
60 - 79% = 960
80 - 99% = 63

Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 111, nodes: 88153
Average data length: 1.13, total dup: 73150, max dup: 223
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 108
60 - 79% = 2
80 - 99% = 1

Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 81, nodes: 88153
Average data length: 0.61, total dup: 80375, max dup: 94
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 38
60 - 79% = 35
80 - 99% = 7

RULES_FOR_PDISTR (152)
Primary pointer page: 250, Index root page: 251
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_PDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 7.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

RULES_FOR_QDISTR (139)
Primary pointer page: 190, Index root page: 191
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 1.57, total dup: 2, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 6.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SEMAPHORES (156)
Primary pointer page: 263, Index root page: 264
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 904, max versions: 502
Data pages: 4, data page slots: 4, average fill: 73%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 3

Index PK_SEMAPHORES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 8.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index SEMAPHORES_TASK_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 18.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SETTINGS (137)
Primary pointer page: 183, Index root page: 184
Average record length: 98.32, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2, data page slots: 2, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1

Index SETTINGS_MODE_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 114
Average data length: 23.07, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 180, Index root page: 181
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 178, Index root page: 179
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$DEP_DOCS (129)
Primary pointer page: 159, Index root page: 160
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_DEP_DOCS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$IDX_RECALC (132)
Primary pointer page: 169, Index root page: 170
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG (133)
Primary pointer page: 174, Index root page: 175
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 176, Index root page: 177
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_LOG (163)
Primary pointer page: 301, Index root page: 302
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_MON (131)
Primary pointer page: 167, Index root page: 168
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$RESULT_SET (130)
Primary pointer page: 162, Index root page: 163
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_DOC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_WARE_DOC (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$SHOPPING_CART (128)
Primary pointer page: 155, Index root page: 156
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_SHOPCART_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TRACE_STAT (276)
Primary pointer page: 513, Index root page: 95177
Average record length: 59.21, total records: 312
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 4, data page slots: 4, average fill: 73%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 0

WARES (144)
Primary pointer page: 210, Index root page: 211
Average record length: 78.00, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 6, data page slots: 6, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2

Index FK_WARES_WARE_GROUPS (3)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 0.14, total dup: 392, max dup: 62
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARES (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Depth: 2, leaf buckets: 2, nodes: 400
Average data length: 19.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0

WARE_GROUPS (155)
Primary pointer page: 261, Index root page: 262
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARE_GROUPS (0)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 7.25, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index WARE_GROUPS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 15.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_1000_1200 (258)
Primary pointer page: 645, Index root page: 646
Average record length: 0.33, total records: 292215
Average version length: 69.74, total versions: 290855, max versions: 1
Data pages: 4017, data page slots: 4017, average fill: 93%
Fill distribution:
0 - 19% = 55
20 - 39% = 39
40 - 59% = 19
60 - 79% = 22
80 - 99% = 3882

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 344, nodes: 292215
Average data length: 1.24, total dup: 256173, max dup: 29
Fill distribution:
0 - 19% = 10
20 - 39% = 2
40 - 59% = 125
60 - 79% = 141
80 - 99% = 66

XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 51.54, total records: 277327
Average version length: 69.21, total versions: 72380, max versions: 1
Data pages: 3805, data page slots: 3859, average fill: 82%
Fill distribution:
0 - 19% = 4
20 - 39% = 19
40 - 59% = 41
60 - 79% = 1888
80 - 99% = 1853

Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 244, nodes: 277327
Average data length: 0.15, total dup: 271154, max dup: 217
Fill distribution:
0 - 19% = 1
20 - 39% = 12
40 - 59% = 123
60 - 79% = 14
80 - 99% = 94

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 321, nodes: 277327
Average data length: 1.25, total dup: 243267, max dup: 44
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 133
60 - 79% = 127
80 - 99% = 61

XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 0.03, total records: 353588
Average version length: 69.72, total versions: 353428, max versions: 1
Data pages: 4788, data page slots: 4790, average fill: 94%
Fill distribution:
0 - 19% = 10
20 - 39% = 23
40 - 59% = 19
60 - 79% = 14
80 - 99% = 4722

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 391, nodes: 353588
Average data length: 0.96, total dup: 320450, max dup: 146
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 137
60 - 79% = 185
80 - 99% = 66

XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 19.11, total records: 1057785
Average version length: 68.31, total versions: 767667, max versions: 1
Data pages: 14252, data page slots: 14252, average fill: 89%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 3506
80 - 99% = 10745

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1349, nodes: 1057785
Average data length: 1.13, total dup: 935437, max dup: 128
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1052
60 - 79% = 124
80 - 99% = 173

XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 5.95, total records: 214880
Average version length: 68.82, total versions: 196365, max versions: 1
Data pages: 4007, data page slots: 4027, average fill: 68%
Fill distribution:
0 - 19% = 66
20 - 39% = 279
40 - 59% = 908
60 - 79% = 1331
80 - 99% = 1423

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 315, nodes: 214880
Average data length: 1.39, total dup: 185123, max dup: 171
Fill distribution:
0 - 19% = 2
20 - 39% = 49
40 - 59% = 158
60 - 79% = 98
80 - 99% = 8

XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 36.14, total records: 745173
Average version length: 68.35, total versions: 354067, max versions: 1
Data pages: 10509, data page slots: 10526, average fill: 82%
Fill distribution:
0 - 19% = 166
20 - 39% = 204
40 - 59% = 283
60 - 79% = 3126
80 - 99% = 6730

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1029, nodes: 745173
Average data length: 1.31, total dup: 645478, max dup: 44
Fill distribution:
0 - 19% = 0
20 - 39% = 19
40 - 59% = 785
60 - 79% = 116
80 - 99% = 109

XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 78.46, total records: 1006541
Average version length: 80.90, total versions: 27897, max versions: 1
Data pages: 15029, data page slots: 15029, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 6529
80 - 99% = 8500

Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 1113, nodes: 1006541
Average data length: 0.16, total dup: 983775, max dup: 152
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 815
60 - 79% = 234
80 - 99% = 56

Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 790, nodes: 1006541
Average data length: 0.72, total dup: 884669, max dup: 49
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 118
60 - 79% = 14
80 - 99% = 655

Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 1264, nodes: 1006541
Average data length: 0.74, total dup: 881665, max dup: 36
Fill distribution:
0 - 19% = 10
20 - 39% = 0
40 - 59% = 915
60 - 79% = 289
80 - 99% = 50

XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 69.82, total records: 611863
Average version length: 80.13, total versions: 79527, max versions: 1
Data pages: 9359, data page slots: 9374, average fill: 80%
Fill distribution:
0 - 19% = 87
20 - 39% = 115
40 - 59% = 153
60 - 79% = 5064
80 - 99% = 3940

Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 635, nodes: 611863
Average data length: 0.15, total dup: 598354, max dup: 288
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 384
60 - 79% = 194
80 - 99% = 54

Index XQS_1000_3300_RCV_ID (2)
Depth: 3, leaf buckets: 498, nodes: 611863
Average data length: 0.83, total dup: 530873, max dup: 14
Fill distribution:
0 - 19% = 4
20 - 39% = 19
40 - 59% = 65
60 - 79% = 1
80 - 99% = 409

Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 761, nodes: 611863
Average data length: 0.73, total dup: 540006, max dup: 44
Fill distribution:
0 - 19% = 35
20 - 39% = 7
40 - 59% = 436
60 - 79% = 245
80 - 99% = 38

XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 76.47, total records: 1055151
Average version length: 82.00, total versions: 55558, max versions: 1
Data pages: 15760, data page slots: 15760, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 7410
80 - 99% = 8350

Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 1093, nodes: 1055151
Average data length: 0.05, total dup: 1048940, max dup: 945
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 728
60 - 79% = 272
80 - 99% = 93

Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 791, nodes: 1055151
Average data length: 0.69, total dup: 932606, max dup: 49
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 68
60 - 79% = 3
80 - 99% = 719

Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 1244, nodes: 1055151
Average data length: 0.69, total dup: 933293, max dup: 113
Fill distribution:
0 - 19% = 5
20 - 39% = 1
40 - 59% = 770
60 - 79% = 349
80 - 99% = 119

XQS_2000_3300 (267)
Primary pointer page: 683, Index root page: 684
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_DOC_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_RCV_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_SND_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQS_2100_3300 (268)
Primary pointer page: 691, Index root page: 692
Average record length: 72.10, total records: 771260
Average version length: 80.31, total versions: 80300, max versions: 1
Data pages: 11967, data page slots: 11998, average fill: 78%
Fill distribution:
0 - 19% = 186
20 - 39% = 219
40 - 59% = 275
60 - 79% = 5605
80 - 99% = 5682

Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 716, nodes: 771260
Average data length: 0.05, total dup: 766815, max dup: 648
Fill distribution:
0 - 19% = 1
20 - 39% = 8
40 - 59% = 271
60 - 79% = 300
80 - 99% = 136

Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 746, nodes: 771260
Average data length: 0.86, total dup: 666800, max dup: 14
Fill distribution:
0 - 19% = 25
20 - 39% = 33
40 - 59% = 258
60 - 79% = 0
80 - 99% = 430

Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 812, nodes: 771260
Average data length: 0.70, total dup: 682868, max dup: 85
Fill distribution:
0 - 19% = 0
20 - 39% = 11
40 - 59% = 268
60 - 79% = 366
80 - 99% = 167

XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 59.80, total records: 342973
Average version length: 68.32, total versions: 43119, max versions: 1
Data pages: 4618, data page slots: 4618, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 0
60 - 79% = 3560
80 - 99% = 1056

Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 311, nodes: 342973
Average data length: 0.21, total dup: 332408, max dup: 203
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 111
60 - 79% = 120
80 - 99% = 80

Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 360, nodes: 342973
Average data length: 0.81, total dup: 298900, max dup: 43
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 148
60 - 79% = 128
80 - 99% = 84

ZDOC_DATA (228)
Primary pointer page: 564, Index root page: 565
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZDOC_LIST (227)
Primary pointer page: 560, Index root page: 561
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZINVNT_TURNOVER_LOG (229)
Primary pointer page: 567, Index root page: 568
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPDISTR (232)
Primary pointer page: 573, Index root page: 574
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPSTORNED (233)
Primary pointer page: 575, Index root page: 576
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQDISTR (230)
Primary pointer page: 569, Index root page: 570
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQSTORNED (231)
Primary pointer page: 571, Index root page: 572
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_DOC_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_RCV_ID (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_SND_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_DEP_DOCS (226)
Primary pointer page: 558, Index root page: 559
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_SHOPPING_CART (225)
Primary pointer page: 556, Index root page: 557
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Z_USED_VIEWS (146)
Primary pointer page: 214, Index root page: 215
Average record length: 29.19, total records: 32
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index Z_USED_VIEWS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 32
Average data length: 10.78, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Done for 18730 ms, from 2:35:09.94 to 2:35:28.67.

Analyzing DB stat log: obtaining values of total records and versions

TABLE_NAME TOTAL_RECS TOTAL_VERS VERS_PERCENT
AGENTS 50 0 0.0000
BUSINESS_OPS 19 0 0.0000
DOC_DATA 473984 16747 3.5332
DOC_LIST 80223 9182 11.4455
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 89345 22336.2500
INVNT_TURNOVER_LOG 178664 178645 99.9893
MONEY_SALDO 49 4226 8624.4897
MONEY_TURNOVER_LOG 8409 8404 99.9405
OPTYPES 9 0 0.0000
PDISTR 148967 109953 73.8103
PERF_ESTIMATED 23253 2 0.0086
PERF_LOG 1234543 1 0.0000
PSTORNED 88153 6208 7.0423
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 904 22600.0000
SETTINGS 114 0 0.0000
TRACE_STAT 312 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 292215 290855 99.5345
XQD_1000_3300 277327 72380 26.0991
XQD_1200_2000 353588 353428 99.9547
XQD_2000_3300 1057785 767667 72.5730
XQD_2100_3300 214880 196365 91.3835
XQD_3300_3400 745173 354067 47.5147
XQS_1000_1200 1006541 27897 2.7715
XQS_1000_3300 611863 79527 12.9975
XQS_1200_2000 1055151 55558 5.2654
XQS_2100_3300 771260 80300 10.4115
XQS_3300_3400 342973 43119 12.5721
Z_USED_VIEWS 32 0 0.0000
Done for 2140 ms, from 2:35:37.49 to 2:35:39.63.

Database validation

02:35:39.95 Validation started

02:35:40.00 Relation 140 (DOC_LIST)
02:35:40.00 process pointer page 0 of 1
02:35:40.06 Index 1 (PK_DOC_LIST)
02:35:40.08 Index 2 (DOC_LIST_ID_DESC)
02:35:40.11 Index 3 (FK_DOC_LIST_AGENTS)
02:35:40.12 Relation 140 (DOC_LIST) is ok

02:35:40.12 Relation 141 (DOC_DATA)
02:35:40.12 process pointer page 0 of 3
02:35:40.19 process pointer page 1 of 3
02:35:40.23 process pointer page 2 of 3
02:35:40.27 Index 2 (DOC_DATA_DOC_WARE_UNQ)
02:35:40.34 Index 3 (DOC_DATA_ID_DESC)
02:35:40.47 Index 4 (FK_DOC_DATA_DOC_LIST)
02:35:40.59 Relation 141 (DOC_DATA) is ok

02:35:40.59 Relation 147 (INVNT_SALDO)
02:35:40.59 process pointer page 0 of 1
02:35:40.69 Index 1 (PK_INVNT_SALDO)
02:35:40.69 Relation 147 (INVNT_SALDO) is ok

02:35:40.69 Relation 150 (PDISTR)
02:35:40.69 process pointer page 0 of 1
02:35:40.75 Index 2 (PDISTR_SND_ID)
02:35:40.76 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
02:35:40.80 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
02:35:40.84 Index 5 (PDISTR_AGENT_ID)
02:35:40.89 Relation 150 (PDISTR) is ok

02:35:40.89 Relation 151 (PSTORNED)
02:35:40.89 process pointer page 0 of 1
02:35:40.94 Index 2 (PSTORNED_SND_ID)
02:35:40.97 Index 3 (PSTORNED_RCV_ID)
02:35:40.98 Relation 151 (PSTORNED) is ok

02:35:40.98 Relation 156 (SEMAPHORES)
02:35:40.98 process pointer page 0 of 1
02:35:40.98 Index 1 (PK_SEMAPHORES)
02:35:40.98 Index 2 (SEMAPHORES_TASK_UNQ)
02:35:40.98 Relation 156 (SEMAPHORES) is ok

02:35:40.98 Relation 157 (INVNT_TURNOVER_LOG)
02:35:40.98 process pointer page 0 of 2
02:35:41.09 process pointer page 1 of 2
02:35:41.15 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
02:35:41.26 Relation 157 (INVNT_TURNOVER_LOG) is ok

02:35:41.26 Relation 160 (PERF_ESTIMATED)
02:35:41.26 process pointer page 0 of 1
02:35:41.28 Index 1 (PERF_EST_MINUTE_SINCE_START)
02:35:41.28 Relation 160 (PERF_ESTIMATED) is ok

02:35:41.28 Relation 161 (PERF_ISQL_STAT)
02:35:41.28 process pointer page 0 of 1
02:35:41.28 Index 1 (PERF_ISQL_STAT_TRN)
02:35:41.28 Relation 161 (PERF_ISQL_STAT) is ok

02:35:41.28 Relation 162 (PERF_LOG)
02:35:41.28 process pointer page 0 of 15
02:35:41.34 process pointer page 1 of 15
02:35:41.36 process pointer page 2 of 15
02:35:41.42 process pointer page 3 of 15
02:35:41.45 process pointer page 4 of 15
02:35:41.50 process pointer page 5 of 15
02:35:41.58 process pointer page 6 of 15
02:35:41.65 process pointer page 7 of 15
02:35:41.73 process pointer page 8 of 15
02:35:41.81 process pointer page 9 of 15
02:35:41.87 process pointer page 10 of 15
02:35:41.95 process pointer page 11 of 15
02:35:42.01 process pointer page 12 of 15
02:35:42.09 process pointer page 13 of 15
02:35:42.15 process pointer page 14 of 15
02:35:42.20 Index 1 (PERF_LOG_DTS_BEG_DESC)
02:35:42.61 Index 2 (PERF_LOG_UNIT)
02:35:42.84 Index 3 (PERF_LOG_TRN_DESC)
02:35:43.04 Index 4 (PERF_LOG_GDSCODE)
02:35:43.23 Relation 162 (PERF_LOG) is ok

02:35:43.23 Relation 166 (V_STOPTEST)
02:35:43.23 Relation 166 (V_STOPTEST) is ok

02:35:43.23 Relation 183 (V_QDISTR_SOURCE)
02:35:43.23 Relation 183 (V_QDISTR_SOURCE) is ok

02:35:43.23 Relation 184 (V_QSTORNED_SOURCE)
02:35:43.23 Relation 184 (V_QSTORNED_SOURCE) is ok

02:35:43.23 Relation 258 (XQD_1000_1200)
02:35:43.23 process pointer page 0 of 3
02:35:43.29 process pointer page 1 of 3
02:35:43.45 process pointer page 2 of 3
02:35:43.46 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
02:35:43.56 Relation 258 (XQD_1000_1200) is ok

02:35:43.56 Relation 259 (XQD_1200_2000)
02:35:43.56 process pointer page 0 of 3
02:35:43.73 process pointer page 1 of 3
02:35:43.92 process pointer page 2 of 3
02:35:43.98 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
02:35:44.02 Relation 259 (XQD_1200_2000) is ok

02:35:44.02 Relation 260 (XQD_1000_3300)
02:35:44.02 process pointer page 0 of 3
02:35:44.07 process pointer page 1 of 3
02:35:44.12 process pointer page 2 of 3
02:35:44.12 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
02:35:44.20 Index 2 (XQD_1000_3300_DOC)
02:35:44.26 Relation 260 (XQD_1000_3300) is ok

02:35:44.26 Relation 261 (XQD_2000_3300)
02:35:44.26 process pointer page 0 of 8
02:35:44.40 process pointer page 1 of 8
02:35:44.52 process pointer page 2 of 8
02:35:44.59 process pointer page 3 of 8
02:35:44.66 process pointer page 4 of 8
02:35:44.71 process pointer page 5 of 8
02:35:44.82 process pointer page 6 of 8
02:35:44.85 process pointer page 7 of 8
02:35:44.90 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
02:35:45.13 Relation 261 (XQD_2000_3300) is ok

02:35:45.13 Relation 262 (XQD_2100_3300)
02:35:45.13 process pointer page 0 of 3
02:35:45.18 process pointer page 1 of 3
02:35:45.23 process pointer page 2 of 3
02:35:45.24 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
02:35:45.26 Relation 262 (XQD_2100_3300) is ok

02:35:45.26 Relation 263 (XQD_3300_3400)
02:35:45.26 process pointer page 0 of 6
02:35:45.32 process pointer page 1 of 6
02:35:45.44 process pointer page 2 of 6
02:35:45.52 process pointer page 3 of 6
02:35:45.58 process pointer page 4 of 6
02:35:45.65 process pointer page 5 of 6
02:35:45.66 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
02:35:45.82 Relation 263 (XQD_3300_3400) is ok

02:35:45.82 Relation 264 (XQS_1000_1200)
02:35:45.82 process pointer page 0 of 8
02:35:45.85 process pointer page 1 of 8
02:35:45.91 process pointer page 2 of 8
02:35:46.01 process pointer page 3 of 8
02:35:46.10 process pointer page 4 of 8
02:35:46.15 process pointer page 5 of 8
02:35:46.21 process pointer page 6 of 8
02:35:46.30 process pointer page 7 of 8
02:35:46.33 Index 1 (XQS_1000_1200_DOC_ID)
02:35:46.58 Index 2 (XQS_1000_1200_SND_ID)
02:35:46.79 Index 3 (XQS_1000_1200_RCV_ID)
02:35:46.88 Relation 264 (XQS_1000_1200) is ok

02:35:46.88 Relation 265 (XQS_1200_2000)
02:35:46.88 process pointer page 0 of 9
02:35:46.91 process pointer page 1 of 9
02:35:46.93 process pointer page 2 of 9
02:35:46.96 process pointer page 3 of 9
02:35:46.99 process pointer page 4 of 9
02:35:47.02 process pointer page 5 of 9
02:35:47.05 process pointer page 6 of 9
02:35:47.08 process pointer page 7 of 9
02:35:47.13 process pointer page 8 of 9
02:35:47.14 Index 1 (XQS_1200_2000_DOC_ID)
02:35:47.36 Index 2 (XQS_1200_2000_SND_ID)
02:35:47.57 Index 3 (XQS_1200_2000_RCV_ID)
02:35:47.69 Relation 265 (XQS_1200_2000) is ok

02:35:47.69 Relation 266 (XQS_1000_3300)
02:35:47.69 process pointer page 0 of 5
02:35:47.74 process pointer page 1 of 5
02:35:47.77 process pointer page 2 of 5
02:35:47.80 process pointer page 3 of 5
02:35:47.83 process pointer page 4 of 5
02:35:47.86 Index 1 (XQS_1000_3300_DOC_ID)
02:35:47.91 Index 2 (XQS_1000_3300_SND_ID)
02:35:47.96 Index 3 (XQS_1000_3300_RCV_ID)
02:35:47.99 Relation 266 (XQS_1000_3300) is ok

02:35:47.99 Relation 267 (XQS_2000_3300)
02:35:48.00 process pointer page 0 of 1
02:35:48.00 Index 1 (XQS_2000_3300_DOC_ID)
02:35:48.00 Index 2 (XQS_2000_3300_SND_ID)
02:35:48.00 Index 3 (XQS_2000_3300_RCV_ID)
02:35:48.00 Relation 267 (XQS_2000_3300) is ok

02:35:48.00 Relation 268 (XQS_2100_3300)
02:35:48.00 process pointer page 0 of 7
02:35:48.02 process pointer page 1 of 7
02:35:48.05 process pointer page 2 of 7
02:35:48.08 process pointer page 3 of 7
02:35:48.10 process pointer page 4 of 7
02:35:48.13 process pointer page 5 of 7
02:35:48.16 process pointer page 6 of 7
02:35:48.16 Index 1 (XQS_2100_3300_DOC_ID)
02:35:48.27 Index 2 (XQS_2100_3300_SND_ID)
02:35:48.42 Index 3 (XQS_2100_3300_RCV_ID)
02:35:48.61 Relation 268 (XQS_2100_3300) is ok

02:35:48.61 Relation 269 (XQS_3300_3400)
02:35:48.61 process pointer page 0 of 3
02:35:48.72 process pointer page 1 of 3
02:35:48.78 process pointer page 2 of 3
02:35:48.80 Index 1 (XQS_3300_3400_DOC_ID)
02:35:48.83 Index 2 (XQS_3300_3400_SND_ID)
02:35:48.86 Relation 269 (XQS_3300_3400) is ok

02:35:48.86 Relation 276 (TRACE_STAT)
02:35:48.86 process pointer page 0 of 1
02:35:48.86 Relation 276 (TRACE_STAT) is ok

02:35:48.86 Validation finished
Done for 9360 ms, from 2:35:39.66 to 2:35:49.02.

Differences between old and current firebird.log

2:35:49.72. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG: 5 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-08-30 02:35 309 oltp25_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

Comparison of old and new firebird.log (get messages that appeared during test):

+++ Start of comparison +++
result: files match. No new messages appeared in firebird.log during test ran.
+++ End of comparison +++

Final processing ISQL logs in e:\temp\logs.oltp25


Remove 401 logs of every ISQL session if there were no serious errors.

Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp25\oltp25_*.*:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2016-08-30 2:35:52.28 - end of report, text file: e:\temp\logs.oltp25\oltp25.report.txt, html: e:\temp\logs.oltp25\oltp25.report.html

Subscribe to IBSurgeon news

Subscribe