Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 25.01.2021 16: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 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 17082568 kB
MemAvailable 31319176 kB
Buffers 0 kB
Cached 14638176 kB
SwapCached 4868 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-25 16:27:18
DTS_END                         2021-01-25 16:27:18.2970
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/51536
TRN_ID                          249230
ATT_ID                          675
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: 9417.45 17840 1130094
customer order: creation 181.48 338 21777
customer order: refuse 15.69 333 1883
order to supplier: creation 48.47 1233 5816
order to supplier: removal 3.63 88203 436
invoice (draft): creation 48.61 3165 5833
invoice (draft): removal 54.08 706 6489
invoice accept: apply 43.84 16640 5261
invoice accept: cancel 48.12 733 5774
customer reserve: creation 4037.74 165 484529
customer reserve: removal 4622.11 54 554653
realization accept: apply 86.85 176 10422
realization accept: cancel 90.39 97 10847
payment from customer: creation 61.93 129 7431
payment from customer: removal 5.89 121 707
payment to supplier: creation 52.18 137 6262
payment to supplier: removal 3.78 76 453
service: total inventory turnovers 4.98 918 598
service: total monetary turnovers 6.83 25 819
service: aggregate perf. data 0.83 20148 100
service: refresh index statistics 0.03 223396 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 25-01-2021 16:29:38 to 25-01-2021 16:29:41.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4387
TEST_TIME 2 4456
TEST_TIME 3 3836
TEST_TIME 4 4536
TEST_TIME 5 4621
TEST_TIME 6 4472
TEST_TIME 7 5336
TEST_TIME 8 5755
TEST_TIME 9 5905
TEST_TIME 10 6088
TEST_TIME 11 6321
TEST_TIME 12 6349
TEST_TIME 13 6416
TEST_TIME 14 6703
TEST_TIME 15 7067
TEST_TIME 16 7636
TEST_TIME 17 8088
TEST_TIME 18 8809
TEST_TIME 19 8987
TEST_TIME 20 8885
TEST_TIME 21 8943
TEST_TIME 22 9683
TEST_TIME 23 10173
TEST_TIME 24 10176
TEST_TIME 25 10244
TEST_TIME 26 10279
TEST_TIME 27 10609
TEST_TIME 28 10684
TEST_TIME 29 10484
TEST_TIME 30 10324
TEST_TIME 31 10316
TEST_TIME 32 10449
TEST_TIME 33 10367
TEST_TIME 34 10483
TEST_TIME 35 10543
TEST_TIME 36 10543
TEST_TIME 37 10417
TEST_TIME 38 10211
TEST_TIME 39 10128
TEST_TIME 40 10113
TEST_TIME 41 10076
TEST_TIME 42 10052
TEST_TIME 43 10049
TEST_TIME 44 10006
TEST_TIME 45 9936
TEST_TIME 46 9934
TEST_TIME 47 10149
TEST_TIME 48 10130
TEST_TIME 49 10025
TEST_TIME 50 9982
TEST_TIME 51 9813
TEST_TIME 52 9854
TEST_TIME 53 9838
TEST_TIME 54 9727
TEST_TIME 55 9670
TEST_TIME 56 9649
TEST_TIME 57 9599
TEST_TIME 58 9541
TEST_TIME 59 9521
TEST_TIME 60 9660
TEST_TIME 61 9589
TEST_TIME 62 9636
TEST_TIME 63 9578
TEST_TIME 64 9615
TEST_TIME 65 9773
TEST_TIME 66 9779
TEST_TIME 67 9723
TEST_TIME 68 9782
TEST_TIME 69 9757
TEST_TIME 70 9766
TEST_TIME 71 9906
TEST_TIME 72 9836
TEST_TIME 73 9813
TEST_TIME 74 9852
TEST_TIME 75 9788
TEST_TIME 76 9738
TEST_TIME 77 9655
TEST_TIME 78 9665
TEST_TIME 79 9615
TEST_TIME 80 9579
TEST_TIME 81 9529
TEST_TIME 82 9482
TEST_TIME 83 9507
TEST_TIME 84 9447
TEST_TIME 85 9434
TEST_TIME 86 9463
TEST_TIME 87 9487
TEST_TIME 88 9574
TEST_TIME 89 9576
TEST_TIME 90 9550
TEST_TIME 91 9555
TEST_TIME 92 9549
TEST_TIME 93 9618
TEST_TIME 94 9669
TEST_TIME 95 9713
TEST_TIME 96 9716
TEST_TIME 97 9661
TEST_TIME 98 9628
TEST_TIME 99 9597
TEST_TIME 100 9564
TEST_TIME 101 9505
TEST_TIME 102 9449
TEST_TIME 103 9472
TEST_TIME 104 9408
TEST_TIME 105 9347
TEST_TIME 106 9345
TEST_TIME 107 9347
TEST_TIME 108 9390
TEST_TIME 109 9413
TEST_TIME 110 9431
TEST_TIME 111 9397
TEST_TIME 112 9388
TEST_TIME 113 9416
TEST_TIME 114 9493
TEST_TIME 115 9525
TEST_TIME 116 9531
TEST_TIME 117 9493
TEST_TIME 118 9540
TEST_TIME 119 9497
TEST_TIME 120 9417

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 25-01-2021 16:29:42 to 25-01-2021 16:29:46.

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 1576763 1576763 0 0.00 0 28939 6 0 0
doc_list_biud 1576763 1576763 0 0.00 0 27745 25 0 0
sp_add_invoice_to_stock 5374 5261 113 2.10 22 202824 16641 0 113
sp_cancel_adding_invoice 5774 5774 0 0.00 5 58003 734 0 0
sp_cancel_client_order 1883 1883 0 0.00 3 8996 334 0 0
sp_cancel_customer_reserve 554653 554653 0 0.00 1 26242 55 0 0
sp_cancel_pay_from_customer 707 707 0 0.00 2 7470 122 0 0
sp_cancel_pay_to_supplier 453 453 0 0.00 2 2876 76 0 0
sp_cancel_supplier_invoice 6502 6489 13 0.19 2 12911 706 0 13
sp_cancel_supplier_order 436 436 0 0.00 7 1050453 88204 0 0
sp_cancel_write_off 10847 10847 0 0.00 1 9578 98 0 0
sp_client_order 21777 21777 0 0.00 3 23096 338 0 0
sp_customer_reserve 484529 484529 0 0.00 0 35895 165 0 0
sp_fill_shopping_cart 33409 33409 0 0.00 1 18599 40 0 0
sp_fill_shopping_cart_clo_res 484529 484529 0 0.00 0 13955 12 0 0
sp_get_clo_for_invoice 5261 5261 0 0.00 0 30918 251 0 0
sp_kill_cost_storno 17781 17781 0 0.00 0 9575 53 0 0
sp_kill_qstorno_ret_qs2qd 1127078 1127078 0 0.00 0 26238 30 0 0
sp_kill_qty_storno 595765 595765 0 0.00 0 27742 64 0 0
sp_lock_selected_doc 21861 21861 0 0.00 0 7907 6 0 0
sp_make_cost_storno 29376 29376 0 0.00 0 28349 52 0 0
sp_multiply_rows_for_pdistr 29376 29376 0 0.00 0 9562 29 0 0
sp_multiply_rows_for_qdistr 21777 21777 0 0.00 0 22663 147 0 0
sp_pay_from_customer 7431 7431 0 0.00 4 16222 130 0 0
sp_pay_to_supplier 6262 6262 0 0.00 5 17480 138 0 0
sp_payment_common 13693 13693 0 0.00 2 16506 39 0 0
sp_qd_handle_on_cancel_clo 1883 1883 0 0.00 0 8990 300 0 0
sp_qd_handle_on_invoice_upd_sts 11035 11035 0 0.00 0 27735 306 0 0
sp_qd_handle_on_reserve_upd_sts 10422 10422 0 0.00 0 15097 62 0 0
sp_reserve_write_off 10422 10422 0 0.00 6 15229 176 0 0
sp_supplier_invoice 5833 5833 0 0.00 7 105285 3166 0 0
sp_supplier_order 5816 5816 0 0.00 4 22801 1233 0 0
srv_aggregate_perf_data 100 100 0 0.00 2723 379211 20149 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1518 159644 31906 0 0
srv_find_qd_qs_mism 1078845 1078845 0 0.00 0 18802 5 0 0
srv_make_invnt_saldo 598 598 0 0.00 37 48611 918 0 0
srv_make_money_saldo 819 819 0 0.00 1 3389 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 148581 366673 223396 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5261 5261 0 0.00 0 29757 173 0 0
t$perf-norm:sp_cancel_adding_invoice 428 428 0 0.00 1 2819 83 0 0
t$perf-norm:sp_cancel_client_order 1883 1883 0 0.00 0 4621 20 0 0
t$perf-norm:sp_cancel_customer_reserve 750 750 0 0.00 0 1322 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 707 707 0 0.00 0 1914 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 453 453 0 0.00 0 1108 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 439 439 0 0.00 0 2261 28 0 0
t$perf-norm:sp_cancel_supplier_order 436 436 0 0.00 0 32936 1511 0 0
t$perf-norm:sp_cancel_write_off 1082 1082 0 0.00 0 7212 16 0 0
t$perf-norm:sp_client_order 21777 21777 0 0.00 0 15706 19 0 0
t$perf-norm:sp_customer_reserve 1067 1067 0 0.00 0 3055 13 0 0
t$perf-norm:sp_pay_from_customer 7431 7431 0 0.00 0 8694 12 0 0
t$perf-norm:sp_pay_to_supplier 6262 6262 0 0.00 0 6639 9 0 0
t$perf-norm:sp_reserve_write_off 10422 10422 0 0.00 0 8741 12 0 0
t$perf-norm:sp_supplier_invoice 5833 5833 0 0.00 0 7555 22 0 0
t$perf-norm:sp_supplier_order 5816 5816 0 0.00 0 5620 19 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 1708 19 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 1295 14 0 0
t$perf-norm:srv_make_invnt_saldo 598 598 0 0.00 0 632 20 0 0
t$perf-norm:srv_make_money_saldo 819 819 0 0.00 0 2139 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 10748 10522 226 2.10 0 6351 19 0 226
v_all_customers 40018 40018 0 0.00 0 90 1 0 0
v_all_suppliers 32424 32424 0 0.00 0 118 1 0 0
v_all_wares 43554 43554 0 0.00 0 39 1 0 0
v_cancel_adding_invoice 856 856 0 0.00 0 971 6 0 0
v_cancel_client_order 3766 3766 0 0.00 0 3331 8 0 0
v_cancel_customer_prepayment 1414 1414 0 0.00 0 4667 13 0 0
v_cancel_customer_reserve 1500 1500 0 0.00 0 1291 4 0 0
v_cancel_payment_to_supplier 906 906 0 0.00 0 2842 11 0 0
v_cancel_supplier_invoice 904 878 26 2.87 0 1912 19 0 26
v_cancel_supplier_order 872 872 0 0.00 0 2626 8 0 0
v_cancel_write_off 2164 2164 0 0.00 0 2641 17 0 0
v_max_id_clo_ord 5812 5812 0 0.00 0 1030 1 0 0
v_max_id_clo_res 1067 1067 0 0.00 0 3138 12 0 0
v_max_id_ord_sup 5819 5819 0 0.00 0 7034 4 0 0
v_max_non_paid_invoice 1681 1681 0 0.00 0 1263 3 0 0
v_max_non_paid_realizn 3835 3835 0 0.00 0 3841 6 0 0
v_min_id_clo_ord 5812 5812 0 0.00 0 12931 10 0 0
v_min_id_clo_res 1067 1067 0 0.00 0 5609 15 0 0
v_min_id_ord_sup 5819 5819 0 0.00 0 10388 13 0 0
v_min_non_paid_invoice 6262 6262 0 0.00 0 16502 27 0 0
v_min_non_paid_realizn 7431 7431 0 0.00 0 16214 28 0 0
v_our_firm 10728 10728 0 0.00 0 35 1 0 0
v_reserve_write_off 20844 20844 0 0.00 0 3332 7 0 0
x_lock_depdocs_on_canc_invoice 11824 11824 0 0.00 0 22132 105 0 0
x_lock_depdocs_on_canc_sup_ord 436 436 0 0.00 0 5189 299 0 0
x_make_qstorno_1000_1200 5816 5816 0 0.00 2 22776 1149 0 0
x_make_qstorno_1200_2000 5833 5833 0 0.00 3 105258 3021 0 0
x_make_qstorno_2100_3300 484529 484529 0 0.00 0 35894 150 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-01-2021 16:29:47 to 25-01-2021 16:29:51.

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
13:57:17 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:23 9536 8192000000 10203925264 10508181504 917171488 10.068 72 60 119 0 939368992 2478256 19719248
13:57:42 20945 8192000000 10322713568 10637058048 1369778384 14.325 100 83 167 0 1401172176 4256448 27137344
13:58:12 17697 8192000000 10353494224 10674044928 1416972640 14.746 100 91 182 1 1453294528 5651776 30670112
13:58:39 16782 8192000000 10380044688 10705190912 1438361104 14.935 100 85 170 1 1472649568 6460384 27828080
13:59:09 16212 8192000000 10419026240 10744463360 1467329792 15.190 100 92 184 0 1504678688 7396208 29952688
13:59:33 20152 8192000000 10429536672 10760974336 1478245168 15.286 100 88 176 0 1515084000 8252640 28586192
14:00:07 18378 8192000000 10443679280 10777370624 1497830208 15.457 100 88 176 0 1535125616 8843056 28452352
14:00:37 27189 8192000000 10458581584 10796007424 1516374672 15.619 100 88 176 0 1553737024 9212544 28149808
14:01:15 12804 8192000000 10477783376 10819006464 1531362592 15.749 100 85 171 1 1567476880 9427760 26686528
14:01:47 9582 8192000000 10510098656 10857947136 1565647040 16.045 100 87 174 0 1602416736 10102608 26667088
14:02:10 16567 8192000000 10528478480 10880405504 1584433264 16.206 100 81 162 0 1619900608 10624736 24842608
14:02:34 15486 8192000000 10560614048 10917543936 1615071136 16.468 100 72 144 1 1647571936 11090128 21410672
14:03:00 10041 8192000000 10584021648 10946240512 1638802464 16.670 100 78 156 1 1673218576 11383312 23032800
14:03:21 12027 8192000000 10600530080 10963808256 1652011936 16.781 100 78 154 0 1687038272 12322736 22703600
14:03:41 10031 8192000000 10601508992 10968256512 1666297584 16.902 100 79 156 0 1701453568 12263408 22892576
14:03:59 8152 8192000000 10618229776 10992836608 1686062976 17.068 100 75 150 2 1719132032 11182128 21886928
14:04:17 11292 8192000000 10661504800 11033034752 1715616624 17.316 100 80 160 1 1750794784 12630752 22547408
14:04:35 7770 8192000000 10677220240 11048656896 1731222480 17.446 100 81 162 0 1766771936 12847568 22701888
14:04:49 6113 8192000000 10683119088 11059605504 1743737904 17.550 100 83 166 0 1779884064 12623792 23522368
14:05:02 8109 8192000000 10693832544 11073585152 1756582176 17.656 100 79 157 2 1791697136 13047088 22067872
14:05:18 4837 8192000000 10705826288 11083943936 1764820496 17.724 100 85 169 1 1801803744 12971984 24011264
14:05:29 3058 8192000000 10709162912 11088945152 1773011088 17.792 100 86 167 1 1810846416 13865424 23969904
14:05:39 5391 8192000000 10713821184 11098177536 1778745136 17.839 100 82 163 0 1815423696 14312864 22365696
14:05:54 4089 8192000000 10733379792 11115384832 1793648512 17.962 100 85 170 1 1830676208 12534080 24493616
14:06:06 4247 8192000000 10750263664 11134201856 1805158704 18.056 100 87 172 0 1843263872 13990096 24115072
14:06:16 4691 8192000000 10759510064 11143520256 1817487440 18.157 100 83 166 0 1854698288 14061424 23149424
14:06:28 3001 8192000000 10760346432 11145990144 1818121088 18.162 100 90 178 1 1857248816 14170848 24956880
14:06:38 2273 8192000000 10763655088 11148812288 1827764784 18.241 100 85 168 1 1865105728 14079664 23261280
14:06:46 9033 8192000000 10767982704 11153928192 1827494720 18.239 100 85 170 0 1866227744 15406176 23326848
14:07:03 6151 8192000000 10767596848 11160690688 1830573376 18.264 100 86 172 0 1869299552 15155424 23570752
14:07:15 1876 8192000000 10784426944 11171196928 1843682384 18.371 100 92 182 2 1883849472 14049248 26117840
14:07:23 1851 8192000000 10790936288 11181355008 1849595696 18.419 100 94 185 3 1889487024 13626560 26264768
14:07:31 1619 8192000000 10800616832 11185725440 1856223040 18.473 100 90 177 0 1893837264 13144080 24470144
14:07:39 2007 8192000000 10802746288 11191345152 1856225808 18.473 100 87 174 2 1893568736 13153488 24189440
14:07:47 1469 8192000000 10809219568 11195432960 1865140368 18.545 100 89 179 0 1902871856 12728176 25003312
14:07:55 1674 8192000000 10801668752 11193171968 1861945360 18.519 100 93 184 1 1901042288 12967296 26129632
14:08:03 1642 8192000000 10803137952 11194978304 1862025072 18.520 100 79 154 2 1896262160 12142624 22094464
14:08:12 1828 8192000000 10817991328 11206729728 1869499776 18.580 100 93 186 0 1908469424 12334256 26635392
14:08:20 3574 8192000000 10815070688 11207114752 1873571920 18.613 100 94 189 4 1913768368 12726624 27469824
14:08:30 2610 8192000000 10814243328 11212476416 1871915376 18.600 100 80 160 1 1909480192 15128320 22436496
14:08:39 1750 8192000000 10803100752 11210096640 1877108112 18.642 100 61 120 0 1906262784 12795136 16359536
14:08:47 2087 8192000000 10819661616 11222454272 1879973088 18.665 100 78 157 2 1913853648 11483872 22396688
14:08:57 11597 8192000000 10785058896 11197075456 1871769824 18.599 100 25 47 1 1884881568 6738288 6373456
14:09:15 50495 8192000000 10823699584 11224469504 1881595520 18.678 100 59 120 1 1905735840 5939168 18201152
14:10:11 15955 8192000000 10787903632 11220082688 1878400768 18.652 100 33 66 1 1895944544 8157680 9386096
14:10:33 1585 8192000000 10811389184 11223642112 1884195856 18.699 100 49 99 1 1904419440 5318384 14905200
14:10:44 5199 8192000000 10802708576 11222351872 1880897120 18.672 100 32 64 1 1895301360 5539696 8864544
14:10:55 6518 8192000000 10803866528 11228422144 1880221296 18.667 100 25 49 2 1896945056 9311520 7412240
14:11:10 4600 8192000000 10796657472 11222020096 1885340464 18.708 100 30 60 2 1900062592 6045360 8676768
14:11:21 3383 8192000000 10801382272 11234140160 1888254928 18.732 100 34 69 1 1904866736 7561280 9050528
14:11:31 5259 8192000000 10802355616 11234050048 1890371616 18.749 100 31 62 0 1906187328 6969616 8846096
14:11:46 7209 8192000000 10816423680 11240689664 1895405776 18.789 100 33 66 2 1912112832 6649040 10058016
14:12:04 4866 8192000000 10816091712 11241783296 1894437040 18.782 100 25 50 2 1907479168 6139424 6902704
14:12:15 6156 8192000000 10817558032 11241730048 1896254752 18.796 100 32 64 2 1912686912 6640736 9791424
14:12:29 8870 8192000000 10807909728 11239940096 1893976576 18.778 100 14 27 0 1903155312 5693360 3485376
14:12:46 11463 8192000000 10811194672 11245625344 1898731216 18.816 100 17 35 0 1909366448 6071488 4563744
14:13:06 6863 8192000000 10814450368 11244797952 1900517840 18.830 100 15 30 0 1910113776 5313440 4282496
14:13:21 6437 8192000000 10816029584 11246022656 1901830720 18.841 100 33 66 1 1917745616 6345504 9569392
14:13:35 6504 8192000000 10819297664 11248476160 1900453808 18.830 100 24 48 0 1914119328 6014272 7651248
14:13:50 11473 8192000000 10816049808 11244109824 1900633616 18.831 100 20 38 1 1911294352 4441424 6219312
14:14:07 74151 8192000000 10808594704 11249197056 1904064544 18.859 100 31 60 4 1918694720 5444032 9186144
14:15:31 7819 8192000000 10838634304 11264585728 1909293376 18.901 100 17 34 0 1919937616 5945664 4698576
14:15:46 4571 8192000000 10850712112 11271524352 1916365024 18.958 100 58 116 0 1945792448 13264816 16162608
14:15:59 4829 8192000000 10832931312 11258572800 1894927568 18.785 99 48 96 0 1916841376 7949904 13963904
14:16:13 5076 8192000000 10827697552 11253526528 1890300432 18.748 99 37 74 2 1908000176 7023808 10675936
14:16:25 6002 8192000000 10821448864 11250405376 1887500736 18.726 99 38 76 1 1905652992 7057296 11094960
14:16:39 7925 8192000000 10797931568 11230846976 1860242464 18.505 98 42 83 2 1878329712 6528912 11558336
14:16:54 7848 8192000000 10791578800 11217838080 1833472640 18.288 97 26 52 1 1846689632 5302400 7914592
14:17:10 5999 8192000000 10779791456 11204558848 1856201168 18.472 98 32 62 3 1872510688 6322912 9986608
14:17:22 5701 8192000000 10779011056 11201085440 1840510752 18.345 98 28 56 1 1858778528 10389104 7878672
14:17:35 5747 8192000000 10788584480 11215904768 1854558720 18.459 99 21 41 0 1865070544 4756320 5755504
14:17:50 8417 8192000000 10788736944 11223793664 1867316096 18.563 99 33 67 4 1886116208 10172800 8627312
14:18:05 13221 8192000000 10755236064 11185500160 1761244784 17.695 94 14 28 0 1770803568 5669408 3889376
14:18:28 4087 8192000000 10748887472 11170988032 1820215616 18.179 99 31 61 2 1835637936 7151808 8270512
14:18:45 63832 8192000000 10727547504 11136008192 1748661520 17.590 96 34 68 0 1764468896 5240256 10567120
14:19:55 7462 8192000000 10697900384 11117387776 1729343328 17.430 96 28 56 0 1744311376 7383120 7584928
14:20:10 7636 8192000000 10685875488 11107336192 1708678688 17.258 95 26 52 2 1722416624 6397056 7340880
14:20:25 3807 8192000000 10680451648 11091349504 1720446928 17.356 96 42 84 1 1740299328 7453504 12398896
14:20:37 7782 8192000000 10680047152 11093565440 1691159920 17.111 95 31 63 1 1705556080 6150656 8245504
14:20:53 5124 8192000000 10698057664 11107799040 1750070944 17.602 99 26 52 2 1762636448 5578528 6986976
14:21:04 8512 8192000000 10698065760 11114835968 1768275360 17.753 99 29 59 0 1782880704 6031104 8574240
14:21:18 9449 8192000000 10696079056 11107184640 1771654272 17.781 99 23 46 0 1784231312 5501312 7075728
14:21:36 6015 8192000000 10680497680 11093626880 1763391504 17.712 99 19 38 2 1775068832 6165840 5511488
14:21:49 7295 8192000000 10702223200 11115761664 1771769008 17.782 99 17 34 0 1781824928 5187936 4867984
14:22:05 4021 8192000000 10726140544 11138072576 1794958944 17.973 100 19 37 1 1809519088 9649728 4910416
14:22:16 6020 8192000000 10730200192 11143696384 1812730032 18.118 100 27 55 0 1825347344 5289088 7328224
14:22:30 7757 8192000000 10739613856 11156992000 1821960864 18.194 100 34 67 2 1841951696 9501040 10489792
14:22:43 8087 8192000000 10739594496 11157954560 1808607584 18.084 99 27 54 2 1822505936 5261296 8637056
14:22:59 7923 8192000000 10740800800 11165130752 1825708752 18.224 100 37 74 1 1847589936 10874256 11006928
14:23:15 11257 8192000000 10744965968 11169947648 1833132016 18.285 100 23 46 1 1845258320 5628000 6498304
14:23:39 65232 8192000000 10745395328 11180699648 1849754464 18.420 100 47 94 2 1870349168 6403504 14191200
14:24:50 8798 8192000000 10749058592 11182088192 1843962384 18.373 100 20 40 0 1856447168 5912064 6572720
14:25:10 11446 8192000000 10776758816 11192090624 1849376528 18.417 100 30 62 1 1864802496 6941088 8484880
14:25:31 6804 8192000000 10777144656 11198087168 1856943280 18.478 100 33 65 1 1872751520 6312928 9495312
14:25:44 11022 8192000000 10770238672 11195613184 1857141152 18.480 100 16 33 0 1867200960 5226144 4833664
14:26:01 8738 8192000000 10775300192 11204812800 1863172576 18.529 100 30 60 1 1878173168 6188640 8811952
14:26:16 8762 8192000000 10786823856 11211038720 1865133776 18.545 100 24 48 2 1877332512 5817728 6381008
14:26:32 9001 8192000000 10778226800 11209519104 1870399216 18.588 100 25 51 0 1884578224 6943136 7235872
14:26:47 9182 8192000000 10787671152 11214237696 1869461440 18.580 100 17 34 0 1880164288 5020512 5682336
14:27:02 13443 8192000000 10803846240 11230642176 1890936128 18.753 100 29 58 1 1908191856 8937136 8318592
14:27:26 26496 8192000000 10827385520 11249606656 1904951728 18.866 100 43 84 2 1923231504 5672704 12607072
14:28:00 12533 8192000000 10848911296 11264159744 1915917792 18.954 100 57 112 2 1939587168 7846928 15822448
14:28:21 27328 8192000000 10860776352 11282796544 1921880880 19.002 100 48 94 2 1943885664 8926864 13077920
14:29:00 129570 8192000000 10869012160 11304054784 1934604352 19.104 100 40 79 3 1958991488 11906000 12481136
14:31:18 62967 8192000000 10864665840 11312373760 1943615872 19.176 100 36 70 2 1967344080 12685312 11042896
14:32:30 18060 8192000000 10894143312 11321851904 1955255648 19.268 100 49 96 2 1984035568 14193824 14586096
14:32:58 13386 8192000000 10893452176 11330011136 1954460224 19.262 100 43 85 1 1985985344 19144672 12380448
14:33:27 30605 8192000000 10911417024 11340210176 1940464480 19.150 99 36 72 1 1973775392 22496688 10814224
14:34:05 16242 8192000000 10910051008 11337977856 1962203344 19.324 100 38 75 2 1991172304 17679344 11289616
14:34:31 4928 8192000000 10911003584 11343433728 1967857888 19.368 100 47 95 1 1999940864 17826656 14256320
14:34:46 12158 8192000000 10927464672 11352133632 1974344080 19.420 100 57 109 4 2007224928 15960560 16920288
14:35:08 2713 8192000000 10929997584 11357655040 1981139264 19.474 100 57 113 2 2016939184 18776128 17023792
14:35:19 9872 8192000000 10932078992 11360911360 1983217680 19.490 100 65 131 1 2022883216 18955488 20710048
14:35:36 6866 8192000000 10941396752 11364282368 1983679648 19.494 100 57 115 2 2019955744 18888512 17387584
14:35:52 8860 8192000000 10944302272 11372118016 1989515392 19.540 100 59 118 2 2024855184 18124224 17215568
14:36:09 6103 8192000000 10963040992 11381387264 2001811024 19.637 100 78 155 0 2046919264 22926352 22181888
14:36:26 3635 8192000000 10971901200 11390300160 2007621792 19.683 100 68 136 1 2051906304 24532032 19752480
14:36:36 8006 8192000000 10960838144 11380535296 2000896176 19.630 100 70 136 1 2046442320 25478480 20067664
14:36:53 6766 8192000000 10955008912 11381985280 2002122336 19.639 100 68 130 1 2046699984 24058768 20518880
14:37:08 7319 8192000000 10955982416 11388997632 2007018784 19.678 100 65 129 3 2052597600 25050768 20528048
14:37:24 4995 8192000000 10968596752 11394875392 2008463520 19.689 100 64 127 1 2053598688 25326752 19808416
14:37:38 5954 8192000000 10973314480 11403038720 2010628128 19.706 100 62 123 0 2059709504 30430112 18651264
14:37:56 9276 8192000000 10959053408 11396907008 2014884224 19.740 100 51 102 0 2054233664 23888688 15460752
14:38:17 8021 8192000000 10963383504 11401396224 2019009280 19.772 100 54 108 0 2054479216 18784800 16685136
14:38:34 6660 8192000000 10962234080 11402334208 2018869360 19.771 100 47 94 2 2053337024 19290096 15177568
14:38:51 4803 8192000000 10969869488 11400843264 2003094672 19.647 99 63 124 0 2042209408 20196576 18918160
14:39:04 11624 8192000000 10959447040 11392671744 1997442208 19.603 99 60 120 2 2037097856 21579536 18076112
14:39:23 4673 8192000000 10970918992 11399573504 2015514960 19.745 100 67 133 1 2059099024 22962400 20621664
14:39:35 3462 8192000000 10949824160 11371704320 1972865504 19.408 98 63 128 0 2014339136 22375168 19098464
14:39:44 1982 8192000000 10965934512 11388108800 2003579760 19.651 100 82 162 0 2051643904 22801984 25262160
14:39:55 1995 8192000000 10957858528 11383926784 1987226288 19.522 99 64 128 2 2029715616 23454976 19034352
14:40:04 2488 8192000000 10946372224 11365310464 1981587344 19.477 99 72 145 0 2026955040 23867648 21500048
14:40:13 5341 8192000000 10955712512 11368370176 1988493856 19.532 100 75 150 0 2037558320 26109088 22955376
14:40:25 3684 8192000000 10960841776 11371094016 1981034160 19.473 99 81 161 1 2031334672 26786048 23514464
14:40:36 2597 8192000000 10962247072 11380424704 1993451296 19.571 100 80 160 0 2049685200 32193440 24040464
14:40:47 3794 8192000000 10974614144 11388755968 2001431600 19.634 100 77 154 2 2052895216 27567728 23895888
14:40:58 6396 8192000000 10966393376 11384115200 1996353072 19.594 100 79 157 1 2048035216 27331200 24350944
14:41:12 5800 8192000000 10960227328 11386478592 1998594112 19.612 100 73 146 0 2051024256 29890256 22539888
14:41:27 6386 8192000000 10949249824 11366543360 1985695184 19.510 100 69 138 0 2034720752 27837872 21187696
14:41:41 2838 8192000000 10927297104 11343478784 1944149904 19.180 98 73 143 1 1994752240 27844960 22757376
14:41:53 3207 8192000000 10947467056 11359813632 1970446624 19.389 100 88 176 1 2028250336 29706496 28097216
14:42:03 2391 8192000000 10960145840 11369828352 1963953120 19.337 99 86 170 0 2022171584 31254112 26964352
14:42:16 5868 8192000000 10951309616 11374977024 1982468128 19.484 100 67 134 2 2034457760 30576272 21413360
14:42:30 2661 8192000000 10932453392 11349868544 1952355152 19.245 98 70 138 2 2003932384 29614912 21962320
14:42:39 1683 8192000000 10955047296 11367739392 1977900272 19.448 100 91 182 1 2036029040 30742080 27386688
14:42:49 2607 8192000000 10950461440 11368259584 1979289520 19.459 100 85 168 3 2035179744 31050240 24839984
14:42:59 1516 8192000000 10957501344 11372072960 1979601040 19.462 100 88 176 2 2039596672 31902864 28092768
14:43:08 3701 8192000000 10943586416 11353243648 1965680752 19.351 99 83 166 0 2024610512 33865760 25064000
14:43:18 1914 8192000000 10961224816 11378253824 1983277328 19.491 100 86 172 1 2045251152 34801120 27172704
14:43:26 3444 8192000000 10950326752 11361116160 1966248464 19.356 99 80 160 1 2027534048 36720320 24565264
14:43:39 1927 8192000000 10953735360 11362996224 1968295680 19.372 100 85 172 0 2030301376 35616080 26389616
14:43:48 11385 8192000000 10922222912 11359010816 1952349952 19.245 99 42 84 1 1999475504 33671200 13454352
14:44:06 8365 8192000000 10923928432 11361738752 1947635408 19.208 99 50 100 0 2002690560 38635536 16419616
14:44:22 6077 8192000000 10878900560 11310649344 1910918848 18.914 98 47 94 1 1957249712 31162736 15168128
14:44:36 6087 8192000000 10923038256 11347095552 1951637632 19.240 100 54 107 1 2001873968 32727264 17509072
14:44:53 2558 8192000000 10927326816 11350118400 1959919488 19.305 100 76 151 1 2017730512 34425632 23385392
14:45:03 2290 8192000000 10920656816 11328909312 1942656288 19.168 99 84 168 0 2000293280 32036816 25600176
14:45:12 5148 8192000000 10920020928 11347615744 1953215232 19.252 100 77 153 1 2011004208 32967616 24821360
14:45:23 6188 8192000000 10886481168 11319394304 1904597440 18.863 98 53 106 0 1948182112 27256720 16327952
14:45:39 4970 8192000000 10892750864 11315810304 1916954416 18.962 99 62 124 3 1965345040 28863200 19527424
14:45:51 3714 8192000000 10893552256 11319476224 1931401264 19.078 100 64 126 0 1982794320 32348816 19044240
14:46:19 16305 8192000000 10897555104 11333824512 1939353152 19.142 100 30 60 2 1980291136 30928256 10009728
14:46:58 18225 8192000000 10901860672 11333423104 1931126384 19.076 99 37 74 0 1971025568 27471296 12427888
14:47:22 8012 8192000000 10877191920 11318538240 1916045024 18.955 99 42 84 1 1959552464 29668144 13839296
14:47:55 6080 8192000000 10884086496 11317186560 1908221936 18.892 99 38 75 0 1953390816 31995184 13173696
14:48:08 5739 8192000000 10896880800 11323211776 1926579920 19.040 100 54 107 0 1979024304 34838400 17605984
14:48:21 6190 8192000000 10915535024 11344424960 1939108688 19.140 100 56 112 3 1995312688 37452208 18751792
14:48:34 12009 8192000000 10880354336 11311116288 1909945584 18.906 100 40 78 1 1961109040 37674336 13489120
14:48:58 7920 8192000000 10905095856 11333066752 1926038448 19.035 100 48 95 2 1981507840 39803248 15666144
14:49:14 13195 8192000000 10911890640 11343118336 1936906032 19.122 100 41 82 1 1989241280 38785136 13550112
14:49:38 17842 8192000000 10876734256 11316301824 1900205408 18.828 98 28 56 2 1940309824 30384464 9719952
14:50:03 10454 8192000000 10868667680 11322200064 1903086192 18.851 99 20 40 0 1939148800 28519856 7542752
14:50:31 27481 8192000000 10876989664 11326930944 1931551328 19.079 100 22 44 1 1962830816 23947936 7331552
14:51:18 29895 8192000000 10875137968 11336105984 1941602304 19.160 100 27 55 3 1970173712 19712576 8858832
14:52:08 18843 8192000000 10887151104 11342893056 1948144848 19.212 100 20 40 0 1970705024 16897440 5662736
14:52:36 5109 8192000000 10881808128 11335282688 1938977456 19.139 100 15 30 0 1964733792 20679280 5077056
14:52:47 14801 8192000000 10833824448 11294068736 1861322368 18.514 97 10 20 0 1883267776 18693056 3252352
14:53:09 31262 8192000000 10844027152 11293691904 1875132944 18.626 99 9 17 1 1898802896 20578320 3091632
14:54:05 104538 8192000000 10843777264 11308294144 1891909184 18.761 99 9 18 0 1916963664 22437936 2616544
14:55:57 76701 8192000000 10858178608 11310436352 1870297520 18.587 97 11 22 0 1891834000 18319680 3216800
14:57:23 60909 8192000000 10864140288 11318099968 1903106000 18.851 99 20 40 0 1926433504 17996864 5330640
14:58:53 57792 8192000000 10865753360 11321569280 1914965024 18.946 99 11 22 1 1932478960 14689792 2824144
15:00:03 71651 8192000000 10895073088 11342393344 1952010272 19.242 100 27 52 2 1967387728 7647488 7729968
15:01:23 30839 8192000000 10875733056 11329855488 1921197888 18.996 98 25 51 1 1940644768 12095936 7350944
15:02:08 52155 8192000000 10873812352 11333660672 1933722368 19.097 99 10 20 1 1945840096 9580368 2537360
15:03:06 80012 8192000000 10892630976 11334078464 1930926224 19.074 99 16 30 3 1947276112 11749088 4600800
15:04:34 87956 8192000000 10892820736 11345035264 1950615712 19.231 100 24 47 1 1965890160 7805968 7468480
15:06:13 17650 8192000000 10898077632 11349716992 1961310848 19.316 100 34 68 1 1977915520 7238576 9366096
15:06:42 14168 8192000000 10917558976 11358134272 1971581936 19.398 100 55 110 2 1997514816 10713152 15219728
15:07:07 31066 8192000000 10911694128 11369558016 1977340480 19.444 100 51 102 1 2006057920 14229088 14488352
15:07:45 80025 8192000000 10911605776 11375857664 1977438944 19.444 100 25 50 3 2010103536 24595136 8069456
15:09:18 17119 8192000000 10914910208 11379011584 1980169888 19.466 100 13 26 1 1996280704 12413904 3696912
15:09:50 11013 8192000000 10937496848 11389829120 1993898848 19.575 100 41 83 0 2017202656 11884272 11419536
15:10:12 1552 8192000000 10951024256 11370860544 1981506592 19.477 99 75 149 2 2018292112 15277984 21507536
15:10:21 8835 8192000000 10939970464 11390459904 1995826224 19.590 100 54 108 1 2027339872 16463504 15050144
15:10:42 74719 8192000000 10923939824 11393257472 1968497632 19.374 99 21 42 0 1993455696 19341280 5616784
15:12:10 35965 8192000000 10957203024 11403935744 2004362256 19.657 100 33 66 1 2032200704 18013536 9824912
15:12:53 30445 8192000000 10952778928 11412291584 2008034560 19.686 100 48 94 1 2042506384 19935312 14536512
15:13:49 47839 8192000000 10928120912 11401162752 1977542416 19.445 99 15 30 0 2004349344 21715664 5091264
15:14:59 33631 8192000000 10916378656 11390156800 1973642544 19.414 99 8 16 0 1992980928 17092320 2246064
15:16:43 33635 8192000000 10907492288 11383398400 1970326592 19.388 99 11 22 1 1983414176 9681536 3406048
15:17:35 85495 8192000000 10926861376 11397808128 1994859088 19.582 100 21 42 0 2010719600 9333648 6526864
15:19:25 80732 8192000000 10875662176 11347107840 1930477072 19.071 97 19 38 0 1945023120 9128432 5417616
15:21:51 35036 8192000000 10894751936 11359281152 1925840256 19.034 97 28 56 1 1943877200 9951424 8085520
15:22:37 53267 8192000000 10890428720 11354923008 1938615648 19.136 98 14 28 1 1955725008 12981008 4128352
15:23:58 61231 8192000000 10888532976 11370704896 1941683472 19.160 98 12 24 1 1957960784 12629776 3647536
15:25:41 17744 8192000000 10901318864 11349393408 1942783856 19.169 99 54 105 0 1967177936 8965168 15428912
15:26:10 19565 8192000000 10868735296 11334750208 1932529456 19.087 99 30 60 2 1952986656 10575952 9881248
15:26:37 60636 8192000000 10865988064 11340222464 1892297648 18.764 97 17 34 1 1912819216 15525120 4996448
15:27:48 74051 8192000000 10845567520 11314622464 1841995584 18.357 95 11 22 1 1855606928 10684624 2926720
15:29:09 50201 8192000000 10851352960 11329499136 1908057984 18.891 98 25 50 0 1923423312 8291488 7073840
15:30:10 11044 8192000000 10878457152 11335163904 1931888912 19.082 99 28 56 1 1949144464 8959936 8295616
15:30:32 30243 8192000000 10872290928 11323924480 1875675536 18.630 96 30 60 1 1898009120 13845744 8487840
15:31:09 49100 8192000000 10845612688 11304681472 1859638912 18.500 96 27 55 2 1885147136 17645920 7862304
15:32:12 70191 8192000000 10867481632 11339333632 1929525824 19.063 100 13 26 1 1944586224 11558736 3501664
15:33:29 51100 8192000000 10864863520 11312918528 1872894752 18.608 96 21 42 3 1890301696 11833696 5573248
15:34:27 26237 8192000000 10875660272 11306348544 1873735248 18.614 97 43 86 3 1901769536 16076160 11958128
15:34:59 31250 8192000000 10871993888 11327066112 1929412304 19.062 100 40 79 0 1954955904 14774448 10769152
15:35:39 21836 8192000000 10866557808 11312041984 1905982400 18.874 99 37 72 1 1930668112 14658928 10026784
15:36:08 18299 8192000000 10854199648 11299852288 1879516640 18.661 98 42 84 1 1902185552 11239392 11429520
15:36:36 21161 8192000000 10881533328 11323609088 1909870944 18.906 99 50 99 1 1938265216 14705392 13688880
15:37:09 27343 8192000000 10883726112 11335970816 1940083088 19.147 100 37 74 1 1966451488 15839200 10529200
15:37:44 40686 8192000000 10833790720 11314274304 1837516288 18.321 95 15 30 0 1856674736 14720912 4437536
15:38:35 38932 8192000000 10815513504 11271852032 1822325312 18.197 96 9 19 0 1836350800 11415040 2610448
15:39:20 23213 8192000000 10839382896 11285315584 1889540080 18.742 99 25 50 3 1904771328 7744416 7486832
15:39:53 25623 8192000000 10856202624 11287076864 1854715776 18.460 97 50 100 0 1879236128 10795264 13725088
15:40:28 23046 8192000000 10887194368 11323813888 1924951024 19.026 100 57 114 0 1953573648 13010800 15611824
15:40:58 18708 8192000000 10877727584 11318992896 1908983920 18.898 99 51 102 0 1937617168 14684224 13949024
15:41:28 63789 8192000000 10853898976 11307352064 1888523840 18.734 98 35 70 1 1911588256 13364016 9700400
15:42:43 61401 8192000000 10847219536 11310911488 1923401696 19.014 100 20 40 1 1936764192 7697184 5665312
15:43:56 39634 8192000000 10855810224 11313594368 1911120288 18.916 99 25 50 1 1925505472 6929328 7455856
15:44:43 77301 8192000000 10828346816 11307593728 1875553088 18.629 97 31 60 2 1894895968 10114144 9228736
15:46:40 55190 8192000000 10852096096 11310198784 1897507744 18.806 99 6 12 0 1910088576 11044672 1536160
15:47:41 66443 8192000000 10814602368 11286237184 1843208896 18.367 96 8 15 0 1855943456 10967696 1766864
15:48:54 61702 8192000000 10855131712 11326005248 1898895664 18.817 99 22 44 1 1919458144 13840688 6721792
15:50:05 74778 8192000000 10858687648 11335270400 1929514880 19.063 100 10 20 0 1939806816 7833312 2458624
15:51:26 37645 8192000000 10887044256 11341295616 1927755664 19.049 99 22 44 1 1946226176 12232688 6237824
15:52:15 76040 8192000000 10888653312 11364151296 1933648912 19.096 99 19 38 2 1953948272 14757696 5541664
15:53:37 63619 8192000000 10895676336 11368701952 1959027328 19.298 100 19 38 0 1986331952 21645376 5659248
15:55:31 96960 8192000000 10871991728 11336638464 1938000512 19.131 99 11 22 0 1950329648 9686976 2642160
15:57:29 54470 8192000000 10897135040 11365404672 1940008864 19.147 98 23 45 1 1954947904 8893840 6045200
15:58:33 102330 8192000000 10914478256 11387822080 1946484032 19.198 98 10 20 0 1960420672 10590912 3345728
16:00:22 73212 8192000000 10911322256 11399569408 1979154928 19.458 100 9 18 0 1996272976 14887184 2230864
16:01:43 91552 8192000000 10917893280 11395846144 1932287648 19.085 97 10 20 1 1950865760 15699632 2878480
16:03:24 159643 8192000000 10864224784 11340386304 1805393040 18.058 91 22 43 0 1820925152 8761504 6770608
16:06:11 54069 8192000000 10827398656 11303424000 1885832144 18.712 97 21 42 0 1899949504 8250096 5867264
16:07:14 41800 8192000000 10846349440 11325734912 1898499648 18.814 98 14 28 0 1917852272 15567584 3785040
16:08:09 51260 8192000000 10850642224 11323727872 1916278400 18.957 99 12 23 1 1929933344 9897888 3757056
16:09:21 61451 8192000000 10859532656 11331887104 1898482512 18.814 98 12 24 0 1912663856 10582048 3599296
16:12:01 81766 8192000000 10856804928 11325276160 1884716704 18.703 97 16 32 0 1900992528 12059744 4216080
16:13:29 63799 8192000000 10864528864 11332231168 1903141824 18.852 98 18 36 1 1923270704 14400896 5727984
16:15:01 75465 8192000000 10872007056 11342725120 1900126400 18.827 98 21 40 2 1927809840 21771760 5911680
16:16:23 39877 8192000000 10875380256 11341144064 1931682800 19.080 99 24 48 0 1947576560 8941904 6951856
16:17:14 46208 8192000000 10865133136 11332296704 1894909072 18.785 97 21 42 0 1912357056 11430384 6017600
16:18:18 42405 8192000000 10877123648 11321532416 1870019632 18.584 96 50 97 3 1896644816 13372768 13252416
16:19:15 55516 8192000000 10867490560 11346575360 1929549312 19.063 100 26 52 2 1954574832 17755184 7270336
16:20:50 101243 8192000000 10870983728 11360722944 1846853232 18.397 95 14 27 2 1873898336 23098736 3946368
16:22:47 76756 8192000000 10859124448 11331670016 1888130896 18.731 97 21 42 0 1909051040 14997648 5922496
16:24:10 48585 8192000000 10868470288 11315294208 1844308112 18.376 95 29 59 0 1861710608 8761392 8641104
16:25:05 46855 8192000000 10848381152 11315605504 1882281008 18.684 98 27 54 2 1906772176 17418528 7072640

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 25-01-2021 16:29:53 to 25-01-2021 16:30:24.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 113 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-01-2021 16:30:25 to 25-01-2021 16:30:27.

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          248536
MON$OLDEST_ACTIVE               249415
MON$OLDEST_SNAPSHOT             249415
MON$NEXT_TRANSACTION            249415
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                       2045088
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

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