en
brFirebird 2.5 Performance Logs
Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2016-10-25 22:29:08.41.
Server implementation: Firebird/x86-64/Windows NT
Done for 3830 ms, from 22:29:20.77 to 22:29:24.60.
Done for 5130 ms, from 22:29:27.09 to 22:29:32.22.
Done for 2460 ms, from 22:29:32.47 to 22:29:34.93.
Done for 13330 ms, from 22:29:39.75 to 22:29:53.08.
Done for 2220 ms, from 22:29:53.48 to 22:29:55.70.
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 76533
MON$OLDEST_ACTIVE 76534
MON$OLDEST_SNAPSHOT 76534
MON$NEXT_TRANSACTION 76534
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 120792
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.7.27026 Firebird 2.5 HQbird
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.7.27026 Firebird 2.5 HQbird"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.7.27026 Firebird 2.5 HQbird/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.7.27026 Firebird 2.5 HQbird/tcp (WIN-2BE1UI8LGDL)/P12"
on disk structure version 11.2
Database "D:\OLTP-EMUL\oltp25-small.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 80976
Page size 8192
ODS version 11.2
Oldest transaction 76535
Oldest active 76536
Oldest snapshot 76536
Next transaction 76537
Bumped transaction 1
Sequence number 0
Next attachment ID 4411
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
Database GUID: {1B856C5D-0E20-4F6F-B5A2-A328411E6B80}
*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: 45.32, total records: 372878
Average version length: 46.10, total versions: 5655, max versions: 1
Data pages: 4037, data page slots: 4037, average fill: 72%
Fill distribution:
0 - 19% = 3
20 - 39% = 15
40 - 59% = 244
60 - 79% = 3764
80 - 99% = 11
Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 1076, nodes: 372878
Average data length: 11.49, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 117
20 - 39% = 17
40 - 59% = 254
60 - 79% = 42
80 - 99% = 646
Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 1116, nodes: 372878
Average data length: 6.07, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 71
40 - 59% = 1044
60 - 79% = 1
80 - 99% = 0
Index FK_DOC_DATA_DOC_LIST (3)
Depth: 2, leaf buckets: 303, nodes: 372878
Average data length: 0.77, total dup: 328098, max dup: 49
Fill distribution:
0 - 19% = 2
20 - 39% = 25
40 - 59% = 44
60 - 79% = 3
80 - 99% = 229
DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 59.13, total records: 56811
Average version length: 54.33, total versions: 3333, max versions: 5
Data pages: 707, data page slots: 707, average fill: 79%
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 41
60 - 79% = 249
80 - 99% = 414
Index DOC_LIST_ID_DESC (1)
Depth: 2, leaf buckets: 164, nodes: 56811
Average data length: 6.31, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 14
40 - 59% = 150
60 - 79% = 0
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 43, nodes: 56811
Average data length: 0.01, total dup: 56761, max dup: 15211
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 21
60 - 79% = 13
80 - 99% = 9
Index PK_DOC_LIST (0)
Depth: 2, leaf buckets: 95, nodes: 56811
Average data length: 6.31, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 11
60 - 79% = 0
80 - 99% = 70
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.73, total records: 400
Average version length: 13.31, total versions: 32814, max versions: 100
Data pages: 133, data page slots: 133, average fill: 96%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 132
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: 1.04, total records: 60995
Average version length: 68.23, total versions: 60066, max versions: 1
Data pages: 999, data page slots: 1011, average fill: 77%
Fill distribution:
0 - 19% = 18
20 - 39% = 12
40 - 59% = 74
60 - 79% = 371
80 - 99% = 524
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 2, leaf buckets: 175, nodes: 60995
Average data length: 8.61, total dup: 6071, max dup: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 92
60 - 79% = 73
80 - 99% = 5
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: 1845, max versions: 133
Data pages: 7, data page slots: 7, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 6
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.70, total records: 3584
Average version length: 44.11, total versions: 3526, max versions: 1
Data pages: 39, data page slots: 39, average fill: 88%
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 37
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 2, leaf buckets: 3, nodes: 3584
Average data length: 0.25, total dup: 3494, max dup: 757
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 1
80 - 99% = 0
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: 29.12, total records: 101140
Average version length: 31.63, total versions: 50552, max versions: 11
Data pages: 1053, data page slots: 1053, average fill: 83%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 465
80 - 99% = 586
Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 77, nodes: 101140
Average data length: 0.01, total dup: 101091, max dup: 19747
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 36
60 - 79% = 23
80 - 99% = 17
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 100, nodes: 101140
Average data length: 0.89, total dup: 91071, max dup: 29
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 57
60 - 79% = 24
80 - 99% = 17
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 101, nodes: 101140
Average data length: 0.89, total dup: 91071, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 57
60 - 79% = 25
80 - 99% = 19
Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 93, nodes: 101140
Average data length: 0.67, total dup: 91071, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 43
60 - 79% = 32
80 - 99% = 15
PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 27.42, total records: 9020
Average version length: 18.00, total versions: 2, max versions: 1
Data pages: 77, data page slots: 77, average fill: 64%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 76
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 7, nodes: 9020
Average data length: 0.00, total dup: 9009, max dup: 1610
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 4
60 - 79% = 3
80 - 99% = 0
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: 141.71, total records: 823646
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 18533, data page slots: 18533, average fill: 86%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 18532
Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 1102, nodes: 823646
Average data length: 0.60, total dup: 416600, max dup: 35
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1013
60 - 79% = 67
80 - 99% = 22
Index PERF_LOG_GDSCODE (3)
Depth: 2, leaf buckets: 808, nodes: 823646
Average data length: 0.00, total dup: 823641, max dup: 800081
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 805
60 - 79% = 1
80 - 99% = 2
Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 1101, nodes: 823646
Average data length: 0.47, total dup: 763462, max dup: 4021
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1052
60 - 79% = 36
80 - 99% = 13
Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 901, nodes: 823646
Average data length: 0.17, total dup: 812328, max dup: 92931
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 678
60 - 79% = 102
80 - 99% = 120
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: 52.96, total records: 73330
Average version length: 54.66, total versions: 2185, max versions: 1
Data pages: 852, data page slots: 852, average fill: 76%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 5
60 - 79% = 834
80 - 99% = 12
Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 91, nodes: 73330
Average data length: 1.10, total dup: 61177, max dup: 144
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 87
60 - 79% = 0
80 - 99% = 4
Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 68, nodes: 73330
Average data length: 0.59, total dup: 67124, max dup: 92
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 36
60 - 79% = 26
80 - 99% = 6
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: 348, max versions: 190
Data pages: 2, data page slots: 2, average fill: 57%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
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: 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
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.40, total records: 116784
Average version length: 69.19, total versions: 116113, max versions: 1
Data pages: 1562, data page slots: 1562, average fill: 94%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 14
80 - 99% = 1548
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 124, nodes: 116784
Average data length: 1.31, total dup: 102344, max dup: 29
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 37
60 - 79% = 56
80 - 99% = 29
XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 56.56, total records: 115689
Average version length: 69.18, total versions: 21095, max versions: 1
Data pages: 1591, data page slots: 1756, average fill: 80%
Fill distribution:
0 - 19% = 20
20 - 39% = 18
40 - 59% = 16
60 - 79% = 802
80 - 99% = 735
Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 111, nodes: 115689
Average data length: 0.15, total dup: 113146, max dup: 193
Fill distribution:
0 - 19% = 2
20 - 39% = 4
40 - 59% = 79
60 - 79% = 10
80 - 99% = 16
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 143, nodes: 115689
Average data length: 1.33, total dup: 101342, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 81
60 - 79% = 44
80 - 99% = 12
XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 0.97, total records: 131534
Average version length: 69.18, total versions: 129697, max versions: 1
Data pages: 1756, data page slots: 1756, average fill: 94%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 20
80 - 99% = 1735
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 129, nodes: 131534
Average data length: 0.94, total dup: 120327, max dup: 99
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 45
60 - 79% = 51
80 - 99% = 33
XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 12.80, total records: 823134
Average version length: 68.12, total versions: 670410, max versions: 1
Data pages: 11080, data page slots: 11080, average fill: 90%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1969
80 - 99% = 9110
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1037, nodes: 823134
Average data length: 1.17, total dup: 724527, max dup: 49
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 771
60 - 79% = 109
80 - 99% = 156
XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 43.90, total records: 166788
Average version length: 68.41, total versions: 59725, max versions: 1
Data pages: 2491, data page slots: 2638, average fill: 76%
Fill distribution:
0 - 19% = 39
20 - 39% = 106
40 - 59% = 193
60 - 79% = 384
80 - 99% = 1769
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 230, nodes: 166788
Average data length: 1.43, total dup: 142798, max dup: 78
Fill distribution:
0 - 19% = 0
20 - 39% = 15
40 - 59% = 133
60 - 79% = 80
80 - 99% = 2
XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 35.79, total records: 551351
Average version length: 68.14, total versions: 262643, max versions: 1
Data pages: 8456, data page slots: 8558, average fill: 75%
Fill distribution:
0 - 19% = 434
20 - 39% = 490
40 - 59% = 504
60 - 79% = 3064
80 - 99% = 3964
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 794, nodes: 551351
Average data length: 1.27, total dup: 480551, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 54
40 - 59% = 560
60 - 79% = 151
80 - 99% = 29
XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 79.22, total records: 811291
Average version length: 80.22, total versions: 9755, max versions: 1
Data pages: 12083, data page slots: 12083, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 6874
80 - 99% = 5209
Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 902, nodes: 811291
Average data length: 0.16, total dup: 792866, max dup: 124
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 680
60 - 79% = 172
80 - 99% = 44
Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 655, nodes: 811291
Average data length: 0.75, total dup: 712818, max dup: 49
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 131
60 - 79% = 11
80 - 99% = 510
Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 1031, nodes: 811291
Average data length: 0.77, total dup: 710237, max dup: 29
Fill distribution:
0 - 19% = 9
20 - 39% = 0
40 - 59% = 781
60 - 79% = 192
80 - 99% = 49
XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 74.71, total records: 547317
Average version length: 80.14, total versions: 36549, max versions: 1
Data pages: 8416, data page slots: 8502, average fill: 78%
Fill distribution:
0 - 19% = 132
20 - 39% = 133
40 - 59% = 128
60 - 79% = 5771
80 - 99% = 2252
Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 594, nodes: 547317
Average data length: 0.16, total dup: 535142, max dup: 201
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 422
60 - 79% = 137
80 - 99% = 29
Index XQS_1000_3300_RCV_ID (2)
Depth: 2, leaf buckets: 419, nodes: 547317
Average data length: 0.80, total dup: 476873, max dup: 14
Fill distribution:
0 - 19% = 2
20 - 39% = 18
40 - 59% = 15
60 - 79% = 3
80 - 99% = 381
Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 717, nodes: 547317
Average data length: 0.76, total dup: 480175, max dup: 29
Fill distribution:
0 - 19% = 33
20 - 39% = 2
40 - 59% = 516
60 - 79% = 140
80 - 99% = 26
XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 78.73, total records: 823300
Average version length: 80.70, total versions: 15043, max versions: 1
Data pages: 12263, data page slots: 12263, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 7286
80 - 99% = 4976
Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 867, nodes: 823300
Average data length: 0.05, total dup: 818153, max dup: 594
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 612
60 - 79% = 193
80 - 99% = 62
Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 628, nodes: 823300
Average data length: 0.73, total dup: 724648, max dup: 49
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 69
60 - 79% = 4
80 - 99% = 555
Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 991, nodes: 823300
Average data length: 0.74, total dup: 724994, max dup: 99
Fill distribution:
0 - 19% = 5
20 - 39% = 1
40 - 59% = 656
60 - 79% = 239
80 - 99% = 90
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: 75.77, total records: 579772
Average version length: 80.14, total versions: 31302, max versions: 1
Data pages: 9681, data page slots: 9846, average fill: 72%
Fill distribution:
0 - 19% = 565
20 - 39% = 536
40 - 59% = 384
60 - 79% = 6255
80 - 99% = 1941
Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 559, nodes: 579772
Average data length: 0.06, total dup: 575739, max dup: 629
Fill distribution:
0 - 19% = 1
20 - 39% = 34
40 - 59% = 229
60 - 79% = 196
80 - 99% = 99
Index XQS_2100_3300_RCV_ID (2)
Depth: 2, leaf buckets: 478, nodes: 579772
Average data length: 0.80, total dup: 505151, max dup: 14
Fill distribution:
0 - 19% = 3
20 - 39% = 53
40 - 59% = 32
60 - 79% = 7
80 - 99% = 383
Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 647, nodes: 579772
Average data length: 0.77, total dup: 507336, max dup: 71
Fill distribution:
0 - 19% = 0
20 - 39% = 51
40 - 59% = 215
60 - 79% = 268
80 - 99% = 113
XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 62.79, total records: 282226
Average version length: 68.24, total versions: 22464, max versions: 1
Data pages: 3796, data page slots: 3796, average fill: 79%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 3250
80 - 99% = 546
Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 248, nodes: 282226
Average data length: 0.22, total dup: 273463, max dup: 145
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 78
60 - 79% = 103
80 - 99% = 67
Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 297, nodes: 282226
Average data length: 0.82, total dup: 245479, max dup: 29
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 115
60 - 79% = 128
80 - 99% = 53
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 18770 ms, from 22:29:56.12 to 22:30:14.89.
Done for 2510 ms, from 22:30:24.78 to 22:30:27.29.
STDOUT: ---------- E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG: 2 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-10-25 22:30 87 oltp25_fb_log_when_test_finished.log
End of gathering firebird.log AFTER test finish.
Comparing files E:\TEMP\LOGS.OLTP25\oltp25_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP25\oltp25_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG
1: operating system directive fopen failed
2: -The system cannot find the file specified.
*****
+++ End of comparison +++
Remove 401 logs of every ISQL session if there were no serious errors.
ISQL logs are removed because no severe errors occured during test.
2016-10-25 22:30:39.94 - end of report, text file: e:\temp\logs.oltp25\oltp25.report.txt, html: e:\temp\logs.oltp25\oltp25.report.html
| Common | Performance | Final Results |
|---|---|---|
Server and database settings
Server version: WI-V2.5.7.27026 Firebird 2.5 HQbirdServer implementation: Firebird/x86-64/Windows NT
| FB_ARCHITECTURE | DB_NAME | FORCED_WRITES | SWEEP_INT | PAGE_BUFFERS | PAGE_SIZE |
|---|---|---|---|---|---|
| SuperClassic 2.5.7 | D:\OLTP-EMUL\OLTP25-SMALL.FDB | ON | 0 | 384 | 8192 |
Test configuration settings
File: E:\OLTP-EMUL\src\oltp25_config.win| PARAM_NAME | PARAM_VALUE |
|---|---|
| fbc | E:\FB257-HQB.TMP\bin\ |
| dbnm | D:\OLTP-EMUL\oltp25-small.fdb |
| host | localhost |
| port | 3257 |
| usr | SYSDBA |
| pwd | masterke |
| tmpdir | e:\temp\logs.oltp25 |
| working_mode | small_03 |
| warm_time | 0 |
| test_time | 10 |
| idle_time | 0 |
| use_mtee | 0 |
| is_embed | 0 |
| remove_isql_logs | if_no_severe_errors |
| no_auto_undo | 1 |
| detailed_info | 0 |
| mon_unit_perf | 0 |
| trc_unit_perf | 0 |
| init_buff | 32768 |
| create_with_fw | sync |
| create_with_sweep | 0 |
| wait_if_not_exists | 0 |
| wait_after_create | 0 |
| init_docs | 0 |
| wait_for_copy | 0 |
| create_with_debug_objects | 1 |
| create_with_split_heavy_tabs | 1 |
| create_with_separate_qdistr_idx | 0 |
| create_with_compound_columns_order | most_selective_first |
| make_html | 1 |
| run_db_statistics | 1 |
| run_db_validation | 1 |
| file_name_with_test_params | regular |
| file_name_this_host_info | ak25 |
| upload_report | 0 |
| max_snapshots_to_store | 0 |
| replace_instance | 0 |
Test finish info
| FINISH_STATE | DTS_END | FB_GDSCODE | FB_MNEMONA | STACK | IP | TRN_ID | ATT_ID | EXC_UNIT |
|---|---|---|---|---|---|---|---|---|
| NORMAL: TEST_TIME EXPIRED. | 2016-10-25 22:28:37.1970 | -1 | <null> | 127.0.0.1 | 76136 | 4251 | 2 |
Current test settings
| CATEGORY | SETTING | VAL |
|---|---|---|
| COMMON | TRACED_UNITS | ,, |
| COMMON | LOG_PK_VIOLATION | 0 |
| COMMON | QMISM_VERIFY_BITSET | 1 |
| COMMON | RECALC_IDX_MIN_INTERVAL | 15 |
| COMMON | ENABLE_RESERVES_WHEN_ADD_INVOICE | 1 |
| COMMON | ORDER_FOR_OUR_FIRM_PERCENT | 25 |
| COMMON | ENABLE_FILL_PHRASES | 0 |
| COMMON | RANDOM_SEEK_VIA_ROWS_LIMIT | 0 |
| COMMON | C_INVOICE_MIN_PURCHASE | 1000 |
| COMMON | C_INVOICE_MAX_PURCHASE | 2000 |
| COMMON | C_INVOICE_MIN_PROFIT_PRC | 35 |
| COMMON | C_INVOICE_MAX_PROFIT_PRC | 80 |
| COMMON | C_MIN_COST_TO_BE_SPLITTED | 1000 |
| COMMON | C_ROWS_TO_MULTIPLY | 10 |
| COMMON | C_PAYMENT_FROM_CLIENT_MIN_TOTAL | 1000 |
| COMMON | C_PAYMENT_FROM_CLIENT_MAX_TOTAL | 5000 |
| COMMON | C_PAYMENT_TO_SUPPLIER_MIN_TOTAL | 2000 |
| COMMON | C_PAYMENT_TO_SUPPLIER_MAX_TOTAL | 15000 |
| COMMON | BUILD_WITH_SPLIT_HEAVY_TABS | 1 |
| COMMON | BUILD_WITH_SEPAR_QDISTR_IDX | 0 |
| COMMON | BUILD_WITH_QD_COMPOUND_ORDR | MOST_SELECTIVE_FIRST |
| COMMON | ENABLE_MON_QUERY | 0 |
| COMMON | HALT_TEST_ON_ERRORS | ,CK, |
| SMALL_03 | C_WARES_MAX_ID | 400 |
| SMALL_03 | C_CUSTOMER_DOC_MAX_ROWS | 10 |
| SMALL_03 | C_SUPPLIER_DOC_MAX_ROWS | 50 |
| SMALL_03 | C_CUSTOMER_DOC_MAX_QTY | 15 |
| SMALL_03 | C_SUPPLIER_DOC_MAX_QTY | 50 |
| SMALL_03 | C_NUMBER_OF_AGENTS | 50 |
Index(es) for heavy-loaded table(s)
| TAB_NAME | IDX_NAME | IDX_KEY |
|---|---|---|
| XQD_1000_1200 | XQD_1000_1200_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
| XQD_1000_3300 | XQD_1000_3300_DOC | DOC_ID |
| XQD_1000_3300 | XQD_1000_3300_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
| XQD_1200_2000 | XQD_1200_2000_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
| XQD_2000_3300 | XQD_2000_3300_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
| XQD_2100_3300 | XQD_2100_3300_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
| XQD_3300_3400 | XQD_3300_3400_WARE_SOP_ROP_SND | WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID |
Performance reports
Performance in TOTAL:
| ACTION | AVG_TIMES_PER_MINUTE | AVG_ELAPSED_MS | SUCCESSFUL_TIMES_DONE | JOB_BEG | JOB_END |
|---|---|---|---|---|---|
| *** OVERALL *** for 10 minutes: | 1004.70 | 8396 | 10047 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| customer order: creation | 264.00 | 2767 | 2640 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| customer order: refuse | 20.50 | 49 | 205 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| order to supplier: creation | 70.80 | 19337 | 708 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| order to supplier: removal | 1.11 | 17143 | 10 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| invoice (draft): creation | 74.80 | 2309 | 748 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| invoice (draft): removal | 7.78 | 560 | 70 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| invoice accept: apply | 5.30 | 94900 | 53 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| invoice accept: cancel | 5.22 | 6281 | 47 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| customer reserve: creation | 108.10 | 5234 | 1081 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| customer reserve: removal | 62.60 | 854 | 626 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| realization accept: apply | 127.80 | 125 | 1278 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| realization accept: cancel | 46.30 | 58 | 463 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| payment from customer: creation | 89.40 | 203 | 894 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| payment from customer: removal | 9.30 | 32 | 93 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| payment to supplier: creation | 73.90 | 755 | 739 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| payment to supplier: removal | 4.20 | 44 | 42 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| service: total inventory turnovers | 19.10 | 1168 | 191 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| service: total monetary turnovers | 17.56 | 7 | 158 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| service: refresh index statistics | 1.00 | 7707 | 1 | 2016-10-25 22:18 | 2016-10-25 22:28 |
Performance in DYNAMIC:
| ACTION | ITRV_NO | CNT_OK_PER_MINUTE | CNT_ALL | CNT_OK | CNT_ERR | ERR_PRC | ITRV_BEG | ITRV_END |
|---|---|---|---|---|---|---|---|---|
| interval # 1, overall | 1 | 2212 | 2904 | 2212 | 692 | 23.83 | 22:18:38 | 22:19:37 |
| interval # 2, overall | 2 | 1494 | 1683 | 1494 | 189 | 11.23 | 22:19:38 | 22:20:37 |
| interval # 3, overall | 3 | 1342 | 1951 | 1342 | 609 | 31.21 | 22:20:38 | 22:21:37 |
| interval # 4, overall | 4 | 818 | 1257 | 818 | 439 | 34.92 | 22:21:38 | 22:22:37 |
| interval # 5, overall | 5 | 648 | 979 | 648 | 331 | 33.81 | 22:22:38 | 22:23:37 |
| interval # 6, overall | 6 | 644 | 864 | 644 | 220 | 25.46 | 22:23:38 | 22:24:37 |
| interval # 7, overall | 7 | 755 | 1013 | 755 | 258 | 25.47 | 22:24:38 | 22:25:37 |
| interval # 8, overall | 8 | 664 | 1043 | 664 | 379 | 36.34 | 22:25:38 | 22:26:37 |
| interval # 9, overall | 9 | 1045 | 1089 | 1045 | 44 | 4.04 | 22:26:38 | 22:27:37 |
| interval # 10, overall | 10 | 425 | 869 | 425 | 444 | 51.09 | 22:27:38 | 22:28:37 |
Performance for every MINUTE:
| TEST_PHASE | MINUTE_SINCE_TEST_START | AVG_ESTIMATED | MIN_TO_AVG_RATIO | MAX_TO_AVG_RATIO | ROWS_AGGREGATED | DISTINCT_ATTACHMENTS |
|---|---|---|---|---|---|---|
| TEST_TIME | 1 | 1559.27 | 0.3424 | 1.5622 | 1611 | 100 |
| TEST_TIME | 2 | 1570.46 | 0.7758 | 1.2340 | 1346 | 82 |
| TEST_TIME | 3 | 1487.02 | 0.8690 | 1.1270 | 1120 | 72 |
| TEST_TIME | 4 | 1348.97 | 0.9320 | 1.0622 | 647 | 59 |
| TEST_TIME | 5 | 1213.58 | 0.9448 | 1.0512 | 606 | 53 |
| TEST_TIME | 6 | 1122.15 | 0.9475 | 1.0488 | 670 | 48 |
| TEST_TIME | 7 | 1073.26 | 0.9401 | 1.0519 | 812 | 40 |
| TEST_TIME | 8 | 1034.38 | 0.9551 | 1.0453 | 783 | 29 |
| TEST_TIME | 9 | 1025.61 | 0.9372 | 1.0711 | 711 | 21 |
| TEST_TIME | 10 | 998.70 | 0.9900 | 1.0060 | 222 | 100 |
Config param. trc_unit_perf=0, trace for ISQL session #1 was not launched.
Performance in DETAILS:
| UNIT | CNT_ALL | CNT_OK | CNT_ERR | ERR_PRC | OK_MIN_MS | OK_MAX_MS | OK_AVG_MS | CNT_LK_CONFL | JOB_BEG | JOB_END |
|---|---|---|---|---|---|---|---|---|---|---|
| doc_list_aiud | 17768 | 14860 | 2908 | 16.36 | 0 | 6910 | 82 | 2908 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| doc_list_biud | 17812 | 14860 | 2952 | 16.57 | 0 | 32886 | 54 | 2952 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_add_invoice_to_stock | 541 | 53 | 488 | 90.20 | 62 | 520467 | 94900 | 488 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_cancel_adding_invoice | 94 | 47 | 47 | 50.00 | 16 | 56899 | 6281 | 47 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_cancel_client_order | 223 | 205 | 18 | 8.07 | 0 | 499 | 49 | 18 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_cancel_customer_reserve | 2823 | 626 | 2197 | 77.82 | 0 | 17487 | 854 | 2197 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_cancel_pay_from_customer | 93 | 93 | 0 | 0.00 | 0 | 374 | 32 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_cancel_pay_to_supplier | 42 | 42 | 0 | 0.00 | 0 | 250 | 44 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_cancel_supplier_invoice | 130 | 70 | 60 | 46.15 | 15 | 3417 | 560 | 60 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_cancel_supplier_order | 54 | 10 | 44 | 81.48 | 171 | 42293 | 17143 | 44 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_cancel_write_off | 1169 | 463 | 706 | 60.39 | 0 | 670 | 58 | 706 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_client_order | 2640 | 2640 | 0 | 0.00 | 0 | 16163 | 2767 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_customer_reserve | 1081 | 1081 | 0 | 0.00 | 15 | 38611 | 5234 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_fill_shopping_cart | 4096 | 4096 | 0 | 0.00 | 0 | 15990 | 609 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_fill_shopping_cart_clo_res | 1081 | 1081 | 0 | 0.00 | 0 | 109 | 4 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_get_clo_for_invoice | 53 | 53 | 0 | 0.00 | 0 | 141 | 21 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_kill_cost_storno | 1355 | 645 | 710 | 52.39 | 0 | 515 | 15 | 710 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_kill_qstorno_ret_qs2qd | 6890 | 1795 | 5095 | 73.94 | 0 | 32886 | 373 | 5095 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_kill_qty_storno | 5701 | 2752 | 2949 | 51.72 | 0 | 32886 | 290 | 2949 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_lock_selected_doc | 2605 | 1918 | 687 | 26.37 | 0 | 31 | 0 | 687 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_make_cost_storno | 2964 | 2964 | 0 | 0.00 | 0 | 6661 | 207 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_multiply_rows_for_pdistr | 2964 | 2964 | 0 | 0.00 | 0 | 999 | 50 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_multiply_rows_for_qdistr | 2640 | 2640 | 0 | 0.00 | 0 | 15821 | 2602 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_pay_from_customer | 894 | 894 | 0 | 0.00 | 31 | 2059 | 203 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_pay_to_supplier | 739 | 739 | 0 | 0.00 | 31 | 7020 | 755 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_payment_common | 1633 | 1633 | 0 | 0.00 | 0 | 343 | 31 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_qd_handle_on_cancel_clo | 223 | 205 | 18 | 8.07 | 0 | 468 | 29 | 18 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_qd_handle_on_invoice_upd_sts | 131 | 100 | 31 | 23.66 | 0 | 12808 | 909 | 31 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_qd_handle_on_reserve_upd_sts | 1278 | 1278 | 0 | 0.00 | 0 | 359 | 23 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_reserve_write_off | 1323 | 1278 | 45 | 3.40 | 0 | 2449 | 125 | 45 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_supplier_invoice | 748 | 748 | 0 | 0.00 | 15 | 22981 | 2309 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| sp_supplier_order | 708 | 708 | 0 | 0.00 | 15 | 80419 | 19337 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| srv_find_qd_qs_mism | 10823 | 7922 | 2901 | 26.80 | 0 | 1185 | 53 | 2901 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| srv_make_invnt_saldo | 191 | 191 | 0 | 0.00 | 15 | 5461 | 1168 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| srv_make_money_saldo | 158 | 158 | 0 | 0.00 | 0 | 47 | 7 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| srv_recalc_idx_stat | 1 | 1 | 0 | 0.00 | 7707 | 7707 | 7707 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-abend:sp_add_invoice_to_stock | 488 | 488 | 0 | 0.00 | 0 | 187 | 15 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-abend:sp_cancel_adding_invoice | 34 | 34 | 0 | 0.00 | 0 | 374 | 52 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-abend:sp_cancel_client_order | 18 | 18 | 0 | 0.00 | 0 | 47 | 14 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-abend:sp_cancel_customer_reserve | 6 | 6 | 0 | 0.00 | 0 | 31 | 13 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-abend:sp_cancel_supplier_invoice | 53 | 53 | 0 | 0.00 | 0 | 62 | 11 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-abend:sp_cancel_supplier_order | 355 | 355 | 0 | 0.00 | 0 | 312 | 59 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-abend:sp_cancel_write_off | 4 | 4 | 0 | 0.00 | 0 | 16 | 4 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-abend:sp_reserve_write_off | 45 | 45 | 0 | 0.00 | 0 | 93 | 15 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_add_invoice_to_stock | 53 | 53 | 0 | 0.00 | 0 | 1545 | 189 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_cancel_adding_invoice | 21 | 21 | 0 | 0.00 | 0 | 6646 | 473 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_cancel_client_order | 205 | 205 | 0 | 0.00 | 0 | 343 | 22 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_cancel_customer_reserve | 82 | 82 | 0 | 0.00 | 0 | 312 | 29 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_cancel_pay_from_customer | 93 | 93 | 0 | 0.00 | 0 | 234 | 18 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_cancel_pay_to_supplier | 42 | 42 | 0 | 0.00 | 0 | 203 | 27 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_cancel_supplier_invoice | 14 | 14 | 0 | 0.00 | 0 | 47 | 21 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_cancel_supplier_order | 10 | 10 | 0 | 0.00 | 0 | 1451 | 221 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_cancel_write_off | 120 | 120 | 0 | 0.00 | 0 | 375 | 21 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_client_order | 2640 | 2640 | 0 | 0.00 | 0 | 561 | 27 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_customer_reserve | 129 | 129 | 0 | 0.00 | 0 | 390 | 30 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_pay_from_customer | 894 | 894 | 0 | 0.00 | 0 | 281 | 18 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_pay_to_supplier | 739 | 739 | 0 | 0.00 | 0 | 344 | 19 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_reserve_write_off | 1278 | 1278 | 0 | 0.00 | 0 | 499 | 26 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_supplier_invoice | 748 | 748 | 0 | 0.00 | 0 | 546 | 25 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:sp_supplier_order | 708 | 708 | 0 | 0.00 | 0 | 374 | 22 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:srv_make_invnt_saldo | 191 | 191 | 0 | 0.00 | 0 | 78 | 6 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:srv_make_money_saldo | 158 | 158 | 0 | 0.00 | 0 | 47 | 6 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| t$perf-norm:srv_recalc_idx_stat | 1 | 1 | 0 | 0.00 | 249 | 249 | 249 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_add_invoice_to_stock | 1082 | 106 | 976 | 90.20 | 0 | 31 | 3 | 976 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_all_customers | 3888 | 3888 | 0 | 0.00 | 0 | 32 | 0 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_all_suppliers | 2912 | 2912 | 0 | 0.00 | 0 | 31 | 0 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_all_wares | 5280 | 5280 | 0 | 0.00 | 0 | 16 | 0 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_cancel_adding_invoice | 100 | 42 | 58 | 58.00 | 0 | 31 | 4 | 58 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_cancel_client_order | 446 | 410 | 36 | 8.07 | 0 | 31 | 1 | 36 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_cancel_customer_prepayment | 186 | 186 | 0 | 0.00 | 0 | 16 | 1 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_cancel_customer_reserve | 176 | 164 | 12 | 6.81 | 0 | 47 | 2 | 12 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_cancel_payment_to_supplier | 84 | 84 | 0 | 0.00 | 0 | 16 | 1 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_cancel_supplier_invoice | 134 | 28 | 106 | 79.10 | 0 | 47 | 6 | 106 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_cancel_supplier_order | 108 | 20 | 88 | 81.48 | 0 | 16 | 4 | 88 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_cancel_write_off | 248 | 240 | 8 | 3.22 | 0 | 16 | 2 | 8 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_max_id_clo_ord | 708 | 708 | 0 | 0.00 | 0 | 733 | 138 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_max_id_clo_res | 129 | 129 | 0 | 0.00 | 0 | 78 | 4 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_max_id_ord_sup | 748 | 748 | 0 | 0.00 | 0 | 249 | 13 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_max_non_paid_invoice | 739 | 739 | 0 | 0.00 | 0 | 78 | 6 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_max_non_paid_realizn | 894 | 894 | 0 | 0.00 | 0 | 78 | 5 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_min_id_clo_ord | 708 | 708 | 0 | 0.00 | 0 | 593 | 120 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_min_id_clo_res | 129 | 129 | 0 | 0.00 | 0 | 47 | 4 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_min_id_ord_sup | 748 | 748 | 0 | 0.00 | 0 | 765 | 35 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_min_non_paid_invoice | 739 | 739 | 0 | 0.00 | 0 | 296 | 31 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_min_non_paid_realizn | 894 | 894 | 0 | 0.00 | 0 | 125 | 12 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_our_firm | 1392 | 1392 | 0 | 0.00 | 0 | 16 | 0 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| v_reserve_write_off | 2646 | 2556 | 90 | 3.40 | 0 | 62 | 1 | 90 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| x_lock_depdocs_on_canc_invoice | 314 | 103 | 211 | 67.19 | 0 | 78 | 3 | 211 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| x_lock_depdocs_on_canc_sup_ord | 54 | 10 | 44 | 81.48 | 0 | 47 | 4 | 44 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| x_make_qstorno_1000_1200 | 708 | 708 | 0 | 0.00 | 15 | 69223 | 16551 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| x_make_qstorno_1200_2000 | 748 | 748 | 0 | 0.00 | 15 | 19908 | 1610 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| x_make_qstorno_2100_3300 | 1081 | 1081 | 0 | 0.00 | 15 | 38611 | 5222 | 0 | 2016-10-25 22:18 | 2016-10-25 22:28 |
Config param. mon_unit_perf=0, data from MON$ tables were NOT gathered.
Exceptions occured during test work:
| FB_MNEMONA | CNT | UNIT | FB_GDSCODE | DTS_BEG | DTS_END |
|---|---|---|---|---|---|
| deadlock | 6 | sp_kill_cost_storno | 335544336 | 2016-10-25 22:20 | 2016-10-25 22:26 |
| deadlock | 2 | sp_qd_handle_on_invoice_upd_sts | 335544336 | 2016-10-25 22:19 | 2016-10-25 22:20 |
| lock_conflict | 596 | sp_lock_selected_doc | 335544345 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| lock_conflict | 18 | sp_qd_handle_on_cancel_clo | 335544345 | 2016-10-25 22:18 | 2016-10-25 22:27 |
| lock_conflict | 23 | sp_qd_handle_on_invoice_upd_sts | 335544345 | 2016-10-25 22:20 | 2016-10-25 22:28 |
| lock_conflict | 38 | x_lock_depdocs_on_canc_invoice | 335544345 | 2016-10-25 22:18 | 2016-10-25 22:28 |
| lock_conflict | 4 | x_lock_depdocs_on_canc_sup_ord | 335544345 | 2016-10-25 22:20 | 2016-10-25 22:24 |
MON$DATABASE and FB VERSION info
MON$DATABASE_NAME D:\OLTP-EMUL\OLTP25-SMALL.FDBMON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 76533
MON$OLDEST_ACTIVE 76534
MON$OLDEST_SNAPSHOT 76534
MON$NEXT_TRANSACTION 76534
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 120792
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.7.27026 Firebird 2.5 HQbird
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.7.27026 Firebird 2.5 HQbird"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.7.27026 Firebird 2.5 HQbird/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.7.27026 Firebird 2.5 HQbird/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 80976
Page size 8192
ODS version 11.2
Oldest transaction 76535
Oldest active 76536
Oldest snapshot 76536
Next transaction 76537
Bumped transaction 1
Sequence number 0
Next attachment ID 4411
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
Database GUID: {1B856C5D-0E20-4F6F-B5A2-A328411E6B80}
*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: 45.32, total records: 372878
Average version length: 46.10, total versions: 5655, max versions: 1
Data pages: 4037, data page slots: 4037, average fill: 72%
Fill distribution:
0 - 19% = 3
20 - 39% = 15
40 - 59% = 244
60 - 79% = 3764
80 - 99% = 11
Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 1076, nodes: 372878
Average data length: 11.49, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 117
20 - 39% = 17
40 - 59% = 254
60 - 79% = 42
80 - 99% = 646
Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 1116, nodes: 372878
Average data length: 6.07, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 71
40 - 59% = 1044
60 - 79% = 1
80 - 99% = 0
Index FK_DOC_DATA_DOC_LIST (3)
Depth: 2, leaf buckets: 303, nodes: 372878
Average data length: 0.77, total dup: 328098, max dup: 49
Fill distribution:
0 - 19% = 2
20 - 39% = 25
40 - 59% = 44
60 - 79% = 3
80 - 99% = 229
DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 59.13, total records: 56811
Average version length: 54.33, total versions: 3333, max versions: 5
Data pages: 707, data page slots: 707, average fill: 79%
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 41
60 - 79% = 249
80 - 99% = 414
Index DOC_LIST_ID_DESC (1)
Depth: 2, leaf buckets: 164, nodes: 56811
Average data length: 6.31, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 14
40 - 59% = 150
60 - 79% = 0
80 - 99% = 0
Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 43, nodes: 56811
Average data length: 0.01, total dup: 56761, max dup: 15211
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 21
60 - 79% = 13
80 - 99% = 9
Index PK_DOC_LIST (0)
Depth: 2, leaf buckets: 95, nodes: 56811
Average data length: 6.31, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 11
60 - 79% = 0
80 - 99% = 70
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.73, total records: 400
Average version length: 13.31, total versions: 32814, max versions: 100
Data pages: 133, data page slots: 133, average fill: 96%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 132
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: 1.04, total records: 60995
Average version length: 68.23, total versions: 60066, max versions: 1
Data pages: 999, data page slots: 1011, average fill: 77%
Fill distribution:
0 - 19% = 18
20 - 39% = 12
40 - 59% = 74
60 - 79% = 371
80 - 99% = 524
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 2, leaf buckets: 175, nodes: 60995
Average data length: 8.61, total dup: 6071, max dup: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 92
60 - 79% = 73
80 - 99% = 5
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: 1845, max versions: 133
Data pages: 7, data page slots: 7, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 6
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.70, total records: 3584
Average version length: 44.11, total versions: 3526, max versions: 1
Data pages: 39, data page slots: 39, average fill: 88%
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 37
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 2, leaf buckets: 3, nodes: 3584
Average data length: 0.25, total dup: 3494, max dup: 757
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 1
80 - 99% = 0
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: 29.12, total records: 101140
Average version length: 31.63, total versions: 50552, max versions: 11
Data pages: 1053, data page slots: 1053, average fill: 83%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 465
80 - 99% = 586
Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 77, nodes: 101140
Average data length: 0.01, total dup: 101091, max dup: 19747
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 36
60 - 79% = 23
80 - 99% = 17
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 100, nodes: 101140
Average data length: 0.89, total dup: 91071, max dup: 29
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 57
60 - 79% = 24
80 - 99% = 17
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 101, nodes: 101140
Average data length: 0.89, total dup: 91071, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 57
60 - 79% = 25
80 - 99% = 19
Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 93, nodes: 101140
Average data length: 0.67, total dup: 91071, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 43
60 - 79% = 32
80 - 99% = 15
PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 27.42, total records: 9020
Average version length: 18.00, total versions: 2, max versions: 1
Data pages: 77, data page slots: 77, average fill: 64%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 76
80 - 99% = 0
Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 7, nodes: 9020
Average data length: 0.00, total dup: 9009, max dup: 1610
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 4
60 - 79% = 3
80 - 99% = 0
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: 141.71, total records: 823646
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 18533, data page slots: 18533, average fill: 86%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 18532
Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 1102, nodes: 823646
Average data length: 0.60, total dup: 416600, max dup: 35
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1013
60 - 79% = 67
80 - 99% = 22
Index PERF_LOG_GDSCODE (3)
Depth: 2, leaf buckets: 808, nodes: 823646
Average data length: 0.00, total dup: 823641, max dup: 800081
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 805
60 - 79% = 1
80 - 99% = 2
Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 1101, nodes: 823646
Average data length: 0.47, total dup: 763462, max dup: 4021
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1052
60 - 79% = 36
80 - 99% = 13
Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 901, nodes: 823646
Average data length: 0.17, total dup: 812328, max dup: 92931
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 678
60 - 79% = 102
80 - 99% = 120
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: 52.96, total records: 73330
Average version length: 54.66, total versions: 2185, max versions: 1
Data pages: 852, data page slots: 852, average fill: 76%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 5
60 - 79% = 834
80 - 99% = 12
Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 91, nodes: 73330
Average data length: 1.10, total dup: 61177, max dup: 144
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 87
60 - 79% = 0
80 - 99% = 4
Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 68, nodes: 73330
Average data length: 0.59, total dup: 67124, max dup: 92
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 36
60 - 79% = 26
80 - 99% = 6
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: 348, max versions: 190
Data pages: 2, data page slots: 2, average fill: 57%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
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: 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
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.40, total records: 116784
Average version length: 69.19, total versions: 116113, max versions: 1
Data pages: 1562, data page slots: 1562, average fill: 94%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 14
80 - 99% = 1548
Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 124, nodes: 116784
Average data length: 1.31, total dup: 102344, max dup: 29
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 37
60 - 79% = 56
80 - 99% = 29
XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 56.56, total records: 115689
Average version length: 69.18, total versions: 21095, max versions: 1
Data pages: 1591, data page slots: 1756, average fill: 80%
Fill distribution:
0 - 19% = 20
20 - 39% = 18
40 - 59% = 16
60 - 79% = 802
80 - 99% = 735
Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 111, nodes: 115689
Average data length: 0.15, total dup: 113146, max dup: 193
Fill distribution:
0 - 19% = 2
20 - 39% = 4
40 - 59% = 79
60 - 79% = 10
80 - 99% = 16
Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 143, nodes: 115689
Average data length: 1.33, total dup: 101342, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 81
60 - 79% = 44
80 - 99% = 12
XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 0.97, total records: 131534
Average version length: 69.18, total versions: 129697, max versions: 1
Data pages: 1756, data page slots: 1756, average fill: 94%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 20
80 - 99% = 1735
Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 2, leaf buckets: 129, nodes: 131534
Average data length: 0.94, total dup: 120327, max dup: 99
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 45
60 - 79% = 51
80 - 99% = 33
XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 12.80, total records: 823134
Average version length: 68.12, total versions: 670410, max versions: 1
Data pages: 11080, data page slots: 11080, average fill: 90%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1969
80 - 99% = 9110
Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1037, nodes: 823134
Average data length: 1.17, total dup: 724527, max dup: 49
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 771
60 - 79% = 109
80 - 99% = 156
XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 43.90, total records: 166788
Average version length: 68.41, total versions: 59725, max versions: 1
Data pages: 2491, data page slots: 2638, average fill: 76%
Fill distribution:
0 - 19% = 39
20 - 39% = 106
40 - 59% = 193
60 - 79% = 384
80 - 99% = 1769
Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 230, nodes: 166788
Average data length: 1.43, total dup: 142798, max dup: 78
Fill distribution:
0 - 19% = 0
20 - 39% = 15
40 - 59% = 133
60 - 79% = 80
80 - 99% = 2
XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 35.79, total records: 551351
Average version length: 68.14, total versions: 262643, max versions: 1
Data pages: 8456, data page slots: 8558, average fill: 75%
Fill distribution:
0 - 19% = 434
20 - 39% = 490
40 - 59% = 504
60 - 79% = 3064
80 - 99% = 3964
Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 794, nodes: 551351
Average data length: 1.27, total dup: 480551, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 54
40 - 59% = 560
60 - 79% = 151
80 - 99% = 29
XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 79.22, total records: 811291
Average version length: 80.22, total versions: 9755, max versions: 1
Data pages: 12083, data page slots: 12083, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 6874
80 - 99% = 5209
Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 902, nodes: 811291
Average data length: 0.16, total dup: 792866, max dup: 124
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 680
60 - 79% = 172
80 - 99% = 44
Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 655, nodes: 811291
Average data length: 0.75, total dup: 712818, max dup: 49
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 131
60 - 79% = 11
80 - 99% = 510
Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 1031, nodes: 811291
Average data length: 0.77, total dup: 710237, max dup: 29
Fill distribution:
0 - 19% = 9
20 - 39% = 0
40 - 59% = 781
60 - 79% = 192
80 - 99% = 49
XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 74.71, total records: 547317
Average version length: 80.14, total versions: 36549, max versions: 1
Data pages: 8416, data page slots: 8502, average fill: 78%
Fill distribution:
0 - 19% = 132
20 - 39% = 133
40 - 59% = 128
60 - 79% = 5771
80 - 99% = 2252
Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 594, nodes: 547317
Average data length: 0.16, total dup: 535142, max dup: 201
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 422
60 - 79% = 137
80 - 99% = 29
Index XQS_1000_3300_RCV_ID (2)
Depth: 2, leaf buckets: 419, nodes: 547317
Average data length: 0.80, total dup: 476873, max dup: 14
Fill distribution:
0 - 19% = 2
20 - 39% = 18
40 - 59% = 15
60 - 79% = 3
80 - 99% = 381
Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 717, nodes: 547317
Average data length: 0.76, total dup: 480175, max dup: 29
Fill distribution:
0 - 19% = 33
20 - 39% = 2
40 - 59% = 516
60 - 79% = 140
80 - 99% = 26
XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 78.73, total records: 823300
Average version length: 80.70, total versions: 15043, max versions: 1
Data pages: 12263, data page slots: 12263, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 7286
80 - 99% = 4976
Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 867, nodes: 823300
Average data length: 0.05, total dup: 818153, max dup: 594
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 612
60 - 79% = 193
80 - 99% = 62
Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 628, nodes: 823300
Average data length: 0.73, total dup: 724648, max dup: 49
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 69
60 - 79% = 4
80 - 99% = 555
Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 991, nodes: 823300
Average data length: 0.74, total dup: 724994, max dup: 99
Fill distribution:
0 - 19% = 5
20 - 39% = 1
40 - 59% = 656
60 - 79% = 239
80 - 99% = 90
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: 75.77, total records: 579772
Average version length: 80.14, total versions: 31302, max versions: 1
Data pages: 9681, data page slots: 9846, average fill: 72%
Fill distribution:
0 - 19% = 565
20 - 39% = 536
40 - 59% = 384
60 - 79% = 6255
80 - 99% = 1941
Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 559, nodes: 579772
Average data length: 0.06, total dup: 575739, max dup: 629
Fill distribution:
0 - 19% = 1
20 - 39% = 34
40 - 59% = 229
60 - 79% = 196
80 - 99% = 99
Index XQS_2100_3300_RCV_ID (2)
Depth: 2, leaf buckets: 478, nodes: 579772
Average data length: 0.80, total dup: 505151, max dup: 14
Fill distribution:
0 - 19% = 3
20 - 39% = 53
40 - 59% = 32
60 - 79% = 7
80 - 99% = 383
Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 647, nodes: 579772
Average data length: 0.77, total dup: 507336, max dup: 71
Fill distribution:
0 - 19% = 0
20 - 39% = 51
40 - 59% = 215
60 - 79% = 268
80 - 99% = 113
XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 62.79, total records: 282226
Average version length: 68.24, total versions: 22464, max versions: 1
Data pages: 3796, data page slots: 3796, average fill: 79%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 3250
80 - 99% = 546
Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 248, nodes: 282226
Average data length: 0.22, total dup: 273463, max dup: 145
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 78
60 - 79% = 103
80 - 99% = 67
Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 297, nodes: 282226
Average data length: 0.82, total dup: 245479, max dup: 29
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 115
60 - 79% = 128
80 - 99% = 53
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 18770 ms, from 22:29:56.12 to 22:30:14.89.
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 | 372878 | 5655 | 1.5165 |
| DOC_LIST | 56811 | 3333 | 5.8668 |
| DOC_STATES | 4 | 0 | 0.0000 |
| FB_ERRORS | 758 | 0 | 0.0000 |
| INVNT_SALDO | 400 | 32814 | 8203.5000 |
| INVNT_TURNOVER_LOG | 60995 | 60066 | 98.4769 |
| MONEY_SALDO | 49 | 1845 | 3765.3061 |
| MONEY_TURNOVER_LOG | 3584 | 3526 | 98.3816 |
| OPTYPES | 9 | 0 | 0.0000 |
| PDISTR | 101140 | 50552 | 49.9822 |
| PERF_ESTIMATED | 9020 | 2 | 0.0221 |
| PERF_LOG | 823646 | 1 | 0.0001 |
| PSTORNED | 73330 | 2185 | 2.9796 |
| RULES_FOR_PDISTR | 4 | 0 | 0.0000 |
| RULES_FOR_QDISTR | 7 | 0 | 0.0000 |
| SEMAPHORES | 4 | 348 | 8700.0000 |
| SETTINGS | 114 | 0 | 0.0000 |
| WARES | 400 | 0 | 0.0000 |
| WARE_GROUPS | 8 | 0 | 0.0000 |
| XQD_1000_1200 | 116784 | 116113 | 99.4254 |
| XQD_1000_3300 | 115689 | 21095 | 18.2342 |
| XQD_1200_2000 | 131534 | 129697 | 98.6034 |
| XQD_2000_3300 | 823134 | 670410 | 81.4460 |
| XQD_2100_3300 | 166788 | 59725 | 35.8089 |
| XQD_3300_3400 | 551351 | 262643 | 47.6362 |
| XQS_1000_1200 | 811291 | 9755 | 1.2024 |
| XQS_1000_3300 | 547317 | 36549 | 6.6778 |
| XQS_1200_2000 | 823300 | 15043 | 1.8271 |
| XQS_2100_3300 | 579772 | 31302 | 5.3990 |
| XQS_3300_3400 | 282226 | 22464 | 7.9595 |
| Z_USED_VIEWS | 32 | 0 | 0.0000 |
Database validation
22:30:27.46 Validation started
22:30:27.46 Relation 140 (DOC_LIST)
22:30:27.46 process pointer page 0 of 1
22:30:27.51 Index 1 (PK_DOC_LIST)
22:30:27.51 Index 2 (DOC_LIST_ID_DESC)
22:30:27.54 Index 3 (FK_DOC_LIST_AGENTS)
22:30:27.55 Relation 140 (DOC_LIST) is ok
22:30:27.55 Relation 141 (DOC_DATA)
22:30:27.55 process pointer page 0 of 3
22:30:27.65 process pointer page 1 of 3
22:30:27.74 process pointer page 2 of 3
22:30:27.76 Index 2 (DOC_DATA_DOC_WARE_UNQ)
22:30:27.90 Index 3 (DOC_DATA_ID_DESC)
22:30:28.02 Index 4 (FK_DOC_DATA_DOC_LIST)
22:30:28.12 Relation 141 (DOC_DATA) is ok
22:30:28.12 Relation 147 (INVNT_SALDO)
22:30:28.12 process pointer page 0 of 1
22:30:28.15 Index 1 (PK_INVNT_SALDO)
22:30:28.15 Relation 147 (INVNT_SALDO) is ok
22:30:28.15 Relation 150 (PDISTR)
22:30:28.15 process pointer page 0 of 1
22:30:28.26 Index 2 (PDISTR_SND_ID)
22:30:28.27 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
22:30:28.30 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
22:30:28.33 Index 5 (PDISTR_AGENT_ID)
22:30:28.36 Relation 150 (PDISTR) is ok
22:30:28.36 Relation 151 (PSTORNED)
22:30:28.36 process pointer page 0 of 1
22:30:28.41 Index 2 (PSTORNED_SND_ID)
22:30:28.43 Index 3 (PSTORNED_RCV_ID)
22:30:28.44 Relation 151 (PSTORNED) is ok
22:30:28.44 Relation 156 (SEMAPHORES)
22:30:28.44 process pointer page 0 of 1
22:30:28.44 Index 1 (PK_SEMAPHORES)
22:30:28.44 Index 2 (SEMAPHORES_TASK_UNQ)
22:30:28.44 Relation 156 (SEMAPHORES) is ok
22:30:28.44 Relation 157 (INVNT_TURNOVER_LOG)
22:30:28.44 process pointer page 0 of 1
22:30:28.52 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
22:30:28.55 Relation 157 (INVNT_TURNOVER_LOG) is ok
22:30:28.55 Relation 160 (PERF_ESTIMATED)
22:30:28.55 process pointer page 0 of 1
22:30:28.57 Index 1 (PERF_EST_MINUTE_SINCE_START)
22:30:28.57 Relation 160 (PERF_ESTIMATED) is ok
22:30:28.57 Relation 161 (PERF_ISQL_STAT)
22:30:28.57 process pointer page 0 of 1
22:30:28.57 Index 1 (PERF_ISQL_STAT_TRN)
22:30:28.57 Relation 161 (PERF_ISQL_STAT) is ok
22:30:28.57 Relation 162 (PERF_LOG)
22:30:28.57 process pointer page 0 of 10
22:30:28.65 process pointer page 1 of 10
22:30:28.71 process pointer page 2 of 10
22:30:28.79 process pointer page 3 of 10
22:30:28.86 process pointer page 4 of 10
22:30:28.94 process pointer page 5 of 10
22:30:29.02 process pointer page 6 of 10
22:30:29.10 process pointer page 7 of 10
22:30:29.18 process pointer page 8 of 10
22:30:29.25 process pointer page 9 of 10
22:30:29.30 Index 1 (PERF_LOG_DTS_BEG_DESC)
22:30:29.53 Index 2 (PERF_LOG_UNIT)
22:30:29.96 Index 3 (PERF_LOG_TRN_DESC)
22:30:30.19 Index 4 (PERF_LOG_GDSCODE)
22:30:30.38 Relation 162 (PERF_LOG) is ok
22:30:30.38 Relation 166 (V_STOPTEST)
22:30:30.38 Relation 166 (V_STOPTEST) is ok
22:30:30.38 Relation 183 (V_QDISTR_SOURCE)
22:30:30.38 Relation 183 (V_QDISTR_SOURCE) is ok
22:30:30.38 Relation 184 (V_QSTORNED_SOURCE)
22:30:30.38 Relation 184 (V_QSTORNED_SOURCE) is ok
22:30:30.38 Relation 258 (XQD_1000_1200)
22:30:30.38 process pointer page 0 of 1
22:30:30.53 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
22:30:30.56 Relation 258 (XQD_1000_1200) is ok
22:30:30.56 Relation 259 (XQD_1200_2000)
22:30:30.56 process pointer page 0 of 1
22:30:30.72 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
22:30:30.77 Relation 259 (XQD_1200_2000) is ok
22:30:30.77 Relation 260 (XQD_1000_3300)
22:30:30.77 process pointer page 0 of 1
22:30:30.85 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
22:30:30.88 Index 2 (XQD_1000_3300_DOC)
22:30:30.91 Relation 260 (XQD_1000_3300) is ok
22:30:30.91 Relation 261 (XQD_2000_3300)
22:30:30.91 process pointer page 0 of 6
22:30:31.08 process pointer page 1 of 6
22:30:31.25 process pointer page 2 of 6
22:30:31.42 process pointer page 3 of 6
22:30:31.61 process pointer page 4 of 6
22:30:31.75 process pointer page 5 of 6
22:30:31.83 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
22:30:32.09 Relation 261 (XQD_2000_3300) is ok
22:30:32.09 Relation 262 (XQD_2100_3300)
22:30:32.09 process pointer page 0 of 2
22:30:32.22 process pointer page 1 of 2
22:30:32.25 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
22:30:32.31 Relation 262 (XQD_2100_3300) is ok
22:30:32.31 Relation 263 (XQD_3300_3400)
22:30:32.31 process pointer page 0 of 5
22:30:32.47 process pointer page 1 of 5
22:30:32.61 process pointer page 2 of 5
22:30:32.72 process pointer page 3 of 5
22:30:32.83 process pointer page 4 of 5
22:30:32.86 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
22:30:33.04 Relation 263 (XQD_3300_3400) is ok
22:30:33.04 Relation 264 (XQS_1000_1200)
22:30:33.04 process pointer page 0 of 7
22:30:33.14 process pointer page 1 of 7
22:30:33.23 process pointer page 2 of 7
22:30:33.31 process pointer page 3 of 7
22:30:33.40 process pointer page 4 of 7
22:30:33.50 process pointer page 5 of 7
22:30:33.56 process pointer page 6 of 7
22:30:33.56 Index 1 (XQS_1000_1200_DOC_ID)
22:30:33.67 Index 2 (XQS_1000_1200_SND_ID)
22:30:33.92 Index 3 (XQS_1000_1200_RCV_ID)
22:30:34.11 Relation 264 (XQS_1000_1200) is ok
22:30:34.11 Relation 265 (XQS_1200_2000)
22:30:34.11 process pointer page 0 of 7
22:30:34.20 process pointer page 1 of 7
22:30:34.28 process pointer page 2 of 7
22:30:34.37 process pointer page 3 of 7
22:30:34.46 process pointer page 4 of 7
22:30:34.56 process pointer page 5 of 7
22:30:34.65 process pointer page 6 of 7
22:30:34.68 Index 1 (XQS_1200_2000_DOC_ID)
22:30:34.90 Index 2 (XQS_1200_2000_SND_ID)
22:30:35.14 Index 3 (XQS_1200_2000_RCV_ID)
22:30:35.34 Relation 265 (XQS_1200_2000) is ok
22:30:35.34 Relation 266 (XQS_1000_3300)
22:30:35.34 process pointer page 0 of 5
22:30:35.43 process pointer page 1 of 5
22:30:35.53 process pointer page 2 of 5
22:30:35.62 process pointer page 3 of 5
22:30:35.71 process pointer page 4 of 5
22:30:35.76 Index 1 (XQS_1000_3300_DOC_ID)
22:30:35.90 Index 2 (XQS_1000_3300_SND_ID)
22:30:36.06 Index 3 (XQS_1000_3300_RCV_ID)
22:30:36.18 Relation 266 (XQS_1000_3300) is ok
22:30:36.18 Relation 267 (XQS_2000_3300)
22:30:36.18 process pointer page 0 of 1
22:30:36.18 Index 1 (XQS_2000_3300_DOC_ID)
22:30:36.18 Index 2 (XQS_2000_3300_SND_ID)
22:30:36.18 Index 3 (XQS_2000_3300_RCV_ID)
22:30:36.18 Relation 267 (XQS_2000_3300) is ok
22:30:36.18 Relation 268 (XQS_2100_3300)
22:30:36.18 process pointer page 0 of 6
22:30:36.27 process pointer page 1 of 6
22:30:36.38 process pointer page 2 of 6
22:30:36.46 process pointer page 3 of 6
22:30:36.55 process pointer page 4 of 6
22:30:36.63 process pointer page 5 of 6
22:30:36.63 Index 1 (XQS_2100_3300_DOC_ID)
22:30:36.82 Index 2 (XQS_2100_3300_SND_ID)
22:30:37.02 Index 3 (XQS_2100_3300_RCV_ID)
22:30:37.16 Relation 268 (XQS_2100_3300) is ok
22:30:37.16 Relation 269 (XQS_3300_3400)
22:30:37.16 process pointer page 0 of 2
22:30:37.27 process pointer page 1 of 2
22:30:37.37 Index 1 (XQS_3300_3400_DOC_ID)
22:30:37.44 Index 2 (XQS_3300_3400_SND_ID)
22:30:37.51 Relation 269 (XQS_3300_3400) is ok
22:30:37.51 Relation 276 (TRACE_STAT)
22:30:37.51 process pointer page 0 of 1
22:30:37.51 Relation 276 (TRACE_STAT) is ok
22:30:37.51 Validation finished
Done for 10200 ms, from 22:30:27.32 to 22:30:37.52.
22:30:27.46 Relation 140 (DOC_LIST)
22:30:27.46 process pointer page 0 of 1
22:30:27.51 Index 1 (PK_DOC_LIST)
22:30:27.51 Index 2 (DOC_LIST_ID_DESC)
22:30:27.54 Index 3 (FK_DOC_LIST_AGENTS)
22:30:27.55 Relation 140 (DOC_LIST) is ok
22:30:27.55 Relation 141 (DOC_DATA)
22:30:27.55 process pointer page 0 of 3
22:30:27.65 process pointer page 1 of 3
22:30:27.74 process pointer page 2 of 3
22:30:27.76 Index 2 (DOC_DATA_DOC_WARE_UNQ)
22:30:27.90 Index 3 (DOC_DATA_ID_DESC)
22:30:28.02 Index 4 (FK_DOC_DATA_DOC_LIST)
22:30:28.12 Relation 141 (DOC_DATA) is ok
22:30:28.12 Relation 147 (INVNT_SALDO)
22:30:28.12 process pointer page 0 of 1
22:30:28.15 Index 1 (PK_INVNT_SALDO)
22:30:28.15 Relation 147 (INVNT_SALDO) is ok
22:30:28.15 Relation 150 (PDISTR)
22:30:28.15 process pointer page 0 of 1
22:30:28.26 Index 2 (PDISTR_SND_ID)
22:30:28.27 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
22:30:28.30 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
22:30:28.33 Index 5 (PDISTR_AGENT_ID)
22:30:28.36 Relation 150 (PDISTR) is ok
22:30:28.36 Relation 151 (PSTORNED)
22:30:28.36 process pointer page 0 of 1
22:30:28.41 Index 2 (PSTORNED_SND_ID)
22:30:28.43 Index 3 (PSTORNED_RCV_ID)
22:30:28.44 Relation 151 (PSTORNED) is ok
22:30:28.44 Relation 156 (SEMAPHORES)
22:30:28.44 process pointer page 0 of 1
22:30:28.44 Index 1 (PK_SEMAPHORES)
22:30:28.44 Index 2 (SEMAPHORES_TASK_UNQ)
22:30:28.44 Relation 156 (SEMAPHORES) is ok
22:30:28.44 Relation 157 (INVNT_TURNOVER_LOG)
22:30:28.44 process pointer page 0 of 1
22:30:28.52 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
22:30:28.55 Relation 157 (INVNT_TURNOVER_LOG) is ok
22:30:28.55 Relation 160 (PERF_ESTIMATED)
22:30:28.55 process pointer page 0 of 1
22:30:28.57 Index 1 (PERF_EST_MINUTE_SINCE_START)
22:30:28.57 Relation 160 (PERF_ESTIMATED) is ok
22:30:28.57 Relation 161 (PERF_ISQL_STAT)
22:30:28.57 process pointer page 0 of 1
22:30:28.57 Index 1 (PERF_ISQL_STAT_TRN)
22:30:28.57 Relation 161 (PERF_ISQL_STAT) is ok
22:30:28.57 Relation 162 (PERF_LOG)
22:30:28.57 process pointer page 0 of 10
22:30:28.65 process pointer page 1 of 10
22:30:28.71 process pointer page 2 of 10
22:30:28.79 process pointer page 3 of 10
22:30:28.86 process pointer page 4 of 10
22:30:28.94 process pointer page 5 of 10
22:30:29.02 process pointer page 6 of 10
22:30:29.10 process pointer page 7 of 10
22:30:29.18 process pointer page 8 of 10
22:30:29.25 process pointer page 9 of 10
22:30:29.30 Index 1 (PERF_LOG_DTS_BEG_DESC)
22:30:29.53 Index 2 (PERF_LOG_UNIT)
22:30:29.96 Index 3 (PERF_LOG_TRN_DESC)
22:30:30.19 Index 4 (PERF_LOG_GDSCODE)
22:30:30.38 Relation 162 (PERF_LOG) is ok
22:30:30.38 Relation 166 (V_STOPTEST)
22:30:30.38 Relation 166 (V_STOPTEST) is ok
22:30:30.38 Relation 183 (V_QDISTR_SOURCE)
22:30:30.38 Relation 183 (V_QDISTR_SOURCE) is ok
22:30:30.38 Relation 184 (V_QSTORNED_SOURCE)
22:30:30.38 Relation 184 (V_QSTORNED_SOURCE) is ok
22:30:30.38 Relation 258 (XQD_1000_1200)
22:30:30.38 process pointer page 0 of 1
22:30:30.53 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
22:30:30.56 Relation 258 (XQD_1000_1200) is ok
22:30:30.56 Relation 259 (XQD_1200_2000)
22:30:30.56 process pointer page 0 of 1
22:30:30.72 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
22:30:30.77 Relation 259 (XQD_1200_2000) is ok
22:30:30.77 Relation 260 (XQD_1000_3300)
22:30:30.77 process pointer page 0 of 1
22:30:30.85 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
22:30:30.88 Index 2 (XQD_1000_3300_DOC)
22:30:30.91 Relation 260 (XQD_1000_3300) is ok
22:30:30.91 Relation 261 (XQD_2000_3300)
22:30:30.91 process pointer page 0 of 6
22:30:31.08 process pointer page 1 of 6
22:30:31.25 process pointer page 2 of 6
22:30:31.42 process pointer page 3 of 6
22:30:31.61 process pointer page 4 of 6
22:30:31.75 process pointer page 5 of 6
22:30:31.83 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
22:30:32.09 Relation 261 (XQD_2000_3300) is ok
22:30:32.09 Relation 262 (XQD_2100_3300)
22:30:32.09 process pointer page 0 of 2
22:30:32.22 process pointer page 1 of 2
22:30:32.25 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
22:30:32.31 Relation 262 (XQD_2100_3300) is ok
22:30:32.31 Relation 263 (XQD_3300_3400)
22:30:32.31 process pointer page 0 of 5
22:30:32.47 process pointer page 1 of 5
22:30:32.61 process pointer page 2 of 5
22:30:32.72 process pointer page 3 of 5
22:30:32.83 process pointer page 4 of 5
22:30:32.86 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
22:30:33.04 Relation 263 (XQD_3300_3400) is ok
22:30:33.04 Relation 264 (XQS_1000_1200)
22:30:33.04 process pointer page 0 of 7
22:30:33.14 process pointer page 1 of 7
22:30:33.23 process pointer page 2 of 7
22:30:33.31 process pointer page 3 of 7
22:30:33.40 process pointer page 4 of 7
22:30:33.50 process pointer page 5 of 7
22:30:33.56 process pointer page 6 of 7
22:30:33.56 Index 1 (XQS_1000_1200_DOC_ID)
22:30:33.67 Index 2 (XQS_1000_1200_SND_ID)
22:30:33.92 Index 3 (XQS_1000_1200_RCV_ID)
22:30:34.11 Relation 264 (XQS_1000_1200) is ok
22:30:34.11 Relation 265 (XQS_1200_2000)
22:30:34.11 process pointer page 0 of 7
22:30:34.20 process pointer page 1 of 7
22:30:34.28 process pointer page 2 of 7
22:30:34.37 process pointer page 3 of 7
22:30:34.46 process pointer page 4 of 7
22:30:34.56 process pointer page 5 of 7
22:30:34.65 process pointer page 6 of 7
22:30:34.68 Index 1 (XQS_1200_2000_DOC_ID)
22:30:34.90 Index 2 (XQS_1200_2000_SND_ID)
22:30:35.14 Index 3 (XQS_1200_2000_RCV_ID)
22:30:35.34 Relation 265 (XQS_1200_2000) is ok
22:30:35.34 Relation 266 (XQS_1000_3300)
22:30:35.34 process pointer page 0 of 5
22:30:35.43 process pointer page 1 of 5
22:30:35.53 process pointer page 2 of 5
22:30:35.62 process pointer page 3 of 5
22:30:35.71 process pointer page 4 of 5
22:30:35.76 Index 1 (XQS_1000_3300_DOC_ID)
22:30:35.90 Index 2 (XQS_1000_3300_SND_ID)
22:30:36.06 Index 3 (XQS_1000_3300_RCV_ID)
22:30:36.18 Relation 266 (XQS_1000_3300) is ok
22:30:36.18 Relation 267 (XQS_2000_3300)
22:30:36.18 process pointer page 0 of 1
22:30:36.18 Index 1 (XQS_2000_3300_DOC_ID)
22:30:36.18 Index 2 (XQS_2000_3300_SND_ID)
22:30:36.18 Index 3 (XQS_2000_3300_RCV_ID)
22:30:36.18 Relation 267 (XQS_2000_3300) is ok
22:30:36.18 Relation 268 (XQS_2100_3300)
22:30:36.18 process pointer page 0 of 6
22:30:36.27 process pointer page 1 of 6
22:30:36.38 process pointer page 2 of 6
22:30:36.46 process pointer page 3 of 6
22:30:36.55 process pointer page 4 of 6
22:30:36.63 process pointer page 5 of 6
22:30:36.63 Index 1 (XQS_2100_3300_DOC_ID)
22:30:36.82 Index 2 (XQS_2100_3300_SND_ID)
22:30:37.02 Index 3 (XQS_2100_3300_RCV_ID)
22:30:37.16 Relation 268 (XQS_2100_3300) is ok
22:30:37.16 Relation 269 (XQS_3300_3400)
22:30:37.16 process pointer page 0 of 2
22:30:37.27 process pointer page 1 of 2
22:30:37.37 Index 1 (XQS_3300_3400_DOC_ID)
22:30:37.44 Index 2 (XQS_3300_3400_SND_ID)
22:30:37.51 Relation 269 (XQS_3300_3400) is ok
22:30:37.51 Relation 276 (TRACE_STAT)
22:30:37.51 process pointer page 0 of 1
22:30:37.51 Relation 276 (TRACE_STAT) is ok
22:30:37.51 Validation finished
Done for 10200 ms, from 22:30:27.32 to 22:30:37.52.
Differences between old and current firebird.log
22:30:38.05. Got:STDOUT: ---------- E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG: 2 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-10-25 22:30 87 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 +++Comparing files E:\TEMP\LOGS.OLTP25\oltp25_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP25\oltp25_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG
1: operating system directive fopen failed
2: -The system cannot find the file specified.
*****
+++ 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 |
2016-10-25 22:30:39.94 - end of report, text file: e:\temp\logs.oltp25\oltp25.report.txt, html: e:\temp\logs.oltp25\oltp25.report.html