Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 07.03.2021 22:29
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 17393816 kB
MemAvailable 31649160 kB
Buffers 0 kB
Cached 14314996 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-07 22:27:19
DTS_END                         2021-03-07 22:27:19.3050
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/53162
TRN_ID                          239703
ATT_ID                          663
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: 9429.01 24583 1131481
customer order: creation 168.79 346 20255
customer order: refuse 14.56 348 1747
order to supplier: creation 46.18 1270 5542
order to supplier: removal 3.46 108659 415
invoice (draft): creation 45.32 3356 5438
invoice (draft): removal 55.18 863 6622
invoice accept: apply 41.46 16930 4975
invoice accept: cancel 49.94 768 5993
customer reserve: creation 3848.48 166 461817
customer reserve: removal 4858.53 61 583024
realization accept: apply 82.59 177 9911
realization accept: cancel 85.15 103 10218
payment from customer: creation 58.56 113 7027
payment from customer: removal 5.65 87 678
payment to supplier: creation 49.55 127 5946
payment to supplier: removal 3.72 100 446
service: total inventory turnovers 4.67 1264 560
service: total monetary turnovers 6.31 70 757
service: aggregate perf. data 0.88 20976 106
service: refresh index statistics 0.03 335879 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-03-2021 22:29:31 to 07-03-2021 22:29:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6007
TEST_TIME 2 5725
TEST_TIME 3 5697
TEST_TIME 4 6200
TEST_TIME 5 5654
TEST_TIME 6 5439
TEST_TIME 7 5243
TEST_TIME 8 5691
TEST_TIME 9 5732
TEST_TIME 10 5885
TEST_TIME 11 6038
TEST_TIME 12 6131
TEST_TIME 13 6421
TEST_TIME 14 7017
TEST_TIME 15 7149
TEST_TIME 16 7255
TEST_TIME 17 7594
TEST_TIME 18 7629
TEST_TIME 19 7567
TEST_TIME 20 8165
TEST_TIME 21 8415
TEST_TIME 22 8519
TEST_TIME 23 8571
TEST_TIME 24 8600
TEST_TIME 25 8986
TEST_TIME 26 9746
TEST_TIME 27 11318
TEST_TIME 28 11225
TEST_TIME 29 11158
TEST_TIME 30 10960
TEST_TIME 31 10750
TEST_TIME 32 10839
TEST_TIME 33 10553
TEST_TIME 34 10564
TEST_TIME 35 10580
TEST_TIME 36 10483
TEST_TIME 37 10355
TEST_TIME 38 10288
TEST_TIME 39 10222
TEST_TIME 40 10247
TEST_TIME 41 10138
TEST_TIME 42 10364
TEST_TIME 43 10405
TEST_TIME 44 10256
TEST_TIME 45 10226
TEST_TIME 46 10098
TEST_TIME 47 10119
TEST_TIME 48 10102
TEST_TIME 49 9935
TEST_TIME 50 9837
TEST_TIME 51 9775
TEST_TIME 52 9736
TEST_TIME 53 9655
TEST_TIME 54 9693
TEST_TIME 55 9694
TEST_TIME 56 9639
TEST_TIME 57 9640
TEST_TIME 58 9629
TEST_TIME 59 9666
TEST_TIME 60 9697
TEST_TIME 61 9810
TEST_TIME 62 9804
TEST_TIME 63 9851
TEST_TIME 64 10072
TEST_TIME 65 10046
TEST_TIME 66 9999
TEST_TIME 67 10055
TEST_TIME 68 10054
TEST_TIME 69 9967
TEST_TIME 70 9843
TEST_TIME 71 9899
TEST_TIME 72 9866
TEST_TIME 73 9793
TEST_TIME 74 9791
TEST_TIME 75 9737
TEST_TIME 76 9685
TEST_TIME 77 9694
TEST_TIME 78 9627
TEST_TIME 79 9586
TEST_TIME 80 9552
TEST_TIME 81 9514
TEST_TIME 82 9525
TEST_TIME 83 9600
TEST_TIME 84 9644
TEST_TIME 85 9611
TEST_TIME 86 9685
TEST_TIME 87 9678
TEST_TIME 88 9629
TEST_TIME 89 9711
TEST_TIME 90 9759
TEST_TIME 91 9783
TEST_TIME 92 9777
TEST_TIME 93 9693
TEST_TIME 94 9610
TEST_TIME 95 9592
TEST_TIME 96 9577
TEST_TIME 97 9591
TEST_TIME 98 9602
TEST_TIME 99 9603
TEST_TIME 100 9579
TEST_TIME 101 9569
TEST_TIME 102 9583
TEST_TIME 103 9606
TEST_TIME 104 9577
TEST_TIME 105 9611
TEST_TIME 106 9652
TEST_TIME 107 9644
TEST_TIME 108 9685
TEST_TIME 109 9722
TEST_TIME 110 9751
TEST_TIME 111 9724
TEST_TIME 112 9645
TEST_TIME 113 9594
TEST_TIME 114 9563
TEST_TIME 115 9592
TEST_TIME 116 9567
TEST_TIME 117 9531
TEST_TIME 118 9495
TEST_TIME 119 9477
TEST_TIME 120 9433

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-03-2021 22:29:35 to 07-03-2021 22:29:38.

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 1557933 1557933 0 0.00 0 25168 6 0 0
doc_list_biud 1557933 1557933 0 0.00 0 34089 29 0 0
sp_add_invoice_to_stock 5137 4975 162 3.15 22 148519 16930 0 162
sp_cancel_adding_invoice 5993 5993 0 0.00 4 77694 769 0 0
sp_cancel_client_order 1747 1747 0 0.00 4 12375 349 0 0
sp_cancel_customer_reserve 583024 583024 0 0.00 1 34091 61 0 0
sp_cancel_pay_from_customer 678 678 0 0.00 2 6234 87 0 0
sp_cancel_pay_to_supplier 446 446 0 0.00 3 13253 101 0 0
sp_cancel_supplier_invoice 6632 6622 10 0.15 1 13009 863 0 10
sp_cancel_supplier_order 415 415 0 0.00 8 1113327 108659 0 0
sp_cancel_write_off 10218 10218 0 0.00 1 16043 104 0 0
sp_client_order 20255 20255 0 0.00 4 26942 347 0 0
sp_customer_reserve 461817 461817 0 0.00 0 96520 166 0 0
sp_fill_shopping_cart 31225 31225 0 0.00 1 21660 38 0 0
sp_fill_shopping_cart_clo_res 461806 461806 0 0.00 0 14300 14 0 0
sp_get_clo_for_invoice 4964 4964 0 0.00 0 20217 297 0 0
sp_kill_cost_storno 17335 17335 0 0.00 0 25157 53 0 0
sp_kill_qstorno_ret_qs2qd 1183303 1183303 0 0.00 0 34053 33 0 0
sp_kill_qty_storno 622894 622894 0 0.00 0 34088 71 0 0
sp_lock_selected_doc 20694 20694 0 0.00 0 9233 8 0 0
sp_make_cost_storno 27848 27848 0 0.00 0 24993 55 0 0
sp_multiply_rows_for_pdistr 27848 27848 0 0.00 0 5511 28 0 0
sp_multiply_rows_for_qdistr 20255 20255 0 0.00 0 25993 158 0 0
sp_pay_from_customer 7027 7027 0 0.00 4 16481 114 0 0
sp_pay_to_supplier 5946 5946 0 0.00 4 18934 128 0 0
sp_payment_common 12973 12973 0 0.00 2 16475 39 0 0
sp_qd_handle_on_cancel_clo 1747 1747 0 0.00 0 12370 325 0 0
sp_qd_handle_on_invoice_upd_sts 10957 10957 0 0.00 0 30073 317 0 0
sp_qd_handle_on_reserve_upd_sts 9911 9911 0 0.00 0 17572 50 0 0
sp_reserve_write_off 9911 9911 0 0.00 6 22985 178 0 0
sp_supplier_invoice 5438 5438 0 0.00 4 108161 3357 0 0
sp_supplier_order 5542 5542 0 0.00 5 32757 1271 0 0
srv_aggregate_perf_data 106 106 0 0.00 2811 609432 20976 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 1578 120310 32700 0 0
srv_find_qd_qs_mism 1083371 1083371 0 0.00 0 12822 5 0 0
srv_make_invnt_saldo 560 560 0 0.00 19 141467 1265 0 0
srv_make_money_saldo 757 757 0 0.00 1 24200 71 0 0
srv_recalc_idx_stat 4 4 0 0.00 75986 487471 335880 0 0
t$perf-abend:sp_add_invoice_to_stock 162 162 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4975 4975 0 0.00 0 10943 160 0 0
t$perf-norm:sp_cancel_adding_invoice 446 446 0 0.00 0 18750 134 0 0
t$perf-norm:sp_cancel_client_order 1747 1747 0 0.00 0 2163 12 0 0
t$perf-norm:sp_cancel_customer_reserve 673 673 0 0.00 0 2834 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 678 678 0 0.00 0 428 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 446 446 0 0.00 0 1264 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 415 415 0 0.00 0 938 15 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 20580 1726 0 0
t$perf-norm:sp_cancel_write_off 1001 1001 0 0.00 0 1409 5 0 0
t$perf-norm:sp_client_order 20255 20255 0 0.00 0 11798 17 0 0
t$perf-norm:sp_customer_reserve 1050 1050 0 0.00 0 620 4 0 0
t$perf-norm:sp_pay_from_customer 7027 7027 0 0.00 0 5394 8 0 0
t$perf-norm:sp_pay_to_supplier 5946 5946 0 0.00 0 13690 13 0 0
t$perf-norm:sp_reserve_write_off 9911 9911 0 0.00 0 12294 12 0 0
t$perf-norm:sp_supplier_invoice 5438 5438 0 0.00 0 10878 17 0 0
t$perf-norm:sp_supplier_order 5542 5542 0 0.00 0 9664 17 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 590 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 1659 13 0 0
t$perf-norm:srv_make_invnt_saldo 560 560 0 0.00 0 5193 31 0 0
t$perf-norm:srv_make_money_saldo 757 757 0 0.00 0 1140 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 4 0 0
v_add_invoice_to_stock 10248 9924 324 3.16 0 6902 18 0 324
v_all_customers 37348 37348 0 0.00 0 36 1 0 0
v_all_suppliers 30600 30600 0 0.00 0 17 1 0 0
v_all_wares 40510 40510 0 0.00 0 117 1 0 0
v_cancel_adding_invoice 892 892 0 0.00 0 254 5 0 0
v_cancel_client_order 3494 3494 0 0.00 0 1826 4 0 0
v_cancel_customer_prepayment 1356 1356 0 0.00 0 6222 9 0 0
v_cancel_customer_reserve 1346 1346 0 0.00 0 2335 4 0 0
v_cancel_payment_to_supplier 892 892 0 0.00 0 798 4 0 0
v_cancel_supplier_invoice 850 830 20 2.35 0 2049 19 0 20
v_cancel_supplier_order 830 830 0 0.00 0 7928 14 0 0
v_cancel_write_off 2002 2002 0 0.00 0 5807 15 0 0
v_max_id_clo_ord 5542 5542 0 0.00 0 1319 1 0 0
v_max_id_clo_res 1050 1050 0 0.00 0 8784 19 0 0
v_max_id_ord_sup 5428 5428 0 0.00 0 2700 3 0 0
v_max_non_paid_invoice 1616 1616 0 0.00 0 3917 6 0 0
v_max_non_paid_realizn 3606 3606 0 0.00 0 3526 4 0 0
v_min_id_clo_ord 5542 5542 0 0.00 0 1096 6 0 0
v_min_id_clo_res 1050 1050 0 0.00 0 3042 10 0 0
v_min_id_ord_sup 5428 5428 0 0.00 0 3393 5 0 0
v_min_non_paid_invoice 5946 5946 0 0.00 0 11336 26 0 0
v_min_non_paid_realizn 7027 7027 0 0.00 0 12415 24 0 0
v_our_firm 10004 10004 0 0.00 0 41 1 0 0
v_reserve_write_off 19822 19822 0 0.00 0 2707 3 0 0
x_lock_depdocs_on_canc_invoice 12200 12200 0 0.00 0 16314 105 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 17508 398 0 0
x_make_qstorno_1000_1200 5542 5542 0 0.00 2 32751 1189 0 0
x_make_qstorno_1200_2000 5438 5438 0 0.00 2 108147 3224 0 0
x_make_qstorno_2100_3300 461817 461817 0 0.00 0 96517 149 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-03-2021 22:29:39 to 07-03-2021 22:29:43.

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:23 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:29 19898 8192000000 10274064736 10577158144 902915888 9.927 71 56 111 0 924190880 2662384 18612608
19:57:56 15810 8192000000 10313341728 10626228224 1372542720 14.350 100 87 174 0 1406245728 4802416 28900592
19:58:29 28931 8192000000 10383102992 10703290368 1425684096 14.823 100 86 172 0 1460003376 6196304 28122976
19:59:17 23857 8192000000 10409693696 10738561024 1462772512 15.150 100 86 172 0 1498879920 7808976 28298432
19:59:53 17202 8192000000 10437314080 10767818752 1488428928 15.375 100 95 190 0 1527365184 8576304 30359952
20:00:24 20487 8192000000 10453818336 10786709504 1507509056 15.542 100 88 176 0 1545041056 9426352 28105648
20:00:58 16538 8192000000 10463648688 10801831936 1519800000 15.649 100 87 174 0 1557579136 10204496 27574640
20:01:32 14993 8192000000 10482157824 10828374016 1543719664 15.856 100 88 176 2 1581597472 10344320 27533488
20:01:57 17231 8192000000 10509157872 10857058304 1565951280 16.047 100 81 162 1 1601405184 10616736 24837168
20:02:23 20020 8192000000 10537924064 10894094336 1590099952 16.255 100 78 156 0 1624914976 11060192 23754832
20:02:55 10750 8192000000 10557336880 10917359616 1617925792 16.492 100 82 164 1 1654478912 11553888 24999232
20:03:13 12931 8192000000 10586768912 10947162112 1644359392 16.717 100 77 154 4 1679118800 12134608 22624800
20:03:35 9775 8192000000 10608859968 10971791360 1666817488 16.906 100 81 163 4 1704305952 13141936 24346528
20:03:58 8287 8192000000 10626888592 10995818496 1682806656 17.041 100 77 154 1 1718518816 13096192 22615968
20:04:16 9617 8192000000 10643477424 11014537216 1701712128 17.199 100 76 152 1 1736927504 13156528 22058848
20:04:33 7993 8192000000 10653297216 11030245376 1719602560 17.349 100 80 159 3 1755862896 13377904 22882432
20:04:52 6739 8192000000 10666968144 11047505920 1735911328 17.485 100 72 144 1 1768644096 11756064 20976704
20:05:05 4712 8192000000 10681040848 11056345088 1745987808 17.568 100 78 156 0 1780567104 12044432 22534864
20:05:18 4018 8192000000 10692880192 11072778240 1758615072 17.673 100 86 170 2 1796218176 12785824 24817280
20:05:29 4587 8192000000 10705678720 11084959744 1768646528 17.756 100 75 149 3 1802103200 12934272 20522400
20:05:40 2741 8192000000 10714632912 11097014272 1774340368 17.803 100 80 157 2 1808784432 12366496 22077568
20:05:49 10048 8192000000 10711288528 11099320320 1778203632 17.835 100 72 145 0 1811903984 13075984 20624368
20:06:07 3104 8192000000 10731371216 11118370816 1785508880 17.895 100 77 154 1 1820073616 12422720 22142016
20:06:17 3554 8192000000 10753836576 11136159744 1810144736 18.097 100 87 176 1 1848378096 12707568 25525792
20:06:28 3137 8192000000 10759490528 11144523776 1815846256 18.144 100 86 165 2 1851982064 12737424 23398384
20:06:38 3575 8192000000 10765755328 11151925248 1822762224 18.200 100 86 170 0 1859598560 12986864 23849472
20:06:48 2448 8192000000 10765155264 11155218432 1827217776 18.237 100 77 154 1 1861975584 13290096 21467712
20:06:57 2068 8192000000 10768317344 11159326720 1835033184 18.300 100 79 157 0 1869885136 13072608 21779344
20:07:06 2114 8192000000 10781247728 11170586624 1841535520 18.353 100 92 184 3 1881192976 13465040 26192416
20:07:14 1984 8192000000 10785730992 11171872768 1844189232 18.375 100 93 186 4 1884135136 13311536 26634368
20:07:22 1710 8192000000 10788366288 11176644608 1843694144 18.371 100 81 163 1 1880332112 13341440 23296528
20:07:30 2917 8192000000 10793088960 11181268992 1852166112 18.440 100 88 177 2 1890247552 11911808 26169632
20:07:40 2643 8192000000 10807590688 11194048512 1859098576 18.496 100 88 171 2 1896634256 13908928 23626752
20:07:49 2096 8192000000 10798102416 11191533568 1863229776 18.529 100 90 180 2 1901573872 13831504 24512592
20:07:57 1678 8192000000 10807193760 11198636032 1862226304 18.521 100 86 174 0 1899884992 13583040 24075648
20:08:06 1871 8192000000 10809778576 11198705664 1866488080 18.556 100 92 184 1 1905176672 12770944 25917648
20:08:14 2195 8192000000 10817269472 11205443584 1868281792 18.570 100 86 173 0 1905125920 12815104 24029024
20:08:24 4500 8192000000 10815511136 11207061504 1869354336 18.579 100 87 176 1 1907869920 13998672 24516912
20:08:35 1500 8192000000 10818770016 11205984256 1872888400 18.608 100 92 186 2 1912874672 14392496 25593776
20:08:42 2235 8192000000 10805930848 11208925184 1871058832 18.593 100 78 156 2 1907096240 14310224 21727184
20:08:52 2387 8192000000 10800048656 11205394432 1870503472 18.588 100 67 133 2 1900793984 10813328 19477184
20:09:02 3070 8192000000 10783380096 11199541248 1867538048 18.564 100 44 89 1 1888635232 8983952 12113232
20:09:11 2399 8192000000 10806976624 11207901184 1876110992 18.634 100 75 149 1 1906493664 9519104 20863568
20:09:21 2437 8192000000 10790696096 11205353472 1875536896 18.629 100 61 122 2 1903427984 10760800 17130288
20:09:31 4263 8192000000 10790647984 11205701632 1872233312 18.602 100 43 86 0 1893666368 8981168 12451888
20:09:42 6741 8192000000 10783019104 11207450624 1873909280 18.616 100 39 78 2 1892852864 6443856 12499728
20:09:56 8065 8192000000 10782098400 11211325440 1875972048 18.633 100 32 65 3 1892912512 8204864 8735600
20:10:10 3947 8192000000 10800409232 11218284544 1884858224 18.704 100 47 94 0 1904541136 5926144 13756768
20:10:23 5564 8192000000 10791839008 11216920576 1880421840 18.669 100 28 56 1 1895475040 7351680 7701520
20:10:35 12074 8192000000 10790327440 11219410944 1883011664 18.689 100 22 45 1 1894860976 5691440 6157872
20:10:53 10804 8192000000 10807434768 11231715328 1891388624 18.757 100 35 68 1 1910459488 9925088 9145776
20:11:14 79082 8192000000 10811323040 11240583168 1893121008 18.771 100 32 63 4 1907836144 6092192 8622944
20:12:40 7210 8192000000 10813001216 11242946560 1894021824 18.778 100 26 50 0 1907942784 7135824 6785136
20:12:56 4202 8192000000 10819387104 11245260800 1896343776 18.797 100 30 60 2 1911661072 6757584 8559712
20:13:06 6022 8192000000 10827709408 11250642944 1899123536 18.819 100 32 63 0 1918484624 9893264 9467824
20:13:21 7857 8192000000 10824686144 11254276096 1900657072 18.832 100 32 64 1 1920443776 11050752 8735952
20:13:37 6818 8192000000 10811738688 11246731264 1898650192 18.815 100 21 42 2 1909880960 4667488 6563280
20:13:50 7609 8192000000 10828709776 11256070144 1902708032 18.848 100 29 58 0 1917057024 5980896 8368096
20:14:05 7363 8192000000 10808370112 11250290688 1905748912 18.873 100 25 49 1 1919247664 6970720 6528032
20:14:20 8296 8192000000 10815232832 11253624832 1902030256 18.843 100 17 34 2 1912449280 5976256 4442768
20:14:35 8379 8192000000 10816716496 11255189504 1903309840 18.853 100 21 42 1 1916238592 6018304 6910448
20:14:51 9712 8192000000 10827036624 11258363904 1904720176 18.864 100 17 34 0 1915394512 5808720 4865616
20:15:08 10157 8192000000 10814351264 11251126272 1898829264 18.817 100 18 36 1 1914061392 10395424 4836704
20:15:24 7901 8192000000 10804733712 11247591424 1882162960 18.683 99 22 44 3 1895655232 6686704 6805568
20:15:39 12377 8192000000 10802978688 11239055360 1876488880 18.637 99 16 30 0 1887114192 6083312 4542000
20:15:58 58161 8192000000 10841655440 11260252160 1907714704 18.888 100 56 114 1 1931102128 7615728 15771696
20:17:04 10668 8192000000 10791735984 11234115584 1874636672 18.622 99 17 34 0 1885373328 5935616 4801040
20:17:22 6659 8192000000 10797934992 11228442624 1838887984 18.332 97 17 34 1 1849156512 5595824 4672704
20:17:37 6337 8192000000 10785967504 11211771904 1831245536 18.269 97 39 77 3 1849366352 7478176 10642640
20:17:53 2839 8192000000 10795431088 11220688896 1876038192 18.633 100 29 57 1 1889411216 6060032 7312992
20:18:02 8013 8192000000 10780282400 11206594560 1830991696 18.267 98 36 71 1 1847971648 6868144 10111808
20:18:19 4765 8192000000 10757010112 11178770432 1815446880 18.140 98 31 62 1 1831080080 5505872 10127328
20:18:30 7376 8192000000 10726160800 11146276864 1768255120 17.753 96 26 53 1 1781112656 5500720 7356816
20:18:44 7848 8192000000 10739298608 11151671296 1769746000 17.765 97 26 50 2 1782722560 5888048 7088512
20:18:58 9394 8192000000 10713742256 11136892928 1748124112 17.586 96 29 58 2 1762456336 6619776 7712448
20:19:18 5920 8192000000 10719515184 11127738368 1764363376 17.720 98 22 44 1 1776059504 5058608 6637520
20:19:31 6264 8192000000 10715371536 11127648256 1766012320 17.734 98 31 62 1 1780985072 5991648 8981104
20:19:43 7192 8192000000 10725989248 11146166272 1794800720 17.971 99 21 42 1 1806810208 5632144 6377344
20:19:59 10101 8192000000 10700854608 11106095104 1713661296 17.299 95 22 44 0 1725719328 5157344 6900688
20:20:18 8429 8192000000 10685094064 11096604672 1731598624 17.449 97 30 60 2 1746166128 5715696 8851808
20:20:34 48192 8192000000 10699476576 11104583680 1688467856 17.088 94 29 57 1 1701941504 4664432 8809216
20:21:29 45001 8192000000 10707272272 11125133312 1719332768 17.347 95 22 44 0 1731169648 6090368 5746512
20:22:22 5457 8192000000 10730781872 11150712832 1794836912 17.972 99 29 58 0 1809131200 5952848 8341440
20:22:34 6278 8192000000 10742660512 11155042304 1818186928 18.163 100 35 70 1 1836157408 7828832 10141648
20:22:46 5336 8192000000 10745010592 11167440896 1826120352 18.228 100 38 76 2 1847196960 9690192 11386416
20:22:58 7319 8192000000 10732472800 11151536128 1773740416 17.798 97 23 46 1 1786012224 5755792 6516016
20:23:12 9558 8192000000 10740153472 11170361344 1829921712 18.259 100 20 40 1 1840881136 5554528 5404896
20:23:30 4006 8192000000 10753140048 11179462656 1841018960 18.349 100 34 68 0 1857606544 6990208 9597376
20:23:45 8998 8192000000 10772325120 11191803904 1845152880 18.383 100 18 36 1 1856391424 5528960 5709584
20:24:02 10413 8192000000 10766493232 11194982400 1851677504 18.436 100 22 44 2 1863902096 6065168 6159424
20:24:22 8989 8192000000 10763610016 11199123456 1853736880 18.452 100 10 20 1 1861926656 5222544 2967232
20:24:37 6741 8192000000 10760583808 11195359232 1838400864 18.328 99 18 36 1 1849826112 6683552 4741696
20:24:53 6123 8192000000 10780881888 11205300224 1861966624 18.519 100 26 52 1 1876460016 6099280 8394112
20:25:07 7131 8192000000 10782494416 11209158656 1863602656 18.532 100 33 64 2 1879077872 6303552 9171664
20:25:25 59326 8192000000 10797740544 11220369408 1869031712 18.576 100 24 47 1 1881922240 6264016 6626512
20:26:35 21377 8192000000 10791659584 11223044096 1875009696 18.625 100 29 56 2 1889369696 5986080 8373920
20:27:06 10581 8192000000 10808093440 11239161856 1890010320 18.746 100 28 56 1 1903924944 5958256 7956368
20:27:25 1952 8192000000 10840883616 11256442880 1909761776 18.905 100 64 125 2 1933769072 5795472 18211824
20:27:38 18332 8192000000 10851862368 11270823936 1917653360 18.968 100 57 114 3 1942647072 9164560 15829152
20:28:11 8111 8192000000 10858241328 11280384000 1922180912 19.004 100 55 108 0 1946194768 9374608 14639248
20:28:41 15805 8192000000 10868626288 11295166464 1932549056 19.087 100 53 106 0 1959935328 12268128 15118144
20:29:05 25451 8192000000 10869257472 11298385920 1937344592 19.126 100 48 96 0 1964345488 12778320 14222576
20:29:37 24002 8192000000 10887273408 11310067712 1944870384 19.186 100 49 98 3 1972250512 13507920 13872208
20:30:19 4561 8192000000 10885641952 11312848896 1950535248 19.231 100 44 89 2 1975045344 11690704 12819392
20:30:46 35891 8192000000 10893034000 11331207168 1960105152 19.307 100 45 90 0 1988429184 14421840 13902192
20:31:38 15566 8192000000 10903873360 11336777728 1967125920 19.363 100 38 76 1 1989501936 10565216 11810800
20:32:08 18535 8192000000 10910315200 11343675392 1971848048 19.400 100 42 80 1 1995565664 12300992 11416624
20:32:34 12080 8192000000 10926783872 11357073408 1980692624 19.470 100 54 108 0 2012008816 15364208 15951984
20:32:53 33238 8192000000 10925770000 11365871616 1986572416 19.517 100 43 86 1 2016954464 16962176 13419872
20:33:48 28733 8192000000 10932991360 11373248512 1991032336 19.552 100 42 84 2 2021307584 17683296 12591952
20:34:24 7303 8192000000 10935017776 11373219840 1992836736 19.566 100 46 92 1 2028724272 21078272 14809264
20:34:43 12341 8192000000 10936766320 11378610176 1997608960 19.604 100 46 88 2 2033432240 21177632 14645648
20:35:12 5391 8192000000 10944168688 11390652416 2005755376 19.668 100 44 85 0 2038735408 19643520 13336512
20:35:25 12775 8192000000 10934562112 11382317056 1969456864 19.381 98 39 78 0 2004872608 22550800 12864944
20:35:49 7369 8192000000 10959302320 11392888832 2006741056 19.676 100 53 106 0 2046570144 23729776 16099312
20:36:07 5683 8192000000 10963895232 11397885952 2008035040 19.686 100 58 116 0 2050040464 24493664 17511760
20:36:24 3225 8192000000 10973331120 11404988416 2015373456 19.744 100 64 128 0 2060478752 25900560 19204736
20:36:34 13027 8192000000 10956834960 11392155648 1989958224 19.543 99 60 120 2 2033736752 26204144 17574384
20:36:54 1732 8192000000 10981412816 11402010624 2009132768 19.695 100 79 157 1 2061045312 28428320 23484224
20:37:04 12969 8192000000 10973655072 11405336576 2013963072 19.733 100 65 130 0 2063739296 30728368 19047856
20:37:25 8910 8192000000 10978354048 11407507456 2013817456 19.732 100 70 140 1 2067072432 32504480 20750496
20:37:43 11060 8192000000 10979628128 11416834048 2017210928 19.758 100 60 120 0 2068935696 33516368 18208400
20:38:03 12934 8192000000 10991427888 11429089280 2023126864 19.805 100 65 130 2 2077693312 35514752 19051696
20:38:30 10969 8192000000 10994097376 11435565056 2029523120 19.855 100 56 112 1 2085041520 38440080 17078320
20:38:51 6057 8192000000 11006756928 11439730688 2031093600 19.867 100 59 118 3 2089721600 40339648 18288352
20:39:04 5816 8192000000 10999969456 11435479040 2015328928 19.743 99 65 129 0 2075516400 40253840 19933632
20:39:19 4071 8192000000 11007316032 11442032640 2035215056 19.899 100 70 138 1 2097423200 40400960 21807184
20:39:30 3603 8192000000 11022282832 11449593856 2037560144 19.918 100 81 161 2 2103044992 41595536 23889312
20:39:43 5369 8192000000 11001980912 11435171840 2015494336 19.745 99 72 144 1 2080370928 43365728 21510864
20:39:55 5274 8192000000 11013015680 11442778112 2030314400 19.861 100 80 159 1 2099603856 45296416 23993040
20:40:07 5911 8192000000 11010973648 11447009280 2031476576 19.870 100 66 129 3 2097832688 45539040 20817072
20:40:25 5487 8192000000 11007121504 11445215232 2028526960 19.847 100 67 134 3 2094816192 45433872 20855360
20:40:38 1897 8192000000 11009839920 11434356736 2030195776 19.860 100 82 163 1 2098763952 43696128 24872048
20:40:47 2961 8192000000 11024424112 11450540032 2036664144 19.911 100 79 158 1 2105286816 44775936 23846736
20:40:57 3187 8192000000 11031820736 11451899904 2044034192 19.969 100 87 173 0 2115529408 45629664 25865552
20:41:08 4560 8192000000 11011725808 11442077696 2031748336 19.872 100 78 156 1 2098169952 42200016 24221600
20:41:21 7473 8192000000 11025961872 11453358080 2023587952 19.808 99 70 140 1 2091044704 45572720 21884032
20:41:39 3806 8192000000 10975780704 11410894848 2001995856 19.638 100 62 124 0 2065320432 43776752 19547824
20:41:50 2845 8192000000 11008904736 11428823040 2013903536 19.732 100 75 150 1 2088295104 50894016 23497552
20:42:02 1896 8192000000 10998218704 11427491840 2013783808 19.731 100 74 147 1 2083613184 46546832 23282544
20:42:13 3505 8192000000 10996305200 11420852224 2000970448 19.630 99 70 141 1 2070406272 48074400 21361424
20:42:26 1885 8192000000 11017907744 11443875840 2024095360 19.812 100 79 156 1 2098045840 49465456 24485024
20:42:35 8052 8192000000 10978728560 11406413824 1981431456 19.476 99 69 137 0 2054064048 50702272 21930320
20:42:56 7903 8192000000 10963622704 11395624960 1955746000 19.272 98 54 109 0 2024492032 51011440 17734592
20:43:15 3399 8192000000 10977919888 11401859072 1976251936 19.435 99 75 150 1 2047956352 48105760 23598656
20:43:26 4711 8192000000 10952152688 11372183552 1962459152 19.326 99 77 153 1 2034247216 48393216 23394848
20:43:40 4903 8192000000 10973068256 11400900608 1984731136 19.502 100 69 137 3 2058195872 52836144 20628592
20:43:58 6344 8192000000 10954985152 11380998144 1972401760 19.404 100 70 139 2 2042205456 48468624 21335072
20:44:10 5281 8192000000 10970831728 11395993600 1969380848 19.381 99 75 150 0 2040842048 48092080 23369120
20:44:27 3785 8192000000 10972629456 11403751424 1990276656 19.546 100 70 138 0 2059404576 47574288 21553632
20:44:37 2929 8192000000 10990537168 11416264704 1998440096 19.610 100 64 126 0 2063660064 45517264 19702704
20:44:46 10085 8192000000 10979334976 11421675520 2002940240 19.646 100 49 98 2 2067378480 48114592 16323648
20:45:05 6897 8192000000 10959655952 11405291520 1976987184 19.441 99 36 71 3 2034423552 45116304 12320064
20:45:25 7783 8192000000 10934945200 11370672128 1948139648 19.212 98 39 78 0 2007910208 47315504 12455056
20:45:40 5733 8192000000 10937495456 11372797952 1961099392 19.315 100 40 80 2 2022121632 47730304 13291936
20:46:00 3802 8192000000 10961673120 11386380288 1973617024 19.414 100 68 134 0 2044255584 49640800 20997760
20:46:11 4906 8192000000 10975345760 11397271552 1981738256 19.478 100 63 125 1 2053513296 52230768 19544272
20:46:25 3939 8192000000 10971244912 11405144064 1987653024 19.525 100 57 114 1 2060489152 54135232 18700896
20:46:36 5153 8192000000 10994013728 11411320832 1992887328 19.567 100 66 130 1 2067022336 53667552 20467456
20:46:48 3034 8192000000 11007132576 11424673792 2005921232 19.669 100 85 170 0 2088172944 55251488 27000224
20:46:59 1578 8192000000 10999121568 11416055808 1998155728 19.608 100 89 177 2 2083348272 56687248 28505296
20:47:09 11351 8192000000 10978820352 11415351296 1975556768 19.430 99 53 105 0 2051831168 58838192 17436208
20:47:29 7989 8192000000 10980327296 11415470080 1992930176 19.567 100 47 93 1 2065411728 57327664 15153888
20:47:45 19801 8192000000 10964647120 11410030592 1973401120 19.412 99 41 82 0 2038755360 51696896 13657344
20:48:14 6052 8192000000 10974062400 11401936896 1972374800 19.404 99 54 108 1 2042234576 52060160 17799616
20:48:30 15032 8192000000 10941172016 11385712640 1928091040 19.052 97 40 81 0 1987750960 46893952 12765968
20:48:57 8243 8192000000 10953091552 11381477376 1954436816 19.262 99 40 78 2 2015073920 47781376 12855728
20:49:17 7167 8192000000 10950529136 11395420160 1974833312 19.424 100 34 68 1 2034563888 48377120 11353456
20:49:38 6862 8192000000 10952594656 11395006464 1964421024 19.341 99 41 83 1 2026993712 48619088 13953600
20:49:54 16347 8192000000 10947796352 11391406080 1944351136 19.181 98 38 75 0 2005719168 48816272 12551760
20:50:17 23271 8192000000 10952773072 11401187328 1974261584 19.419 100 39 78 1 2044045088 56323008 13460496
20:51:02 18726 8192000000 10943980048 11402518528 1970994752 19.393 100 35 67 3 2041957488 58481456 12481280
20:51:38 21725 8192000000 10945391776 11395530752 1957873312 19.289 100 40 80 0 2037933952 65809712 14250928
20:52:06 16308 8192000000 10928609648 11383558144 1908879136 18.898 98 33 66 0 1990088544 68050032 13159376
20:52:58 11024 8192000000 10939239552 11382738944 1931495424 19.079 100 30 60 3 2012704272 69444176 11764672
20:53:17 11899 8192000000 10910873568 11363483648 1898005696 18.810 98 37 74 1 1983716624 71922608 13788320
20:53:42 25391 8192000000 10911323664 11350941696 1892603536 18.767 98 32 64 2 1974297376 70314944 11378896
20:54:14 9768 8192000000 10920839472 11372982272 1919619728 18.984 99 36 73 0 1991589792 59962576 12007488
20:54:38 49561 8192000000 10856114368 11307401216 1859182848 18.497 96 17 34 0 1875878848 11590864 5105136
20:55:37 110174 8192000000 10887407808 11346489344 1918276688 18.973 99 20 40 1 1931973872 8211408 5485776
20:57:38 97739 8192000000 10880801648 11322421248 1842658192 18.362 94 32 64 2 1861022144 9683232 8680720
20:59:24 95095 8192000000 10888431136 11327455232 1916108992 18.956 99 23 46 1 1940817776 18086496 6622288
21:01:35 53225 8192000000 10906856992 11355254784 1948125456 19.212 99 37 73 3 1970751552 12291376 10334720
21:02:34 120308 8192000000 10916505920 11362222080 1939588448 19.143 98 40 82 2 1962749088 11830592 11330048
21:04:41 28313 8192000000 10900091408 11357769728 1957100608 19.283 99 39 77 2 1983146688 14474128 11571952
21:05:16 40014 8192000000 10917529136 11381948416 1983417856 19.492 100 34 68 1 2008815808 15362768 10035184
21:06:03 30093 8192000000 10944732064 11393261568 1987047968 19.520 100 21 42 0 2010521056 17269552 6203536
21:07:05 44514 8192000000 10937718912 11407544320 1995003488 19.583 100 31 62 1 2026751808 22100848 9647472
21:07:57 37045 8192000000 10935356912 11405815808 1997009520 19.599 100 16 32 0 2025415216 23443760 4961936
21:08:53 56830 8192000000 10921354336 11412135936 1988138208 19.529 100 18 35 0 2012690704 19852560 4699936
21:10:20 58518 8192000000 10907268464 11375927296 1949193760 19.220 98 17 34 3 1966037072 11946960 4896352
21:11:24 42625 8192000000 10892864960 11353591808 1925608240 19.032 97 29 59 0 1946568064 13030816 7929008
21:12:13 48532 8192000000 10879018768 11358019584 1942476944 19.167 99 13 26 1 1955701936 9591248 3633744
21:13:13 22229 8192000000 10877064832 11354353664 1956427216 19.278 100 8 16 1 1969619136 10970592 2221328
21:13:42 38492 8192000000 10889769664 11366232064 1943865920 19.178 99 18 36 0 1969148048 20071888 5210240
21:14:27 57927 8192000000 10891102432 11368943616 1967479456 19.365 100 11 22 0 1983402672 12272928 3650288
21:15:32 97968 8192000000 10903048032 11372232704 1975369984 19.428 100 11 22 0 1987507328 9299664 2837680
21:17:16 44017 8192000000 10892050256 11362607104 1968620992 19.375 99 23 46 2 1982954656 7869792 6463872
21:18:06 57735 8192000000 10907812944 11384078336 1967734672 19.367 99 19 38 1 1981468768 8694256 5039840
21:19:40 60828 8192000000 10905491328 11390705664 1983943616 19.496 100 16 32 0 2002944720 14088224 4912880
21:20:47 68322 8192000000 10878760928 11365888000 1947768896 19.209 98 26 52 0 1966802800 11821312 7212592
21:22:09 62407 8192000000 10906121648 11386146816 1961446880 19.318 99 8 16 0 1971164096 7446448 2270768
21:23:23 45421 8192000000 10923514512 11395174400 1997643568 19.604 100 34 67 0 2014556480 7492224 9420688
21:24:34 36172 8192000000 10929125840 11385040896 1964315136 19.340 98 26 52 1 1980100912 8869824 6915952
21:25:24 42652 8192000000 10924655280 11396931584 1972570496 19.406 99 20 40 0 1997663920 19930880 5162544
21:26:13 46190 8192000000 10902221760 11369447424 1955613984 19.271 98 31 60 4 1980880112 15784560 9481568
21:27:06 61861 8192000000 10910448944 11394584576 1962769184 19.328 98 15 30 3 1984150432 16940736 4440512
21:28:19 79286 8192000000 10913086656 11400474624 1894568352 18.783 95 13 26 3 1921257456 23498144 3190960
21:30:34 63182 8192000000 10893973264 11399454720 1931389936 19.078 98 11 22 0 1965076320 30456976 3229408
21:32:05 78534 8192000000 10929608976 11377385472 1922947552 19.010 97 26 51 1 1942657088 12699824 7009712
21:33:30 20383 8192000000 10933809616 11382038528 1990740480 19.550 100 63 126 4 2021711984 11414000 19557504
21:34:07 59469 8192000000 10904828592 11376590848 1924686384 19.024 97 16 32 0 1942025360 13087216 4251760
21:35:19 44523 8192000000 10914693760 11379576832 1965246064 19.348 99 22 44 0 1980330960 8833648 6251248
21:36:09 75936 8192000000 10876610688 11338465280 1895263088 18.788 95 37 74 1 1919486944 13615360 10608496
21:38:13 69473 8192000000 10842316816 11314073600 1828832176 18.250 93 20 40 1 1848333968 14175856 5325936
21:39:29 53013 8192000000 10855172864 11338747904 1913065904 18.931 99 16 32 0 1936725392 19244960 4414528
21:40:29 11071 8192000000 10863134320 11324825600 1917739344 18.969 99 19 38 1 1939981488 17202400 5039744
21:40:47 16457 8192000000 10846793264 11319873536 1898879392 18.817 98 53 105 0 1930822352 16895216 15047744
21:41:27 52458 8192000000 10857774256 11320676352 1894051376 18.778 98 27 53 1 1911319344 9402672 7865296
21:42:26 46190 8192000000 10842603968 11328057344 1913654512 18.936 99 12 24 0 1926684448 10001968 3027968
21:43:28 50356 8192000000 10826930736 11295137792 1885792928 18.712 98 18 36 0 1905507824 14687360 5027536
21:44:25 72678 8192000000 10829604816 11310477312 1901783168 18.841 99 10 20 0 1915721392 10924688 3013536
21:45:44 14889 8192000000 10840487552 11323572224 1917254000 18.965 100 6 13 0 1929299408 10587072 1458336
21:46:15 48858 8192000000 10812124752 11291664384 1822650640 18.199 95 2 4 0 1830016992 7012512 353840
21:47:13 28740 8192000000 10839033456 11313106944 1918823536 18.977 100 7 15 0 1927157808 6822144 1512128
21:47:48 17634 8192000000 10849887312 11322314752 1912603776 18.928 99 19 38 1 1924499872 6509056 5387040
21:48:16 45240 8192000000 10886157392 11343261696 1918216896 18.973 99 24 48 1 1933607936 8167888 7223152
21:49:10 49782 8192000000 10866644496 11338510336 1913862416 18.938 98 26 52 0 1935604608 14377952 7364240
21:50:12 54953 8192000000 10868574720 11344670720 1898852928 18.817 97 23 46 0 1918423472 12476704 7093840
21:51:13 57990 8192000000 10860976800 11335286784 1906397488 18.878 98 12 24 1 1921808192 11931984 3478720
21:52:18 70204 8192000000 10877491680 11347357696 1892390896 18.765 97 17 34 0 1907337328 10345424 4601008
21:53:38 91211 8192000000 10897492400 11362242560 1936233808 19.117 99 12 24 1 1949155392 9799536 3122048
21:55:16 26306 8192000000 10922596592 11371130880 1969262016 19.380 100 34 68 1 1991400592 12843136 9295440
21:55:48 32973 8192000000 10907998096 11364626432 1915707904 18.952 97 44 88 5 1942193520 14427856 12057760
21:56:28 60207 8192000000 10901438912 11369029632 1913926592 18.938 98 23 46 2 1936347008 16429696 5990720
21:57:34 85560 8192000000 10887177008 11361763328 1889042144 18.738 96 9 18 1 1908995072 17695552 2257376
21:59:06 74745 8192000000 10886077904 11364818944 1963388144 19.333 100 16 32 1 1978170656 10111136 4671376
22:00:55 42641 8192000000 10895355840 11355983872 1946236464 19.196 99 28 56 1 1960230352 7048800 6945088
22:01:44 54823 8192000000 10890445712 11371134976 1958151888 19.291 99 24 48 0 1979612096 15184384 6275824
22:02:57 51668 8192000000 10896577264 11381653504 1950148528 19.228 99 6 12 0 1965299920 13476912 1674480
22:03:55 61638 8192000000 10899256416 11381624832 1933404880 19.094 98 12 24 0 1953248400 16484528 3358992
22:05:02 42890 8192000000 10907888336 11384909824 1953671136 19.256 99 17 34 1 1977154192 18716608 4766448
22:06:01 67143 8192000000 10906902432 11384459264 1943720960 19.176 98 23 46 0 1958926768 8634640 6571168
22:07:15 83126 8192000000 10937501072 11396825088 1948683648 19.216 98 28 56 0 1968239504 11182688 8373168
22:08:48 59393 8192000000 10917176624 11397189632 1978127808 19.450 99 34 68 3 1998525280 10744576 9652896
22:10:45 44015 8192000000 10910938160 11372351488 1894640880 18.783 95 20 40 0 1907305184 7141584 5522720
22:11:36 65706 8192000000 10880640704 11370496000 1912023408 18.923 97 16 32 2 1933160656 16548480 4588768
22:13:35 35875 8192000000 10907885120 11375812608 1963079888 19.331 100 23 46 1 1982299264 12875536 6343840
22:14:20 55693 8192000000 10909578864 11378475008 1937599584 19.128 98 32 64 0 1958234048 11963504 8670960
22:15:24 58517 8192000000 10903193760 11397365760 1956348928 19.277 99 14 28 0 1977310880 17073296 3888656
22:16:29 117718 8192000000 10889107072 11361357824 1873982912 18.616 95 9 18 1 1893204560 16997664 2223984
22:18:36 79700 8192000000 10859204992 11335733248 1938703600 19.136 100 10 20 0 1953022128 11873680 2444848
22:20:02 55065 8192000000 10864292944 11338907648 1908815120 18.897 98 19 38 1 1920994128 7252144 4926864
22:21:03 45965 8192000000 10858946368 11331895296 1906965200 18.882 98 15 30 0 1922434336 11410768 4058368
22:21:56 31051 8192000000 10857784304 11328946176 1880870960 18.672 97 19 38 0 1903075504 16222000 5982544
22:22:49 34326 8192000000 10870307504 11352850432 1929875360 19.066 100 13 26 1 1942122160 8756704 3490096
22:23:34 81937 8192000000 10877701344 11360448512 1939394576 19.142 99 15 29 0 1957413456 13131040 4887840
22:25:03 87506 8192000000 10884423184 11362295808 1884377024 18.700 96 10 20 0 1900504656 13332320 2795312
22:26:36 52968 8192000000 10351473984 10792538112 1428114864 14.845 73 10 20 0 1444880896 13922864 2843168

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 07-03-2021 22:29:45 to 07-03-2021 22:30:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 162 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

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          239493
MON$OLDEST_ACTIVE               240038
MON$OLDEST_SNAPSHOT             240038
MON$NEXT_TRANSACTION            240038
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                       2045728
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 ---
:151: 
:152: mscs-test-161.budzdorov.ru    Sun Mar  7 22:27:46 2021
:153:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:154: 
:155: 
:156: mscs-test-161.budzdorov.ru    Sun Mar  7 22:27:54 2021
:157:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:158: 
--- end of diff output ---

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

07.03.21 22:30:20. 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-07 22:30:23 No severe PSQL-related problems occured
07.03.21 22:30:24. End of report.