Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 13.06.2021 16: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 58e1ddde69c44dad93d327777e5becec
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-05-09 08:45
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 4793.92
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 17012752 kB
MemAvailable 31390432 kB
Buffers 0 kB
Cached 14622216 kB
SwapCached 32 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-06-13 16:27:37
DTS_END                         2021-06-13 16:27:37.5770
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/56558
TRN_ID                          238243
ATT_ID                          647
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: 9539.22 20519 1144706
customer order: creation 174.87 344 20984
customer order: refuse 15.49 347 1859
order to supplier: creation 45.93 1256 5512
order to supplier: removal 3.78 98407 454
invoice (draft): creation 46.00 3152 5520
invoice (draft): removal 54.87 789 6584
invoice accept: apply 42.02 16421 5042
invoice accept: cancel 50.03 762 6003
customer reserve: creation 3888.03 161 466563
customer reserve: removal 4911.42 59 589370
realization accept: apply 84.17 185 10100
realization accept: cancel 92.16 113 11059
payment from customer: creation 58.73 118 7047
payment from customer: removal 5.71 107 685
payment to supplier: creation 50.44 138 6053
payment to supplier: removal 3.47 100 416
service: total inventory turnovers 4.88 1137 586
service: total monetary turnovers 6.48 33 777
service: aggregate perf. data 0.73 25361 88
service: refresh index statistics 0.03 261386 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-06-2021 16:28:45 to 13-06-2021 16:28:47.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2640
TEST_TIME 2 3448
TEST_TIME 3 4117
TEST_TIME 4 5523
TEST_TIME 5 5629
TEST_TIME 6 5286
TEST_TIME 7 5000
TEST_TIME 8 4946
TEST_TIME 9 4916
TEST_TIME 10 5401
TEST_TIME 11 5708
TEST_TIME 12 5786
TEST_TIME 13 6100
TEST_TIME 14 6551
TEST_TIME 15 6695
TEST_TIME 16 6856
TEST_TIME 17 7280
TEST_TIME 18 7423
TEST_TIME 19 8465
TEST_TIME 20 8322
TEST_TIME 21 8474
TEST_TIME 22 8990
TEST_TIME 23 9009
TEST_TIME 24 8873
TEST_TIME 25 9128
TEST_TIME 26 9252
TEST_TIME 27 9522
TEST_TIME 28 10945
TEST_TIME 29 11046
TEST_TIME 30 10809
TEST_TIME 31 10814
TEST_TIME 32 10990
TEST_TIME 33 10806
TEST_TIME 34 10666
TEST_TIME 35 10479
TEST_TIME 36 10308
TEST_TIME 37 10511
TEST_TIME 38 10468
TEST_TIME 39 10353
TEST_TIME 40 10341
TEST_TIME 41 10322
TEST_TIME 42 10292
TEST_TIME 43 10207
TEST_TIME 44 10239
TEST_TIME 45 10302
TEST_TIME 46 10333
TEST_TIME 47 10314
TEST_TIME 48 10211
TEST_TIME 49 10029
TEST_TIME 50 9991
TEST_TIME 51 10031
TEST_TIME 52 9906
TEST_TIME 53 9855
TEST_TIME 54 9801
TEST_TIME 55 9772
TEST_TIME 56 9805
TEST_TIME 57 9834
TEST_TIME 58 9760
TEST_TIME 59 9692
TEST_TIME 60 9648
TEST_TIME 61 9550
TEST_TIME 62 9504
TEST_TIME 63 9623
TEST_TIME 64 9546
TEST_TIME 65 9638
TEST_TIME 66 9605
TEST_TIME 67 9613
TEST_TIME 68 9665
TEST_TIME 69 9667
TEST_TIME 70 9714
TEST_TIME 71 9695
TEST_TIME 72 9767
TEST_TIME 73 9823
TEST_TIME 74 9794
TEST_TIME 75 9801
TEST_TIME 76 9822
TEST_TIME 77 9860
TEST_TIME 78 9860
TEST_TIME 79 9762
TEST_TIME 80 9725
TEST_TIME 81 9750
TEST_TIME 82 9712
TEST_TIME 83 9735
TEST_TIME 84 9686
TEST_TIME 85 9636
TEST_TIME 86 9607
TEST_TIME 87 9580
TEST_TIME 88 9499
TEST_TIME 89 9481
TEST_TIME 90 9527
TEST_TIME 91 9504
TEST_TIME 92 9522
TEST_TIME 93 9512
TEST_TIME 94 9525
TEST_TIME 95 9534
TEST_TIME 96 9625
TEST_TIME 97 9650
TEST_TIME 98 9614
TEST_TIME 99 9699
TEST_TIME 100 9710
TEST_TIME 101 9696
TEST_TIME 102 9720
TEST_TIME 103 9749
TEST_TIME 104 9726
TEST_TIME 105 9782
TEST_TIME 106 9710
TEST_TIME 107 9686
TEST_TIME 108 9639
TEST_TIME 109 9644
TEST_TIME 110 9605
TEST_TIME 111 9572
TEST_TIME 112 9542
TEST_TIME 113 9495
TEST_TIME 114 9498
TEST_TIME 115 9492
TEST_TIME 116 9545
TEST_TIME 117 9506
TEST_TIME 118 9507
TEST_TIME 119 9486
TEST_TIME 120 9542

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-06-2021 16:28:49 to 13-06-2021 16:28:52.

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 1577616 1577616 0 0.00 0 21547 6 0 0
doc_list_biud 1577611 1577611 0 0.00 0 65379 28 0 0
sp_add_invoice_to_stock 5126 5042 84 1.63 27 172640 16421 0 84
sp_cancel_adding_invoice 6003 6003 0 0.00 5 67745 763 0 0
sp_cancel_client_order 1859 1859 0 0.00 4 11447 347 0 0
sp_cancel_customer_reserve 589370 589370 0 0.00 1 65382 59 0 0
sp_cancel_pay_from_customer 685 685 0 0.00 2 7666 108 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 3 7628 101 0 0
sp_cancel_supplier_invoice 6592 6584 8 0.12 2 14202 790 0 8
sp_cancel_supplier_order 454 454 0 0.00 4 1181784 98407 0 0
sp_cancel_write_off 11059 11059 0 0.00 1 21548 113 0 0
sp_client_order 20984 20984 0 0.00 3 19333 344 0 0
sp_customer_reserve 466563 466563 0 0.00 0 56114 161 0 0
sp_fill_shopping_cart 32014 32014 0 0.00 1 8969 35 0 0
sp_fill_shopping_cart_clo_res 466556 466556 0 0.00 0 19804 13 0 0
sp_get_clo_for_invoice 5035 5035 0 0.00 0 20634 264 0 0
sp_kill_cost_storno 18163 18163 0 0.00 0 21546 59 0 0
sp_kill_qstorno_ret_qs2qd 1196837 1196837 0 0.00 0 65376 32 0 0
sp_kill_qty_storno 630459 630459 0 0.00 0 65378 69 0 0
sp_lock_selected_doc 21018 21018 0 0.00 0 9703 7 0 0
sp_make_cost_storno 28235 28235 0 0.00 0 15919 56 0 0
sp_multiply_rows_for_pdistr 28231 28231 0 0.00 0 12131 30 0 0
sp_multiply_rows_for_qdistr 20984 20984 0 0.00 0 19327 140 0 0
sp_pay_from_customer 7047 7047 0 0.00 4 10538 118 0 0
sp_pay_to_supplier 6053 6053 0 0.00 4 16072 138 0 0
sp_payment_common 13100 13100 0 0.00 2 10529 31 0 0
sp_qd_handle_on_cancel_clo 1859 1859 0 0.00 0 11441 317 0 0
sp_qd_handle_on_invoice_upd_sts 11034 11034 0 0.00 0 23630 325 0 0
sp_qd_handle_on_reserve_upd_sts 10099 10099 0 0.00 0 17671 65 0 0
sp_reserve_write_off 10100 10100 0 0.00 6 17690 186 0 0
sp_supplier_invoice 5520 5520 0 0.00 7 68494 3153 0 0
sp_supplier_order 5512 5512 0 0.00 5 35108 1256 0 0
srv_aggregate_perf_data 88 88 0 0.00 2592 281540 25361 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 910 158328 31639 0 0
srv_find_qd_qs_mism 1096936 1096936 0 0.00 0 18352 5 0 0
srv_make_invnt_saldo 586 586 0 0.00 47 114139 1137 0 0
srv_make_money_saldo 777 777 0 0.00 1 4783 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 132401 369167 261386 0 0
t$perf-abend:sp_add_invoice_to_stock 84 84 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5042 5042 0 0.00 0 19941 172 0 0
t$perf-norm:sp_cancel_adding_invoice 416 416 0 0.00 1 16592 118 0 0
t$perf-norm:sp_cancel_client_order 1859 1859 0 0.00 0 6110 19 0 0
t$perf-norm:sp_cancel_customer_reserve 697 697 0 0.00 0 4108 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 685 685 0 0.00 0 710 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 320 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 371 371 0 0.00 0 5479 33 0 0
t$perf-norm:sp_cancel_supplier_order 454 454 0 0.00 0 21801 1686 0 0
t$perf-norm:sp_cancel_write_off 990 990 0 0.00 0 2740 7 0 0
t$perf-norm:sp_client_order 20984 20984 0 0.00 0 16648 20 0 0
t$perf-norm:sp_customer_reserve 987 987 0 0.00 0 2003 6 0 0
t$perf-norm:sp_pay_from_customer 7047 7047 0 0.00 0 6875 9 0 0
t$perf-norm:sp_pay_to_supplier 6053 6053 0 0.00 0 9289 14 0 0
t$perf-norm:sp_reserve_write_off 10100 10100 0 0.00 0 7830 12 0 0
t$perf-norm:sp_supplier_invoice 5520 5520 0 0.00 0 14871 20 0 0
t$perf-norm:sp_supplier_order 5512 5512 0 0.00 0 11620 17 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 2668 38 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 89 2 0 0
t$perf-norm:srv_make_invnt_saldo 586 586 0 0.00 0 802 24 0 0
t$perf-norm:srv_make_money_saldo 777 777 0 0.00 0 1144 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 38 13 0 0
v_add_invoice_to_stock 10230 10062 168 1.64 0 8279 17 0 168
v_all_customers 37806 37806 0 0.00 0 13 1 0 0
v_all_suppliers 31002 31002 0 0.00 0 24 1 0 0
v_all_wares 41968 41968 0 0.00 0 41 1 0 0
v_cancel_adding_invoice 832 832 0 0.00 0 1669 10 0 0
v_cancel_client_order 3718 3718 0 0.00 0 3904 7 0 0
v_cancel_customer_prepayment 1370 1370 0 0.00 0 5023 8 0 0
v_cancel_customer_reserve 1394 1394 0 0.00 0 1891 5 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 3728 9 0 0
v_cancel_supplier_invoice 758 742 16 2.11 0 3346 25 0 16
v_cancel_supplier_order 908 908 0 0.00 0 3896 10 0 0
v_cancel_write_off 1980 1980 0 0.00 0 9385 25 0 0
v_max_id_clo_ord 5511 5511 0 0.00 0 1703 2 0 0
v_max_id_clo_res 987 987 0 0.00 0 1455 11 0 0
v_max_id_ord_sup 5519 5519 0 0.00 0 6013 4 0 0
v_max_non_paid_invoice 1582 1582 0 0.00 0 142 2 0 0
v_max_non_paid_realizn 3800 3800 0 0.00 0 3060 6 0 0
v_min_id_clo_ord 5511 5511 0 0.00 0 7282 12 0 0
v_min_id_clo_res 987 987 0 0.00 0 7764 12 0 0
v_min_id_ord_sup 5519 5519 0 0.00 0 4158 4 0 0
v_min_non_paid_invoice 6053 6053 0 0.00 0 9664 17 0 0
v_min_non_paid_realizn 7047 7047 0 0.00 0 10524 19 0 0
v_our_firm 10656 10656 0 0.00 0 23 1 0 0
v_reserve_write_off 20198 20198 0 0.00 0 3865 6 0 0
x_lock_depdocs_on_canc_invoice 12216 12216 0 0.00 0 19879 128 0 0
x_lock_depdocs_on_canc_sup_ord 454 454 0 0.00 0 27417 409 0 0
x_make_qstorno_1000_1200 5512 5512 0 0.00 2 35092 1171 0 0
x_make_qstorno_1200_2000 5520 5520 0 0.00 3 68482 3037 0 0
x_make_qstorno_2100_3300 466563 466563 0 0.00 0 56112 146 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-06-2021 16:28:53 to 13-06-2021 16:28:57.

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
13:57:41 1 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
13:57:47 21238 8192000000 10279057632 10585956352 969640112 10.583 75 52 105 0 989506624 2616064 17250448
13:58:17 44520 8192000000 10368926688 10687320064 1409620112 14.681 100 89 178 0 1443898256 5751360 28526784
13:59:11 22307 8192000000 10390306768 10716798976 1446481392 15.007 100 87 175 2 1482167696 7326112 28360192
13:59:53 28672 8192000000 10420964544 10749640704 1473216864 15.242 100 87 174 0 1510394672 8783456 28394352
14:00:30 21133 8192000000 10442384176 10773606400 1492772288 15.413 100 87 174 1 1529963472 9383728 27807456
14:01:03 24177 8192000000 10462846192 10798665728 1514631296 15.604 100 92 184 3 1554040800 10131648 29277856
14:01:41 22458 8192000000 10479841856 10824134656 1529521808 15.733 100 82 164 0 1566077872 10588784 25967280
14:02:22 12805 8192000000 10511035536 10858606592 1565504816 16.044 100 79 158 1 1601446272 11239600 24701856
14:02:49 8155 8192000000 10541331776 10895745024 1599817312 16.338 100 80 160 1 1635063872 11236576 24009984
14:03:05 12841 8192000000 10560764176 10919510016 1616594496 16.481 100 78 156 2 1651673344 11262416 23816432
14:03:28 13038 8192000000 10574191072 10938523648 1638103344 16.664 100 76 152 2 1672520064 11836016 22580704
14:03:57 9634 8192000000 10609228544 10974588928 1661943808 16.865 100 69 138 2 1693735248 11358480 20432960
14:04:15 7338 8192000000 10625902576 10994634752 1684883488 17.058 100 77 154 0 1720229472 12116128 23229856
14:04:30 12841 8192000000 10637875696 11015393280 1701735584 17.200 100 75 151 0 1735300224 12226800 21337840
14:04:50 6418 8192000000 10666236288 11036426240 1721262448 17.363 100 84 167 0 1758193680 12624192 24307040
14:05:04 4597 8192000000 10673613888 11045502976 1731494032 17.448 100 86 171 2 1770239424 14350896 24394496
14:05:16 8430 8192000000 10676486352 11053277184 1736717328 17.491 100 71 142 2 1774081968 17573168 19791472
14:05:33 4300 8192000000 10680866176 11060142080 1747086944 17.577 100 80 161 0 1783345584 13654912 22603728
14:05:43 5488 8192000000 10708927024 11083403264 1765912416 17.733 100 86 171 1 1803390256 14095408 23382432
14:05:56 3992 8192000000 10711354704 11090460672 1770200288 17.769 100 83 166 0 1808451536 15166624 23084624
14:06:06 3340 8192000000 10711022016 11092762624 1774736336 17.806 100 76 152 1 1809963056 13761040 21465680
14:06:17 2654 8192000000 10717696992 11101220864 1788874288 17.923 100 81 160 1 1823033952 11281040 22878624
14:06:26 2983 8192000000 10736258560 11116912640 1796064048 17.982 100 78 156 2 1829561392 11082880 22414464
14:06:43 4714 8192000000 10745620064 11132891136 1804926272 18.054 100 77 153 2 1837819024 11593600 21299152
14:06:54 2699 8192000000 10765143776 11148484608 1824152752 18.212 100 89 179 1 1861548016 11780576 25614688
14:07:04 2768 8192000000 10774074672 11157209088 1830723088 18.265 100 89 178 2 1867096544 12019952 24353504
14:07:13 2285 8192000000 10774390528 11158257664 1835278944 18.302 100 86 171 3 1871352304 12032800 24040560
14:07:22 1990 8192000000 10782653248 11167956992 1843431808 18.369 100 94 188 0 1884061904 12414336 28215760
14:07:30 1772 8192000000 10785380608 11170861056 1847624304 18.403 100 85 170 1 1883615440 12271888 23719248
14:07:38 2150 8192000000 10793872320 11181096960 1851627536 18.435 100 92 180 1 1889881840 13109248 25145056
14:07:46 1709 8192000000 10800193440 11190210560 1855200528 18.464 100 85 168 0 1892372576 13210368 23961680
14:07:55 1635 8192000000 10808036864 11194519552 1859369744 18.498 100 91 184 3 1898580016 12576640 26633632
14:08:03 2566 8192000000 10808173248 11195559936 1861960720 18.519 100 93 189 0 1901669872 12525744 27183408
14:08:12 2011 8192000000 10813706992 11201028096 1864702336 18.541 100 90 180 0 1903567520 13667280 25197904
14:08:20 1704 8192000000 10813339264 11199995904 1869980032 18.584 100 95 191 1 1910694704 14267040 26447632
14:08:28 1338 8192000000 10816838368 11203461120 1868377600 18.571 100 94 188 3 1908117936 13055616 26684720
14:08:35 1588 8192000000 10810520064 11202138112 1872627984 18.606 100 94 190 1 1912173440 12874544 26670912
14:08:43 42152 8192000000 10794558256 11200069632 1864806688 18.542 100 61 122 1 1892980016 10619056 17554272
14:09:32 4295 8192000000 10803334608 11210485760 1871865008 18.599 100 67 134 2 1902378656 11389072 19124576
14:09:44 4282 8192000000 10797887696 11211440128 1871091120 18.593 100 61 123 1 1899890032 11940928 16857984
14:09:55 5443 8192000000 10796253536 11209424896 1874283312 18.619 100 49 94 3 1896459840 9297856 12878672
14:10:06 5851 8192000000 10786649712 11207147520 1871827904 18.599 100 36 72 2 1890824928 8946784 10050240
14:10:20 3729 8192000000 10792070128 11214987264 1877254608 18.643 100 35 70 2 1895241888 8091088 9896192
14:10:30 7702 8192000000 10787277440 11214708736 1879643696 18.662 100 31 63 1 1895957920 7571424 8742800
14:10:47 6570 8192000000 10800314176 11222900736 1886255248 18.716 100 32 64 0 1903207776 8113168 8839360
14:11:02 7948 8192000000 10789355328 11221790720 1884393536 18.701 100 21 42 3 1897599024 6497408 6708080
14:11:17 13874 8192000000 10795456608 11222335488 1883622064 18.694 100 16 31 3 1893782832 5573008 4587760
14:11:40 19084 8192000000 10806615920 11228418048 1891703280 18.760 100 39 78 1 1909793952 6444928 11645744
14:12:08 71373 8192000000 10803000400 11235221504 1888374624 18.733 100 21 42 1 1898679120 4678128 5626368
14:13:25 8690 8192000000 10804496960 11233705984 1887098016 18.722 100 23 46 2 1899714848 6756400 5860432
14:13:40 10332 8192000000 10801310832 11237044224 1889056112 18.738 100 20 40 1 1899566320 5415072 5095136
14:13:58 4748 8192000000 10819992736 11243372544 1895880080 18.793 100 36 70 1 1913129728 7809904 9439744
14:14:13 4705 8192000000 10818130048 11240878080 1896227120 18.796 100 41 80 0 1915471360 7796656 11447584
14:14:26 7917 8192000000 10794891088 11239383040 1893643536 18.775 100 27 54 0 1907935696 6425824 7866336
14:14:41 9964 8192000000 10804942656 11239309312 1892360352 18.765 100 13 26 1 1901666592 5286160 4020080
14:14:59 6691 8192000000 10809914864 11240509440 1900746048 18.832 100 48 95 2 1921097072 6361792 13989232
14:15:12 7419 8192000000 10817109520 11248488448 1896349808 18.797 100 19 38 2 1908159248 6482560 5326880
14:15:26 5529 8192000000 10824331520 11251720192 1901665088 18.840 100 35 70 0 1918123408 6349072 10109248
14:15:40 13016 8192000000 10808970576 11238846464 1878443072 18.653 99 16 32 1 1889031024 6051136 4536816
14:16:02 7732 8192000000 10806438176 11244941312 1896679504 18.800 100 15 30 3 1906818672 5667968 4471200
14:16:17 11284 8192000000 10801705872 11236835328 1876024832 18.633 99 14 28 2 1885619040 5739856 3854352
14:16:37 6179 8192000000 10809005616 11247517696 1898498976 18.814 100 20 39 2 1910801456 5834576 6467904
14:16:52 74293 8192000000 10783399856 11218018304 1770045904 17.767 93 29 57 2 1783922112 4760528 9115680
14:18:14 11250 8192000000 10773535920 11199954944 1802663376 18.036 96 23 44 1 1815200800 5837520 6699904
14:18:32 8067 8192000000 10757747280 11171639296 1816866352 18.152 98 33 65 4 1832704512 6340624 9497536
14:18:48 7476 8192000000 10764529984 11180711936 1828793312 18.249 99 39 78 2 1847635296 7117936 11724048
14:19:01 6491 8192000000 10759044432 11181182976 1816457568 18.149 98 29 57 2 1831435520 6587152 8390800
14:19:17 4568 8192000000 10722847536 11144318976 1777948368 17.833 97 21 43 2 1788977392 5312992 5716032
14:19:29 6972 8192000000 10730867792 11148251136 1780657296 17.855 98 25 50 0 1793648192 5486320 7504576
14:19:43 7253 8192000000 10731653520 11157311488 1810656112 18.101 99 40 80 0 1828428272 5730240 12041920
14:19:58 5621 8192000000 10728675984 11151388672 1775283216 17.811 97 28 56 0 1790034864 7013824 7737824
14:20:10 8289 8192000000 10730396832 11152785408 1809318032 18.090 99 22 44 0 1822063760 6771984 5973744
14:20:25 6075 8192000000 10737703872 11158147072 1793994656 17.965 98 32 64 2 1808261328 5308176 8958496
14:20:37 8103 8192000000 10727977312 11151278080 1801856256 18.029 99 21 42 1 1814071648 5492944 6722448
14:20:52 11517 8192000000 10703038144 11124273152 1740057568 17.519 96 15 30 0 1750050384 5662336 4330480
14:21:10 10830 8192000000 10710744736 11131543552 1749661904 17.599 97 26 52 2 1768282704 10779232 7841568
14:21:30 49100 8192000000 10704785376 11116756992 1717158400 17.329 95 25 50 2 1729250992 4684816 7407776
14:22:25 20512 8192000000 10707244576 11129536512 1735224816 17.479 96 23 44 1 1747875024 5521696 7128512
14:22:55 9346 8192000000 10756889728 11176042496 1821012400 18.186 100 33 66 1 1836613408 6778992 8822016
14:23:11 3453 8192000000 10753967632 11160653824 1791076928 17.941 98 48 96 0 1813389856 8748528 13564400
14:23:22 5874 8192000000 10741372368 11167817728 1827599936 18.240 100 37 74 1 1846155744 8035424 10520384
14:23:35 6963 8192000000 10761230848 11169026048 1830484416 18.263 100 40 81 2 1848304624 6613840 11206368
14:23:50 6778 8192000000 10735628704 11159441408 1807377904 18.074 99 19 37 1 1818404496 5535104 5491488
14:24:03 4937 8192000000 10748774768 11176583168 1839169776 18.334 100 30 60 1 1854090848 5720160 9200912
14:24:14 8348 8192000000 10767177344 11194687488 1848397136 18.409 100 26 52 0 1861244288 5482480 7364672
14:24:29 6846 8192000000 10768668432 11197825024 1851259360 18.432 100 14 28 1 1860726720 5340816 4126544
14:24:43 8783 8192000000 10770762256 11200913408 1857708576 18.485 100 22 43 2 1869459824 5665072 6086176
14:24:58 9777 8192000000 10775341296 11205111808 1861160256 18.513 100 14 28 1 1870496528 5290464 4045808
14:25:15 11657 8192000000 10776086016 11209052160 1864567712 18.540 100 21 42 1 1876667024 6041120 6058192
14:25:35 8961 8192000000 10784136608 11207913472 1865007504 18.544 100 18 36 3 1880574048 9398880 6167664
14:25:50 9691 8192000000 10778375264 11215749120 1870488368 18.588 100 18 36 0 1882386752 5716992 6181392
14:26:07 71934 8192000000 10795611664 11223044096 1874680656 18.622 100 23 44 2 1886634768 5541056 6413056
14:27:26 7107 8192000000 10800242752 11231322112 1890357664 18.749 100 22 40 1 1901328688 5221520 5749504
14:27:44 25460 8192000000 10836208672 11255160832 1903596240 18.855 100 39 78 1 1921154576 6354912 11203424
14:28:17 27612 8192000000 10828659888 11261063168 1913067712 18.931 100 38 76 2 1931302320 7052800 11181808
14:29:02 16993 8192000000 10841066864 11273785344 1924354432 19.022 100 47 88 1 1944730720 7811056 12565232
14:29:38 33036 8192000000 10855134480 11292377088 1932497856 19.087 100 41 82 2 1953735872 9112304 12125712
14:30:24 11298 8192000000 10868404224 11297660928 1940730544 19.153 100 44 88 3 1962318144 9389392 12198208
14:30:44 9115 8192000000 10885038672 11305697280 1947387584 19.206 100 61 120 1 1979187536 14033712 17766240
14:31:04 2993 8192000000 10900462096 11316150272 1953291296 19.253 100 72 144 0 1986162960 12241280 20630384
14:31:16 6215 8192000000 10896711328 11321032704 1954208224 19.260 100 56 112 0 1986495568 16890608 15396736
14:31:47 13985 8192000000 10888584896 11324682240 1958144800 19.291 100 34 68 0 1981218592 13147456 9926336
14:32:10 11936 8192000000 10899006256 11332915200 1966860144 19.361 100 43 85 1 1991963856 11233744 13869968
14:32:34 8183 8192000000 10911117456 11344900096 1976361664 19.436 100 49 96 1 2001775984 10976544 14437776
14:32:48 31722 8192000000 10907133440 11344830464 1978122864 19.450 100 39 78 2 2001565936 12049232 11393840
14:33:28 15002 8192000000 10916615040 11355762688 1984401232 19.500 100 46 90 3 2011596880 14455328 12740320
14:34:17 14026 8192000000 10929293840 11366551552 1992283872 19.562 100 42 84 1 2021773728 17425776 12064080
14:34:40 31574 8192000000 10926854752 11369357312 1977035376 19.441 99 41 82 3 2009476704 20593600 11847728
14:35:34 9784 8192000000 10945428800 11379961856 1999773376 19.621 100 44 87 0 2033125040 20054160 13297504
14:35:52 14029 8192000000 10957650688 11391324160 2006796800 19.676 100 58 116 2 2045444288 21539600 17107888
14:36:15 3452 8192000000 10955681040 11393003520 2007825376 19.684 100 58 113 2 2048603984 23972768 16805840
14:36:28 5378 8192000000 10965297504 11401342976 2016073104 19.749 100 49 98 0 2055589152 24714480 14801568
14:36:41 4051 8192000000 10959818080 11397857280 2011390400 19.712 100 51 102 4 2052425056 25829920 15204736
14:36:54 3895 8192000000 10973662224 11404472320 2015926352 19.748 100 70 137 0 2063950960 26873552 21151056
14:37:05 3724 8192000000 10987172480 11414175744 2020477968 19.784 100 74 147 1 2071705936 27873600 23354368
14:37:17 4605 8192000000 10989168592 11417100288 2022902400 19.803 100 63 124 3 2070054656 28170544 18981712
14:37:30 9649 8192000000 10986745376 11415846912 2020296160 19.782 100 68 135 2 2072273904 31849680 20128064
14:37:48 5579 8192000000 10995202160 11425681408 2026233568 19.829 100 66 131 1 2077508224 30613968 20660688
14:38:01 5897 8192000000 10986898912 11417829376 2025458608 19.823 100 62 124 1 2070981920 27039024 18484288
14:38:14 7162 8192000000 10983778464 11417600000 2029004560 19.851 100 63 125 3 2074730816 26832000 18894256
14:38:27 2841 8192000000 10987972928 11410509824 2018090416 19.765 99 78 156 2 2070721456 28718560 23912480
14:38:37 3314 8192000000 11005157024 11429986304 2036089424 19.906 100 70 140 0 2086864640 29103952 21671264
14:38:47 6535 8192000000 11007178992 11437801472 2037051280 19.914 100 73 146 1 2093540448 34989872 21499296
14:39:02 4321 8192000000 11003412096 11436367872 2039674032 19.934 100 77 155 1 2094608880 31745616 23189232
14:39:15 5772 8192000000 11011957968 11440361472 2037966288 19.921 100 78 154 4 2093360784 31683872 23710624
14:39:30 15322 8192000000 10992055456 11436503040 2024288256 19.814 99 59 116 2 2075080336 32093488 18698592
14:39:53 5720 8192000000 10992544208 11430309888 2027867904 19.842 100 69 138 2 2085242176 35199488 22174784
14:40:08 2561 8192000000 11008158960 11433668608 2015060736 19.741 99 83 164 1 2077524896 36396160 26068000
14:40:19 5392 8192000000 11011774544 11445420032 2034426176 19.893 100 70 140 1 2094587584 37505792 22655616
14:40:32 5606 8192000000 11027491968 11449012224 2044983392 19.976 100 87 172 1 2107012240 36390864 25637984
14:40:46 2299 8192000000 11019656736 11443474432 2038763664 19.927 100 87 168 1 2106034864 41376432 25894768
14:40:55 2772 8192000000 11018297232 11447300096 2041156080 19.946 100 91 179 1 2107107168 38211712 27739376
14:41:05 3784 8192000000 11008597552 11437752320 2034002960 19.890 100 86 172 0 2100091616 39123040 26965616
14:41:19 2897 8192000000 11008216720 11434053632 2032146608 19.875 100 88 174 3 2091804368 34415744 25242016
14:41:29 4407 8192000000 11014959584 11439316992 2038453648 19.925 100 87 172 1 2098610928 34836352 25320928
14:41:42 5304 8192000000 11021385920 11440947200 2036334480 19.908 100 74 148 0 2094129184 35843184 21951520
14:41:55 2770 8192000000 11024317088 11450298368 2042612576 19.957 100 81 160 1 2102765872 35775312 24377984
14:42:07 909 8192000000 11013123248 11432804352 2030471088 19.862 100 84 167 2 2092414912 35832128 26111696
14:42:16 2441 8192000000 10988951408 11413745664 2008787120 19.692 99 79 158 2 2070060960 36737856 24535984
14:42:29 2949 8192000000 11013369568 11432787968 2028703600 19.848 100 91 180 1 2094324464 37333600 28287264
14:42:39 10459 8192000000 10987855696 11422466048 2015661616 19.746 100 79 157 0 2077963616 37750128 24551872
14:42:58 8125 8192000000 10986161936 11419709440 2010558352 19.706 100 67 134 0 2070540528 39218336 20763840
14:43:16 4159 8192000000 10996546400 11430576128 2017568176 19.761 100 70 140 2 2084225552 44742800 21914576
14:43:27 5695 8192000000 10987054720 11413344256 2004392224 19.657 99 66 130 2 2065829536 41028128 20409184
14:43:40 4009 8192000000 10984417088 11402862592 1997630656 19.604 100 85 169 0 2066683504 42417632 26635216
14:43:53 2181 8192000000 10998589232 11414351872 2008844544 19.692 100 93 187 0 2079061072 42608448 27608080
14:44:02 6786 8192000000 10980659136 11421462528 2007835968 19.684 100 58 116 0 2071247296 44109904 19301424
14:44:16 10541 8192000000 10973320912 11424575488 2009161776 19.695 100 49 98 1 2063678800 38544368 15972656
14:44:35 4837 8192000000 10971137648 11411734528 2000339984 19.625 100 44 88 0 2057029824 41795920 14893920
14:44:49 10730 8192000000 10926289776 11360468992 1948367072 19.213 99 47 94 2 2008325744 44189072 15769600
14:45:10 3989 8192000000 10949667552 11376087040 1953462720 19.254 99 55 110 2 2015796032 44899040 17434272
14:45:21 2140 8192000000 10965858736 11385389056 1977807920 19.447 100 83 165 1 2050630752 46867552 25955280
14:45:31 3793 8192000000 10978700384 11398950912 1986102128 19.513 100 81 163 2 2059101904 47411680 25588096
14:45:42 3914 8192000000 10988058160 11411251200 1987699072 19.526 100 74 149 0 2060187184 49088224 23399888
14:45:56 2591 8192000000 10979680352 11397431296 1967747920 19.368 99 88 175 0 2049261920 53380912 28133088
14:46:09 2277 8192000000 10990471264 11407085568 1991319888 19.554 100 77 154 1 2066254816 51632656 23302272
14:46:20 2641 8192000000 10985305712 11406622720 1978133776 19.450 99 78 156 0 2052797488 49846048 24817664
14:46:30 10604 8192000000 10969480272 11416268800 1993061888 19.568 100 47 94 0 2059805600 51685408 15058304
14:46:54 10786 8192000000 10960933120 11411685376 1977456720 19.445 99 37 74 1 2033871232 44020304 12394208
14:47:11 8772 8192000000 10930975152 11363229696 1926248960 19.037 97 46 91 1 1985770608 44863216 14658432
14:47:27 6273 8192000000 10981110624 11400253440 1982162480 19.482 100 67 131 2 2047743168 46058528 19522160
14:47:41 2300 8192000000 10996909440 11415658496 1994591728 19.580 100 89 176 2 2071679952 50009888 27078336
14:47:52 6678 8192000000 10972297568 11408281600 1988131984 19.529 100 64 128 1 2059687840 51558672 19997184
14:48:13 8824 8192000000 10945177760 11383365632 1940697024 19.152 98 40 80 2 2004618656 50763696 13157936
14:48:30 4183 8192000000 10977509344 11400265728 1975930800 19.432 100 64 125 1 2048678816 52073360 20674656
14:48:43 12093 8192000000 10950548320 11395801088 1974466592 19.421 100 49 98 0 2046687072 55682048 16538432
14:49:08 8937 8192000000 10941111504 11379675136 1954344640 19.261 100 40 80 1 2023921744 55865584 13711520
14:49:32 6973 8192000000 10942954272 11373432832 1952051040 19.243 99 47 96 0 2016862992 48303968 16507984
14:49:46 7191 8192000000 10937101824 11378057216 1946298704 19.197 99 48 96 0 2011475216 49865024 15311488
14:50:20 12702 8192000000 10945875280 11389689856 1974648928 19.422 100 28 56 2 2024444032 40488896 9306208
14:50:46 12732 8192000000 10929396032 11374227456 1960740256 19.312 100 33 66 1 2015113536 43385680 10987600
14:51:09 13882 8192000000 10944961440 11383410688 1952574224 19.247 99 50 100 3 2019831840 50761984 16495632
14:51:30 15358 8192000000 10939755472 11383050240 1949104880 19.219 99 41 82 0 2010759936 48336304 13318752
14:51:54 15582 8192000000 10934693264 11396116480 1961910928 19.321 100 32 64 0 2025174096 52221600 11041568
14:52:24 20897 8192000000 10928699536 11380985856 1956980368 19.282 100 31 62 0 2017891456 50564992 10346096
14:52:51 21769 8192000000 10913675072 11363876864 1932480096 19.087 99 26 52 2 1992971024 51249696 9241232
14:53:25 28132 8192000000 10899046544 11356835840 1919548240 18.983 99 24 48 1 1988641728 59755840 9337648
14:54:00 10955 8192000000 10916602784 11366567936 1933299840 19.093 100 31 61 3 2000220208 55768144 11152224
14:54:19 23978 8192000000 10908102320 11370659840 1905965312 18.874 99 21 42 0 1976009104 61303040 8740752
14:54:51 42138 8192000000 10898082144 11365253120 1868110416 18.569 97 25 50 0 1942272416 65359232 8802768
14:55:39 36758 8192000000 10867460320 11309182976 1888527952 18.734 98 23 46 0 1907022832 11527632 6967248
14:56:32 51768 8192000000 10875746992 11326476288 1926559104 19.039 100 27 54 2 1947857536 13248592 8049840
14:57:43 31738 8192000000 10896926752 11343216640 1951704176 19.240 100 42 82 4 1978066592 14254560 12107856
14:58:31 31461 8192000000 10882937136 11352342528 1949194032 19.220 100 20 40 3 1970492864 15751200 5547632
14:59:09 27426 8192000000 10879890160 11349303296 1930490352 19.071 99 8 16 0 1950375680 17576416 2308912
14:59:56 75487 8192000000 10864710288 11341852672 1919964768 18.987 99 5 10 0 1935488080 14769600 753712
15:01:27 74264 8192000000 10880669904 11330961408 1869688256 18.582 96 24 45 2 1882567184 7071664 5807264
15:02:48 64908 8192000000 10883090688 11344818176 1948536560 19.215 100 18 36 1 1969291408 16090624 4664224
15:04:09 119877 8192000000 10894620704 11367563264 1938336480 19.133 99 7 14 2 1961596320 21135056 2124784
15:06:23 103858 8192000000 10896931984 11347243008 1912027968 18.923 97 15 30 0 1929243104 13142352 4072784
15:08:14 58149 8192000000 10882722144 11346608128 1921275520 18.997 98 9 18 0 1931440320 7857760 2307040
15:09:21 36630 8192000000 10885600944 11346137088 1920540384 18.991 98 16 31 2 1931844624 6843616 4460624
15:10:08 65217 8192000000 10897647408 11363909632 1941506800 19.159 99 10 20 0 1957489104 13478784 2503520
15:11:20 90093 8192000000 10907862032 11374325760 1966836832 19.360 100 14 25 2 1984224320 13794912 3592576
15:12:57 84611 8192000000 10920394288 11393564672 1975877072 19.432 100 8 16 1 1993058304 15007152 2174080
15:15:04 158327 8192000000 10937712816 11406061568 1994528256 19.580 100 20 40 1 2011382736 10944784 5909696
15:17:50 103958 8192000000 10943276192 11400945664 2001605856 19.635 100 23 46 0 2025671328 17436128 6629344
15:19:41 19085 8192000000 10930959392 11389378560 1989014576 19.536 99 52 103 2 2009551680 6099136 14437968
15:20:09 12510 8192000000 10934259536 11387969536 1983876288 19.495 99 39 78 0 2003321008 7512816 11931904
15:20:31 26521 8192000000 10909748976 11378769920 1957476784 19.286 98 27 54 2 1973587264 8482000 7628480
15:21:10 25221 8192000000 10933395824 11393392640 1988843584 19.535 100 27 55 1 2003109840 6530512 7735744
15:21:44 12706 8192000000 10929826480 11392458752 1982287952 19.483 99 40 80 1 2003326224 8847616 12190656
15:22:03 14981 8192000000 10925046528 11391696896 1984921808 19.504 99 45 90 2 2007184128 9318480 12943840
15:22:29 50886 8192000000 10951413856 11413671936 2004627664 19.659 100 45 88 2 2029156432 10953440 13575328
15:23:30 27247 8192000000 10947344256 11419111424 1993420336 19.571 99 50 97 0 2018857632 11928448 13508848
15:24:06 40223 8192000000 10917312640 11382394880 1957672304 19.288 98 20 40 1 1974553760 10878960 6002496
15:25:45 39753 8192000000 10907189008 11378532352 1947037408 19.203 98 8 16 1 1958094208 8943856 2112944
15:26:31 43295 8192000000 10906884672 11374510080 1951232128 19.236 98 12 24 1 1961363968 6733104 3398736
15:27:20 15449 8192000000 10885320864 11359059968 1945983712 19.194 98 16 32 0 1959886688 9174224 4728752
15:27:54 39605 8192000000 10892101776 11358306304 1953354144 19.253 99 14 29 1 1964712704 7690864 3667696
15:28:40 63553 8192000000 10892376816 11371749376 1944799936 19.185 98 23 46 0 1963253200 11668640 6784624
15:30:36 32968 8192000000 10906074416 11389239296 1968612256 19.374 99 11 23 0 1980254144 8930208 2711680
15:31:23 21873 8192000000 10902746320 11361280000 1944976592 19.186 98 25 48 3 1966199232 13513264 7709376
15:31:56 70942 8192000000 10909460016 11398152192 1968412064 19.373 99 13 26 0 1983523344 11673296 3437984
15:33:19 44078 8192000000 10883143856 11359744000 1906433904 18.878 96 18 36 1 1919723280 7806960 5482416
15:34:12 19554 8192000000 10866458160 11335335936 1899476336 18.822 97 24 48 1 1912948352 7024304 6447712
15:34:40 38579 8192000000 10891692464 11351244800 1918136240 18.972 98 23 46 0 1938220848 13874432 6210176
15:35:29 61616 8192000000 10871604720 11338477568 1872817728 18.607 96 16 31 2 1892979904 15483328 4678848
15:36:44 34902 8192000000 10871295344 11332427776 1899489200 18.822 98 23 46 0 1916148592 9865152 6794240
15:37:33 63616 8192000000 10877007552 11343646720 1901235792 18.836 98 19 38 0 1915611616 9014528 5361296
15:38:43 40213 8192000000 10871020656 11340513280 1898616592 18.815 98 25 50 1 1921615328 15945200 7053536
15:39:30 42469 8192000000 10851048912 11306766336 1852536144 18.443 96 10 20 2 1871046432 15245520 3264768
15:40:21 84816 8192000000 10842415552 11310125056 1820662240 18.183 94 20 40 0 1839861712 13819744 5379728
15:41:53 18357 8192000000 10882517328 11327606784 1931076576 19.075 100 42 83 3 1953608912 11033024 11499312
15:42:23 36730 8192000000 10872055280 11325345792 1880524400 18.669 97 39 78 1 1902484032 11222480 10737152
15:43:10 124877 8192000000 10867439408 11342323712 1836248992 18.310 95 8 16 0 1851888000 13627904 2011104
15:45:21 126408 8192000000 10879149040 11340361728 1907512480 18.887 98 24 48 0 1922906992 8530480 6864032
15:47:59 94900 8192000000 10861025024 11354894336 1927787328 19.049 99 10 20 0 1950794464 20398672 2608464
15:49:48 29731 8192000000 10867596848 11333894144 1914716128 18.944 99 25 50 0 1931272208 9153312 7402768
15:50:33 68289 8192000000 10849581792 11328487424 1902512240 18.846 98 10 20 1 1914907632 9307952 3087440
15:51:56 37730 8192000000 10849314672 11326582784 1919379552 18.982 99 23 45 0 1933970864 7750736 6840576
15:52:41 62407 8192000000 10857522880 11332853760 1920164768 18.988 99 12 24 0 1931996832 8428608 3403456
15:53:51 71060 8192000000 10857861680 11340165120 1905471696 18.870 98 11 22 1 1918217792 9520928 3225168
15:55:08 80727 8192000000 10859827808 11334750208 1919938960 18.986 99 12 23 0 1940214384 16566608 3708816
15:56:38 56641 8192000000 10867221392 11354198016 1943459904 19.174 100 19 38 0 1966448080 17818160 5170016
15:57:41 60241 8192000000 10857549776 11338379264 1888458064 18.733 97 12 24 1 1901515056 10069504 2987488
15:58:48 66451 8192000000 10882615248 11357368320 1942429088 19.166 99 15 32 0 1955602048 9367840 3805120
16:00:31 32541 8192000000 10912558048 11385012224 1981489808 19.476 100 24 48 1 1995619920 7093552 7036560
16:01:16 50641 8192000000 10915612992 11396984832 1967061408 19.362 99 21 42 2 1985053888 11975984 6016496
16:02:19 65452 8192000000 10917067328 11396763648 1964382944 19.341 99 15 29 2 1983124848 14376000 4365904
16:03:33 104580 8192000000 10923615168 11417968640 1982423248 19.484 100 11 22 1 2007627440 22130768 3073424
16:05:24 92264 8192000000 10912117840 11390537728 1907849904 18.889 96 9 18 0 1933598800 23468960 2279936
16:07:25 27753 8192000000 10913311744 11388624896 1962401840 19.325 99 23 45 1 1978965968 9572496 6991632
16:07:58 42793 8192000000 10922547840 11387994112 1969387136 19.381 99 43 84 2 1992876128 11588720 11900272
16:08:49 15021 8192000000 10919045744 11375263744 1943369760 19.174 98 33 66 1 1961481936 9699712 8412464
16:09:14 40085 8192000000 10914034736 11392520192 1964407568 19.341 99 29 58 1 1984418752 12033808 7977376
16:10:29 91275 8192000000 10914778144 11375177728 1923767392 19.017 97 33 66 0 1944881136 11859056 9254688
16:12:25 82026 8192000000 10905779200 11401129984 1977652864 19.446 100 25 50 1 2009414512 24791936 6969712
16:13:55 73509 8192000000 10910650688 11380191232 1975656592 19.430 100 23 46 1 1996660640 14386656 6617392
16:15:28 20388 8192000000 10894674064 11363946496 1945975984 19.194 98 21 42 0 1959374432 7611728 5786720
16:15:54 45328 8192000000 10894018272 11380154368 1974740496 19.423 100 26 52 0 1991734992 9147728 7846768
16:17:02 50365 8192000000 10889052864 11377188864 1973143056 19.410 100 8 16 1 1984806848 9564048 2099744
16:18:04 64357 8192000000 10903389232 11384573952 1945340320 19.189 98 12 22 0 1958311152 9974656 2996176
16:19:17 82219 8192000000 10881722608 11359014912 1903222384 18.852 96 17 34 0 1920576080 12082720 5270976
16:20:46 93425 8192000000 10877276208 11366887424 1916497376 18.959 97 16 33 0 1932071040 10538192 5035472
16:23:53 67915 8192000000 10862621488 11338723328 1902424448 18.846 97 9 18 0 1917544128 12393328 2726352
16:25:09 49398 8192000000 10871201808 11349401600 1860099808 18.504 95 15 31 0 1877876000 12941872 4834320
16:26:25 68295 8192000000 10862930288 11342135296 1892414256 18.765 97 18 36 1 1913149280 15401664 5333360

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 13-06-2021 16:28:59 to 13-06-2021 16:29:31.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 84 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-06-2021 16:29:31 to 13-06-2021 16:29:33.

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          237626
MON$OLDEST_ACTIVE               238419
MON$OLDEST_SNAPSHOT             238419
MON$NEXT_TRANSACTION            238419
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                       2052064
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.33473 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33473 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33473 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33473 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 ---
:78: 
:79: mscs-test-161.budzdorov.ru    Sun Jun 13 16:27:47 2021
:80:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:81: 
:82: 
:83: mscs-test-161.budzdorov.ru    Sun Jun 13 16:27:51 2021
:84:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:85: 
:86: 
:87: mscs-test-161.budzdorov.ru    Sun Jun 13 16:27:51 2021
:88:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:89: 
--- end of diff output ---

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

13.06.21 16:29:34. 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-06-13 16:29:37 No severe PSQL-related problems occured
13.06.21 16:29:38. End of report.