Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.02.2021 22: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 17088444 kB
MemAvailable 31215932 kB
Buffers 0 kB
Cached 14631192 kB
SwapCached 4772 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-10 22:27:18
DTS_END                         2021-02-10 22:27:18.9820
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(345:9) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46514
TRN_ID                          243653
ATT_ID                          720
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: 9166.27 20657 1099952
customer order: creation 174.27 377 20912
customer order: refuse 15.13 338 1816
order to supplier: creation 46.88 1199 5625
order to supplier: removal 3.50 100506 420
invoice (draft): creation 46.54 3723 5585
invoice (draft): removal 51.68 845 6201
invoice accept: apply 42.70 17260 5124
invoice accept: cancel 46.58 798 5590
customer reserve: creation 3882.72 174 465926
customer reserve: removal 4552.02 61 546243
realization accept: apply 84.72 152 10166
realization accept: cancel 90.78 96 10894
payment from customer: creation 58.72 110 7046
payment from customer: removal 5.63 105 676
payment to supplier: creation 48.61 110 5833
payment to supplier: removal 3.43 74 412
service: total inventory turnovers 4.69 1111 563
service: total monetary turnovers 6.62 24 794
service: aggregate perf. data 1.02 15570 122
service: refresh index statistics 0.03 270513 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-02-2021 22:29:15 to 10-02-2021 22:29:17.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1740
TEST_TIME 2 2709
TEST_TIME 3 3664
TEST_TIME 4 3654
TEST_TIME 5 3738
TEST_TIME 6 3911
TEST_TIME 7 4163
TEST_TIME 8 4305
TEST_TIME 9 4243
TEST_TIME 10 5288
TEST_TIME 11 5754
TEST_TIME 12 6031
TEST_TIME 13 6508
TEST_TIME 14 6828
TEST_TIME 15 7287
TEST_TIME 16 7368
TEST_TIME 17 7481
TEST_TIME 18 8015
TEST_TIME 19 8372
TEST_TIME 20 8948
TEST_TIME 21 8920
TEST_TIME 22 8964
TEST_TIME 23 9042
TEST_TIME 24 9167
TEST_TIME 25 9684
TEST_TIME 26 10019
TEST_TIME 27 10216
TEST_TIME 28 10729
TEST_TIME 29 10588
TEST_TIME 30 10730
TEST_TIME 31 10676
TEST_TIME 32 10574
TEST_TIME 33 10502
TEST_TIME 34 10394
TEST_TIME 35 10171
TEST_TIME 36 10177
TEST_TIME 37 10084
TEST_TIME 38 10008
TEST_TIME 39 9979
TEST_TIME 40 10028
TEST_TIME 41 10044
TEST_TIME 42 9962
TEST_TIME 43 10061
TEST_TIME 44 9930
TEST_TIME 45 9834
TEST_TIME 46 9657
TEST_TIME 47 9649
TEST_TIME 48 9670
TEST_TIME 49 9530
TEST_TIME 50 9472
TEST_TIME 51 9523
TEST_TIME 52 9470
TEST_TIME 53 9492
TEST_TIME 54 9691
TEST_TIME 55 9619
TEST_TIME 56 9713
TEST_TIME 57 9659
TEST_TIME 58 9690
TEST_TIME 59 9683
TEST_TIME 60 9764
TEST_TIME 61 9770
TEST_TIME 62 9765
TEST_TIME 63 9677
TEST_TIME 64 9553
TEST_TIME 65 9516
TEST_TIME 66 9566
TEST_TIME 67 9514
TEST_TIME 68 9467
TEST_TIME 69 9372
TEST_TIME 70 9308
TEST_TIME 71 9369
TEST_TIME 72 9342
TEST_TIME 73 9373
TEST_TIME 74 9332
TEST_TIME 75 9398
TEST_TIME 76 9506
TEST_TIME 77 9478
TEST_TIME 78 9507
TEST_TIME 79 9495
TEST_TIME 80 9611
TEST_TIME 81 9590
TEST_TIME 82 9640
TEST_TIME 83 9753
TEST_TIME 84 9698
TEST_TIME 85 9604
TEST_TIME 86 9582
TEST_TIME 87 9536
TEST_TIME 88 9518
TEST_TIME 89 9478
TEST_TIME 90 9421
TEST_TIME 91 9444
TEST_TIME 92 9427
TEST_TIME 93 9423
TEST_TIME 94 9409
TEST_TIME 95 9419
TEST_TIME 96 9388
TEST_TIME 97 9389
TEST_TIME 98 9402
TEST_TIME 99 9464
TEST_TIME 100 9458
TEST_TIME 101 9436
TEST_TIME 102 9456
TEST_TIME 103 9488
TEST_TIME 104 9495
TEST_TIME 105 9490
TEST_TIME 106 9493
TEST_TIME 107 9490
TEST_TIME 108 9525
TEST_TIME 109 9462
TEST_TIME 110 9430
TEST_TIME 111 9399
TEST_TIME 112 9373
TEST_TIME 113 9317
TEST_TIME 114 9302
TEST_TIME 115 9262
TEST_TIME 116 9210
TEST_TIME 117 9234
TEST_TIME 118 9234
TEST_TIME 119 9208
TEST_TIME 120 9167

