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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-26 19:27:26
DTS_END                         2021-03-26 19:27:26.6200
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35298
TRN_ID                          244489
ATT_ID                          671
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: 9216.13 22890 1105936
customer order: creation 175.42 352 21050
customer order: refuse 14.88 333 1785
order to supplier: creation 46.18 1212 5542
order to supplier: removal 3.51 101636 421
invoice (draft): creation 47.36 3209 5683
invoice (draft): removal 52.07 794 6248
invoice accept: apply 41.98 16367 5038
invoice accept: cancel 46.71 853 5605
customer reserve: creation 3918.49 160 470219
customer reserve: removal 4574.77 62 548973
realization accept: apply 86.39 162 10367
realization accept: cancel 75.43 110 9052
payment from customer: creation 60.42 96 7250
payment from customer: removal 5.75 66 690
payment to supplier: creation 50.33 106 6039
payment to supplier: removal 3.73 59 448
service: total inventory turnovers 5.07 881 608
service: total monetary turnovers 6.73 24 807
service: aggregate perf. data 0.89 16410 107
service: refresh index statistics 0.03 314916 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-03-2021 19:29:18 to 26-03-2021 19:29:20.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2424
TEST_TIME 2 4164
TEST_TIME 3 4068
TEST_TIME 4 4216
TEST_TIME 5 4386
TEST_TIME 6 4154
TEST_TIME 7 4975
TEST_TIME 8 4826
TEST_TIME 9 4997
TEST_TIME 10 5078
TEST_TIME 11 5072
TEST_TIME 12 5194
TEST_TIME 13 5433
TEST_TIME 14 5353
TEST_TIME 15 5562
TEST_TIME 16 5972
TEST_TIME 17 6442
TEST_TIME 18 6671
TEST_TIME 19 7176
TEST_TIME 20 7750
TEST_TIME 21 7773
TEST_TIME 22 8259
TEST_TIME 23 9118
TEST_TIME 24 9252
TEST_TIME 25 9559
TEST_TIME 26 9827
TEST_TIME 27 10695
TEST_TIME 28 10547
TEST_TIME 29 10687
TEST_TIME 30 10437
TEST_TIME 31 10113
TEST_TIME 32 10341
TEST_TIME 33 10140
TEST_TIME 34 10260
TEST_TIME 35 10041
TEST_TIME 36 10108
TEST_TIME 37 9985
TEST_TIME 38 10032
TEST_TIME 39 9907
TEST_TIME 40 9962
TEST_TIME 41 9890
TEST_TIME 42 9761
TEST_TIME 43 9740
TEST_TIME 44 9752
TEST_TIME 45 9731
TEST_TIME 46 9716
TEST_TIME 47 9632
TEST_TIME 48 9568
TEST_TIME 49 9529
TEST_TIME 50 9570
TEST_TIME 51 9501
TEST_TIME 52 9525
TEST_TIME 53 9546
TEST_TIME 54 9547
TEST_TIME 55 9491
TEST_TIME 56 9489
TEST_TIME 57 9616
TEST_TIME 58 9593
TEST_TIME 59 9649
TEST_TIME 60 9629
TEST_TIME 61 9709
TEST_TIME 62 9687
TEST_TIME 63 9659
TEST_TIME 64 9660
TEST_TIME 65 9701
TEST_TIME 66 9733
TEST_TIME 67 9729
TEST_TIME 68 9602
TEST_TIME 69 9645
TEST_TIME 70 9580
TEST_TIME 71 9540
TEST_TIME 72 9506
TEST_TIME 73 9494
TEST_TIME 74 9477
TEST_TIME 75 9415
TEST_TIME 76 9343
TEST_TIME 77 9303
TEST_TIME 78 9268
TEST_TIME 79 9254
TEST_TIME 80 9207
TEST_TIME 81 9261
TEST_TIME 82 9218
TEST_TIME 83 9318
TEST_TIME 84 9300
TEST_TIME 85 9260
TEST_TIME 86 9311
TEST_TIME 87 9435
TEST_TIME 88 9407
TEST_TIME 89 9413
TEST_TIME 90 9492
TEST_TIME 91 9552
TEST_TIME 92 9580
TEST_TIME 93 9503
TEST_TIME 94 9427
TEST_TIME 95 9407
TEST_TIME 96 9394
TEST_TIME 97 9389
TEST_TIME 98 9377
TEST_TIME 99 9349
TEST_TIME 100 9326
TEST_TIME 101 9428
TEST_TIME 102 9382
TEST_TIME 103 9408
TEST_TIME 104 9408
TEST_TIME 105 9416
TEST_TIME 106 9442
TEST_TIME 107 9455
TEST_TIME 108 9446
TEST_TIME 109 9433
TEST_TIME 110 9452
TEST_TIME 111 9480
TEST_TIME 112 9408
TEST_TIME 113 9391
TEST_TIME 114 9347
TEST_TIME 115 9311
TEST_TIME 116 9327
TEST_TIME 117 9274
TEST_TIME 118 9261
TEST_TIME 119 9217
TEST_TIME 120 9216

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-03-2021 19:29:22 to 26-03-2021 19:29:25.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1540715 1540715 0 0.00 0 13011 6 0 0
doc_list_biud 1540708 1540708 0 0.00 0 104414 28 0 0
sp_add_invoice_to_stock 5138 5038 100 1.94 39 209144 16367 0 100
sp_cancel_adding_invoice 5605 5605 0 0.00 5 108522 853 0 0
sp_cancel_client_order 1785 1785 0 0.00 4 23680 334 0 0
sp_cancel_customer_reserve 548973 548973 0 0.00 1 104417 62 0 0
sp_cancel_pay_from_customer 690 690 0 0.00 3 4968 66 0 0
sp_cancel_pay_to_supplier 448 448 0 0.00 3 2908 60 0 0
sp_cancel_supplier_invoice 6255 6248 7 0.11 2 12756 794 0 7
sp_cancel_supplier_order 421 421 0 0.00 6 1245859 101636 0 0
sp_cancel_write_off 9052 9052 0 0.00 1 10269 110 0 0
sp_client_order 21050 21050 0 0.00 3 75577 353 0 0
sp_customer_reserve 470219 470219 0 0.00 0 144031 160 0 0
sp_fill_shopping_cart 32252 32252 0 0.00 1 15139 33 0 0
sp_fill_shopping_cart_clo_res 470217 470217 0 0.00 0 16616 11 0 0
sp_get_clo_for_invoice 5036 5036 0 0.00 0 32258 288 0 0
sp_kill_cost_storno 15795 15795 0 0.00 0 10266 55 0 0
sp_kill_qstorno_ret_qs2qd 1113667 1113667 0 0.00 0 104405 34 0 0
sp_kill_qty_storno 587486 587486 0 0.00 0 104414 72 0 0
sp_lock_selected_doc 21383 21383 0 0.00 0 6152 4 0 0
sp_make_cost_storno 28692 28692 0 0.00 0 11178 46 0 0
sp_multiply_rows_for_pdistr 28691 28691 0 0.00 0 9473 25 0 0
sp_multiply_rows_for_qdistr 21050 21050 0 0.00 0 75567 177 0 0
sp_pay_from_customer 7250 7250 0 0.00 4 9980 97 0 0
sp_pay_to_supplier 6039 6039 0 0.00 5 10938 107 0 0
sp_payment_common 13287 13287 0 0.00 1 9971 29 0 0
sp_qd_handle_on_cancel_clo 1785 1785 0 0.00 0 23674 307 0 0
sp_qd_handle_on_invoice_upd_sts 10640 10640 0 0.00 0 30834 327 0 0
sp_qd_handle_on_reserve_upd_sts 10367 10367 0 0.00 0 18214 61 0 0
sp_reserve_write_off 10367 10367 0 0.00 6 18263 163 0 0
sp_supplier_invoice 5683 5683 0 0.00 6 84208 3210 0 0
sp_supplier_order 5542 5542 0 0.00 5 40097 1213 0 0
srv_aggregate_perf_data 107 107 0 0.00 2558 140777 16410 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1012 209655 34576 0 0
srv_find_qd_qs_mism 1056895 1056895 0 0.00 0 11085 5 0 0
srv_make_invnt_saldo 608 608 0 0.00 24 28808 882 0 0
srv_make_money_saldo 807 807 0 0.00 0 2382 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 174537 452159 314917 0 0
t$perf-abend:sp_add_invoice_to_stock 100 100 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 5038 5038 0 0.00 0 18516 153 0 0
t$perf-norm:sp_cancel_adding_invoice 457 457 0 0.00 1 4295 100 0 0
t$perf-norm:sp_cancel_client_order 1785 1785 0 0.00 0 2417 11 0 0
t$perf-norm:sp_cancel_customer_reserve 708 708 0 0.00 0 1959 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 690 690 0 0.00 0 439 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 448 448 0 0.00 0 2141 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 424 424 0 0.00 0 2063 23 0 0
t$perf-norm:sp_cancel_supplier_order 421 421 0 0.00 0 18074 1407 0 0
t$perf-norm:sp_cancel_write_off 1048 1048 0 0.00 0 5048 15 0 0
t$perf-norm:sp_client_order 21050 21050 0 0.00 0 4818 13 0 0
t$perf-norm:sp_customer_reserve 1012 1012 0 0.00 0 6445 14 0 0
t$perf-norm:sp_pay_from_customer 7250 7250 0 0.00 0 12329 9 0 0
t$perf-norm:sp_pay_to_supplier 6039 6039 0 0.00 0 5265 9 0 0
t$perf-norm:sp_reserve_write_off 10368 10368 0 0.00 0 15569 15 0 0
t$perf-norm:sp_supplier_invoice 5683 5683 0 0.00 0 5526 16 0 0
t$perf-norm:sp_supplier_order 5542 5542 0 0.00 0 9353 14 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 217 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 1554 15 0 0
t$perf-norm:srv_make_invnt_saldo 608 608 0 0.00 0 1995 23 0 0
t$perf-norm:srv_make_money_saldo 807 807 0 0.00 0 9653 27 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10269 10069 200 1.94 0 11048 19 0 200
v_all_customers 38052 38052 0 0.00 0 46 0 0 0
v_all_suppliers 31580 31580 0 0.00 0 12 1 0 0
v_all_wares 42098 42098 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 914 914 0 0.00 0 1121 8 0 0
v_cancel_client_order 3570 3570 0 0.00 0 4012 5 0 0
v_cancel_customer_prepayment 1380 1380 0 0.00 0 1081 4 0 0
v_cancel_customer_reserve 1416 1416 0 0.00 0 956 4 0 0
v_cancel_payment_to_supplier 896 896 0 0.00 0 1714 7 0 0
v_cancel_supplier_invoice 862 848 14 1.62 0 795 12 0 14
v_cancel_supplier_order 842 842 0 0.00 0 3578 8 0 0
v_cancel_write_off 2096 2096 0 0.00 0 2179 14 0 0
v_max_id_clo_ord 5539 5539 0 0.00 0 4911 2 0 0
v_max_id_clo_res 1012 1012 0 0.00 0 7986 13 0 0
v_max_id_ord_sup 5664 5664 0 0.00 0 3804 3 0 0
v_max_non_paid_invoice 1450 1450 0 0.00 0 953 3 0 0
v_max_non_paid_realizn 3920 3920 0 0.00 0 4518 5 0 0
v_min_id_clo_ord 5539 5539 0 0.00 0 2130 4 0 0
v_min_id_clo_res 1012 1012 0 0.00 0 2785 6 0 0
v_min_id_ord_sup 5664 5664 0 0.00 0 7902 6 0 0
v_min_non_paid_invoice 6037 6037 0 0.00 0 6882 19 0 0
v_min_non_paid_realizn 7250 7250 0 0.00 0 6931 18 0 0
v_our_firm 10706 10706 0 0.00 0 13 1 0 0
v_reserve_write_off 20734 20734 0 0.00 0 5284 6 0 0
x_lock_depdocs_on_canc_invoice 11429 11429 0 0.00 0 19191 122 0 0
x_lock_depdocs_on_canc_sup_ord 421 421 0 0.00 0 21078 387 0 0
x_make_qstorno_1000_1200 5542 5542 0 0.00 2 40069 1149 0 0
x_make_qstorno_1200_2000 5683 5683 0 0.00 2 84198 3082 0 0
x_make_qstorno_2100_3300 470219 470219 0 0.00 0 144030 147 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-03-2021 19:29:26 to 26-03-2021 19:29:30.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:30 9 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:36 21078 8192000000 10230053248 10536456192 785866272 8.753 62 53 107 0 805728672 2246544 17615856
16:58:07 20162 8192000000 10322311776 10632351744 1362208112 14.257 100 88 176 1 1395837568 4636432 28993024
16:58:36 28780 8192000000 10363255328 10681905152 1406512240 14.653 100 84 168 0 1440669152 6237936 27918976
16:59:14 17982 8192000000 10387290000 10710872064 1441574512 14.964 100 89 178 0 1479085648 7588880 29922256
16:59:57 19479 8192000000 10406412288 10732503040 1460973760 15.134 100 90 180 1 1499018704 8341504 29703440
17:00:28 17253 8192000000 10423234752 10753736704 1473660800 15.246 100 84 168 0 1510396496 8501152 28234544
17:01:00 20046 8192000000 10453575808 10787442688 1502703616 15.500 100 88 176 0 1540590912 9258080 28629216
17:01:33 13521 8192000000 10459160368 10796187648 1514937888 15.606 100 87 173 1 1552173328 9605472 27629968
17:01:54 15768 8192000000 10466398640 10811052032 1521366672 15.662 100 80 160 0 1556916176 10044080 25505424
17:02:19 15744 8192000000 10495259408 10843594752 1545224784 15.869 100 70 140 0 1577333136 9649120 22459232
17:02:44 11438 8192000000 10516659120 10873602048 1578839648 16.158 100 76 152 0 1612514336 10111312 23563376
17:03:09 17327 8192000000 10557496752 10917502976 1610370992 16.428 100 78 153 2 1644468656 10744784 23352880
17:03:36 9065 8192000000 10589686352 10956337152 1649439008 16.760 100 71 140 1 1681150288 11213648 20497632
17:03:53 11808 8192000000 10614678016 10985840640 1674309456 16.969 100 84 169 0 1711067360 12127760 24630144
17:04:13 7416 8192000000 10652053872 11025420288 1697232064 17.162 100 73 145 0 1729204768 11244448 20728256
17:04:29 7050 8192000000 10659885840 11027304448 1711742272 17.283 100 83 166 1 1748459040 12582288 24134480
17:04:43 7604 8192000000 10667215280 11039698944 1725039648 17.394 100 84 168 3 1762304352 12970384 24294320
17:04:58 5194 8192000000 10682444880 11058380800 1740118576 17.520 100 82 164 1 1775918928 12097920 23702432
17:05:12 5587 8192000000 10697120720 11070312448 1754334640 17.638 100 85 170 2 1791274480 13088992 23850848
17:05:24 5320 8192000000 10707778320 11084767232 1767490720 17.746 100 91 182 3 1806165632 13227632 25447280
17:05:36 6260 8192000000 10712637296 11092357120 1773610928 17.797 100 77 155 0 1807441456 12635424 21195104
17:05:49 2569 8192000000 10721399744 11100950528 1782138896 17.867 100 87 170 1 1819389088 13303856 23946336
17:06:00 3715 8192000000 10729596000 11111014400 1789030464 17.924 100 78 152 1 1823643072 13207168 21405440
17:06:10 3727 8192000000 10732689056 11115012096 1797549616 17.994 100 74 146 1 1830492320 12667520 20275184
17:06:21 2675 8192000000 10746474912 11128020992 1806880496 18.070 100 81 159 1 1842552912 13228592 22443824
17:06:31 4538 8192000000 10755922512 11142549504 1816069664 18.146 100 83 167 1 1850932496 12259872 22602960
17:06:43 6083 8192000000 10756442672 11148165120 1818243696 18.163 100 68 136 0 1848613376 11333312 19036368
17:06:56 5087 8192000000 10762656944 11147370496 1822565088 18.199 100 84 166 1 1858366032 12578784 23222160
17:07:08 2467 8192000000 10785706384 11169595392 1838929184 18.332 100 91 182 1 1879258672 14594512 25734976
17:07:17 2346 8192000000 10785600624 11170930688 1843705792 18.371 100 88 175 1 1881903520 14005008 24192720
17:07:25 1910 8192000000 10794000512 11179024384 1847623600 18.403 100 95 188 0 1888299152 13227760 27447792
17:07:34 2466 8192000000 10794074752 11184357376 1854771600 18.461 100 87 174 0 1889815840 10509952 24534288
17:07:43 2604 8192000000 10798464144 11190140928 1863440992 18.531 100 92 184 1 1902517552 12911056 26165504
17:07:52 1942 8192000000 10804081840 11190607872 1863114160 18.529 100 94 186 4 1902994880 13916880 25963840
17:08:01 2320 8192000000 10810101632 11198152704 1868964656 18.576 100 97 194 2 1911093632 14576160 27552816
17:08:09 1617 8192000000 10818640368 11208978432 1872036768 18.601 100 98 195 0 1913518512 13765520 27716224
17:08:17 2058 8192000000 10825105312 11213873152 1877048544 18.641 100 97 193 1 1917537936 13268384 27221008
17:08:26 13853 8192000000 10796805248 11202555904 1871418704 18.596 100 62 123 0 1899470080 10196880 17854496
17:08:46 14862 8192000000 10783483760 11201572864 1868974576 18.576 100 45 88 0 1890733440 9301344 12457520
17:09:08 9991 8192000000 10773420576 11203260416 1872795872 18.607 100 34 69 3 1889184960 6661792 9727296
17:09:24 7256 8192000000 10789343600 11209658368 1877167472 18.642 100 29 58 1 1891842432 6933744 7741216
17:09:40 8327 8192000000 10787029968 11216060416 1879867568 18.664 100 31 62 1 1896393328 7728816 8796944
17:09:55 5850 8192000000 10792276144 11219836928 1879227680 18.659 100 31 63 1 1897908416 10799792 7880944
17:10:09 7147 8192000000 10787432560 11216969728 1883047600 18.690 100 22 44 0 1895167472 5561568 6558304
17:10:24 9797 8192000000 10793638768 11221245952 1885274176 18.708 100 20 40 1 1896560256 5756576 5529504
17:10:40 9046 8192000000 10803413968 11232915456 1888738976 18.736 100 24 48 0 1906374048 11010720 6624352
17:10:57 10158 8192000000 10789554080 11225382912 1889290320 18.740 100 19 38 4 1901373232 6790576 5292336
17:11:14 10767 8192000000 10804262192 11236659200 1891518640 18.758 100 22 44 3 1903455888 5893040 6044208
17:11:34 12245 8192000000 10802871792 11236945920 1896716976 18.800 100 17 34 1 1907489600 5904128 4868496
17:11:52 4595 8192000000 10809988896 11240804352 1898428976 18.814 100 20 41 0 1909684848 5973808 5282064
17:12:07 57688 8192000000 10817512352 11252117504 1902954720 18.850 100 24 48 1 1915723536 5572208 7196608
17:13:16 23004 8192000000 10817663552 11256061952 1904493216 18.862 100 22 44 1 1916709968 6017600 6199152
17:13:45 7844 8192000000 10820261488 11262324736 1910123264 18.908 100 25 50 2 1923340016 6225760 6990992
17:14:00 6471 8192000000 10832529040 11263627264 1910934896 18.914 100 23 46 3 1923291648 4929200 7427552
17:14:14 7366 8192000000 10829900352 11264729088 1911485312 18.919 100 17 34 0 1922203024 5718224 4999488
17:14:28 3837 8192000000 10842893808 11272515584 1917416608 18.966 100 41 80 1 1937385776 8668080 11301088
17:14:39 8001 8192000000 10795968016 11236827136 1857909024 18.486 97 21 42 3 1869945488 5787024 6249440
17:14:53 6439 8192000000 10827618784 11259285504 1905375472 18.870 100 31 62 1 1920198192 6350816 8471904
17:15:08 6827 8192000000 10823875904 11260764160 1909019792 18.899 100 32 64 0 1924344896 6320976 9004128
17:15:23 6952 8192000000 10830588736 11262353408 1908350480 18.893 100 22 41 2 1920911232 5745184 6815568
17:15:38 10682 8192000000 10820259200 11259404288 1896222112 18.796 99 19 38 2 1906555056 5263312 5069632
17:15:55 13178 8192000000 10821528240 11260657664 1889122656 18.739 99 13 27 1 1902435248 9846720 3465872
17:16:18 9762 8192000000 10828192464 11264925696 1911573616 18.919 100 20 40 3 1923442496 6086336 5782544
17:16:36 13787 8192000000 10829605904 11264745472 1896380272 18.797 99 19 38 2 1908466256 5894624 6191360
17:17:01 61935 8192000000 10737527616 11157508096 1765633664 17.731 93 21 42 1 1777330144 4993888 6702592
17:18:23 15368 8192000000 10747509616 11172556800 1738888976 17.509 93 17 34 1 1749086368 5811984 4385408
17:18:49 6035 8192000000 10753873408 11167232000 1802760144 18.037 98 28 56 2 1817443776 6232160 8451472
17:19:04 5843 8192000000 10675040688 11085963264 1684100880 17.052 94 30 60 0 1699547104 6286096 9160128
17:19:16 6207 8192000000 10684245680 11105550336 1762340208 17.704 99 35 70 1 1778498224 6001680 10156336
17:19:30 5779 8192000000 10699396960 11118370816 1769164464 17.760 99 22 43 1 1781648976 5947648 6536864
17:19:50 7699 8192000000 10714882928 11135557632 1798959968 18.005 100 30 59 2 1813639552 6449136 8230448
17:20:07 8513 8192000000 10705401120 11127132160 1740940656 17.526 96 35 69 1 1757144112 6305152 9898304
17:20:21 9133 8192000000 10713265456 11129966592 1751931968 17.618 97 31 61 0 1767612656 5619488 10061200
17:20:37 9340 8192000000 10690285872 11106820096 1741614912 17.532 97 38 76 0 1759488160 6653952 11219296
17:20:54 11396 8192000000 10727360096 11143950336 1770528608 17.771 98 28 53 0 1784423568 5559808 8335152
17:21:16 8641 8192000000 10725001920 11146354688 1800685568 18.020 99 37 73 3 1817813152 6085168 11042416
17:21:31 11560 8192000000 10688750432 11104235520 1742888800 17.543 96 16 32 1 1753347952 5662736 4796416
17:21:52 72757 8192000000 10718474752 11146944512 1776811600 17.823 98 19 37 1 1787787664 5199872 5776192
17:23:11 9640 8192000000 10714555936 11134050304 1795285424 17.975 99 16 32 1 1806107088 5937520 4884144
17:23:29 8208 8192000000 10739859472 11162120192 1822938928 18.202 100 25 50 3 1835982080 6303968 6739184
17:23:44 4972 8192000000 10751962128 11169570816 1830554624 18.264 100 39 78 1 1848631888 6161072 11916192
17:23:58 5103 8192000000 10751808560 11174346752 1835675904 18.306 100 38 76 3 1854498768 8005600 10817264
17:24:11 6502 8192000000 10745397808 11169169408 1831707520 18.273 100 30 59 2 1846085872 5174176 9204176
17:24:26 5430 8192000000 10764751632 11183263744 1844631584 18.378 100 33 66 3 1860100192 6192048 9276560
17:24:39 5975 8192000000 10763735104 11186954240 1847186320 18.399 100 28 56 3 1862277312 7355168 7735824
17:24:52 10469 8192000000 10766680400 11190304768 1848639360 18.411 100 20 39 1 1860275744 5952864 5683520
17:25:09 7562 8192000000 10774234160 11198992384 1857423040 18.482 100 23 47 0 1869565904 5599392 6543472
17:25:22 10462 8192000000 10776928480 11207409664 1861335712 18.514 100 25 50 1 1878950608 9844704 7770192
17:25:39 14364 8192000000 10782260576 11208728576 1864176480 18.537 100 32 60 3 1879252704 4977856 10098368
17:26:01 11908 8192000000 10781205488 11209613312 1866163232 18.553 100 24 48 2 1879808272 5689776 7955264
17:26:20 10855 8192000000 10786462992 11213606912 1866184912 18.553 100 18 36 3 1876797296 5948512 4663872
17:26:37 11957 8192000000 10781363920 11209510912 1868303984 18.571 100 23 46 2 1880968448 5869072 6795392
17:26:55 66354 8192000000 10815822928 11235012608 1884359376 18.700 100 42 85 2 1902655760 5612432 12683952
17:28:13 59874 8192000000 10833354480 11258036224 1905004064 18.867 100 42 82 0 1923808752 7096096 11708592
17:29:22 16316 8192000000 10856565552 11272556544 1920147312 18.988 100 52 102 2 1943497952 8694272 14656368
17:29:47 7313 8192000000 10857343632 11283374080 1928133504 19.052 100 59 116 2 1954529184 10311216 16084464
17:30:02 11866 8192000000 10869086752 11288129536 1930633568 19.072 100 53 106 1 1956526016 10501760 15390688
17:30:34 30576 8192000000 10871732176 11296391168 1936825360 19.121 100 54 108 1 1965185504 13123456 15236688
17:31:21 20880 8192000000 10881812992 11307118592 1944310352 19.181 100 50 100 1 1971482816 13273440 13899024
17:31:49 38206 8192000000 10885644448 11313745920 1945542432 19.191 100 34 67 0 1969006656 13005872 10458352
17:32:58 12057 8192000000 10894433456 11322527744 1954815792 19.265 100 39 78 1 1978890816 12588800 11486224
17:33:21 7389 8192000000 10899173728 11325702144 1958364768 19.293 100 51 102 2 1988788720 15220336 15203616
17:33:41 11224 8192000000 10908774464 11335655424 1966420736 19.357 100 62 122 1 2000513568 16463648 17629184
17:34:06 17093 8192000000 10908929472 11335749632 1946986992 19.202 99 54 108 1 1981608432 18485376 16136064
17:34:32 14842 8192000000 10893213328 11333550080 1941117392 19.156 99 44 89 1 1971412608 17225808 13069408
17:34:59 25238 8192000000 10913459712 11348717568 1968025360 19.370 100 38 76 1 1996584272 16632848 11926064
17:35:37 2847 8192000000 10925316240 11350863872 1976398256 19.436 100 56 112 0 2011258656 18420400 16440000
17:35:51 15615 8192000000 10922337552 11357986816 1977549008 19.445 100 53 106 1 2014242736 20183376 16510352
17:36:15 9708 8192000000 10927744432 11366293504 1983391008 19.492 100 47 93 0 2021655344 23688112 14576224
17:36:32 7746 8192000000 10930667216 11366133760 1980368000 19.468 100 44 88 1 2019386160 24983568 14034592
17:36:54 26539 8192000000 10937689776 11371646976 1976539008 19.437 99 53 106 0 2016373376 23411760 16422608
17:37:42 2205 8192000000 10952330624 11384213504 1999993632 19.623 100 55 110 1 2039453680 22674368 16785680
17:37:51 6841 8192000000 10955315424 11382644736 1996672304 19.596 100 63 125 0 2039934416 24399168 18862944
17:38:19 4830 8192000000 10961625104 11390119936 2004831440 19.661 100 66 131 0 2050146736 25379120 19936176
17:38:32 5447 8192000000 10973266416 11396689920 2012140064 19.718 100 81 163 0 2063524592 26852816 24531712
17:38:45 3302 8192000000 10974960400 11398385664 2009523840 19.698 100 74 148 2 2059049472 27579296 21946336
17:38:57 4788 8192000000 10968338464 11390808064 2002555168 19.643 100 70 141 0 2052713040 28677808 21480064
17:39:11 4702 8192000000 10980118256 11399917568 2009951600 19.701 100 81 163 1 2064702768 28315328 26435840
17:39:25 5440 8192000000 10980171120 11399151616 2005951904 19.670 100 76 146 4 2059233456 29227744 24053808
17:39:45 9539 8192000000 10967877408 11390169088 1981148896 19.474 99 56 112 1 2031082496 32612352 17321248
17:40:07 5297 8192000000 10968155440 11393175552 1998912192 19.614 100 73 146 1 2053345488 31033200 23400096
17:40:21 6401 8192000000 10979611072 11404234752 2008527728 19.690 100 66 132 1 2060591632 31418352 20645552
17:40:35 5406 8192000000 10985582144 11413143552 2016589120 19.753 100 76 152 3 2073993712 32839248 24565344
17:40:48 3265 8192000000 10977400400 11402825728 2009869840 19.700 100 73 146 2 2063190416 30375984 22944592
17:41:00 8382 8192000000 10986408240 11414663168 2016093104 19.749 100 63 127 0 2066796944 30734928 19968912
17:41:17 3160 8192000000 10991116032 11412045824 2003506192 19.650 99 79 157 1 2059675936 31374624 24795120
17:41:26 5687 8192000000 10982783936 11413979136 2015285328 19.743 100 64 128 3 2067948688 31869632 20793728
17:41:47 4722 8192000000 10985459968 11411812352 2013663024 19.730 100 71 142 1 2070732608 34264288 22805296
17:42:05 5402 8192000000 10997262224 11419897856 2014858688 19.740 100 73 146 1 2076173040 38392912 22921440
17:42:21 5051 8192000000 10988403424 11419455488 2016030896 19.749 100 67 135 1 2075155456 38012384 21112176
17:42:34 2635 8192000000 11002661792 11425247232 2019080864 19.773 100 84 167 3 2085131984 38314384 27736736
17:42:44 3241 8192000000 10998378256 11426381824 2021468720 19.792 100 77 153 2 2084163680 38496048 24198912
17:42:54 2375 8192000000 10998980576 11418472448 1998506464 19.611 99 78 155 4 2063131840 40022080 24603296
17:43:06 2971 8192000000 10994275632 11423420416 2014565728 19.737 100 73 144 3 2078448432 40899872 22982832
17:43:17 2931 8192000000 11002236000 11423473664 2018677808 19.770 100 83 166 1 2086553136 42005808 25869520
17:43:30 2904 8192000000 10994112224 11415064576 2004664032 19.659 100 88 177 3 2077360816 44212960 28483824
17:43:43 7823 8192000000 10989586688 11420487680 2006835840 19.677 100 71 142 1 2075288080 45297456 23154784
17:44:07 10440 8192000000 10979888560 11416412160 1999712544 19.620 100 55 110 1 2066120880 47700544 18707792
17:44:25 6199 8192000000 10979878656 11416817664 1986127808 19.513 99 57 113 0 2049754560 44813472 18813280
17:44:39 3237 8192000000 10980938768 11408371712 1982831424 19.487 99 69 137 1 2052512768 47108800 22572544
17:44:49 1181 8192000000 10980170080 11393835008 1961679808 19.319 98 82 164 1 2029730992 41681264 26369920
17:44:59 4242 8192000000 10980634128 11396276224 1990022592 19.544 100 79 158 2 2059666432 44724448 24919392
17:45:10 7334 8192000000 10982207392 11400237056 1987957840 19.528 100 80 160 1 2060737360 47113120 25666400
17:45:24 1007 8192000000 10994222768 11407872000 1996998336 19.599 100 83 165 0 2073367552 50329840 26039376
17:45:34 1568 8192000000 11007567312 11425583104 2003960240 19.654 100 83 166 0 2083588768 53021120 26607408
17:45:43 7339 8192000000 10971317424 11410829312 1987642784 19.525 100 54 106 0 2058619264 52443136 18533344
17:46:03 7791 8192000000 10975999232 11410903040 1990430336 19.547 100 59 118 3 2061737168 51348672 19958160
17:46:24 4676 8192000000 10976085088 11407646720 1976076432 19.434 99 60 120 1 2050732080 54757648 19898000
17:46:35 1999 8192000000 10976124352 11399061504 1975904624 19.432 100 70 138 2 2056134352 57342816 22886912
17:46:50 5594 8192000000 10965078576 11398881280 1974555952 19.422 100 61 122 1 2050172096 55483520 20132624
17:47:12 13113 8192000000 10934217088 11386724352 1937380160 19.126 98 30 60 1 1998083952 50160128 10543664
17:47:32 17602 8192000000 10933886848 11384655872 1971849168 19.400 100 36 73 3 2028029936 44214736 11966032
17:47:59 14612 8192000000 10945044464 11389411328 1967488544 19.366 100 36 72 1 2024877472 44888464 12500464
17:48:23 4798 8192000000 10931394224 11365494784 1938498960 19.135 99 67 133 2 2007191520 46726832 21965728
17:48:35 7350 8192000000 10934747472 11374895104 1953643600 19.255 100 44 85 2 2017042160 48338176 15060384
17:48:59 11520 8192000000 10944064816 11382030336 1954702320 19.264 100 39 76 1 2022120448 53492032 13926096
17:49:17 29135 8192000000 10920271104 11379286016 1897393744 18.805 97 29 58 1 1968439680 60034976 11010960
17:50:00 6548 8192000000 10927564672 11364200448 1920522528 18.991 99 55 110 2 1992205792 53349392 18333872
17:50:16 19493 8192000000 10898653312 11353104384 1929423504 19.062 100 28 56 1 1993708352 54470224 9814624
17:50:44 21032 8192000000 10860149328 11312037888 1892184416 18.763 98 20 40 1 1943864656 44661056 7019184
17:51:34 38231 8192000000 10870183216 11319164928 1889202752 18.739 98 19 38 1 1931292032 35785376 6303904
17:52:23 12253 8192000000 10882712320 11341475840 1917013040 18.963 100 17 34 0 1971001808 47871440 6117328
17:53:17 36253 8192000000 10854419152 11312611328 1894263680 18.780 100 20 40 2 1935323328 33926208 7133440
17:54:19 38157 8192000000 10835125552 11294126080 1876955280 18.641 98 16 32 1 1901869248 19962272 4951696
17:55:03 46779 8192000000 10852754496 11290062848 1843642272 18.370 96 21 42 0 1865712560 16048240 6022048
17:56:01 38141 8192000000 10833929232 11300507648 1875200304 18.626 98 16 32 1 1895270176 15433536 4636336
17:56:59 116389 8192000000 10871415088 11309178880 1883985440 18.697 98 30 59 0 1900519840 7894256 8640144
17:59:44 40669 8192000000 10875000864 11313209344 1873518560 18.613 96 45 78 1 1893695728 8646224 11530944
18:00:36 45646 8192000000 10847273568 11295776768 1859474448 18.499 96 34 66 2 1881095536 12211328 9409760
18:01:31 158559 8192000000 10861549056 11310718976 1877783968 18.647 97 21 42 1 1897539456 13845504 5909984
18:04:17 17846 8192000000 10871196512 11320967168 1923752352 19.017 99 25 50 0 1940798224 9524448 7521424
18:04:46 9227 8192000000 10906992672 11338616832 1937974464 19.131 99 59 116 2 1966133440 11433056 16725920
18:05:02 30500 8192000000 10883161776 11339280384 1937937600 19.130 99 52 104 0 1967405648 14680080 14787968
18:05:43 44862 8192000000 10875268160 11350032384 1952317648 19.245 100 16 32 0 1970386128 13400080 4668400
18:06:34 38846 8192000000 10886389296 11354324992 1954402048 19.262 100 13 27 0 1974951424 16538272 4011104
18:07:20 31658 8192000000 10889369312 11372531712 1965502448 19.350 100 14 28 0 1984946832 15555408 3888976
18:07:58 25853 8192000000 10895022016 11362619392 1968800176 19.376 100 11 23 0 1985213504 12996784 3416544
18:08:34 209655 8192000000 10907644304 11391623168 1956304288 19.277 99 16 31 0 1977348224 16750624 4293312
18:12:26 62965 8192000000 10886125376 11368448000 1958127424 19.291 99 16 30 1 1974505872 12532400 3846048
18:13:36 51289 8192000000 10884139808 11355893760 1938127360 19.132 98 16 32 0 1955656624 13117584 4411680
18:14:40 38068 8192000000 10899487040 11365879808 1950920928 19.234 99 16 32 0 1967502720 12098800 4482992
18:15:24 75976 8192000000 10892953632 11377025024 1967946768 19.369 100 15 30 0 1990506480 18067344 4492368
18:17:31 37096 8192000000 10893094816 11375259648 1966871904 19.361 100 6 12 0 1977549856 9073120 1604832
18:18:16 34979 8192000000 10915285456 11381788672 1986678432 19.518 100 52 104 1 2011649008 9997024 14973552
18:19:03 32467 8192000000 10887687632 11367563264 1958195232 19.292 99 12 23 0 1970406960 9071520 3140208
18:19:44 25683 8192000000 10899210448 11365462016 1958308656 19.293 99 19 37 2 1970037824 6903904 4825264
18:20:20 21400 8192000000 10920129088 11380756480 1986696224 19.518 100 37 75 1 2006770560 8922544 11151792
18:21:03 40865 8192000000 10919300608 11389616128 1986684976 19.518 100 18 36 3 2000052576 8263760 5103840
18:21:52 41686 8192000000 10922924736 11388928000 1957079344 19.283 98 18 35 1 1970087296 7659920 5348032
18:22:51 31698 8192000000 10957453680 11414110208 2008711728 19.691 100 40 81 2 2031478480 11259760 11506992
18:23:29 74370 8192000000 10919702768 11392507904 1960123344 19.307 98 18 36 0 1978894656 13496096 5275216
18:24:53 38084 8192000000 10937764032 11401359360 1974370832 19.420 99 18 36 1 1992432512 13389520 4672160
18:25:37 62255 8192000000 10940380416 11404378112 1983841648 19.495 99 19 38 1 1999685744 10723488 5120608
18:26:46 50906 8192000000 10917416688 11381366784 1925124704 19.028 96 14 28 0 1936460528 7390928 3944896
18:27:52 68471 8192000000 10920936096 11400994816 1959220656 19.300 98 17 34 0 1974010336 10320672 4469008
18:29:06 44301 8192000000 10893283312 11353186304 1892600160 18.767 95 11 22 2 1903242432 8063712 2578560
18:30:00 45447 8192000000 10915799552 11373109248 1961883936 19.321 99 22 44 1 1975639072 7914640 5840496
18:30:57 20423 8192000000 10928253200 11376156672 1946265648 19.197 98 45 90 0 1968670576 10067344 12337584
18:31:28 48905 8192000000 10907020496 11376193536 1929287968 19.061 97 40 80 0 1955816432 15434800 11093664
18:32:34 43913 8192000000 10906101008 11374612480 1941843616 19.161 99 32 62 0 1963044336 12074256 9126464
18:33:24 86523 8192000000 10882660640 11366694912 1938585344 19.135 99 12 24 1 1958764080 16945728 3233008
18:35:05 96821 8192000000 10867462064 11341225984 1883448272 18.693 96 22 44 0 1901771312 11914880 6408160
18:36:49 50008 8192000000 10846674992 11312234496 1876632624 18.638 97 24 48 0 1893082128 9285808 7163696
18:37:45 30861 8192000000 10849290112 11301629952 1826287808 18.229 95 23 46 0 1841272128 8399024 6585296
18:38:24 94909 8192000000 10826985440 11303927808 1894478256 18.782 99 26 52 0 1913410880 11069216 7863408
18:40:05 34670 8192000000 10812330672 11279187968 1836575536 18.313 96 10 20 0 1850813312 11161776 3076000
18:40:46 36423 8192000000 10828022256 11293933568 1872833520 18.607 98 18 36 1 1889587536 11330272 5423744
18:41:57 53642 8192000000 10811939328 11285790720 1885620656 18.710 99 15 29 0 1896494304 6520880 4352768
18:43:00 59937 8192000000 10836985568 11301498880 1907265968 18.885 100 13 26 0 1921355280 10905696 3183616
18:44:09 23007 8192000000 10826771408 11297386496 1892328752 18.765 99 16 32 1 1907264848 10633216 4302880
18:44:43 29413 8192000000 10822650864 11301322752 1900599888 18.831 100 6 12 1 1917463152 15564768 1298496
18:45:18 14841 8192000000 10823200192 11301752832 1905139264 18.868 100 9 18 1 1922785824 15442800 2203760
18:45:40 70819 8192000000 10833758432 11305054208 1879186928 18.659 98 7 14 0 1886737824 5991216 1559680
18:47:07 39145 8192000000 10834913904 11294277632 1862598208 18.524 97 20 40 0 1875665424 7515168 5552048
18:47:53 51776 8192000000 10817215648 11281997824 1818471728 18.165 95 14 28 0 1835900464 13070288 4358448
18:48:52 51342 8192000000 10806674000 11272671232 1809645360 18.093 95 13 26 0 1824281536 10872704 3763472
18:49:59 53918 8192000000 10815269696 11294613504 1879031232 18.657 99 25 49 0 1899054992 13079680 6944080
18:51:30 34472 8192000000 10861981568 11318165504 1920863888 18.994 100 36 72 1 1945557520 14696064 9997568
18:52:13 40958 8192000000 10865491360 11319332864 1919560416 18.983 100 32 64 0 1942696688 14133312 9002960
18:53:02 28440 8192000000 10855896288 11317186560 1882343472 18.684 98 36 72 2 1915804752 23590720 9870560
18:53:37 23026 8192000000 10879421344 11330453504 1929341968 19.062 100 48 98 1 1960396576 17952992 13101616
18:54:11 81973 8192000000 10850508000 11329691648 1901106304 18.835 99 14 28 1 1931098128 25323904 4667920
18:55:39 83617 8192000000 10870875200 11346411520 1907342352 18.885 99 13 26 1 1928266592 17382672 3541568
18:57:15 67201 8192000000 10894391168 11376377856 1957747408 19.288 100 14 28 0 1984341296 22387888 4206000
18:58:28 63922 8192000000 10897513184 11373600768 1943499872 19.175 99 14 28 0 1963303568 16568480 3235216
18:59:39 152154 8192000000 10888842544 11370979328 1948496304 19.214 99 15 29 0 1963461808 11141840 3823664
19:02:58 64813 8192000000 10884369056 11363819520 1936218832 19.117 98 6 12 0 1945725168 8433568 1072768
19:04:17 82346 8192000000 10918116128 11399094272 1962144288 19.323 99 14 28 0 1977073504 11241424 3687792
19:05:47 42211 8192000000 10895985488 11366092800 1909349728 18.901 96 26 52 1 1924764960 7957536 7457696
19:06:49 73646 8192000000 10911785904 11380097024 1960430640 19.309 99 21 42 1 1976959376 10139888 6388848
19:08:30 80356 8192000000 10922742256 11389677568 1967525952 19.366 99 20 40 0 1985307440 12338816 5442672
19:10:02 22745 8192000000 10905297632 11377836032 1951580384 19.239 98 37 74 2 1973759216 11801088 10377744
19:10:36 77662 8192000000 10899810016 11379572736 1940385808 19.150 98 13 27 1 1955784720 11639152 3759760
19:12:00 27159 8192000000 10921240288 11375173632 1958701264 19.296 99 39 78 2 1979030032 9224608 11104160
19:12:33 66426 8192000000 10909442592 11396567040 1984825264 19.503 100 22 44 0 2002075680 11084608 6165808
19:13:47 62336 8192000000 10899312576 11368390656 1935432896 19.110 97 25 49 0 1952082752 9905376 6744480
19:15:04 52318 8192000000 10876387952 11334856704 1893914048 18.777 96 11 22 2 1904735040 7858080 2962912
19:16:05 25628 8192000000 10890150000 11349397504 1907661376 18.888 97 23 46 1 1921323952 7382576 6280000
19:16:40 17198 8192000000 10876776272 11333304320 1930620240 19.072 99 19 38 0 1943460928 7655024 5185664
19:17:04 61319 8192000000 10863007952 11330183168 1823840816 18.209 93 18 36 0 1836347424 8034304 4472304
19:18:15 138700 8192000000 10848888640 11312439296 1822530560 18.198 93 19 38 1 1838180640 10084288 5565792
19:20:40 85819 8192000000 10841362912 11305504768 1872625776 18.606 96 8 16 0 1887328624 12273472 2429376
19:22:12 8963 8192000000 10854627840 11319898112 1932675680 19.088 100 20 40 1 1950059472 11348112 6035680
19:22:27 13189 8192000000 10872231600 11332231168 1929712416 19.065 100 6 12 1 1942655552 10376576 2566560
19:23:01 64604 8192000000 10844170512 11324350464 1879887584 18.664 97 12 24 1 1897482016 14097920 3496512
19:24:15 41146 8192000000 10852923408 11325988864 1916023280 18.955 99 8 16 0 1931644288 13238304 2382704
19:25:02 49123 8192000000 10853631840 11327754240 1915353504 18.950 99 15 30 1 1934567600 14928976 4285120
19:26:05 77243 8192000000 10870765776 11341807616 1923758832 19.017 99 13 26 0 1943094224 15115632 4219760

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 26-03-2021 19:29:32 to 26-03-2021 19:30:02.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 100 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 26-03-2021 19:30:03 to 26-03-2021 19:30:05.

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          244348
MON$OLDEST_ACTIVE               244853
MON$OLDEST_SNAPSHOT             244853
MON$NEXT_TRANSACTION            244853
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                       2025056
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:334: 
:335: mscs-test-161.budzdorov.ru    Fri Mar 26 19:27:36 2021
:336:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:337: 
:338: 
:339: mscs-test-161.budzdorov.ru    Fri Mar 26 19:27:36 2021
:340:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:341: 
:342: 
:343: mscs-test-161.budzdorov.ru    Fri Mar 26 19:27:44 2021
:344:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:345: 
:346: 
:347: mscs-test-161.budzdorov.ru    Fri Mar 26 19:27:47 2021
:348:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:349: 
--- end of diff output ---

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

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