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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17239688 kB
MemAvailable 31392496 kB
Buffers 0 kB
Cached 14402420 kB
SwapCached 16 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 01:27:41
DTS_END                         2021-06-13 01:27:41.0170
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47060
TRN_ID                          241759
ATT_ID                          661
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: 9573.25 20465 1148790
customer order: creation 172.97 363 20756
customer order: refuse 14.13 350 1695
order to supplier: creation 45.58 1266 5469
order to supplier: removal 3.61 106876 433
invoice (draft): creation 45.07 3276 5408
invoice (draft): removal 55.89 921 6707
invoice accept: apply 42.36 18067 5083
invoice accept: cancel 50.33 798 6039
customer reserve: creation 3913.70 179 469644
customer reserve: removal 4915.23 59 589827
realization accept: apply 83.02 178 9962
realization accept: cancel 100.75 116 12090
payment from customer: creation 59.31 116 7117
payment from customer: removal 5.78 77 694
payment to supplier: creation 49.72 117 5966
payment to supplier: removal 3.40 62 408
service: total inventory turnovers 4.78 1169 574
service: total monetary turnovers 6.81 33 817
service: aggregate perf. data 0.81 17058 97
service: refresh index statistics 0.03 258213 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-06-2021 01:28:28 to 13-06-2021 01:28:30.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2693
TEST_TIME 2 3365
TEST_TIME 3 3757
TEST_TIME 4 4900
TEST_TIME 5 5305
TEST_TIME 6 5005
TEST_TIME 7 5174
TEST_TIME 8 4970
TEST_TIME 9 5153
TEST_TIME 10 5236
TEST_TIME 11 5547
TEST_TIME 12 5681
TEST_TIME 13 5737
TEST_TIME 14 6323
TEST_TIME 15 6738
TEST_TIME 16 6698
TEST_TIME 17 7175
TEST_TIME 18 7354
TEST_TIME 19 7757
TEST_TIME 20 8387
TEST_TIME 21 8479
TEST_TIME 22 8310
TEST_TIME 23 8757
TEST_TIME 24 8719
TEST_TIME 25 8776
TEST_TIME 26 9099
TEST_TIME 27 11041
TEST_TIME 28 11330
TEST_TIME 29 11388
TEST_TIME 30 11344
TEST_TIME 31 11031
TEST_TIME 32 10810
TEST_TIME 33 10726
TEST_TIME 34 10706
TEST_TIME 35 10592
TEST_TIME 36 10497
TEST_TIME 37 10439
TEST_TIME 38 10345
TEST_TIME 39 10290
TEST_TIME 40 10392
TEST_TIME 41 10533
TEST_TIME 42 10405
TEST_TIME 43 10279
TEST_TIME 44 10166
TEST_TIME 45 9963
TEST_TIME 46 10011
TEST_TIME 47 9973
TEST_TIME 48 9835
TEST_TIME 49 9872
TEST_TIME 50 9932
TEST_TIME 51 9907
TEST_TIME 52 9929
TEST_TIME 53 9929
TEST_TIME 54 9900
TEST_TIME 55 10009
TEST_TIME 56 10008
TEST_TIME 57 9968
TEST_TIME 58 10068
TEST_TIME 59 10091
TEST_TIME 60 10066
TEST_TIME 61 10108
TEST_TIME 62 9986
TEST_TIME 63 9919
TEST_TIME 64 9864
TEST_TIME 65 9887
TEST_TIME 66 9791
TEST_TIME 67 9778
TEST_TIME 68 9717
TEST_TIME 69 9667
TEST_TIME 70 9602
TEST_TIME 71 9633
TEST_TIME 72 9702
TEST_TIME 73 9696
TEST_TIME 74 9688
TEST_TIME 75 9770
TEST_TIME 76 9733
TEST_TIME 77 9808
TEST_TIME 78 9784
TEST_TIME 79 9804
TEST_TIME 80 9789
TEST_TIME 81 9917
TEST_TIME 82 9990
TEST_TIME 83 9939
TEST_TIME 84 9851
TEST_TIME 85 9823
TEST_TIME 86 9806
TEST_TIME 87 9754
TEST_TIME 88 9719
TEST_TIME 89 9665
TEST_TIME 90 9651
TEST_TIME 91 9648
TEST_TIME 92 9655
TEST_TIME 93 9627
TEST_TIME 94 9646
TEST_TIME 95 9704
TEST_TIME 96 9678
TEST_TIME 97 9679
TEST_TIME 98 9716
TEST_TIME 99 9656
TEST_TIME 100 9838
TEST_TIME 101 9838
TEST_TIME 102 9869
TEST_TIME 103 9857
TEST_TIME 104 9867
TEST_TIME 105 9823
TEST_TIME 106 9742
TEST_TIME 107 9702
TEST_TIME 108 9701
TEST_TIME 109 9651
TEST_TIME 110 9642
TEST_TIME 111 9605
TEST_TIME 112 9595
TEST_TIME 113 9604
TEST_TIME 114 9571
TEST_TIME 115 9582
TEST_TIME 116 9583
TEST_TIME 117 9569
TEST_TIME 118 9545
TEST_TIME 119 9554
TEST_TIME 120 9581

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-06-2021 01:28:32 to 13-06-2021 01:28:35.

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 1584365 1584365 0 0.00 0 24403 6 0 0
doc_list_biud 1584362 1584362 0 0.00 0 40914 28 0 0
sp_add_invoice_to_stock 5177 5083 94 1.81 39 174729 18068 0 94
sp_cancel_adding_invoice 6039 6039 0 0.00 5 69683 798 0 0
sp_cancel_client_order 1695 1695 0 0.00 5 12666 351 0 0
sp_cancel_customer_reserve 589827 589827 0 0.00 1 40917 60 0 0
sp_cancel_pay_from_customer 694 694 0 0.00 2 10385 77 0 0
sp_cancel_pay_to_supplier 408 408 0 0.00 3 1309 62 0 0
sp_cancel_supplier_invoice 6714 6707 7 0.10 1 15092 922 0 7
sp_cancel_supplier_order 433 433 0 0.00 8 1089704 106876 0 0
sp_cancel_write_off 12090 12090 0 0.00 1 17658 116 0 0
sp_client_order 20756 20756 0 0.00 3 55644 364 0 0
sp_customer_reserve 469644 469644 0 0.00 0 64467 179 0 0
sp_fill_shopping_cart 31627 31627 0 0.00 1 17837 35 0 0
sp_fill_shopping_cart_clo_res 469632 469632 0 0.00 0 15028 15 0 0
sp_get_clo_for_invoice 5071 5071 0 0.00 0 37234 330 0 0
sp_kill_cost_storno 19231 19231 0 0.00 0 5020 55 0 0
sp_kill_qstorno_ret_qs2qd 1198884 1198884 0 0.00 0 40909 33 0 0
sp_kill_qty_storno 631824 631824 0 0.00 0 40914 71 0 0
sp_lock_selected_doc 20786 20786 0 0.00 0 9506 8 0 0
sp_make_cost_storno 28116 28116 0 0.00 0 12839 50 0 0
sp_multiply_rows_for_pdistr 28116 28116 0 0.00 0 8729 27 0 0
sp_multiply_rows_for_qdistr 20756 20756 0 0.00 0 50122 173 0 0
sp_pay_from_customer 7117 7117 0 0.00 4 14867 116 0 0
sp_pay_to_supplier 5966 5966 0 0.00 4 12879 117 0 0
sp_payment_common 13082 13082 0 0.00 1 7051 23 0 0
sp_qd_handle_on_cancel_clo 1695 1695 0 0.00 0 12419 316 0 0
sp_qd_handle_on_invoice_upd_sts 11110 11110 0 0.00 0 20927 324 0 0
sp_qd_handle_on_reserve_upd_sts 9962 9962 0 0.00 0 16676 54 0 0
sp_reserve_write_off 9962 9962 0 0.00 6 17275 179 0 0
sp_supplier_invoice 5408 5408 0 0.00 7 66168 3277 0 0
sp_supplier_order 5469 5469 0 0.00 5 32231 1267 0 0
srv_aggregate_perf_data 97 97 0 0.00 3360 120221 17058 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 1034 131346 31218 0 0
srv_find_qd_qs_mism 1101006 1101006 0 0.00 0 24401 5 0 0
srv_make_invnt_saldo 574 574 0 0.00 32 59837 1170 0 0
srv_make_money_saldo 817 817 0 0.00 0 2938 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 121239 355225 258214 0 0
t$perf-abend:sp_add_invoice_to_stock 94 94 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5083 5083 0 0.00 0 18822 202 0 0
t$perf-norm:sp_cancel_adding_invoice 412 412 0 0.00 0 6576 93 0 0
t$perf-norm:sp_cancel_client_order 1695 1695 0 0.00 0 1838 14 0 0
t$perf-norm:sp_cancel_customer_reserve 681 681 0 0.00 0 622 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 694 694 0 0.00 0 2537 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 408 408 0 0.00 0 3560 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 410 410 0 0.00 0 1061 15 0 0
t$perf-norm:sp_cancel_supplier_order 433 433 0 0.00 0 27105 1477 0 0
t$perf-norm:sp_cancel_write_off 1020 1020 0 0.00 0 6312 10 0 0
t$perf-norm:sp_client_order 20756 20756 0 0.00 0 5950 18 0 0
t$perf-norm:sp_customer_reserve 1014 1014 0 0.00 0 4337 13 0 0
t$perf-norm:sp_pay_from_customer 7117 7117 0 0.00 0 5998 11 0 0
t$perf-norm:sp_pay_to_supplier 5966 5966 0 0.00 0 4369 11 0 0
t$perf-norm:sp_reserve_write_off 9962 9962 0 0.00 0 4269 10 0 0
t$perf-norm:sp_supplier_invoice 5408 5408 0 0.00 0 4843 18 0 0
t$perf-norm:sp_supplier_order 5469 5469 0 0.00 0 6692 15 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 511 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 1439 18 0 0
t$perf-norm:srv_make_invnt_saldo 574 574 0 0.00 0 8500 29 0 0
t$perf-norm:srv_make_money_saldo 817 817 0 0.00 0 2888 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 10330 10142 188 1.81 0 6086 22 0 188
v_all_customers 38240 38240 0 0.00 0 93 1 0 0
v_all_suppliers 30444 30444 0 0.00 0 104 1 0 0
v_all_wares 41512 41512 0 0.00 0 49 1 0 0
v_cancel_adding_invoice 824 824 0 0.00 0 1504 8 0 0
v_cancel_client_order 3390 3390 0 0.00 0 3856 7 0 0
v_cancel_customer_prepayment 1388 1388 0 0.00 0 10365 17 0 0
v_cancel_customer_reserve 1362 1362 0 0.00 0 3044 11 0 0
v_cancel_payment_to_supplier 816 816 0 0.00 0 798 4 0 0
v_cancel_supplier_invoice 834 820 14 1.67 0 2412 18 0 14
v_cancel_supplier_order 866 866 0 0.00 0 4474 7 0 0
v_cancel_write_off 2040 2040 0 0.00 0 3690 16 0 0
v_max_id_clo_ord 5469 5469 0 0.00 0 1806 1 0 0
v_max_id_clo_res 1014 1014 0 0.00 0 3441 18 0 0
v_max_id_ord_sup 5402 5402 0 0.00 0 5470 8 0 0
v_max_non_paid_invoice 1614 1614 0 0.00 0 2841 5 0 0
v_max_non_paid_realizn 3558 3558 0 0.00 0 2048 4 0 0
v_min_id_clo_ord 5469 5469 0 0.00 0 1889 7 0 0
v_min_id_clo_res 1014 1014 0 0.00 0 9852 26 0 0
v_min_id_ord_sup 5402 5402 0 0.00 0 12548 11 0 0
v_min_non_paid_invoice 5965 5965 0 0.00 0 6362 13 0 0
v_min_non_paid_realizn 7117 7117 0 0.00 0 4301 15 0 0
v_our_firm 10390 10390 0 0.00 0 15 1 0 0
v_reserve_write_off 19924 19924 0 0.00 0 11364 9 0 0
x_lock_depdocs_on_canc_invoice 12336 12336 0 0.00 0 18013 125 0 0
x_lock_depdocs_on_canc_sup_ord 433 433 0 0.00 0 6944 331 0 0
x_make_qstorno_1000_1200 5469 5469 0 0.00 2 32219 1192 0 0
x_make_qstorno_1200_2000 5408 5408 0 0.00 3 66157 3150 0 0
x_make_qstorno_2100_3300 469644 469644 0 0.00 0 64465 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-06-2021 01:28:36 to 13-06-2021 01:28:40.

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:44 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
22:57:51 20823 8192000000 10233891760 10538098688 838322752 9.283 67 51 101 0 857869936 2345808 17201376
22:58:20 22602 8192000000 10309334720 10618363904 1359939440 14.237 100 83 166 0 1391938224 4291616 27707168
22:58:51 40106 8192000000 10364032560 10683723776 1406620320 14.654 100 87 174 0 1440701312 5523104 28557888
22:59:47 20445 8192000000 10394455072 10716524544 1449858464 15.037 100 91 182 1 1486010944 6822352 29330128
23:00:25 13903 8192000000 10408110192 10735263744 1465650208 15.176 100 85 170 0 1504666768 11586128 27430432
23:00:50 17798 8192000000 10437554960 10767630336 1487498848 15.367 100 86 172 1 1522516144 7386624 27630672
23:01:20 7694 8192000000 10449436576 10783313920 1503940480 15.511 100 89 178 0 1540731680 8012128 28779072
23:01:39 22739 8192000000 10467869856 10809171968 1526688880 15.708 100 82 164 0 1560430832 8273680 25468272
23:02:12 12931 8192000000 10484444496 10838925312 1550059184 15.911 100 66 133 0 1578582400 8366592 20156624
23:02:36 11866 8192000000 10526534880 10881462272 1585186752 16.213 100 78 155 0 1617806096 8640608 23978736
23:02:59 10491 8192000000 10552908960 10910228480 1608675008 16.413 100 66 131 0 1637798336 9314912 19808416
23:03:18 13144 8192000000 10570720480 10937581568 1645036688 16.722 100 73 146 0 1676529952 9536080 21957184
23:03:41 15530 8192000000 10603650432 10969948160 1665099744 16.892 100 75 150 0 1697185104 10892672 21192688
23:04:04 8641 8192000000 10609620352 10978992128 1680321552 17.020 100 78 155 3 1714106224 11545552 22239120
23:04:21 9452 8192000000 10631242368 10998939648 1691227536 17.112 100 78 156 0 1725750880 11704384 22818960
23:04:39 7551 8192000000 10645118384 11014746112 1710670896 17.274 100 86 172 1 1748727440 12989520 25067024
23:04:53 8325 8192000000 10659004640 11032932352 1718928464 17.343 100 76 149 1 1752685376 13050736 20706176
23:05:09 6277 8192000000 10671817728 11048103936 1737404704 17.497 100 82 164 1 1774903200 14004400 23494096
23:05:22 4521 8192000000 10683123744 11060428800 1751379760 17.613 100 85 170 1 1789002432 13335936 24286736
23:05:36 3314 8192000000 10706273776 11083030528 1770718128 17.773 100 84 168 2 1807844656 13448224 23678304
23:05:47 4344 8192000000 10715361296 11094130688 1775601728 17.813 100 83 164 0 1811895824 13523840 22770256
23:05:58 3436 8192000000 10734736160 11110604800 1787140272 17.908 100 89 180 1 1827121808 14741616 25239920
23:06:08 3566 8192000000 10731877632 11112407040 1788327952 17.918 100 79 158 1 1823437520 13042864 22066704
23:06:19 2849 8192000000 10735053328 11115597824 1797238048 17.991 100 91 181 2 1836800672 13911696 25650928
23:06:29 2883 8192000000 10744977936 11124477952 1802421552 18.034 100 88 177 0 1839925088 12754640 24748896
23:06:38 6195 8192000000 10741197840 11122028544 1799055680 18.006 100 75 150 3 1832632784 12585488 20991616
23:06:51 4975 8192000000 10755177904 11136016384 1808410944 18.083 100 85 169 3 1846951856 14703232 23837680
23:07:03 2497 8192000000 10767241536 11152052224 1824958704 18.218 100 83 166 0 1862570192 14486592 23124896
23:07:12 2388 8192000000 10768618944 11155771392 1828941760 18.251 100 85 171 1 1866163696 13776416 23445520
23:07:21 2231 8192000000 10779915152 11168301056 1838793136 18.331 100 92 184 2 1879488400 14662832 26032432
23:07:30 2255 8192000000 10776730608 11163185152 1839945088 18.340 100 93 184 0 1880675552 14991808 25738656
23:07:38 2024 8192000000 10786809472 11172265984 1841687424 18.355 100 90 181 0 1880330768 13005728 25637616
23:07:47 2002 8192000000 10788481696 11173576704 1851326880 18.433 100 93 187 1 1889936768 12392608 26217280
23:07:55 2020 8192000000 10798933792 11181543424 1855514912 18.467 100 92 184 1 1895384400 13341840 26527648
23:08:04 1521 8192000000 10799417216 11186348032 1858720976 18.493 100 91 183 1 1896838112 12052672 26064464
23:08:12 2047 8192000000 10807705120 11193257984 1858586688 18.492 100 88 174 3 1895975504 13321200 24067616
23:08:20 1498 8192000000 10808905424 11194150912 1863886928 18.535 100 94 186 3 1904669312 14346688 26435696
23:08:28 2122 8192000000 10809373296 11197816832 1865361488 18.547 100 89 179 1 1904724576 13486576 25876512
23:08:37 25460 8192000000 10790548000 11193978880 1861647632 18.517 100 66 130 1 1893198160 12935280 18615248
23:09:10 4132 8192000000 10785054816 11192205312 1859354496 18.498 100 52 104 0 1884663088 10815024 14493568
23:09:20 3030 8192000000 10764097104 11188596736 1861055424 18.512 100 33 64 0 1878345312 8283088 9006800
23:09:31 5933 8192000000 10782500000 11190276096 1863913968 18.535 100 33 67 1 1879368064 5660944 9793152
23:09:43 4366 8192000000 10783736928 11200233472 1863934704 18.535 100 34 68 1 1881251088 8123312 9193072
23:09:57 10153 8192000000 10771855328 11199209472 1864123120 18.537 100 21 42 3 1876616432 6719072 5774240
23:10:14 9256 8192000000 10775438928 11204362240 1870959248 18.592 100 30 60 2 1886876640 7048672 8868720
23:10:34 12228 8192000000 10783740688 11208192000 1872448784 18.604 100 14 29 0 1881913488 5672016 3792688
23:10:53 11427 8192000000 10793341360 11219046400 1877467072 18.645 100 20 40 2 1893305024 10610688 5227264
23:11:16 9733 8192000000 10791150128 11214729216 1878468512 18.653 100 17 34 0 1889082112 5676832 4936768
23:11:32 48436 8192000000 10807044368 11232542720 1884413584 18.701 100 32 66 1 1899587600 4941888 10232128
23:12:27 22424 8192000000 10832877296 11242950656 1890959968 18.754 100 62 125 1 1920157424 9888128 19309328
23:12:56 8915 8192000000 10807607424 11229188096 1886046112 18.714 100 25 50 1 1900342432 7307024 6989296
23:13:15 7808 8192000000 10819508400 11235115008 1889666128 18.743 100 45 90 2 1909720512 7266640 12787744
23:13:31 5265 8192000000 10815743232 11235495936 1890877552 18.753 100 41 79 2 1910061536 7793104 11390880
23:13:44 4750 8192000000 10800087200 11229081600 1871511024 18.596 99 34 68 1 1892676032 11550304 9614704
23:13:55 3049 8192000000 10808942816 11232518144 1890334000 18.748 100 47 94 0 1911929808 8018048 13577760
23:14:09 4436 8192000000 10804866192 11236937728 1892425392 18.765 100 26 52 2 1906240560 6160208 7654960
23:14:22 10158 8192000000 10826994880 11242582016 1894049648 18.778 100 24 45 2 1905566336 4918160 6598528
23:14:38 5519 8192000000 10813934448 11239911424 1897031648 18.802 100 25 50 0 1909894384 5981696 6881040
23:14:53 10910 8192000000 10801018848 11242987520 1896186848 18.796 100 19 38 1 1907178800 5620448 5371504
23:15:10 10300 8192000000 10808925536 11250974720 1900442592 18.830 100 16 32 1 1914252176 9927024 3882560
23:15:26 54856 8192000000 10813170192 11240017920 1864655760 18.541 98 21 42 0 1876501344 5522960 6322624
23:16:40 12579 8192000000 10806812496 11237928960 1876732496 18.639 99 16 30 0 1886098848 5476384 3889968
23:16:59 8660 8192000000 10792582752 11220451328 1840468112 18.345 97 22 44 1 1852457088 5745344 6243632
23:17:14 4346 8192000000 10809352336 11226480640 1868375760 18.571 99 51 102 0 1891996976 9404432 14216784
23:17:26 9918 8192000000 10798890592 11221458944 1874830640 18.623 100 32 64 2 1890793456 6337584 9625232
23:17:42 6555 8192000000 10763307696 11188436992 1806826800 18.070 96 22 44 1 1818756496 5459264 6470432
23:17:56 6824 8192000000 10782064240 11213078528 1871430672 18.596 100 31 61 2 1887631040 6409424 9790944
23:18:09 6918 8192000000 10777264272 11213299712 1870463712 18.588 100 22 44 2 1887024256 9928208 6632336
23:18:23 7891 8192000000 10778935072 11210403840 1849680448 18.420 99 19 38 1 1860687200 5907136 5099616
23:18:37 7497 8192000000 10761820944 11180707840 1791367488 17.943 96 21 42 1 1806396432 9117408 5911536
23:18:53 10924 8192000000 10698684672 11117420544 1671004192 16.942 91 17 32 2 1681514736 5051264 5459280
23:19:11 6884 8192000000 10718242608 11130748928 1768078096 17.751 98 43 86 2 1791716528 10268320 13370112
23:19:24 11440 8192000000 10707188624 11124420608 1748372272 17.588 97 22 44 3 1761065392 5889408 6803712
23:19:41 8670 8192000000 10713089184 11118714880 1719047056 17.344 95 33 64 1 1733861936 4856368 9958512
23:19:59 11614 8192000000 10688262880 11099353088 1678656752 17.006 93 27 54 1 1691730656 5224224 7849680
23:20:20 46009 8192000000 10748421696 11141443584 1754011664 17.635 98 43 86 2 1771675056 4795232 12868160
23:21:12 7484 8192000000 10680621728 11099176960 1729078912 17.428 96 16 32 0 1739149504 5945120 4125472
23:21:30 9163 8192000000 10711438256 11124359168 1765873216 17.733 98 29 58 1 1779956480 6021616 8061648
23:21:45 6490 8192000000 10713029568 11127734272 1782855360 17.873 99 35 68 0 1799194944 6560464 9779120
23:22:00 5487 8192000000 10715791952 11131957248 1774046368 17.800 98 34 68 1 1789701952 5878160 9777424
23:22:12 6195 8192000000 10736781248 11157577728 1824091824 18.211 100 37 74 2 1840891056 6271472 10527760
23:22:25 5421 8192000000 10746417552 11164123136 1824618512 18.215 100 25 50 0 1837807104 5530512 7658080
23:22:42 9498 8192000000 10745190832 11164712960 1830031280 18.260 100 25 50 2 1844640016 5879120 8729616
23:22:57 10983 8192000000 10746740224 11162664960 1800275104 18.016 98 20 40 1 1811289008 5235248 5778656
23:23:17 8875 8192000000 10748815424 11175194624 1837926880 18.324 100 20 40 0 1849933136 5649984 6356272
23:23:32 9312 8192000000 10756458608 11182698496 1845494560 18.386 100 25 50 2 1858738064 6444576 6798928
23:23:48 11157 8192000000 10752482928 11183751168 1831150864 18.269 99 24 48 0 1843433584 5415760 6866960
23:24:06 6933 8192000000 10775021936 11194613760 1852374128 18.441 100 28 55 1 1870514096 9218320 8921648
23:24:23 12342 8192000000 10772686928 11201626112 1862246432 18.521 100 32 64 1 1881161472 9684176 9230864
23:24:45 27933 8192000000 10782465904 11203428352 1862045584 18.520 100 20 36 1 1872956272 5237232 5673456
23:25:34 37390 8192000000 10766892160 11202887680 1866743440 18.558 100 44 89 0 1885708864 6066576 12898848
23:26:22 9218 8192000000 10781276544 11204276224 1863691792 18.533 100 25 50 0 1876274144 5005616 7576736
23:26:40 7917 8192000000 10765101840 11205009408 1868895696 18.575 100 30 60 0 1883337328 5968544 8473088
23:26:57 11397 8192000000 10787927584 11214962688 1867043040 18.560 100 13 26 0 1875281776 4985968 3252768
23:27:17 7007 8192000000 10797086256 11225796608 1885633872 18.711 100 30 60 1 1900855872 7332640 7889360
23:27:30 7754 8192000000 10800207488 11226910720 1889908736 18.745 100 29 58 0 1904082048 4843936 9329376
23:27:49 30141 8192000000 10819522192 11232997376 1875099424 18.626 99 38 76 5 1892044016 5411040 11533552
23:28:34 24213 8192000000 10830222192 11249750016 1901372592 18.837 100 50 99 2 1923667504 8274304 14020608
23:29:18 9632 8192000000 10853692736 11270692864 1914655696 18.944 100 56 112 0 1943761936 13300592 15805648
23:29:36 12193 8192000000 10863435616 11277127680 1919539440 18.983 100 61 118 2 1950337024 13391424 17406160
23:30:00 18060 8192000000 10862270528 11279515648 1923981632 19.019 100 59 117 2 1956807984 16136000 16690352
23:30:27 22607 8192000000 10871847328 11290324992 1931769536 19.081 100 61 122 2 1968054320 18989248 17295536
23:30:58 6153 8192000000 10878556640 11297968128 1934419648 19.102 100 61 122 2 1971323632 19441840 17462144
23:31:11 20994 8192000000 10876694368 11297366016 1936731728 19.121 100 53 103 0 1971089920 18760944 15597248
23:31:47 40959 8192000000 10870742560 11311763456 1939531568 19.143 100 39 78 1 1975625056 24321712 11771776
23:32:40 14811 8192000000 10872565200 11311751168 1937208432 19.124 100 34 68 1 1969107296 21513616 10385248
23:33:33 27122 8192000000 10880799584 11321942016 1939196336 19.140 100 22 44 1 1968247040 21813488 7237216
23:34:07 13581 8192000000 10898982352 11331248128 1953696688 19.256 100 46 92 2 1988523568 20304480 14522400
23:34:28 18206 8192000000 10885029760 11315187712 1941274816 19.157 99 40 81 0 1973254288 19824896 12154576
23:34:55 7631 8192000000 10923007680 11338207232 1964540176 19.342 100 58 117 1 2002878720 21297280 17041264
23:35:18 8996 8192000000 10912105472 11342540800 1967779488 19.368 100 47 94 1 2003423600 21988224 13655888
23:35:36 9297 8192000000 10933077296 11356463104 1978887936 19.456 100 58 116 0 2019286000 23096496 17301568
23:35:53 26348 8192000000 10931698624 11363508224 1980235520 19.467 100 53 106 2 2020209056 24126224 15847312
23:36:30 8215 8192000000 10937949088 11371413504 1986278544 19.514 100 47 94 0 2028846720 28405264 14162912
23:36:45 4169 8192000000 10950274016 11375898624 1991165552 19.553 100 55 109 1 2035472432 28473728 15833152
23:36:59 4879 8192000000 10966345568 11388153856 1999115520 19.616 100 71 140 2 2050397216 30129008 21152688
23:37:11 6386 8192000000 10960630384 11383410688 1982903280 19.488 99 74 143 3 2033887840 29908848 21075712
23:37:27 5884 8192000000 10954181408 11385184256 1998746816 19.613 100 59 118 0 2046718224 30581024 17390384
23:37:40 2653 8192000000 10968471968 11389497344 2002270576 19.641 100 76 152 3 2057484128 31500912 23712640
23:37:50 4234 8192000000 10968368160 11391963136 2003822480 19.653 100 76 150 2 2058498960 32276352 22400128
23:38:09 7005 8192000000 10973254224 11392098304 2001086384 19.631 100 67 134 0 2055610640 35320224 19204032
23:38:23 3630 8192000000 10970131184 11388841984 1995957488 19.591 100 70 140 1 2054047728 36509168 21581072
23:38:33 2461 8192000000 10967953216 11392434176 1998839056 19.614 100 68 134 1 2056114848 36220384 21055408
23:38:46 2096 8192000000 10979950432 11396407296 1980991488 19.473 99 82 163 1 2045989424 39303760 25694176
23:38:57 2636 8192000000 10957972272 11367317504 1962523936 19.326 98 89 178 0 2028062160 38905792 26632432
23:39:07 2611 8192000000 10977298128 11390488576 1990849280 19.551 100 90 180 2 2057227648 39339200 27039168
23:39:19 3827 8192000000 10971861824 11382587392 1988535968 19.532 100 76 149 1 2050388176 39342736 22509472
23:39:35 2406 8192000000 10974560672 11388067840 1992059184 19.560 100 79 157 3 2056514720 40863312 23592224
23:39:45 6443 8192000000 10967286480 11381608448 1971354112 19.396 99 76 150 2 2037475392 43067744 23053536
23:39:58 4681 8192000000 10983588672 11399221248 1994976048 19.583 100 72 142 1 2063158816 46164976 22017792
23:40:10 5176 8192000000 10966736272 11385802752 1977019248 19.441 99 69 137 3 2044127568 46673184 20435136
23:40:24 9252 8192000000 10977466112 11399499776 1977162912 19.442 99 72 143 1 2050473664 50501008 22809744
23:40:42 2106 8192000000 10973106608 11393445888 1970093840 19.386 99 72 142 0 2043647008 51571472 21981696
23:40:51 1944 8192000000 10984890864 11399475200 1990556624 19.548 100 88 176 0 2070641584 52832096 27252864
23:41:01 3826 8192000000 10970371568 11389337600 1982755552 19.487 100 86 172 1 2063421504 54115312 26550640
23:41:15 5922 8192000000 10970667888 11386109952 1965944480 19.353 99 81 157 1 2047395760 55565808 25885472
23:41:29 1099 8192000000 10961690656 11383660544 1966587440 19.358 99 83 164 1 2049359280 56358896 26412944
23:41:39 4728 8192000000 10969971600 11387146240 1964231168 19.340 99 74 146 0 2041176640 54935616 22009856
23:41:51 7673 8192000000 10971775696 11389394944 1962611584 19.327 99 76 152 0 2040048064 54327104 23109376
23:42:06 13469 8192000000 10928434896 11343642624 1928060544 19.051 98 68 137 0 2004591696 55126672 21404480
23:42:36 3242 8192000000 10938897984 11358883840 1936830240 19.121 99 71 142 1 2018686912 58364096 23492576
23:42:50 4725 8192000000 10967598656 11388940288 1972847632 19.408 100 72 142 0 2049227056 54217552 22161872
23:43:03 4067 8192000000 10981177200 11396669440 1968450544 19.373 99 83 161 0 2049350960 55082144 25818272
23:43:15 1320 8192000000 10981373968 11392323584 1978900240 19.456 100 73 145 0 2059315424 57475824 22939360
23:43:23 4005 8192000000 10985580880 11402723328 1984742816 19.502 100 83 165 0 2069420592 59149648 25528128
23:43:37 3996 8192000000 10983328880 11397001216 1982361760 19.483 100 83 164 0 2069225984 60550544 26313680
23:43:48 2598 8192000000 10981369072 11393892352 1969439312 19.381 99 87 172 4 2060048816 63259072 27350432
23:43:58 3366 8192000000 10986135216 11405217792 1978449744 19.452 100 78 153 0 2069253952 66269120 24535088
23:44:08 1654 8192000000 10992442000 11405185024 1978435760 19.452 100 90 181 2 2076076608 68834000 28806848
23:44:17 2398 8192000000 10979664256 11395366912 1974590576 19.422 100 76 152 1 2062513152 63567248 24355328
23:44:26 3401 8192000000 10969534112 11376521216 1956592896 19.279 99 79 158 0 2046940192 64620064 25727232
23:44:36 2124 8192000000 10992955984 11402809344 1980062960 19.465 100 92 185 0 2076810880 67416688 29331232
23:44:45 2522 8192000000 10994766688 11403096064 1978285328 19.451 100 93 186 0 2076929984 69173728 29470928
23:44:54 3023 8192000000 10976634080 11392016384 1955424080 19.270 99 88 178 2 2051507552 68240016 27843456
23:45:03 1025 8192000000 10975315728 11386068992 1965787088 19.352 100 83 167 0 2058145696 66492224 25866384
23:45:11 4062 8192000000 10994444080 11399196672 1977534128 19.445 100 85 169 0 2071828144 67245968 27048048
23:45:23 3570 8192000000 10991175184 11397267456 1973002208 19.409 100 87 174 2 2068943424 68161760 27779456
23:45:34 1657 8192000000 10989879152 11398594560 1977415136 19.444 100 93 186 5 2075206992 68423888 29367968
23:45:45 4565 8192000000 10979229824 11390013440 1956284672 19.276 99 80 160 1 2052809376 69882080 26642624
23:46:02 3849 8192000000 10984817568 11406561280 1980892848 19.472 100 70 140 1 2075875792 72275760 22707184
23:46:16 3509 8192000000 11011370416 11420442624 1997761968 19.605 100 91 182 3 2095225680 68472640 28991072
23:46:27 2121 8192000000 11007011184 11417575424 1988132368 19.529 100 82 164 0 2085840832 71532240 26176224
23:46:40 7038 8192000000 10988135392 11420844032 1982983728 19.488 100 60 121 1 2074653904 71506672 20163504
23:46:56 6215 8192000000 10990064960 11422564352 1985913888 19.511 100 54 108 0 2076757616 72589984 18253744
23:47:18 23992 8192000000 10961232112 11393261568 1948463280 19.214 98 37 74 1 2022484784 61360032 12661472
23:47:55 12660 8192000000 10966716480 11418869760 1983813168 19.495 100 38 76 0 2062227888 65380048 13034672
23:48:14 7982 8192000000 10960507088 11397083136 1969325728 19.380 99 39 78 0 2040376496 58094240 12956528
23:48:29 15620 8192000000 10960568848 11406893056 1979643872 19.462 100 35 70 0 2047425296 56327888 11453536
23:48:58 13416 8192000000 10961052352 11402051584 1979462768 19.460 100 32 64 0 2048709504 58302816 10943920
23:49:26 19561 8192000000 10956733824 11398324224 1939840832 19.145 98 37 75 1 2014621248 61841840 12938576
23:50:07 8673 8192000000 10953422192 11405291520 1962217984 19.324 100 29 57 3 2039858016 67147776 10492256
23:51:02 9029 8192000000 10940804944 11389972480 1947599808 19.207 100 32 63 3 2023175536 64068240 11507488
23:51:42 31730 8192000000 10923990144 11371446272 1902585696 18.847 98 27 54 0 1983788512 71006576 10196240
23:52:21 13831 8192000000 10915698576 11365785600 1906899440 18.882 99 33 66 1 1995243456 75938560 12405456
23:52:42 10640 8192000000 10929635920 11377258496 1925992496 19.035 100 29 58 0 2014137168 76962032 11182640
23:53:24 20410 8192000000 10931045600 11394170880 1923660240 19.016 100 35 70 1 2027908496 90539872 13708384
23:53:52 14609 8192000000 10935641904 11401129984 1925514288 19.031 100 21 42 0 2020269776 86071760 8683728
23:55:01 57613 8192000000 10867737824 11322556416 1863818208 18.534 97 10 20 0 1883583056 16777744 2987104
23:56:07 50982 8192000000 10851636960 11325587456 1910723616 18.912 99 12 24 2 1929753520 14956160 4073744
23:57:05 79618 8192000000 10886389088 11318149120 1884311200 18.700 97 21 42 0 1904481824 14255760 5914864
23:58:36 131345 8192000000 10895488432 11342704640 1924222544 19.021 99 31 62 0 1951427504 18578112 8626848
00:00:55 90061 8192000000 10889229664 11357753344 1916183744 18.956 98 15 27 2 1937222832 16482608 4556480
00:02:32 62209 8192000000 10886445280 11361730560 1935326976 19.109 99 8 16 1 1962749440 24976624 2445840
00:03:43 11239 8192000000 10887715312 11357245440 1953919520 19.258 100 17 34 1 1976483072 17880336 4683216
00:04:00 1236 8192000000 10921347344 11352010752 1964200400 19.339 100 63 125 1 1993772592 9954512 19617680
00:04:08 91707 8192000000 10928845536 11388882944 1976256720 19.435 100 28 56 0 2000947664 16528128 8162816
00:05:47 50789 8192000000 10944997792 11392094208 1966208656 19.355 99 30 58 1 2000248368 24972512 9067200
00:06:45 29533 8192000000 10933530768 11395264512 1990365104 19.547 100 48 96 2 2025319376 20556960 14397312
00:07:31 37904 8192000000 10895477360 11375243264 1921237056 18.997 97 16 32 2 1949777968 23245072 5295840
00:09:07 29100 8192000000 10895007808 11353763840 1950984208 19.234 99 23 47 0 1963938256 6164368 6789680
00:10:37 59935 8192000000 10880008288 11354488832 1935647616 19.112 98 9 18 0 1947592176 9508896 2435664
00:11:43 10209 8192000000 10890711648 11358789632 1960390992 19.309 100 7 14 0 1972224272 10076864 1756416
00:12:04 48453 8192000000 10886982496 11355938816 1946268848 19.197 99 15 30 0 1962583248 11721040 4593360
00:13:10 51870 8192000000 10884452976 11375407104 1944454432 19.182 99 19 38 0 1961118288 11509488 5154368
00:14:16 32623 8192000000 10888459216 11369164800 1963515200 19.334 100 8 16 0 1979711312 13976448 2219664
00:14:59 36269 8192000000 10885759776 11361087488 1909949168 18.906 97 8 16 0 1923535136 11447744 2138224
00:15:42 54188 8192000000 10892941616 11374714880 1973114352 19.410 100 26 52 1 1995609872 14392368 8103152
00:17:45 60369 8192000000 10870302624 11335532544 1935118416 19.108 98 24 48 3 1952410352 10638496 6653440
00:18:59 28592 8192000000 10891610864 11354935296 1912043552 18.923 97 41 82 2 1935638016 12098464 11496000
00:19:34 51517 8192000000 10899983184 11372412928 1960693312 19.312 100 24 46 0 1979021680 11727808 6600560
00:20:32 58402 8192000000 10915017216 11373973504 1974447648 19.421 100 9 17 0 1986913152 10237872 2227632
00:21:37 28819 8192000000 10937416128 11390611456 1967249632 19.364 99 29 58 0 1988794144 13367312 8177200
00:22:14 22607 8192000000 10922915376 11379568640 1966010512 19.354 99 48 96 0 1992535744 12857888 13667344
00:22:47 47338 8192000000 10917501664 11389485056 1977733248 19.447 100 18 36 1 1992655184 9850608 5071328
00:23:42 53660 8192000000 10901408656 11363356672 1922558368 19.007 97 35 70 0 1941736672 9074320 10103984
00:24:55 43113 8192000000 10917182832 11382263808 1960670336 19.311 99 40 80 1 1986122704 14214784 11237584
00:26:41 80072 8192000000 10911205632 11383177216 1932055120 19.083 97 23 46 1 1950036816 11701088 6280608
00:28:10 32591 8192000000 10890329440 11351642112 1892437104 18.765 96 11 22 1 1902114336 6689680 2987552
00:28:51 84466 8192000000 10875662672 11325923328 1852448176 18.442 94 28 54 0 1866704944 6921232 7335536
00:30:24 62150 8192000000 10893851888 11341377536 1852624672 18.443 95 27 53 0 1871426816 11588432 7213712
00:31:36 57701 8192000000 10862252288 11329163264 1914310816 18.941 98 31 62 0 1935216928 11578592 9327520
00:32:45 58114 8192000000 10833951856 11311398912 1881391120 18.676 97 14 28 0 1896435184 11223776 3820288
00:33:51 49498 8192000000 10825067184 11310907392 1866433216 18.555 97 4 8 0 1880017984 12793248 791520
00:34:47 37146 8192000000 10837226384 11313991680 1891022192 18.754 99 8 16 0 1907879168 14279440 2577536
00:35:31 40889 8192000000 10854041728 11317866496 1908426960 18.894 99 18 36 1 1930826416 17164464 5234992
00:36:19 61895 8192000000 10853865376 11329232896 1914819920 18.945 99 16 32 1 1933364416 13812928 4731568
00:37:30 82652 8192000000 10836168560 11308572672 1857074064 18.480 96 9 18 0 1874137584 14387072 2676448
00:39:02 45836 8192000000 10856507360 11318898688 1879741392 18.663 97 20 40 2 1901863056 16724560 5397104
00:39:58 66178 8192000000 10866287264 11338051584 1886409344 18.717 97 18 36 2 1907462304 15233552 5819408
00:41:11 32026 8192000000 10845007408 11296104448 1864635648 18.541 97 22 44 0 1882553008 11458384 6458976
00:41:50 81115 8192000000 10864774768 11327868928 1901949024 18.842 99 16 32 4 1922971872 16563344 4459504
00:43:24 74760 8192000000 10849164416 11329916928 1856359072 18.474 96 12 24 0 1872929568 13154736 3415760
00:44:58 47379 8192000000 10867635664 11331588096 1917036624 18.963 99 30 60 0 1934769936 9627504 8105808
00:45:56 55568 8192000000 10874270208 11332980736 1907412288 18.886 98 23 46 0 1923064656 9299616 6352752
00:47:01 17416 8192000000 10894271264 11336892416 1940091024 19.147 100 47 94 1 1962407440 9857344 12459072
00:47:25 48560 8192000000 10870369232 11343056896 1911862416 18.922 99 30 60 1 1933962336 13695552 8404368
00:48:28 72158 8192000000 10871213520 11369787392 1936500000 19.119 100 8 17 0 1962943744 23904416 2539328
00:49:46 60183 8192000000 10888775184 11338047488 1928408528 19.054 99 22 43 2 1945840032 11202016 6229488
00:50:54 101827 8192000000 10881689712 11346984960 1950841024 19.233 100 41 81 1 1972563040 10276784 11445232
00:52:42 10849 8192000000 10879248464 11324465152 1931684896 19.080 99 38 76 1 1950941888 8480768 10776224
00:53:00 38938 8192000000 10842280016 11330203648 1907439840 18.886 98 32 64 0 1925571744 9217952 8913952
00:53:45 51154 8192000000 10843498944 11322572800 1918510016 18.975 99 9 18 1 1928624592 7414080 2700496
00:54:45 76878 8192000000 10867114656 11352768512 1939973744 19.147 100 5 10 0 1949531568 8277776 1280048
00:56:08 49265 8192000000 10886507296 11367387136 1954935808 19.266 100 14 28 1 1971182864 12136192 4110864
00:57:04 49160 8192000000 10878297952 11374325760 1956821440 19.281 100 11 23 1 1974476480 14490720 3164320
00:57:59 16737 8192000000 10878375008 11375583232 1956321296 19.277 100 2 4 0 1969695200 13235312 138592
00:58:22 64019 8192000000 10895092496 11363536896 1929618160 19.064 98 17 34 0 1942288016 7998688 4671168
00:59:32 39913 8192000000 10872688784 11342860288 1907849616 18.889 97 16 32 0 1918743952 6671712 4222624
01:00:18 48779 8192000000 10890157680 11355119616 1907037328 18.883 97 20 40 1 1920260672 8051584 5171760
01:01:21 63912 8192000000 10876665504 11358531584 1923310880 19.013 98 17 34 2 1937230480 9631232 4288368
01:02:31 40656 8192000000 10894745744 11365191680 1946942272 19.202 99 21 40 2 1964807888 12211888 5653728
01:03:18 55772 8192000000 10916364656 11389145088 1962962144 19.330 99 28 56 1 1987638960 16308880 8367936
01:04:30 68515 8192000000 10905313328 11384713216 1919278144 18.981 97 15 28 1 1943392368 19880176 4234048
01:05:45 45713 8192000000 10911682848 11377848320 1924666976 19.024 98 19 38 1 1952301744 22242592 5392176
01:06:43 29624 8192000000 10916434560 11390115840 1970358976 19.388 100 44 88 0 2008929344 25162480 13407888
01:07:50 67613 8192000000 10894380080 11369410560 1951898160 19.242 99 23 46 0 1968970432 10117680 6954592
01:09:10 61313 8192000000 10905193472 11397533696 1975950880 19.433 100 10 20 0 1990724320 12200960 2572480
01:10:27 31588 8192000000 10927323472 11387654144 1948488656 19.214 98 33 66 0 1967426240 10104848 8832736
01:11:06 24573 8192000000 10933803248 11392167936 1986483648 19.516 100 51 100 0 2012759632 12361408 13914576
01:11:38 97903 8192000000 10876326208 11352829952 1873686976 18.614 95 23 46 1 1890843200 10217744 6938480
01:13:25 77776 8192000000 10879691296 11362095104 1942698512 19.168 99 21 42 0 1956229488 7892240 5638736
01:15:03 25414 8192000000 10876328544 11348688896 1922961920 19.011 98 21 42 1 1939727616 9969248 6796448
01:15:56 47677 8192000000 10876004624 11355807744 1931735456 19.081 99 8 16 0 1945285728 11081968 2468304
01:16:53 47516 8192000000 10872178144 11364376576 1938811120 19.137 99 8 16 0 1955106448 13407200 2888128
01:17:48 35444 8192000000 10853199584 11334914048 1881313136 18.676 96 10 19 0 1896701168 12992928 2395104
01:18:43 93516 8192000000 10831837312 11310813184 1862795776 18.526 95 23 46 0 1884515776 14304128 7415872
01:20:43 67451 8192000000 10858292576 11342077952 1914118304 18.940 99 10 20 0 1923335376 6664960 2552112
01:22:26 53473 8192000000 10875834544 11340820480 1891424928 18.757 97 20 40 0 1904832736 7429088 5978720
01:23:27 63799 8192000000 10883003216 11360997376 1961185920 19.315 100 24 48 0 1976404624 8348752 6869952
01:24:37 47938 8192000000 10885109312 11353452544 1897428944 18.806 97 25 50 2 1913230704 8546752 7255008
01:25:39 38376 8192000000 10879512960 11363729408 1937601968 19.128 99 27 54 1 1957827168 12726912 7498288
01:26:40 66681 8192000000 9248232176 9552449536 348955520 4.085 18 6 11 0 352290208 2090864 1243824

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 01:28:42 to 13-06-2021 01:29:14.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 94 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-06-2021 01:29:15 to 13-06-2021 01:29:17.

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          242190
MON$OLDEST_ACTIVE               242191
MON$OLDEST_SNAPSHOT             242191
MON$NEXT_TRANSACTION            242191
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                       2027296
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 ---
:61: 
:62: mscs-test-161.budzdorov.ru    Sun Jun 13 01:27:49 2021
:63:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:64: 
:65: 
:66: mscs-test-161.budzdorov.ru    Sun Jun 13 01:27:49 2021
:67:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:68: 
:69: 
:70: mscs-test-161.budzdorov.ru    Sun Jun 13 01:27:49 2021
:71:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:72: 
--- end of diff output ---

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

13.06.21 01:29:18. 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 01:29:20 No severe PSQL-related problems occured
13.06.21 01:29:21. End of report.