Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 08.04.2021 01:28
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17464064 kB
MemAvailable 31421524 kB
Buffers 0 kB
Cached 14205084 kB
SwapCached 120 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-04-08 01:27:24
DTS_END                         2021-04-08 01:27:24.9660
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57120
TRN_ID                          241135
ATT_ID                          662
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9193.71 22259 1103245
customer order: creation 172.75 381 20730
customer order: refuse 14.54 337 1745
order to supplier: creation 45.79 1384 5495
order to supplier: removal 3.44 98982 413
invoice (draft): creation 46.93 3449 5632
invoice (draft): removal 52.25 844 6270
invoice accept: apply 41.70 16678 5004
invoice accept: cancel 47.23 794 5667
customer reserve: creation 3868.77 163 464252
customer reserve: removal 4605.63 58 552676
realization accept: apply 83.28 180 9994
realization accept: cancel 81.58 110 9789
payment from customer: creation 59.88 102 7185
payment from customer: removal 5.07 113 608
payment to supplier: creation 48.72 142 5846
payment to supplier: removal 3.55 92 426
service: total inventory turnovers 4.95 1020 594
service: total monetary turnovers 6.72 34 806
service: aggregate perf. data 0.91 19776 109
service: refresh index statistics 0.03 300549 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-04-2021 01:28:53 to 08-04-2021 01:28:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3309
TEST_TIME 2 3378
TEST_TIME 3 3565
TEST_TIME 4 4042
TEST_TIME 5 4901
TEST_TIME 6 5278
TEST_TIME 7 5191
TEST_TIME 8 5474
TEST_TIME 9 5630
TEST_TIME 10 5764
TEST_TIME 11 5916
TEST_TIME 12 5860
TEST_TIME 13 6203
TEST_TIME 14 6503
TEST_TIME 15 6752
TEST_TIME 16 6974
TEST_TIME 17 7199
TEST_TIME 18 7661
TEST_TIME 19 7731
TEST_TIME 20 7764
TEST_TIME 21 7678
TEST_TIME 22 8044
TEST_TIME 23 8298
TEST_TIME 24 8402
TEST_TIME 25 8642
TEST_TIME 26 9266
TEST_TIME 27 9759
TEST_TIME 28 10476
TEST_TIME 29 10584
TEST_TIME 30 10282
TEST_TIME 31 10241
TEST_TIME 32 10284
TEST_TIME 33 10198
TEST_TIME 34 10093
TEST_TIME 35 10010
TEST_TIME 36 9884
TEST_TIME 37 9922
TEST_TIME 38 9868
TEST_TIME 39 9776
TEST_TIME 40 9712
TEST_TIME 41 9615
TEST_TIME 42 9683
TEST_TIME 43 9577
TEST_TIME 44 9521
TEST_TIME 45 9403
TEST_TIME 46 9499
TEST_TIME 47 9397
TEST_TIME 48 9357
TEST_TIME 49 9434
TEST_TIME 50 9349
TEST_TIME 51 9271
TEST_TIME 52 9150
TEST_TIME 53 9123
TEST_TIME 54 9066
TEST_TIME 55 9138
TEST_TIME 56 9176
TEST_TIME 57 9164
TEST_TIME 58 9143
TEST_TIME 59 9126
TEST_TIME 60 9133
TEST_TIME 61 9222
TEST_TIME 62 9262
TEST_TIME 63 9263
TEST_TIME 64 9274
TEST_TIME 65 9303
TEST_TIME 66 9358
TEST_TIME 67 9301
TEST_TIME 68 9403
TEST_TIME 69 9442
TEST_TIME 70 9430
TEST_TIME 71 9314
TEST_TIME 72 9304
TEST_TIME 73 9260
TEST_TIME 74 9195
TEST_TIME 75 9205
TEST_TIME 76 9156
TEST_TIME 77 9113
TEST_TIME 78 9078
TEST_TIME 79 9056
TEST_TIME 80 9067
TEST_TIME 81 9050
TEST_TIME 82 9133
TEST_TIME 83 9086
TEST_TIME 84 9102
TEST_TIME 85 9168
TEST_TIME 86 9181
TEST_TIME 87 9217
TEST_TIME 88 9194
TEST_TIME 89 9183
TEST_TIME 90 9250
TEST_TIME 91 9313
TEST_TIME 92 9329
TEST_TIME 93 9393
TEST_TIME 94 9417
TEST_TIME 95 9336
TEST_TIME 96 9291
TEST_TIME 97 9282
TEST_TIME 98 9257
TEST_TIME 99 9266
TEST_TIME 100 9222
TEST_TIME 101 9194
TEST_TIME 102 9179
TEST_TIME 103 9142
TEST_TIME 104 9108
TEST_TIME 105 9080
TEST_TIME 106 9074
TEST_TIME 107 9076
TEST_TIME 108 9049
TEST_TIME 109 9051
TEST_TIME 110 9181
TEST_TIME 111 9145
TEST_TIME 112 9139
TEST_TIME 113 9207
TEST_TIME 114 9272
TEST_TIME 115 9279
TEST_TIME 116 9315
TEST_TIME 117 9324
TEST_TIME 118 9313
TEST_TIME 119 9273
TEST_TIME 120 9198

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-04-2021 01:28:57 to 08-04-2021 01:29:00.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1532227 1532227 0 0.00 0 23351 6 0 0
doc_list_biud 1532227 1532227 0 0.00 0 52872 27 0 0
sp_add_invoice_to_stock 5139 5004 135 2.62 47 193721 16679 0 135
sp_cancel_adding_invoice 5667 5667 0 0.00 5 68751 795 0 0
sp_cancel_client_order 1745 1745 0 0.00 4 14408 338 0 0
sp_cancel_customer_reserve 552676 552676 0 0.00 1 33916 58 0 0
sp_cancel_pay_from_customer 608 608 0 0.00 3 12493 113 0 0
sp_cancel_pay_to_supplier 426 426 0 0.00 3 6127 92 0 0
sp_cancel_supplier_invoice 6283 6270 13 0.20 1 52878 845 0 13
sp_cancel_supplier_order 413 413 0 0.00 6 985841 98982 0 0
sp_cancel_write_off 9789 9789 0 0.00 1 14524 111 0 0
sp_client_order 20730 20730 0 0.00 3 73824 381 0 0
sp_customer_reserve 464252 464252 0 0.00 0 63389 163 0 0
sp_fill_shopping_cart 31854 31854 0 0.00 1 23798 46 0 0
sp_fill_shopping_cart_clo_res 464248 464248 0 0.00 0 28711 13 0 0
sp_get_clo_for_invoice 5000 5000 0 0.00 0 25964 319 0 0
sp_kill_cost_storno 16490 16490 0 0.00 0 8466 56 0 0
sp_kill_qstorno_ret_qs2qd 1121824 1121824 0 0.00 0 52869 32 0 0
sp_kill_qty_storno 591554 591554 0 0.00 0 52871 69 0 0
sp_lock_selected_doc 20710 20710 0 0.00 0 12481 6 0 0
sp_make_cost_storno 28025 28025 0 0.00 0 19470 57 0 0
sp_multiply_rows_for_pdistr 28025 28025 0 0.00 0 10744 29 0 0
sp_multiply_rows_for_qdistr 20730 20730 0 0.00 0 73816 183 0 0
sp_pay_from_customer 7185 7185 0 0.00 4 12739 102 0 0
sp_pay_to_supplier 5846 5846 0 0.00 4 19477 142 0 0
sp_payment_common 13031 13031 0 0.00 1 17235 32 0 0
sp_qd_handle_on_cancel_clo 1745 1745 0 0.00 0 14399 301 0 0
sp_qd_handle_on_invoice_upd_sts 10667 10667 0 0.00 0 33003 311 0 0
sp_qd_handle_on_reserve_upd_sts 9994 9994 0 0.00 0 30701 62 0 0
sp_reserve_write_off 9994 9994 0 0.00 6 30712 180 0 0
sp_supplier_invoice 5632 5632 0 0.00 6 100142 3450 0 0
sp_supplier_order 5495 5495 0 0.00 5 39779 1384 0 0
srv_aggregate_perf_data 109 109 0 0.00 2440 293366 19777 0 0
srv_fill_mon_cache_memory 155 155 0 0.00 1678 160951 34422 0 0
srv_find_qd_qs_mism 1054860 1054860 0 0.00 0 23351 5 0 0
srv_make_invnt_saldo 594 594 0 0.00 34 51628 1021 0 0
srv_make_money_saldo 806 806 0 0.00 0 9517 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 187385 472389 300549 0 0
t$perf-abend:sp_add_invoice_to_stock 135 135 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5004 5004 0 0.00 0 16533 171 0 0
t$perf-norm:sp_cancel_adding_invoice 444 444 0 0.00 0 3391 85 0 0
t$perf-norm:sp_cancel_client_order 1745 1745 0 0.00 0 2418 11 0 0
t$perf-norm:sp_cancel_customer_reserve 708 708 0 0.00 0 5752 24 0 0
t$perf-norm:sp_cancel_pay_from_customer 608 608 0 0.00 0 447 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 426 426 0 0.00 0 2701 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 406 406 0 0.00 0 2170 20 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 30710 1302 0 0
t$perf-norm:sp_cancel_write_off 969 969 0 0.00 0 7028 12 0 0
t$perf-norm:sp_client_order 20730 20730 0 0.00 0 14503 18 0 0
t$perf-norm:sp_customer_reserve 1037 1037 0 0.00 0 5849 10 0 0
t$perf-norm:sp_pay_from_customer 7185 7185 0 0.00 0 5282 12 0 0
t$perf-norm:sp_pay_to_supplier 5846 5846 0 0.00 0 11256 14 0 0
t$perf-norm:sp_reserve_write_off 9994 9994 0 0.00 0 8105 14 0 0
t$perf-norm:sp_supplier_invoice 5633 5633 0 0.00 0 9423 26 0 0
t$perf-norm:sp_supplier_order 5495 5495 0 0.00 0 10805 19 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 298 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 412 10 0 0
t$perf-norm:srv_make_invnt_saldo 594 594 0 0.00 0 897 22 0 0
t$perf-norm:srv_make_money_saldo 806 806 0 0.00 0 1380 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10268 9998 270 2.62 0 8820 23 0 270
v_all_customers 37890 37890 0 0.00 0 22 1 0 0
v_all_suppliers 30536 30536 0 0.00 0 66 1 0 0
v_all_wares 41460 41460 0 0.00 0 38 1 0 0
v_cancel_adding_invoice 888 888 0 0.00 0 1996 9 0 0
v_cancel_client_order 3490 3490 0 0.00 0 5723 10 0 0
v_cancel_customer_prepayment 1216 1216 0 0.00 0 5195 7 0 0
v_cancel_customer_reserve 1416 1416 0 0.00 0 3415 8 0 0
v_cancel_payment_to_supplier 852 852 0 0.00 0 6080 15 0 0
v_cancel_supplier_invoice 838 812 26 3.10 0 4921 31 0 26
v_cancel_supplier_order 826 826 0 0.00 0 555 4 0 0
v_cancel_write_off 1938 1938 0 0.00 0 5068 17 0 0
v_max_id_clo_ord 5495 5495 0 0.00 0 443 1 0 0
v_max_id_clo_res 1037 1037 0 0.00 0 2482 9 0 0
v_max_id_ord_sup 5629 5629 0 0.00 0 6436 5 0 0
v_max_non_paid_invoice 1702 1702 0 0.00 0 2304 3 0 0
v_max_non_paid_realizn 3813 3813 0 0.00 0 3275 4 0 0
v_min_id_clo_ord 5495 5495 0 0.00 0 23340 23 0 0
v_min_id_clo_res 1037 1037 0 0.00 0 3126 9 0 0
v_min_id_ord_sup 5629 5629 0 0.00 0 7826 12 0 0
v_min_non_paid_invoice 5846 5846 0 0.00 0 9399 22 0 0
v_min_non_paid_realizn 7185 7185 0 0.00 0 9385 20 0 0
v_our_firm 10314 10314 0 0.00 0 19 1 0 0
v_reserve_write_off 19984 19984 0 0.00 0 5577 6 0 0
x_lock_depdocs_on_canc_invoice 11531 11531 0 0.00 0 17129 116 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 18934 377 0 0
x_make_qstorno_1000_1200 5495 5495 0 0.00 2 39760 1297 0 0
x_make_qstorno_1200_2000 5632 5632 0 0.00 2 93021 3281 0 0
x_make_qstorno_2100_3300 464252 464252 0 0.00 0 63382 147 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-04-2021 01:29:01 to 08-04-2021 01:29:05.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:28 3 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:35 9231 8192000000 10151814832 10449387520 732862288 8.211 60 51 105 0 752697312 1923296 17911728
22:57:52 27539 8192000000 10328496704 10638761984 1365941808 14.291 100 88 176 0 1399411152 4359808 29109536
22:58:30 28445 8192000000 10361535344 10682556416 1413728176 14.717 100 86 171 1 1448254336 5407040 29119120
22:59:06 22310 8192000000 10396773088 10720632832 1446758656 15.009 100 88 176 0 1481873872 6417136 28698080
22:59:40 23692 8192000000 10423763840 10748874752 1468499280 15.201 100 90 180 0 1504684672 7019216 29166176
23:00:13 12967 8192000000 10428222624 10759393280 1490019728 15.389 100 89 178 0 1526225952 7617472 28588752
23:00:41 24606 8192000000 10460742992 10795520000 1518341392 15.636 100 91 182 0 1555242992 7842144 29059456
23:01:15 20819 8192000000 10495014688 10836135936 1550297248 15.913 100 85 171 1 1584732192 8015120 26419824
23:01:45 16440 8192000000 10517356400 10859204608 1566717200 16.054 100 89 178 1 1603098192 8426368 27954624
23:02:11 20646 8192000000 10533634304 10888749056 1594285328 16.291 100 78 156 1 1627187344 9170432 23731584
23:02:40 16346 8192000000 10571049184 10930016256 1623943072 16.543 100 70 141 1 1654335968 9761696 20631200
23:03:06 13107 8192000000 10604647424 10969358336 1661304096 16.860 100 81 162 2 1695823888 11225968 23293824
23:03:28 13366 8192000000 10622119936 10985742336 1686240288 17.070 100 84 168 2 1722236224 12305792 23690144
23:03:50 12725 8192000000 10635535136 11001282560 1697445248 17.164 100 84 168 1 1734592640 13154192 23993200
23:04:13 11491 8192000000 10665359888 11033100288 1721095168 17.361 100 90 179 2 1760828144 13993008 25739968
23:04:31 9550 8192000000 10674158032 11044392960 1726561696 17.407 100 86 173 1 1765421120 14047648 24811776
23:04:51 5186 8192000000 10676388624 11048013824 1737697712 17.500 100 87 175 2 1777260992 14682800 24880480
23:05:03 6000 8192000000 10694744240 11066392576 1744172016 17.553 100 84 168 0 1783071008 15489232 23409760
23:05:18 7754 8192000000 10691085824 11066408960 1752915264 17.626 100 88 175 1 1792806576 15589168 24302144
23:05:35 6603 8192000000 10706444688 11083935744 1765593456 17.731 100 91 182 2 1806486464 14866400 26026608
23:05:49 5305 8192000000 10711836736 11088072704 1770398560 17.770 100 91 182 0 1811381088 15189216 25793312
23:06:02 3825 8192000000 10716193408 11091062784 1776115488 17.817 100 84 166 2 1813455184 13671536 23668160
23:06:12 4387 8192000000 10718628960 11099779072 1781510976 17.862 100 84 168 1 1818431344 13603712 23316656
23:06:23 2943 8192000000 10723154656 11106836480 1786102240 17.900 100 82 165 1 1823008896 14286608 22620048
23:06:33 8432 8192000000 10726791504 11111714816 1791427648 17.944 100 79 158 2 1826953600 13804144 21721808
23:06:48 5732 8192000000 10739677232 11123007488 1798077728 17.998 100 79 158 2 1833677280 14026736 21572816
23:07:02 2224 8192000000 10763082736 11143045120 1818122320 18.162 100 90 180 1 1856406800 13680272 24604208
23:07:11 2242 8192000000 10767041552 11151605760 1827123680 18.236 100 87 172 1 1863704528 12220272 24360576
23:07:20 2590 8192000000 10768516720 11157106688 1828418816 18.246 100 91 182 3 1868081712 13731504 25931392
23:07:29 1964 8192000000 10776354688 11162030080 1832191456 18.277 100 88 175 0 1869901232 13007840 24701936
23:07:37 2181 8192000000 10785711648 11168485376 1837821024 18.323 100 93 187 2 1878344784 13558992 26964768
23:07:45 2079 8192000000 10791293392 11178377216 1846034400 18.390 100 84 167 0 1882980560 12753936 24192224
23:07:54 2353 8192000000 10796146544 11182968832 1854771584 18.461 100 88 177 1 1891658512 11965728 24921200
23:08:03 2059 8192000000 10800054384 11189542912 1857187552 18.480 100 91 183 2 1895190016 12239056 25763408
23:08:11 2001 8192000000 10800589968 11186814976 1858202704 18.489 100 93 186 0 1898354880 13936368 26215808
23:08:19 1632 8192000000 10796790752 11187601408 1858103936 18.488 100 88 178 2 1895278096 12309424 24864736
23:08:27 1138 8192000000 10798579552 11185672192 1861338256 18.514 100 86 171 1 1899159616 12966864 24854496
23:08:35 18772 8192000000 10794169136 11183194112 1855300032 18.465 100 71 141 1 1887649520 12478912 19870576
23:09:02 10209 8192000000 10787676352 11183312896 1860568224 18.508 100 72 142 2 1889840096 9447936 19823936
23:09:19 1340 8192000000 10807970256 11194621952 1865944480 18.551 100 95 190 1 1904197744 12044128 26209136
23:09:26 5765 8192000000 10799895488 11201126400 1862916896 18.527 100 77 154 2 1898885824 14267920 21701008
23:09:38 17031 8192000000 10761975792 11186544640 1854342016 18.457 100 23 46 0 1868643264 7729040 6572208
23:10:01 7194 8192000000 10778664928 11190906880 1860127936 18.504 100 39 77 1 1876255888 5399280 10728672
23:10:15 6540 8192000000 10779284688 11197517824 1858959024 18.495 100 29 58 1 1874176688 7040704 8176960
23:10:29 5204 8192000000 10768969488 11192537088 1862509152 18.524 100 19 38 2 1875377392 6010288 6857952
23:10:41 6962 8192000000 10765104480 11198177280 1864097216 18.536 100 20 40 0 1877096336 6830784 6168336
23:10:54 9808 8192000000 10774971200 11204853760 1866544672 18.556 100 20 40 2 1878346528 5649888 6151968
23:11:12 4686 8192000000 10790380480 11207331840 1872300864 18.603 100 29 58 1 1887036256 7015808 7719584
23:11:23 8241 8192000000 10784268848 11210989568 1874302496 18.619 100 15 28 3 1887858720 9669792 3886432
23:11:38 14167 8192000000 10780140928 11214680064 1875838480 18.631 100 18 34 2 1886947200 6031888 5076832
23:12:02 9286 8192000000 10781805888 11213905920 1874553280 18.621 100 12 24 1 1883397360 5392592 3451488
23:12:18 7716 8192000000 10784629472 11215437824 1877843648 18.648 100 22 40 3 1889036256 5691152 5501456
23:12:35 6275 8192000000 10789797664 11219660800 1879793280 18.663 100 17 34 0 1890519424 6396800 4329344
23:12:49 10402 8192000000 10788221936 11228930048 1881993344 18.681 100 21 42 1 1894847920 6752240 6102336
23:13:05 42287 8192000000 10805278080 11232878592 1886493536 18.718 100 28 56 0 1900447936 5567184 8387216
23:14:17 4219 8192000000 10813747968 11240087552 1890660304 18.751 100 41 80 0 1910742912 8590416 11492192
23:14:29 10079 8192000000 10803419184 11238342656 1891918736 18.761 100 27 54 4 1906235360 6521328 7795296
23:14:46 4901 8192000000 10806176416 11240161280 1893948384 18.778 100 32 58 2 1908950576 5923952 9078240
23:14:57 4322 8192000000 10816731280 11243724800 1895380208 18.789 100 33 66 2 1910506848 6368176 8758464
23:15:08 4944 8192000000 10805457488 11244167168 1898860208 18.817 100 28 56 2 1913679392 7006320 7812864
23:15:20 3560 8192000000 10818449024 11250475008 1902163952 18.844 100 32 64 0 1919199760 7396208 9639600
23:15:32 8451 8192000000 10815507824 11245330432 1884578672 18.702 99 21 40 2 1899456336 9221456 5656208
23:15:52 8347 8192000000 10817867536 11251142656 1903790688 18.857 100 22 44 0 1915570400 5443648 6336064
23:16:09 8357 8192000000 10811154112 11241058304 1861774128 18.518 98 21 41 0 1873798576 5500672 6523776
23:16:27 9807 8192000000 10807743632 11240300544 1895015264 18.786 100 25 50 3 1907653232 6039248 6598720
23:16:43 6952 8192000000 10806117712 11239489536 1876480112 18.637 99 16 32 2 1886618016 5811968 4325936
23:16:56 12583 8192000000 10804258128 11244023808 1893972240 18.778 100 20 40 2 1905977664 6145600 5859824
23:17:16 16212 8192000000 10787590672 11216723968 1854896464 18.462 98 9 18 0 1863111216 5601824 2612928
23:17:38 35398 8192000000 10757942672 11178201088 1810025008 18.096 96 32 64 0 1828734384 9957168 8752208
23:18:37 25725 8192000000 10725342928 11155636224 1727202608 17.412 92 32 57 4 1739668272 4734368 7731296
23:19:10 8646 8192000000 10737373216 11155382272 1784094928 17.883 97 33 66 2 1799025392 6120304 8810160
23:19:27 4362 8192000000 10751601344 11172245504 1809917072 18.095 98 37 74 0 1827807776 6865904 11024800
23:19:38 7306 8192000000 10754469712 11166527488 1748045584 17.585 95 33 66 1 1762685696 5852304 8787808
23:19:55 4205 8192000000 10733717136 11148546048 1775283584 17.811 97 28 54 0 1787973760 4824416 7865760
23:20:08 7961 8192000000 10692846112 11109425152 1722929584 17.377 95 27 54 2 1740553632 9359824 8264224
23:20:22 8043 8192000000 10697104608 11119423488 1756548768 17.656 98 28 56 1 1771020720 5957760 8514192
23:20:37 9378 8192000000 10714809872 11125657600 1748812256 17.592 97 30 56 3 1761923360 4470400 8640704
23:20:54 11003 8192000000 10685059936 11088261120 1606289792 16.393 89 27 54 3 1619645808 4609312 8746704
23:21:12 9689 8192000000 10696508480 11115806720 1734151424 17.470 97 27 52 3 1747796496 5318240 8326832
23:21:31 8373 8192000000 10720380448 11135221760 1771289312 17.778 98 29 58 4 1785471696 4949984 9232400
23:21:46 8218 8192000000 10729890384 11150704640 1800671584 18.019 99 38 73 4 1817692432 5140592 11880256
23:22:04 10975 8192000000 10715043472 11140464640 1776689520 17.822 98 18 35 1 1786713984 4941776 5082688
23:22:21 34630 8192000000 10715746544 11144491008 1773771696 17.798 98 22 44 1 1786145824 5258608 7115520
23:23:24 14208 8192000000 10765037472 11153211392 1818880928 18.169 100 59 122 2 1841740864 5167504 17692432
23:23:44 10165 8192000000 10747879840 11169521664 1822993680 18.202 100 20 40 0 1833824624 5181056 5649888
23:24:00 8053 8192000000 10747125872 11175006208 1835042832 18.300 100 16 33 0 1844485776 4927088 4515856
23:24:18 10574 8192000000 10762465472 11182751744 1838595600 18.329 100 22 44 1 1851336800 6473152 6268048
23:24:35 7256 8192000000 10761198560 11184308224 1844940208 18.381 100 33 66 0 1860353216 5306512 10106496
23:24:49 7380 8192000000 10766261248 11187851264 1848351456 18.409 100 41 82 1 1867971008 6653584 12965968
23:25:06 5268 8192000000 10765769376 11189231616 1850344784 18.425 100 38 77 3 1867914992 6546640 11023568
23:25:18 7847 8192000000 10766556192 11189448704 1850851744 18.429 100 26 52 3 1864001760 5028976 8121040
23:25:32 9418 8192000000 10784555424 11200118784 1856542256 18.475 100 29 58 2 1870473888 5002288 8929344
23:25:48 13406 8192000000 10766934288 11198586880 1856571808 18.475 100 24 47 3 1870181184 5757104 7852272
23:26:10 11025 8192000000 10776737360 11201482752 1859692592 18.501 100 30 58 3 1874684800 5247360 9744848
23:26:28 11448 8192000000 10782546368 11205394432 1862595200 18.524 100 20 40 1 1874178192 6124160 5458832
23:26:50 4956 8192000000 10772133712 11205550080 1865049904 18.544 100 18 36 0 1875805872 5291840 5464128
23:27:07 12651 8192000000 10793285264 11228282880 1880954864 18.673 100 14 28 0 1889918464 5401888 3561712
23:27:31 24327 8192000000 10830641904 11249311744 1902792208 18.849 100 36 73 2 1918224192 5305008 10126976
23:28:05 67731 8192000000 10859789984 11274584064 1914762320 18.945 100 30 60 2 1928951968 6214720 7974928
23:29:21 89167 8192000000 10864080160 11294445568 1929271952 19.061 100 34 68 1 1948879824 9747296 9860576
23:31:08 6271 8192000000 10869806928 11297017856 1938676016 19.136 100 57 112 1 1967670448 13269472 15724960
23:31:22 22282 8192000000 10880596976 11311599616 1944217296 19.180 100 51 100 1 1972148064 13901888 14028880
23:31:53 24645 8192000000 10887738720 11317387264 1952216928 19.244 100 53 106 0 1980832928 13552208 15063792
23:32:26 14395 8192000000 10906425168 11326853120 1961465776 19.318 100 60 120 1 1992063648 13435264 17162608
23:32:48 11418 8192000000 10894914112 11326877696 1962730176 19.328 100 65 128 0 1996577280 14878288 18968816
23:33:13 10829 8192000000 10900191680 11327602688 1962959344 19.330 100 46 90 2 1994127280 18005920 13162016
23:33:30 7211 8192000000 10902556144 11334987776 1968517936 19.374 100 61 119 2 1999355184 12682624 18154624
23:33:51 17857 8192000000 10911477152 11340480512 1970932208 19.393 100 44 89 2 1995631888 12330368 12369312
23:34:22 4867 8192000000 10918234800 11348983808 1977572160 19.445 100 52 104 1 2008852400 16431424 14848816
23:34:36 13410 8192000000 10918477840 11351310336 1978188560 19.450 100 42 84 2 2005571840 15435088 11948192
23:34:57 3998 8192000000 10927268208 11355156480 1983355296 19.491 100 53 107 1 2015621664 16729264 15537104
23:35:10 3503 8192000000 10918993888 11339448320 1972637712 19.406 99 68 136 0 2010764160 18451600 19674848
23:35:21 6442 8192000000 10930976256 11354476544 1982483056 19.484 100 71 141 1 2020092896 17985648 19624192
23:35:36 6617 8192000000 10922268144 11350638592 1977919824 19.448 100 65 130 0 2015206608 18801760 18485024
23:35:53 7389 8192000000 10905682384 11332079616 1959542800 19.302 99 58 114 0 1994961712 18703456 16715456
23:36:09 6776 8192000000 10934368144 11358347264 1985770320 19.510 100 72 143 1 2025437216 18888416 20778480
23:36:32 5107 8192000000 10937953568 11365126144 1988603584 19.533 100 73 144 1 2029158912 19644496 20910832
23:36:45 4328 8192000000 10946989472 11358593024 1983339888 19.491 100 69 138 2 2023600768 19725936 20534944
23:36:56 5577 8192000000 10943540080 11364372480 1984016912 19.496 100 67 132 0 2023184064 20452560 18714592
23:37:08 2912 8192000000 10933337792 11354329088 1983764368 19.494 100 82 164 1 2029025184 20488720 24772096
23:37:18 13081 8192000000 10923366176 11359432704 1983252144 19.490 100 67 132 0 2023066352 20415616 19398592
23:37:42 9386 8192000000 10930338496 11364691968 1987069504 19.521 100 54 108 1 2023518416 20066176 16382736
23:38:14 7370 8192000000 10939179472 11372072960 1990804416 19.550 100 56 109 1 2031172432 24638368 15729648
23:38:28 5495 8192000000 10943468624 11376443392 1993150128 19.569 100 64 127 0 2037515744 24927088 19438528
23:38:43 15016 8192000000 10939851216 11379015680 1976833008 19.440 99 48 96 1 2014581696 23065024 14683664
23:39:12 17647 8192000000 10953338448 11393744896 2003952448 19.654 100 52 105 2 2047164096 27500224 15711424
23:39:37 4960 8192000000 10977819920 11404410880 2013976064 19.733 100 64 128 3 2061783616 28298176 19509376
23:39:50 4891 8192000000 10963093456 11389636608 2000627984 19.628 100 57 114 3 2047541920 28536304 18377632
23:40:03 5158 8192000000 10982801696 11408359424 2015704176 19.746 100 70 140 0 2068193696 31196448 21293072
23:40:16 3950 8192000000 10975602000 11393990656 2000044688 19.623 99 79 153 3 2055279712 31701888 23533136
23:40:26 2905 8192000000 10987969456 11409068032 2018944304 19.772 100 77 153 1 2074433504 32256304 23232896
23:40:36 5921 8192000000 10995368032 11417079808 2021581856 19.793 100 84 168 2 2078967312 32024960 25360496
23:40:49 3730 8192000000 10981217328 11406544896 2013120288 19.726 100 71 142 0 2067212848 32681520 21411040
23:41:01 4006 8192000000 10993716240 11419320320 2021248784 19.790 100 80 159 1 2078003472 32790528 23964160
23:41:12 3294 8192000000 10984347680 11406422016 2002032592 19.639 99 79 152 0 2057717616 32916928 22768096
23:41:23 7535 8192000000 10980679664 11405930496 1993748496 19.573 99 71 142 0 2048842048 33065888 22027664
23:41:42 4096 8192000000 10992739184 11413643264 2017244352 19.758 100 74 147 1 2070722656 32379680 21098624
23:41:55 7577 8192000000 10975456208 11413807104 2011092016 19.710 100 56 112 0 2061467360 32870352 17504992
23:42:20 4184 8192000000 10963968192 11378655232 1981759472 19.479 99 65 128 0 2036289744 34319088 20211184
23:42:32 1956 8192000000 10982897472 11400744960 1991296560 19.554 99 85 167 0 2057237920 40109280 25832080
23:42:43 2410 8192000000 10955955488 11374600192 1976941072 19.440 99 69 136 1 2034665600 36089168 21635360
23:42:53 1678 8192000000 10967272880 11379019776 1983339120 19.491 100 83 164 0 2046691792 36995520 26357152
23:43:03 1858 8192000000 10979924720 11394756608 1996182752 19.593 100 85 170 1 2059834384 37310112 26341520
23:43:12 4869 8192000000 10989859184 11410149376 2006229728 19.672 100 87 176 1 2073177584 39641600 27306256
23:43:24 8314 8192000000 10977258160 11399794688 1999189584 19.616 100 71 140 2 2062501200 41741856 21569760
23:43:40 5424 8192000000 10993529040 11410890752 1988285456 19.530 99 81 161 1 2057901856 44432576 25183824
23:43:53 3029 8192000000 10986693744 11407998976 2000401440 19.626 100 79 158 0 2069103280 44070592 24631248
23:44:02 2551 8192000000 10982666064 11400683520 1981065520 19.473 99 81 162 0 2050350720 44298512 24986688
23:44:11 1832 8192000000 10961388656 11376795648 1953243120 19.252 98 80 160 0 2022582384 44803344 24535920
23:44:19 1903 8192000000 10985544608 11395891200 1989926864 19.543 100 91 182 1 2063734112 45738960 28068288
23:44:28 3806 8192000000 10995317984 11414638592 2000613280 19.628 100 76 150 1 2069839488 45984288 23241920
23:44:41 2747 8192000000 10983519360 11402805248 1993903280 19.575 100 84 166 1 2064811344 44957808 25950256
23:44:51 2238 8192000000 10995830656 11412398080 1999021008 19.615 100 89 178 1 2075565248 49122272 27421968
23:45:00 1860 8192000000 10995454192 11411374080 2002362800 19.641 100 92 184 0 2079174224 47898112 28913312
23:45:09 2215 8192000000 10966043008 11378626560 1976750896 19.439 100 86 167 0 2045905456 44336960 24817600
23:45:19 2209 8192000000 10960609504 11381727232 1964045248 19.338 99 84 168 2 2035405248 44625856 26734144
23:45:29 4900 8192000000 10959988336 11373641728 1976820144 19.440 100 81 160 1 2040601168 38678288 25102736
23:45:42 5683 8192000000 10968964032 11384774656 1968362032 19.372 99 72 144 1 2030363312 39589680 22411600
23:45:58 8913 8192000000 10947908592 11381702656 1961527296 19.318 99 53 106 0 2020481328 42123264 16830768
23:46:17 28818 8192000000 10947489680 11390959616 1977899168 19.448 100 39 78 0 2032001520 40630592 13471760
23:46:53 7765 8192000000 10948998592 11388424192 1963187696 19.331 99 37 72 0 2018044896 42519712 12337488
23:47:09 2335 8192000000 10955090592 11393228800 1982504448 19.485 100 51 102 0 2041959712 42863376 16591888
23:47:18 16933 8192000000 10920330912 11363893248 1935853040 19.114 98 30 60 1 1986632672 40730320 10049312
23:47:42 13816 8192000000 10920447744 11361734656 1954496816 19.262 99 37 74 3 2009596800 42726976 12373008
23:48:08 7669 8192000000 10901733312 11329552384 1894385184 18.781 97 48 94 1 1953830160 43296464 16148512
23:48:25 12324 8192000000 10880742320 11312328704 1904609136 18.863 99 44 89 2 1969116880 49922928 14584816
23:48:49 11521 8192000000 10884217584 11310002176 1883961856 18.697 99 40 79 2 1949730128 52291168 13477104
23:49:09 14606 8192000000 10897586592 11321548800 1871918256 18.600 98 41 81 0 1942596768 56587296 14091216
23:49:45 13610 8192000000 10897115792 11332390912 1913784704 18.937 100 32 64 0 1975594464 50455744 11354016
23:50:09 18674 8192000000 10881284832 11321409536 1900978464 18.834 99 30 60 2 1962389056 50911648 10498944
23:50:34 14382 8192000000 10893564240 11327361024 1914688560 18.944 100 28 56 1 1972869392 47742016 10438816
23:50:56 21394 8192000000 10902053312 11346812928 1929248480 19.061 100 32 64 1 1990348928 50332736 10767712
23:51:31 19623 8192000000 10903626240 11351519232 1915786736 18.953 99 22 44 4 1977273840 53042560 8444544
23:52:01 3554 8192000000 10916763232 11358531584 1934211792 19.101 100 37 74 1 2003038016 55517600 13308624
23:52:13 18521 8192000000 10925586112 11368493056 1940919488 19.154 100 32 64 0 2004149520 51665840 11564192
23:52:42 23426 8192000000 10935250544 11387568128 1943473120 19.174 100 23 46 2 2007484528 55686704 8324704
23:53:11 13062 8192000000 10936291488 11392069632 1950370784 19.229 100 26 52 1 2020397584 60493664 9533136
23:53:32 14612 8192000000 10921794032 11394289664 1951232912 19.236 100 29 56 1 2016260896 55621824 9406160
23:53:58 16476 8192000000 10925062000 11375804416 1931537600 19.079 99 27 54 1 1993906896 52978272 9391024
23:54:29 22237 8192000000 10903933920 11366916096 1940541296 19.151 100 20 40 0 1994440400 46362416 7536688
23:54:58 38933 8192000000 10863055408 11318530048 1834942000 18.300 95 13 26 0 1879490464 39450848 5097616
23:55:44 52011 8192000000 10870392944 11335614464 1925303104 19.029 100 19 38 1 1958715616 27256224 6156288
23:56:50 143839 8192000000 10873169824 11338608640 1894821472 18.785 97 37 74 0 1915692448 10480544 10390432
23:59:28 44667 8192000000 10879538624 11340976128 1930327632 19.069 99 21 39 0 1949165440 13803328 5034480
00:00:30 57353 8192000000 10868264000 11334488064 1924247488 19.021 99 9 18 1 1949364784 22180176 2937120
00:01:34 74046 8192000000 10861851168 11326365696 1941581856 19.159 100 20 40 0 1959708016 12368752 5757408
00:02:56 78119 8192000000 10864809360 11310419968 1849709232 18.420 95 17 34 1 1864580880 10189360 4682288
00:04:40 66009 8192000000 10885450864 11314810880 1887907792 18.729 97 47 89 2 1909426736 8775936 12743008
00:05:57 77913 8192000000 10891631392 11350675456 1948224656 19.212 100 33 64 1 1965716848 8621472 8870720
00:07:24 125463 8192000000 10902532416 11365478400 1970215376 19.387 100 29 59 3 1992285200 13003968 9065856
00:09:52 83546 8192000000 10905659536 11343843328 1935062224 19.107 98 42 82 0 1956972480 9372592 12537664
00:11:24 48952 8192000000 10921592240 11366817792 1974255072 19.419 100 37 74 2 1992687568 7987632 10444864
00:12:22 64297 8192000000 10932866256 11385937920 1990887616 19.551 100 47 95 1 2017318896 13188304 13242976
00:13:53 42292 8192000000 10909273040 11389116416 1986015472 19.512 100 18 36 1 2006179744 14900080 5264192
00:14:44 13024 8192000000 10922422464 11393748992 1985601824 19.509 100 17 34 1 2004251264 13815376 4834064
00:15:09 20563 8192000000 10916568976 11387383808 1993034016 19.568 100 25 50 1 2012600704 12486960 7079728
00:15:36 24518 8192000000 10930897952 11387162624 1997301312 19.601 100 33 64 1 2014763696 8247520 9214864
00:16:10 65379 8192000000 10911577488 11396591616 1997163120 19.600 100 20 40 2 2013785712 10351712 6270880
00:17:22 43372 8192000000 10910982544 11394121728 1979539616 19.461 99 9 16 2 1994198240 11968976 2689648
00:18:29 59251 8192000000 10932423328 11398975488 2000272816 19.625 100 15 30 1 2015902208 11151024 4478368
00:20:22 58153 8192000000 10926908016 11410870272 2003210128 19.648 100 16 32 0 2022709200 15181792 4317280
00:21:36 49970 8192000000 10920687328 11405217792 1987158192 19.521 99 15 30 0 2003802864 13224480 3420192
00:22:35 56165 8192000000 10917700016 11375370240 1921192528 18.996 96 16 32 1 1937342736 11315904 4834304
00:23:40 80145 8192000000 10876978272 11345354752 1892217248 18.764 96 16 32 1 1908305712 12335296 3753168
00:25:10 21076 8192000000 10908715888 11360456704 1949187200 19.220 99 38 76 0 1966190816 6417280 10586336
00:25:38 25294 8192000000 10900636688 11371462656 1972470048 19.405 100 22 44 1 1986357504 8038192 5849264
00:26:16 55140 8192000000 10895776496 11371388928 1953948352 19.258 99 11 22 3 1967265584 9718704 3598528
00:27:17 77782 8192000000 10888233104 11355443200 1865852416 18.551 94 13 26 0 1880641728 11270416 3518896
00:29:23 65111 8192000000 10857115264 11318673408 1863697456 18.533 95 17 34 0 1877887968 9991600 4198912
00:30:38 55940 8192000000 10874301264 11331756032 1856713248 18.477 95 24 48 1 1871825952 9083104 6029600
00:31:41 41053 8192000000 10874671904 11335843840 1912304896 18.925 98 23 46 0 1932086880 13774016 6007968
00:32:33 47668 8192000000 10891884304 11348291584 1935745600 19.113 99 25 50 1 1954483456 11550944 7186912
00:33:29 80215 8192000000 10861449520 11310182400 1820238720 18.180 94 9 18 0 1834685408 11821312 2625376
00:34:57 25592 8192000000 10894211984 11332911104 1916347536 18.958 99 50 100 0 1945443568 14368992 14727040
00:35:31 75011 8192000000 10859916784 11331317760 1879598432 18.662 97 21 41 1 1905045872 19588752 5858688
00:36:54 102043 8192000000 10801356784 11250237440 1750705840 17.607 91 12 24 1 1764298784 10792176 2800768
00:39:54 83528 8192000000 10831683616 11290238976 1840926784 18.348 96 31 61 2 1859386256 8756880 9702592
00:41:27 29985 8192000000 10855283024 11300724736 1880342864 18.668 98 55 108 1 1909030304 12756992 15930448
00:42:16 41727 8192000000 10828568080 11297091584 1854440304 18.458 96 30 60 0 1870375232 7325440 8609488
00:44:43 45328 8192000000 10818291856 11276636160 1840048400 18.341 96 20 38 0 1858135856 12348272 5739184
00:45:39 57943 8192000000 10820526608 11286286336 1866696400 18.558 98 14 28 1 1886673248 15177408 4799440
00:46:51 67534 8192000000 10823227008 11307077632 1884417072 18.701 99 19 38 1 1912185088 21731296 6036720
00:48:05 43009 8192000000 10841420688 11311128576 1906830560 18.881 99 24 48 2 1926067488 11329120 7907808
00:49:06 62126 8192000000 10813203440 11276136448 1824910240 18.218 95 12 23 3 1838226512 9907040 3409232
00:50:19 22169 8192000000 10836380576 11292258304 1888232064 18.732 99 27 55 0 1905069296 9227200 7610032
00:50:55 28612 8192000000 10856981088 11314098176 1906963216 18.882 99 35 70 0 1928348592 11664688 9720688
00:51:34 68377 8192000000 10856936272 11328569344 1907654608 18.888 99 22 44 1 1934601648 20282304 6664736
00:52:50 67167 8192000000 10859735344 11325976576 1912544192 18.927 99 11 22 1 1929642400 13798000 3300208
00:54:05 63585 8192000000 10864310048 11333079040 1933968736 19.099 100 23 46 0 1954596752 14123056 6504960
00:55:24 21720 8192000000 10888832528 11339108352 1928870064 19.058 99 38 76 0 1949977664 10854256 10253344
00:56:08 57926 8192000000 10892575872 11356028928 1953084704 19.251 100 26 52 1 1973762192 13820128 6857360
00:57:24 124569 8192000000 10916717312 11391483904 1950054032 19.227 99 12 24 0 1970911040 18008000 2849008
00:59:44 85357 8192000000 10910640416 11399004160 1941571232 19.159 98 10 20 0 1966761760 22199456 2991072
01:02:00 160951 8192000000 10906355200 11390541824 1962264384 19.324 99 13 26 1 1979170992 13191248 3715360
01:04:59 39572 8192000000 10918759296 11394064384 1987866832 19.527 100 7 14 0 2005005360 14988976 2149552
01:05:47 66960 8192000000 10892481024 11379126272 1953571040 19.255 98 14 28 1 1967185600 9461968 4152592
01:07:01 45789 8192000000 10863253776 11344306176 1901182720 18.836 96 5 9 0 1910505536 8103344 1219472
01:08:07 66613 8192000000 10871254064 11350405120 1910970384 18.914 97 19 38 1 1924863216 7792720 6100112
01:09:20 71751 8192000000 10868248256 11350372352 1924291248 19.021 98 12 24 0 1937726688 9989184 3446256
01:10:38 51831 8192000000 10869191696 11348410368 1911790960 18.921 98 10 21 0 1921448544 7225072 2432512
01:11:39 60591 8192000000 10880752928 11360534528 1955397376 19.269 100 12 24 0 1966656224 7904272 3354576
01:12:53 78010 8192000000 10897055584 11378122752 1954105856 19.259 99 20 38 2 1971276112 10635760 6534496
01:14:17 74753 8192000000 10887116400 11364347904 1897119264 18.803 96 18 34 2 1914519616 12338160 5062192
01:15:38 62389 8192000000 10894427840 11363868672 1910015776 18.907 97 16 32 0 1928831680 14380624 4435280
01:16:58 65701 8192000000 10882948352 11366883328 1946723504 19.200 99 21 43 1 1974461984 21040096 6698384
01:18:10 33600 8192000000 10891205792 11347271680 1894338432 18.781 96 27 53 1 1909224976 7798480 7088064
01:18:53 53535 8192000000 10897452160 11346849792 1883613104 18.694 96 25 49 1 1900445248 9744080 7088064
01:20:00 109371 8192000000 10843827200 11327102976 1848565712 18.410 95 18 36 0 1872581616 18497632 5518272
01:21:56 84180 8192000000 10866620192 11339100160 1879528128 18.661 97 13 25 1 1896805440 13812016 3465296
01:23:42 112475 8192000000 10875092704 11352014848 1886814624 18.720 97 7 14 2 1901775568 13021344 1939600
01:25:47 27399 8192000000 10884104016 11335274496 1917297840 18.965 98 38 75 1 1936078064 7732816 11047408
01:26:31 76143 8192000000 9334570384 9610514432 497980624 5.730 26 12 24 0 504603536 3408144 3214768

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 08-04-2021 01:29:07 to 08-04-2021 01:29:38.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 135 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-04-2021 01:29:39 to 08-04-2021 01:29:41.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          241398
MON$OLDEST_ACTIVE               241399
MON$OLDEST_SNAPSHOT             241399
MON$NEXT_TRANSACTION            241399
MON$PAGE_BUFFERS                1000000
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               2020-04-03 16:41:55.3470
MON$PAGES                       2012672
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33442 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33442 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33442 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33442 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

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

--- start of diff output ---
:61: 
:62: mscs-test-161.budzdorov.ru    Thu Apr  8 01:27:57 2021
:63:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:64: 
:65: 
:66: mscs-test-161.budzdorov.ru    Thu Apr  8 01:27:57 2021
:67:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:68: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

08.04.21 01:29:42. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-04-08 01:29:45 No severe PSQL-related problems occured
08.04.21 01:29:46. End of report.