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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17579256 kB
MemAvailable 31628776 kB
Buffers 0 kB
Cached 14102988 kB
SwapCached 2040 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 2020-11-27 01:27:04
DTS_END                         2020-11-27 01:27:04.9440
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38204
TRN_ID                          246179
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: 9344.76 22082 1121371
customer order: creation 181.31 380 21757
customer order: refuse 15.36 314 1843
order to supplier: creation 48.55 1393 5826
order to supplier: removal 3.40 97679 408
invoice (draft): creation 48.83 3619 5860
invoice (draft): removal 51.88 806 6225
invoice accept: apply 44.59 17295 5351
invoice accept: cancel 46.64 816 5597
customer reserve: creation 4087.41 172 490489
customer reserve: removal 4509.92 58 541190
realization accept: apply 88.87 180 10664
realization accept: cancel 81.28 104 9754
payment from customer: creation 61.25 116 7350
payment from customer: removal 6.28 75 753
payment to supplier: creation 53.21 134 6385
payment to supplier: removal 3.34 81 401
service: total inventory turnovers 4.89 1091 587
service: total monetary turnovers 6.81 63 817
service: aggregate perf. data 0.92 15269 110
service: refresh index statistics 0.03 301995 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 27-11-2020 01:28:13 to 27-11-2020 01:28:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3914
TEST_TIME 2 4900
TEST_TIME 3 4551
TEST_TIME 4 5121
TEST_TIME 5 5050
TEST_TIME 6 6234
TEST_TIME 7 6096
TEST_TIME 8 6094
TEST_TIME 9 6204
TEST_TIME 10 6735
TEST_TIME 11 6792
TEST_TIME 12 6878
TEST_TIME 13 7005
TEST_TIME 14 7166
TEST_TIME 15 7535
TEST_TIME 16 7701
TEST_TIME 17 8156
TEST_TIME 18 8314
TEST_TIME 19 8644
TEST_TIME 20 8461
TEST_TIME 21 8825
TEST_TIME 22 9381
TEST_TIME 23 9602
TEST_TIME 24 9728
TEST_TIME 25 10314
TEST_TIME 26 11482
TEST_TIME 27 11372
TEST_TIME 28 11315
TEST_TIME 29 11125
TEST_TIME 30 10952
TEST_TIME 31 10801
TEST_TIME 32 11097
TEST_TIME 33 10836
TEST_TIME 34 10565
TEST_TIME 35 10623
TEST_TIME 36 10527
TEST_TIME 37 10327
TEST_TIME 38 10306
TEST_TIME 39 10207
TEST_TIME 40 10214
TEST_TIME 41 10178
TEST_TIME 42 10124
TEST_TIME 43 10041
TEST_TIME 44 10036
TEST_TIME 45 9942
TEST_TIME 46 9873
TEST_TIME 47 9794
TEST_TIME 48 9793
TEST_TIME 49 9682
TEST_TIME 50 9756
TEST_TIME 51 9808
TEST_TIME 52 9776
TEST_TIME 53 9723
TEST_TIME 54 9705
TEST_TIME 55 9700
TEST_TIME 56 9834
TEST_TIME 57 9836
TEST_TIME 58 9870
TEST_TIME 59 9933
TEST_TIME 60 9962
TEST_TIME 61 9932
TEST_TIME 62 10012
TEST_TIME 63 9968
TEST_TIME 64 9842
TEST_TIME 65 9746
TEST_TIME 66 9670
TEST_TIME 67 9682
TEST_TIME 68 9610
TEST_TIME 69 9544
TEST_TIME 70 9581
TEST_TIME 71 9561
TEST_TIME 72 9477
TEST_TIME 73 9454
TEST_TIME 74 9399
TEST_TIME 75 9327
TEST_TIME 76 9456
TEST_TIME 77 9462
TEST_TIME 78 9480
TEST_TIME 79 9508
TEST_TIME 80 9464
TEST_TIME 81 9471
TEST_TIME 82 9589
TEST_TIME 83 9592
TEST_TIME 84 9631
TEST_TIME 85 9668
TEST_TIME 86 9679
TEST_TIME 87 9648
TEST_TIME 88 9553
TEST_TIME 89 9604
TEST_TIME 90 9541
TEST_TIME 91 9536
TEST_TIME 92 9516
TEST_TIME 93 9458
TEST_TIME 94 9422
TEST_TIME 95 9495
TEST_TIME 96 9476
TEST_TIME 97 9498
TEST_TIME 98 9474
TEST_TIME 99 9499
TEST_TIME 100 9485
TEST_TIME 101 9488
TEST_TIME 102 9486
TEST_TIME 103 9549
TEST_TIME 104 9604
TEST_TIME 105 9620
TEST_TIME 106 9669
TEST_TIME 107 9677
TEST_TIME 108 9635
TEST_TIME 109 9650
TEST_TIME 110 9613
TEST_TIME 111 9554
TEST_TIME 112 9547
TEST_TIME 113 9530
TEST_TIME 114 9485
TEST_TIME 115 9487
TEST_TIME 116 9461
TEST_TIME 117 9415
TEST_TIME 118 9381
TEST_TIME 119 9414
TEST_TIME 120 9348

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-11-2020 01:28:17 to 27-11-2020 01:28:20.

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 1574164 1574164 0 0.00 0 34085 6 0 0
doc_list_biud 1574162 1574162 0 0.00 0 25928 26 0 0
sp_add_invoice_to_stock 5486 5351 135 2.46 22 202193 17296 0 135
sp_cancel_adding_invoice 5597 5597 0 0.00 4 69373 816 0 0
sp_cancel_client_order 1843 1843 0 0.00 4 8329 315 0 0
sp_cancel_customer_reserve 541190 541190 0 0.00 1 24438 58 0 0
sp_cancel_pay_from_customer 753 753 0 0.00 3 6141 76 0 0
sp_cancel_pay_to_supplier 401 401 0 0.00 3 2069 82 0 0
sp_cancel_supplier_invoice 6237 6225 12 0.19 2 25933 807 0 12
sp_cancel_supplier_order 408 408 0 0.00 6 1188549 97679 0 0
sp_cancel_write_off 9754 9754 0 0.00 1 10887 105 0 0
sp_client_order 21757 21757 0 0.00 3 28017 380 0 0
sp_customer_reserve 490489 490489 0 0.00 0 44001 172 0 0
sp_fill_shopping_cart 33426 33426 0 0.00 1 11556 38 0 0
sp_fill_shopping_cart_clo_res 490480 490480 0 0.00 0 28284 13 0 0
sp_get_clo_for_invoice 5333 5333 0 0.00 0 41736 291 0 0
sp_kill_cost_storno 16505 16505 0 0.00 0 12127 52 0 0
sp_kill_qstorno_ret_qs2qd 1098767 1098767 0 0.00 0 25926 32 0 0
sp_kill_qty_storno 581011 581011 0 0.00 0 25927 69 0 0
sp_lock_selected_doc 22099 22099 0 0.00 0 8375 6 0 0
sp_make_cost_storno 29730 29730 0 0.00 0 34080 51 0 0
sp_multiply_rows_for_pdistr 29728 29728 0 0.00 0 6947 30 0 0
sp_multiply_rows_for_qdistr 21757 21757 0 0.00 0 9899 151 0 0
sp_pay_from_customer 7350 7350 0 0.00 4 9733 116 0 0
sp_pay_to_supplier 6385 6385 0 0.00 5 8783 135 0 0
sp_payment_common 13734 13734 0 0.00 1 7874 26 0 0
sp_qd_handle_on_cancel_clo 1843 1843 0 0.00 0 8306 296 0 0
sp_qd_handle_on_invoice_upd_sts 10928 10928 0 0.00 0 15597 320 0 0
sp_qd_handle_on_reserve_upd_sts 10663 10663 0 0.00 0 17201 67 0 0
sp_reserve_write_off 10664 10664 0 0.00 6 17236 180 0 0
sp_supplier_invoice 5860 5860 0 0.00 6 100612 3619 0 0
sp_supplier_order 5826 5826 0 0.00 5 40291 1394 0 0
srv_aggregate_perf_data 110 110 0 0.00 2767 169713 15269 0 0
srv_fill_mon_cache_memory 172 172 0 0.00 900 134840 31140 0 0
srv_find_qd_qs_mism 1070155 1070155 0 0.00 0 19803 6 0 0
srv_make_invnt_saldo 587 587 0 0.00 22 40460 1092 0 0
srv_make_money_saldo 817 817 0 0.00 0 28118 64 0 0
srv_recalc_idx_stat 4 4 0 0.00 185543 399727 301995 0 0
t$perf-abend:sp_add_invoice_to_stock 135 135 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5351 5351 0 0.00 0 21175 168 0 0
t$perf-norm:sp_cancel_adding_invoice 448 448 0 0.00 0 2529 87 0 0
t$perf-norm:sp_cancel_client_order 1843 1843 0 0.00 0 2876 12 0 0
t$perf-norm:sp_cancel_customer_reserve 722 722 0 0.00 0 928 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 753 753 0 0.00 0 1329 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 401 401 0 0.00 0 1281 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 448 448 0 0.00 0 4365 23 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 21613 1403 0 0
t$perf-norm:sp_cancel_write_off 1086 1086 0 0.00 0 2553 8 0 0
t$perf-norm:sp_client_order 21757 21757 0 0.00 0 8849 18 0 0
t$perf-norm:sp_customer_reserve 1083 1083 0 0.00 0 2842 8 0 0
t$perf-norm:sp_pay_from_customer 7350 7350 0 0.00 0 10537 10 0 0
t$perf-norm:sp_pay_to_supplier 6385 6385 0 0.00 0 7243 15 0 0
t$perf-norm:sp_reserve_write_off 10664 10664 0 0.00 0 6290 11 0 0
t$perf-norm:sp_supplier_invoice 5860 5860 0 0.00 0 8599 19 0 0
t$perf-norm:sp_supplier_order 5826 5826 0 0.00 0 8590 24 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 806 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 3927 25 0 0
t$perf-norm:srv_make_invnt_saldo 587 587 0 0.00 0 7819 38 0 0
t$perf-norm:srv_make_money_saldo 817 817 0 0.00 0 685 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10924 10654 270 2.47 0 6546 22 0 270
v_all_customers 39012 39012 0 0.00 0 168 1 0 0
v_all_suppliers 32404 32404 0 0.00 0 140 1 0 0
v_all_wares 43514 43514 0 0.00 0 53 1 0 0
v_cancel_adding_invoice 896 896 0 0.00 0 1396 10 0 0
v_cancel_client_order 3686 3686 0 0.00 0 1767 4 0 0
v_cancel_customer_prepayment 1506 1506 0 0.00 0 4403 9 0 0
v_cancel_customer_reserve 1444 1444 0 0.00 0 3448 12 0 0
v_cancel_payment_to_supplier 802 802 0 0.00 0 1880 9 0 0
v_cancel_supplier_invoice 920 896 24 2.60 0 1880 15 0 24
v_cancel_supplier_order 816 816 0 0.00 0 1827 7 0 0
v_cancel_write_off 2172 2172 0 0.00 0 5218 14 0 0
v_max_id_clo_ord 5825 5825 0 0.00 0 5383 2 0 0
v_max_id_clo_res 1083 1083 0 0.00 0 3479 14 0 0
v_max_id_ord_sup 5843 5843 0 0.00 0 2569 4 0 0
v_max_non_paid_invoice 1850 1850 0 0.00 0 1601 4 0 0
v_max_non_paid_realizn 4042 4042 0 0.00 0 1386 3 0 0
v_min_id_clo_ord 5825 5825 0 0.00 0 2614 5 0 0
v_min_id_clo_res 1083 1083 0 0.00 0 2986 6 0 0
v_min_id_ord_sup 5843 5843 0 0.00 0 7071 10 0 0
v_min_non_paid_invoice 6384 6384 0 0.00 0 7870 14 0 0
v_min_non_paid_realizn 7350 7350 0 0.00 0 6212 16 0 0
v_our_firm 11118 11118 0 0.00 0 26 1 0 0
v_reserve_write_off 21326 21326 0 0.00 0 5590 8 0 0
x_lock_depdocs_on_canc_invoice 11374 11374 0 0.00 0 28649 120 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 13921 372 0 0
x_make_qstorno_1000_1200 5826 5826 0 0.00 2 37957 1313 0 0
x_make_qstorno_1200_2000 5860 5860 0 0.00 3 100598 3479 0 0
x_make_qstorno_2100_3300 490489 490489 0 0.00 0 43999 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-11-2020 01:28:21 to 27-11-2020 01:28:25.

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:08 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:14 19519 8192000000 10284850848 10598379520 921675568 10.113 70 53 108 0 941475760 2719872 17080320
22:57:42 46918 8192000000 10384974000 10708140032 1421150704 14.783 100 89 177 1 1455142240 5769872 28221664
22:58:38 24766 8192000000 10419145840 10750337024 1470541328 15.218 100 90 180 1 1506653568 7512304 28599936
22:59:11 30156 8192000000 10457915296 10791297024 1502585456 15.499 100 89 177 0 1540138352 8807744 28745152
22:59:50 16219 8192000000 10466267104 10800730112 1514103648 15.599 100 87 174 0 1551259792 9681792 27474352
23:00:14 29487 8192000000 10480853296 10815549440 1526896272 15.710 100 88 176 0 1564583056 10276672 27410112
23:00:54 25403 8192000000 10491664880 10836406272 1551189968 15.920 100 85 170 0 1588296896 10895552 26211376
23:01:29 16620 8192000000 10510966144 10857750528 1568762224 16.072 100 83 166 1 1606123888 11546464 25815200
23:01:54 13912 8192000000 10528782848 10881261568 1585419456 16.215 100 81 160 1 1621121040 11577952 24123632
23:02:16 15977 8192000000 10565683968 10919333888 1615019680 16.467 100 88 175 2 1652978640 11715120 26243840
23:02:45 14434 8192000000 10585463200 10944798720 1643560560 16.710 100 90 180 1 1683916672 13216112 27140000
23:03:11 15141 8192000000 10605401136 10968096768 1662807264 16.873 100 83 166 0 1701318544 13727952 24783328
23:03:35 10253 8192000000 10611704816 10983464960 1673972064 16.967 100 75 146 0 1707884464 12591728 21320672
23:03:54 8886 8192000000 10641476688 11011186688 1694313184 17.137 100 78 154 1 1728544272 11640096 22590992
23:04:13 11165 8192000000 10657611664 11029864448 1720186320 17.354 100 80 160 1 1755569072 12219584 23163168
23:04:33 5984 8192000000 10673852848 11049811968 1734088752 17.470 100 83 165 1 1769537392 11687776 23760864
23:04:54 4953 8192000000 10683111344 11063070720 1749181088 17.595 100 77 154 0 1781943216 10800976 21961152
23:05:06 4883 8192000000 10684978048 11064631296 1757810720 17.666 100 81 162 2 1792388784 10735824 23842240
23:05:18 4838 8192000000 10699000896 11077877760 1764560896 17.722 100 77 154 0 1798621968 11665728 22395344
23:05:31 6799 8192000000 10722260528 11100549120 1780888368 17.857 100 88 176 2 1819004160 12913008 25202784
23:05:45 2673 8192000000 10724322784 11103592448 1784278880 17.885 100 84 167 0 1821411520 13364864 23767776
23:05:54 3010 8192000000 10729795024 11110400000 1793395120 17.960 100 86 172 1 1831401760 13400720 24605920
23:06:04 4494 8192000000 10740130864 11120795648 1800677984 18.019 100 89 171 3 1838107568 14047280 23382304
23:06:16 10268 8192000000 10744435376 11130499072 1807255792 18.073 100 90 180 1 1847541424 15380624 24905008
23:06:35 3064 8192000000 10759424496 11139743744 1809868416 18.095 100 86 172 0 1847714848 13982896 23863536
23:06:45 2162 8192000000 10762136880 11148992512 1824599824 18.215 100 83 164 1 1862963120 13944496 24418800
23:06:54 3130 8192000000 10767447312 11152056320 1830291712 18.262 100 84 166 0 1866031824 13565824 22174288
23:07:03 2256 8192000000 10783902032 11165970432 1838551024 18.329 100 87 174 0 1876212160 13466128 24195008
23:07:12 2552 8192000000 10786879520 11171356672 1843878848 18.372 100 85 169 1 1880936464 12704320 24353296
23:07:21 3280 8192000000 10792617504 11180703744 1849851248 18.421 100 92 185 3 1889435056 13927696 25656112
23:07:31 1914 8192000000 10796669904 11184128000 1855480816 18.467 100 92 184 1 1895639872 13964784 26194272
23:07:39 1780 8192000000 10798124928 11189084160 1857169568 18.480 100 86 171 3 1894615552 13463232 23982752
23:07:48 1793 8192000000 10803629936 11190657024 1860718384 18.509 100 94 188 3 1900189760 13213728 26257648
23:07:57 2674 8192000000 10807116976 11193946112 1862371088 18.522 100 95 190 1 1902313488 12559312 27383088
23:08:06 1463 8192000000 10811310880 11198369792 1865312480 18.546 100 94 184 0 1905332816 13604080 26416256
23:08:13 2062 8192000000 10815953968 11204263936 1869055664 18.577 100 95 189 1 1907464064 11709792 26698608
23:08:22 1684 8192000000 10810414400 11197820928 1873388464 18.612 100 87 172 2 1910556464 12063392 25104608
23:08:30 2038 8192000000 10826188704 11212959744 1876888384 18.640 100 93 185 1 1915490592 12183744 26418464
23:08:38 1440 8192000000 10829992832 11218198528 1881403952 18.676 100 91 185 0 1920844160 13368192 26072016
23:08:46 1640 8192000000 10823601808 11214213120 1881342624 18.676 100 92 184 3 1920601680 13055744 26203312
23:08:54 37580 8192000000 10808174176 11213811712 1877268272 18.643 100 67 135 1 1906973520 9618464 20086784
23:09:39 4183 8192000000 10817253568 11220324352 1883023552 18.690 100 87 175 3 1918371376 9227120 26120704
23:09:50 10698 8192000000 10780970832 11205263360 1872700144 18.606 100 33 64 1 1889209408 7236832 9272432
23:10:07 7156 8192000000 10779327840 11208892416 1873071088 18.609 100 26 50 1 1887298800 7082656 7145056
23:10:23 5892 8192000000 10800292416 11219656704 1881907856 18.681 100 38 76 0 1900931808 7720368 11303584
23:10:36 9047 8192000000 10798070000 11223367680 1880688384 18.671 100 30 60 3 1896099056 6628672 8782000
23:10:55 7886 8192000000 10791666928 11222487040 1884873168 18.704 100 27 54 2 1898530144 5919216 7737760
23:11:09 13216 8192000000 10800078048 11235393536 1890593152 18.751 100 24 48 2 1904120832 6542704 6984976
23:11:28 10001 8192000000 10798349536 11232096256 1891207344 18.756 100 20 41 2 1903059808 6231728 5620736
23:11:47 15634 8192000000 10799677792 11235160064 1896046432 18.794 100 27 56 0 1909285264 5089200 8149632
23:12:11 66933 8192000000 10822916544 11248824320 1902281056 18.845 100 35 66 1 1917703264 5520832 9901376
23:13:25 10197 8192000000 10808051664 11246723072 1901908784 18.842 100 21 42 1 1913928640 6596144 5423712
23:13:43 8121 8192000000 10817687424 11250647040 1900704528 18.832 100 22 44 1 1913487232 6341584 6441120
23:14:00 7878 8192000000 10816085872 11250196480 1902189152 18.844 100 24 48 1 1915107680 6352432 6566096
23:14:15 3860 8192000000 10821926192 11254095872 1908131552 18.892 100 34 68 0 1925144608 6254272 10758784
23:14:25 6900 8192000000 10816244528 11252740096 1907218704 18.884 100 21 41 3 1918799104 5628992 5951408
23:14:39 7024 8192000000 10827413168 11256160256 1906138960 18.876 100 36 71 3 1924202560 7997600 10066000
23:14:54 7133 8192000000 10823615200 11257749504 1905520272 18.871 100 24 48 3 1919408048 6760320 7127456
23:15:10 9144 8192000000 10809666112 11251429376 1886618688 18.719 99 13 26 1 1896441280 5665504 4157088
23:15:27 5836 8192000000 10816691952 11254243328 1904454768 18.862 100 28 56 0 1919690656 7326944 7908944
23:15:41 9341 8192000000 10818257504 11253338112 1907643456 18.888 100 30 59 2 1922700272 5758480 9298336
23:15:57 12163 8192000000 10796883712 11231748096 1868069520 18.569 98 12 24 0 1876680144 5483392 3127232
23:16:18 9866 8192000000 10794584512 11230199808 1882250352 18.683 99 25 50 0 1895359904 5859632 7249920
23:16:36 60517 8192000000 10824524352 11241222144 1883461760 18.693 99 39 77 2 1900735248 5164496 12108992
23:17:43 10321 8192000000 10801943248 11240177664 1879207504 18.659 99 23 46 3 1896968032 11674128 6086400
23:18:01 4748 8192000000 10791056896 11210416128 1857317104 18.482 99 43 85 2 1876067808 6936800 11813904
23:18:13 4984 8192000000 10783930016 11211841536 1858631328 18.492 99 32 64 3 1875039904 7370624 9037952
23:18:25 5590 8192000000 10787738784 11195793408 1826294576 18.229 98 40 80 1 1844808672 6753392 11760704
23:18:37 5169 8192000000 10766807696 11180998656 1812457456 18.116 98 29 58 0 1827298160 6984896 7855808
23:18:52 6071 8192000000 10727643696 11145084928 1782569408 17.871 98 35 70 0 1798559136 6037360 9952368
23:19:05 2645 8192000000 10721802384 11136155648 1755491232 17.647 96 35 70 0 1772292688 6553136 10248320
23:19:15 7022 8192000000 10701995488 11114442752 1746842144 17.575 96 33 65 2 1766013296 10734592 8436560
23:19:30 7919 8192000000 10746498368 11153518592 1787461504 17.911 98 31 62 0 1801709744 4772864 9475376
23:19:46 6500 8192000000 10722687248 11142029312 1794876352 17.972 99 36 72 2 1811491872 7026416 9589104
23:19:59 6027 8192000000 10737125872 11162460160 1826728208 18.233 100 19 38 0 1838185952 5338512 6119232
23:20:11 8023 8192000000 10717996352 11143376896 1790555296 17.936 98 23 45 0 1803231648 5857744 6818608
23:20:26 8643 8192000000 10713679568 11132772352 1787054544 17.908 98 9 17 1 1794980368 5235712 2690112
23:20:44 6472 8192000000 10704872032 11116032000 1762057872 17.701 97 22 45 0 1774300464 4992976 7249616
23:21:01 7214 8192000000 10720403504 11136356352 1777627376 17.830 98 23 46 3 1789705216 4686912 7390928
23:21:16 69062 8192000000 10685055104 11096154112 1687484000 17.080 94 31 63 0 1702131536 5429904 9217632
23:22:36 10518 8192000000 10717935264 11130658816 1783096112 17.875 99 25 51 1 1795936080 5046976 7792992
23:22:54 8558 8192000000 10713304304 11127648256 1772742720 17.790 98 48 95 3 1792707888 6979744 12985424
23:23:10 4695 8192000000 10726826976 11137224704 1803661040 18.044 100 32 64 0 1818511808 5325680 9525088
23:23:22 7017 8192000000 10731207280 11152625664 1819410784 18.173 100 27 54 1 1833160784 5868096 7881904
23:23:35 8425 8192000000 10747622768 11171401728 1831170000 18.269 100 22 44 0 1843282656 6017488 6095168
23:23:52 7122 8192000000 10753815536 11176124416 1838728352 18.330 100 29 57 2 1853318288 6678576 7911360
23:24:07 7842 8192000000 10760599744 11179773952 1840871424 18.348 100 22 43 2 1852541504 5491840 6178240
23:24:22 6093 8192000000 10772128592 11184726016 1843402224 18.368 100 31 62 0 1859500784 6917504 9181056
23:24:35 7680 8192000000 10764241776 11182264320 1845687984 18.387 100 24 48 4 1858025040 5773568 6563488
23:24:49 7709 8192000000 10770751872 11187994624 1848445968 18.409 100 38 76 3 1865343920 5592528 11305424
23:25:10 14181 8192000000 10757956864 11184783360 1844361840 18.376 100 15 30 1 1854485968 5389760 4734368
23:25:31 13564 8192000000 10770787248 11195502592 1853517632 18.451 100 18 34 3 1864143248 5567200 5058416
23:25:53 23706 8192000000 10768465072 11199557632 1856452160 18.475 100 22 43 2 1868043376 5340064 6251152
23:26:41 87092 8192000000 10823554048 11240329216 1876716880 18.639 100 51 101 1 1897021568 6520272 13784416
23:28:21 19045 8192000000 10818658400 11241549824 1895800688 18.793 100 41 79 2 1915626496 8521648 11304160
23:28:55 31165 8192000000 10833626608 11258585088 1910408176 18.910 100 39 78 0 1932822304 11362352 11051776
23:29:34 3512 8192000000 10842880272 11265024000 1914880096 18.946 100 42 83 4 1938027936 10427984 12719856
23:29:47 20833 8192000000 10843221152 11272957952 1922464864 19.007 100 42 83 1 1945760704 11333072 11962768
23:30:19 24549 8192000000 10867387584 11294187520 1933529216 19.095 100 43 86 1 1960303472 14101856 12672400
23:30:53 8651 8192000000 10883821728 11304603648 1940645376 19.152 100 53 106 3 1972034512 15746816 15642320
23:31:17 12701 8192000000 10882600048 11303698432 1941682464 19.160 100 41 82 1 1970974176 17010688 12281024
23:31:39 21689 8192000000 10873318672 11305312256 1945781248 19.193 100 46 92 0 1975217104 15705648 13730208
23:32:08 16854 8192000000 10877210576 11306835968 1944213264 19.180 100 33 67 2 1968444576 14398272 9833040
23:32:37 17057 8192000000 10896800688 11317936128 1953514208 19.254 100 43 84 1 1983670816 16652976 13503632
23:33:01 6183 8192000000 10892821344 11319975936 1959416608 19.301 100 58 116 2 1994587728 17612624 17558496
23:33:14 5898 8192000000 10893997824 11322171392 1958075952 19.291 100 53 106 2 1990210832 16742336 15392544
23:33:26 1636 8192000000 10920193200 11329536000 1962813712 19.328 100 63 126 3 1999074960 17859424 18401824
23:33:35 9496 8192000000 10898157920 11326472192 1955993216 19.274 100 49 97 0 1989007648 18668496 14345936
23:33:55 2580 8192000000 10908838928 11326820352 1962480544 19.326 100 87 173 1 2004742976 18086224 24176208
23:34:05 7060 8192000000 10908050656 11325329408 1958061328 19.291 100 66 132 3 1995595936 18154160 19380448
23:34:20 7292 8192000000 10911424992 11331510272 1961923696 19.321 100 58 116 2 1996842144 18684768 16233680
23:34:35 22057 8192000000 10909170512 11335720960 1965503824 19.350 100 60 120 2 2002898496 19220704 18173968
23:35:05 29062 8192000000 10913240960 11343282176 1969458368 19.381 100 46 92 2 2002899952 19538288 13903296
23:35:44 13877 8192000000 10924863456 11357417472 1977950720 19.448 100 43 86 2 2015074512 23230544 13893248
23:36:06 13823 8192000000 10931826384 11362906112 1979828912 19.463 100 44 87 3 2016311440 23286288 13196240
23:36:27 6258 8192000000 10936522704 11366674432 1982308048 19.483 100 50 100 1 2022942160 25578144 15055968
23:36:43 17484 8192000000 10933221760 11365351424 1984952976 19.504 100 59 118 1 2028050704 25247264 17850464
23:37:07 4237 8192000000 10938471760 11367505920 1984022720 19.497 100 55 110 1 2026043648 24781376 17239552
23:37:21 2633 8192000000 10935280864 11360993280 1983558112 19.493 100 63 122 3 2024550720 22753648 18238960
23:37:32 3114 8192000000 10933714848 11359432704 1973044112 19.410 99 74 146 1 2017521968 22710848 21767008
23:37:41 5346 8192000000 10933547184 11353673728 1977336064 19.444 100 64 128 0 2020377712 24233360 18808288
23:37:55 3262 8192000000 10938448368 11356938240 1980462208 19.468 100 77 154 1 2027993264 25089456 22441600
23:38:06 6836 8192000000 10933623280 11353186304 1974247264 19.419 100 76 151 1 2020858112 25099840 21511008
23:38:23 8978 8192000000 10931689024 11349708800 1969730032 19.383 100 68 134 3 2015303456 25786768 19786656
23:38:39 7270 8192000000 10942693296 11360473088 1966348640 19.356 99 77 152 1 2016684144 27795312 22540192
23:38:53 7659 8192000000 10946202368 11369472000 1984295952 19.499 100 72 143 0 2033126496 27647232 21183312
23:39:12 7469 8192000000 10952527376 11380137984 1993171856 19.569 100 66 132 1 2044796976 31666256 19958864
23:39:28 9379 8192000000 10963371872 11387981824 1994715600 19.581 100 67 134 2 2047877184 33190064 19971520
23:39:52 5092 8192000000 10958494912 11386634240 1994399664 19.579 100 67 132 0 2050159456 36042992 19716800
23:40:05 3766 8192000000 10965718176 11382267904 1974667328 19.422 99 81 161 1 2037462816 37705648 25089840
23:40:17 4047 8192000000 10969151296 11379425280 1978072160 19.449 99 87 175 1 2049379392 44180192 27127040
23:40:30 7727 8192000000 10972214736 11392827392 1992898720 19.567 100 74 148 0 2057601360 42017008 22685632
23:40:47 4072 8192000000 10982211296 11402227712 1997764528 19.605 100 70 140 0 2061930048 41871760 22293760
23:40:58 6344 8192000000 10981485296 11405078528 2004510624 19.658 100 82 164 1 2070854976 41102016 25242336
23:41:17 4000 8192000000 10982336016 11405008896 1998054992 19.607 100 69 138 2 2064370752 44989424 21326336
23:41:28 2323 8192000000 10988876416 11401736192 1994107136 19.576 100 71 140 4 2061457904 44947968 22402800
23:41:39 4972 8192000000 10987559488 11407863808 2000567520 19.627 100 75 150 1 2069899584 46046128 23285936
23:41:50 3422 8192000000 10991525568 11403468800 2000378960 19.626 100 79 158 2 2067815760 43466016 23970784
23:42:01 5170 8192000000 10976929824 11394277376 1982528352 19.485 100 75 150 0 2053064768 47488064 23048352
23:42:13 1780 8192000000 10960261280 11374526464 1972124544 19.402 100 84 168 0 2042356864 44219184 26013136
23:42:24 2079 8192000000 10959474000 11376975872 1976986272 19.441 100 77 154 3 2043219680 41730880 24502528
23:42:35 6335 8192000000 10958654656 11380514816 1982565392 19.485 100 80 160 3 2053970544 46558336 24846816
23:42:49 3317 8192000000 10945755872 11366694912 1965707024 19.351 99 70 140 0 2026400096 38955616 21737456
23:43:00 1917 8192000000 10972463264 11380748288 1985585920 19.509 100 78 154 0 2046660560 37418640 23656000
23:43:10 5798 8192000000 10966724592 11379535872 1978701200 19.454 100 85 168 2 2043452576 38982976 25768400
23:43:24 3708 8192000000 10954493968 11362332672 1951205376 19.236 99 83 164 3 2015573360 38954128 25413856
23:43:34 3675 8192000000 10951815488 11357638656 1962229616 19.324 100 83 166 2 2028606848 40891040 25486192
23:43:44 2428 8192000000 10954149136 11360264192 1947600320 19.207 99 88 176 1 2016906624 41864736 27441568
23:43:56 3718 8192000000 10931928160 11348434944 1933792640 19.097 99 72 145 1 2000437920 42591792 24053488
23:44:07 1364 8192000000 10949282912 11359125504 1962120400 19.323 100 91 180 1 2034317216 42924976 29271840
23:44:16 1626 8192000000 10940197104 11345960960 1947147296 19.204 99 90 181 1 2020167360 44998064 28022000
23:44:25 4379 8192000000 10955543088 11363209216 1963845728 19.337 100 82 164 2 2033507152 44052960 25608464
23:44:36 3102 8192000000 10962144928 11370999808 1970651248 19.391 100 87 173 1 2042129936 44096144 27382544
23:44:46 4336 8192000000 10952660432 11362455552 1953297648 19.253 99 84 164 4 2020143664 40099408 26746608
23:44:58 6404 8192000000 10946217296 11372113920 1972203584 19.403 100 70 140 1 2036444448 41391008 22849856
23:45:11 13931 8192000000 10922715344 11364859904 1949734960 19.224 99 39 79 1 2001297168 38755088 12807120
23:45:31 8725 8192000000 10931074400 11369263104 1967605824 19.366 100 37 74 4 2018189664 38700000 11883840
23:45:47 8241 8192000000 10899845696 11317108736 1908759232 18.897 97 60 121 2 1967771264 39808688 19203344
23:46:06 3487 8192000000 10947246400 11358826496 1959984272 19.306 100 88 172 0 2028970560 42325280 26661008
23:46:18 1259 8192000000 10959823456 11372544000 1967905952 19.369 100 78 155 0 2037734176 44445904 25382320
23:46:26 3611 8192000000 10946067808 11371278336 1952430192 19.246 99 59 118 0 2015163040 44060560 18672288
23:46:39 11150 8192000000 10896497776 11335364608 1905839184 18.873 98 35 70 2 1960319808 42149856 12330768
23:47:04 8216 8192000000 10909468992 11341049856 1937625664 19.128 100 39 76 2 1991287424 40777632 12884128
23:47:19 11635 8192000000 10918939680 11346661376 1927126720 19.044 99 40 79 1 1982566832 41894704 13545408
23:47:37 6215 8192000000 10945858032 11357630464 1953015248 19.250 100 79 158 1 2023480896 44370880 26094768
23:47:51 3955 8192000000 10944937872 11360927744 1953514800 19.254 100 77 154 1 2027433888 49093776 24825312
23:48:03 5636 8192000000 10935273232 11351953408 1940785920 19.153 99 71 142 1 2016013072 52132272 23094880
23:48:23 9571 8192000000 10919218880 11348766720 1926313280 19.037 99 61 122 2 2000920000 55187632 19419088
23:48:41 7486 8192000000 10915805984 11345137664 1923189184 19.012 99 44 88 2 1987937888 49989184 14759520
23:48:59 15030 8192000000 10909451520 11349823488 1932247040 19.085 100 34 68 3 1995244304 51217440 11779824
23:49:21 13300 8192000000 10904778192 11337998336 1919653888 18.984 99 41 82 1 1979713712 46660032 13399792
23:49:46 32060 8192000000 10884210208 11340791808 1900535328 18.831 98 32 64 1 1965722256 54447424 10739504
23:50:25 38137 8192000000 10878570864 11322306560 1899099952 18.819 99 20 40 0 1946796048 40232304 7463792
23:51:16 32541 8192000000 10874135200 11332173824 1890078896 18.746 99 20 40 1 1949727264 51689408 7958960
23:51:59 16922 8192000000 10903440672 11356651520 1927650864 19.048 100 35 70 0 1989450976 49620032 12180080
23:52:36 10508 8192000000 10892274640 11342508032 1930483344 19.071 100 41 80 0 1988275456 44747776 13044336
23:53:05 36592 8192000000 10886182688 11355680768 1935840816 19.114 100 17 34 1 1992791328 50363168 6587344
23:53:48 50858 8192000000 10894553808 11344330752 1941142704 19.156 100 15 30 1 1960506976 15134464 4229808
23:54:57 11016 8192000000 10881878896 11329576960 1945340848 19.189 100 44 88 1 1971709472 13804880 12563744
23:55:25 66961 8192000000 10870787344 11340115968 1923399264 19.014 99 11 22 1 1938308768 11840704 3068800
23:57:23 46577 8192000000 10888759088 11329302528 1918547552 18.975 98 17 33 2 1930529856 6668016 5314288
23:58:16 26323 8192000000 10898928224 11350691840 1945683888 19.192 99 18 36 2 1961940752 11121184 5135680
23:58:49 74664 8192000000 10888657040 11364352000 1943620592 19.176 99 11 21 1 1964273440 17327696 3325152
00:00:11 103178 8192000000 10912975872 11353030656 1930567168 19.071 98 28 56 0 1945940992 7305632 8068192
00:02:16 134840 8192000000 10880156608 11350552576 1871285600 18.595 95 15 30 0 1890156448 14459728 4411120
00:04:45 900 8192000000 10925871712 11350151168 1968706784 19.375 100 76 153 5 1998575664 8299936 21568944
00:04:52 13471 8192000000 10924955184 11353509888 1965465744 19.349 100 43 86 3 1988605792 11147328 11992720
00:05:18 32012 8192000000 10889615488 11349786624 1946169840 19.196 99 34 68 2 1966678528 10333888 10174800
00:05:57 14743 8192000000 10889900528 11343634432 1964815648 19.344 100 37 74 0 1985662912 9849968 10997296
00:06:26 38396 8192000000 10908302464 11353878528 1933031056 19.091 98 36 71 3 1955209040 11483792 10694192
00:07:25 21131 8192000000 10914336176 11364642816 1974488544 19.421 100 36 72 0 1997164480 12385984 10289952
00:08:00 49775 8192000000 10916521168 11379306496 1973871920 19.416 100 17 34 0 1989560576 10743840 4944816
00:09:03 45029 8192000000 10892653952 11365195776 1963955232 19.337 99 15 30 0 1977571968 9372064 4244672
00:09:55 8088 8192000000 10896060192 11364597760 1976551440 19.437 100 6 12 0 1987252192 9087312 1613440
00:10:13 64973 8192000000 10907552384 11379503104 1981703856 19.478 100 14 28 0 1996081424 10238000 4139568
00:11:26 27662 8192000000 10905844032 11366305792 1967147184 19.363 99 26 52 1 1984730000 10176608 7406208
00:12:02 62666 8192000000 10894137936 11361234944 1965726400 19.352 99 11 22 1 1976839152 7901472 3211280
00:13:16 44722 8192000000 10890829936 11366825984 1943193952 19.172 98 9 19 1 1954593488 8390272 3009264
00:14:48 68123 8192000000 10890671248 11368878080 1940349920 19.150 98 21 42 3 1958901312 12540144 6011248
00:16:09 41417 8192000000 10912954880 11378155520 1973983136 19.417 100 22 44 0 1994579920 14127968 6468816
00:17:05 50015 8192000000 10909303568 11394105344 1982590656 19.485 100 7 14 0 1999552336 15007616 1954064
00:18:02 37458 8192000000 10904002336 11378331648 1963377776 19.333 99 12 24 0 1979578048 12014224 4186048
00:18:45 41529 8192000000 10926349280 11377905664 1966323936 19.356 99 28 57 1 1983523440 8516656 8682848
00:19:33 38743 8192000000 10889708784 11371442176 1947307760 19.205 98 14 28 1 1959225360 7742064 4175536
00:20:20 31989 8192000000 10925782032 11387527168 1969281920 19.380 99 39 78 1 1988422080 7397504 11742656
00:20:58 32287 8192000000 10918856064 11396046848 1992179056 19.561 100 27 54 1 2011639504 11401664 8058784
00:21:37 44250 8192000000 10963316976 11408142336 1984144976 19.498 99 37 74 0 2005138320 9919696 11073648
00:22:29 42383 8192000000 10904755824 11367337984 1938061696 19.131 97 20 40 0 1957749568 13487040 6200832
00:23:21 70168 8192000000 10905337344 11380981760 1908930576 18.898 96 14 28 0 1923764352 11243024 3590752
00:24:43 69940 8192000000 10873258624 11345444864 1851660224 18.436 94 11 22 1 1870273008 15271232 3341552
00:25:59 63645 8192000000 10870471088 11333066752 1866964912 18.560 96 9 18 1 1883751392 13568864 3217616
00:27:11 57633 8192000000 10918504688 11369054208 1963690192 19.335 100 17 34 1 1976106160 8197888 4218080
00:28:15 9611 8192000000 10925918992 11353243648 1931776000 19.081 97 68 137 1 1963782864 11931792 20075072
00:28:34 41026 8192000000 10888071952 11355136000 1923601392 19.016 98 29 58 2 1945072592 13781136 7690064
00:29:21 104976 8192000000 10887128944 11346755584 1866903440 18.559 95 10 20 0 1880769808 11680928 2185440
00:31:27 96961 8192000000 10884237712 11342536704 1940026896 19.147 99 33 66 1 1956915648 6758720 10130032
00:33:10 9804 8192000000 10913529472 11341041664 1944300672 19.181 99 60 118 1 1969998784 8006864 17691248
00:33:26 39344 8192000000 10869569792 11326595072 1889548544 18.742 97 46 92 2 1915480768 12879216 13053008
00:34:16 65250 8192000000 10824230192 11299774464 1866812912 18.558 97 13 25 1 1883574496 12900992 3860592
00:35:49 64015 8192000000 10852916880 11323785216 1888203664 18.731 98 7 14 1 1906507664 16509728 1794272
00:37:57 70750 8192000000 10816696432 11291262976 1840411360 18.344 96 9 19 1 1850923600 7595248 2916992
00:39:37 67198 8192000000 10829139808 11305963520 1911611056 18.920 100 13 26 0 1923817392 8888352 3317984
00:40:59 93173 8192000000 10830698688 11306692608 1855211760 18.464 97 6 12 0 1864591824 7815360 1564704
00:42:38 37237 8192000000 10849296592 11323912192 1906571120 18.879 99 31 62 0 1931721168 15818848 9331200
00:43:40 66530 8192000000 10872483808 11341447168 1936253056 19.117 100 11 22 1 1950883856 11638864 2991936
00:44:56 70333 8192000000 10853266144 11321389056 1851001056 18.430 95 18 36 2 1868102736 12053424 5048256
00:46:12 57551 8192000000 10878672512 11331670016 1937294144 19.125 100 29 59 0 1954866000 9700240 7871616
00:47:20 49037 8192000000 10898825152 11359555584 1941583552 19.159 99 30 60 0 1961149872 10857200 8709120
00:48:38 64870 8192000000 10878677984 11361406976 1954799808 19.265 100 14 28 1 1972625280 13641792 4183680
00:49:49 58912 8192000000 10880916224 11343872000 1898329168 18.813 97 22 44 0 1916077536 11883360 5865008
00:50:55 40533 8192000000 10886320992 11343630336 1917017392 18.963 98 23 46 0 1934348560 11257696 6073472
00:51:42 67144 8192000000 10878905664 11356209152 1917990064 18.971 98 22 44 3 1940944464 16662160 6292240
00:52:55 75469 8192000000 10873668528 11333218304 1896962864 18.802 97 18 36 1 1918830304 17229200 4638240
00:54:20 50254 8192000000 10884116976 11343863808 1953529472 19.255 100 41 82 0 1975346128 10278368 11538288
00:55:47 92778 8192000000 10889562512 11367497728 1958802944 19.297 100 23 46 3 1974807328 9914976 6089408
00:57:26 9245 8192000000 10881936672 11361492992 1944926304 19.186 99 19 38 1 1962470112 12730784 4813024
00:57:42 26320 8192000000 10867125696 11335581696 1936856144 19.122 99 18 36 2 1952958688 11250352 4852192
00:58:28 75663 8192000000 10882213696 11365912576 1962973008 19.330 100 8 16 0 1978765072 13661680 2130384
00:59:59 57537 8192000000 10896724144 11379597312 1974043136 19.418 100 11 22 0 1986616176 9519760 3053280
01:01:03 71811 8192000000 10863402944 11346407424 1912727504 18.929 97 15 30 1 1927912720 10886064 4299152
01:02:21 40599 8192000000 10882180944 11352956928 1923026464 19.011 98 12 24 1 1932503152 6391696 3084992
01:03:08 85934 8192000000 10918907072 11388096512 1981993840 19.480 100 20 40 0 1994713072 7696096 5023136
01:04:41 16062 8192000000 10937411152 11393138688 1999263312 19.617 100 47 93 0 2019279168 6800720 13215136
01:05:14 37769 8192000000 10934901696 11387691008 1976547776 19.437 99 28 57 1 1992267984 8077328 7642880
01:05:59 15981 8192000000 10931784336 11390750720 1997053536 19.599 100 58 112 5 2025974624 13808160 15112928
01:06:22 25295 8192000000 10923827408 11385946112 1973746384 19.415 99 21 42 1 1986618896 7406496 5466016
01:06:59 50310 8192000000 10893819184 11359711232 1932823680 19.089 98 26 52 2 1949865120 9736736 7304704
01:07:56 39242 8192000000 10879859216 11338575872 1875214064 18.626 95 30 60 1 1892858848 9402736 8242048
01:08:48 11184 8192000000 10891202736 11344199680 1933804320 19.097 99 44 88 2 1963085904 17434752 11846832
01:09:07 33981 8192000000 10867131232 11325792256 1863219200 18.529 95 34 68 1 1885696016 12888928 9587888
01:09:54 81016 8192000000 10892625728 11373481984 1945299792 19.189 100 22 44 3 1976281520 24587168 6394560
01:11:24 71327 8192000000 10887236400 11362340864 1912156896 18.924 98 6 12 0 1931295376 17762784 1375696
01:13:39 120172 8192000000 10889042304 11364589568 1888241664 18.732 96 8 16 0 1907368352 16915280 2211408
01:15:51 99854 8192000000 10878138880 11348836352 1920365904 18.990 98 22 44 0 1942152992 15297776 6489312
01:17:42 69916 8192000000 10878039776 11340300288 1906669072 18.880 97 20 40 1 1919936880 7474688 5793120
01:18:58 33903 8192000000 10828658384 11303018496 1903705376 18.856 99 13 26 1 1913196048 5795568 3695104
01:19:40 47488 8192000000 10814486496 11280506880 1874352144 18.619 97 11 22 0 1884785280 7591296 2841840
01:20:38 64542 8192000000 10842331568 11320885248 1909776816 18.905 99 8 16 0 1921768512 9750336 2241360
01:21:48 21175 8192000000 10836705936 11315417088 1907149856 18.884 99 13 26 0 1921294016 10704224 3439936
01:22:16 20122 8192000000 10825061408 11289505792 1878993872 18.657 98 3 6 0 1891436816 11089888 1353056
01:22:44 94373 8192000000 10843490976 11321503744 1905589792 18.871 99 21 42 1 1918621904 7236304 5795808
01:24:27 65047 8192000000 10835747952 11293630464 1853452432 18.450 96 19 38 0 1873981072 15604032 4924608
01:25:41 29492 8192000000 10858123776 11322806272 1923752608 19.017 100 18 36 1 1939955360 11242816 4959936
01:26:22 31907 8192000000 10862904144 11321425920 1890828080 18.752 98 17 34 1 1909355936 13210944 5316912
01:27:00 11115 8192000000 9037827280 9273614336 201632960 2.402 11 2 4 0 204856800 2938896 284944

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 27-11-2020 01:28:27 to 27-11-2020 01:28:59.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 135 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-11-2020 01:29:00 to 27-11-2020 01:29:02.

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          246765
MON$OLDEST_ACTIVE               246766
MON$OLDEST_SNAPSHOT             246766
MON$NEXT_TRANSACTION            246766
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                       2025888
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.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 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 ---
--- end of diff output ---

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

27.11.20 01:29:03. 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
2020-11-27 01:29:06 No severe PSQL-related problems occured
27.11.20 01:29:07. End of report.