Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 16.02.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 e0e7b46250ba4f9795ceb55e0face73f
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 2020-09-25 13:42
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.00
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 17091692 kB
MemAvailable 31135176 kB
Buffers 0 kB
Cached 14582492 kB
SwapCached 4088 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-02-16 19:27:15
DTS_END                         2021-02-16 19:27:15.0980
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/52470
TRN_ID                          240386
ATT_ID                          636
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: 9215.77 23328 1105892
customer order: creation 168.78 330 20254
customer order: refuse 14.84 352 1781
order to supplier: creation 46.02 1191 5522
order to supplier: removal 3.23 96440 388
invoice (draft): creation 46.53 3390 5584
invoice (draft): removal 52.64 687 6317
invoice accept: apply 41.31 18589 4957
invoice accept: cancel 47.23 686 5668
customer reserve: creation 3829.54 184 459545
customer reserve: removal 4672.07 52 560648
realization accept: apply 82.03 183 9844
realization accept: cancel 82.90 105 9948
payment from customer: creation 58.28 132 6993
payment from customer: removal 5.91 81 709
payment to supplier: creation 48.73 153 5848
payment to supplier: removal 3.37 80 404
service: total inventory turnovers 4.84 1007 581
service: total monetary turnovers 6.53 23 784
service: aggregate perf. data 0.94 16564 113
service: refresh index statistics 0.03 326333 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-02-2021 19:28:32 to 16-02-2021 19:28:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5392
TEST_TIME 2 3909
TEST_TIME 3 3489
TEST_TIME 4 3673
TEST_TIME 5 3870
TEST_TIME 6 3988
TEST_TIME 7 4280
TEST_TIME 8 4763
TEST_TIME 9 5147
TEST_TIME 10 5365
TEST_TIME 11 5772
TEST_TIME 12 5975
TEST_TIME 13 6221
TEST_TIME 14 6304
TEST_TIME 15 6412
TEST_TIME 16 6669
TEST_TIME 17 7145
TEST_TIME 18 7744
TEST_TIME 19 7896
TEST_TIME 20 8594
TEST_TIME 21 8966
TEST_TIME 22 9070
TEST_TIME 23 9372
TEST_TIME 24 10189
TEST_TIME 25 10321
TEST_TIME 26 10424
TEST_TIME 27 10391
TEST_TIME 28 10445
TEST_TIME 29 10302
TEST_TIME 30 10254
TEST_TIME 31 9971
TEST_TIME 32 9884
TEST_TIME 33 9718
TEST_TIME 34 9754
TEST_TIME 35 9725
TEST_TIME 36 9662
TEST_TIME 37 9615
TEST_TIME 38 9611
TEST_TIME 39 9505
TEST_TIME 40 9503
TEST_TIME 41 9566
TEST_TIME 42 9506
TEST_TIME 43 9390
TEST_TIME 44 9380
TEST_TIME 45 9451
TEST_TIME 46 9565
TEST_TIME 47 9646
TEST_TIME 48 9650
TEST_TIME 49 9662
TEST_TIME 50 9621
TEST_TIME 51 9766
TEST_TIME 52 9657
TEST_TIME 53 9756
TEST_TIME 54 9775
TEST_TIME 55 9766
TEST_TIME 56 9847
TEST_TIME 57 9952
TEST_TIME 58 10003
TEST_TIME 59 9899
TEST_TIME 60 9815
TEST_TIME 61 9747
TEST_TIME 62 9695
TEST_TIME 63 9681
TEST_TIME 64 9671
TEST_TIME 65 9577
TEST_TIME 66 9506
TEST_TIME 67 9480
TEST_TIME 68 9472
TEST_TIME 69 9576
TEST_TIME 70 9546
TEST_TIME 71 9534
TEST_TIME 72 9493
TEST_TIME 73 9503
TEST_TIME 74 9502
TEST_TIME 75 9558
TEST_TIME 76 9651
TEST_TIME 77 9599
TEST_TIME 78 9629
TEST_TIME 79 9643
TEST_TIME 80 9658
TEST_TIME 81 9662
TEST_TIME 82 9660
TEST_TIME 83 9566
TEST_TIME 84 9512
TEST_TIME 85 9431
TEST_TIME 86 9441
TEST_TIME 87 9484
TEST_TIME 88 9447
TEST_TIME 89 9400
TEST_TIME 90 9371
TEST_TIME 91 9310
TEST_TIME 92 9340
TEST_TIME 93 9317
TEST_TIME 94 9331
TEST_TIME 95 9305
TEST_TIME 96 9372
TEST_TIME 97 9351
TEST_TIME 98 9319
TEST_TIME 99 9420
TEST_TIME 100 9406
TEST_TIME 101 9414
TEST_TIME 102 9417
TEST_TIME 103 9470
TEST_TIME 104 9480
TEST_TIME 105 9460
TEST_TIME 106 9443
TEST_TIME 107 9473
TEST_TIME 108 9417
TEST_TIME 109 9374
TEST_TIME 110 9383
TEST_TIME 111 9337
TEST_TIME 112 9327
TEST_TIME 113 9298
TEST_TIME 114 9262
TEST_TIME 115 9264
TEST_TIME 116 9305
TEST_TIME 117 9320
TEST_TIME 118 9299
TEST_TIME 119 9270
TEST_TIME 120 9217

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 16-02-2021 19:28:36 to 16-02-2021 19:28:39.

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 1530919 1530919 0 0.00 0 33715 6 0 0
doc_list_biud 1530918 1530918 0 0.00 0 22840 24 0 0
sp_add_invoice_to_stock 5061 4957 104 2.05 26 225487 18589 0 104
sp_cancel_adding_invoice 5668 5668 0 0.00 4 44947 687 0 0
sp_cancel_client_order 1781 1781 0 0.00 4 15297 352 0 0
sp_cancel_customer_reserve 560648 560648 0 0.00 1 22842 53 0 0
sp_cancel_pay_from_customer 709 709 0 0.00 3 5124 81 0 0
sp_cancel_pay_to_supplier 404 404 0 0.00 2 4206 80 0 0
sp_cancel_supplier_invoice 6320 6317 3 0.04 1 20230 688 0 3
sp_cancel_supplier_order 388 388 0 0.00 7 1146714 96440 0 0
sp_cancel_write_off 9948 9948 0 0.00 1 12417 106 0 0
sp_client_order 20254 20254 0 0.00 4 18609 330 0 0
sp_customer_reserve 459545 459545 0 0.00 0 59287 184 0 0
sp_fill_shopping_cart 31356 31356 0 0.00 1 14056 38 0 0
sp_fill_shopping_cart_clo_res 459543 459543 0 0.00 0 14761 14 0 0
sp_get_clo_for_invoice 4955 4955 0 0.00 0 16802 266 0 0
sp_kill_cost_storno 16729 16729 0 0.00 0 11970 50 0 0
sp_kill_qstorno_ret_qs2qd 1137949 1137949 0 0.00 0 22836 28 0 0
sp_kill_qty_storno 599549 599549 0 0.00 0 22839 62 0 0
sp_lock_selected_doc 20590 20590 0 0.00 0 11592 5 0 0
sp_make_cost_storno 27640 27640 0 0.00 0 33648 58 0 0
sp_multiply_rows_for_pdistr 27640 27640 0 0.00 0 9718 30 0 0
sp_multiply_rows_for_qdistr 20254 20254 0 0.00 0 13822 155 0 0
sp_pay_from_customer 6993 6993 0 0.00 4 24722 133 0 0
sp_pay_to_supplier 5848 5848 0 0.00 4 14749 154 0 0
sp_payment_common 12841 12841 0 0.00 1 24711 48 0 0
sp_qd_handle_on_cancel_clo 1781 1781 0 0.00 0 15290 314 0 0
sp_qd_handle_on_invoice_upd_sts 10623 10623 0 0.00 0 22656 312 0 0
sp_qd_handle_on_reserve_upd_sts 9844 9844 0 0.00 0 20137 62 0 0
sp_reserve_write_off 9844 9844 0 0.00 6 20154 183 0 0
sp_supplier_invoice 5584 5584 0 0.00 6 103809 3390 0 0
sp_supplier_order 5522 5522 0 0.00 5 46810 1192 0 0
srv_aggregate_perf_data 113 113 0 0.00 2909 104654 16564 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 1219 148295 35044 0 0
srv_find_qd_qs_mism 1058260 1058260 0 0.00 0 12213 5 0 0
srv_make_invnt_saldo 581 581 0 0.00 34 51464 1008 0 0
srv_make_money_saldo 784 784 0 0.00 0 1962 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 190438 480984 326333 0 0
t$perf-abend:sp_add_invoice_to_stock 104 104 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4957 4957 0 0.00 0 13751 180 0 0
t$perf-norm:sp_cancel_adding_invoice 382 382 0 0.00 1 10425 126 0 0
t$perf-norm:sp_cancel_client_order 1781 1781 0 0.00 0 4450 10 0 0
t$perf-norm:sp_cancel_customer_reserve 705 705 0 0.00 0 2136 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 709 709 0 0.00 0 2041 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 404 404 0 0.00 0 16329 43 0 0
t$perf-norm:sp_cancel_supplier_invoice 420 420 0 0.00 0 2792 32 0 0
t$perf-norm:sp_cancel_supplier_order 388 388 0 0.00 0 35991 1745 0 0
t$perf-norm:sp_cancel_write_off 1002 1002 0 0.00 0 2943 9 0 0
t$perf-norm:sp_client_order 20254 20254 0 0.00 0 9843 18 0 0
t$perf-norm:sp_customer_reserve 1009 1009 0 0.00 0 6304 10 0 0
t$perf-norm:sp_pay_from_customer 6993 6993 0 0.00 0 7531 12 0 0
t$perf-norm:sp_pay_to_supplier 5848 5848 0 0.00 0 15046 13 0 0
t$perf-norm:sp_reserve_write_off 9844 9844 0 0.00 0 5919 13 0 0
t$perf-norm:sp_supplier_invoice 5584 5584 0 0.00 0 4509 18 0 0
t$perf-norm:sp_supplier_order 5522 5522 0 0.00 0 7748 20 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 440 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 366 6 0 0
t$perf-norm:srv_make_invnt_saldo 581 581 0 0.00 0 3765 28 0 0
t$perf-norm:srv_make_money_saldo 784 784 0 0.00 0 2672 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 73 20 0 0
v_add_invoice_to_stock 10118 9910 208 2.05 0 5773 21 0 208
v_all_customers 36490 36490 0 0.00 0 22 1 0 0
v_all_suppliers 30496 30496 0 0.00 0 22 1 0 0
v_all_wares 40508 40508 0 0.00 0 39 1 0 0
v_cancel_adding_invoice 764 764 0 0.00 0 1297 9 0 0
v_cancel_client_order 3562 3562 0 0.00 0 7730 9 0 0
v_cancel_customer_prepayment 1418 1418 0 0.00 0 308 4 0 0
v_cancel_customer_reserve 1410 1410 0 0.00 0 5278 12 0 0
v_cancel_payment_to_supplier 808 808 0 0.00 0 4170 14 0 0
v_cancel_supplier_invoice 846 840 6 0.70 0 1805 17 0 6
v_cancel_supplier_order 776 776 0 0.00 0 1863 6 0 0
v_cancel_write_off 2004 2004 0 0.00 0 1874 15 0 0
v_max_id_clo_ord 5520 5520 0 0.00 0 2535 2 0 0
v_max_id_clo_res 1009 1009 0 0.00 0 3158 20 0 0
v_max_id_ord_sup 5582 5582 0 0.00 0 7580 5 0 0
v_max_non_paid_invoice 1702 1702 0 0.00 0 187 2 0 0
v_max_non_paid_realizn 4011 4011 0 0.00 0 12505 6 0 0
v_min_id_clo_ord 5520 5520 0 0.00 0 1472 6 0 0
v_min_id_clo_res 1009 1009 0 0.00 0 6227 14 0 0
v_min_id_ord_sup 5582 5582 0 0.00 0 8565 5 0 0
v_min_non_paid_invoice 5848 5848 0 0.00 0 12585 36 0 0
v_min_non_paid_realizn 6993 6993 0 0.00 0 12583 27 0 0
v_our_firm 9982 9982 0 0.00 0 16 1 0 0
v_reserve_write_off 19688 19688 0 0.00 0 5021 6 0 0
x_lock_depdocs_on_canc_invoice 11565 11565 0 0.00 0 26875 118 0 0
x_lock_depdocs_on_canc_sup_ord 388 388 0 0.00 0 12104 363 0 0
x_make_qstorno_1000_1200 5522 5522 0 0.00 1 46792 1111 0 0
x_make_qstorno_1200_2000 5584 5584 0 0.00 3 103716 3258 0 0
x_make_qstorno_2100_3300 459545 459545 0 0.00 0 59284 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-02-2021 19:28:40 to 16-02-2021 19:28:44.

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:18 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:25 12451 8192000000 10220283872 10522316800 937369152 10.267 76 52 105 0 958528960 2538624 18621184
16:57:44 26790 8192000000 10316806784 10633453568 1352824704 14.173 100 81 163 0 1387924064 8620704 26478656
16:58:24 27015 8192000000 10379787872 10705031168 1418850096 14.763 100 90 180 2 1454735120 6075712 29809312
16:59:03 24977 8192000000 10409779680 10733809664 1461033792 15.135 100 89 178 0 1497888784 7372352 29482640
16:59:38 16790 8192000000 10417245376 10746269696 1475792432 15.265 100 91 182 1 1514060400 8151792 30116176
17:00:12 9459 8192000000 10425830272 10757545984 1484644096 15.342 100 89 178 0 1521675792 8348352 28683344
17:00:30 26292 8192000000 10441346816 10775748608 1499635200 15.473 100 88 176 1 1537156336 8928736 28592400
17:01:08 20679 8192000000 10462527232 10805411840 1513965200 15.598 100 86 172 0 1551046752 9474768 27606784
17:01:37 17452 8192000000 10488619168 10836172800 1547404064 15.888 100 79 158 0 1581534208 9875232 24254912
17:02:03 14321 8192000000 10523283056 10874081280 1575897904 16.133 100 85 170 2 1612297344 10473440 25926000
17:02:28 10246 8192000000 10540287408 10894565376 1601176816 16.349 100 77 154 1 1634436144 10219872 23039456
17:02:45 13375 8192000000 10560172576 10918125568 1618610336 16.498 100 76 152 1 1652151408 10495488 23045584
17:03:07 13720 8192000000 10591209680 10952830976 1643686032 16.711 100 78 156 0 1677570288 11140112 22744144
17:03:31 7203 8192000000 10595721408 10960547840 1657885856 16.831 100 76 152 1 1692795280 12019248 22890176
17:03:49 11464 8192000000 10618069488 10985119744 1677911120 17.000 100 75 150 1 1711426464 11961648 21553696
17:04:07 11312 8192000000 10647243040 11015692288 1696413376 17.155 100 76 153 0 1731032672 12811568 21807728
17:04:26 8798 8192000000 10661089456 11032027136 1714945760 17.310 100 77 154 0 1750069056 13186592 21936704
17:04:43 6026 8192000000 10665100608 11041333248 1726231456 17.404 100 77 153 2 1761158336 13344176 21582704
17:04:55 7698 8192000000 10665836336 11042283520 1735968592 17.485 100 83 166 2 1773615728 13857168 23789968
17:05:10 4310 8192000000 10686357104 11061248000 1747255280 17.579 100 81 161 2 1783243408 12886368 23101760
17:05:21 5948 8192000000 10692706256 11071639552 1755220272 17.645 100 78 155 0 1789200560 12579072 21401216
17:05:37 4496 8192000000 10702920992 11081207808 1768753552 17.757 100 80 158 1 1803804000 12596576 22453872
17:05:48 4089 8192000000 10702535376 11087896576 1771509696 17.779 100 78 153 3 1806935408 13906512 21519200
17:05:59 3982 8192000000 10722330736 11098099712 1780135408 17.851 100 89 178 2 1818911312 13691568 25084336
17:06:11 7510 8192000000 10722975520 11105021952 1781585728 17.863 100 77 152 2 1816370352 13741136 21043488
17:06:25 2967 8192000000 10740249104 11123163136 1799543632 18.010 100 78 156 0 1834616384 13043392 22029360
17:06:35 3167 8192000000 10745989536 11128803328 1805185760 18.056 100 83 167 0 1842380000 13974992 23219248
17:06:45 2940 8192000000 10747958880 11130900480 1814611600 18.134 100 87 174 4 1851757792 12992960 24153232
17:06:55 2606 8192000000 10753490960 11140956160 1817884688 18.160 100 87 171 5 1856105040 13953424 24266928
17:07:04 2989 8192000000 10765396640 11152556032 1821306176 18.188 100 82 163 0 1857302288 12849264 23146848
17:07:14 2422 8192000000 10772127328 11154780160 1829393200 18.254 100 91 183 1 1867397632 12370192 25634240
17:07:22 1553 8192000000 10776631936 11160698880 1836957408 18.316 100 93 187 0 1876688080 13521776 26208896
17:07:31 2652 8192000000 10775425296 11161079808 1833752224 18.290 100 81 162 2 1869973360 13812160 22408976
17:07:40 2328 8192000000 10789086464 11172024320 1841520240 18.353 100 90 180 1 1880581040 14501536 24559264
17:07:49 2112 8192000000 10790916832 11174621184 1843843792 18.372 100 94 188 0 1885447616 15311136 26292688
17:07:57 1603 8192000000 10792223456 11176648704 1847190160 18.399 100 94 187 1 1887304688 13957392 26157136
17:08:06 1446 8192000000 10789674544 11174903808 1852703408 18.444 100 94 186 0 1892151712 13069520 26378784
17:08:13 1654 8192000000 10794881456 11179872256 1856214576 18.473 100 92 184 1 1894886624 12763744 25908304
17:08:21 1404 8192000000 10806461920 11191181312 1855774032 18.469 100 93 184 1 1895046048 12838016 26434000
17:08:29 1366 8192000000 10804575328 11191017472 1862346720 18.522 100 92 183 1 1902012016 12912448 26752848
17:08:38 40569 8192000000 10789310736 11192020992 1856257600 18.473 100 60 118 1 1884990144 10783344 17949200
17:09:25 6466 8192000000 10803863936 11198189568 1867876608 18.567 100 68 138 2 1897664096 10665568 19121920
17:09:38 12400 8192000000 10761692768 11193806848 1860810368 18.510 100 35 69 1 1880320576 9091328 10418880
17:09:58 6417 8192000000 10772390080 11197468672 1860470768 18.507 100 35 70 0 1876674992 6350064 9854160
17:10:11 9254 8192000000 10770571440 11197874176 1866284080 18.554 100 29 59 4 1885690976 11327920 8078976
17:10:26 7847 8192000000 10782455072 11212578816 1872245856 18.602 100 25 50 0 1884976784 6116224 6614704
17:10:45 6933 8192000000 10777432208 11208654848 1874634512 18.622 100 19 38 1 1886122784 6047808 5440464
17:11:01 6144 8192000000 10789686544 11216928768 1878148160 18.650 100 16 32 1 1892585936 9968528 4469248
17:11:13 8464 8192000000 10787178128 11217346560 1880667776 18.670 100 20 40 0 1892795120 6029088 6098256
17:11:31 15447 8192000000 10779531136 11217002496 1881036096 18.673 100 21 41 3 1892596576 5906592 5653888
17:11:53 15414 8192000000 10791680944 11223425024 1883371424 18.692 100 17 34 2 1894243360 5926656 4945280
17:12:15 8299 8192000000 10787896512 11225149440 1887748000 18.728 100 17 34 3 1898377792 5608640 5021152
17:12:29 7803 8192000000 10788821264 11228229632 1886414496 18.717 100 9 18 0 1894142688 5658832 2069360
17:12:44 6236 8192000000 10796192656 11229642752 1890718624 18.752 100 30 59 2 1906139952 7076160 8345168
17:12:57 12196 8192000000 10805065952 11239829504 1892032896 18.762 100 16 32 1 1901956464 5452912 4470656
17:13:18 7348 8192000000 10798858992 11236765696 1896393296 18.797 100 24 48 1 1909262240 6147776 6721168
17:13:35 57148 8192000000 10846879840 11253235712 1907760768 18.889 100 49 98 2 1928422400 5824304 14837328
17:14:39 3691 8192000000 10816865424 11250544640 1901720608 18.840 100 28 56 0 1917959440 7918976 8319856
17:14:49 7994 8192000000 10817414400 11250548736 1902989920 18.850 100 21 41 1 1914365808 5811504 5564384
17:15:05 7285 8192000000 10825861584 11254075392 1905460160 18.870 100 30 60 0 1920226464 5447280 9319024
17:15:18 3148 8192000000 10835429248 11254804480 1905946304 18.874 100 31 62 1 1921574688 6967456 8660928
17:15:29 4593 8192000000 10829876304 11255439360 1906345728 18.877 100 33 67 0 1922710592 6339120 10025744
17:15:39 5619 8192000000 10816775360 11247722496 1888190048 18.731 99 34 68 1 1905292000 7479072 9622880
17:15:52 6902 8192000000 10806263616 11240812544 1880016464 18.665 99 32 64 0 1895484032 6327456 9140112
17:16:08 6814 8192000000 10814559968 11248672768 1897585568 18.807 100 25 50 2 1911256608 6570688 7100352
17:16:21 12562 8192000000 10798912928 11232665600 1842026912 18.357 97 12 24 1 1851132976 5601760 3504304
17:16:40 5507 8192000000 10803982320 11239268352 1890828048 18.752 100 26 52 0 1904597488 6399984 7369456
17:16:54 6547 8192000000 10784718432 11217756160 1834639936 18.297 97 16 32 0 1844784736 5638032 4506768
17:17:08 6315 8192000000 10768700544 11203760128 1840294144 18.343 98 29 57 4 1854160320 6081072 7785104
17:17:22 7786 8192000000 10782151104 11209252864 1848001664 18.406 99 20 40 0 1859745392 6398336 5345392
17:17:36 9212 8192000000 10749886992 11179003904 1811158352 18.105 98 12 24 0 1820209568 5788560 3262656
17:17:52 55660 8192000000 10751848192 11162640384 1738884480 17.509 94 16 32 1 1748325568 5359584 4081504
17:18:58 11496 8192000000 10737262416 11164975104 1803013024 18.039 98 26 52 1 1817544128 7516352 7014752
17:19:18 8156 8192000000 10763967104 11188400128 1833516464 18.288 99 30 60 0 1848529808 6821856 8191488
17:19:36 3627 8192000000 10751965120 11166281728 1821829008 18.193 100 36 70 2 1838338336 6668352 9840976
17:19:46 8081 8192000000 10712444080 11123376128 1678382704 17.004 92 24 48 1 1691278256 6152048 6743504
17:20:02 7256 8192000000 10699317824 11117043712 1730154976 17.437 96 27 54 2 1742868912 5308752 7405184
17:20:16 5750 8192000000 10683120992 11098267648 1735573552 17.482 96 29 56 2 1749983808 5813104 8597152
17:20:29 7168 8192000000 10688092576 11099267072 1736392816 17.489 97 31 60 2 1751391888 5523776 9475296
17:20:42 5902 8192000000 10698698048 11110256640 1726215968 17.404 96 26 52 1 1739501184 5186272 8098944
17:20:56 4368 8192000000 10706858384 11116113920 1742330608 17.538 97 26 52 0 1755995456 6659792 7005056
17:21:06 5141 8192000000 10678773936 11086163968 1716115312 17.320 96 23 46 2 1729296016 5678400 7502304
17:21:23 10206 8192000000 10703227504 11114758144 1770611248 17.772 99 27 54 1 1784741040 5780304 8349488
17:21:39 8392 8192000000 10714729968 11123830784 1759214320 17.678 98 26 52 2 1771711200 5358176 7138704
17:21:54 9445 8192000000 10713040704 11137318912 1789157776 17.925 99 17 32 2 1799775680 5869952 4747952
17:22:10 3703 8192000000 10727520624 11146698752 1796200432 17.983 99 23 46 1 1808623488 6303696 6119360
17:22:22 17924 8192000000 10704954240 11134693376 1789241280 17.926 98 39 79 1 1806071392 5993424 10836688
17:23:11 38199 8192000000 10751542912 11174678528 1831626528 18.273 100 21 40 0 1842738112 4926352 6185232
17:23:55 5707 8192000000 10741780832 11168321536 1819620672 18.175 99 24 49 1 1832475088 6269008 6585408
17:24:08 4567 8192000000 10762877712 11181580288 1843330912 18.368 100 41 81 2 1860064816 5678640 11055264
17:24:21 6564 8192000000 10763868928 11189964800 1846112352 18.391 100 24 48 5 1859409680 6783200 6514128
17:24:34 7091 8192000000 10761432560 11193372672 1850817408 18.429 100 27 54 0 1865522528 6662976 8042144
17:24:50 6385 8192000000 10774933184 11194855424 1853265856 18.449 100 31 62 1 1868377472 5314576 9797040
17:25:05 6990 8192000000 10765685392 11200466944 1856744048 18.477 100 27 54 3 1870831248 6461056 7626144
17:25:20 6220 8192000000 10771582864 11204685824 1863629008 18.533 100 28 55 3 1877458144 6550368 7278768
17:25:33 5505 8192000000 10781899696 11208331264 1867970992 18.568 100 26 53 2 1881398288 5581632 7845664
17:25:46 8026 8192000000 10794644208 11212906496 1870629760 18.589 100 31 62 1 1888939984 9266048 9044176
17:26:00 15720 8192000000 10782769104 11216490496 1871411552 18.596 100 15 30 1 1882010352 5841600 4757200
17:26:22 10728 8192000000 10784511776 11221454848 1876371296 18.636 100 25 50 2 1888899312 5864928 6663088
17:26:43 13346 8192000000 10791440576 11227320320 1880865616 18.672 100 18 35 2 1891521584 5442880 5213088
17:27:05 12529 8192000000 10816428496 11243417600 1895013888 18.786 100 19 35 0 1904496800 4911168 4571744
17:27:29 45405 8192000000 10845224576 11270070272 1916365312 18.958 100 37 75 5 1931256208 4936080 9954816
17:28:24 32915 8192000000 10864022464 11284283392 1929079520 19.060 100 43 85 3 1948776560 7115280 12581760
17:29:07 14346 8192000000 10875029488 11301543936 1940711024 19.152 100 46 89 2 1967607600 14614544 12282032
17:29:34 100528 8192000000 10882625968 11317108736 1951903280 19.242 100 50 98 1 1980469296 14004928 14561088
17:31:28 36265 8192000000 10884099776 11323084800 1952647760 19.248 100 27 53 0 1974109280 13503968 7957552
17:32:12 30162 8192000000 10885424736 11324665856 1940717552 19.152 99 32 60 3 1965210128 14904912 9587664
17:32:58 6747 8192000000 10897579104 11329449984 1959907536 19.305 100 38 74 2 1986328688 14941984 11479168
17:33:19 16205 8192000000 10897979536 11336728576 1965760928 19.352 100 39 78 1 1993859536 16397984 11700624
17:34:00 41989 8192000000 10896485024 11346124800 1969631472 19.383 100 32 63 2 1997689184 17737344 10320368
17:34:48 8588 8192000000 10921017200 11352219648 1976060928 19.433 100 57 110 2 2010413984 16967712 17385344
17:35:06 7837 8192000000 10913315520 11338674176 1955962672 19.274 99 62 122 2 1993962640 19634080 18365888
17:35:26 12148 8192000000 10919535696 11348365312 1971629840 19.398 100 62 122 3 2009050848 19636496 17784512
17:35:46 15197 8192000000 10915888336 11354148864 1974462352 19.421 100 55 109 1 2011416976 20308160 16646464
17:36:15 2952 8192000000 10926479760 11360931840 1985181984 19.506 100 58 114 0 2022422976 19031104 18209888
17:36:27 5685 8192000000 10920668864 11347288064 1971115792 19.394 100 56 111 0 2005749088 17850592 16782704
17:36:41 5455 8192000000 10930492768 11355844608 1979138400 19.458 100 64 126 0 2016624144 19307408 18178336
17:36:58 7896 8192000000 10944172112 11370967040 1988869760 19.535 100 67 135 1 2029969984 21679888 19420336
17:37:17 9219 8192000000 10959848096 11379150848 1997531216 19.603 100 75 148 0 2041883520 22842016 21510288
17:37:35 10149 8192000000 10952577952 11378827264 1997388768 19.602 100 71 141 2 2041354048 23127456 20837824
17:37:54 4387 8192000000 10936670336 11365658624 1978804384 19.455 99 56 112 0 2018674976 23117248 16753344
17:38:05 4326 8192000000 10957165840 11377516544 1994837968 19.582 100 74 147 1 2041555760 25066512 21651280
17:38:16 8857 8192000000 10973304416 11391541248 2001875040 19.638 100 73 146 0 2050149552 26614128 21660384
17:38:35 1736 8192000000 10961312512 11373674496 1993853136 19.574 100 82 162 1 2043751200 26261552 23636512
17:38:44 1218 8192000000 10949989440 11366166528 1984592496 19.501 100 89 177 1 2038167296 26890128 26684672
17:38:54 1475 8192000000 10918727792 11327983616 1944212400 19.180 98 89 173 0 1996514928 26582624 25719904
17:39:02 13156 8192000000 10939780224 11365117952 1979114400 19.458 100 68 136 0 2024203888 25374336 19715152
17:39:25 4777 8192000000 10950423568 11372163072 1988149072 19.529 100 79 156 0 2034966816 23813312 23004432
17:39:37 1821 8192000000 10965374496 11376533504 1994052512 19.576 100 87 172 1 2044953440 24824624 26076304
17:39:46 11668 8192000000 10961016272 11382419456 1996441040 19.595 100 77 152 0 2046612288 27413952 22757296
17:40:04 7786 8192000000 10962123648 11388846080 1997605328 19.604 100 66 131 3 2045246224 27624000 20016896
17:40:18 4339 8192000000 10972554672 11400212480 2007230016 19.680 100 73 146 3 2059487536 30234368 22023152
17:40:33 10975 8192000000 10935541376 11361599488 1966418944 19.357 99 59 118 1 2014101600 29371040 18311616
17:40:51 4975 8192000000 10931932400 11359375360 1952095152 19.243 98 62 121 1 2000501456 29232016 19174288
17:41:05 3714 8192000000 10954495872 11380236288 1988091232 19.529 100 75 150 1 2042529408 29739408 24698768
17:41:20 3899 8192000000 10957539760 11381673984 1990210992 19.545 100 67 132 3 2040332000 29100720 21020288
17:41:31 3566 8192000000 10969089488 11388530688 1981533456 19.477 99 89 177 2 2039231872 31212432 26485984
17:41:42 5082 8192000000 10949448880 11372478464 1977478480 19.445 100 74 146 1 2033259648 33262000 22519168
17:41:57 6080 8192000000 10956607264 11385606144 1986374096 19.515 100 73 144 3 2044578512 35620816 22583600
17:42:15 4049 8192000000 10962558688 11387621376 1977843792 19.448 99 69 137 0 2036706736 37117280 21745664
17:42:27 3049 8192000000 10947733440 11354849280 1935295520 19.109 97 89 177 1 1999732272 37161648 27275104
17:42:37 2643 8192000000 10962218560 11377430528 1977722640 19.447 100 78 154 2 2040879072 38223056 24933376
17:42:49 4663 8192000000 10967202320 11379134464 1980641360 19.470 100 80 156 1 2042559216 37687424 24230432
17:43:02 2133 8192000000 10973928656 11383595008 1983770128 19.495 100 93 187 1 2052283968 39310288 29203552
17:43:11 4659 8192000000 10961122832 11372441600 1976969536 19.441 100 87 173 2 2044330576 40166896 27194144
17:43:23 2292 8192000000 10955380208 11368456192 1959919568 19.305 99 86 172 2 2029546528 41996048 27630912
17:43:33 4763 8192000000 10946049488 11360395264 1962010912 19.322 100 78 157 3 2030366224 42949232 25406080
17:43:44 1566 8192000000 10938893408 11352764416 1950839936 19.233 100 82 164 1 2020305168 42944016 26521216
17:43:53 2931 8192000000 10950656640 11368714240 1966482624 19.358 100 82 164 1 2036131824 43653472 25995728
17:44:05 3617 8192000000 10937852224 11361017856 1956991728 19.282 99 69 136 2 2023596592 44326656 22278208
17:44:16 3292 8192000000 10961148688 11375038464 1969235120 19.379 100 89 175 3 2040372016 43578208 27558688
17:44:29 3208 8192000000 10961807216 11379388416 1973806928 19.416 100 76 148 0 2040615792 42852576 23956288
17:44:40 2292 8192000000 10979134384 11387531264 1982165728 19.482 100 84 168 3 2051828864 43005632 26657504
17:44:49 1936 8192000000 10965376304 11387408384 1981257600 19.475 100 76 152 1 2051583824 45863584 24462640
17:45:02 4364 8192000000 10953545008 11385389056 1975839232 19.432 100 66 132 0 2042289568 44951376 21498960
17:45:20 12559 8192000000 10924763168 11376087040 1951308464 19.237 99 47 94 1 2015406704 47216448 16881792
17:45:40 6314 8192000000 10936119792 11377127424 1967062688 19.362 100 46 92 2 2025189456 42713712 15413056
17:45:54 5597 8192000000 10940587408 11367448576 1947442656 19.206 99 60 121 1 2009559616 42534880 19582080
17:46:09 4373 8192000000 10958466608 11377700864 1967735040 19.367 100 67 132 2 2032667408 44104368 20828000
17:46:20 3891 8192000000 10930723168 11344388096 1931850000 19.082 99 82 159 1 2001153456 43737488 25565968
17:46:33 5022 8192000000 10949891968 11373084672 1958122448 19.291 100 75 150 0 2029245584 47555808 23567328
17:46:46 3144 8192000000 10943081136 11363643392 1957483584 19.286 100 81 162 0 2030157216 48056256 24617376
17:46:56 5211 8192000000 10942301920 11373371392 1958399760 19.293 100 63 126 0 2027563696 49364288 19799648
17:47:08 18569 8192000000 10915146432 11363307520 1936912320 19.122 99 37 74 2 1994719088 45475680 12331088
17:47:38 11846 8192000000 10911110400 11353210880 1911823264 18.921 98 36 70 2 1968817760 45251744 11742752
17:47:59 17043 8192000000 10896390880 11336998912 1889584576 18.742 97 30 59 0 1938436352 38453712 10398064
17:48:25 31394 8192000000 10884218880 11326439424 1899973088 18.826 98 20 40 0 1939525408 32839776 6712544
17:49:05 7502 8192000000 10901396992 11335524352 1933072880 19.091 100 49 96 2 1984192048 36235024 14884144
17:49:46 24332 8192000000 10872363760 11327008768 1878239120 18.651 97 16 32 0 1918914656 35154496 5521040
17:50:32 16407 8192000000 10865553120 11316310016 1902193360 18.844 99 12 24 1 1939100608 32831744 4075504
17:51:31 29485 8192000000 10867044208 11334246400 1924942992 19.026 100 14 27 2 1962375440 32349200 5083248
17:52:07 7709 8192000000 10898810592 11339415552 1946488304 19.198 100 39 78 1 1975404688 16364864 12551520
17:52:58 54925 8192000000 10881153312 11318145024 1879346512 18.660 97 12 23 0 1896940512 14434784 3159216
17:54:09 101805 8192000000 10850399664 11305660416 1862896272 18.527 96 13 26 1 1875547808 9300272 3351264
17:55:59 106791 8192000000 10855638224 11305455616 1825072080 18.219 94 21 42 0 1838615904 8127968 5415856
17:58:10 112249 8192000000 10864788176 11323273216 1925543584 19.031 99 30 60 0 1940158416 6261616 8353216
18:00:11 42103 8192000000 10863380272 11315707904 1925075792 19.027 99 22 44 2 1937104736 5857808 6171136
18:01:04 12058 8192000000 10879946160 11326824448 1948632736 19.216 100 27 54 0 1963050688 6439728 7978224
18:01:23 43258 8192000000 10887652240 11338510336 1942571328 19.167 99 35 69 2 1960295088 7860336 9863424
18:02:13 40602 8192000000 10895720192 11352633344 1959976304 19.306 100 41 82 2 1984270704 11494608 12799792
18:03:03 28322 8192000000 10890109584 11349037056 1961556576 19.318 100 22 44 0 1979516240 11409840 6549824
18:03:42 21778 8192000000 10905574000 11352690688 1951320288 19.237 99 33 66 0 1970825424 9931168 9573968
18:04:23 56897 8192000000 10884330272 11353128960 1927751488 19.049 98 19 38 1 1946714512 13274976 5688048
18:05:26 28172 8192000000 10894258304 11360583680 1961791440 19.320 100 8 16 0 1976574816 12628304 2155072
18:06:05 76059 8192000000 10901358560 11366064128 1975514080 19.429 100 14 28 0 1991652160 11827296 4310784
18:07:27 22302 8192000000 10917013104 11371290624 1965295968 19.348 99 27 54 2 1989467136 16275648 7895520
18:08:04 55082 8192000000 10920344416 11390152704 1968896288 19.377 99 23 46 0 1999685312 23424736 7364288
18:10:05 33924 8192000000 10919619104 11377766400 1971846416 19.400 100 28 57 1 1994662896 14725328 8091152
18:10:45 48207 8192000000 10910273136 11385982976 1970155184 19.387 100 14 28 0 1994806240 20309488 4341568
18:11:43 27028 8192000000 10907789216 11389911040 1973394688 19.412 100 10 20 1 1998328624 21929936 3004000
18:12:16 70799 8192000000 10924822176 11395858432 1946667248 19.200 98 19 38 1 1970661104 18260064 5733792
18:13:33 71362 8192000000 10924925760 11409166336 1988666736 19.533 100 20 39 0 2018775024 23923856 6184432
18:14:54 51032 8192000000 10950719472 11406692352 1975758592 19.431 99 27 54 0 1994663232 11636480 7268160
18:15:54 36980 8192000000 10945124368 11413004288 2005822528 19.669 100 24 46 1 2024114912 11652800 6639584
18:16:40 51702 8192000000 10941712016 11414581248 2008023136 19.686 100 16 32 0 2029842560 17118384 4701040
18:17:48 71076 8192000000 10920538240 11400900608 1950082240 19.227 97 17 34 0 1970199296 14987040 5130016
18:19:07 28359 8192000000 10917748592 11374796800 1934646960 19.104 97 13 26 1 1946109408 7861136 3601312
18:19:51 34601 8192000000 10906346976 11359641600 1968150784 19.371 99 30 59 1 1988418240 11394192 8873264
18:20:32 56525 8192000000 10922989136 11396141056 1987988576 19.528 100 19 38 1 2005665120 12105280 5571264
18:21:35 56490 8192000000 10929854704 11400077312 1978430000 19.452 99 20 40 1 2000164192 16185376 5548816
18:22:38 73665 8192000000 10920935952 11402493952 1922686896 19.008 97 10 20 1 1939403072 14353200 2362976
18:23:58 69393 8192000000 10930274192 11407986688 1985214640 19.506 100 12 24 1 2013426816 24534528 3677648
18:25:14 58447 8192000000 10902074032 11372892160 1916827504 18.961 97 15 30 1 1941802816 20648416 4326896
18:26:20 100450 8192000000 10881438144 11349385216 1910192000 18.908 97 13 26 0 1929657936 15917456 3548480
18:28:07 58123 8192000000 10906779584 11369586688 1962594896 19.327 99 40 79 2 1981092864 7778880 10719088
18:29:17 22956 8192000000 10892898288 11361603584 1954370624 19.261 99 25 50 1 1970133824 9260304 6502896
18:29:57 9356 8192000000 10891557712 11344023552 1938922048 19.138 99 31 62 2 1955859360 9110496 7826816
18:30:15 33763 8192000000 10890276464 11345317888 1910054608 18.907 97 24 48 0 1925587376 8952464 6580304
18:31:02 25008 8192000000 10870584832 11323219968 1878624480 18.654 96 31 61 2 1897472512 10530096 8317936
18:31:33 29459 8192000000 10831332352 11302539264 1902130384 18.843 99 11 22 0 1912398128 7503984 2763760
18:33:15 58137 8192000000 10885872320 11355131904 1951734160 19.240 100 17 34 0 1968823680 11969008 5120512
18:35:36 95806 8192000000 10872982768 11364749312 1921446256 18.998 99 12 24 0 1948949584 24081536 3421792
18:37:19 61033 8192000000 10855276032 11315949568 1843449984 18.369 95 17 33 0 1859179648 11157120 4572544
18:38:54 71654 8192000000 10828444784 11301892096 1848649776 18.411 96 28 56 3 1866326704 9734752 7942176
18:40:25 56462 8192000000 10876427216 11318923264 1874946160 18.624 97 33 65 3 1897885920 13674240 9265520
18:41:34 94890 8192000000 10866487296 11352240128 1917231728 18.965 99 14 28 0 1941248176 20373200 3643248
18:43:21 80128 8192000000 10857679840 11308552192 1852130464 18.439 96 10 20 0 1869844144 15122336 2591344
18:44:47 24459 8192000000 10875026640 11321724928 1927320080 19.045 100 45 90 1 1949094288 9015376 12758832
18:45:18 68048 8192000000 10851595248 11307601920 1871763376 18.599 97 23 46 3 1888318912 10297104 6258432
18:46:37 66679 8192000000 10858098048 11336712192 1888696144 18.735 98 21 42 1 1907444480 12594912 6153424
18:47:58 66436 8192000000 10879601216 11320868864 1862552080 18.524 96 28 56 0 1880810416 10685280 7573056
18:49:13 10992 8192000000 10892362624 11331194880 1925989728 19.035 99 62 124 1 1953306160 10003696 17312736
18:49:36 115939 8192000000 10866622272 11327610880 1895125072 18.787 98 28 56 0 1912466816 9937904 7403840
18:51:42 74474 8192000000 10874338112 11336572928 1921243408 18.997 99 21 42 1 1939745360 12796816 5705136
18:53:11 39033 8192000000 10868321904 11344445440 1940753936 19.153 100 16 32 1 1958281152 12540672 4986544
18:54:02 50035 8192000000 10857933856 11345739776 1919914112 18.986 99 12 22 1 1938079120 14968496 3196512
18:55:03 53963 8192000000 10858798480 11340972032 1942642816 19.168 100 5 10 0 1954715920 10814800 1258304
18:56:49 61564 8192000000 10881088304 11357556736 1915039872 18.947 98 18 36 2 1930789360 10930048 4819440
18:57:58 70827 8192000000 10879427696 11359178752 1955284320 19.269 100 18 37 2 1979024176 18446288 5293568
18:59:38 55921 8192000000 10874986576 11358785536 1941904208 19.162 99 14 27 1 1955313280 9771872 3637200
19:01:08 73732 8192000000 10891903248 11377164288 1931888704 19.082 98 10 20 0 1944743056 10524416 2329936
19:02:29 80830 8192000000 10886599008 11365888000 1910461264 18.910 97 17 34 1 1930615664 15485200 4669200
19:03:56 46958 8192000000 10908153408 11373428736 1968461840 19.373 100 19 38 1 1982768448 9022432 5284176
19:04:49 22775 8192000000 10918617152 11376308224 1962242032 19.324 99 44 89 3 1987262672 12692736 12327904
19:05:22 34215 8192000000 10919733024 11387920384 1986334912 19.515 100 41 80 0 2016181312 18594912 11251488
19:06:08 65854 8192000000 10904948288 11369476096 1937849936 19.130 98 13 26 1 1955496240 13707056 3939248
19:07:26 54619 8192000000 10885962176 11358208000 1927570912 19.047 98 23 46 1 1944165280 10388560 6205808
19:08:28 47224 8192000000 10897321808 11360989184 1874168128 18.618 95 33 66 3 1898411136 15728592 8514416
19:09:24 76047 8192000000 10885982144 11356581888 1887572912 18.726 96 27 55 0 1913351408 18873728 6904768
19:10:53 80559 8192000000 10873335456 11352956928 1885613088 18.710 96 28 56 2 1904477808 11207776 7656944
19:12:20 42015 8192000000 10877426640 11332546560 1891777296 18.760 97 30 60 0 1910098320 9485936 8835088
19:13:11 35722 8192000000 10899983936 11350294528 1933143744 19.092 99 45 90 0 1956596160 10727888 12724528
19:13:53 23282 8192000000 10918497920 11372748800 1968184560 19.371 100 47 93 1 1995857952 14069072 13604320
19:14:23 106109 8192000000 10872132480 11341856768 1881943744 18.681 96 18 36 1 1898815520 11856928 5014848
19:16:21 76936 8192000000 10884039760 11371372544 1950794928 19.233 100 16 32 0 1969981360 14659520 4526912
19:18:24 80882 8192000000 10886335920 11373604864 1961707808 19.320 100 14 29 0 1982543392 15706704 5128880
19:19:56 51438 8192000000 10877713680 11361402880 1929386480 19.062 98 12 24 0 1950654016 17494768 3772768
19:21:01 64296 8192000000 10893077728 11372888064 1938651520 19.136 99 20 41 1 1966825344 21875584 6298240
19:22:26 75670 8192000000 10878904944 11358896128 1916075152 18.955 98 14 28 2 1939242304 19419472 3747680
19:23:48 148295 8192000000 10841217488 11327037440 1730552480 17.440 89 8 16 0 1748732160 16279552 1900128
19:26:22 25164 8192000000 10847349344 11309887488 1856671280 18.476 96 23 46 0 1870309936 7168048 6470608
19:26:55 28446 8192000000 9363888048 9652535296 517164832 5.938 27 5 8 1 523446880 4893008 1389040

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 16-02-2021 19:28:46 to 16-02-2021 19:29:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 104 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-02-2021 19:29:18 to 16-02-2021 19:29:20.

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          241038
MON$OLDEST_ACTIVE               241039
MON$OLDEST_SNAPSHOT             241039
MON$NEXT_TRANSACTION            241039
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                       2022208
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.33416 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33416 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33416 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33416 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 ---
:23: 
:24: mscs-test-161.budzdorov.ru    Tue Feb 16 19:27:28 2021
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
--- end of diff output ---

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

16.02.21 19:29:21. 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-02-16 19:29:23 No severe PSQL-related problems occured
16.02.21 19:29:24. End of report.