Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 22.03.2021 01:27
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 17623220 kB
MemAvailable 31500176 kB
Buffers 0 kB
Cached 14020216 kB
SwapCached 0 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-03-22 01:27:23
DTS_END                         2021-03-22 01:27:23.6360
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47772
TRN_ID                          243824
ATT_ID                          626
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: 9018.40 23429 1082208
customer order: creation 176.72 398 21206
customer order: refuse 15.07 362 1808
order to supplier: creation 47.49 1275 5699
order to supplier: removal 3.13 105931 375
invoice (draft): creation 47.48 3592 5697
invoice (draft): removal 49.50 814 5940
invoice accept: apply 43.28 18519 5193
invoice accept: cancel 44.33 807 5320
customer reserve: creation 3978.26 183 477391
customer reserve: removal 4310.40 59 517248
realization accept: apply 87.03 216 10443
realization accept: cancel 82.15 118 9858
payment from customer: creation 60.41 127 7249
payment from customer: removal 6.34 98 761
payment to supplier: creation 50.43 141 6052
payment to supplier: removal 3.19 62 383
service: total inventory turnovers 5.09 1317 611
service: total monetary turnovers 7.18 52 862
service: aggregate perf. data 0.90 18664 108
service: refresh index statistics 0.03 315844 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-03-2021 01:28:18 to 22-03-2021 01:28:20.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3416
TEST_TIME 2 4204
TEST_TIME 3 2978
TEST_TIME 4 3400
TEST_TIME 5 3702
TEST_TIME 6 4199
TEST_TIME 7 5062
TEST_TIME 8 4896
TEST_TIME 9 4888
TEST_TIME 10 5059
TEST_TIME 11 5285
TEST_TIME 12 5435
TEST_TIME 13 5883
TEST_TIME 14 5803
TEST_TIME 15 6425
TEST_TIME 16 6484
TEST_TIME 17 6472
TEST_TIME 18 6690
TEST_TIME 19 7071
TEST_TIME 20 7117
TEST_TIME 21 7513
TEST_TIME 22 8072
TEST_TIME 23 8521
TEST_TIME 24 8905
TEST_TIME 25 9707
TEST_TIME 26 10052
TEST_TIME 27 10693
TEST_TIME 28 10375
TEST_TIME 29 10150
TEST_TIME 30 10268
TEST_TIME 31 10178
TEST_TIME 32 10013
TEST_TIME 33 9886
TEST_TIME 34 9703
TEST_TIME 35 9764
TEST_TIME 36 9638
TEST_TIME 37 9600
TEST_TIME 38 9358
TEST_TIME 39 9423
TEST_TIME 40 9346
TEST_TIME 41 9230
TEST_TIME 42 9086
TEST_TIME 43 9097
TEST_TIME 44 9014
TEST_TIME 45 8941
TEST_TIME 46 8932
TEST_TIME 47 9049
TEST_TIME 48 8973
TEST_TIME 49 9033
TEST_TIME 50 8987
TEST_TIME 51 8988
TEST_TIME 52 9167
TEST_TIME 53 9118
TEST_TIME 54 9116
TEST_TIME 55 9186
TEST_TIME 56 9122
TEST_TIME 57 9189
TEST_TIME 58 9175
TEST_TIME 59 9250
TEST_TIME 60 9198
TEST_TIME 61 9059
TEST_TIME 62 9096
TEST_TIME 63 9047
TEST_TIME 64 8989
TEST_TIME 65 8931
TEST_TIME 66 8875
TEST_TIME 67 8879
TEST_TIME 68 8973
TEST_TIME 69 9038
TEST_TIME 70 9013
TEST_TIME 71 9082
TEST_TIME 72 9031
TEST_TIME 73 9101
TEST_TIME 74 9131
TEST_TIME 75 9095
TEST_TIME 76 9130
TEST_TIME 77 9159
TEST_TIME 78 9141
TEST_TIME 79 9083
TEST_TIME 80 8994
TEST_TIME 81 9032
TEST_TIME 82 9010
TEST_TIME 83 8971
TEST_TIME 84 8943
TEST_TIME 85 8904
TEST_TIME 86 8869
TEST_TIME 87 8801
TEST_TIME 88 8801
TEST_TIME 89 8773
TEST_TIME 90 8820
TEST_TIME 91 8834
TEST_TIME 92 8866
TEST_TIME 93 8838
TEST_TIME 94 8933
TEST_TIME 95 8994
TEST_TIME 96 9004
TEST_TIME 97 9054
TEST_TIME 98 9067
TEST_TIME 99 9129
TEST_TIME 100 9145
TEST_TIME 101 9134
TEST_TIME 102 9157
TEST_TIME 103 9175
TEST_TIME 104 9105
TEST_TIME 105 9077
TEST_TIME 106 9071
TEST_TIME 107 9054
TEST_TIME 108 9024
TEST_TIME 109 9006
TEST_TIME 110 8973
TEST_TIME 111 8915
TEST_TIME 112 8945
TEST_TIME 113 8975
TEST_TIME 114 8970
TEST_TIME 115 8955
TEST_TIME 116 8990
TEST_TIME 117 8982
TEST_TIME 118 9018
TEST_TIME 119 9082
TEST_TIME 120 9022

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-03-2021 01:28:22 to 22-03-2021 01:28:25.

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 1521796 1521796 0 0.00 0 32034 7 0 0
doc_list_biud 1521796 1521796 0 0.00 0 52146 26 0 0
sp_add_invoice_to_stock 5320 5193 127 2.38 23 198571 18520 0 127
sp_cancel_adding_invoice 5320 5320 0 0.00 5 52164 808 0 0
sp_cancel_client_order 1808 1808 0 0.00 3 11940 363 0 0
sp_cancel_customer_reserve 517248 517248 0 0.00 1 36013 60 0 0
sp_cancel_pay_from_customer 761 761 0 0.00 2 8824 99 0 0
sp_cancel_pay_to_supplier 383 383 0 0.00 2 3151 62 0 0
sp_cancel_supplier_invoice 5954 5940 14 0.23 1 17514 815 0 14
sp_cancel_supplier_order 375 375 0 0.00 8 983246 105932 0 0
sp_cancel_write_off 9858 9858 0 0.00 1 32035 118 0 0
sp_client_order 21206 21206 0 0.00 4 17356 398 0 0
sp_customer_reserve 477391 477391 0 0.00 0 66177 184 0 0
sp_fill_shopping_cart 32594 32594 0 0.00 1 10417 42 0 0
sp_fill_shopping_cart_clo_res 477386 477386 0 0.00 0 20467 14 0 0
sp_get_clo_for_invoice 5188 5188 0 0.00 0 31510 304 0 0
sp_kill_cost_storno 16322 16322 0 0.00 0 32031 55 0 0
sp_kill_qstorno_ret_qs2qd 1050669 1050669 0 0.00 0 35990 32 0 0
sp_kill_qty_storno 556180 556180 0 0.00 0 52144 71 0 0
sp_lock_selected_doc 21460 21460 0 0.00 0 11091 7 0 0
sp_make_cost_storno 28932 28932 0 0.00 0 30000 62 0 0
sp_multiply_rows_for_pdistr 28932 28932 0 0.00 0 29127 33 0 0
sp_multiply_rows_for_qdistr 21206 21206 0 0.00 0 16895 191 0 0
sp_pay_from_customer 7249 7249 0 0.00 4 29762 128 0 0
sp_pay_to_supplier 6052 6052 0 0.00 5 28209 141 0 0
sp_payment_common 13301 13301 0 0.00 1 29025 44 0 0
sp_qd_handle_on_cancel_clo 1808 1808 0 0.00 0 11929 342 0 0
sp_qd_handle_on_invoice_upd_sts 10508 10508 0 0.00 0 52142 359 0 0
sp_qd_handle_on_reserve_upd_sts 10443 10443 0 0.00 0 25515 63 0 0
sp_reserve_write_off 10443 10443 0 0.00 6 30196 217 0 0
sp_supplier_invoice 5697 5697 0 0.00 7 93677 3593 0 0
sp_supplier_order 5699 5699 0 0.00 5 39778 1276 0 0
srv_aggregate_perf_data 108 108 0 0.00 2805 298070 18664 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 612 131694 33518 0 0
srv_find_qd_qs_mism 1031772 1031772 0 0.00 0 13446 6 0 0
srv_make_invnt_saldo 611 611 0 0.00 41 122614 1317 0 0
srv_make_money_saldo 862 862 0 0.00 1 23017 52 0 0
srv_recalc_idx_stat 4 4 0 0.00 138108 488470 315845 0 0
t$perf-abend:sp_add_invoice_to_stock 127 127 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5193 5193 0 0.00 0 28135 152 0 0
t$perf-norm:sp_cancel_adding_invoice 411 411 0 0.00 0 11299 152 0 0
t$perf-norm:sp_cancel_client_order 1808 1808 0 0.00 0 7684 27 0 0
t$perf-norm:sp_cancel_customer_reserve 683 683 0 0.00 0 708 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 761 761 0 0.00 0 2975 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 383 383 0 0.00 0 5073 20 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 1867 20 0 0
t$perf-norm:sp_cancel_supplier_order 375 375 0 0.00 0 36977 1640 0 0
t$perf-norm:sp_cancel_write_off 1003 1003 0 0.00 0 4053 13 0 0
t$perf-norm:sp_client_order 21206 21206 0 0.00 0 12834 19 0 0
t$perf-norm:sp_customer_reserve 961 961 0 0.00 0 996 7 0 0
t$perf-norm:sp_pay_from_customer 7249 7249 0 0.00 0 12417 12 0 0
t$perf-norm:sp_pay_to_supplier 6052 6052 0 0.00 0 11618 14 0 0
t$perf-norm:sp_reserve_write_off 10443 10443 0 0.00 0 13053 17 0 0
t$perf-norm:sp_supplier_invoice 5697 5697 0 0.00 0 16777 26 0 0
t$perf-norm:sp_supplier_order 5699 5699 0 0.00 0 5480 16 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 575 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 477 13 0 0
t$perf-norm:srv_make_invnt_saldo 611 611 0 0.00 0 1446 29 0 0
t$perf-norm:srv_make_money_saldo 862 862 0 0.00 0 898 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10630 10376 254 2.38 0 5403 17 0 254
v_all_customers 38370 38370 0 0.00 0 79 1 0 0
v_all_suppliers 31542 31542 0 0.00 0 57 1 0 0
v_all_wares 42412 42412 0 0.00 0 99 1 0 0
v_cancel_adding_invoice 822 822 0 0.00 0 4158 13 0 0
v_cancel_client_order 3616 3616 0 0.00 0 3619 4 0 0
v_cancel_customer_prepayment 1522 1522 0 0.00 0 5133 14 0 0
v_cancel_customer_reserve 1366 1366 0 0.00 0 1060 6 0 0
v_cancel_payment_to_supplier 766 766 0 0.00 0 3137 8 0 0
v_cancel_supplier_invoice 838 810 28 3.34 0 5396 23 0 28
v_cancel_supplier_order 750 750 0 0.00 0 3147 12 0 0
v_cancel_write_off 2006 2006 0 0.00 0 3705 15 0 0
v_max_id_clo_ord 5698 5698 0 0.00 0 1709 2 0 0
v_max_id_clo_res 961 961 0 0.00 0 2782 14 0 0
v_max_id_ord_sup 5690 5690 0 0.00 0 5196 5 0 0
v_max_non_paid_invoice 1669 1669 0 0.00 0 2316 4 0 0
v_max_non_paid_realizn 4002 4002 0 0.00 0 5896 8 0 0
v_min_id_clo_ord 5698 5698 0 0.00 0 2796 9 0 0
v_min_id_clo_res 961 961 0 0.00 0 5426 15 0 0
v_min_id_ord_sup 5690 5690 0 0.00 0 4817 8 0 0
v_min_non_paid_invoice 6052 6052 0 0.00 0 27166 32 0 0
v_min_non_paid_realizn 7249 7249 0 0.00 0 29020 29 0 0
v_our_firm 10536 10536 0 0.00 0 15 1 0 0
v_reserve_write_off 20886 20886 0 0.00 0 4166 5 0 0
x_lock_depdocs_on_canc_invoice 10855 10855 0 0.00 0 12564 123 0 0
x_lock_depdocs_on_canc_sup_ord 375 375 0 0.00 0 18486 456 0 0
x_make_qstorno_1000_1200 5699 5699 0 0.00 2 39748 1190 0 0
x_make_qstorno_1200_2000 5697 5697 0 0.00 3 93481 3441 0 0
x_make_qstorno_2100_3300 477391 477391 0 0.00 0 66175 167 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-03-2021 01:28:26 to 22-03-2021 01:28:30.

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:27 4 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:33 7165 8192000000 10143511984 10435059712 783866208 8.733 64 51 110 0 802867200 2125968 16875024
22:57:48 23834 8192000000 10320783200 10631348224 1362091328 14.256 100 86 172 1 1395204064 4362432 28750304
22:58:20 15632 8192000000 10351312528 10665185280 1404084656 14.631 100 89 178 0 1439713600 5829296 29799648
22:58:46 34858 8192000000 10383045456 10707714048 1431050144 14.871 100 83 166 0 1465499472 6869232 27580096
22:59:31 30696 8192000000 10414540336 10743496704 1460600992 15.131 100 85 170 1 1495751120 7538240 27611888
23:00:15 26824 8192000000 10437521184 10770710528 1488974736 15.380 100 85 170 1 1525319616 8762144 27582736
23:00:51 22372 8192000000 10468179008 10805436416 1516966544 15.624 100 89 180 0 1554529232 9389200 28173488
23:01:25 18944 8192000000 10504492640 10849038336 1545007808 15.867 100 85 170 0 1581008752 9761360 26239584
23:01:52 16501 8192000000 10526534912 10877669376 1578543904 16.156 100 80 160 0 1613008016 9917120 24546992
23:02:18 12650 8192000000 10556206848 10908155904 1606310896 16.393 100 80 160 1 1641326880 10283072 24732912
23:02:39 12024 8192000000 10571625872 10930036736 1625021136 16.553 100 82 164 1 1660624416 11082928 24520352
23:03:01 12947 8192000000 10581286640 10943586304 1647478384 16.743 100 82 164 1 1683020960 11457376 24085200
23:03:21 11170 8192000000 10592011968 10961137664 1656434784 16.819 100 67 134 0 1688315552 12216336 19664432
23:03:41 11151 8192000000 10616296704 10983227392 1674948368 16.975 100 81 162 2 1710996864 12236416 23812080
23:04:01 8128 8192000000 10636612432 11005915136 1693052048 17.127 100 80 160 0 1727960656 11792640 23115968
23:04:17 5743 8192000000 10648653216 11023028224 1711951408 17.285 100 77 154 2 1745980704 11796416 22232880
23:04:29 7897 8192000000 10661366864 11036336128 1726910272 17.410 100 80 160 2 1762622224 12658464 23053488
23:04:45 8200 8192000000 10677632480 11051847680 1736191632 17.487 100 83 162 0 1772667088 13394960 23080496
23:05:01 4772 8192000000 10682725200 11059367936 1745490848 17.564 100 79 156 0 1781011568 13360352 22160368
23:05:12 4700 8192000000 10695917264 11074789376 1759931120 17.684 100 80 160 1 1794222016 12066688 22224208
23:05:24 6933 8192000000 10704172784 11084304384 1764569984 17.722 100 81 160 1 1800633168 13554064 22509120
23:05:39 4474 8192000000 10700497936 11080802304 1770145792 17.768 100 86 172 0 1808638848 14272560 24220496
23:05:50 4123 8192000000 10725358160 11104354304 1784975552 17.890 100 88 173 1 1822094464 13269632 23849280
23:06:01 2945 8192000000 10727035344 11103539200 1785721600 17.897 100 82 164 0 1821870656 13477584 22671472
23:06:10 4388 8192000000 10729314304 11112919040 1790878144 17.939 100 80 158 0 1826363264 13302624 22182496
23:06:21 2911 8192000000 10743177712 11123879936 1799975472 18.014 100 92 184 2 1840294544 14957728 25361344
23:06:30 3966 8192000000 10739094848 11124260864 1803505136 18.043 100 88 173 0 1842017296 14165312 24346848
23:06:41 3786 8192000000 10757834592 11137466368 1809726208 18.094 100 89 179 0 1848508336 14382480 24399648
23:06:52 2767 8192000000 10759652128 11142893568 1816853312 18.152 100 92 185 0 1857224528 14959904 25411312
23:07:01 9644 8192000000 10756162464 11142647808 1816979776 18.153 100 88 175 3 1854858064 14570000 23308288
23:07:18 3518 8192000000 10752338160 11143155712 1818350848 18.164 100 81 161 0 1855285792 14597952 22336992
23:07:30 1522 8192000000 10772619280 11158323200 1832191536 18.277 100 83 165 0 1867119840 11923360 23004944
23:07:38 2307 8192000000 10780742736 11166892032 1841827248 18.356 100 83 165 0 1877375056 12312128 23235680
23:07:47 2637 8192000000 10791121888 11175092224 1845963792 18.389 100 90 180 1 1885190704 13177904 26049008
23:07:56 2705 8192000000 10787169632 11176407040 1847701760 18.403 100 92 184 1 1887870640 14212352 25956528
23:08:06 2024 8192000000 10791576928 11178135552 1848964096 18.414 100 86 171 2 1886226272 12748768 24513408
23:08:14 1728 8192000000 10800357024 11187888128 1856178240 18.472 100 96 191 0 1896828576 12949712 27700624
23:08:22 1892 8192000000 10808606208 11194290176 1859532864 18.499 100 94 185 2 1898461536 13602960 25325712
23:08:31 1350 8192000000 10807666832 11193929728 1860093040 18.504 100 94 190 0 1899368544 13027392 26248112
23:08:38 2430 8192000000 10804014192 11192979456 1861356992 18.514 100 89 179 2 1898663824 11397776 25909056
23:08:47 19601 8192000000 10797080176 11194298368 1858329296 18.490 100 65 130 1 1887353216 11357984 17665936
23:09:14 14518 8192000000 10805074304 11195367424 1861347680 18.514 100 74 147 4 1894059904 11829872 20882352
23:09:34 2012 8192000000 10818254304 11206135808 1871064096 18.593 100 90 178 2 1908651264 12250288 25336880
23:09:42 8194 8192000000 10805343664 11205058560 1864820176 18.542 100 61 123 0 1894369824 12388864 17160784
23:09:58 10961 8192000000 10776122624 11191578624 1863985792 18.536 100 31 62 1 1881357136 7902720 9468624
23:10:15 4188 8192000000 10779302240 11197153280 1866632480 18.557 100 42 86 0 1885365808 6693872 12039456
23:10:26 6703 8192000000 10775803440 11203604480 1868574464 18.573 100 36 73 1 1886403648 8015040 9814144
23:10:42 4227 8192000000 10784115632 11207143424 1875473680 18.629 100 37 75 1 1892059024 5984288 10601056
23:10:54 7776 8192000000 10768922384 11206176768 1873260992 18.611 100 25 50 1 1887367408 6969184 7137232
23:11:09 2909 8192000000 10792687760 11211821056 1877986400 18.649 100 33 66 1 1894471360 6856432 9628528
23:11:21 6036 8192000000 10782924560 11213475840 1877197424 18.642 100 23 46 1 1890554064 6902752 6453888
23:11:36 8259 8192000000 10783262192 11210452992 1875453088 18.628 100 11 21 1 1884029264 5284576 3291600
23:11:51 17979 8192000000 10783341936 11213242368 1876066816 18.633 100 10 20 2 1884325216 5866384 2392016
23:12:19 9793 8192000000 10787571472 11222028288 1882025264 18.681 100 17 34 2 1892621088 6051632 4544192
23:12:38 5983 8192000000 10795757392 11224977408 1885587040 18.710 100 21 42 2 1897713776 5921952 6204784
23:12:53 13910 8192000000 10787116128 11223117824 1884844448 18.704 100 17 34 2 1896024896 6639536 4540912
23:13:17 10755 8192000000 10795750912 11226169344 1887277264 18.724 100 23 45 3 1900336992 6419200 6640528
23:13:34 70375 8192000000 10822978752 11251159040 1896955168 18.802 100 33 65 2 1912705696 6255472 9495056
23:14:56 7861 8192000000 10821789712 11246063616 1901200384 18.836 100 40 80 1 1919122464 6879104 11042976
23:15:10 3700 8192000000 10819975536 11249631232 1901099792 18.835 100 33 66 1 1917670048 7015072 9555184
23:15:20 4050 8192000000 10817759280 11251564544 1905156992 18.868 100 36 72 0 1922166720 7234384 9775344
23:15:31 3404 8192000000 10830428224 11255508992 1904578592 18.863 100 42 84 4 1924508608 8247376 11682640
23:15:42 4372 8192000000 10821809536 11252772864 1902196912 18.844 100 31 60 1 1917799984 7388048 8215024
23:15:55 7610 8192000000 10827165712 11257376768 1903996576 18.858 100 16 32 1 1913682160 5263232 4422352
23:16:10 6267 8192000000 10825371744 11255615488 1903494784 18.854 100 24 48 1 1915867936 5421008 6952144
23:16:27 18176 8192000000 10822723584 11249004544 1866604432 18.557 98 16 32 3 1876686192 5803808 4277952
23:16:51 9399 8192000000 10812792512 11250733056 1901871712 18.841 100 21 40 4 1913936064 5907376 6156976
23:17:07 9161 8192000000 10822184064 11251888128 1880877488 18.672 99 18 36 0 1891726064 5833872 5014704
23:17:24 10139 8192000000 10787843104 11218178048 1825146720 18.220 96 17 32 1 1834752624 5287168 4318736
23:17:40 12018 8192000000 10781285440 11209551872 1820421008 18.181 97 10 20 1 1828158592 5135056 2602528
23:17:59 8090 8192000000 10773317056 11195006976 1795477552 17.977 96 17 33 2 1806496128 6046368 4972208
23:18:15 53892 8192000000 10767602448 11197931520 1796053360 17.982 96 25 50 1 1808942256 6076160 6812736
23:19:16 8597 8192000000 10769009920 11197640704 1837601456 18.321 99 22 43 1 1850091280 6223984 6265840
23:19:32 8245 8192000000 10775675264 11193688064 1808949392 18.087 97 38 76 1 1826912400 7283728 10679280
23:19:47 6860 8192000000 10757438432 11176611840 1826059696 18.227 99 32 64 1 1841248864 6386624 8802544
23:20:00 7127 8192000000 10725684224 11139461120 1755859824 17.650 96 26 52 4 1768787440 5551168 7376448
23:20:14 6500 8192000000 10733639136 11155116032 1798783840 18.004 99 29 58 5 1813035072 6020736 8230496
23:20:29 5786 8192000000 10720443232 11131834368 1767211600 17.744 97 30 60 3 1782223760 5780544 9231616
23:20:42 5566 8192000000 10672807952 11089641472 1712483936 17.289 95 33 67 1 1727567600 4922704 10160960
23:20:54 4684 8192000000 10707445728 11119796224 1774810960 17.807 99 32 65 0 1789934928 5385536 9738432
23:21:09 8754 8192000000 10731004304 11130716160 1728832192 17.426 96 28 55 3 1742406656 4661424 8913040
23:21:26 5864 8192000000 10704097200 11113545728 1732006240 17.452 96 24 48 2 1748648208 9815888 6826080
23:21:38 8409 8192000000 10678780720 11102507008 1709354784 17.263 95 15 31 0 1719138944 5622000 4162160
23:21:53 12162 8192000000 10710488800 11118583808 1728577712 17.424 96 27 54 2 1741723088 4506016 8639360
23:22:11 8007 8192000000 10691242288 11105431552 1756426432 17.655 98 34 68 4 1772396608 4652496 11317680
23:22:28 10838 8192000000 10695255232 11111395328 1734894640 17.476 96 19 36 2 1745384880 5177360 5312880
23:22:45 61647 8192000000 10714842496 11125006336 1749389616 17.597 97 31 62 1 1763444464 5620560 8434288
23:23:54 20806 8192000000 10746440320 11168096256 1819524240 18.174 100 37 74 1 1837066000 7764544 9777216
23:24:23 6068 8192000000 10745642064 11172937728 1832598160 18.281 100 44 89 1 1856237216 11346448 12292608
23:24:39 4980 8192000000 10753215664 11173617664 1826448288 18.230 100 27 54 0 1844944016 11277152 7218576
23:24:51 7236 8192000000 10765925552 11182759936 1837703056 18.322 100 28 56 1 1852153520 6675760 7774704
23:25:07 6001 8192000000 10755410416 11186503680 1844373632 18.376 100 27 54 0 1858497040 6240576 7882832
23:25:20 6116 8192000000 10759229888 11192324096 1849665168 18.419 100 28 54 2 1863319744 5783024 7871552
23:25:33 11982 8192000000 10766833440 11196727296 1854958000 18.462 100 30 59 2 1868757952 5085808 8714144
23:25:57 11126 8192000000 10772982080 11200053248 1854663920 18.460 100 27 54 1 1869481600 6893872 7923808
23:26:16 14599 8192000000 10770196032 11201699840 1860309040 18.506 100 28 56 1 1874499984 5068432 9122512
23:26:37 6059 8192000000 10775262704 11207548928 1858892032 18.494 100 19 38 0 1870176432 5544736 5739664
23:26:52 6941 8192000000 10776988912 11207245824 1860827968 18.510 100 25 50 3 1873554272 5887360 6838944
23:27:08 8406 8192000000 10801330624 11224195072 1882211008 18.683 100 24 47 4 1893917056 5150464 6555584
23:27:22 39858 8192000000 10813709568 11234852864 1884415808 18.701 100 25 47 1 1895347648 4627712 6304128
23:28:12 4149 8192000000 10828170432 11248074752 1898229264 18.812 100 37 74 1 1921953296 12589744 11134288
23:28:25 44066 8192000000 10842156464 11261341696 1910755408 18.913 100 49 100 3 1934711824 9647536 14308880
23:29:16 67330 8192000000 10863224496 11292319744 1918953184 18.978 100 48 96 0 1946517264 13586464 13977616
23:30:33 38250 8192000000 10861308192 11291971584 1927827808 19.050 100 42 83 3 1955959168 16089424 12041936
23:31:25 12116 8192000000 10874342160 11298537472 1933825616 19.097 100 49 98 2 1960578768 12329872 14423280
23:32:06 15249 8192000000 10890036608 11309785088 1941840720 19.161 100 53 105 1 1970850064 13653984 15355360
23:32:31 15620 8192000000 10888731920 11313852416 1948003808 19.211 100 60 120 1 1979480992 14151936 17325248
23:32:55 12594 8192000000 10897151104 11318890496 1949881952 19.226 100 64 128 1 1984881376 16228368 18771056
23:33:24 7515 8192000000 10896691040 11326574592 1951453056 19.238 100 55 107 0 1983556656 16055296 16048304
23:33:39 1887 8192000000 10918949216 11328909312 1957322688 19.285 100 67 131 1 1993994576 18143680 18528208
23:33:51 13967 8192000000 10905741808 11333214208 1959988624 19.306 100 56 111 0 1993263296 17436528 15838144
23:34:29 11109 8192000000 10898734400 11342675968 1963975024 19.338 100 48 94 0 1995914304 17802528 14136752
23:34:47 20114 8192000000 10905716528 11351728128 1966974400 19.361 100 31 62 1 1993762640 17475312 9312928
23:35:17 5502 8192000000 10924072944 11353468928 1975651648 19.430 100 55 109 0 2008547872 16740192 16156032
23:35:32 2828 8192000000 10916110544 11349721088 1972375600 19.404 100 58 116 2 2008795600 18578320 17841680
23:35:44 46168 8192000000 10920214544 11359973376 1973257744 19.411 100 47 94 1 2009311296 21681536 14372016
23:36:53 3013 8192000000 10937611968 11369816064 1984692016 19.502 100 60 117 1 2028317360 25863936 17761408
23:37:05 5815 8192000000 10945776272 11373580288 1991475984 19.555 100 67 132 0 2038313584 26522352 20315248
23:37:19 3324 8192000000 10956271248 11380027392 1994110512 19.576 100 77 152 1 2045853984 28708672 23034800
23:37:30 9498 8192000000 10963800544 11388903424 1998092080 19.608 100 75 149 0 2049049264 29231936 21725248
23:38:02 3961 8192000000 10976521504 11398873088 2005319728 19.665 100 65 130 1 2056616224 31926864 19369632
23:38:17 3132 8192000000 10980026992 11405565952 2014987792 19.741 100 77 151 1 2071080352 32874768 23217792
23:38:27 3794 8192000000 10980557632 11401740288 2010342928 19.704 100 77 154 0 2067535520 33939680 23252912
23:38:39 3938 8192000000 10978630832 11402870784 2009915888 19.701 100 71 142 1 2065609456 34590272 21103296
23:38:53 3300 8192000000 10985314176 11405557760 2013580592 19.730 100 76 152 3 2070922880 35195904 22146384
23:39:02 5237 8192000000 10972969488 11399307264 2007692112 19.683 100 80 160 2 2069782768 37645360 24445296
23:39:16 13101 8192000000 10980628080 11404378112 1992346432 19.562 99 79 156 2 2057725536 42236064 23143040
23:39:46 6012 8192000000 10971757120 11409850368 2007281024 19.680 100 55 110 0 2066945840 42154144 17510672
23:40:01 5916 8192000000 10976079200 11404238848 1984575152 19.501 99 55 110 1 2044904688 42360080 17969456
23:40:15 5714 8192000000 10971005072 11398660096 1981062000 19.473 99 57 114 0 2040448144 41601744 17784400
23:40:28 13325 8192000000 10974908640 11409854464 2003433296 19.650 100 53 106 1 2058683904 39323136 15927472
23:40:49 2355 8192000000 10983247808 11414908928 2007629760 19.683 100 56 112 0 2065265856 40759392 16876704
23:40:58 3965 8192000000 10979662240 11404849152 1997747984 19.605 100 79 158 4 2064297120 42057184 24491952
23:41:08 6921 8192000000 10951218992 11373600768 1973469744 19.413 99 71 142 0 2038587648 43132064 21985840
23:41:23 4381 8192000000 10977023408 11398475776 1992144624 19.561 100 80 161 1 2061753184 45165280 24443280
23:41:34 4371 8192000000 10983525232 11402674176 1994888544 19.582 100 78 156 1 2066107952 47717808 23501600
23:41:49 5722 8192000000 10987433696 11408162816 1996268432 19.593 100 81 161 1 2070776736 50292944 24215360
23:42:06 2584 8192000000 10992513504 11406528512 1997152672 19.600 100 84 166 2 2072201392 49926992 25121728
23:42:17 2354 8192000000 10986123008 11409285120 1997896560 19.606 100 78 155 2 2071906976 50208192 23802224
23:42:27 5192 8192000000 10997395376 11412115456 2008199296 19.687 100 79 158 1 2075158464 42979280 23979888
23:42:38 5191 8192000000 10990203824 11406942208 1999318032 19.617 100 83 168 0 2067923168 43489760 25115376
23:42:59 6144 8192000000 10987700976 11409199104 2005917920 19.669 100 77 153 0 2071827392 42434304 23475168
23:43:13 2560 8192000000 10987132384 11408248832 2003804816 19.653 100 88 173 2 2073177568 42790464 26582288
23:43:24 1406 8192000000 10998088848 11414409216 2013186496 19.727 100 81 155 6 2081423696 43625408 24611792
23:43:32 4978 8192000000 10975738112 11394428928 1993288400 19.570 100 82 162 1 2060672080 41273232 26110448
23:43:50 2504 8192000000 10970677584 11391197184 1987149920 19.521 100 80 160 1 2055217472 42753648 25313904
23:44:00 4351 8192000000 10971646320 11385315328 1964443680 19.341 99 84 166 1 2034678288 43818368 26416240
23:44:12 1791 8192000000 10966737344 11379437568 1973609280 19.414 100 83 166 0 2046246176 47010000 25626896
23:44:22 5933 8192000000 10971615968 11391705088 1981877776 19.480 100 73 143 1 2055307136 51105968 22323392
23:44:37 610 8192000000 10971064528 11381116928 1975251280 19.427 100 86 167 0 2048091296 48069936 24770080
23:44:45 3022 8192000000 10981720480 11394244608 1984853376 19.503 100 86 168 0 2061461696 51273840 25334480
23:44:55 5309 8192000000 10981167584 11396624384 1985827552 19.511 100 80 159 2 2061492816 51062224 24603040
23:45:09 2603 8192000000 10990974560 11402002432 1990109184 19.545 100 91 181 2 2070229664 52657936 27462544
23:45:20 5584 8192000000 10986161728 11398422528 1984828768 19.503 100 88 177 2 2065650544 53358976 27462800
23:45:33 3919 8192000000 10962478000 11379142656 1971251392 19.395 100 77 154 2 2046385088 51050704 24082992
23:45:45 4953 8192000000 10968040768 11382050816 1974025520 19.417 100 86 171 3 2053820592 52337120 27457952
23:45:58 6295 8192000000 10973792464 11395145728 1977984576 19.449 100 77 151 0 2055442224 53023968 24433680
23:46:12 1567 8192000000 10988204272 11399692288 1985405216 19.507 100 86 172 3 2068276608 54205536 28665856
23:46:20 2245 8192000000 10995817584 11405160448 1989848368 19.543 100 92 185 2 2072712672 53708704 29155600
23:46:29 3557 8192000000 10993157376 11408203776 1990194672 19.545 100 82 163 1 2071056320 54658880 26202768
23:46:41 4145 8192000000 10980630960 11407466496 1990789056 19.550 100 71 142 1 2064232016 49950160 23492800
23:46:51 2613 8192000000 10977256064 11394379776 1980536080 19.469 100 82 163 2 2058282640 52943040 24803520
23:47:03 1583 8192000000 10959136448 11369926656 1938488928 19.135 99 91 180 2 2022277584 55136480 28652176
23:47:14 2298 8192000000 10973561760 11380617216 1963589824 19.335 100 86 172 1 2046608352 55849776 27168752
23:47:23 1310 8192000000 10964727888 11369037824 1950630240 19.231 99 90 179 2 2035177248 57132400 27414608
23:47:31 3289 8192000000 10966943024 11379728384 1954444848 19.262 100 75 150 0 2041663072 63092032 24126192
23:47:44 7990 8192000000 10943917936 11367497728 1932866672 19.090 99 64 125 1 2012230192 59280000 20083520
23:48:00 3703 8192000000 10955083104 11373101056 1950339808 19.229 100 71 136 3 2033781600 61125168 22316624
23:48:12 2072 8192000000 10983827184 11394285568 1966878176 19.361 100 86 170 1 2057524256 62689808 27956272
23:48:21 1686 8192000000 10982560080 11389411328 1964853296 19.345 100 86 170 1 2057767552 65868512 27045744
23:48:32 7777 8192000000 10945076048 11381792768 1950411184 19.230 100 43 86 2 2031964832 65964016 15589632
23:48:51 6860 8192000000 10941803776 11370541056 1946486608 19.198 100 49 96 3 2025104464 60640016 17977840
23:49:07 11495 8192000000 10936040224 11371839488 1935112768 19.108 99 45 89 2 2011086784 60489696 15484320
23:49:28 14583 8192000000 10932844800 11376644096 1936425520 19.118 99 46 87 1 2013641376 62018096 15197760
23:49:49 13728 8192000000 10931927280 11373588480 1949559888 19.223 100 40 80 1 2016139280 52544256 14035136
23:50:28 27010 8192000000 10906982400 11353710592 1929414560 19.062 99 33 66 2 1986048592 45375888 11258144
23:51:14 27553 8192000000 10915309632 11368894464 1942954560 19.170 100 27 54 0 2003383488 50323280 10105648
23:51:49 23331 8192000000 10882935104 11339309056 1878833248 18.656 97 24 48 1 1939309232 51722080 8753904
23:52:19 23327 8192000000 10881052032 11347030016 1933985520 19.099 100 24 48 1 1984799472 42811776 8002176
23:52:56 26687 8192000000 10867640800 11323998208 1894741408 18.784 99 18 34 0 1936608832 35786944 6080480
23:53:30 36911 8192000000 10874433344 11327115264 1913866528 18.938 100 15 30 0 1954367984 35298992 5202464
23:54:14 82020 8192000000 10878122608 11306983424 1887888064 18.729 98 25 50 1 1908288736 13265728 7134944
23:55:49 51411 8192000000 10875139552 11324411904 1931887104 19.082 100 30 59 2 1953269200 12873232 8508864
23:56:47 23484 8192000000 10868710672 11321389056 1920028304 18.987 99 18 36 2 1939128496 13082752 6017440
23:57:28 25618 8192000000 10858575888 11313143808 1909592096 18.903 98 31 63 3 1924112032 6243760 8276176
23:58:13 82643 8192000000 10866663312 11318960128 1906664688 18.880 98 21 43 0 1918582400 6954528 4963184
23:59:53 40524 8192000000 10875476432 11335811072 1946813584 19.201 99 24 48 1 1960116016 6958464 6343968
00:00:39 82498 8192000000 10891094656 11346755584 1944109216 19.180 99 14 28 2 1956112016 7993408 4009392
00:02:08 72421 8192000000 10868705776 11337900032 1926409568 19.038 98 12 24 1 1940749152 10412464 3927120
00:03:33 42394 8192000000 10872543888 11332853760 1938493744 19.135 99 15 30 0 1951569872 9245680 3830448
00:04:22 101088 8192000000 10878759296 11343048704 1938088192 19.131 99 20 39 0 1953579248 9712688 5778368
00:06:10 97366 8192000000 10870028352 11344879616 1930675216 19.072 98 15 30 0 1942593024 7959696 3958112
00:07:54 65738 8192000000 10841674928 11312009216 1906329888 18.877 98 15 29 0 1918901536 8198816 4372832
00:09:18 32456 8192000000 10879144800 11334496256 1939482688 19.143 100 21 43 1 1960289360 14756112 6050560
00:09:58 39603 8192000000 10868554784 11346046976 1951942528 19.242 100 33 66 0 1973666384 12046208 9677648
00:10:44 62264 8192000000 10878562592 11344097280 1938499152 19.135 99 15 30 0 1951083776 8523728 4060896
00:12:03 84191 8192000000 10892710608 11359408128 1947608656 19.207 99 14 27 1 1963066416 11521680 3936080
00:13:47 37181 8192000000 10889840496 11367333888 1966540704 19.358 100 12 21 1 1984630528 14873328 3216496
00:15:16 33789 8192000000 10889898544 11350634496 1934644112 19.104 98 31 61 1 1953738320 10406272 8687936
00:16:30 62754 8192000000 10892163472 11350749184 1954210304 19.260 99 22 44 3 1968396704 8491280 5695120
00:17:39 55296 8192000000 10916174176 11370946560 1926028608 19.035 97 32 64 2 1947230016 11957008 9244400
00:18:58 129682 8192000000 10907294848 11380154368 1890991264 18.754 96 12 24 0 1907831824 13976544 2864016
00:21:24 56972 8192000000 10885994944 11354132480 1949511136 19.223 99 8 16 1 1968208176 16457856 2239184
00:22:32 63421 8192000000 10892797184 11360874496 1912699472 18.928 97 9 18 0 1923617696 8513968 2404256
00:23:42 48229 8192000000 10922367360 11374624768 1979443168 19.460 100 31 61 0 2000201872 12389520 8369184
00:24:40 81012 8192000000 10898640256 11347988480 1876445904 18.636 95 27 53 0 1898955024 15342512 7166608
00:26:07 46218 8192000000 10912186528 11369181184 1946997664 19.203 99 34 67 2 1971843424 15068240 9777520
00:27:03 61055 8192000000 10857620192 11322925056 1896762256 18.800 96 24 48 1 1915386432 11277168 7347008
00:28:57 86212 8192000000 10880778704 11356819456 1951746080 19.240 100 26 52 1 1972407712 13078560 7583072
00:30:30 21106 8192000000 10851636272 11338407936 1918987840 18.979 99 8 16 2 1933373568 12613904 1771824
00:31:00 36508 8192000000 10836656096 11306975232 1894507152 18.782 97 16 32 0 1904726672 5976112 4243408
00:31:43 36477 8192000000 10838332064 11307048960 1864993616 18.544 96 9 18 0 1874785760 7827408 1964736
00:32:25 57006 8192000000 10830400800 11295793152 1833710160 18.290 95 11 22 0 1845790320 9652896 2427264
00:33:38 32787 8192000000 10869647888 11334275072 1901150240 18.836 98 17 33 2 1920765744 15375696 4239808
00:34:18 65017 8192000000 10867205248 11332165632 1889039632 18.738 97 20 41 0 1906969056 11585504 6343920
00:35:31 64733 8192000000 10879384912 11344257024 1924575968 19.023 99 16 33 1 1941013680 11454288 4983424
00:37:02 65795 8192000000 10883913520 11333971968 1885085456 18.706 96 23 44 0 1906195616 14214176 6895984
00:38:14 80657 8192000000 10867273904 11332665344 1904056848 18.859 98 19 38 1 1921753264 12515904 5180512
00:39:41 75659 8192000000 10851834256 11315019776 1786668224 17.904 92 29 58 1 1807817616 12949664 8199728
00:41:08 48822 8192000000 10859098720 11316563968 1890793184 18.752 98 19 38 0 1905156368 9306464 5056720
00:42:05 83904 8192000000 10880945984 11346731008 1922536736 19.007 99 24 48 1 1941982064 10772544 8672784
00:43:41 131694 8192000000 10875257648 11332362240 1854013008 18.455 95 20 40 3 1873571072 14085568 5472496
00:46:17 16484 8192000000 10897878464 11345096704 1959201456 19.300 100 61 123 0 1989533904 13682720 16649728
00:46:39 119547 8192000000 10874250464 11347877888 1955127568 19.267 100 41 82 3 1981858176 15290416 11440192
00:48:50 32447 8192000000 10875240928 11345018880 1932455568 19.087 99 14 28 2 1945973008 9741168 3776272
00:49:37 66850 8192000000 10848848368 11331674112 1893786544 18.776 97 15 30 0 1908560624 10576480 4197600
00:50:50 31633 8192000000 10845557744 11329224704 1918552496 18.975 99 5 9 0 1928864528 9306112 1005920
00:51:32 21178 8192000000 10859124224 11332198400 1912945808 18.930 99 8 16 0 1923341424 8426576 1969040
00:52:27 72798 8192000000 10849925120 11316293632 1898041584 18.811 98 15 30 0 1910008640 7184192 4782864
00:54:10 1574 8192000000 10849767840 11287089152 1909150944 18.900 99 71 139 0 1935528880 5843648 20534288
00:54:18 34993 8192000000 10859271952 11320426496 1935665744 19.112 100 35 70 2 1956282080 10686864 9929472
00:55:06 73833 8192000000 10854235792 11338682368 1938958160 19.138 100 10 20 2 1954328096 11868672 3501264
00:56:26 64694 8192000000 10888529472 11356119040 1935998688 19.115 99 15 29 2 1949698016 9678000 4021328
00:57:54 58368 8192000000 10891770928 11371331584 1955842256 19.273 99 23 46 1 1970796528 8551088 6403184
00:59:22 37601 8192000000 10904877280 11370516480 1938783088 19.137 98 24 48 2 1955996080 10577376 6635616
01:00:07 59231 8192000000 10907148096 11375611904 1940309968 19.149 98 20 40 2 1958733440 12815136 5608336
01:01:36 63658 8192000000 10902453504 11370016768 1961641712 19.319 100 12 24 1 1978590720 13227456 3721552
01:02:47 25010 8192000000 10923492016 11369771008 1957415152 19.285 99 43 85 0 1977335488 8200224 11720112
01:03:26 48046 8192000000 10903528784 11374194688 1927735664 19.049 98 31 62 0 1949876960 13389456 8751840
01:04:21 57440 8192000000 10900314448 11373379584 1934605216 19.104 98 21 42 0 1955849520 15308272 5936032
01:05:38 112361 8192000000 10881555968 11357548544 1906934672 18.882 97 16 28 2 1928966160 17991792 4039696
01:07:38 42590 8192000000 10894710176 11345973248 1919397200 18.982 98 33 66 0 1938022192 9767904 8857088
01:08:27 25254 8192000000 10907035744 11355787264 1962383312 19.325 100 42 85 0 1984009824 9526064 12100448
01:08:59 63357 8192000000 10905276496 11375312896 1950321200 19.229 99 34 68 0 1975252832 15656496 9275136
01:10:09 92504 8192000000 10894189280 11363307520 1931577904 19.079 98 17 34 0 1950520064 14373488 4568672
01:11:51 87825 8192000000 10890658512 11344576512 1878920080 18.656 95 23 46 0 1891669952 6427552 6322320
01:13:27 61977 8192000000 10892370960 11359367168 1931125568 19.076 98 34 68 0 1951913264 11677840 9109856
01:14:35 14476 8192000000 10869126624 11349487616 1941988256 19.163 99 23 47 0 1958867072 10907904 5970912
01:14:56 15490 8192000000 10879049072 11339280384 1919702800 18.984 98 19 36 1 1931851632 7347744 4801088
01:15:25 38240 8192000000 10854107120 11337768960 1933396752 19.094 99 35 70 0 1954783232 10931136 10455344
01:16:14 67481 8192000000 10875094880 11356647424 1941888240 19.162 99 8 16 1 1954898816 10544576 2466000
01:17:30 50087 8192000000 10882586064 11363475456 1963908272 19.337 100 7 14 0 1980155296 14196384 2050640
01:18:32 75917 8192000000 10870034480 11354529792 1912354896 18.926 97 25 51 3 1938065088 18403664 7306528
01:20:04 69571 8192000000 10860030880 11314503680 1842205184 18.359 94 20 40 2 1862346896 14566944 5574768
01:21:21 30763 8192000000 10878025696 11347529728 1949697200 19.224 100 19 38 1 1963158816 8008032 5453584
01:22:02 49669 8192000000 10873097104 11341340672 1902116528 18.843 97 26 51 1 1919250640 10159488 6974624
01:23:00 64408 8192000000 10861891904 11334324224 1852885664 18.446 95 28 56 3 1874537776 12835072 8817040
01:24:11 81666 8192000000 10862832720 11330920448 1868957376 18.576 96 19 38 1 1892315440 18194384 5163680
01:25:39 61515 8192000000 10870723952 11340447744 1912989056 18.931 99 17 34 2 1934625456 16348656 5287744
01:26:50 48147 8192000000 9260600064 9517641728 418576528 4.861 22 5 8 2 421696624 2062752 1057344

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 22-03-2021 01:28:32 to 22-03-2021 01:29:03.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 127 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-03-2021 01:29:04 to 22-03-2021 01:29:06.

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          244204
MON$OLDEST_ACTIVE               244205
MON$OLDEST_SNAPSHOT             244205
MON$NEXT_TRANSACTION            244205
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                       2002944
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
--- end of diff output ---

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

22.03.21 01:29:07. 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-03-22 01:29:10 No severe PSQL-related problems occured
22.03.21 01:29:11. End of report.