Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.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 17123068 kB
MemAvailable 31417104 kB
Buffers 0 kB
Cached 14526296 kB
SwapCached 80 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-10 01:27:41
DTS_END                         2021-06-10 01:27:41.3230
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57262
TRN_ID                          243809
ATT_ID                          714
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: 9604.72 19651 1152566
customer order: creation 179.63 330 21555
customer order: refuse 15.08 383 1810
order to supplier: creation 47.29 1262 5675
order to supplier: removal 3.63 101809 435
invoice (draft): creation 48.02 3611 5762
invoice (draft): removal 54.96 816 6595
invoice accept: apply 42.97 18026 5156
invoice accept: cancel 48.80 801 5856
customer reserve: creation 4044.47 174 485336
customer reserve: removal 4822.80 60 578736
realization accept: apply 86.83 177 10420
realization accept: cancel 76.51 112 9181
payment from customer: creation 61.36 100 7363
payment from customer: removal 5.81 87 697
payment to supplier: creation 50.76 124 6091
payment to supplier: removal 3.40 81 408
service: total inventory turnovers 4.94 1141 593
service: total monetary turnovers 6.55 26 786
service: aggregate perf. data 0.89 21181 107
service: refresh index statistics 0.03 242724 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-06-2021 01:28:52 to 10-06-2021 01:28:54.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2192
TEST_TIME 2 3277
TEST_TIME 3 3674
TEST_TIME 4 3503
TEST_TIME 5 3683
TEST_TIME 6 4038
TEST_TIME 7 4650
TEST_TIME 8 5114
TEST_TIME 9 5582
TEST_TIME 10 5919
TEST_TIME 11 6080
TEST_TIME 12 6047
TEST_TIME 13 6034
TEST_TIME 14 6137
TEST_TIME 15 6363
TEST_TIME 16 6406
TEST_TIME 17 6937
TEST_TIME 18 7329
TEST_TIME 19 7515
TEST_TIME 20 7594
TEST_TIME 21 7986
TEST_TIME 22 8374
TEST_TIME 23 8527
TEST_TIME 24 8800
TEST_TIME 25 9351
TEST_TIME 26 9317
TEST_TIME 27 9370
TEST_TIME 28 9439
TEST_TIME 29 10161
TEST_TIME 30 10782
TEST_TIME 31 10975
TEST_TIME 32 10792
TEST_TIME 33 10632
TEST_TIME 34 10613
TEST_TIME 35 10827
TEST_TIME 36 10853
TEST_TIME 37 10766
TEST_TIME 38 10743
TEST_TIME 39 10535
TEST_TIME 40 10382
TEST_TIME 41 10398
TEST_TIME 42 10426
TEST_TIME 43 10279
TEST_TIME 44 10189
TEST_TIME 45 10256
TEST_TIME 46 10194
TEST_TIME 47 10136
TEST_TIME 48 10285
TEST_TIME 49 10208
TEST_TIME 50 10093
TEST_TIME 51 10108
TEST_TIME 52 10035
TEST_TIME 53 9922
TEST_TIME 54 9858
TEST_TIME 55 9888
TEST_TIME 56 9782
TEST_TIME 57 9772
TEST_TIME 58 9657
TEST_TIME 59 9728
TEST_TIME 60 9768
TEST_TIME 61 9716
TEST_TIME 62 9751
TEST_TIME 63 9790
TEST_TIME 64 9803
TEST_TIME 65 9747
TEST_TIME 66 9799
TEST_TIME 67 9832
TEST_TIME 68 9818
TEST_TIME 69 9915
TEST_TIME 70 9904
TEST_TIME 71 9871
TEST_TIME 72 10015
TEST_TIME 73 9997
TEST_TIME 74 10009
TEST_TIME 75 9886
TEST_TIME 76 9968
TEST_TIME 77 9893
TEST_TIME 78 9843
TEST_TIME 79 9856
TEST_TIME 80 9780
TEST_TIME 81 9769
TEST_TIME 82 9725
TEST_TIME 83 9679
TEST_TIME 84 9666
TEST_TIME 85 9710
TEST_TIME 86 9651
TEST_TIME 87 9667
TEST_TIME 88 9700
TEST_TIME 89 9734
TEST_TIME 90 9836
TEST_TIME 91 9780
TEST_TIME 92 9854
TEST_TIME 93 9887
TEST_TIME 94 9916
TEST_TIME 95 9900
TEST_TIME 96 9906
TEST_TIME 97 9920
TEST_TIME 98 9954
TEST_TIME 99 9948
TEST_TIME 100 9906
TEST_TIME 101 9829
TEST_TIME 102 9870
TEST_TIME 103 9821
TEST_TIME 104 9820
TEST_TIME 105 9779
TEST_TIME 106 9750
TEST_TIME 107 9734
TEST_TIME 108 9714
TEST_TIME 109 9649
TEST_TIME 110 9622
TEST_TIME 111 9578
TEST_TIME 112 9568
TEST_TIME 113 9559
TEST_TIME 114 9573
TEST_TIME 115 9585
TEST_TIME 116 9578
TEST_TIME 117 9584
TEST_TIME 118 9612
TEST_TIME 119 9644
TEST_TIME 120 9608

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-06-2021 01:28:56 to 10-06-2021 01:28:59.

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 1602379 1602379 0 0.00 0 19209 6 0 0
doc_list_biud 1602378 1602378 0 0.00 0 51216 28 0 0
sp_add_invoice_to_stock 5264 5156 108 2.05 26 143788 18026 0 108
sp_cancel_adding_invoice 5856 5856 0 0.00 5 68264 802 0 0
sp_cancel_client_order 1810 1810 0 0.00 4 15666 383 0 0
sp_cancel_customer_reserve 578736 578736 0 0.00 1 51217 60 0 0
sp_cancel_pay_from_customer 697 697 0 0.00 2 8263 88 0 0
sp_cancel_pay_to_supplier 408 408 0 0.00 3 5348 82 0 0
sp_cancel_supplier_invoice 6607 6595 12 0.18 1 20302 817 0 12
sp_cancel_supplier_order 435 435 0 0.00 7 1271967 101809 0 0
sp_cancel_write_off 9181 9181 0 0.00 1 9645 113 0 0
sp_client_order 21555 21555 0 0.00 4 15775 330 0 0
sp_customer_reserve 485336 485336 0 0.00 0 40877 174 0 0
sp_fill_shopping_cart 32982 32982 0 0.00 1 9117 37 0 0
sp_fill_shopping_cart_clo_res 485327 485327 0 0.00 0 19616 13 0 0
sp_get_clo_for_invoice 5147 5147 0 0.00 0 18992 292 0 0
sp_kill_cost_storno 16142 16142 0 0.00 0 7776 59 0 0
sp_kill_qstorno_ret_qs2qd 1173683 1173683 0 0.00 0 51209 33 0 0
sp_kill_qty_storno 618180 618180 0 0.00 0 51216 71 0 0
sp_lock_selected_doc 21428 21428 0 0.00 0 10289 6 0 0
sp_make_cost_storno 29021 29021 0 0.00 0 19191 54 0 0
sp_multiply_rows_for_pdistr 29021 29021 0 0.00 0 7452 28 0 0
sp_multiply_rows_for_qdistr 21555 21555 0 0.00 0 14965 152 0 0
sp_pay_from_customer 7363 7363 0 0.00 4 12259 101 0 0
sp_pay_to_supplier 6091 6091 0 0.00 5 10222 125 0 0
sp_payment_common 13454 13454 0 0.00 1 11530 30 0 0
sp_qd_handle_on_cancel_clo 1810 1810 0 0.00 0 15659 348 0 0
sp_qd_handle_on_invoice_upd_sts 11003 11003 0 0.00 0 19420 330 0 0
sp_qd_handle_on_reserve_upd_sts 10420 10420 0 0.00 0 16780 60 0 0
sp_reserve_write_off 10420 10420 0 0.00 6 16792 177 0 0
sp_supplier_invoice 5762 5762 0 0.00 6 98387 3611 0 0
sp_supplier_order 5675 5675 0 0.00 5 20949 1263 0 0
srv_aggregate_perf_data 107 107 0 0.00 2261 148466 21181 0 0
srv_fill_mon_cache_memory 173 173 0 0.00 1158 154938 28268 0 0
srv_find_qd_qs_mism 1103006 1103006 0 0.00 0 11465 5 0 0
srv_make_invnt_saldo 593 593 0 0.00 35 61880 1142 0 0
srv_make_money_saldo 786 786 0 0.00 1 1534 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 80119 448159 242725 0 0
t$perf-abend:sp_add_invoice_to_stock 108 108 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5156 5156 0 0.00 0 9456 158 0 0
t$perf-norm:sp_cancel_adding_invoice 394 394 0 0.00 0 5065 124 0 0
t$perf-norm:sp_cancel_client_order 1810 1810 0 0.00 0 7058 17 0 0
t$perf-norm:sp_cancel_customer_reserve 670 670 0 0.00 0 1020 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 697 697 0 0.00 0 5367 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 408 408 0 0.00 0 440 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 428 428 0 0.00 0 985 7 0 0
t$perf-norm:sp_cancel_supplier_order 435 435 0 0.00 0 20162 1637 0 0
t$perf-norm:sp_cancel_write_off 1019 1019 0 0.00 0 2176 10 0 0
t$perf-norm:sp_client_order 21555 21555 0 0.00 0 10242 19 0 0
t$perf-norm:sp_customer_reserve 1069 1069 0 0.00 0 1090 5 0 0
t$perf-norm:sp_pay_from_customer 7363 7363 0 0.00 0 6389 12 0 0
t$perf-norm:sp_pay_to_supplier 6091 6091 0 0.00 0 6535 11 0 0
t$perf-norm:sp_reserve_write_off 10420 10420 0 0.00 0 5476 9 0 0
t$perf-norm:sp_supplier_invoice 5762 5762 0 0.00 0 5831 24 0 0
t$perf-norm:sp_supplier_order 5675 5675 0 0.00 0 3715 13 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 389 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 3847 31 0 0
t$perf-norm:srv_make_invnt_saldo 593 593 0 0.00 0 1726 22 0 0
t$perf-norm:srv_make_money_saldo 786 786 0 0.00 0 2361 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 10510 10294 216 2.05 0 12169 22 0 216
v_all_customers 39136 39136 0 0.00 0 125 1 0 0
v_all_suppliers 31772 31772 0 0.00 0 75 1 0 0
v_all_wares 43108 43108 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 788 788 0 0.00 0 320 6 0 0
v_cancel_client_order 3620 3620 0 0.00 0 2889 5 0 0
v_cancel_customer_prepayment 1394 1394 0 0.00 0 3242 9 0 0
v_cancel_customer_reserve 1340 1340 0 0.00 0 5256 12 0 0
v_cancel_payment_to_supplier 816 816 0 0.00 0 3758 10 0 0
v_cancel_supplier_invoice 880 856 24 2.72 0 6098 23 0 24
v_cancel_supplier_order 870 870 0 0.00 0 353 4 0 0
v_cancel_write_off 2038 2038 0 0.00 0 6183 21 0 0
v_max_id_clo_ord 5674 5674 0 0.00 0 2370 2 0 0
v_max_id_clo_res 1069 1069 0 0.00 0 3221 15 0 0
v_max_id_ord_sup 5754 5754 0 0.00 0 5545 5 0 0
v_max_non_paid_invoice 1633 1633 0 0.00 0 2689 5 0 0
v_max_non_paid_realizn 3980 3980 0 0.00 0 2071 4 0 0
v_min_id_clo_ord 5674 5674 0 0.00 0 3463 7 0 0
v_min_id_clo_res 1069 1069 0 0.00 0 8376 25 0 0
v_min_id_ord_sup 5754 5754 0 0.00 0 7164 10 0 0
v_min_non_paid_invoice 6091 6091 0 0.00 0 7213 18 0 0
v_min_non_paid_realizn 7363 7363 0 0.00 0 8763 19 0 0
v_our_firm 10738 10738 0 0.00 0 95 1 0 0
v_reserve_write_off 20840 20840 0 0.00 0 6221 5 0 0
x_lock_depdocs_on_canc_invoice 12023 12023 0 0.00 0 19873 115 0 0
x_lock_depdocs_on_canc_sup_ord 435 435 0 0.00 0 6694 380 0 0
x_make_qstorno_1000_1200 5675 5675 0 0.00 1 20939 1183 0 0
x_make_qstorno_1200_2000 5762 5762 0 0.00 2 98342 3478 0 0
x_make_qstorno_2100_3300 485336 485336 0 0.00 0 40875 158 0 0

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

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:45 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:51 18255 8192000000 10247589232 10550403072 943315936 10.326 75 55 109 1 963798912 2698992 17783984
22:58:19 16584 8192000000 10319562528 10632318976 1369409456 14.322 100 90 180 0 1404110528 4510304 30190768
22:58:44 32369 8192000000 10367947120 10688065536 1414419984 14.723 100 93 186 0 1450581792 6007504 30154304
22:59:30 10751 8192000000 10377377376 10699087872 1432972544 14.888 100 91 182 1 1470275824 7236736 30066544
22:59:51 31128 8192000000 10403582800 10728194048 1453419152 15.068 100 87 174 0 1489370544 7586256 28365136
23:00:32 21185 8192000000 10421440192 10749063168 1471025888 15.223 100 86 172 0 1507183040 8322864 27834288
23:01:03 23868 8192000000 10446010608 10780794880 1499797920 15.474 100 89 179 0 1536883088 8658976 28426192
23:01:35 22314 8192000000 10479051408 10819608576 1522060160 15.668 100 81 162 0 1555593856 8808160 24725536
23:02:10 13114 8192000000 10495508800 10843549696 1556517840 15.966 100 83 166 1 1591954256 9467952 25968464
23:02:36 17510 8192000000 10533278656 10887180288 1590685184 16.260 100 79 158 1 1624339440 9444304 24209952
23:03:02 17773 8192000000 10562819200 10919677952 1615311328 16.470 100 82 164 0 1650094192 9990304 24792560
23:03:27 8403 8192000000 10580774144 10942623744 1643321904 16.708 100 82 164 1 1679023696 11278480 24423312
23:03:47 12608 8192000000 10593543088 10960334848 1652544128 16.786 100 74 145 1 1684738144 10515312 21678704
23:04:09 10271 8192000000 10623449920 10989391872 1673857856 16.966 100 77 154 0 1708290224 11826192 22606176
23:04:27 10153 8192000000 10635288000 11003351040 1693942112 17.134 100 78 156 2 1729356496 12478496 22935888
23:04:45 7189 8192000000 10651156912 11018641408 1707106736 17.245 100 85 171 3 1745234960 13324976 24803248
23:04:59 8392 8192000000 10664026304 11033587712 1717183136 17.329 100 76 151 2 1752250464 13296752 21770576
23:05:16 7549 8192000000 10677602096 11053268992 1733053088 17.461 100 84 168 2 1771612848 13962080 24597680
23:05:29 7885 8192000000 10682767712 11058778112 1742784480 17.542 100 88 175 2 1780683360 13084784 24814096
23:05:44 6956 8192000000 10691176720 11071066112 1751962192 17.618 100 79 158 0 1787212000 13013024 22236784
23:05:58 5434 8192000000 10703519280 11079593984 1766080080 17.735 100 83 161 3 1802431232 12811104 23540048
23:06:11 4565 8192000000 10716546592 11093741568 1776816912 17.823 100 89 176 3 1814251776 12479952 24954912
23:06:22 3840 8192000000 10726653600 11107332096 1785639872 17.896 100 83 166 2 1822466864 13317824 23509168
23:06:32 4213 8192000000 10733712432 11112853504 1790894416 17.939 100 85 170 2 1829260720 14143552 24222752
23:06:43 3667 8192000000 10734266112 11119828992 1795576928 17.978 100 85 168 0 1832228368 14230224 22421216
23:06:54 2087 8192000000 10741468320 11122139136 1802189168 18.032 100 88 176 1 1842105472 15404416 24511888
23:07:03 8115 8192000000 10749563104 11135954944 1813503840 18.125 100 94 188 1 1854386016 15750832 25131344
23:07:23 6427 8192000000 10750406928 11138940928 1813428896 18.124 100 85 164 3 1851713600 15360096 22924608
23:07:36 2213 8192000000 10776587520 11159732224 1828475712 18.247 100 90 178 1 1868727664 14924352 25327600
23:07:45 2056 8192000000 10777124000 11162710016 1837738544 18.322 100 93 182 3 1878274992 14600016 25936432
23:07:53 1248 8192000000 10779228560 11165712384 1841931168 18.357 100 92 186 0 1881602848 14926288 24745392
23:08:02 2439 8192000000 10787722448 11175047168 1843174768 18.367 100 90 176 0 1882894096 14421296 25298032
23:08:11 2737 8192000000 10800315920 11185381376 1854134720 18.456 100 88 175 1 1892463312 13385168 24943424
23:08:20 2109 8192000000 10803205408 11188936704 1862000304 18.519 100 94 187 2 1903082064 14280384 26801376
23:08:29 2575 8192000000 10803614192 11195150336 1865359552 18.547 100 89 180 0 1903081152 12672176 25049424
23:08:38 2026 8192000000 10809999552 11196256256 1864817424 18.542 100 93 186 0 1905009600 14248448 25943728
23:08:47 1237 8192000000 10810867744 11200200704 1868977552 18.576 100 95 190 1 1909182192 12682576 27522064
23:08:54 1480 8192000000 10819047120 11207634944 1872783760 18.607 100 93 186 1 1911131200 11705888 26641552
23:09:02 1374 8192000000 10812408864 11209629696 1873167600 18.610 100 84 166 0 1910518736 13355088 23996048
23:09:12 2967 8192000000 10820456448 11212288000 1877608624 18.646 100 75 149 1 1910653312 11423440 21621248
23:09:21 1853 8192000000 10823492928 11217969152 1883767168 18.696 100 93 185 0 1924112176 13063488 27281520
23:09:31 4055 8192000000 10823334592 11218395136 1882729712 18.687 100 85 170 2 1919159040 12649712 23779616
23:09:41 13585 8192000000 10810112000 11217285120 1883862000 18.696 100 62 124 0 1912396496 11656704 16877792
23:10:03 31745 8192000000 10783851264 11209957376 1876151952 18.634 100 28 56 0 1890482224 5746768 8583504
23:10:43 6092 8192000000 10791201520 11213651968 1881400880 18.676 100 28 56 1 1895968288 6890032 7677376
23:10:56 5243 8192000000 10801155104 11221663744 1881832544 18.680 100 36 72 0 1900600816 8763984 10004288
23:11:08 9309 8192000000 10796466032 11224502272 1881935904 18.681 100 22 44 1 1898911680 10661104 6314672
23:11:25 9903 8192000000 10786297008 11221004288 1883293680 18.692 100 29 56 3 1897989360 6697792 7997888
23:11:41 7157 8192000000 10794624528 11226718208 1885623360 18.710 100 25 51 0 1898896064 6531072 6741632
23:11:59 10408 8192000000 10802641344 11227148288 1884044784 18.698 100 10 20 0 1896606768 10016320 2545664
23:12:16 14209 8192000000 10792219904 11227160576 1887558352 18.726 100 18 36 0 1899130208 6510528 5061328
23:12:36 14875 8192000000 10794010656 11227557888 1889340240 18.740 100 18 36 2 1900240320 5799520 5100560
23:12:59 6471 8192000000 10794119408 11228946432 1890424160 18.749 100 15 30 0 1900145920 5371200 4350560
23:13:12 10199 8192000000 10816965536 11236962304 1893082048 18.771 100 28 56 1 1907159936 5841328 8236560
23:13:34 16893 8192000000 10801850176 11237048320 1893208032 18.772 100 12 24 0 1902150064 6087152 2854880
23:14:05 41950 8192000000 10804250752 11245228032 1897635872 18.807 100 26 52 0 1909830272 5179280 7015120
23:15:17 16636 8192000000 10815339056 11246542848 1882687744 18.687 99 35 70 1 1899572400 7248176 9636480
23:15:42 11140 8192000000 10802678128 11242745856 1895187440 18.788 100 14 28 0 1905399024 5804032 4407552
23:16:02 11663 8192000000 10811858128 11245522944 1900557808 18.831 100 18 37 1 1911090640 5649040 4883792
23:16:22 6629 8192000000 10816972688 11250483200 1881783584 18.680 99 27 52 1 1895729648 6303104 7642960
23:16:38 4512 8192000000 10823109600 11250155520 1882602800 18.686 99 22 44 0 1894401680 5368816 6430064
23:16:49 9327 8192000000 10802842272 11240300544 1879989824 18.665 99 24 47 2 1892367936 5961008 6417104
23:17:08 12209 8192000000 10809799216 11244896256 1893601616 18.775 100 23 46 1 1905907280 5630064 6675600
23:17:30 5382 8192000000 10813938816 11250323456 1901493136 18.838 100 27 52 2 1915465760 6121168 7851456
23:17:42 9128 8192000000 10788127488 11220017152 1845879232 18.389 97 18 36 1 1856785328 5836496 5069600
23:18:00 13037 8192000000 10802162240 11235176448 1869562288 18.581 99 18 35 0 1879807040 4949616 5295136
23:18:21 10343 8192000000 10792748384 11224514560 1820078224 18.178 96 18 36 1 1831170624 5560464 5531936
23:18:39 11888 8192000000 10727153024 11142131712 1729051696 17.428 93 24 48 2 1745761760 9589488 7120576
23:18:58 14421 8192000000 10764829952 11188588544 1786409760 17.902 97 14 29 3 1795787088 5359664 4017664
23:19:18 54748 8192000000 10752408176 11171848192 1760150400 17.686 95 26 52 0 1773050768 5306416 7593952
23:20:22 14728 8192000000 10694100368 11119554560 1650088752 16.765 90 18 35 0 1660333632 5021376 5223504
23:20:50 4186 8192000000 10707449888 11125694464 1765956864 17.734 98 28 56 2 1780952208 6492688 8502656
23:21:04 8716 8192000000 10727491408 11134238720 1776650800 17.822 98 29 58 0 1790201632 4973312 8577520
23:21:21 11328 8192000000 10710117344 11124301824 1724511760 17.390 95 21 42 1 1736113792 5191744 6410288
23:21:43 6081 8192000000 10711999600 11120271360 1748395312 17.588 97 26 52 2 1761859728 5703504 7760912
23:21:55 6081 8192000000 10691421120 11108732928 1739024352 17.511 97 35 69 4 1755225008 5752432 10448224
23:22:08 7976 8192000000 10694606432 11110273024 1770750080 17.773 99 24 48 1 1784224432 5539136 7935216
23:22:23 6453 8192000000 10709917968 11125096448 1766815264 17.741 98 27 54 3 1780222352 5470176 7936912
23:22:37 4953 8192000000 10725180368 11142885376 1806622608 18.068 100 27 54 2 1820558064 5266656 8668800
23:22:49 10090 8192000000 10725059872 11143331840 1790480960 17.936 99 23 46 0 1802793520 5564080 6748480
23:23:09 9006 8192000000 10741558928 11164184576 1821387056 18.189 100 21 42 1 1833710272 5007888 7315328
23:23:25 6678 8192000000 10759521616 11179282432 1834803216 18.298 100 32 64 1 1850524880 6411088 9310576
23:23:41 8133 8192000000 10732909376 11162157056 1810203552 18.098 99 19 38 1 1822365824 5399728 6762544
23:24:00 13981 8192000000 10760158704 11176927232 1817768400 18.159 99 18 32 0 1828378960 4727600 5882960
23:24:21 69801 8192000000 10752361456 11188817920 1851345728 18.433 100 33 66 2 1867125696 6117888 9662080
23:25:38 10228 8192000000 10784801392 11206803456 1857706960 18.485 100 26 52 1 1870374592 5992768 6674864
23:25:58 5032 8192000000 10785371520 11210108928 1865755184 18.550 100 30 60 3 1881371152 6849968 8766000
23:26:12 7057 8192000000 10787654160 11211788288 1864805744 18.542 100 24 48 4 1877542832 6439664 6297424
23:26:27 8285 8192000000 10784137104 11214483456 1870033696 18.585 100 30 60 1 1885293536 6562928 8696912
23:26:46 6116 8192000000 10792274336 11214479360 1870596640 18.589 100 18 36 0 1881015392 5347280 5071472
23:27:00 7341 8192000000 10799225168 11226689536 1879008384 18.657 100 45 86 2 1897969376 7354608 11606384
23:27:17 6581 8192000000 10804117520 11235667968 1891687360 18.759 100 21 42 1 1903175648 4751856 6736432
23:27:29 13697 8192000000 10815537136 11243065344 1896866256 18.801 100 22 44 0 1908446112 4865440 6714416
23:28:04 14991 8192000000 10843987504 11261890560 1909723968 18.904 100 41 82 1 1927820736 5995360 12101408
23:28:28 36019 8192000000 10855677680 11277762560 1920769520 18.993 100 51 102 1 1948513472 12535056 15208896
23:29:14 21928 8192000000 10862702448 11286757376 1928348176 19.054 100 46 92 2 1950754816 8893904 13512736
23:29:44 12311 8192000000 10872409872 11296714752 1938445728 19.134 100 49 96 2 1960985760 7704656 14835376
23:30:09 34948 8192000000 10880477552 11312570368 1948424672 19.214 100 36 72 0 1969401840 10375296 10601872
23:30:50 10557 8192000000 10891638208 11316695040 1955068336 19.267 100 44 88 3 1979679408 11212528 13398544
23:31:08 26283 8192000000 10898625648 11329236992 1956271392 19.276 100 46 89 1 1980953200 12436304 12245504
23:31:46 35712 8192000000 10900568112 11335766016 1966912512 19.361 100 46 92 4 1995750896 15601680 13236704
23:32:49 23668 8192000000 10902650992 11341299712 1968507024 19.374 100 43 86 2 1999081264 17730208 12844032
23:33:26 29641 8192000000 10896029600 11332460544 1954993680 19.266 99 32 64 2 1982130944 17852160 9285104
23:34:05 16052 8192000000 10915693168 11346935808 1972108640 19.402 100 50 97 1 2005605424 19094064 14402720
23:34:36 4764 8192000000 10919513120 11353542656 1973931040 19.417 100 45 90 1 2009649248 22024272 13693936
23:34:48 4494 8192000000 10931760496 11359674368 1983447248 19.492 100 65 131 1 2022352464 19436288 19468928
23:34:59 9231 8192000000 10940538016 11367870464 1989926880 19.543 100 65 130 2 2030887248 21853792 19106576
23:35:17 7213 8192000000 10946061632 11371393024 1986510176 19.516 100 58 117 0 2027255712 23523600 17221936
23:35:32 6934 8192000000 10942270848 11375562752 1991563664 19.556 100 63 126 1 2032860816 22837920 18459232
23:35:47 4334 8192000000 10953544496 11376156672 1992823120 19.566 100 83 164 1 2040267744 24055056 23389568
23:36:03 20288 8192000000 10952751504 11380420608 1997471712 19.603 100 73 146 1 2043525712 24934336 21119664
23:36:33 3535 8192000000 10953157088 11377446912 1981493488 19.477 99 73 144 0 2027675984 25301152 20881344
23:36:50 4890 8192000000 10948695136 11379572736 1996103616 19.592 100 71 139 3 2041820464 25728272 19988576
23:37:03 9125 8192000000 10962957008 11389865984 2002067952 19.639 100 75 149 2 2050135104 26374992 21692160
23:37:22 9020 8192000000 10976214560 11398672384 2010361424 19.704 100 70 139 0 2058525520 27205744 20958352
23:37:38 4035 8192000000 10979335984 11406860288 2012546176 19.722 100 72 144 2 2063426624 29292224 21588224
23:37:57 9945 8192000000 10972388864 11411357696 2015780624 19.747 100 54 109 0 2059804400 27555104 16468672
23:38:16 6128 8192000000 10976586384 11410968576 1998688416 19.612 99 59 118 1 2053693664 37275488 17729760
23:38:30 16649 8192000000 10965943472 11415273472 2016830320 19.755 100 51 102 2 2066130400 33890624 15409456
23:38:58 4476 8192000000 10970833680 11410980864 2012003072 19.717 100 37 73 4 2051657776 28389328 11265376
23:39:10 3870 8192000000 10966863952 11406368768 1996849264 19.598 99 56 111 3 2039959744 26746400 16364080
23:39:25 13791 8192000000 10963991664 11403177984 1993464752 19.571 99 47 92 0 2035926032 28279936 14181344
23:39:47 5292 8192000000 10962220480 11398860800 2004223296 19.656 100 67 134 3 2057904256 33335712 20345248
23:40:01 8592 8192000000 10973323248 11401883648 2004310400 19.657 100 57 115 0 2051063152 29791376 16961376
23:40:17 8207 8192000000 10979870288 11409174528 2010152592 19.703 100 72 142 2 2063729632 30955600 22621440
23:40:33 2798 8192000000 10984673280 11411828736 2017290576 19.759 100 70 141 2 2070763216 31515168 21957472
23:40:42 7089 8192000000 10990894224 11415457792 2005925504 19.669 99 81 162 1 2064206352 33554464 24726384
23:40:59 9670 8192000000 10994478272 11424423936 2024815040 19.818 100 68 137 0 2081744576 36065936 20863600
23:41:18 4199 8192000000 10986062288 11427385344 2028529392 19.847 100 65 129 3 2084835952 35888832 20417728
23:41:33 2027 8192000000 11003609040 11437019136 2027606528 19.840 100 51 100 2 2083102528 39406736 16089264
23:41:43 3267 8192000000 11013283024 11441356800 2039907936 19.936 100 73 144 3 2098255872 35977216 22370720
23:41:54 5365 8192000000 11001387024 11427688448 2008048240 19.686 99 80 161 0 2072159600 38622096 25489264
23:42:09 9455 8192000000 10968680368 11397988352 1981020128 19.473 98 65 128 1 2040948304 39940784 19987392
23:42:26 4911 8192000000 10963601472 11386568704 1954936448 19.266 97 73 146 0 2020838528 42518576 23383504
23:42:38 1432 8192000000 10987101664 11413884928 2006911312 19.677 100 73 143 2 2071066352 41629168 22525872
23:42:46 4765 8192000000 10977186032 11412172800 2007348928 19.681 100 69 138 2 2072102496 42968272 21785296
23:42:59 4550 8192000000 10980680880 11404451840 2001252080 19.633 100 80 159 4 2066679600 40938736 24488784
23:43:13 1327 8192000000 10987202800 11407273984 1989365952 19.539 99 85 168 1 2059466400 43581904 26518544
23:43:21 2557 8192000000 11002325648 11422810112 2012938304 19.725 100 84 168 1 2085377152 46843872 25594976
23:43:33 3891 8192000000 10995439920 11419926528 2008671936 19.691 100 75 150 0 2078957072 47316544 22968592
23:43:43 2913 8192000000 11009944256 11433345024 2017421136 19.760 100 86 172 0 2092251520 48099728 26730656
23:43:54 9452 8192000000 10986952656 11410706432 1956713552 19.280 97 67 135 2 2026431968 48206032 21512384
23:44:12 4407 8192000000 10989655472 11412934656 1999032704 19.615 100 78 152 2 2072339888 49088992 24218192
23:44:23 2911 8192000000 10981480992 11400531968 1989837728 19.543 100 89 178 0 2063488480 45737376 27913376
23:44:33 4250 8192000000 10978204512 11400343552 1993267056 19.570 100 73 144 1 2060246272 44530448 22448768
23:44:45 2026 8192000000 10987426528 11407536128 1981718448 19.478 99 78 156 0 2050672304 45017920 23935936
23:44:56 2885 8192000000 10983434192 11412426752 2001782544 19.637 100 77 153 1 2069579968 44095552 23701872
23:45:07 4934 8192000000 10976048144 11404664832 1963538816 19.334 98 73 143 1 2030138480 43921808 22677856
23:45:22 4555 8192000000 10984930800 11402588160 1994060800 19.576 100 91 179 1 2068390048 46082592 28246656
23:45:37 3184 8192000000 10975308240 11408318464 1995256000 19.585 100 70 140 0 2062190416 43841344 23093072
23:45:47 5709 8192000000 10963656704 11390177280 1975744048 19.431 99 67 135 2 2041313584 43530448 22039088
23:46:02 3266 8192000000 10979429536 11398148096 1987950704 19.528 100 74 149 1 2055736480 44181856 23603920
23:46:13 4080 8192000000 10981389680 11404087296 1993009168 19.568 100 75 150 0 2064185392 46232832 24943392
23:46:25 2825 8192000000 10985856224 11404935168 1993656528 19.573 100 81 161 2 2063512880 44765056 25091296
23:46:36 2704 8192000000 10985666496 11401801728 1989276928 19.538 100 86 172 1 2063753248 47523136 26953184
23:46:46 2724 8192000000 10986109968 11401039872 1986626880 19.517 100 77 154 2 2058393424 48344640 23421904
23:46:56 3405 8192000000 10981187024 11397959680 1987756080 19.526 100 82 163 2 2060730528 47003360 25971088
23:47:05 7039 8192000000 10935461920 11362103296 1940829392 19.153 99 60 120 0 2007897296 47285232 19782672
23:47:22 9919 8192000000 10927407072 11365154816 1931431920 19.078 99 37 74 3 1991312112 47394736 12485456
23:47:42 2170 8192000000 10945790016 11370926080 1957105728 19.283 100 57 113 1 2023551552 48297584 18148240
23:47:55 2606 8192000000 10951054320 11381673984 1965022480 19.346 100 58 114 3 2035141664 50845728 19273456
23:48:07 3929 8192000000 10971961968 11392688128 1975776720 19.431 100 71 143 0 2050359392 52024928 22557744
23:48:18 4976 8192000000 10981511120 11395665920 1977345984 19.444 100 80 160 0 2056331200 53090784 25894432
23:48:30 3048 8192000000 10966891360 11375931392 1954618208 19.263 99 90 181 3 2038201888 55267840 28315840
23:48:40 3304 8192000000 10971529552 11394367488 1972747520 19.407 100 69 136 2 2048542480 54039760 21755200
23:48:50 5011 8192000000 10950182704 11378606080 1963252528 19.332 100 57 114 1 2034042672 51992832 18797312
23:49:04 6938 8192000000 10969674992 11389558784 1976602256 19.438 100 66 132 0 2042951456 44712880 21636320
23:49:19 2140 8192000000 10964499584 11382226944 1957997280 19.290 99 84 167 0 2031503408 46137712 27368416
23:49:30 1158 8192000000 10968217904 11384745984 1969947200 19.385 100 79 158 1 2043219088 48358848 24913040
23:49:41 4483 8192000000 10936153296 11358744576 1947273904 19.205 99 57 115 2 2009889056 44666448 17948704
23:49:53 10076 8192000000 10943408464 11385913344 1970244080 19.387 100 44 88 1 2031377264 46299456 14833728
23:50:11 17287 8192000000 10927890576 11369672704 1937574736 19.127 98 39 78 1 2000212288 49441200 13196352
23:50:42 5726 8192000000 10944603904 11378556928 1943577840 19.175 99 49 99 1 2009466064 49785936 16102288
23:50:56 7328 8192000000 10948240032 11383111680 1960898016 19.313 100 52 105 2 2027787712 49685040 17204656
23:51:14 7964 8192000000 10950629152 11388395520 1965513808 19.350 100 45 90 0 2032010816 50823312 15673696
23:51:34 1541 8192000000 10969704736 11399159808 1971551552 19.398 100 64 128 1 2047457024 54868400 21037072
23:51:45 7083 8192000000 10955838912 11402108928 1969175328 19.379 100 44 88 0 2038595552 54669872 14750352
23:52:24 15937 8192000000 10945696416 11402588160 1979532880 19.461 100 29 58 2 2032259408 42725056 10001472
23:52:46 14600 8192000000 10943081968 11400241152 1987148912 19.521 100 34 67 4 2040570736 42187424 11234400
23:53:07 29181 8192000000 10945674880 11400331264 1981466624 19.476 100 27 54 1 2027246304 36470224 9309456
23:53:49 21180 8192000000 10940475424 11400495104 1982337888 19.483 100 26 52 2 2030409440 38984208 9087344
23:54:42 19353 8192000000 10945782896 11408510976 1979818464 19.463 100 20 40 2 2023911840 37386112 6707264
23:55:25 35446 8192000000 10939209744 11395817472 1964702560 19.343 100 22 44 2 2027649040 54666752 8279728
23:56:07 16170 8192000000 10937656320 11400216576 1960984688 19.314 100 18 36 2 2018119984 50257040 6878256
23:56:54 17236 8192000000 10903256096 11375271936 1937429728 19.126 99 13 26 4 1975979488 33944960 4604800
23:57:18 25045 8192000000 10913038704 11390447616 1960563984 19.311 100 13 26 0 1992489280 28193232 3732064
23:57:53 40010 8192000000 10886265408 11372580864 1930473088 19.071 98 4 8 0 1953239632 21896640 869904
23:58:40 69775 8192000000 10928185872 11360894976 1913038272 18.931 97 29 57 3 1933795360 13809696 6947392
00:00:01 53991 8192000000 10915210320 11372052480 1961046512 19.314 99 36 72 0 1979458192 8231584 10180096
00:01:10 61391 8192000000 10903681888 11369164800 1945779872 19.193 98 23 47 2 1967966544 16109248 6077424
00:04:25 52025 8192000000 10890716048 11350130688 1951728464 19.240 100 27 52 2 1971959008 12135168 8095376
00:05:30 111575 8192000000 10886656912 11337834496 1926477152 19.039 98 35 70 1 1945576736 8574720 10524864
00:07:30 81956 8192000000 10870534272 11334873088 1896671200 18.800 97 26 52 1 1911457568 7820784 6965584
00:09:11 65597 8192000000 10908145760 11376443392 1952537056 19.247 99 40 78 4 1979710864 15346240 11827568
00:10:24 82019 8192000000 10898043456 11377094656 1952170896 19.244 99 9 18 0 1973851520 19339856 2340768
00:11:54 8378 8192000000 10910837392 11355140096 1955919216 19.274 99 40 80 1 1980715536 13023808 11772512
00:12:09 42978 8192000000 10881594576 11353673728 1945907536 19.194 99 23 46 1 1961455312 9031104 6516672
00:13:18 35350 8192000000 10902238416 11367530496 1966517952 19.358 100 15 30 2 1982203952 11046816 4639184
00:14:01 26439 8192000000 10900323232 11365507072 1954629952 19.263 99 28 58 0 1974358192 10791344 8936896
00:14:35 7418 8192000000 10929496992 11372400640 1978055088 19.449 100 57 112 1 2002523312 8338320 16129904
00:15:01 25185 8192000000 10922658720 11383296000 1981228272 19.474 100 48 95 0 2005867920 10937952 13701696
00:15:34 66979 8192000000 10899977600 11371491328 1959546096 19.302 99 23 46 0 1973994544 7674032 6774416
00:17:27 57465 8192000000 10899736048 11386249216 1981649600 19.478 100 12 25 0 1993314688 8289872 3375216
00:19:38 91513 8192000000 10922028304 11393806336 1989398960 19.539 100 11 23 0 1999156160 6652608 3104592
00:21:26 45386 8192000000 10891077840 11361005568 1928675840 19.056 97 31 62 0 1945308896 7082688 9550368
00:22:27 95083 8192000000 10883134192 11364118528 1916888496 18.962 97 10 20 1 1934878368 14885792 3104080
00:24:08 56486 8192000000 10906583824 11392245760 1977886800 19.448 100 22 44 0 1996469184 11672944 6909440
00:25:12 61436 8192000000 10902480496 11397681152 1984741952 19.502 100 17 34 0 2002178128 12338848 5097328
00:26:50 34094 8192000000 10892746816 11367829504 1916609056 18.960 97 17 34 2 1928538384 7577136 4352192
00:27:41 34361 8192000000 10848470736 11328442368 1872370736 18.603 96 11 22 0 1887394256 12095904 2927616
00:28:21 28467 8192000000 10882658224 11348316160 1949039440 19.219 100 19 38 0 1962297664 8174064 5084160
00:28:56 41535 8192000000 10878763968 11348537344 1933354096 19.094 99 17 34 0 1945282832 7756768 4171968
00:29:47 16471 8192000000 10850381840 11314720768 1873647488 18.614 96 23 46 5 1886969728 7285648 6036592
00:30:17 23539 8192000000 10874363136 11348148224 1948629360 19.216 100 25 50 0 1964178560 8736448 6812752
00:30:47 50443 8192000000 10881028656 11351949312 1890525920 18.750 96 35 71 2 1909646992 9394144 9726928
00:31:47 33390 8192000000 10875156016 11335081984 1901472336 18.838 97 24 49 2 1917153040 8698720 6981984
00:32:29 5841 8192000000 10916924240 11351359488 1942934064 19.170 99 68 136 2 1971068640 9501648 18632928
00:32:41 6697 8192000000 10897960928 11340402688 1933656912 19.096 99 63 126 0 1962171664 10784080 17730672
00:32:56 22728 8192000000 10872211040 11325366272 1882064624 18.682 97 48 96 3 1911257216 16189168 13003424
00:33:28 25010 8192000000 10857954640 11317407744 1878233392 18.651 97 47 94 1 1904652736 13170640 13248704
00:34:04 61569 8192000000 10859890000 11321614336 1885806048 18.712 98 21 42 2 1903349760 11294608 6249104
00:35:20 11838 8192000000 10904297936 11351994368 1947419920 19.206 100 52 105 0 1975928624 13527920 14980784
00:35:41 61008 8192000000 10829285776 11296509952 1757242864 17.662 91 17 34 1 1775314368 13260352 4811152
00:36:50 85121 8192000000 10852855488 11310346240 1839951360 18.340 96 13 25 0 1858590656 15183392 3455904
00:38:24 50552 8192000000 10861232816 11325153280 1906564192 18.879 99 15 31 0 1929517280 18694784 4258304
00:40:03 59747 8192000000 10839008784 11301511168 1839341024 18.335 96 16 32 0 1855445840 11820528 4284288
00:41:08 87155 8192000000 10854269888 11322097664 1899420992 18.822 99 12 25 0 1912522128 9980336 3120800
00:43:39 84347 8192000000 10868129280 11354152960 1919986000 18.987 99 14 28 0 1941627664 17644880 3996784
00:45:09 17007 8192000000 10881698384 11335094272 1917856448 18.970 99 15 30 2 1937798048 15304752 4636848
00:45:35 29119 8192000000 10859965024 11329327104 1934467360 19.103 99 49 96 3 1956375552 8423856 13484336
00:46:11 57918 8192000000 10864724176 11354058752 1929093872 19.060 99 8 16 1 1942105600 10636240 2375488
00:47:15 36523 8192000000 10870187712 11344130048 1932138112 19.084 99 8 15 0 1944041360 9833968 2069280
00:48:02 44499 8192000000 10881342384 11351429120 1937682608 19.128 99 16 32 1 1955369584 12761456 4925520
00:48:56 78117 8192000000 10878291936 11354931200 1942734112 19.169 99 16 31 2 1961179136 13250448 5194576
00:50:39 67170 8192000000 10879299584 11360276480 1927422496 19.046 98 20 40 0 1945121680 12017904 5681280
00:52:15 58892 8192000000 10877949040 11367514112 1922477776 19.007 98 9 18 0 1938056464 13092208 2486480
00:53:26 40469 8192000000 10905619088 11373588480 1947111776 19.203 99 26 52 1 1971186480 16144096 7930608
00:54:13 56364 8192000000 10917430496 11388522496 1959958656 19.306 99 28 56 2 1983797280 15647168 8191456
00:55:18 52128 8192000000 10906459856 11390255104 1938092960 19.132 98 20 41 2 1961028176 16703632 6231584
00:56:42 84606 8192000000 10881136912 11370926080 1914700304 18.944 97 16 32 0 1931192688 12454512 4037872
00:58:13 27617 8192000000 10929122688 11385524224 1970866640 19.392 100 22 43 0 1984811728 8396592 5548496
00:58:51 37006 8192000000 10919867488 11384545280 1966037824 19.354 99 32 64 1 1984800880 9894912 8868144
00:59:36 67514 8192000000 10902281360 11387334656 1936956656 19.122 98 16 32 0 1953436096 12382448 4096992
01:01:51 57705 8192000000 10927811120 11383926784 1974465392 19.421 100 19 38 0 1989764704 10050816 5248496
01:02:57 34169 8192000000 10931717280 11385790464 1979817952 19.463 100 34 68 0 2001708000 12197696 9692352
01:03:38 7453 8192000000 10945485136 11399745536 1994205984 19.577 100 53 106 1 2021823088 12064720 15552384
01:04:03 102311 8192000000 10916971632 11392090112 1916656288 18.960 96 32 64 1 1937093680 11863328 8574064
01:05:52 69762 8192000000 10923192752 11379847168 1925440752 19.030 97 17 33 1 1941531232 11555744 4534736
01:07:12 154938 8192000000 10921559920 11398500352 1969329472 19.380 99 26 52 0 1987480176 10500576 7650128
01:10:48 29032 8192000000 10908138784 11378069504 1953636320 19.255 98 26 52 2 1970454896 8220800 8597776
01:11:26 43812 8192000000 10901364464 11380629504 1962704768 19.328 99 20 39 0 1974544816 6415696 5424352
01:12:19 74287 8192000000 10901558288 11386191872 1955244208 19.268 98 15 29 2 1967353696 7293904 4815584
01:13:41 65301 8192000000 10893065376 11390480384 1950041264 19.227 98 13 27 1 1963889792 9950816 3897712
01:14:53 50059 8192000000 10894550560 11370590208 1942959648 19.170 98 16 32 1 1955679424 7824688 4895088
01:15:52 36847 8192000000 10882063904 11358572544 1934527680 19.103 98 11 22 1 1943076656 5634064 2914912
01:16:45 42429 8192000000 10881737728 11365711872 1949769712 19.225 99 29 58 1 1966730624 8880752 8080160
01:17:38 81038 8192000000 10856458432 11339288576 1849787104 18.420 94 7 14 0 1858471968 6864384 1820480
01:19:31 42396 8192000000 10845819600 11319275520 1876349376 18.636 97 15 30 0 1887284880 6826496 4109008
01:20:22 40487 8192000000 10880475984 11341889536 1924551808 19.023 99 23 45 1 1938523824 7766864 6205152
01:21:09 48439 8192000000 10881072336 11355500544 1916333760 18.957 98 29 59 1 1936240928 11758256 8148912
01:22:12 32540 8192000000 10877599552 11345833984 1930003072 19.067 99 26 52 1 1947852960 10629840 7220048
01:22:51 26788 8192000000 10867751728 11337752576 1913951424 18.938 98 28 56 0 1932716304 10938048 7826832
01:23:24 38490 8192000000 10879297264 11343806464 1928187680 19.052 99 30 60 1 1949230752 12215392 8827680
01:24:16 29749 8192000000 10851686976 11323613184 1851147568 18.431 95 22 44 2 1870540368 13248192 6144608
01:25:46 82726 8192000000 10852503184 11317231616 1787452016 17.911 93 21 42 0 1807249904 13757840 6040048

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 10-06-2021 01:29:06 to 10-06-2021 01:29:38.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 108 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          242587
MON$OLDEST_ACTIVE               244117
MON$OLDEST_SNAPSHOT             244117
MON$NEXT_TRANSACTION            244117
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                       2044832
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.33472 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33472 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33472 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33472 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 ---
:57: 
:58: mscs-test-161.budzdorov.ru    Thu Jun 10 01:28:05 2021
:59:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:60: 
:61: 
:62: mscs-test-161.budzdorov.ru    Thu Jun 10 01:28:07 2021
:63:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:64: 
:65: 
:66: mscs-test-161.budzdorov.ru    Thu Jun 10 01:28:11 2021
:67:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:68: 
:69: 
:70: mscs-test-161.budzdorov.ru    Thu Jun 10 01:28:11 2021
:71:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:72: 
:73: 
:74: mscs-test-161.budzdorov.ru    Thu Jun 10 01:28:11 2021
:75:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:76: 
--- end of diff output ---

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

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