Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 23.01.2021 19:27
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 17253224 kB
MemAvailable 31272480 kB
Buffers 0 kB
Cached 14418796 kB
SwapCached 4868 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-01-23 19:27:12
DTS_END                         2021-01-23 19:27:12.3540
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/50572
TRN_ID                          247196
ATT_ID                          681
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: 9340.81 22410 1120897
customer order: creation 179.07 352 21488
customer order: refuse 15.86 328 1903
order to supplier: creation 48.19 1248 5783
order to supplier: removal 3.63 96047 435
invoice (draft): creation 48.27 3098 5792
invoice (draft): removal 51.61 741 6193
invoice accept: apply 43.98 17574 5277
invoice accept: cancel 46.14 802 5537
customer reserve: creation 4051.20 175 486144
customer reserve: removal 4557.69 60 546923
realization accept: apply 87.94 169 10553
realization accept: cancel 73.39 129 8807
payment from customer: creation 60.75 116 7290
payment from customer: removal 5.83 77 700
payment to supplier: creation 51.52 129 6182
payment to supplier: removal 3.56 68 427
service: total inventory turnovers 4.82 1210 578
service: total monetary turnovers 6.42 33 770
service: aggregate perf. data 0.93 16188 111
service: refresh index statistics 0.03 309652 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-01-2021 19:28:07 to 23-01-2021 19:28:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4763
TEST_TIME 2 4978
TEST_TIME 3 4541
TEST_TIME 4 4608
TEST_TIME 5 4385
TEST_TIME 6 4115
TEST_TIME 7 4354
TEST_TIME 8 4584
TEST_TIME 9 5378
TEST_TIME 10 5662
TEST_TIME 11 5849
TEST_TIME 12 6316
TEST_TIME 13 6503
TEST_TIME 14 6422
TEST_TIME 15 6525
TEST_TIME 16 6657
TEST_TIME 17 7095
TEST_TIME 18 7347
TEST_TIME 19 7787
TEST_TIME 20 8238
TEST_TIME 21 8833
TEST_TIME 22 9002
TEST_TIME 23 8783
TEST_TIME 24 9450
TEST_TIME 25 9444
TEST_TIME 26 10062
TEST_TIME 27 10706
TEST_TIME 28 10853
TEST_TIME 29 10705
TEST_TIME 30 10659
TEST_TIME 31 10708
TEST_TIME 32 10575
TEST_TIME 33 10433
TEST_TIME 34 10246
TEST_TIME 35 10066
TEST_TIME 36 10176
TEST_TIME 37 10038
TEST_TIME 38 10033
TEST_TIME 39 9901
TEST_TIME 40 9904
TEST_TIME 41 9879
TEST_TIME 42 9892
TEST_TIME 43 9803
TEST_TIME 44 9711
TEST_TIME 45 9933
TEST_TIME 46 9960
TEST_TIME 47 9840
TEST_TIME 48 9898
TEST_TIME 49 9958
TEST_TIME 50 9901
TEST_TIME 51 9867
TEST_TIME 52 9962
TEST_TIME 53 10038
TEST_TIME 54 9979
TEST_TIME 55 9939
TEST_TIME 56 9921
TEST_TIME 57 9790
TEST_TIME 58 9759
TEST_TIME 59 9873
TEST_TIME 60 9764
TEST_TIME 61 9713
TEST_TIME 62 9748
TEST_TIME 63 9744
TEST_TIME 64 9626
TEST_TIME 65 9635
TEST_TIME 66 9578
TEST_TIME 67 9634
TEST_TIME 68 9616
TEST_TIME 69 9601
TEST_TIME 70 9653
TEST_TIME 71 9610
TEST_TIME 72 9608
TEST_TIME 73 9718
TEST_TIME 74 9697
TEST_TIME 75 9742
TEST_TIME 76 9726
TEST_TIME 77 9729
TEST_TIME 78 9727
TEST_TIME 79 9635
TEST_TIME 80 9636
TEST_TIME 81 9576
TEST_TIME 82 9577
TEST_TIME 83 9565
TEST_TIME 84 9507
TEST_TIME 85 9458
TEST_TIME 86 9410
TEST_TIME 87 9364
TEST_TIME 88 9365
TEST_TIME 89 9386
TEST_TIME 90 9500
TEST_TIME 91 9516
TEST_TIME 92 9529
TEST_TIME 93 9521
TEST_TIME 94 9534
TEST_TIME 95 9540
TEST_TIME 96 9517
TEST_TIME 97 9546
TEST_TIME 98 9533
TEST_TIME 99 9540
TEST_TIME 100 9582
TEST_TIME 101 9580
TEST_TIME 102 9572
TEST_TIME 103 9611
TEST_TIME 104 9533
TEST_TIME 105 9508
TEST_TIME 106 9500
TEST_TIME 107 9470
TEST_TIME 108 9463
TEST_TIME 109 9460
TEST_TIME 110 9443
TEST_TIME 111 9409
TEST_TIME 112 9405
TEST_TIME 113 9365
TEST_TIME 114 9386
TEST_TIME 115 9419
TEST_TIME 116 9402
TEST_TIME 117 9382
TEST_TIME 118 9448
TEST_TIME 119 9415
TEST_TIME 120 9349

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 23-01-2021 19:28:10 to 23-01-2021 19:28:14.

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 1570753 1570753 0 0.00 0 22747 6 0 0
doc_list_biud 1570752 1570752 0 0.00 0 38199 26 0 0
sp_add_invoice_to_stock 5415 5277 138 2.54 29 167912 17574 0 138
sp_cancel_adding_invoice 5537 5537 0 0.00 5 76749 803 0 0
sp_cancel_client_order 1903 1903 0 0.00 4 15881 328 0 0
sp_cancel_customer_reserve 546923 546923 0 0.00 1 21717 61 0 0
sp_cancel_pay_from_customer 700 700 0 0.00 3 8011 78 0 0
sp_cancel_pay_to_supplier 427 427 0 0.00 3 1437 68 0 0
sp_cancel_supplier_invoice 6202 6193 9 0.14 2 24986 742 0 9
sp_cancel_supplier_order 435 435 0 0.00 7 1161129 96047 0 0
sp_cancel_write_off 8807 8807 0 0.00 1 15484 130 0 0
sp_client_order 21488 21488 0 0.00 3 22166 352 0 0
sp_customer_reserve 486144 486144 0 0.00 0 117449 175 0 0
sp_fill_shopping_cart 33060 33060 0 0.00 1 17411 34 0 0
sp_fill_shopping_cart_clo_res 486139 486139 0 0.00 0 12669 14 0 0
sp_get_clo_for_invoice 5267 5267 0 0.00 0 39400 315 0 0
sp_kill_cost_storno 15471 15471 0 0.00 0 8082 58 0 0
sp_kill_qstorno_ret_qs2qd 1109281 1109281 0 0.00 0 24974 33 0 0
sp_kill_qty_storno 585618 585618 0 0.00 0 38198 70 0 0
sp_lock_selected_doc 21946 21946 0 0.00 0 10253 7 0 0
sp_make_cost_storno 29292 29292 0 0.00 0 18411 55 0 0
sp_multiply_rows_for_pdistr 29292 29292 0 0.00 0 22741 28 0 0
sp_multiply_rows_for_qdistr 21488 21488 0 0.00 0 13890 158 0 0
sp_pay_from_customer 7290 7290 0 0.00 3 17458 117 0 0
sp_pay_to_supplier 6182 6182 0 0.00 4 22750 129 0 0
sp_payment_common 13472 13472 0 0.00 1 14367 31 0 0
sp_qd_handle_on_cancel_clo 1903 1903 0 0.00 0 15873 307 0 0
sp_qd_handle_on_invoice_upd_sts 10804 10804 0 0.00 0 38195 315 0 0
sp_qd_handle_on_reserve_upd_sts 10553 10553 0 0.00 0 16882 50 0 0
sp_reserve_write_off 10553 10553 0 0.00 6 17683 170 0 0
sp_supplier_invoice 5792 5792 0 0.00 6 93562 3098 0 0
sp_supplier_order 5783 5783 0 0.00 5 68086 1249 0 0
srv_aggregate_perf_data 111 111 0 0.00 2576 153337 16188 0 0
srv_fill_mon_cache_memory 153 153 0 0.00 1146 180884 33429 0 0
srv_find_qd_qs_mism 1070889 1070889 0 0.00 0 20302 6 0 0
srv_make_invnt_saldo 578 578 0 0.00 44 109387 1211 0 0
srv_make_money_saldo 770 770 0 0.00 1 9341 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 175719 477990 309653 0 0
t$perf-abend:sp_add_invoice_to_stock 138 138 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5277 5277 0 0.00 0 18894 159 0 0
t$perf-norm:sp_cancel_adding_invoice 419 419 0 0.00 0 1563 61 0 0
t$perf-norm:sp_cancel_client_order 1903 1903 0 0.00 0 7589 21 0 0
t$perf-norm:sp_cancel_customer_reserve 737 737 0 0.00 0 3449 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 700 700 0 0.00 0 7342 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 427 427 0 0.00 0 1008 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 434 434 0 0.00 0 558 14 0 0
t$perf-norm:sp_cancel_supplier_order 435 435 0 0.00 0 25982 1562 0 0
t$perf-norm:sp_cancel_write_off 1071 1071 0 0.00 0 1614 5 0 0
t$perf-norm:sp_client_order 21488 21488 0 0.00 0 9776 16 0 0
t$perf-norm:sp_customer_reserve 1053 1053 0 0.00 0 2805 12 0 0
t$perf-norm:sp_pay_from_customer 7290 7290 0 0.00 0 6825 14 0 0
t$perf-norm:sp_pay_to_supplier 6182 6182 0 0.00 0 5787 11 0 0
t$perf-norm:sp_reserve_write_off 10553 10553 0 0.00 0 6674 11 0 0
t$perf-norm:sp_supplier_invoice 5792 5792 0 0.00 0 14783 22 0 0
t$perf-norm:sp_supplier_order 5783 5783 0 0.00 0 6075 17 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 2551 27 0 0
t$perf-norm:srv_fill_mon_cache_memory 153 153 0 0.00 0 396 6 0 0
t$perf-norm:srv_make_invnt_saldo 578 578 0 0.00 0 915 21 0 0
t$perf-norm:srv_make_money_saldo 770 770 0 0.00 0 2258 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10810 10534 276 2.55 0 6986 17 0 276
v_all_customers 38818 38818 0 0.00 0 141 1 0 0
v_all_suppliers 31996 31996 0 0.00 0 76 1 0 0
v_all_wares 42976 42976 0 0.00 0 66 1 0 0
v_cancel_adding_invoice 838 838 0 0.00 0 1659 13 0 0
v_cancel_client_order 3806 3806 0 0.00 0 1629 4 0 0
v_cancel_customer_prepayment 1400 1400 0 0.00 0 4002 10 0 0
v_cancel_customer_reserve 1474 1474 0 0.00 0 1323 5 0 0
v_cancel_payment_to_supplier 854 854 0 0.00 0 1429 7 0 0
v_cancel_supplier_invoice 886 868 18 2.03 0 886 15 0 18
v_cancel_supplier_order 870 870 0 0.00 0 9317 18 0 0
v_cancel_write_off 2142 2142 0 0.00 0 2337 15 0 0
v_max_id_clo_ord 5783 5783 0 0.00 0 869 1 0 0
v_max_id_clo_res 1053 1053 0 0.00 0 4746 19 0 0
v_max_id_ord_sup 5789 5789 0 0.00 0 3351 5 0 0
v_max_non_paid_invoice 1756 1756 0 0.00 0 1336 3 0 0
v_max_non_paid_realizn 3976 3976 0 0.00 0 1426 3 0 0
v_min_id_clo_ord 5783 5783 0 0.00 0 2849 5 0 0
v_min_id_clo_res 1053 1053 0 0.00 0 5937 25 0 0
v_min_id_ord_sup 5789 5789 0 0.00 0 3895 4 0 0
v_min_non_paid_invoice 6182 6182 0 0.00 0 12015 21 0 0
v_min_non_paid_realizn 7290 7290 0 0.00 0 13801 17 0 0
v_our_firm 10786 10786 0 0.00 0 49 1 0 0
v_reserve_write_off 21106 21106 0 0.00 0 3238 7 0 0
x_lock_depdocs_on_canc_invoice 11296 11296 0 0.00 0 29168 132 0 0
x_lock_depdocs_on_canc_sup_ord 435 435 0 0.00 0 12800 368 0 0
x_make_qstorno_1000_1200 5783 5783 0 0.00 1 68072 1172 0 0
x_make_qstorno_1200_2000 5792 5792 0 0.00 3 93534 2982 0 0
x_make_qstorno_2100_3300 486144 486144 0 0.00 0 117448 159 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-01-2021 19:28:15 to 23-01-2021 19:28:19.

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:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:22 15913 8192000000 10261679440 10575384576 914968480 10.046 70 56 112 0 935558848 2588656 18001712
16:57:50 17283 8192000000 10347842048 10665979904 1398841328 14.585 100 85 170 0 1430210272 4686016 26682928
16:58:16 27785 8192000000 10394810656 10717712384 1441962304 14.967 100 92 184 0 1478106512 6612976 29531232
16:58:56 27713 8192000000 10424249088 10751823872 1474245616 15.251 100 88 176 0 1510370576 7802320 28322640
16:59:33 17669 8192000000 10433848960 10764824576 1488352304 15.374 100 92 184 0 1526484176 8310480 29821392
17:00:03 17635 8192000000 10449328288 10784514048 1496681120 15.447 100 80 160 0 1531442448 8622640 26138688
17:00:32 16103 8192000000 10473848208 10813145088 1528225024 15.722 100 87 174 0 1564978336 9244976 27508336
17:00:57 14526 8192000000 10490434080 10834190336 1553415344 15.939 100 89 178 2 1591094592 9713936 27965312
17:01:27 19882 8192000000 10520777104 10867793920 1575417936 16.129 100 81 162 0 1610791008 10124720 25248352
17:01:56 18819 8192000000 10531341024 10883104768 1588438560 16.240 100 83 166 0 1625137600 10814560 25884480
17:02:25 10708 8192000000 10557189104 10912305152 1608263952 16.410 100 81 160 2 1642836016 10671776 23900288
17:02:45 15626 8192000000 10571394928 10928926720 1630335536 16.598 100 84 165 0 1666713600 11610080 24767984
17:03:12 7996 8192000000 10588618208 10946473984 1644242800 16.716 100 87 174 0 1682623952 12512000 25869152
17:03:34 13446 8192000000 10591296032 10958991360 1653531408 16.794 100 75 148 2 1688290688 13127552 21631728
17:03:57 8378 8192000000 10622000528 10990080000 1677652096 16.998 100 80 160 1 1713306000 12912992 22740912
17:04:14 7430 8192000000 10637401568 11004309504 1692245760 17.120 100 85 170 2 1730424304 13824704 24353840
17:04:28 7914 8192000000 10651318080 11022528512 1708466176 17.256 100 81 162 1 1745245600 13176368 23603056
17:04:44 9006 8192000000 10662647792 11039129600 1722003088 17.369 100 75 150 1 1755513456 12149584 21360784
17:05:02 4260 8192000000 10679681056 11056525312 1742364704 17.538 100 83 162 2 1776819920 11244128 23211088
17:05:16 3524 8192000000 10698568576 11076931584 1762579760 17.706 100 83 167 1 1798311696 11625168 24106768
17:05:27 3224 8192000000 10715101808 11096641536 1778107216 17.834 100 84 164 0 1812725216 11271104 23346896
17:05:37 3269 8192000000 10727507680 11106848768 1789788080 17.930 100 82 164 0 1824889200 11674256 23426864
17:05:48 3705 8192000000 10730786000 11114745856 1793373008 17.960 100 71 142 0 1824799184 11993408 19432768
17:05:58 4613 8192000000 10735347184 11119939584 1797707776 17.995 100 76 151 1 1831994768 12943712 21343280
17:06:10 3165 8192000000 10745567296 11132731392 1808710592 18.085 100 83 166 1 1845061696 12468016 23883088
17:06:20 3145 8192000000 10757241456 11141574656 1812076080 18.113 100 86 173 0 1848980576 12575168 24329328
17:06:31 5338 8192000000 10748944144 11138719744 1819107088 18.170 100 76 152 0 1852169792 11989744 21072960
17:06:43 3939 8192000000 10773340640 11155103744 1819362016 18.172 100 80 158 0 1854816400 13811584 21642800
17:06:53 2178 8192000000 10781909872 11168194560 1838947360 18.332 100 86 173 0 1876515424 13781344 23786720
17:07:02 1928 8192000000 10783502496 11172700160 1845921408 18.389 100 90 179 0 1885029696 13756448 25351840
17:07:10 1834 8192000000 10790990944 11182231552 1848908864 18.413 100 86 171 0 1886913584 12847568 25157152
17:07:18 1946 8192000000 10809590800 11194351616 1859664144 18.501 100 93 186 2 1901153584 15525872 25963568
17:07:26 1370 8192000000 10803274272 11192893440 1864007168 18.536 100 93 187 2 1903312448 13349168 25956112
17:07:34 1640 8192000000 10808912112 11201286144 1868988816 18.576 100 92 185 2 1906984112 12050176 25945120
17:07:42 2184 8192000000 10815719696 11203518464 1872644528 18.606 100 97 195 1 1912577792 12347888 27585376
17:07:50 1724 8192000000 10819314224 11210698752 1875166704 18.626 100 91 183 2 1913979440 12583536 26229200
17:07:58 8719 8192000000 10802843888 11202150400 1875187328 18.626 100 79 154 1 1909018784 12113552 21717904
17:08:16 1342 8192000000 10824166368 11214409728 1878797136 18.655 100 89 179 0 1917234528 11674448 26762944
17:08:24 4926 8192000000 10803516752 11214766080 1878377072 18.652 100 59 118 0 1905467088 10211632 16878384
17:08:36 5081 8192000000 10783849680 11203158016 1873277472 18.611 100 43 84 2 1893951872 9305680 11368720
17:08:48 5151 8192000000 10794098768 11214585856 1882356048 18.684 100 48 96 2 1905298208 9554048 13388112
17:09:00 2845 8192000000 10790141968 11218407424 1881309584 18.676 100 35 70 1 1900410288 9199792 9900912
17:09:10 5152 8192000000 10804873264 11220414464 1882817280 18.688 100 34 68 1 1900959104 8968944 9172880
17:09:23 8976 8192000000 10802831984 11227537408 1884430816 18.701 100 35 69 1 1901988016 8165600 9391600
17:09:42 37172 8192000000 10798927248 11230511104 1888515312 18.734 100 41 83 0 1908452016 8138384 11798320
17:10:34 20534 8192000000 10840726752 11240689664 1897831328 18.809 100 68 136 2 1923290224 6263504 19195392
17:11:01 10064 8192000000 10797675472 11239636992 1894570832 18.783 100 29 58 0 1910917488 8244752 8101904
17:11:19 6833 8192000000 10809219840 11240382464 1891830912 18.761 100 26 52 2 1905288976 6753104 6704960
17:11:32 5128 8192000000 10817618736 11248693248 1895096832 18.787 100 29 58 0 1913885760 10934960 7853968
17:11:46 2674 8192000000 10822727232 11251433472 1899453888 18.822 100 29 58 3 1919056448 11659696 7942864
17:11:59 3525 8192000000 10827577440 11254956032 1904871952 18.865 100 34 68 0 1925444976 10974144 9598880
17:12:10 2470 8192000000 10827067840 11252723712 1906542272 18.879 100 37 74 2 1925401088 8064352 10794464
17:12:18 6434 8192000000 10816519184 11250851840 1907628640 18.888 100 34 67 0 1923678048 6329152 9720256
17:12:33 9376 8192000000 10826967264 11255476224 1905956064 18.874 100 29 57 1 1920690112 6463744 8270304
17:12:49 4633 8192000000 10823383344 11255545856 1905649664 18.872 100 27 54 0 1920739872 7354320 7735888
17:13:02 4647 8192000000 10823719328 11260055552 1906366416 18.877 100 24 49 0 1919220528 6096512 6757600
17:13:13 7724 8192000000 10829517440 11256881152 1909311600 18.901 100 32 64 3 1925250736 6070928 9868208
17:13:28 6779 8192000000 10826475376 11261341696 1910767888 18.913 100 26 52 1 1924313776 6166560 7379328
17:13:45 5845 8192000000 10829695376 11261980672 1912902704 18.930 100 29 58 1 1928062864 7444048 7716112
17:13:58 9923 8192000000 10811880576 11250614272 1877950128 18.649 98 34 68 2 1894139008 6420560 9768320
17:14:16 5138 8192000000 10816587344 11252264960 1901601488 18.839 100 32 62 2 1920247920 9913920 8732512
17:14:30 6856 8192000000 10818437872 11252502528 1903660912 18.856 100 18 36 1 1914825584 6030272 5134400
17:14:46 66313 8192000000 10813623456 11257188352 1910010192 18.907 100 29 58 0 1924125712 5367680 8747840
17:15:58 7658 8192000000 10823717408 11256410112 1905140672 18.868 100 25 49 1 1918558912 6060192 7358048
17:16:12 4249 8192000000 10817494832 11246358528 1887612928 18.727 99 43 84 3 1907173456 7568000 11992528
17:16:25 6815 8192000000 10818408096 11251224576 1901324144 18.837 100 30 60 2 1915511008 6046560 8140304
17:16:39 6874 8192000000 10812663776 11243950080 1901465952 18.838 100 35 70 2 1918393712 6922064 10005696
17:16:54 6825 8192000000 10806614864 11235684352 1860792192 18.510 98 23 45 2 1873001632 5836304 6373136
17:17:08 5652 8192000000 10793308560 11226542080 1866503600 18.556 99 33 66 3 1886821136 10794224 9523312
17:17:21 8291 8192000000 10770254144 11187621888 1818239584 18.163 98 28 54 2 1832153328 5773216 8140528
17:17:36 8769 8192000000 10767180464 11184271360 1806506224 18.067 97 27 54 0 1821332128 6299904 8526000
17:17:53 10677 8192000000 10748218240 11179597824 1779485920 17.845 96 19 40 2 1791063296 6211760 5365616
17:18:11 11002 8192000000 10734764192 11148533760 1771747872 17.781 96 28 56 0 1785114192 4929376 8436944
17:18:28 10729 8192000000 10732256896 11138785280 1728876064 17.426 95 31 62 0 1743917184 5432448 9608672
17:18:46 10970 8192000000 10702176064 11119366144 1726599488 17.407 96 19 37 3 1737693984 5582064 5512432
17:19:04 4685 8192000000 10710631600 11123519488 1769198512 17.760 98 31 62 2 1784524176 6561280 8764384
17:19:18 51769 8192000000 10695985280 11109310464 1652314736 16.784 91 25 48 2 1665683152 5331344 8037072
17:20:22 19253 8192000000 10680627056 11098456064 1722579232 17.374 96 30 60 1 1737904304 7138576 8186496
17:20:50 8364 8192000000 10673615456 11075870720 1670302240 16.936 94 24 48 1 1681949488 4455728 7191520
17:21:13 8475 8192000000 10667581968 11085107200 1746518864 17.573 98 29 58 0 1762219600 7570672 8130064
17:21:29 3601 8192000000 10709886880 11119357952 1772412624 17.787 99 32 64 1 1788899168 6490688 9995856
17:21:41 7413 8192000000 10726024368 11142205440 1813369520 18.123 100 37 73 4 1831081344 6816864 10894960
17:21:58 8592 8192000000 10726794656 11145310208 1802279488 18.033 99 22 44 0 1814584848 5255792 7049568
17:22:14 5250 8192000000 10731865264 11147018240 1800608544 18.019 99 39 78 1 1822265696 10585728 11071424
17:22:26 5408 8192000000 10738697536 11151196160 1803066544 18.039 99 34 68 2 1818617584 5733072 9817968
17:22:38 6788 8192000000 10743348272 11164430336 1832143616 18.277 100 30 60 0 1847649968 6210096 9296256
17:22:53 13277 8192000000 10760684192 11184689152 1843787648 18.372 100 36 72 2 1860325648 5730656 10807344
17:23:13 4882 8192000000 10770541280 11193647104 1851874384 18.437 100 21 42 3 1863568240 5934032 5759824
17:23:27 6552 8192000000 10783541424 11201761280 1861405680 18.515 100 32 63 0 1877235392 6791584 9038128
17:23:45 8427 8192000000 10786097664 11202617344 1860440096 18.507 100 15 31 1 1869957696 5007616 4509984
17:24:00 7715 8192000000 10777282720 11209764864 1864709280 18.541 100 26 52 0 1883601760 11515056 7377424
17:24:14 8354 8192000000 10777179392 11208966144 1870153488 18.586 100 21 42 0 1883147040 5803936 7189616
17:24:31 75723 8192000000 10786499232 11219083264 1878297952 18.651 100 35 70 0 1894447264 5028528 11120784
17:25:54 6949 8192000000 10794084512 11226472448 1879184432 18.659 100 29 58 0 1893913296 6880784 7848080
17:26:11 8222 8192000000 10805909184 11234504704 1879546432 18.661 100 21 43 0 1891566336 5893792 6126112
17:26:29 5430 8192000000 10810029216 11236851712 1890741872 18.752 100 44 88 5 1911017952 8264416 12011664
17:26:42 5821 8192000000 10817039408 11238809600 1886326464 18.716 100 21 41 0 1898532592 6566448 5639680
17:26:54 6799 8192000000 10816529632 11238535168 1890694752 18.751 100 31 62 4 1904977232 5638640 8643840
17:27:08 31792 8192000000 10828120128 11256049664 1908659824 18.896 100 36 71 6 1924573504 5970176 9943504
17:27:48 20315 8192000000 10861523776 11279855616 1927028176 19.043 100 44 87 1 1945934912 6023600 12883136
17:28:21 25884 8192000000 10870561856 11294490624 1934826688 19.105 100 48 96 0 1957331760 9039120 13465952
17:28:55 20218 8192000000 10886607200 11310583808 1944781904 19.185 100 50 100 1 1970596832 11757296 14057632
17:29:24 11889 8192000000 10895619680 11316174848 1956678704 19.280 100 62 125 2 1988222624 13435936 18107984
17:29:44 8382 8192000000 10885298816 11309297664 1939062384 19.139 99 57 114 0 1967973152 13300000 15610768
17:30:01 14313 8192000000 10894709488 11323478016 1957721056 19.288 100 54 106 1 1986353504 13509264 15123184
17:30:30 36557 8192000000 10910234672 11341410304 1967069568 19.362 100 47 94 0 1998014928 16209856 14735504
17:31:19 23327 8192000000 10913081040 11334299648 1960268496 19.308 99 50 100 0 1993154848 17825440 15060912
17:31:53 79671 8192000000 10921662192 11357298688 1981356144 19.475 100 47 93 1 2013577824 18070976 14150704
17:33:23 18140 8192000000 10929756064 11362783232 1988783408 19.534 100 55 109 1 2025356832 20108224 16465200
17:33:48 16342 8192000000 10931862992 11369807872 1990376112 19.547 100 46 92 1 2024914896 21094944 13443840
17:34:16 7304 8192000000 10946350448 11375538176 1996619392 19.596 100 52 103 1 2032774000 21501456 14653152
17:34:30 25528 8192000000 10929411904 11366178816 1973635936 19.414 99 46 91 1 2009118288 22081728 13400624
17:35:29 6984 8192000000 10945696880 11379425280 1990941440 19.551 100 45 89 2 2034028064 29031552 14055072
17:35:44 9214 8192000000 10965948784 11390156800 1999330144 19.617 100 60 119 1 2048493744 30525824 18637776
17:36:02 2685 8192000000 10960702336 11384324096 2003302912 19.649 100 70 138 2 2051601776 27441328 20857536
17:36:13 9621 8192000000 10965568400 11389943808 2004760736 19.660 100 65 128 1 2055115952 30818480 19536736
17:36:34 3678 8192000000 10966856992 11398774784 2009406672 19.697 100 61 120 1 2057677776 29711424 18559680
17:36:47 8049 8192000000 10965863152 11401420800 2013227152 19.727 100 64 128 2 2059999680 27140928 19631600
17:37:07 6101 8192000000 10961619696 11403182080 2013613136 19.730 100 57 114 2 2056540928 25627760 17300032
17:37:23 2246 8192000000 10973307280 11403571200 2018990320 19.772 100 72 135 0 2061608256 22154032 20463904
17:37:32 4041 8192000000 10980716112 11398533120 2015753632 19.747 100 70 136 0 2060854224 24043952 21056640
17:37:47 2873 8192000000 10980265248 11391197184 2011410272 19.713 100 83 162 0 2060706432 25708288 23587872
17:38:05 4216 8192000000 10969578880 11399692288 2013546560 19.729 100 71 141 0 2062880624 27257424 22076640
17:38:23 3253 8192000000 10972084688 11393200128 2007182640 19.679 100 79 155 2 2059199360 28323680 23693040
17:38:35 2842 8192000000 10986355680 11404926976 2013173664 19.726 100 85 169 0 2069781184 30566288 26041232
17:38:45 10079 8192000000 10961036960 11390971904 1986361840 19.515 99 83 166 0 2043689280 31587568 25739872
17:39:12 5781 8192000000 10968679008 11392831488 1996961168 19.599 100 66 132 2 2047646224 30405520 20279536
17:39:26 4523 8192000000 10967044592 11393781760 2003779504 19.653 100 68 135 1 2052469440 28376608 20313328
17:39:40 7016 8192000000 10971081248 11398676480 2007610736 19.683 100 61 121 0 2053249056 27199552 18438768
17:40:02 4658 8192000000 10972428816 11409637376 2013907664 19.732 100 62 123 0 2064405040 32170880 18326496
17:40:19 14193 8192000000 10955203056 11401084928 1991184704 19.553 99 43 86 0 2035502224 30727232 13590288
17:40:40 2937 8192000000 10971244960 11404455936 2014666496 19.738 100 61 122 1 2057321504 23489152 19165856
17:40:52 6344 8192000000 10958642704 11386486784 1992918656 19.567 99 65 130 0 2039550288 26841392 19790240
17:41:11 7757 8192000000 10972498880 11406254080 2010694480 19.707 100 61 122 2 2056855296 27354912 18805904
17:41:30 5254 8192000000 10964921232 11387224064 1994909744 19.583 99 63 125 2 2044224128 30367920 18946464
17:41:45 6011 8192000000 10966477104 11383345152 1989396400 19.539 99 71 140 3 2043032864 32277472 21358992
17:41:58 4042 8192000000 10990555984 11410444288 2009683840 19.699 100 74 144 0 2065448912 33131072 22634000
17:42:09 7570 8192000000 10990468736 11420340224 2017693536 19.762 100 67 134 0 2072452752 33795728 20963488
17:42:27 4055 8192000000 10975142784 11393380352 1970882528 19.392 98 69 138 1 2028195296 34977312 22335456
17:42:38 1144 8192000000 10978340928 11394629632 1996265888 19.593 100 76 152 0 2056452160 35714096 24472176
17:42:50 10462 8192000000 10978852816 11407798272 2001763392 19.637 100 70 140 0 2061744496 37517744 22463360
17:43:13 7824 8192000000 10983509136 11417849856 2006077536 19.671 100 57 114 1 2066528752 41748912 18702304
17:43:32 2371 8192000000 11009432544 11426844672 2016764640 19.755 100 73 144 0 2083780944 44155712 22860592
17:43:48 4000 8192000000 10989794528 11406192640 1992265008 19.562 99 83 165 2 2063533696 44783008 26485680
17:43:59 1953 8192000000 10981672096 11403612160 1992381248 19.563 99 79 155 2 2062923808 45888352 24654208
17:44:08 1869 8192000000 10997243792 11414413312 2011268576 19.712 100 77 153 1 2074334784 39000832 24065376
17:44:17 2721 8192000000 10979641136 11397804032 1978038992 19.449 98 71 141 0 2038933824 38840640 22054192
17:44:28 1661 8192000000 10982771376 11393437696 1985715776 19.510 99 87 175 2 2052741712 39637456 27388480
17:44:35 4121 8192000000 10993166272 11403616256 1997502384 19.603 100 89 179 0 2065830848 40471504 27856960
17:44:47 1815 8192000000 10961723680 11375464448 1972625824 19.406 100 81 159 0 2038949920 41046896 25277200
17:44:57 2392 8192000000 10985615344 11397058560 1990748800 19.550 100 89 176 1 2062330192 43244400 28336992
17:45:08 3337 8192000000 10985275920 11397533696 1989658400 19.541 100 80 160 0 2061725456 46042992 26024064
17:45:19 1386 8192000000 10991108816 11400818688 1997502016 19.603 100 91 182 0 2074409648 47553376 29354256
17:45:29 1809 8192000000 10979923600 11398201344 1985741744 19.510 100 77 154 1 2059834096 48566944 25525408
17:45:39 3129 8192000000 10948730400 11367202816 1948116944 19.211 98 70 138 2 2020433088 49256864 23059280
17:45:51 9066 8192000000 10939814192 11363856384 1955673776 19.272 99 60 120 1 2021885600 46229296 19982528
17:46:09 15511 8192000000 10949586896 11380977664 1972114096 19.402 100 49 98 1 2030637728 41719392 16804240
17:46:31 10192 8192000000 10954474640 11386671104 1979905264 19.464 100 46 92 1 2036950240 41662144 15382832
17:46:52 11148 8192000000 10959558752 11389849600 1965626064 19.351 99 55 109 1 2025579744 41955632 17998048
17:47:12 4741 8192000000 10956187536 11375239168 1964661568 19.343 100 68 135 1 2034166224 47127808 22376848
17:47:29 3232 8192000000 10953146416 11375464448 1952808368 19.249 99 74 145 3 2022943888 46735712 23399808
17:47:42 4600 8192000000 10966718416 11391938560 1981267216 19.475 100 82 164 0 2055738960 47639440 26832304
17:47:58 14345 8192000000 10941645840 11381764096 1959278752 19.300 99 43 86 0 2015774032 42174720 14320560
17:48:50 16725 8192000000 10920202576 11373379584 1950543424 19.231 99 31 62 3 1997479280 36714160 10221696
17:49:13 11055 8192000000 10912190832 11356139520 1931094704 19.076 98 40 81 1 1977350528 33485264 12770560
17:49:44 24141 8192000000 10905972544 11355213824 1932772096 19.089 99 21 42 0 1975072384 35237648 7062640
17:50:23 16555 8192000000 10913639696 11357925376 1922122160 19.004 98 31 63 2 1971364592 38646064 10596368
17:50:46 16882 8192000000 10910614736 11351117824 1930526928 19.071 99 37 74 0 1986398768 42698960 13172880
17:51:17 8111 8192000000 10911658928 11363078144 1941107648 19.156 100 28 56 4 1996734560 45694864 9932048
17:51:36 7513 8192000000 10913964704 11367051264 1946538768 19.199 100 30 60 0 1999832576 43376304 9917504
17:52:07 28098 8192000000 10895476544 11356352512 1931280544 19.077 99 19 38 0 1973876000 35598992 6996464
17:53:24 48199 8192000000 10878889376 11339841536 1891117104 18.755 98 18 36 1 1945763408 48547616 6098688
17:54:18 26484 8192000000 10879404320 11362934784 1929253904 19.061 100 14 28 0 1974815568 40979920 4581744
17:54:51 63279 8192000000 10877618032 11345645568 1920393024 18.990 99 9 18 0 1936671344 13609040 2669280
17:56:05 43103 8192000000 10893822528 11339644928 1939515312 19.143 100 16 33 0 1960134960 16294832 4324816
17:57:01 64167 8192000000 10869466192 11326066688 1907686768 18.888 98 21 42 1 1924351568 10470336 6194464
17:58:13 106266 8192000000 10868679600 11325599744 1856360736 18.474 95 15 30 1 1867326976 7289392 3676848
18:00:13 95582 8192000000 10890220656 11334995968 1917075520 18.963 98 27 54 2 1931146784 6950080 7121184
18:02:07 54309 8192000000 10887452768 11336892416 1913179296 18.932 98 37 74 2 1931741552 7946688 10615568
18:03:15 95378 8192000000 10899590112 11337609216 1899902400 18.826 97 34 68 1 1917900688 8564176 9434112
18:04:58 48051 8192000000 10875946704 11333128192 1946821648 19.201 99 30 60 0 1967555392 11212208 9521536
18:06:02 34216 8192000000 10898683392 11334426624 1929332352 19.062 98 24 48 2 1946752912 10454304 6966256
18:06:43 25734 8192000000 10911042992 11348451328 1954341232 19.261 99 60 117 1 1984059312 12649792 17068288
18:07:34 27083 8192000000 10897860848 11349594112 1948221872 19.212 99 43 86 1 1974282736 14082976 11977888
18:09:10 137930 8192000000 10893869248 11355906048 1911646624 18.920 97 9 18 1 1930729312 16226304 2856384
18:11:35 54250 8192000000 10893406720 11371204608 1966862000 19.361 100 8 16 0 1988827648 19184192 2781456
18:12:36 99967 8192000000 10919817840 11383144448 1981259472 19.475 100 18 36 1 1999587680 13912960 4415248
18:14:26 28509 8192000000 10950452688 11394154496 1994581808 19.580 100 43 86 1 2020762832 14085904 12095120
18:15:09 37249 8192000000 10920189776 11392946176 1988718192 19.534 100 22 44 1 2011107216 15875744 6513280
18:15:53 59280 8192000000 10917860304 11383754752 1968883632 19.377 99 15 30 1 1986653184 13986496 3783056
18:17:01 35966 8192000000 10894062864 11367747584 1923874464 19.018 97 12 24 2 1937909424 10217152 3817808
18:17:43 46772 8192000000 10913409568 11375960064 1962809616 19.328 99 14 28 0 1975206080 8322064 4074400
18:18:38 54863 8192000000 10924989040 11396067328 1992616240 19.564 100 21 41 6 2012157936 12542672 6999024
18:19:39 80215 8192000000 10930400528 11408097280 1975292672 19.427 99 15 30 0 1993339520 13874176 4172672
18:22:05 19731 8192000000 10899394128 11351433216 1926495552 19.039 97 24 48 1 1940777056 7593376 6688128
18:22:32 22523 8192000000 10914468016 11366588416 1959547744 19.302 99 32 64 1 1977915392 9639264 8728384
18:23:04 20591 8192000000 10919736464 11378167808 1961840432 19.321 99 26 52 3 1986528080 17941616 6746032
18:23:31 74717 8192000000 10886472528 11349712896 1906032240 18.875 96 28 56 0 1926693376 12968576 7692560
18:25:18 55243 8192000000 10894742304 11358449664 1947389408 19.206 99 28 55 2 1975464464 20243280 7831776
18:28:13 54562 8192000000 10910751568 11370274816 1971438176 19.397 100 48 96 1 2003776960 18649936 13688848
18:29:41 70537 8192000000 10875915104 11368833024 1944975296 19.186 99 5 10 0 1960266864 14180992 1110576
18:30:58 1897 8192000000 10877790832 11371692032 1957943328 19.290 100 7 14 0 1974132576 14224752 1964496
18:31:52 42582 8192000000 10846287712 11319382016 1867798048 18.566 96 15 30 1 1878179808 5774304 4607456
18:32:48 27364 8192000000 10856809344 11316355072 1887037616 18.722 97 30 60 2 1902019600 7067808 7914176
18:33:24 53679 8192000000 10828403296 11286810624 1815544688 18.141 94 22 43 1 1832820496 11110128 6165680
18:34:45 36059 8192000000 10839783552 11296063488 1869512864 18.580 97 34 68 0 1891400912 12077952 9810096
18:35:33 20622 8192000000 10828727744 11273531392 1887616928 18.727 98 35 70 3 1904958736 7604704 9737104
18:36:02 30054 8192000000 10851680496 11292622848 1850927088 18.430 96 41 82 1 1872384064 10041856 11415120
18:36:43 70010 8192000000 10831232144 11299082240 1858168096 18.488 97 25 50 0 1876677376 11766880 6742400
18:38:24 85157 8192000000 10877256816 11335827456 1890594032 18.751 98 28 56 1 1911236992 13350256 7292704
18:39:58 180884 8192000000 10843182608 11304280064 1816225056 18.147 94 8 16 0 1837167104 18594320 2347728
18:43:05 19426 8192000000 10864898368 11313311744 1926313840 19.037 100 48 97 0 1947957216 7578816 14064560
18:43:38 64589 8192000000 10866810944 11320979456 1863495072 18.532 96 18 36 1 1877353792 9475824 4382896
18:44:50 14525 8192000000 10877259648 11325001728 1917034832 18.963 99 48 97 2 1942272080 11364720 13872528
18:45:15 25074 8192000000 10872675952 11328557056 1918951248 18.978 99 35 71 1 1941614848 12710864 9952736
18:45:46 121826 8192000000 10854280256 11321876480 1899793600 18.825 98 25 50 2 1921403440 14582624 7027216
18:47:55 70432 8192000000 10853160688 11310112768 1883851296 18.696 97 40 80 2 1905818384 10418800 11548288
18:49:12 36315 8192000000 10843877488 11303174144 1890498496 18.750 98 15 30 0 1903292688 8334416 4459776
18:51:17 72309 8192000000 10856076944 11326914560 1901892512 18.842 98 17 34 0 1915675712 9371776 4411424
18:52:35 64152 8192000000 10878478720 11346669568 1930911824 19.074 99 22 44 1 1955590752 17811584 6867344
18:53:52 86428 8192000000 10880908464 11356082176 1930728768 19.073 99 20 41 0 1961470816 24997696 5744352
18:55:30 55483 8192000000 10883080544 11366543360 1948581600 19.215 100 16 32 1 1978690912 24959312 5150000
18:56:42 47846 8192000000 10890374032 11363692544 1960617488 19.311 100 23 46 3 1981499456 14464960 6417008
18:57:36 66775 8192000000 10904852144 11364450304 1955517872 19.270 99 20 40 0 1972321440 10503680 6299888
18:58:49 88463 8192000000 10907991104 11382362112 1961675280 19.319 99 15 30 0 1978835040 13620720 3539040
19:00:24 82454 8192000000 10920496032 11387518976 1972760432 19.407 99 22 44 2 1990501136 11054176 6686528
19:01:58 48691 8192000000 10916002096 11381370880 1966531136 19.358 99 13 25 1 1977611424 8082176 2998112
19:03:07 22665 8192000000 10931483744 11378622464 1954891776 19.265 98 40 78 3 1973422080 8100160 10430144
19:03:40 47970 8192000000 10932010144 11393585152 1994024592 19.576 100 28 57 0 2015181472 13111904 8044976
19:04:37 60250 8192000000 10911732000 11375472640 1917072816 18.963 96 19 35 0 1932555008 10754528 4727664
19:05:45 34059 8192000000 10909043312 11364159488 1924759168 19.025 97 20 40 0 1937892656 7774928 5358560
19:06:25 32327 8192000000 10905436976 11365003264 1920206176 18.988 97 43 86 0 1942329056 9528512 12594368
19:07:04 39825 8192000000 10921204880 11378880512 1951206000 19.236 99 27 54 1 1974433088 15449200 7777888
19:07:56 91299 8192000000 10878436144 11344949248 1871436512 18.596 95 10 19 1 1888889808 14714592 2738704
19:09:36 75836 8192000000 10916150976 11387379712 1943112784 19.172 98 21 42 0 1962420352 13552512 5755056
19:11:54 108518 8192000000 10837653536 11313004544 1806829088 18.070 91 19 38 1 1825825344 13460752 5535504
19:13:49 2959 8192000000 10862242288 11313836032 1888265248 18.732 97 41 81 1 1910972976 10983920 11723808
19:14:19 46871 8192000000 10857542976 11334057984 1918799744 18.977 99 7 14 1 1933001136 12463616 1737776
19:15:12 55195 8192000000 10854335056 11336814592 1897581024 18.807 98 6 12 0 1912612736 13309712 1722000
19:16:13 55232 8192000000 10852750400 11332677632 1925287536 19.029 99 16 32 3 1942200688 12565152 4348000
19:17:15 38938 8192000000 10842567104 11321282560 1862485280 18.523 96 11 22 0 1876329824 10992256 2852288
19:18:26 65017 8192000000 10833277168 11309252608 1888992096 18.738 98 22 44 1 1904066752 8676368 6398288
19:19:38 72228 8192000000 10875334336 11334217728 1899244048 18.820 98 13 26 2 1912722064 9204272 4273744
19:20:56 38621 8192000000 10862643888 11326631936 1902355184 18.845 98 19 38 0 1914996672 7346848 5294640
19:21:50 54002 8192000000 10823942144 11290279936 1797893488 17.997 93 17 34 1 1811456592 8473664 5089440
19:22:51 48520 8192000000 10806087184 11268784128 1795980928 17.981 94 11 22 1 1807073088 7838880 3253280
19:23:47 41108 8192000000 10819745840 11274477568 1838412352 18.328 97 26 52 0 1856240336 10075792 7752192
19:24:36 34541 8192000000 10830939888 11293360128 1871840880 18.599 98 22 44 0 1888703216 10654336 6208000
19:25:19 62884 8192000000 10838464976 11299950592 1878126704 18.650 99 14 28 0 1890593728 8284688 4182336
19:26:29 18396 8192000000 10851087744 11303182336 1894009680 18.778 99 31 62 3 1910294400 8067328 8217392
19:26:53 19789 8192000000 10720924256 11158396928 1785870928 17.898 93 40 80 0 1806454496 9517776 11065792

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 23-01-2021 19:28:21 to 23-01-2021 19:28:52.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 138 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-01-2021 19:28:53 to 23-01-2021 19:28:55.

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          246918
MON$OLDEST_ACTIVE               248549
MON$OLDEST_SNAPSHOT             248549
MON$NEXT_TRANSACTION            248549
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                       2021056
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:307: 
:308: mscs-test-161.budzdorov.ru    Sat Jan 23 19:27:18 2021
:309:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:310: 
:311: 
:312: mscs-test-161.budzdorov.ru    Sat Jan 23 19:27:19 2021
:313:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:314: 
:315: 
:316: mscs-test-161.budzdorov.ru    Sat Jan 23 19:27:23 2021
:317:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:318: 
:319: 
:320: mscs-test-161.budzdorov.ru    Sat Jan 23 19:27:25 2021
:321:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:322: 
--- end of diff output ---

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

23.01.21 19:28:56. 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-01-23 19:28:58 No severe PSQL-related problems occured
23.01.21 19:28:59. End of report.