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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-05 01:27:17
DTS_END                         2021-03-05 01:27:17.7530
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/36632
TRN_ID                          239667
ATT_ID                          726
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: 9400.59 17368 1128071
customer order: creation 175.98 359 21117
customer order: refuse 15.08 354 1810
order to supplier: creation 47.16 1432 5659
order to supplier: removal 3.64 91770 437
invoice (draft): creation 46.26 3408 5551
invoice (draft): removal 53.37 758 6404
invoice accept: apply 42.78 19090 5133
invoice accept: cancel 47.67 733 5720
customer reserve: creation 3980.90 188 477708
customer reserve: removal 4681.34 56 561761
realization accept: apply 86.34 187 10361
realization accept: cancel 87.33 106 10480
payment from customer: creation 61.34 122 7361
payment from customer: removal 6.12 95 734
payment to supplier: creation 49.83 123 5980
payment to supplier: removal 3.59 124 431
service: total inventory turnovers 4.51 1120 541
service: total monetary turnovers 6.58 34 789
service: aggregate perf. data 0.75 24981 90
service: refresh index statistics 0.03 202315 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-03-2021 01:28:49 to 05-03-2021 01:28:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6864
TEST_TIME 2 6714
TEST_TIME 3 7005
TEST_TIME 4 6763
TEST_TIME 5 6993
TEST_TIME 6 6554
TEST_TIME 7 6639
TEST_TIME 8 6615
TEST_TIME 9 6574
TEST_TIME 10 6626
TEST_TIME 11 7029
TEST_TIME 12 7095
TEST_TIME 13 7463
TEST_TIME 14 7380
TEST_TIME 15 7485
TEST_TIME 16 7809
TEST_TIME 17 7822
TEST_TIME 18 8091
TEST_TIME 19 8297
TEST_TIME 20 8314
TEST_TIME 21 8484
TEST_TIME 22 8465
TEST_TIME 23 8335
TEST_TIME 24 8632
TEST_TIME 25 8858
TEST_TIME 26 9470
TEST_TIME 27 9419
TEST_TIME 28 9471
TEST_TIME 29 9864
TEST_TIME 30 10443
TEST_TIME 31 10677
TEST_TIME 32 10769
TEST_TIME 33 10614
TEST_TIME 34 10542
TEST_TIME 35 10497
TEST_TIME 36 10451
TEST_TIME 37 10376
TEST_TIME 38 10244
TEST_TIME 39 10395
TEST_TIME 40 10291
TEST_TIME 41 10241
TEST_TIME 42 10043
TEST_TIME 43 10117
TEST_TIME 44 10053
TEST_TIME 45 10031
TEST_TIME 46 10075
TEST_TIME 47 10115
TEST_TIME 48 10006
TEST_TIME 49 9956
TEST_TIME 50 9865
TEST_TIME 51 9847
TEST_TIME 52 9785
TEST_TIME 53 9753
TEST_TIME 54 9717
TEST_TIME 55 9661
TEST_TIME 56 9725
TEST_TIME 57 9692
TEST_TIME 58 9713
TEST_TIME 59 9684
TEST_TIME 60 9741
TEST_TIME 61 9804
TEST_TIME 62 9870
TEST_TIME 63 9871
TEST_TIME 64 9933
TEST_TIME 65 9892
TEST_TIME 66 9913
TEST_TIME 67 9991
TEST_TIME 68 9984
TEST_TIME 69 9971
TEST_TIME 70 9852
TEST_TIME 71 9830
TEST_TIME 72 9838
TEST_TIME 73 9763
TEST_TIME 74 9849
TEST_TIME 75 9775
TEST_TIME 76 9703
TEST_TIME 77 9628
TEST_TIME 78 9622
TEST_TIME 79 9615
TEST_TIME 80 9528
TEST_TIME 81 9514
TEST_TIME 82 9595
TEST_TIME 83 9568
TEST_TIME 84 9602
TEST_TIME 85 9582
TEST_TIME 86 9583
TEST_TIME 87 9573
TEST_TIME 88 9596
TEST_TIME 89 9652
TEST_TIME 90 9694
TEST_TIME 91 9714
TEST_TIME 92 9758
TEST_TIME 93 9719
TEST_TIME 94 9764
TEST_TIME 95 9676
TEST_TIME 96 9613
TEST_TIME 97 9630
TEST_TIME 98 9579
TEST_TIME 99 9540
TEST_TIME 100 9493
TEST_TIME 101 9441
TEST_TIME 102 9482
TEST_TIME 103 9451
TEST_TIME 104 9442
TEST_TIME 105 9442
TEST_TIME 106 9480
TEST_TIME 107 9465
TEST_TIME 108 9499
TEST_TIME 109 9551
TEST_TIME 110 9524
TEST_TIME 111 9523
TEST_TIME 112 9542
TEST_TIME 113 9574
TEST_TIME 114 9563
TEST_TIME 115 9606
TEST_TIME 116 9573
TEST_TIME 117 9507
TEST_TIME 118 9491
TEST_TIME 119 9478
TEST_TIME 120 9406

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 05-03-2021 01:28:52 to 05-03-2021 01:28:56.

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 1570899 1570899 0 0.00 0 15308 6 0 0
doc_list_biud 1570898 1570898 0 0.00 0 24089 26 0 0
sp_add_invoice_to_stock 5206 5133 73 1.40 26 212412 19091 0 73
sp_cancel_adding_invoice 5720 5720 0 0.00 4 63799 734 0 0
sp_cancel_client_order 1810 1810 0 0.00 4 9124 354 0 0
sp_cancel_customer_reserve 561761 561761 0 0.00 1 24091 57 0 0
sp_cancel_pay_from_customer 734 734 0 0.00 3 9383 96 0 0
sp_cancel_pay_to_supplier 431 431 0 0.00 3 13461 125 0 0
sp_cancel_supplier_invoice 6408 6404 4 0.06 1 16883 758 0 4
sp_cancel_supplier_order 437 437 0 0.00 7 1064942 91771 0 0
sp_cancel_write_off 10480 10480 0 0.00 1 12083 107 0 0
sp_client_order 21117 21117 0 0.00 3 17592 360 0 0
sp_customer_reserve 477708 477708 0 0.00 0 142934 188 0 0
sp_fill_shopping_cart 32322 32322 0 0.00 1 10480 38 0 0
sp_fill_shopping_cart_clo_res 477695 477695 0 0.00 0 14952 13 0 0
sp_get_clo_for_invoice 5120 5120 0 0.00 0 24050 275 0 0
sp_kill_cost_storno 17365 17365 0 0.00 0 6549 53 0 0
sp_kill_qstorno_ret_qs2qd 1140843 1140843 0 0.00 0 24063 31 0 0
sp_kill_qty_storno 602091 602091 0 0.00 0 24089 66 0 0
sp_lock_selected_doc 21474 21474 0 0.00 0 9485 7 0 0
sp_make_cost_storno 28820 28820 0 0.00 0 14129 48 0 0
sp_multiply_rows_for_pdistr 28820 28820 0 0.00 0 8181 29 0 0
sp_multiply_rows_for_qdistr 21117 21117 0 0.00 0 13275 152 0 0
sp_pay_from_customer 7361 7361 0 0.00 4 19613 122 0 0
sp_pay_to_supplier 5980 5980 0 0.00 4 14148 124 0 0
sp_payment_common 13341 13341 0 0.00 1 19596 30 0 0
sp_qd_handle_on_cancel_clo 1810 1810 0 0.00 0 6367 316 0 0
sp_qd_handle_on_invoice_upd_sts 10838 10838 0 0.00 0 13999 296 0 0
sp_qd_handle_on_reserve_upd_sts 10361 10361 0 0.00 0 19961 65 0 0
sp_reserve_write_off 10361 10361 0 0.00 6 19972 188 0 0
sp_supplier_invoice 5551 5551 0 0.00 6 105521 3409 0 0
sp_supplier_order 5659 5659 0 0.00 6 41543 1432 0 0
srv_aggregate_perf_data 90 90 0 0.00 2606 470117 24982 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 1192 173632 31552 0 0
srv_find_qd_qs_mism 1079244 1079244 0 0.00 0 15308 6 0 0
srv_make_invnt_saldo 541 541 0 0.00 45 44233 1120 0 0
srv_make_money_saldo 789 789 0 0.00 0 9545 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 151154 282615 202316 0 0
t$perf-abend:sp_add_invoice_to_stock 73 73 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5133 5133 0 0.00 0 11976 177 0 0
t$perf-norm:sp_cancel_adding_invoice 422 422 0 0.00 0 9559 96 0 0
t$perf-norm:sp_cancel_client_order 1810 1810 0 0.00 0 1879 11 0 0
t$perf-norm:sp_cancel_customer_reserve 668 668 0 0.00 0 4168 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 734 734 0 0.00 0 7223 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 431 431 0 0.00 0 268 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 422 422 0 0.00 0 515 12 0 0
t$perf-norm:sp_cancel_supplier_order 437 437 0 0.00 0 18826 1567 0 0
t$perf-norm:sp_cancel_write_off 1071 1071 0 0.00 0 3265 10 0 0
t$perf-norm:sp_client_order 21117 21117 0 0.00 0 14335 23 0 0
t$perf-norm:sp_customer_reserve 1011 1011 0 0.00 0 6270 15 0 0
t$perf-norm:sp_pay_from_customer 7361 7361 0 0.00 0 11338 12 0 0
t$perf-norm:sp_pay_to_supplier 5980 5980 0 0.00 0 4211 10 0 0
t$perf-norm:sp_reserve_write_off 10361 10361 0 0.00 0 14664 15 0 0
t$perf-norm:sp_supplier_invoice 5551 5551 0 0.00 0 11215 24 0 0
t$perf-norm:sp_supplier_order 5659 5659 0 0.00 0 9101 15 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 103 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 2495 18 0 0
t$perf-norm:srv_make_invnt_saldo 541 541 0 0.00 0 1778 29 0 0
t$perf-norm:srv_make_money_saldo 789 789 0 0.00 0 4406 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 130 40 0 0
v_add_invoice_to_stock 10382 10236 146 1.40 0 8757 21 0 146
v_all_customers 38578 38578 0 0.00 0 15 1 0 0
v_all_suppliers 31172 31172 0 0.00 0 21 1 0 0
v_all_wares 42234 42234 0 0.00 0 28 1 0 0
v_cancel_adding_invoice 844 844 0 0.00 0 1099 8 0 0
v_cancel_client_order 3620 3620 0 0.00 0 4600 8 0 0
v_cancel_customer_prepayment 1468 1468 0 0.00 0 2687 10 0 0
v_cancel_customer_reserve 1336 1336 0 0.00 0 16011 18 0 0
v_cancel_payment_to_supplier 862 862 0 0.00 0 4579 17 0 0
v_cancel_supplier_invoice 852 844 8 0.93 0 3547 27 0 8
v_cancel_supplier_order 874 874 0 0.00 0 8753 27 0 0
v_cancel_write_off 2142 2142 0 0.00 0 5427 20 0 0
v_max_id_clo_ord 5658 5658 0 0.00 0 856 1 0 0
v_max_id_clo_res 1011 1011 0 0.00 0 1434 12 0 0
v_max_id_ord_sup 5547 5547 0 0.00 0 10314 8 0 0
v_max_non_paid_invoice 1599 1599 0 0.00 0 2444 4 0 0
v_max_non_paid_realizn 3940 3940 0 0.00 0 9288 8 0 0
v_min_id_clo_ord 5658 5658 0 0.00 0 3629 9 0 0
v_min_id_clo_res 1011 1011 0 0.00 0 8104 27 0 0
v_min_id_ord_sup 5547 5547 0 0.00 0 5995 7 0 0
v_min_non_paid_invoice 5980 5980 0 0.00 0 5448 12 0 0
v_min_non_paid_realizn 7361 7361 0 0.00 0 19592 20 0 0
v_our_firm 10498 10498 0 0.00 0 13 1 0 0
v_reserve_write_off 20722 20722 0 0.00 0 17353 10 0 0
x_lock_depdocs_on_canc_invoice 11702 11702 0 0.00 0 15667 99 0 0
x_lock_depdocs_on_canc_sup_ord 437 437 0 0.00 0 22732 418 0 0
x_make_qstorno_1000_1200 5659 5659 0 0.00 2 41535 1347 0 0
x_make_qstorno_1200_2000 5551 5551 0 0.00 3 104452 3278 0 0
x_make_qstorno_2100_3300 477708 477708 0 0.00 0 142931 172 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 05-03-2021 01:28:56 to 05-03-2021 01:29:01.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:21 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:27 23525 8192000000 10259528112 10568208384 1026943520 11.139 81 58 119 0 1049904560 2987040 19974000
22:57:59 30878 8192000000 10333469680 10648576000 1381952368 14.434 100 87 174 0 1415605392 4827952 28825072
22:58:44 26845 8192000000 10365656512 10685636608 1415333104 14.731 100 83 166 0 1449335760 6098448 27904208
22:59:27 13635 8192000000 10391865760 10714021888 1444257728 14.987 100 92 184 0 1481049040 6880768 29910544
22:59:51 26215 8192000000 10404877888 10733400064 1457519856 15.104 100 82 164 0 1491748480 7496672 26731952
23:00:34 14558 8192000000 10422504096 10756800512 1476448768 15.270 100 80 160 0 1510083248 7669328 25965152
23:00:59 18648 8192000000 10460112624 10795667456 1507413152 15.541 100 83 166 0 1541390688 8084320 25893216
23:01:30 21132 8192000000 10479355008 10826698752 1538312352 15.809 100 80 160 0 1572441920 9377712 24751856
23:02:12 13205 8192000000 10518953760 10871169024 1574220464 16.119 100 76 152 0 1606598480 9304528 23073488
23:02:35 17123 8192000000 10553445248 10913914880 1613487200 16.454 100 78 156 0 1646967984 10008176 23472608
23:03:01 17572 8192000000 10582521440 10944184320 1642615392 16.702 100 72 144 1 1674441488 10652368 21173728
23:03:29 14900 8192000000 10614560512 10979631104 1664490048 16.887 100 78 157 1 1698765216 10938496 23336672
23:03:51 15042 8192000000 10631278016 11001683968 1682195792 17.036 100 73 146 1 1714932496 11273632 21463072
23:04:15 10036 8192000000 10646475472 11018887168 1706492640 17.239 100 75 150 0 1738909312 10631856 21784816
23:04:33 8871 8192000000 10657935936 11034320896 1723030624 17.377 100 75 150 1 1755564144 11473120 21060400
23:04:50 7917 8192000000 10665931568 11044278272 1734457616 17.473 100 75 151 1 1768897312 12133616 22306080
23:05:06 8851 8192000000 10696668576 11070529536 1746934448 17.576 100 75 150 2 1780247024 11786704 21525872
23:05:28 4186 8192000000 10707334320 11081261056 1763143312 17.710 100 84 165 3 1798788080 12499728 23145040
23:05:41 8319 8192000000 10713368688 11094204416 1772685216 17.789 100 77 154 2 1807228400 12546704 21996480
23:05:57 5935 8192000000 10719251296 11098337280 1782380464 17.869 100 86 172 1 1820177280 13832544 23964272
23:06:12 4909 8192000000 10732260800 11108573184 1788755888 17.922 100 87 174 1 1828061120 15111888 24193344
23:06:24 5566 8192000000 10731335776 11115298816 1795454208 17.977 100 78 153 1 1830223904 14267424 20502272
23:06:36 3577 8192000000 10737784192 11122311168 1798084672 17.998 100 83 162 2 1834800496 13692352 23023472
23:06:48 7299 8192000000 10745028912 11125563392 1803036080 18.039 100 90 180 0 1842584576 14317488 25231008
23:07:03 5815 8192000000 10749880880 11129921536 1805627232 18.060 100 77 154 2 1840499152 13561184 21310736
23:07:15 3041 8192000000 10757896544 11144364032 1818252864 18.163 100 79 157 0 1853319600 13201008 21865728
23:07:25 2325 8192000000 10767706384 11152007168 1827184016 18.236 100 90 178 1 1866043600 13564512 25295072
23:07:33 2983 8192000000 10775549120 11159908352 1829709136 18.257 100 85 170 0 1867178512 13077984 24391392
23:07:43 2790 8192000000 10776745040 11164852224 1835568640 18.305 100 84 168 2 1872386624 12976096 23841888
23:07:53 1900 8192000000 10790532096 11174842368 1842242800 18.359 100 95 191 1 1886783088 17931760 26608528
23:08:01 2365 8192000000 10789652080 11173888000 1844657280 18.379 100 80 160 1 1879711840 12643408 22411152
23:08:10 1506 8192000000 10799462752 11182444544 1851883488 18.437 100 89 178 1 1889668896 12998144 24787264
23:08:18 1965 8192000000 10796627568 11183648768 1855340896 18.465 100 88 175 1 1892350208 12041488 24967824
23:08:26 2769 8192000000 10804992416 11191996416 1859621088 18.500 100 93 186 1 1897982416 12225136 26136192
23:08:35 1158 8192000000 10807763856 11196456960 1865087456 18.545 100 91 182 0 1904481440 14078736 25315248
23:08:42 1246 8192000000 10811643792 11197763584 1866556064 18.556 100 92 184 3 1907312320 15144560 25611696
23:08:50 1447 8192000000 10816435056 11204243456 1867014848 18.560 100 92 184 0 1908336704 15900480 25421376
23:08:58 1425 8192000000 10819121808 11206283264 1872762352 18.607 100 93 186 1 1911950688 13979296 25209040
23:09:06 1577 8192000000 10819251536 11205824512 1872696096 18.606 100 91 181 1 1912277568 14256128 25325344
23:09:14 2092 8192000000 10819288336 11207106560 1874078304 18.617 100 96 196 2 1913932864 13253536 26601024
23:09:24 7937 8192000000 10816613216 11205664768 1870666448 18.590 100 78 155 2 1904241808 12686640 20888720
23:09:39 1217 8192000000 10818070400 11211788288 1883112096 18.690 100 89 179 2 1920151664 12154208 24885360
23:09:51 20323 8192000000 10770242800 11200065536 1870622416 18.589 100 28 55 1 1884216752 6329360 7264976
23:10:17 9101 8192000000 10780374608 11203256320 1873355664 18.611 100 28 56 0 1887050064 6090672 7603728
23:10:37 9490 8192000000 10784529024 11212451840 1875133936 18.626 100 28 55 2 1892899152 10717936 7047280
23:10:54 9202 8192000000 10782121664 11210854400 1877398928 18.644 100 26 52 1 1891737808 7224368 7114512
23:11:11 12762 8192000000 10782443088 11214614528 1878076352 18.650 100 15 30 0 1888417472 6189008 4152112
23:11:32 8490 8192000000 10788029296 11218374656 1884013392 18.698 100 19 39 1 1895031840 5592016 5426432
23:11:49 17692 8192000000 10785669792 11222822912 1884998416 18.705 100 16 31 2 1895027952 5361088 4668448
23:12:14 10259 8192000000 10786385808 11219652608 1885127184 18.706 100 16 32 2 1895130128 5107712 4895232
23:12:30 15983 8192000000 10787741328 11225939968 1885834288 18.712 100 11 22 0 1894700720 5638816 3227616
23:12:53 8018 8192000000 10795252096 11227492352 1891854480 18.761 100 17 33 1 1902154768 5639936 4660352
23:13:08 13305 8192000000 10789158032 11231358976 1892250800 18.764 100 10 20 1 1901264576 6378816 2634960
23:13:30 77573 8192000000 10833529360 11247091712 1897211584 18.804 100 38 76 1 1914091152 5531056 11348512
23:14:54 7040 8192000000 10827511248 11255738368 1902026384 18.843 100 37 74 1 1921505840 9056736 10422720
23:15:08 6659 8192000000 10837395568 11258871808 1903486848 18.854 100 39 76 4 1921816208 7398560 10930800
23:15:26 4646 8192000000 10838621808 11265449984 1911507744 18.919 100 55 110 0 1933700784 7124672 15068368
23:15:39 3451 8192000000 10847845088 11272175616 1913051376 18.931 100 44 86 2 1937900736 12988384 11860976
23:15:49 4553 8192000000 10833538128 11264757760 1912763520 18.929 100 34 67 1 1927407072 5391232 9252320
23:16:03 5002 8192000000 10826085008 11261923328 1912612592 18.928 100 31 62 1 1928361536 6907904 8841040
23:16:19 6462 8192000000 10838705184 11265392640 1914659760 18.944 100 30 58 2 1927849312 5041184 8148368
23:16:33 9563 8192000000 10825250912 11259191296 1894278640 18.780 99 18 36 1 1904698256 5165712 5253904
23:16:48 6833 8192000000 10809162656 11247558656 1888019840 18.730 99 21 41 3 1899577904 5752816 5805248
23:17:04 47696 8192000000 10827007888 11261358080 1892608640 18.767 99 40 80 2 1915389504 11361920 11418944
23:18:02 9438 8192000000 10809979776 11241017344 1862306496 18.522 98 17 32 1 1872730960 5634464 4790000
23:18:18 9716 8192000000 10786535136 11210702848 1802139904 18.031 95 27 54 2 1815611760 5196096 8275760
23:18:34 4683 8192000000 10764193504 11195342848 1841601264 18.354 99 25 49 2 1855361648 6381840 7378544
23:18:44 7083 8192000000 10761571792 11183538176 1800347568 18.017 97 23 46 2 1813126672 5801152 6977952
23:18:59 4542 8192000000 10750532656 11168899072 1801361088 18.025 98 36 72 1 1819419472 7225776 10832608
23:19:10 7373 8192000000 10750648432 11163385856 1785322960 17.893 97 27 53 2 1798499424 4963856 8212608
23:19:25 9041 8192000000 10731666224 11154657280 1777833360 17.832 97 25 50 0 1790601056 6051488 6716208
23:19:41 6251 8192000000 10731468640 11145936896 1797370288 17.992 99 31 62 1 1815900736 9781104 8749344
23:19:53 10030 8192000000 10727216624 11147104256 1732836752 17.459 95 26 52 0 1745953600 5927552 7189296
23:20:12 8950 8192000000 10724438768 11129819136 1733376112 17.464 95 32 63 0 1747403776 5849280 8178384
23:20:28 6508 8192000000 10677920288 11091976192 1699854544 17.184 94 21 42 0 1712861648 6783024 6224080
23:20:41 6616 8192000000 10686286288 11101310976 1744449712 17.556 98 27 54 1 1757901440 5595152 7856576
23:20:54 9032 8192000000 10705435664 11119259648 1744365808 17.555 97 18 35 1 1754069664 5091376 4612480
23:21:10 58194 8192000000 10710650928 11108917248 1681615248 17.031 94 30 59 0 1695771184 4904704 9251232
23:22:14 12257 8192000000 10697995296 11121008640 1778225088 17.835 99 21 42 0 1789800336 5153648 6421600
23:22:37 6205 8192000000 10711117072 11131510784 1758013888 17.668 97 36 72 1 1775188688 6448112 10726688
23:22:50 4882 8192000000 10720411168 11138367488 1785941456 17.898 99 30 61 0 1800502896 6117504 8443936
23:23:05 6257 8192000000 10746711472 11158867968 1817716912 18.159 100 37 75 1 1835072960 6374192 10981856
23:23:21 8757 8192000000 10732395520 11153039360 1792033280 17.948 98 28 56 2 1806794912 6578560 8183072
23:23:36 9799 8192000000 10736919968 11155390464 1801440576 18.026 99 21 42 1 1813727280 5914848 6371856
23:23:58 5754 8192000000 10762534816 11181162496 1837957664 18.324 100 28 56 1 1851525072 5526384 8041024
23:24:13 7703 8192000000 10771589024 11188482048 1843239344 18.367 100 29 58 0 1857737616 6833968 7664304
23:24:28 8879 8192000000 10762409312 11186843648 1844335600 18.376 100 23 46 1 1857996672 5629984 8031088
23:24:49 9581 8192000000 10751554736 11185664000 1849001488 18.414 100 28 57 1 1863187488 5679824 8506176
23:25:05 5313 8192000000 10766670912 11194150912 1856215856 18.473 100 26 53 2 1869952480 5809440 7927184
23:25:19 10583 8192000000 10781155872 11205181440 1861645472 18.517 100 20 40 0 1873070688 5907792 5517424
23:25:39 5834 8192000000 10783667888 11212070912 1865192592 18.545 100 18 35 1 1875149392 4837360 5119440
23:25:51 8757 8192000000 10781372224 11216519168 1869946704 18.584 100 20 39 0 1880966176 5789552 5229920
23:26:08 11209 8192000000 10795610112 11224219648 1876532848 18.637 100 33 66 0 1891452976 6310128 8610000
23:26:32 70913 8192000000 10831750448 11250122752 1893554352 18.774 100 44 88 1 1912552272 6298064 12699856
23:27:56 6292 8192000000 10845828752 11264606208 1913169696 18.932 100 59 118 1 1937597552 8624128 15803728
23:28:09 17187 8192000000 10852276448 11271995392 1917340640 18.966 100 53 106 0 1942717952 10642816 14734496
23:28:34 11383 8192000000 10868490976 11281301504 1923034288 19.011 100 60 117 1 1949763984 11275168 15454528
23:28:54 5655 8192000000 10862953728 11283615744 1924424960 19.022 100 58 116 1 1951531136 11277296 15828880
23:29:08 13563 8192000000 10861994352 11287396352 1929239200 19.061 100 62 124 0 1958951104 12158864 17553040
23:29:29 9534 8192000000 10860693696 11284070400 1929894576 19.066 100 55 110 4 1956705328 11267808 15542944
23:29:54 54304 8192000000 10854693808 11300253696 1935869280 19.114 100 36 72 2 1957468528 11390272 10208976
23:30:57 13851 8192000000 10866599376 11307278336 1943523968 19.175 100 38 73 1 1964146128 9405248 11216912
23:31:18 19786 8192000000 10877890736 11315970048 1952820336 19.249 100 43 86 4 1974496352 8242352 13433664
23:31:46 18818 8192000000 10896721616 11326562304 1957852816 19.289 100 51 102 2 1983373280 11007712 14512752
23:32:12 16958 8192000000 10894339712 11336142848 1961584480 19.319 100 48 96 3 1989678512 14266608 13827424
23:32:37 18422 8192000000 10895855616 11337814016 1968213232 19.371 100 56 112 0 1996643088 11873696 16556160
23:33:06 33601 8192000000 10909362288 11350630400 1974846640 19.424 100 52 104 4 2003435024 13487856 15100528
23:33:48 9669 8192000000 10912225184 11351810048 1978437392 19.452 100 45 89 2 2006579408 14767776 13374240
23:34:06 11540 8192000000 10921364720 11356725248 1984724352 19.502 100 48 95 2 2014500416 15510160 14265904
23:34:35 14378 8192000000 10939636032 11370156032 1992901280 19.567 100 65 129 1 2029910368 17545248 19463840
23:34:59 4412 8192000000 10946783456 11375071232 1994746320 19.581 100 61 119 0 2031501232 18817696 17937216
23:35:10 1831 8192000000 10971076560 11385532416 2000648880 19.628 100 78 155 1 2042616480 19354576 22613024
23:35:21 12794 8192000000 10953501072 11383205888 2002308912 19.641 100 69 138 0 2043644320 21016064 20319344
23:35:51 20897 8192000000 10951827696 11391234048 2003389888 19.649 100 57 115 1 2041238560 21122448 16726224
23:36:20 6025 8192000000 10958731360 11390468096 2002386144 19.642 100 66 132 0 2045447344 22731776 20329424
23:36:34 11282 8192000000 10947187168 11386556416 2006549408 19.674 100 59 116 1 2045648144 22399648 16699088
23:36:54 5968 8192000000 10949257696 11383832576 1998599456 19.612 100 60 119 1 2038592608 22457760 17535392
23:37:09 10428 8192000000 10963812720 11394027520 2005154240 19.663 100 71 141 3 2050763072 24618928 20989904
23:37:30 7657 8192000000 10959614032 11400851456 2006503424 19.674 100 49 98 0 2049017136 27156480 15357232
23:37:45 4108 8192000000 10972549104 11405062144 2012519616 19.721 100 58 116 3 2058234576 27888784 17826176
23:37:59 2076 8192000000 10992593344 11415597056 2019587808 19.777 100 80 160 2 2072169120 28319472 24261840
23:38:08 4812 8192000000 10990306912 11417833472 2019543616 19.777 100 73 143 2 2070081552 28894752 21643184
23:38:21 4826 8192000000 10985729664 11417407488 2020494912 19.784 100 56 112 1 2067727344 30278464 16953968
23:38:33 2721 8192000000 10995794448 11425234944 2026206336 19.829 100 83 166 2 2081023792 30650576 24166880
23:38:43 5494 8192000000 10989030864 11422797824 2023749216 19.810 100 73 145 1 2075167984 30033600 21385168
23:38:57 4922 8192000000 10992997424 11421667328 2022880976 19.803 100 69 138 2 2073970576 30603552 20486048
23:39:08 2653 8192000000 10995269328 11416117248 2001160576 19.632 99 82 162 0 2055715808 30127760 24427472
23:39:26 2857 8192000000 10979155664 11409903616 2009041648 19.694 100 72 143 0 2062001280 31358160 21601472
23:39:39 7799 8192000000 10968832208 11409448960 2010144992 19.703 100 58 116 0 2058777792 30940352 17692448
23:40:00 5645 8192000000 10957674704 11388502016 1984392512 19.499 99 52 104 4 2033176032 32584880 16198640
23:40:13 11602 8192000000 10950283424 11400929280 2002963952 19.646 100 47 92 1 2046000672 28820192 14216528
23:40:34 3248 8192000000 10957648944 11395035136 2000693984 19.628 100 51 102 2 2041241024 25016912 15530128
23:40:51 2886 8192000000 10959528880 11389992960 1985974752 19.512 99 71 143 2 2033000784 25592304 21433728
23:41:01 6248 8192000000 10966806336 11400581120 2001968736 19.638 100 71 140 1 2049956768 27306288 20681744
23:41:16 11487 8192000000 10956666416 11388157952 1981628944 19.478 99 63 126 2 2027735744 27576672 18530128
23:41:39 4185 8192000000 10967420352 11394846720 1996979760 19.599 100 78 153 2 2053624896 32895456 23749680
23:42:03 4316 8192000000 10954302208 11383787520 1990757968 19.550 100 65 128 0 2038105856 28735392 18612496
23:42:14 5343 8192000000 10955494320 11378282496 1984207472 19.498 100 79 158 2 2037228352 29181280 23839600
23:42:28 4904 8192000000 10933901232 11364483072 1957590944 19.287 99 53 106 2 2001346048 28071344 15683760
23:42:41 2095 8192000000 10952165888 11371266048 1975473600 19.429 99 75 148 1 2025987472 27989824 22524048
23:42:51 2133 8192000000 10961440864 11378237440 1976186048 19.434 99 80 160 1 2029353584 29203168 23964368
23:43:02 5391 8192000000 10934233088 11355766784 1929186960 19.060 97 71 140 0 1982010256 31098160 21725136
23:43:13 3090 8192000000 10951797840 11372105728 1976282192 19.435 100 77 154 1 2033667312 33862160 23522960
23:43:24 11599 8192000000 10918678656 11361353728 1951212576 19.236 99 48 95 1 1997419408 31170592 15036240
23:43:42 4502 8192000000 10916368432 11356315648 1965807008 19.352 100 50 99 1 2011273584 30089904 15376672
23:43:57 3007 8192000000 10931674496 11359567872 1952467040 19.246 99 56 111 2 1998540192 28770480 17302672
23:44:13 4084 8192000000 10912927472 11331153920 1939477952 19.143 99 57 114 1 1988903184 31152640 18272592
23:44:29 5127 8192000000 10921188352 11348307968 1952870864 19.249 100 66 130 1 2005063920 32632928 19560128
23:44:42 4870 8192000000 10941325264 11356303360 1960664192 19.311 100 83 164 3 2021086880 35296000 25126688
23:44:55 5060 8192000000 10943850480 11368996864 1967141472 19.363 100 55 110 2 2018295264 34283552 16870240
23:45:07 3927 8192000000 10945397232 11367297024 1969757312 19.384 100 79 158 1 2029605360 34566752 25281296
23:45:20 10750 8192000000 10920677840 11359113216 1964990752 19.346 100 46 92 0 2007747616 28347824 14409040
23:45:38 5450 8192000000 10932330304 11361181696 1950287696 19.229 99 51 101 2 1995495648 29350608 15857344
23:45:52 2560 8192000000 10945432912 11352674304 1960649008 19.311 99 84 168 1 2017964208 30017136 27298064
23:46:02 1793 8192000000 10927251984 11343511552 1933754736 19.097 99 88 176 1 1994762896 32953824 28054336
23:46:10 4278 8192000000 10899191088 11321626624 1934295008 19.101 100 67 132 2 1983523168 29457920 19770240
23:46:21 6508 8192000000 10882064032 11301019648 1915888256 18.954 99 58 114 1 1963114624 29341248 17885120
23:46:35 12432 8192000000 10876523920 11310022656 1896582976 18.799 98 52 102 1 1941249824 29225152 15441696
23:47:03 2249 8192000000 10904463952 11319988224 1924581200 19.024 99 73 144 3 1975316368 28621584 22113584
23:47:12 3875 8192000000 10909847440 11332608000 1941920352 19.162 100 55 110 0 1988141056 29145888 17074816
23:47:23 2962 8192000000 10910588448 11326468096 1926214384 19.037 99 64 126 0 1975381200 30281264 18885552
23:47:34 20311 8192000000 10900546272 11335004160 1940681552 19.152 100 37 73 1 1982799952 30038048 12080352
23:48:10 8959 8192000000 10899391888 11344543744 1947577216 19.207 100 47 94 1 1996073664 33383136 15113312
23:48:26 18831 8192000000 10911304128 11349929984 1949965376 19.226 100 33 66 0 1992049776 31323280 10761120
23:48:53 7939 8192000000 10915432624 11343777792 1950126544 19.227 100 46 88 3 1992910480 28341760 14442176
23:49:09 5864 8192000000 10912599088 11333529600 1929533440 19.063 99 50 99 1 1974776576 29660208 15582928
23:49:28 7952 8192000000 10910981040 11341938688 1935147520 19.108 99 41 82 1 1978551856 30184656 13219680
23:49:46 9073 8192000000 10903982736 11334651904 1929166848 19.060 99 51 101 0 1976975616 31548064 16260704
23:50:05 8800 8192000000 10891242480 11313209344 1905715328 18.872 98 47 94 1 1954584512 33775312 15093872
23:50:20 10050 8192000000 10902979264 11335827456 1937696576 19.128 100 39 77 1 1987031952 36309872 13025504
23:50:37 13565 8192000000 10915621200 11353411584 1951239632 19.236 100 35 70 1 2002966944 39303088 12424224
23:51:01 13175 8192000000 10933973392 11367342080 1967633744 19.367 100 52 102 2 2028932208 44758384 16540080
23:51:21 23079 8192000000 10918542592 11355500544 1920885536 18.994 98 39 77 2 1970765248 36222336 13657376
23:51:54 9111 8192000000 10946940384 11373510656 1962012416 19.322 100 52 104 0 2023586608 44086816 17487376
23:52:22 1605 8192000000 10980084736 11396718592 1986181344 19.514 100 86 168 3 2061798448 48412192 27204912
23:52:31 1191 8192000000 10997135040 11406225408 1989266960 19.538 100 87 174 2 2068614512 51617984 27729568
23:52:38 5225 8192000000 10986761360 11410395136 1992677920 19.565 100 68 136 1 2067151552 52426224 22047408
23:52:54 18831 8192000000 10957014944 11404214272 1978594192 19.454 100 43 85 1 2040446896 47663392 14189312
23:53:31 15170 8192000000 10927062560 11371659264 1942198992 19.164 98 39 78 0 1997093200 41654768 13239440
23:54:23 20335 8192000000 10928210256 11378208768 1967937120 19.369 100 30 60 2 2010233648 32571392 9725136
23:54:52 18949 8192000000 10933461312 11379699712 1973785424 19.415 100 46 92 5 2022444832 33293376 15366032
23:55:26 28430 8192000000 10921275968 11375095808 1942483408 19.167 99 23 45 2 1984187328 33315872 8388048
23:56:10 17833 8192000000 10918330832 11380477952 1954079584 19.259 100 22 44 1 2003052368 40427632 8545152
23:56:43 6537 8192000000 10916102624 11381047296 1946248048 19.197 100 18 36 0 1998282432 45645184 6389200
23:57:16 38066 8192000000 10910902928 11380334592 1955109152 19.267 100 8 16 0 1985298832 27781440 2408240
23:58:01 38508 8192000000 10911121008 11374759936 1971678528 19.399 100 15 30 0 1998323488 21891264 4753696
23:58:51 101974 8192000000 10889736048 11324481536 1848431936 18.409 94 10 20 1 1860775856 10088560 2255360
00:00:40 20578 8192000000 10906805712 11341029376 1960161728 19.307 100 36 70 4 1980080272 8768864 11149680
00:01:10 36766 8192000000 10887534864 11334774784 1913435936 18.934 97 25 50 1 1932545664 12067808 7041920
00:02:01 125528 8192000000 10879641936 11344613376 1898236896 18.812 97 21 41 2 1923669664 18942656 6490112
00:04:13 61816 8192000000 10866752464 11297832960 1888023584 18.730 97 44 86 2 1909434800 8783072 12628144
00:05:25 76609 8192000000 10883768624 11351183360 1947611504 19.207 100 36 72 1 1970612224 12925344 10075376
00:06:50 59112 8192000000 10898719536 11338403840 1921028560 18.995 98 26 52 1 1941644352 13229584 7386208
00:07:57 18192 8192000000 10914662800 11352981504 1960410352 19.309 100 51 102 1 1986012704 9426912 16175440
00:08:22 173630 8192000000 10890023440 11348414464 1871829984 18.599 95 26 51 3 1892542448 13028224 7684240
00:11:23 36808 8192000000 10903054064 11365257216 1977814960 19.447 100 34 68 4 1996826784 9188016 9823808
00:12:37 48304 8192000000 10916381824 11392823296 1984710288 19.502 100 23 42 0 2006124864 15422800 5991776
00:13:33 44141 8192000000 10922854320 11392151552 1987762032 19.526 100 14 29 2 2008580992 16615184 4203776
00:14:43 110499 8192000000 10910456896 11386408960 1985431072 19.508 100 5 10 0 2000219280 13410624 1377584
00:16:40 34926 8192000000 10906085520 11376357376 1966297312 19.356 99 25 47 2 1985574624 12634976 6642336
00:17:27 30590 8192000000 10901080192 11376463872 1980459392 19.468 100 13 26 1 1996747952 12469984 3818576
00:18:05 81796 8192000000 10910055840 11392958464 1981741312 19.478 100 17 34 0 2000146464 12982608 5422544
00:19:53 68067 8192000000 10924314176 11408162816 1992199424 19.561 100 20 41 1 2018793552 20867856 5726272
00:21:15 58683 8192000000 10914598192 11400822784 1968623232 19.375 99 10 20 1 1993950560 22223296 3104032
00:22:23 48068 8192000000 10914724688 11405623296 1989593248 19.541 100 13 26 0 2011815744 18309344 3913152
00:23:28 52978 8192000000 10893454032 11365359616 1894432352 18.781 95 17 34 0 1907016672 7908928 4675392
00:24:43 29726 8192000000 10932810192 11363651584 1925416064 19.030 97 41 83 0 1944303712 7709808 11177840
00:25:20 12498 8192000000 10908773984 11364720640 1956673904 19.280 99 44 87 2 1977974480 8967472 12333104
00:25:45 79599 8192000000 10874158240 11338428416 1889986800 18.746 96 29 58 1 1909661376 11761456 7913120
00:27:15 87778 8192000000 10928890624 11395760128 1954779472 19.265 99 22 44 1 1977780272 17095536 5905264
00:28:49 65730 8192000000 10877977888 11336355840 1888278880 18.732 95 13 26 0 1906762016 14612816 3870320
00:30:01 66742 8192000000 10876354880 11349483520 1890966272 18.754 96 15 30 1 1908117296 12608000 4543024
00:31:22 71183 8192000000 10870082976 11340607488 1827117728 18.236 93 9 18 0 1848361488 18334928 2908832
00:32:45 40031 8192000000 10847871600 11299893248 1802965936 18.038 93 26 52 3 1825734464 15355120 7413408
00:33:31 114048 8192000000 10870059424 11333738496 1794678400 17.970 94 8 16 0 1813947632 17227520 2041712
00:35:33 25324 8192000000 10889561376 11326697472 1883187808 18.691 97 49 99 1 1906357664 8156000 15013856
00:36:12 16268 8192000000 10862795472 11313078272 1890720640 18.752 98 39 78 1 1915699824 13685632 11293552
00:36:41 78909 8192000000 10861263376 11313582080 1912097504 18.923 99 34 69 1 1935568528 13613136 9857888
00:38:22 57122 8192000000 10821930336 11293151232 1844891040 18.381 96 21 42 0 1868688784 17930256 5867488
00:39:30 45639 8192000000 10808237552 11279491072 1880420320 18.669 99 14 27 3 1897125264 12625344 4079600
00:40:23 10386 8192000000 10829526112 11295875072 1888389168 18.733 99 23 46 1 1907374128 12200720 6784240
00:40:39 17523 8192000000 10839030704 11285389312 1889950080 18.745 99 41 82 1 1915506816 14279440 11277296
00:41:05 75432 8192000000 10825585056 11305103360 1875911376 18.632 98 13 26 0 1891946528 11956224 4078928
00:43:04 69891 8192000000 10847599120 11323494400 1863584608 18.532 97 10 20 0 1885188336 18964448 2639280
00:44:20 45747 8192000000 10871650512 11322105856 1905317952 18.869 99 12 24 0 1925078304 15963984 3796368
00:45:13 82446 8192000000 10860829824 11336871936 1927923232 19.050 100 14 28 1 1944475136 12434912 4116992
00:46:56 58039 8192000000 10860908496 11337596928 1930640448 19.072 100 8 16 0 1948240816 15267600 2332768
00:48:00 58936 8192000000 10871053280 11355193344 1940871728 19.154 100 14 28 1 1963194224 18546016 3776480
00:49:05 72840 8192000000 10870218832 11338997760 1924777136 19.025 99 10 19 1 1938803824 11566080 2460608
00:50:26 16822 8192000000 10889957424 11350147072 1956364576 19.277 100 45 90 0 1976831200 7348096 13118528
00:50:58 31218 8192000000 10867441664 11339726848 1912257280 18.925 98 28 56 3 1931471216 11465120 7748816
00:51:39 72098 8192000000 10888708928 11358789632 1946901584 19.202 100 20 40 3 1963415264 11053056 5460624
00:53:18 49303 8192000000 10885761968 11357093888 1938617840 19.136 99 13 26 0 1955886720 13622960 3645920
00:54:14 53120 8192000000 10917494352 11368423424 1942543472 19.167 99 34 68 0 1969932432 17129136 10259824
00:55:19 27644 8192000000 10901267824 11358896128 1940468080 19.150 99 52 104 2 1975607440 20924896 14214464
00:55:58 76647 8192000000 10874169344 11363160064 1894168528 18.779 97 16 32 0 1920266784 21739040 4359216
00:57:31 80459 8192000000 10871196192 11348312064 1842279168 18.359 94 16 32 2 1862055408 15767968 4008272
00:58:57 68161 8192000000 10906213808 11345752064 1922239968 19.005 99 10 20 1 1938940048 14202784 2497296
01:00:12 15952 8192000000 10896130016 11341922304 1921611040 19.000 98 49 98 0 1943998304 8242752 14144512
01:00:39 18724 8192000000 10907318768 11357773824 1962072416 19.323 100 51 102 1 1987310400 10833424 14404560
01:01:08 52482 8192000000 10895254000 11365883904 1941869120 19.162 99 30 60 1 1963019376 12767056 8383200
01:02:07 85923 8192000000 10884168304 11348811776 1923209440 19.013 98 21 42 0 1938920016 9829872 5880704
01:03:39 43222 8192000000 10889977136 11347562496 1941115504 19.156 99 34 68 0 1961158480 10088640 9954336
01:04:29 49472 8192000000 10872973648 11352842240 1941491984 19.159 99 15 30 0 1954805312 9123904 4189424
01:05:53 45905 8192000000 10879410176 11354079232 1958403152 19.293 100 6 12 0 1967272624 7350928 1518544
01:06:57 37136 8192000000 10870998240 11353903104 1939631776 19.144 99 10 20 0 1949754896 7413936 2709184
01:07:45 44537 8192000000 10889346928 11370291200 1952863968 19.249 99 14 27 1 1965709264 8678496 4166800
01:08:47 47757 8192000000 10897061872 11387121664 1976098560 19.434 100 19 38 0 1994648336 12853728 5696048
01:09:55 72061 8192000000 10909055376 11389247488 1972676944 19.407 100 13 26 1 1986244272 9683456 3883872
01:11:25 62977 8192000000 10924358336 11397443584 1971059472 19.394 99 29 56 2 1988281072 9418544 7803056
01:12:37 51187 8192000000 10917410976 11397648384 1985890656 19.511 100 18 35 1 2004312352 12471888 5949808
01:13:36 79004 8192000000 10864594816 11333607424 1747995472 17.585 88 18 36 0 1759830944 6838688 4996784
01:15:02 60981 8192000000 10878408864 11368136704 1949509520 19.223 100 20 40 2 1971370976 15196560 6664896
01:17:20 48562 8192000000 10883657136 11333345280 1805973760 18.063 92 21 42 0 1821434928 9515728 5945440
01:18:17 38683 8192000000 10880468208 11338907648 1880120304 18.666 97 40 80 1 1901760480 10998800 10641376
01:19:03 19715 8192000000 10885220784 11340697600 1900807792 18.833 98 45 90 3 1931694512 18915760 11970960
01:19:30 69230 8192000000 10870460448 11339448320 1908050480 18.891 98 28 55 1 1930502288 15052336 7399472
01:20:52 90369 8192000000 10854748912 11317293056 1787362016 17.910 92 25 50 0 1807560832 13681376 6517440
01:22:28 96179 8192000000 10864206944 11332132864 1901335776 18.837 99 26 52 0 1921012960 12107888 7569296
01:24:29 112005 8192000000 10863159072 11336724480 1897499440 18.806 98 20 40 1 1914770992 11419248 5852304
01:26:28 11588 8192000000 10855972320 11336630272 1929843936 19.066 100 12 24 0 1948103408 15013696 3245776
01:26:48 27737 8192000000 10864520272 11326636032 1895905472 18.793 98 27 54 0 1913887024 10255280 7726272

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 05-03-2021 01:29:02 to 05-03-2021 01:29:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 73 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-03-2021 01:29:35 to 05-03-2021 01:29:37.

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          238571
MON$OLDEST_ACTIVE               240159
MON$OLDEST_SNAPSHOT             240159
MON$NEXT_TRANSACTION            240159
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                       2035296
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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 ---
:36: 
:37: mscs-test-161.budzdorov.ru    Fri Mar  5 01:27:27 2021
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:39: 
:40: 
:41: mscs-test-161.budzdorov.ru    Fri Mar  5 01:27:27 2021
:42:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:43: 
--- end of diff output ---

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

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