Performance per minute, chart


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

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 1531596 1531596 0 0.00 0 15869 6 0 0
doc_list_biud 1531572 1531572 0 0.00 0 35461 28 0 0
sp_add_invoice_to_stock 5222 5124 98 1.87 29 220209 17261 0 98
sp_cancel_adding_invoice 5590 5590 0 0.00 5 50361 798 0 0
sp_cancel_client_order 1816 1816 0 0.00 5 11370 339 0 0
sp_cancel_customer_reserve 546243 546243 0 0.00 1 29020 61 0 0
sp_cancel_pay_from_customer 676 676 0 0.00 2 6359 106 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 2317 74 0 0
sp_cancel_supplier_invoice 6207 6201 6 0.09 2 35471 846 0 6
sp_cancel_supplier_order 420 420 0 0.00 6 982413 100506 0 0
sp_cancel_write_off 10894 10894 0 0.00 1 8183 96 0 0
sp_client_order 20912 20912 0 0.00 3 46242 378 0 0
sp_customer_reserve 465926 465926 0 0.00 0 115150 174 0 0
sp_fill_shopping_cart 32112 32112 0 0.00 1 46282 45 0 0
sp_fill_shopping_cart_clo_res 465924 465924 0 0.00 0 41093 14 0 0
sp_get_clo_for_invoice 5122 5122 0 0.00 0 27250 284 0 0
sp_kill_cost_storno 17572 17572 0 0.00 0 8833 52 0 0
sp_kill_qstorno_ret_qs2qd 1110001 1110001 0 0.00 0 35456 33 0 0
sp_kill_qty_storno 586436 586436 0 0.00 0 35459 72 0 0
sp_lock_selected_doc 21128 21128 0 0.00 0 6007 4 0 0
sp_make_cost_storno 28166 28166 0 0.00 0 13955 50 0 0
sp_multiply_rows_for_pdistr 28142 28142 0 0.00 0 8519 26 0 0
sp_multiply_rows_for_qdistr 20912 20912 0 0.00 0 46230 197 0 0
sp_pay_from_customer 7046 7046 0 0.00 4 16517 111 0 0
sp_pay_to_supplier 5833 5833 0 0.00 5 10158 110 0 0
sp_payment_common 12870 12870 0 0.00 1 16513 26 0 0
sp_qd_handle_on_cancel_clo 1816 1816 0 0.00 0 11150 301 0 0
sp_qd_handle_on_invoice_upd_sts 10697 10697 0 0.00 0 28968 327 0 0
sp_qd_handle_on_reserve_upd_sts 10165 10165 0 0.00 0 10012 52 0 0
sp_reserve_write_off 10166 10166 0 0.00 6 12394 153 0 0
sp_supplier_invoice 5585 5585 0 0.00 6 140811 3724 0 0
sp_supplier_order 5625 5625 0 0.00 5 68663 1200 0 0
srv_aggregate_perf_data 122 122 0 0.00 2811 118711 15570 0 0
srv_fill_mon_cache_memory 153 153 0 0.00 1032 139124 33858 0 0
srv_find_qd_qs_mism 1052029 1052029 0 0.00 0 15868 5 0 0
srv_make_invnt_saldo 563 563 0 0.00 56 49962 1111 0 0
srv_make_money_saldo 794 794 0 0.00 1 1335 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 132464 426071 270514 0 0
t$perf-abend:sp_add_invoice_to_stock 98 98 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5124 5124 0 0.00 0 8972 153 0 0
t$perf-norm:sp_cancel_adding_invoice 439 439 0 0.00 0 3513 105 0 0
t$perf-norm:sp_cancel_client_order 1816 1816 0 0.00 0 6720 18 0 0
t$perf-norm:sp_cancel_customer_reserve 650 650 0 0.00 0 899 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 676 676 0 0.00 0 15355 29 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 338 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 423 423 0 0.00 0 643 11 0 0
t$perf-norm:sp_cancel_supplier_order 420 420 0 0.00 0 21508 1587 0 0
t$perf-norm:sp_cancel_write_off 1022 1022 0 0.00 0 3994 9 0 0
t$perf-norm:sp_client_order 20912 20912 0 0.00 0 6679 16 0 0
t$perf-norm:sp_customer_reserve 999 999 0 0.00 0 1979 13 0 0
t$perf-norm:sp_pay_from_customer 7046 7046 0 0.00 0 7183 7 0 0
t$perf-norm:sp_pay_to_supplier 5833 5833 0 0.00 0 6363 11 0 0
t$perf-norm:sp_reserve_write_off 10166 10166 0 0.00 0 11873 11 0 0
t$perf-norm:sp_supplier_invoice 5585 5585 0 0.00 0 11902 26 0 0
t$perf-norm:sp_supplier_order 5625 5625 0 0.00 0 5928 13 0 0
t$perf-norm:srv_aggregate_perf_data 122 122 0 0.00 0 476 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 153 153 0 0.00 0 325 4 0 0
t$perf-norm:srv_make_invnt_saldo 563 563 0 0.00 0 4179 44 0 0
t$perf-norm:srv_make_money_saldo 794 794 0 0.00 0 3991 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 630 160 0 0
v_add_invoice_to_stock 10404 10208 196 1.88 0 5091 19 0 196
v_all_customers 38240 38240 0 0.00 0 48 1 0 0
v_all_suppliers 30704 30704 0 0.00 0 22 1 0 0
v_all_wares 41824 41824 0 0.00 0 88 1 0 0
v_cancel_adding_invoice 878 878 0 0.00 0 3509 17 0 0
v_cancel_client_order 3632 3632 0 0.00 0 11091 11 0 0
v_cancel_customer_prepayment 1352 1352 0 0.00 0 2933 13 0 0
v_cancel_customer_reserve 1300 1300 0 0.00 0 1354 5 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 2075 7 0 0
v_cancel_supplier_invoice 858 846 12 1.39 0 2045 15 0 12
v_cancel_supplier_order 840 840 0 0.00 0 2712 6 0 0
v_cancel_write_off 2044 2044 0 0.00 0 3577 16 0 0
v_max_id_clo_ord 5621 5621 0 0.00 0 569 1 0 0
v_max_id_clo_res 999 999 0 0.00 0 1273 16 0 0
v_max_id_ord_sup 5578 5578 0 0.00 0 4803 4 0 0
v_max_non_paid_invoice 1668 1668 0 0.00 0 755 3 0 0
v_max_non_paid_realizn 3639 3639 0 0.00 0 3694 5 0 0
v_min_id_clo_ord 5621 5621 0 0.00 0 1588 4 0 0
v_min_id_clo_res 999 999 0 0.00 0 5042 11 0 0
v_min_id_ord_sup 5578 5578 0 0.00 0 5428 9 0 0
v_min_non_paid_invoice 5828 5828 0 0.00 0 5826 15 0 0
v_min_non_paid_realizn 7040 7040 0 0.00 0 16510 18 0 0
v_our_firm 10386 10386 0 0.00 0 18 1 0 0
v_reserve_write_off 20330 20330 0 0.00 0 4253 5 0 0
x_lock_depdocs_on_canc_invoice 11368 11368 0 0.00 0 13286 107 0 0
x_lock_depdocs_on_canc_sup_ord 420 420 0 0.00 0 23684 414 0 0
x_make_qstorno_1000_1200 5625 5625 0 0.00 1 68619 1128 0 0
x_make_qstorno_1200_2000 5585 5585 0 0.00 3 140151 3539 0 0
x_make_qstorno_2100_3300 465926 465926 0 0.00 0 114515 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-02-2021 22:29:23 to 10-02-2021 22:29:27.

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
19:57:22 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:29 8681 8192000000 10180324016 10475945984 906732032 9.965 74 55 115 0 928941728 2560144 19649552
19:57:46 21154 8192000000 10296221584 10609639424 1344404848 14.097 100 79 158 0 1375206864 3959696 26842320
19:58:15 38032 8192000000 10366672048 10684411904 1419333088 14.767 100 91 182 0 1454359008 5828112 29197808
19:59:09 27128 8192000000 10399263680 10723373056 1451798592 15.054 100 89 178 0 1487720752 7084512 28837648
19:59:45 15811 8192000000 10408682800 10736549888 1467708800 15.194 100 85 170 0 1502802576 7471760 27622016
20:00:10 18718 8192000000 10430221152 10762149888 1486810672 15.361 100 85 170 0 1521881264 7528544 27542048
20:00:37 18095 8192000000 10455229216 10786799616 1507729984 15.544 100 90 180 0 1544058096 7957504 28370608
20:01:10 20931 8192000000 10472571120 10810998784 1529531984 15.733 100 92 184 0 1567710208 8994896 29183328
20:01:39 18274 8192000000 10498807824 10840461312 1553516256 15.940 100 87 174 1 1590396240 9525952 27354032
20:02:11 11065 8192000000 10528282576 10878898176 1583869696 16.201 100 75 150 0 1616874096 9792688 23211712
20:02:32 13924 8192000000 10562050624 10917715968 1611258816 16.435 100 80 160 0 1645670720 10085408 24326496
20:02:57 12217 8192000000 10587341360 10949079040 1648976336 16.756 100 76 152 1 1681849648 10219744 22653568
20:03:20 12550 8192000000 10606322256 10975588352 1673862832 16.966 100 73 146 1 1706069840 10947952 21259056
20:03:40 6601 8192000000 10623084544 10989051904 1686812704 17.075 100 75 148 1 1719267424 10299408 22155312
20:03:54 10045 8192000000 10646536560 11018063872 1706550800 17.240 100 78 156 1 1740121664 11062816 22508048
20:04:13 6852 8192000000 10656047536 11028381696 1717811072 17.334 100 69 139 0 1749449136 11508704 20129360
20:04:26 6747 8192000000 10673710352 11047571456 1728960560 17.427 100 81 159 3 1763358448 11917424 22480464
20:04:41 7240 8192000000 10678040992 11053240320 1738800512 17.509 100 73 147 0 1772173760 12582368 20790880
20:04:55 5281 8192000000 10699262032 11073527808 1755109200 17.644 100 81 163 1 1791155200 13321888 22724112
20:05:07 5671 8192000000 10698394640 11079598080 1762692192 17.707 100 78 154 1 1797686544 13151072 21843280
20:05:22 5024 8192000000 10709395184 11092336640 1776933552 17.824 100 69 138 2 1808186768 12649376 18603840
20:05:34 4549 8192000000 10728097376 11107377152 1787848912 17.914 100 82 161 1 1822988672 12618304 22521456
20:05:46 8956 8192000000 10724343984 11111120896 1793701440 17.962 100 79 158 1 1829088720 13906144 21481136
20:06:02 5145 8192000000 10750812448 11133513728 1799853856 18.013 100 80 160 0 1836017152 13728816 22434480
20:06:14 3092 8192000000 10750723088 11140276224 1816168688 18.146 100 78 156 0 1852156224 14127104 21860432
20:06:25 2913 8192000000 10767025600 11153276928 1825107088 18.219 100 82 162 2 1862361696 13811680 23442928
20:06:36 3377 8192000000 10767769952 11159789568 1833332416 18.286 100 81 161 2 1869314944 12846752 23135776
20:06:47 2336 8192000000 10777677632 11165663232 1837055248 18.317 100 76 151 1 1870215312 12396192 20763872
20:06:55 3548 8192000000 10783790528 11171766272 1843608064 18.370 100 72 142 1 1875497136 11812208 20076864
20:07:06 2494 8192000000 10791450304 11179089920 1851627264 18.435 100 89 179 0 1889650992 13511600 24512128
20:07:15 1952 8192000000 10791472352 11186794496 1853449568 18.450 100 81 160 2 1889219088 12470416 23299104
20:07:24 1597 8192000000 10796815888 11184537600 1854751888 18.461 100 85 172 0 1890725472 12162976 23810608
20:07:32 2567 8192000000 10800668432 11188432896 1861104304 18.512 100 91 182 0 1899239040 12929760 25204976
20:07:40 2858 8192000000 10800315328 11193978880 1863912864 18.535 100 85 170 2 1901192240 13322128 23957248
20:07:51 7102 8192000000 10801806512 11192233984 1862345408 18.522 100 81 162 0 1899176704 12813184 24018112
20:08:05 2817 8192000000 10803138608 11202195456 1866362192 18.555 100 73 145 1 1898528272 10990096 21175984
20:08:14 2353 8192000000 10816404368 11205533696 1873598928 18.613 100 88 176 1 1909856224 11308416 24948880
20:08:23 1995 8192000000 10823478512 11210219520 1878437952 18.652 100 93 184 2 1916884192 12852368 25593872
20:08:31 1650 8192000000 10823346256 11215970304 1878731424 18.655 100 91 181 2 1917123888 13771600 24620864
20:08:39 1297 8192000000 10831590048 11218841600 1882096272 18.682 100 93 187 2 1921522256 13677728 25748256
20:08:47 2569 8192000000 10808655472 11210444800 1875799664 18.631 100 67 133 0 1907069664 13271712 17998288
20:08:56 5036 8192000000 10813192896 11205996544 1875010544 18.625 100 59 119 0 1902683840 10427680 17245616
20:09:09 1452 8192000000 10822108688 11212517376 1878980096 18.657 100 82 163 1 1912612480 10463568 23168816
20:09:16 9519 8192000000 10789202944 11204374528 1874571328 18.621 100 47 94 0 1897176384 8931456 13673600
20:09:34 8043 8192000000 10790830704 11211739136 1873730672 18.614 100 36 72 0 1891587408 7962224 9894512
20:09:51 5132 8192000000 10795190864 11212894208 1880532128 18.669 100 52 107 3 1903448368 7019520 15896720
20:10:04 5819 8192000000 10786321920 11210625024 1876608640 18.638 100 24 48 2 1889294704 6088736 6597328
20:10:17 4912 8192000000 10799761520 11216461824 1881134432 18.674 100 32 62 1 1897635392 7820496 8680464
20:10:31 8852 8192000000 10792303696 11216343040 1882121776 18.682 100 26 53 2 1896551904 7285872 7144256
20:10:46 7412 8192000000 10793737712 11221196800 1886564800 18.718 100 29 58 3 1901875168 7282288 8028080
20:11:01 6570 8192000000 10793969520 11222077440 1886784800 18.720 100 32 64 0 1903385648 7715776 8885072
20:11:14 7679 8192000000 10801470272 11226542080 1888584608 18.734 100 41 78 4 1910619024 10857952 11176464
20:11:29 7555 8192000000 10804277040 11234381824 1889809344 18.744 100 39 78 1 1908265936 7514688 10941904
20:11:44 4437 8192000000 10797744208 11228184576 1892822768 18.769 100 28 57 2 1906141488 5768432 7550288
20:11:54 6848 8192000000 10802736912 11230461952 1892264016 18.764 100 23 42 2 1904178496 6327776 5586704
20:12:09 11511 8192000000 10803239072 11226906624 1895640096 18.791 100 30 60 1 1910041120 5230192 9170832
20:12:28 84157 8192000000 10813263840 11247816704 1898769424 18.816 100 29 58 3 1912472192 5794352 7908416
20:13:59 6761 8192000000 10832252944 11254140928 1901906672 18.842 100 29 56 3 1915978544 6277424 7794448
20:14:13 5858 8192000000 10819797680 11253178368 1905082080 18.867 100 39 78 3 1922178704 5744176 11352448
20:14:26 8628 8192000000 10826839232 11258998784 1904042400 18.859 100 19 38 0 1919747920 10312400 5393120
20:14:41 8230 8192000000 10825258720 11257544704 1908875888 18.898 100 23 46 0 1921272656 5850704 6546064
20:14:59 7192 8192000000 10833562336 11263787008 1911632112 18.920 100 31 62 2 1927273968 6679120 8962736
20:15:15 3783 8192000000 10840196304 11268595712 1918366528 18.974 100 40 80 3 1935765712 6065248 11333936
20:15:25 6622 8192000000 10844275440 11275763712 1920973312 18.995 100 31 62 1 1936689904 6681760 9034832
20:15:43 9310 8192000000 10828713264 11261878272 1882458928 18.685 98 19 38 3 1892999056 5283520 5256608
20:15:58 11330 8192000000 10827820672 11258257408 1893858672 18.777 99 28 56 3 1908146432 6144944 8142816
20:16:19 4277 8192000000 10813131440 11243925504 1882999712 18.689 99 23 46 0 1896129296 6942896 6186688
20:16:29 14447 8192000000 10799095920 11233828864 1852250368 18.440 97 13 26 1 1860708688 5139344 3318976
20:16:52 11281 8192000000 10805461248 11246907392 1881280352 18.675 99 24 48 2 1894182976 6391152 6511472
20:17:11 51757 8192000000 10818294256 11233406976 1843363136 18.368 97 33 66 3 1857650112 5066592 9220384
20:18:09 19607 8192000000 10752790176 11181522944 1769257200 17.761 94 30 61 1 1783189008 5721312 8210496
20:18:35 8388 8192000000 10771850496 11205795840 1860817680 18.510 100 27 54 6 1874097760 6466464 6813616
20:18:52 8126 8192000000 10792591104 11214815232 1842073344 18.358 98 15 30 1 1851803952 5218624 4511984
20:19:10 6629 8192000000 10796975536 11219849216 1862416016 18.523 99 34 68 1 1879814336 7432384 9965936
20:19:22 6139 8192000000 10768454720 11187884032 1792470496 17.952 96 32 63 0 1807823040 5903904 9448640
20:19:36 5109 8192000000 10746190112 11168604160 1797897248 17.997 98 26 50 2 1814386368 9674352 6814768
20:19:50 8518 8192000000 10698917344 11114250240 1709022240 17.261 95 26 52 0 1726870704 10679728 7168736
20:20:08 4782 8192000000 10691655824 11100487680 1747457456 17.581 97 21 41 1 1759258480 5820992 5980032
20:20:19 6716 8192000000 10706249520 11114307584 1743640800 17.549 97 18 36 1 1754161424 5442256 5078368
20:20:32 9247 8192000000 10688237696 11104997376 1687592304 17.081 94 21 42 1 1699097648 5571984 5933360
20:20:49 7793 8192000000 10689196848 11101999104 1730712688 17.441 97 20 40 0 1742150224 5211488 6226048
20:21:03 7439 8192000000 10724913856 11139813376 1803983856 18.047 100 35 70 0 1820510720 5596128 10930736
20:21:18 8625 8192000000 10700528752 11125231616 1758850832 17.675 97 22 44 1 1770579552 5275728 6452992
20:21:36 6085 8192000000 10718853424 11138580480 1802710656 18.036 100 25 49 0 1816006992 6247408 7048928
20:21:51 10570 8192000000 10718958032 11137458176 1791448528 17.944 99 30 60 2 1806074992 5210384 9416080
20:22:12 43171 8192000000 10749464768 11161350144 1826318512 18.229 100 32 63 3 1840493456 5180480 8994464
20:23:07 39124 8192000000 10750689008 11170897920 1807883376 18.079 98 29 57 2 1821224272 5501584 7839312
20:23:53 11463 8192000000 10783511312 11190157312 1846380512 18.393 100 23 46 0 1858701072 5697456 6623104
20:24:11 6088 8192000000 10770907280 11197734912 1854058848 18.455 100 31 62 1 1873865232 11276240 8530144
20:24:23 7541 8192000000 10768062544 11200245760 1860696560 18.509 100 25 50 2 1873762496 5542736 7523200
20:24:38 5916 8192000000 10786440208 11207499776 1864606464 18.541 100 36 70 2 1881141696 6584896 9950336
20:24:54 5479 8192000000 10792661600 11212394496 1867759456 18.566 100 30 60 0 1882392192 5618048 9014688
20:25:13 8767 8192000000 10777780352 11211997184 1866481536 18.556 100 16 32 1 1876082160 4953344 4647280
20:25:27 5950 8192000000 10783883168 11218808832 1872401536 18.604 100 25 50 1 1885864880 6053200 7410144
20:25:42 12570 8192000000 10795859824 11223437312 1876768928 18.639 100 24 47 3 1889100080 4999344 7331808
20:26:02 9513 8192000000 10795569344 11226341376 1879293008 18.659 100 22 44 3 1891652688 5270592 7089088
20:26:21 14265 8192000000 10789642032 11225182208 1879419696 18.660 100 23 46 3 1890849472 4867344 6562432
20:26:47 6541 8192000000 10802218960 11233234944 1885653936 18.711 100 24 47 2 1899012112 5560064 7798112
20:27:03 6556 8192000000 10815327792 11239497728 1898678736 18.816 100 27 53 2 1912308224 5792832 7836656
20:27:15 111043 8192000000 10847692672 11271106560 1916100208 18.956 100 50 99 2 1937393968 6261136 15032624
20:29:20 43198 8192000000 10857992832 11286798336 1925838240 19.034 100 29 58 0 1944232880 9202000 9192640
20:30:11 15694 8192000000 10865588928 11297722368 1938169728 19.132 100 48 96 1 1962958752 10503792 14285232
20:30:50 17379 8192000000 10896368912 11322810368 1953233264 19.252 100 57 113 0 1981960592 12068560 16658768
20:31:17 30368 8192000000 10896479424 11331555328 1962080528 19.323 100 45 90 0 1991918432 16612224 13225680
20:31:55 29837 8192000000 10907859872 11344535552 1972702480 19.407 100 39 78 1 2002151984 17399360 12050144
20:32:32 5475 8192000000 10927393920 11354185728 1980832976 19.471 100 59 115 0 2015472400 18224528 16414896
20:32:52 22742 8192000000 10930519344 11364593664 1985167024 19.506 100 51 102 2 2020178944 19768496 15243424
20:33:24 4685 8192000000 10926440368 11362942976 1990001088 19.544 100 47 88 2 2021919760 18862384 13056288
20:33:40 10459 8192000000 10941896800 11367419904 1988405616 19.531 100 53 106 3 2025310080 20383712 16520752
20:34:10 16525 8192000000 10914338912 11351400448 1966307232 19.356 99 47 94 0 2002553600 21265344 14981024
20:34:50 10675 8192000000 10932354336 11368574976 1987296368 19.522 100 48 96 3 2024730448 22114416 15319664
20:35:09 13837 8192000000 10915203664 11357536256 1947408240 19.206 98 38 72 3 1984617696 25258944 11950512
20:35:39 13468 8192000000 10920841856 11354562560 1955235920 19.268 99 47 94 1 1992265952 22166288 14863744
20:36:04 8662 8192000000 10928947184 11361873920 1976773600 19.439 100 48 95 1 2016042256 24140544 15128112
20:36:27 7659 8192000000 10935524368 11365498880 1981333440 19.475 100 53 106 0 2024374368 26387072 16653856
20:36:42 5174 8192000000 10951463056 11380404224 1993294416 19.570 100 62 123 3 2040013040 28464176 18254448
20:36:54 8956 8192000000 10957385664 11387842560 1997250896 19.601 100 63 125 1 2046888464 29818512 19819056
20:37:15 3645 8192000000 10960619584 11390959616 1998486512 19.611 100 67 131 0 2046796576 27938768 20371296
20:37:25 2865 8192000000 10954726944 11373367296 1983219344 19.490 99 67 132 0 2030114768 27040480 19854944
20:37:37 4144 8192000000 10957826688 11385610240 1997118832 19.600 100 66 132 1 2042291472 25494832 19677808
20:37:50 17324 8192000000 10961952944 11399217152 2004017408 19.654 100 59 118 1 2050982464 27935600 19029456
20:38:16 4946 8192000000 10953480048 11395395584 1999105392 19.616 100 41 80 0 2039313840 26549072 13659376
20:38:37 2758 8192000000 10961892048 11393126400 2003543712 19.651 100 73 147 3 2049029824 23474928 22011184
20:38:48 2468 8192000000 10965725040 11398451200 2008034656 19.686 100 68 136 1 2055292560 26101056 21156848
20:38:58 2976 8192000000 10970198768 11397287936 2008595616 19.690 100 81 162 2 2059657392 26703296 24358480
20:39:10 3789 8192000000 10956768704 11390099456 1998577264 19.612 100 75 148 1 2049086736 27603584 22905888
20:39:20 5843 8192000000 10975848784 11398467584 2004108624 19.655 100 78 154 0 2056159536 28393808 23657104
20:39:37 3568 8192000000 10970663616 11401330688 2006335264 19.673 100 61 122 1 2054064000 28902560 18826176
20:39:48 3785 8192000000 10973159328 11398713344 2007672416 19.683 100 82 165 0 2060849904 28130624 25046864
20:40:02 3830 8192000000 10987231616 11410673664 2012355792 19.720 100 82 161 1 2066866400 30078864 24431744
20:40:12 5717 8192000000 10980043888 11411046400 2011240448 19.711 100 69 138 1 2063332960 30963344 21129168
20:40:29 3148 8192000000 10989081568 11407892480 2012496592 19.721 100 88 177 1 2069988320 30084224 27407504
20:40:42 2736 8192000000 10975605072 11402121216 1995888928 19.590 99 86 172 1 2052194288 30541520 25763840
20:40:52 3654 8192000000 10981305440 11405004800 2010941968 19.709 100 89 178 1 2066729408 29227808 26559632
20:41:03 6160 8192000000 10976099008 11407028224 2009348048 19.696 100 79 158 1 2064438672 31333888 23756736
20:41:18 7019 8192000000 10980977008 11410694144 2010262816 19.704 100 75 150 0 2064635776 31753648 22619312
20:41:32 2804 8192000000 10961621584 11385565184 1990381136 19.547 100 76 150 0 2043098320 30487136 22230048
20:41:42 5490 8192000000 10956045504 11380195328 1986243552 19.514 100 77 154 2 2040820064 30815232 23761280
20:42:00 2773 8192000000 10962143952 11385364480 1991040336 19.552 100 81 163 0 2046015952 29204112 25771504
20:42:09 1031 8192000000 10941907072 11348471808 1954876144 19.265 98 96 190 2 2014842752 30839968 29126640
20:42:17 1049 8192000000 10924469056 11332775936 1948481632 19.214 99 91 182 3 2004197616 28296576 27419408
20:42:27 3040 8192000000 10932910000 11347619840 1958755456 19.296 100 79 156 2 2011092112 29189920 23146736
20:42:37 1490 8192000000 10932720912 11342856192 1958957936 19.298 100 89 178 1 2015074896 28866944 27250016
20:42:57 3768 8192000000 10929376608 11349446656 1961417168 19.317 100 68 134 1 2012891280 31298816 20175296
20:43:09 3865 8192000000 10940601776 11354230784 1958475344 19.294 100 77 152 1 2013640336 31532432 23632560
20:43:19 1578 8192000000 10938610912 11348160512 1958735520 19.296 99 88 176 1 2017422192 32027744 26658928
20:43:28 3122 8192000000 10934590896 11348828160 1945461264 19.190 99 82 161 2 2004185408 32951792 25772352
20:43:41 6291 8192000000 10935699088 11357478912 1960844160 19.313 100 76 151 3 2017116576 32788928 23483488
20:43:54 4897 8192000000 10932484992 11353313280 1958505920 19.294 100 78 156 3 2017375408 34414528 24454960
20:44:06 2821 8192000000 10926519440 11341672448 1936584880 19.119 99 83 166 1 1999181920 36288688 26308352
20:44:17 2567 8192000000 10913231792 11322474496 1927672416 19.048 99 86 168 2 1991985360 36956576 27356368
20:44:29 2587 8192000000 10933825952 11343294464 1947488688 19.206 100 90 181 3 2015239632 39866560 27884384
20:44:40 2139 8192000000 10906878288 11320856576 1909341136 18.901 99 75 149 0 1974006416 40502096 24163184
20:44:49 5734 8192000000 10906058576 11316523008 1902928656 18.850 99 71 142 1 1966341344 40774384 22638304
20:45:01 2490 8192000000 10924688048 11333345280 1928340016 19.054 100 79 156 0 1996029056 41835632 25853408
20:45:11 15765 8192000000 10900842624 11340574720 1934299840 19.101 100 34 66 1 1985759328 39310464 12149024
20:45:36 6210 8192000000 10924654384 11355373568 1951462800 19.238 100 59 117 1 2009614000 39042992 19108208
20:45:56 6792 8192000000 10930943568 11364827136 1961999440 19.322 100 55 110 1 2014645104 34747232 17898432
20:46:10 10725 8192000000 10921201120 11353231360 1946608224 19.199 99 47 92 0 1997334464 35714528 15011712
20:46:37 8153 8192000000 10929189232 11365318656 1967640240 19.367 100 57 114 0 2017969360 31761680 18567440
20:46:58 8258 8192000000 10943165776 11372855296 1968332624 19.372 100 69 136 0 2027084576 37881344 20870608
20:47:13 11097 8192000000 10924606688 11368034304 1951265376 19.237 99 47 94 3 2000985936 34353104 15367456
20:47:39 12560 8192000000 10898270208 11348680704 1952142272 19.244 100 41 82 0 1995300560 29601792 13556496
20:48:02 18838 8192000000 10923669888 11352584192 1941000288 19.155 99 40 80 3 1986078144 32551184 12526672
20:48:28 5518 8192000000 10919019520 11350454272 1953854576 19.257 100 63 126 2 2006006656 32814080 19338000
20:48:43 15824 8192000000 10918769232 11365097472 1959694080 19.304 100 36 72 1 2005709264 34627824 11387360
20:49:05 13344 8192000000 10925608672 11367677952 1968801856 19.376 100 35 69 2 2012175968 31805168 11568944
20:49:29 4876 8192000000 10929170720 11361689600 1950937360 19.234 99 44 86 2 1993780272 29387488 13455424
20:49:41 16695 8192000000 10917353984 11360669696 1960975376 19.314 100 45 90 4 2004512464 29470768 14066320
20:50:06 19875 8192000000 10901814992 11343327232 1930961168 19.075 99 38 76 0 1972983968 29365984 12656816
20:50:34 20647 8192000000 10901245088 11347050496 1946149072 19.196 100 35 70 2 1990459584 32558736 11751776
20:51:01 13757 8192000000 10901425936 11347308544 1944128544 19.180 100 24 48 2 1982741616 29997264 8615808
20:51:53 7936 8192000000 10924928880 11365175296 1952747424 19.248 100 42 82 0 2003677232 36798464 14131344
20:52:11 18220 8192000000 10897403696 11353788416 1915364240 18.950 98 26 52 2 1959619296 35129536 9125520
20:52:43 23409 8192000000 10883191440 11343888384 1933323408 19.093 100 17 34 0 1972284336 32461568 6499360
20:53:32 30633 8192000000 10891706736 11355795456 1939164944 19.140 100 18 36 0 1979297744 33582064 6550736
20:54:33 51345 8192000000 10870149664 11334619136 1920076288 18.987 99 20 40 0 1954821808 28697984 6047536
20:55:32 40822 8192000000 10891345904 11356725248 1943694848 19.176 100 22 43 1 1968237536 17929888 6612800
20:56:32 68344 8192000000 10858549344 11324858368 1852819808 18.445 95 15 30 1 1880769792 23256144 4693840
20:57:48 48662 8192000000 10872221552 11323486208 1917222496 18.965 99 28 56 3 1939789904 14609840 7957568
20:58:44 107562 8192000000 10877907184 11341946880 1930366032 19.070 99 17 34 3 1950200032 15465520 4368480
21:01:01 64969 8192000000 10876939264 11331129344 1920085152 18.988 98 41 78 3 1941596896 10416448 11095296
21:02:12 129215 8192000000 10893392000 11354828800 1927205328 19.045 98 37 74 0 1949075152 10602752 11267072
21:04:28 30197 8192000000 10899709952 11359391744 1953508752 19.254 99 26 53 3 1974122528 13219472 7394304
21:05:08 21407 8192000000 10895127968 11350016000 1951240304 19.236 99 22 44 1 1969871184 12653216 5977664
21:05:36 36342 8192000000 10927382416 11380527104 1975812272 19.432 100 31 63 0 2002057616 15954496 10290848
21:06:26 41243 8192000000 10912210096 11382226944 1964885296 19.345 99 20 40 2 1991196784 20251088 6060400
21:07:14 139124 8192000000 10881553072 11347103744 1920126720 18.988 97 24 48 0 1943498848 16198256 7173872
21:09:45 45509 8192000000 10896140320 11359420416 1970007344 19.386 100 14 28 0 1983127392 9374848 3745200
21:10:43 55949 8192000000 10879056624 11354206208 1951409328 19.238 99 8 16 0 1962485840 9228992 1847520
21:12:51 87693 8192000000 10892678368 11372269568 1955249760 19.268 99 16 32 0 1976413360 16751536 4412064
21:14:31 34458 8192000000 10899283744 11359801344 1959051776 19.299 99 27 53 2 1977839776 9928736 8859264
21:15:12 34240 8192000000 10904539856 11375149056 1977778576 19.447 100 20 40 0 1995027216 10190160 7058480
21:16:04 61508 8192000000 10887417376 11359481856 1946658992 19.200 98 22 44 0 1962839088 9807312 6372784
21:17:22 30627 8192000000 10898700368 11373092864 1977662832 19.446 100 17 34 2 1991912928 9767792 4482304
21:18:00 69251 8192000000 10919374896 11406536704 1987597936 19.525 100 13 26 1 2003491200 12093808 3799456
21:19:15 41308 8192000000 10906146352 11381317632 1918664176 18.976 96 19 37 0 1941314656 17068592 5581888
21:20:06 44492 8192000000 10917873056 11387277312 1972728352 19.407 99 22 44 0 1993437952 14409616 6299984
21:21:16 51492 8192000000 10899492080 11382530048 1947833440 19.209 98 14 28 1 1966475312 14691504 3950368
21:22:13 100542 8192000000 10868404544 11345399808 1858848928 18.494 94 11 22 0 1873933696 11976576 3108192
21:24:11 20761 8192000000 10895189696 11349336064 1935534816 19.111 99 24 47 1 1950183744 8398624 6250304
21:24:43 58679 8192000000 10882473584 11347398656 1868601488 18.573 95 29 59 1 1888998640 12632944 7764208
21:25:51 33478 8192000000 10901026768 11351506944 1953047072 19.251 100 30 60 0 1974866560 13292288 8527200
21:26:40 86144 8192000000 10880428192 11342659584 1858344736 18.490 95 13 26 1 1870548992 8834640 3369616
21:28:12 84106 8192000000 10869537712 11328249856 1816559648 18.150 93 19 38 0 1837295440 15755248 4980544
21:29:43 23792 8192000000 10879973696 11316170752 1888203904 18.731 97 38 76 0 1907720864 8669104 10847856
21:30:14 100397 8192000000 10895732880 11351089152 1957686672 19.288 100 49 98 1 1986087568 13718224 14682672
21:32:10 64800 8192000000 10889539776 11355922432 1955124368 19.267 100 29 58 1 1980782080 17538576 8119136
21:34:04 53624 8192000000 10871776320 11349528576 1960546672 19.310 100 8 16 0 1969140624 6335520 2258432
21:35:04 43213 8192000000 10839066304 11316670464 1876964304 18.641 96 5 10 1 1884045824 5945904 1135616
21:35:53 54844 8192000000 10857607248 11324137472 1903671664 18.856 98 16 33 0 1915767392 7378000 4717728
21:37:31 66074 8192000000 10859361280 11358158848 1930786464 19.073 99 10 20 0 1949883952 15898560 3198928
21:38:58 78139 8192000000 10870223872 11341926400 1822746176 18.200 93 10 20 0 1838015904 12278656 2991072
21:40:33 42692 8192000000 10868512192 11332763648 1883896144 18.697 96 23 46 1 1908421056 17908560 6616352
21:41:26 50822 8192000000 10868489712 11340668928 1898045392 18.811 97 33 67 1 1928403728 20585728 9772608
21:42:37 48964 8192000000 10871245312 11336777728 1923761568 19.017 99 16 32 0 1951976048 23287168 4927312
21:43:37 33808 8192000000 10893143456 11349938176 1948025936 19.211 100 16 32 0 1965451088 12905520 4519632
21:44:19 26300 8192000000 10901084288 11356934144 1946775024 19.201 99 38 76 0 1967288464 9695728 10817712
21:44:54 43724 8192000000 10850548272 11322814464 1893709440 18.776 97 18 36 1 1908822800 10180016 4933344
21:45:44 77417 8192000000 10900999712 11369762816 1957841152 19.289 100 22 42 0 1981127376 17200624 6085600
21:47:24 56004 8192000000 10883083504 11367223296 1924747728 19.025 98 18 36 3 1946870064 17364288 4758048
21:48:26 98563 8192000000 10899491840 11378208768 1913046976 18.931 97 30 60 1 1933827008 11867744 8912288
21:50:14 37207 8192000000 10889463888 11381542912 1953148752 19.252 100 13 26 1 1979114208 21928128 4037328
21:51:08 119878 8192000000 10909728672 11373604864 1955107216 19.267 99 34 68 2 1974955184 9840464 10007504
21:53:40 58567 8192000000 10889627920 11365425152 1966650208 19.359 100 28 56 2 1986502208 12680160 7171840
21:54:44 35736 8192000000 10878974640 11367997440 1959104576 19.299 100 7 14 0 1972903968 11817520 1981872
21:55:27 49587 8192000000 10882674128 11363426304 1927928880 19.050 98 13 26 0 1942759552 11511120 3319552
21:57:02 77273 8192000000 10888113136 11371692032 1914764624 18.945 97 13 26 2 1935544224 17078416 3701184
21:58:36 28114 8192000000 10883634800 11366674432 1963937632 19.337 100 18 36 0 1979254480 10574560 4742288
21:59:19 90744 8192000000 10890098240 11378397184 1959533424 19.302 99 12 24 0 1972922448 10222976 3166048
22:01:00 66840 8192000000 10892752640 11369525248 1920844640 18.994 97 9 18 0 1931481488 8178176 2458672
22:03:04 42884 8192000000 10899384304 11374231552 1944433920 19.182 98 20 41 0 1959368112 9203424 5730768
22:04:16 71826 8192000000 10917735760 11401084928 1966316080 19.356 99 13 26 0 1987952912 17693616 3943216
22:05:35 71221 8192000000 10885889392 11377139712 1932509232 19.087 97 11 22 0 1952348352 16937184 2901936
22:06:55 52843 8192000000 10919072448 11384524800 1945253520 19.189 98 33 67 1 1969124592 14687392 9183680
22:07:57 22961 8192000000 10911376224 11376427008 1950580960 19.231 98 53 105 1 1978361200 13317744 14462496
22:08:36 33123 8192000000 10908556784 11374968832 1936518848 19.119 98 38 77 0 1965239952 17647104 11074000
22:09:24 15374 8192000000 10894662752 11346288640 1925933328 19.034 98 48 96 0 1949845152 10041216 13870608
22:09:49 11594 8192000000 10912286192 11363704832 1960450688 19.310 100 53 106 1 1987765936 12265424 15049824
22:10:10 108540 8192000000 10889576912 11349782528 1863472640 18.531 95 38 76 0 1889962656 16125424 10364592
22:12:08 41340 8192000000 10884946752 11359264768 1944360320 19.182 99 28 56 0 1962023344 9714944 7948080
22:13:45 49783 8192000000 10882758368 11345887232 1866968688 18.560 95 12 24 1 1877584496 7311872 3303936
22:14:43 81068 8192000000 10858080256 11345522688 1887642592 18.727 97 13 26 0 1912653440 21244992 3765856
22:16:32 103726 8192000000 10837591872 11321380864 1899782352 18.825 98 9 18 0 1911914272 9643520 2488400
22:18:42 49868 8192000000 10837740720 11324260352 1890978688 18.754 98 7 13 1 1904226192 11564240 1683264
22:19:43 35633 8192000000 10842193824 11330445312 1926418880 19.038 100 7 14 0 1942190640 13774000 1997760
22:20:25 20812 8192000000 10842242752 11310878720 1916104416 18.956 99 17 34 1 1930540064 8570144 5865504
22:20:59 66782 8192000000 10866727088 11335045120 1901532144 18.839 98 21 43 2 1917845280 9820976 6492160
22:22:15 62274 8192000000 10868278848 11341971456 1894188672 18.780 97 18 36 0 1916521328 16656592 5676064
22:23:29 84847 8192000000 10891306560 11368120320 1903352928 18.853 97 27 54 0 1937231456 25141952 8736576
22:25:34 46826 8192000000 10901723200 11377549312 1942537904 19.167 99 27 53 3 1976445376 24839120 9068352
22:26:28 45282 8192000000 10899338736 11377934336 1937358144 19.126 99 27 54 3 1973946624 28100304 8488176

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 10-02-2021 22:29:29 to 10-02-2021 22:30:00.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 98 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-02-2021 22:30:01 to 10-02-2021 22:30:03.

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          237994
MON$OLDEST_ACTIVE               243878
MON$OLDEST_SNAPSHOT             243878
MON$NEXT_TRANSACTION            243878
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                       2032096
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:188: 
:189: mscs-test-161.budzdorov.ru    Wed Feb 10 22:27:26 2021
:190:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:191: 
:192: 
:193: mscs-test-161.budzdorov.ru    Wed Feb 10 22:27:27 2021
:194:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:195: 
--- end of diff output ---

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

10.02.21 22:30:04. 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-10 22:30:06 No severe PSQL-related problems occured
10.02.21 22:30:08. End of report.