Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 16.11.2020 16: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 17096624 kB
MemAvailable 31386380 kB
Buffers 0 kB
Cached 14552464 kB
SwapCached 3828 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-16 16:27:05
DTS_END                         2020-11-16 16:27:05.7570
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52176
TRN_ID                          244459
ATT_ID                          674
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: 9428.06 21332 1131367
customer order: creation 179.13 343 21495
customer order: refuse 15.80 339 1896
order to supplier: creation 46.18 1375 5541
order to supplier: removal 3.41 99828 409
invoice (draft): creation 47.14 3253 5657
invoice (draft): removal 52.84 805 6341
invoice accept: apply 44.34 18725 5321
invoice accept: cancel 48.03 807 5763
customer reserve: creation 3990.66 191 478879
customer reserve: removal 4697.86 56 563743
realization accept: apply 87.49 165 10499
realization accept: cancel 81.23 107 9748
payment from customer: creation 61.03 110 7324
payment from customer: removal 6.14 80 737
payment to supplier: creation 49.99 120 5999
payment to supplier: removal 3.40 83 408
service: total inventory turnovers 5.18 992 621
service: total monetary turnovers 7.43 33 892
service: aggregate perf. data 0.75 25214 90
service: refresh index statistics 0.03 274012 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 16-11-2020 16:28:14 to 16-11-2020 16:28:17.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5082
TEST_TIME 2 4730
TEST_TIME 3 4724
TEST_TIME 4 5621
TEST_TIME 5 6458
TEST_TIME 6 6780
TEST_TIME 7 7988
TEST_TIME 8 7921
TEST_TIME 9 7932
TEST_TIME 10 7867
TEST_TIME 11 8032
TEST_TIME 12 7910
TEST_TIME 13 8275
TEST_TIME 14 8525
TEST_TIME 15 8321
TEST_TIME 16 8204
TEST_TIME 17 8586
TEST_TIME 18 8752
TEST_TIME 19 8648
TEST_TIME 20 8847
TEST_TIME 21 9089
TEST_TIME 22 8959
TEST_TIME 23 8913
TEST_TIME 24 9307
TEST_TIME 25 9246
TEST_TIME 26 9461
TEST_TIME 27 9542
TEST_TIME 28 9483
TEST_TIME 29 9497
TEST_TIME 30 9548
TEST_TIME 31 9678
TEST_TIME 32 10414
TEST_TIME 33 11056
TEST_TIME 34 10814
TEST_TIME 35 10887
TEST_TIME 36 11040
TEST_TIME 37 10979
TEST_TIME 38 10830
TEST_TIME 39 10633
TEST_TIME 40 10640
TEST_TIME 41 10759
TEST_TIME 42 10735
TEST_TIME 43 10765
TEST_TIME 44 10595
TEST_TIME 45 10384
TEST_TIME 46 10297
TEST_TIME 47 10347
TEST_TIME 48 10199
TEST_TIME 49 10194
TEST_TIME 50 10079
TEST_TIME 51 10116
TEST_TIME 52 10130
TEST_TIME 53 10134
TEST_TIME 54 10056
TEST_TIME 55 10045
TEST_TIME 56 9965
TEST_TIME 57 9882
TEST_TIME 58 9904
TEST_TIME 59 9904
TEST_TIME 60 9872
TEST_TIME 61 9790
TEST_TIME 62 9751
TEST_TIME 63 9718
TEST_TIME 64 9762
TEST_TIME 65 9781
TEST_TIME 66 9815
TEST_TIME 67 9812
TEST_TIME 68 9846
TEST_TIME 69 9876
TEST_TIME 70 9831
TEST_TIME 71 9867
TEST_TIME 72 9963
TEST_TIME 73 9948
TEST_TIME 74 10006
TEST_TIME 75 10025
TEST_TIME 76 10053
TEST_TIME 77 10105
TEST_TIME 78 9986
TEST_TIME 79 9958
TEST_TIME 80 9892
TEST_TIME 81 9930
TEST_TIME 82 9865
TEST_TIME 83 9819
TEST_TIME 84 9778
TEST_TIME 85 9717
TEST_TIME 86 9677
TEST_TIME 87 9673
TEST_TIME 88 9652
TEST_TIME 89 9635
TEST_TIME 90 9624
TEST_TIME 91 9619
TEST_TIME 92 9671
TEST_TIME 93 9678
TEST_TIME 94 9700
TEST_TIME 95 9734
TEST_TIME 96 9709
TEST_TIME 97 9721
TEST_TIME 98 9763
TEST_TIME 99 9816
TEST_TIME 100 9853
TEST_TIME 101 9844
TEST_TIME 102 9887
TEST_TIME 103 9891
TEST_TIME 104 9816
TEST_TIME 105 9770
TEST_TIME 106 9710
TEST_TIME 107 9732
TEST_TIME 108 9673
TEST_TIME 109 9649
TEST_TIME 110 9602
TEST_TIME 111 9568
TEST_TIME 112 9505
TEST_TIME 113 9479
TEST_TIME 114 9461
TEST_TIME 115 9493
TEST_TIME 116 9499
TEST_TIME 117 9542
TEST_TIME 118 9515
TEST_TIME 119 9507
TEST_TIME 120 9433

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 16-11-2020 16:28:18 to 16-11-2020 16:28:21.

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 1576151 1576151 0 0.00 0 13618 6 0 0
doc_list_biud 1576150 1576150 0 0.00 0 50264 26 0 0
sp_add_invoice_to_stock 5447 5321 126 2.31 41 187142 18726 0 126
sp_cancel_adding_invoice 5763 5763 0 0.00 5 64875 807 0 0
sp_cancel_client_order 1896 1896 0 0.00 4 14324 339 0 0
sp_cancel_customer_reserve 563743 563743 0 0.00 1 50266 57 0 0
sp_cancel_pay_from_customer 737 737 0 0.00 2 4332 81 0 0
sp_cancel_pay_to_supplier 408 408 0 0.00 3 9260 83 0 0
sp_cancel_supplier_invoice 6353 6341 12 0.18 1 18676 806 0 12
sp_cancel_supplier_order 409 409 0 0.00 8 938943 99828 0 0
sp_cancel_write_off 9748 9748 0 0.00 1 21115 108 0 0
sp_client_order 21495 21495 0 0.00 3 18087 343 0 0
sp_customer_reserve 478879 478879 0 0.00 0 110674 191 0 0
sp_fill_shopping_cart 32686 32686 0 0.00 1 13695 39 0 0
sp_fill_shopping_cart_clo_res 478872 478872 0 0.00 0 16982 13 0 0
sp_get_clo_for_invoice 5311 5311 0 0.00 0 24605 286 0 0
sp_kill_cost_storno 16656 16656 0 0.00 0 9037 55 0 0
sp_kill_qstorno_ret_qs2qd 1143984 1143984 0 0.00 0 50261 31 0 0
sp_kill_qty_storno 603710 603710 0 0.00 0 50263 67 0 0
sp_lock_selected_doc 21837 21837 0 0.00 0 8202 4 0 0
sp_make_cost_storno 29133 29133 0 0.00 0 11709 51 0 0
sp_multiply_rows_for_pdistr 29133 29133 0 0.00 0 7364 30 0 0
sp_multiply_rows_for_qdistr 21495 21495 0 0.00 0 11739 165 0 0
sp_pay_from_customer 7324 7324 0 0.00 4 9592 110 0 0
sp_pay_to_supplier 5999 5999 0 0.00 5 12582 120 0 0
sp_payment_common 13323 13323 0 0.00 2 12561 28 0 0
sp_qd_handle_on_cancel_clo 1896 1896 0 0.00 0 14317 318 0 0
sp_qd_handle_on_invoice_upd_sts 11074 11074 0 0.00 0 14121 317 0 0
sp_qd_handle_on_reserve_upd_sts 10499 10499 0 0.00 0 7383 48 0 0
sp_reserve_write_off 10499 10499 0 0.00 6 12403 166 0 0
sp_supplier_invoice 5657 5657 0 0.00 6 89731 3253 0 0
sp_supplier_order 5541 5541 0 0.00 5 78546 1375 0 0
srv_aggregate_perf_data 90 90 0 0.00 2442 289925 25214 0 0
srv_fill_mon_cache_memory 175 175 0 0.00 845 134852 28644 0 0
srv_find_qd_qs_mism 1082702 1082702 0 0.00 0 13267 5 0 0
srv_make_invnt_saldo 621 621 0 0.00 27 75225 993 0 0
srv_make_money_saldo 892 892 0 0.00 0 4336 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 170533 361978 274012 0 0
t$perf-abend:sp_add_invoice_to_stock 126 126 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 5322 5322 0 0.00 0 10663 173 0 0
t$perf-norm:sp_cancel_adding_invoice 445 445 0 0.00 0 5287 86 0 0
t$perf-norm:sp_cancel_client_order 1896 1896 0 0.00 0 3937 16 0 0
t$perf-norm:sp_cancel_customer_reserve 694 694 0 0.00 0 2613 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 737 737 0 0.00 0 12285 25 0 0
t$perf-norm:sp_cancel_pay_to_supplier 408 408 0 0.00 0 1121 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 408 408 0 0.00 0 3749 22 0 0
t$perf-norm:sp_cancel_supplier_order 409 409 0 0.00 0 18706 1616 0 0
t$perf-norm:sp_cancel_write_off 1030 1030 0 0.00 0 2717 14 0 0
t$perf-norm:sp_client_order 21495 21495 0 0.00 0 10015 18 0 0
t$perf-norm:sp_customer_reserve 986 986 0 0.00 0 4893 10 0 0
t$perf-norm:sp_pay_from_customer 7324 7324 0 0.00 0 5834 11 0 0
t$perf-norm:sp_pay_to_supplier 5999 5999 0 0.00 0 11593 12 0 0
t$perf-norm:sp_reserve_write_off 10499 10499 0 0.00 0 4342 12 0 0
t$perf-norm:sp_supplier_invoice 5657 5657 0 0.00 0 19472 23 0 0
t$perf-norm:sp_supplier_order 5541 5541 0 0.00 0 2663 17 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 2232 30 0 0
t$perf-norm:srv_fill_mon_cache_memory 175 175 0 0.00 0 423 5 0 0
t$perf-norm:srv_make_invnt_saldo 621 621 0 0.00 0 4672 26 0 0
t$perf-norm:srv_make_money_saldo 892 892 0 0.00 0 673 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10874 10622 252 2.31 0 6154 19 0 252
v_all_customers 39072 39072 0 0.00 0 53 1 0 0
v_all_suppliers 30544 30544 0 0.00 0 20 1 0 0
v_all_wares 42990 42990 0 0.00 0 173 1 0 0
v_cancel_adding_invoice 890 890 0 0.00 0 315 7 0 0
v_cancel_client_order 3792 3792 0 0.00 0 1844 4 0 0
v_cancel_customer_prepayment 1474 1474 0 0.00 0 4215 9 0 0
v_cancel_customer_reserve 1388 1388 0 0.00 0 6159 13 0 0
v_cancel_payment_to_supplier 816 816 0 0.00 0 3064 9 0 0
v_cancel_supplier_invoice 840 816 24 2.85 0 9564 29 0 24
v_cancel_supplier_order 818 818 0 0.00 0 3391 9 0 0
v_cancel_write_off 2060 2060 0 0.00 0 901 12 0 0
v_max_id_clo_ord 5541 5541 0 0.00 0 3895 2 0 0
v_max_id_clo_res 986 986 0 0.00 0 2916 17 0 0
v_max_id_ord_sup 5650 5650 0 0.00 0 4443 5 0 0
v_max_non_paid_invoice 1918 1918 0 0.00 0 6272 6 0 0
v_max_non_paid_realizn 3910 3910 0 0.00 0 3756 4 0 0
v_min_id_clo_ord 5541 5541 0 0.00 0 6404 12 0 0
v_min_id_clo_res 986 986 0 0.00 0 2449 7 0 0
v_min_id_ord_sup 5650 5650 0 0.00 0 7071 8 0 0
v_min_non_paid_invoice 5999 5999 0 0.00 0 12550 16 0 0
v_min_non_paid_realizn 7324 7324 0 0.00 0 8908 18 0 0
v_our_firm 10746 10746 0 0.00 0 36 1 0 0
v_reserve_write_off 20998 20998 0 0.00 0 8301 6 0 0
x_lock_depdocs_on_canc_invoice 11696 11696 0 0.00 0 23004 118 0 0
x_lock_depdocs_on_canc_sup_ord 409 409 0 0.00 0 20373 351 0 0
x_make_qstorno_1000_1200 5541 5541 0 0.00 2 78521 1286 0 0
x_make_qstorno_1200_2000 5657 5657 0 0.00 3 89720 3118 0 0
x_make_qstorno_2100_3300 478878 478878 0 0.00 0 110673 175 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-11-2020 16:28:22 to 16-11-2020 16:28:26.

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:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:15 16957 8192000000 10240262896 10548469760 954942480 10.440 76 56 113 2 976410864 2770992 18697392
13:57:39 17031 8192000000 10332336464 10647756800 1374364448 14.366 100 80 160 0 1404583072 4610960 25607664
13:58:06 23536 8192000000 10365570080 10686623744 1419761920 14.771 100 86 172 0 1453656240 6144128 27750192
13:58:41 23161 8192000000 10393974496 10719223808 1453391888 15.068 100 95 190 1 1491338704 7161776 30785040
13:59:12 16326 8192000000 10419631008 10747723776 1469022912 15.205 100 87 174 0 1505233824 7487520 28723392
13:59:41 12447 8192000000 10432532800 10758574080 1488413904 15.375 100 93 186 0 1526358432 8009856 29934672
14:00:10 20719 8192000000 10448762320 10780966912 1499809040 15.475 100 86 172 0 1536319360 8691760 27818560
14:00:46 19719 8192000000 10469240720 10808725504 1520470656 15.654 100 84 168 0 1556162656 9206992 26485008
14:01:15 20480 8192000000 10492682016 10834313216 1543957584 15.858 100 86 172 0 1580596560 9792208 26846768
14:01:45 19019 8192000000 10513980400 10863366144 1562930576 16.021 100 71 142 0 1594354064 9536592 21886896
14:02:14 11994 8192000000 10527872896 10882088960 1588928304 16.245 100 68 136 2 1619404144 9398480 21077360
14:02:35 11547 8192000000 10560994640 10919002112 1621150864 16.520 100 71 143 1 1652120576 9616288 21353424
14:02:54 9238 8192000000 10572649520 10937151488 1637588896 16.659 100 68 136 0 1667947632 10509632 19849104
14:03:14 9815 8192000000 10610568288 10975858688 1666059504 16.900 100 76 151 1 1698831728 10222096 22550128
14:03:32 12060 8192000000 10626591280 10993553408 1686238784 17.070 100 75 149 2 1719139632 11125152 21775696
14:03:52 6535 8192000000 10648164320 11017367552 1704198400 17.220 100 77 152 3 1737676800 11215520 22262880
14:04:09 6919 8192000000 10652744480 11032576000 1722149616 17.370 100 81 161 0 1756598368 11304960 23143792
14:04:23 7849 8192000000 10677065376 11055267840 1740355360 17.522 100 74 148 2 1773499056 10978032 22165664
14:04:39 6504 8192000000 10691883664 11070803968 1757927456 17.667 100 74 148 2 1790476272 11029552 21519264
14:04:53 6523 8192000000 10709817824 11086348288 1771735472 17.781 100 78 157 1 1804358032 10890032 21732528
14:05:06 4828 8192000000 10729456208 11106537472 1783021856 17.874 100 86 172 3 1820377648 13311232 24044560
14:05:18 3539 8192000000 10723735232 11103846400 1788374288 17.918 100 92 181 2 1828007360 13988432 25644640
14:05:31 4757 8192000000 10727622688 11109892096 1791480400 17.944 100 83 166 1 1829227200 14570768 23176032
14:05:42 2802 8192000000 10752002704 11130781696 1800787632 18.020 100 87 174 0 1840201536 14585712 24828192
14:05:51 3906 8192000000 10746841664 11131490304 1807181536 18.073 100 84 166 1 1843348688 12912800 23254352
14:06:02 8364 8192000000 10744752064 11140120576 1813640720 18.126 100 82 163 6 1849723072 13618688 22463664
14:06:19 4386 8192000000 10766599936 11151380480 1818012720 18.161 100 83 166 3 1854611808 14286416 22312672
14:06:30 2956 8192000000 10776205408 11161812992 1835210208 18.302 100 89 177 3 1874951104 14817904 24922992
14:06:39 2154 8192000000 10787331664 11172941824 1844263552 18.375 100 96 190 2 1885749888 15121024 26365312
14:06:48 2745 8192000000 10792684992 11177689088 1844458448 18.377 100 93 186 1 1885764464 15133344 26172672
14:06:58 1853 8192000000 10795989904 11186274304 1852079392 18.439 100 93 187 0 1893100016 14781744 26238880
14:07:06 2352 8192000000 10796456256 11183677440 1859362912 18.498 100 86 170 2 1896277488 13177792 23736784
14:07:14 2164 8192000000 10799151680 11190165504 1859191168 18.497 100 89 178 2 1897368256 12254448 25922640
14:07:23 1723 8192000000 10810795216 11198115840 1865107248 18.545 100 97 196 2 1906452032 14440080 26904704
14:07:31 1959 8192000000 10808300592 11200028672 1867549120 18.564 100 90 177 2 1905791904 13299280 24943504
14:07:39 1661 8192000000 10809990528 11200913408 1867407024 18.563 100 79 158 1 1902445488 12956656 22081808
14:07:48 1264 8192000000 10819559056 11210424320 1871568112 18.597 100 96 192 1 1911520896 12835760 27117024
14:07:55 1922 8192000000 10825394128 11213660160 1875129568 18.626 100 92 184 1 1914357920 13116752 26111600
14:08:04 1256 8192000000 10819523984 11212824576 1877172752 18.642 100 87 176 1 1913733680 12174528 24386400
14:08:11 46219 8192000000 10796911328 11207806976 1873896880 18.616 100 66 131 1 1902576320 9208160 19471280
14:09:04 1968 8192000000 10809739200 11218935808 1883277264 18.692 100 83 164 3 1916006464 9510480 23218720
14:09:13 8485 8192000000 10793697824 11216691200 1876060960 18.633 100 35 70 0 1894829392 8646160 10122272
14:09:29 3682 8192000000 10783296224 11216314368 1879056096 18.657 100 34 68 1 1897079328 7990400 10032832
14:09:41 2638 8192000000 10806816672 11224072192 1883372400 18.692 100 48 97 1 1904294880 7302976 13619504
14:09:52 7088 8192000000 10786297632 11219140608 1879061712 18.658 100 23 46 2 1893047344 7559680 6425952
14:10:05 8971 8192000000 10790008512 11219021824 1879198112 18.659 100 15 28 4 1888728816 5831216 3699488
14:10:21 3182 8192000000 10807590576 11227353088 1884146000 18.699 100 30 60 2 1899663712 7225120 8292592
14:10:30 4107 8192000000 10790040416 11225468928 1885376272 18.708 100 22 44 1 1898347088 6681920 6288896
14:10:42 6723 8192000000 10801682048 11230322688 1890664544 18.751 100 29 59 1 1904920000 5800176 8455280
14:10:56 6069 8192000000 10789142272 11229528064 1890849488 18.753 100 19 38 0 1901973872 5593520 5530864
14:11:11 8672 8192000000 10804179456 11238653952 1895467568 18.790 100 14 28 1 1905238384 5112800 4658016
14:11:28 28195 8192000000 10797557600 11243343872 1903611712 18.855 100 22 43 1 1915226944 5593296 6021936
14:12:17 23850 8192000000 10855626720 11258220544 1913722064 18.937 100 76 154 1 1943894768 5869152 24303552
14:12:46 4920 8192000000 10822572656 11253497856 1906553312 18.879 100 36 70 2 1925024160 8870160 9600688
14:13:00 6950 8192000000 10813189696 11253096448 1906424592 18.878 100 28 55 3 1921281440 6865936 7990912
14:13:19 6645 8192000000 10828773616 11259236352 1911327904 18.917 100 33 66 3 1927620784 7050384 9242496
14:13:32 4878 8192000000 10830539776 11261812736 1914135072 18.940 100 42 84 3 1932654720 6830432 11689216
14:13:45 4979 8192000000 10824817296 11262595072 1915004736 18.947 100 31 62 0 1931230912 7549872 8676304
14:13:57 7133 8192000000 10816482592 11260829696 1914192384 18.940 100 19 38 0 1925054496 5523344 5338768
14:14:13 8558 8192000000 10821577840 11261161472 1918435728 18.974 100 31 62 1 1934010448 6252832 9321888
14:14:29 3864 8192000000 10839605520 11267981312 1922160960 19.004 100 25 50 3 1934739664 5640128 6938576
14:14:40 6630 8192000000 10833246288 11267145728 1919269920 18.981 100 21 42 1 1931545648 6193984 6081744
14:14:54 3295 8192000000 10846470608 11273224192 1922060256 19.003 100 32 64 0 1938434416 7154928 9219232
14:15:03 13294 8192000000 10809769696 11253956608 1893807264 18.776 99 13 26 3 1902844016 5478128 3558624
14:15:23 7918 8192000000 10816146512 11246989312 1873354096 18.611 98 16 32 3 1883416992 5200816 4862080
14:15:40 64956 8192000000 10815664096 11257823232 1899592560 18.823 99 26 51 2 1912680912 4769040 8319312
14:16:53 10664 8192000000 10820038576 11259002880 1911973280 18.922 100 24 48 1 1924884896 6182496 6729120
14:17:10 9675 8192000000 10817277920 11244621824 1839388112 18.336 96 30 61 7 1854797056 6664016 8744928
14:17:28 6360 8192000000 10815058832 11241848832 1894621856 18.783 100 28 57 0 1908684032 6402272 7659904
14:17:42 7509 8192000000 10803307136 11219030016 1854488160 18.459 98 37 74 3 1872519888 7397184 10634544
14:17:56 4525 8192000000 10788502448 11209818112 1850421136 18.426 98 44 88 4 1871551392 9161744 11968512
14:18:07 3353 8192000000 10771941616 11191627776 1823435968 18.206 97 35 71 0 1840741008 7531552 9773488
14:18:17 8216 8192000000 10728248448 11155542016 1754167408 17.636 95 26 52 2 1767479584 6291456 7020720
14:18:32 8435 8192000000 10767668464 11187007488 1816462320 18.149 98 31 62 1 1831854640 6516240 8876080
14:18:48 6382 8192000000 10740235184 11155640320 1789229840 17.925 97 27 54 0 1802426896 5378448 7818608
14:19:02 11862 8192000000 10722840720 11141771264 1739897520 17.518 95 16 32 1 1749906464 5172016 4836928
14:19:21 7520 8192000000 10723970480 11142684672 1792534080 17.953 99 19 37 0 1803978448 5726224 5718144
14:19:36 7757 8192000000 10727673152 11145572352 1811424832 18.108 100 18 35 1 1822976864 6277024 5275008
14:19:52 34546 8192000000 10688005568 11105644544 1729615488 17.432 95 32 63 3 1743676736 5934624 8126624
14:20:42 25689 8192000000 10684537888 11100348416 1658902592 16.840 92 19 38 1 1669396736 5222288 5271856
14:21:14 12571 8192000000 10703870336 11115139072 1755534688 17.647 98 24 48 0 1768139056 5161808 7442560
14:21:34 6167 8192000000 10732690752 11144503296 1793948960 17.964 99 30 60 1 1809335056 6245232 9140864
14:21:47 5566 8192000000 10716120128 11127275520 1757560192 17.664 97 27 54 2 1770824848 5377696 7886960
14:21:59 7908 8192000000 10716967616 11137572864 1807044672 18.072 100 28 56 0 1821923312 6416288 8462352
14:22:15 8855 8192000000 10727277712 11155664896 1808971440 18.087 99 27 54 3 1822820192 5847824 8000928
14:22:31 5211 8192000000 10739290112 11157614592 1809279184 18.090 99 34 66 4 1829299168 10172752 9847232
14:22:42 8400 8192000000 10746681152 11165839360 1813111232 18.121 99 28 56 1 1827093680 5551424 8431024
14:23:05 9478 8192000000 10757637856 11182034944 1840918608 18.348 100 23 44 3 1853429696 4825056 7686032
14:23:22 12696 8192000000 10771788128 11193167872 1852725824 18.444 100 32 64 2 1868512240 6548720 9237696
14:23:41 9419 8192000000 10763298720 11194925056 1857705184 18.485 100 30 60 3 1873598752 6944416 8949152
14:23:57 11253 8192000000 10768470128 11193024512 1856346464 18.474 100 13 25 2 1865336144 5143312 3846368
14:24:16 7568 8192000000 10779817408 11203092480 1858980432 18.495 100 25 50 3 1876252864 10516336 6756096
14:24:32 5716 8192000000 10762680080 11197517824 1857255024 18.481 100 14 28 2 1867565424 6577040 3733360
14:24:49 69004 8192000000 10765745728 11200671744 1863505536 18.532 100 32 66 0 1879085504 5556544 10023424
14:26:06 7433 8192000000 10786201056 11209592832 1866832464 18.559 100 41 81 7 1884922880 6065776 12024640
14:26:24 12305 8192000000 10785635232 11212185600 1866481568 18.556 100 21 42 3 1877101552 5448176 5171808
14:26:42 5992 8192000000 10786674560 11213287424 1869810016 18.583 100 23 46 1 1882046768 5855504 6381248
14:26:55 8238 8192000000 10799061216 11219214336 1872786080 18.607 100 30 60 0 1888018480 6883104 8349296
14:27:12 48247 8192000000 10824173168 11243569152 1894468864 18.782 100 32 61 1 1909481776 6574960 8437952
14:28:09 24742 8192000000 10844827360 11259817984 1907592320 18.887 100 34 68 0 1925198848 6454672 11151856
14:29:02 16920 8192000000 10861863168 11284017152 1926653472 19.040 100 53 105 2 1952107824 10356576 15097776
14:29:32 22168 8192000000 10865309776 11288817664 1932003712 19.083 100 48 96 1 1956159168 10489552 13665904
14:30:09 14695 8192000000 10871139888 11295608832 1941250992 19.157 100 54 106 1 1967303968 10445408 15607568
14:30:34 7723 8192000000 10876220544 11302985728 1946626832 19.200 100 43 84 0 1969093840 10588752 11878256
14:30:59 20232 8192000000 10890199392 11314065408 1957542320 19.287 100 54 107 0 1986107040 12926848 15637872
14:31:28 12656 8192000000 10893022256 11321360384 1958499392 19.294 100 59 117 2 1984896784 11224016 15173376
14:31:58 39094 8192000000 10879994352 11321692160 1954908448 19.266 100 36 71 1 1978074224 12805664 10360112
14:32:46 1759 8192000000 10897473152 11327606784 1964615696 19.343 100 65 131 1 1993302544 9629696 19057152
14:32:55 9414 8192000000 10893421312 11325820928 1962459616 19.326 100 49 98 1 1988146880 11296240 14391024
14:33:12 8013 8192000000 10899913456 11325575168 1962804528 19.328 100 54 106 1 1990372000 11669248 15898224
14:33:26 1274 8192000000 10919862256 11333795840 1971744832 19.399 100 80 161 1 2008295280 12728000 23822448
14:33:36 1390 8192000000 10933321680 11342135296 1973884848 19.416 100 79 155 1 2010511840 14092960 22534032
14:33:44 1958 8192000000 10913023984 11335065600 1969318560 19.380 100 80 162 3 2008706032 16183696 23203776
14:33:54 3867 8192000000 10925336560 11338502144 1972986688 19.409 100 82 159 1 2012804032 17500720 22316624
14:34:06 3335 8192000000 10916395792 11341058048 1974775872 19.423 100 76 152 1 2013644032 17169504 21698656
14:34:18 10755 8192000000 10906663344 11334946816 1964979536 19.346 100 59 119 1 1998041376 16698768 16363072
14:34:36 3861 8192000000 10889472240 11317936128 1941705344 19.160 99 63 126 0 1971046400 11309456 18031600
14:34:49 12391 8192000000 10902580832 11329540096 1963277184 19.332 100 53 106 2 1990694544 12322368 15094992
14:35:10 3629 8192000000 10903643728 11327275008 1948729776 19.216 99 54 107 0 1976212256 12431408 15051072
14:35:22 3130 8192000000 10911084304 11334897664 1969481840 19.381 100 68 134 2 2002755808 13010128 20263840
14:35:35 2709 8192000000 10915445824 11346632704 1981026464 19.473 100 72 144 0 2015468656 14170032 20272160
14:35:48 4653 8192000000 10930090000 11354714112 1980740704 19.471 100 66 131 1 2012365600 13398048 18226848
14:36:00 3499 8192000000 10917432576 11352154112 1982055808 19.481 100 53 106 2 2010538864 13424800 15058256
14:36:10 13121 8192000000 10922022832 11350974464 1978672160 19.454 100 59 116 1 2009508848 14285696 16550992
14:36:34 5400 8192000000 10920435952 11347230720 1977585856 19.446 100 63 121 1 2012020688 17095840 17338992
14:36:54 3030 8192000000 10924467472 11356909568 1987236944 19.522 100 64 124 1 2019610304 14227120 18146240
14:37:04 3371 8192000000 10933965168 11358420992 1979952208 19.464 100 54 107 1 2010402960 15313968 15136784
14:37:14 5428 8192000000 10928388096 11359449088 1985480608 19.508 100 56 111 0 2016894256 15294816 16118832
14:37:26 3654 8192000000 10931797440 11355467776 1985903696 19.511 100 78 154 0 2024452512 15974528 22574288
14:37:36 4552 8192000000 10934916752 11350372352 1981120288 19.474 100 80 161 0 2024637264 20701392 22815584
14:37:49 6714 8192000000 10937699520 11360169984 1985964992 19.512 100 62 124 0 2022700208 17665504 19069712
14:38:03 6997 8192000000 10926901024 11348221952 1976649120 19.438 99 70 138 2 2014394912 17338832 20406960
14:38:20 3952 8192000000 10950869088 11371061248 1994578016 19.580 100 71 142 1 2034168736 18262688 21328032
14:38:32 3544 8192000000 10949981568 11365101568 1992611456 19.564 100 72 137 3 2032321664 18927056 20783152
14:38:42 1739 8192000000 10959347920 11374362624 1997728192 19.605 100 90 180 1 2044302736 19119312 27455232
14:38:51 7437 8192000000 10929588848 11353432064 1984433840 19.500 100 67 133 0 2021970656 18497200 19039616
14:39:05 2351 8192000000 10923713168 11339595776 1965660992 19.351 99 78 156 2 2008340496 19675312 23004192
14:39:14 11797 8192000000 10906863568 11324665856 1919649440 18.984 97 70 140 0 1960973568 20805040 20519088
14:39:38 6814 8192000000 10940574896 11350188032 1976978496 19.441 100 83 163 1 2022977408 21456352 24542560
14:39:55 4950 8192000000 10898560064 11299426304 1914914448 18.946 97 70 137 2 1955809152 21261904 19632800
14:40:08 3323 8192000000 10924791056 11341541376 1966407040 19.357 100 73 145 0 2012178944 24366320 21405584
14:40:18 2029 8192000000 10915416272 11326058496 1937324720 19.125 98 83 165 0 1987234432 25246400 24663312
14:40:29 3840 8192000000 10912375456 11329519616 1951055040 19.235 100 61 122 0 1995864576 25111136 19698400
14:40:39 3962 8192000000 10920333056 11328974848 1954138560 19.259 100 82 162 1 2003530832 24981200 24411072
14:40:52 842 8192000000 10912437232 11314479104 1943849504 19.177 100 89 175 1 1995464576 25118832 26496240
14:41:00 4864 8192000000 10896076880 11301646336 1932421760 19.086 100 80 158 1 1979622832 25004944 22196128
14:41:12 3362 8192000000 10871471216 11283329024 1910357008 18.910 99 74 148 2 1957740896 25516928 21866960
14:41:23 6699 8192000000 10885041984 11299774464 1912533120 18.927 99 64 126 3 1953833552 23068384 18232048
14:41:36 2085 8192000000 10885711888 11295662080 1927221968 19.045 100 72 144 0 1971017408 23229200 20566240
14:41:45 13042 8192000000 10889912944 11315056640 1939116544 19.140 100 65 130 0 1980894032 23129056 18648432
14:42:05 6219 8192000000 10891811920 11305398272 1928688640 19.056 99 60 119 5 1968839168 22511472 17639056
14:42:23 35586 8192000000 10887046016 11311030272 1933117952 19.092 99 56 112 1 1973153152 23236640 16798560
14:43:09 7032 8192000000 10901069728 11321389056 1943767984 19.177 100 56 112 0 1984794192 24539744 16486464
14:43:27 9192 8192000000 10899230720 11317301248 1942365552 19.166 100 55 109 0 1984035824 25721952 15948320
14:43:44 7120 8192000000 10883022832 11305332736 1926315296 19.037 100 56 112 1 1970790032 27506336 16968400
14:43:59 4315 8192000000 10882947360 11297366016 1921673792 19.000 100 64 128 1 1970956080 29652832 19629456
14:44:18 28981 8192000000 10859175152 11303362560 1906539616 18.879 99 31 62 4 1946978032 30400224 10038192
14:45:10 7098 8192000000 10827934224 11231989760 1818060512 18.162 95 53 106 2 1858134816 24834768 15239536
14:45:24 7342 8192000000 10862271808 11279929344 1906673104 18.880 100 72 144 1 1956231408 28075248 21483056
14:45:39 5303 8192000000 10844603232 11254251520 1882535680 18.686 100 62 120 1 1928895728 28297056 18062992
14:45:51 5735 8192000000 10860691872 11275276288 1904012240 18.859 100 67 134 0 1947351392 23725600 19613552
14:46:06 4234 8192000000 10880596816 11293036544 1917002576 18.963 100 61 120 2 1961859040 26509168 18347296
14:46:17 2829 8192000000 10887500944 11290189824 1911501504 18.919 100 75 147 3 1961348704 27479296 22367904
14:46:26 6734 8192000000 10880570240 11287932928 1911119264 18.916 100 77 153 1 1962659632 28610800 22929568
14:46:39 7140 8192000000 10891808800 11297656832 1923967104 19.019 100 73 145 2 1978482096 32820928 21694064
14:46:54 7126 8192000000 10893467424 11308175360 1919163392 18.980 100 65 129 1 1974325824 35822992 19339440
14:47:10 2078 8192000000 10884705952 11296702464 1906879776 18.882 99 71 138 2 1961480048 33695616 20904656
14:47:20 4240 8192000000 10887817136 11288621056 1903145152 18.852 99 79 157 1 1962950080 36136272 23668656
14:47:32 3442 8192000000 10875348928 11285880832 1900021728 18.826 99 65 130 1 1957054976 37567248 19466000
14:47:45 1750 8192000000 10897342416 11297263616 1910282752 18.909 100 86 173 1 1976175568 40128064 25764752
14:47:53 3603 8192000000 10867185184 11284357120 1901964512 18.842 100 67 132 2 1963818736 41086688 20767536
14:48:27 4604 8192000000 10863003344 11287957504 1904395216 18.862 100 33 66 1 1947394560 32128800 10870544
14:48:38 6506 8192000000 10865376784 11294121984 1912762768 18.929 100 40 80 2 1959564096 33203184 13598144
14:48:56 1570 8192000000 10882359440 11283709952 1897207920 18.804 99 78 155 0 1955651312 34624080 23819312
14:49:04 2276 8192000000 10894241088 11304022016 1916747808 18.961 100 69 137 1 1974423616 36831520 20844288
14:49:14 2650 8192000000 10900259488 11310002176 1921646800 19.000 100 68 133 1 1979988560 37251616 21090144
14:49:26 4303 8192000000 10909879728 11313479680 1907560640 18.887 99 70 140 0 1967151696 38216112 21374944
14:49:37 4515 8192000000 10915457744 11326255104 1933904096 19.098 100 68 136 2 1994661376 39609504 21147776
14:49:48 6964 8192000000 10931979664 11337367552 1944873680 19.186 100 87 176 0 2013489120 40330576 28284864
14:50:02 2015 8192000000 10942813392 11344850944 1949827408 19.225 100 93 185 1 2023348448 44493088 29027952
14:50:11 1639 8192000000 10943645536 11348189184 1950497792 19.230 100 88 175 1 2023964528 45977504 27489232
14:50:21 5384 8192000000 10925805760 11348844544 1946504320 19.199 100 55 109 1 2008747424 44779264 17463840
14:50:55 3767 8192000000 10933843904 11352858624 1950179296 19.228 100 66 131 2 2020953168 50012512 20761360
14:51:06 4496 8192000000 10933382352 11365384192 1954090992 19.259 100 53 106 0 2023758224 51746336 17920896
14:51:21 12128 8192000000 10925179536 11360165888 1947510832 19.207 100 33 66 0 2007396272 47996288 11889152
14:51:50 9232 8192000000 10939286912 11370881024 1957203584 19.284 100 41 82 0 2019202064 48042000 13956480
14:52:15 12640 8192000000 10917605168 11365888000 1959159248 19.299 100 29 58 1 2008373680 39043456 10170976
14:52:42 8793 8192000000 10944940720 11374551040 1967148720 19.363 100 47 94 0 2023452320 41278400 15025200
14:52:59 3948 8192000000 10951218752 11377209344 1971473536 19.397 100 56 110 1 2031608800 42618336 17516928
14:53:11 4079 8192000000 10945658912 11377332224 1971779040 19.400 100 61 123 0 2035030560 43771744 19479776
14:53:26 15410 8192000000 10939643344 11380940800 1966384368 19.357 100 45 90 1 2027394288 45765136 15244784
14:54:00 23280 8192000000 10923183280 11363581952 1945329056 19.189 99 32 64 2 1999750992 43610016 10811920
14:54:33 22845 8192000000 10916101968 11363508224 1937576624 19.127 99 26 52 0 1988241728 41502304 9162800
14:55:07 24559 8192000000 10910613744 11361353728 1934947696 19.106 99 30 60 1 1986126864 41312864 9866304
14:55:58 15205 8192000000 10917639056 11357941760 1945140176 19.188 100 27 54 2 1999330224 45033344 9156704
14:56:32 14743 8192000000 10919063808 11355512832 1941487632 19.159 100 34 68 2 1998197808 45122288 11587888
14:56:54 8305 8192000000 10926752224 11367993344 1948796928 19.217 100 30 60 0 2006413632 47076672 10540032
14:57:10 8093 8192000000 10936793072 11374010368 1954439632 19.262 100 33 66 1 2018888288 52799248 11649408
14:57:32 15980 8192000000 10937315408 11382263808 1956994144 19.282 100 27 54 2 2016483360 50102800 9386416
14:58:01 14402 8192000000 10951504400 11394543616 1963799632 19.336 100 27 54 1 2031122992 57477024 9846336
14:58:28 20491 8192000000 10955771792 11407269888 1961543168 19.318 100 27 54 1 2039235376 67256848 10435360
14:59:02 21155 8192000000 10961638112 11405385728 1961930304 19.321 100 26 52 2 2037256496 65931104 9395088
14:59:33 30466 8192000000 10925995680 11380785152 1962526544 19.326 100 20 40 1 2033736864 62647696 8562624
15:00:10 28402 8192000000 10907334768 11382190080 1968183904 19.371 100 11 21 2 1998621616 27122576 3315136
15:00:45 45871 8192000000 10912400000 11369205760 1969277120 19.380 100 14 27 1 1989073792 15681152 4115520
15:01:41 26293 8192000000 10925913696 11375153152 1983869888 19.495 100 30 60 1 2006127776 13419728 8838160
15:02:25 57674 8192000000 10903088864 11380486144 1959661472 19.303 99 10 20 0 1976880208 14388384 2830352
15:03:30 43357 8192000000 10917241312 11381706752 1970646656 19.391 100 5 10 1 1993753392 21442608 1664128
15:04:20 72475 8192000000 10906391488 11357794304 1967510656 19.366 100 11 22 0 1983493840 13160176 2823008
15:05:41 72684 8192000000 10953702480 11393277952 1989269152 19.538 100 33 64 3 2012516976 14138208 9109616
15:07:00 76123 8192000000 10940646656 11401736192 1994627184 19.580 100 24 48 1 2015933744 14464720 6841840
15:08:25 75312 8192000000 10931132320 11404996608 1959069168 19.299 98 17 34 1 1989809120 25406576 5333376
15:10:09 84560 8192000000 10936122992 11391250432 1994889408 19.582 100 20 40 0 2017439280 17418112 5131760
15:11:56 75274 8192000000 10932932272 11381575680 1947023984 19.203 97 30 60 1 1964383376 8896960 8462432
15:13:18 38960 8192000000 10940249536 11391524864 1995554992 19.588 100 35 70 1 2016714368 11153888 10005488
15:14:05 33219 8192000000 10952137872 11415150592 2005714112 19.668 100 42 83 0 2028415872 11232592 11469168
15:14:58 115311 8192000000 10944920240 11418800128 1989010000 19.536 99 22 44 0 2009678608 14670128 5998480
15:17:02 49237 8192000000 10934983648 11399913472 1960000784 19.306 97 19 39 2 1977883856 12251536 5631536
15:18:03 56008 8192000000 10938881040 11410006016 1979338048 19.459 99 36 72 1 2007138368 16264816 11535504
15:19:16 32340 8192000000 10904613552 11364507648 1916485744 18.959 96 36 73 1 1939207552 11185488 11536320
15:19:54 134852 8192000000 10882157456 11356692480 1878830752 18.656 95 21 42 0 1895065824 10616384 5618688
15:23:15 62544 8192000000 10866271776 11338928128 1902415696 18.846 97 12 24 1 1916077504 10160128 3501680
15:24:36 119071 8192000000 10864308960 11353239552 1915641584 18.952 98 20 41 0 1933720320 11941040 6137696
15:26:43 32626 8192000000 10869640176 11340242944 1910432592 18.910 98 21 41 2 1926574896 10667696 5474608
15:27:23 31240 8192000000 10865982800 11338035200 1951640208 19.240 100 33 66 1 1970826512 9880832 9305472
15:28:06 63975 8192000000 10870088160 11339325440 1920822624 18.993 98 17 34 0 1936242944 10710560 4709760
15:29:27 58280 8192000000 10884362208 11372896256 1961048928 19.314 100 6 12 0 1973732912 11294368 1389616
15:30:33 59346 8192000000 10899062720 11376099328 1929176720 19.060 98 13 26 0 1940196720 7322048 3697952
15:32:11 44292 8192000000 10892981680 11364089856 1936082352 19.115 98 24 48 1 1956907376 14931744 5893280
15:33:05 35580 8192000000 10907181568 11382816768 1957787696 19.288 99 20 40 1 1976597056 13460624 5348736
15:34:17 43184 8192000000 10894369760 11360874496 1934258128 19.101 98 17 34 1 1951354416 12140720 4955568
15:35:09 30936 8192000000 10891923376 11338833920 1914483664 18.943 98 47 95 0 1940698000 12931184 13283152
15:36:27 71794 8192000000 10889136000 11347607552 1882344736 18.684 96 23 46 2 1901542128 12828448 6368944
15:37:45 42939 8192000000 10875252592 11334426624 1897734912 18.808 97 20 40 0 1919244080 15508064 6001104
15:39:09 45840 8192000000 10870128080 11353493504 1924032400 19.019 99 14 28 0 1940814048 12862064 3919584
15:40:03 42352 8192000000 10910691216 11351760896 1921520016 18.999 98 40 81 1 1948362832 15686448 11156368
15:40:56 38508 8192000000 10868100800 11329282048 1905205280 18.868 98 44 88 1 1935131424 17376768 12549376
15:41:45 97433 8192000000 10892147280 11361787904 1893257520 18.772 97 18 36 0 1912657952 14659488 4740944
15:44:51 94286 8192000000 10870434064 11340414976 1916019904 18.955 98 33 65 2 1937097984 10948016 10130064
15:46:39 61711 8192000000 10892617696 11342688256 1917221552 18.965 98 40 79 2 1937831520 9813568 10796400
15:47:47 38895 8192000000 10885747424 11339137024 1926995936 19.043 99 52 104 2 1954480576 12962064 14522576
15:48:33 63301 8192000000 10838771904 11324895232 1904736720 18.864 98 18 36 0 1920036160 9975680 5323760
15:50:04 65682 8192000000 10833979632 11306262528 1913548080 18.935 99 9 18 1 1923416112 6946096 2921936
15:51:22 69534 8192000000 10850707456 11337469952 1940164720 19.148 100 13 26 2 1953124448 9199824 3759904
15:52:57 85093 8192000000 10873271040 11350294528 1930240464 19.069 99 21 41 1 1944899440 9205216 5453760
15:54:34 69984 8192000000 10873435664 11356524544 1954642048 19.263 100 13 25 0 1965169120 7679728 2847344
15:55:59 51215 8192000000 10870223360 11351273472 1936937088 19.122 99 16 32 2 1948230688 6967856 4325744
15:56:57 37845 8192000000 10876619040 11352064000 1922782944 19.009 98 17 32 0 1933937760 7250864 3903952
15:58:01 52966 8192000000 10890930672 11353268224 1922505552 19.007 98 25 50 0 1940450848 11036784 6908512
15:59:23 58494 8192000000 10882468512 11369873408 1907908576 18.890 97 15 30 2 1928220928 15681184 4631168
16:00:29 73831 8192000000 10883622240 11364827136 1926931216 19.042 98 19 37 2 1946429392 13780992 5717184
16:01:49 40512 8192000000 10906365424 11371331584 1965201328 19.347 100 27 54 0 1983657616 10786416 7669872
16:02:37 48383 8192000000 10906185840 11383427072 1972597040 19.406 100 16 32 2 1987040608 9970128 4473440
16:03:33 69254 8192000000 10895267280 11369721856 1903047440 18.851 96 19 38 0 1923465152 15141232 5276480
16:04:51 59543 8192000000 10903840752 11363987456 1926784000 19.041 98 26 52 0 1956205312 21606384 7814928
16:06:06 65715 8192000000 10871707280 11338985472 1863628112 18.533 95 15 31 1 1876989568 9286912 4074544
16:07:18 98415 8192000000 10873070912 11339124736 1843576784 18.370 95 11 22 0 1858305168 11726656 3001728
16:09:07 82107 8192000000 10880920464 11367395328 1916583840 18.959 99 8 16 1 1936878224 18489040 1805344
16:10:36 115042 8192000000 10884091024 11355877376 1938702672 19.136 99 12 24 0 1955152160 13021968 3427520
16:12:50 25586 8192000000 10883917968 11363106816 1958506464 19.294 100 20 38 0 1974833856 11138448 5188944
16:13:45 45344 8192000000 10854380832 11339796480 1902669344 18.848 97 11 22 0 1917422176 11343184 3409648
16:14:39 34451 8192000000 10848153440 11338166272 1933127600 19.092 100 1 2 0 1943780096 10590368 62128
16:15:47 51388 8192000000 10877689856 11350384640 1957093008 19.283 100 8 16 1 1966598016 6894096 2610912
16:16:45 43275 8192000000 10869653040 11350372352 1924242432 19.021 98 13 26 1 1935094528 6986240 3865856
16:17:35 44445 8192000000 10869470912 11352371200 1955023504 19.266 100 4 8 0 1964357616 8317728 1016384
16:18:26 60727 8192000000 10881886880 11352567808 1911672544 18.920 97 15 30 1 1925124960 9501536 3950880
16:19:50 67570 8192000000 10884976080 11365707776 1935912304 19.114 98 30 60 0 1958445408 14206432 8326672
16:21:21 47661 8192000000 10891686432 11369398272 1954702816 19.264 100 14 28 0 1983299184 24391040 4205328
16:22:15 76516 8192000000 10875814512 11350380544 1885274048 18.708 96 20 39 2 1907242864 16130928 5837888
16:24:05 43938 8192000000 10862928352 11334209536 1869390992 18.579 96 9 17 1 1884105344 12427680 2286672
16:24:57 43125 8192000000 10872318352 11331878912 1899086944 18.819 98 24 48 0 1917580096 12103552 6389600
16:25:46 49768 8192000000 10845577872 11314507776 1840180944 18.342 95 20 40 3 1859509456 13549648 5778864
16:26:52 14438 8192000000 10834826864 11292545024 1896358880 18.797 98 38 76 2 1920351920 12542720 11450320

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 16-11-2020 16:28:28 to 16-11-2020 16:29:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 126 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 16-11-2020 16:29:02 to 16-11-2020 16:29:04.

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          242060
MON$OLDEST_ACTIVE               244747
MON$OLDEST_SNAPSHOT             244747
MON$NEXT_TRANSACTION            244747
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                       2053536
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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 ---
:162: 
:163: mscs-test-161.budzdorov.ru    Mon Nov 16 16:27:14 2020
:164:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:165: 
:166: 
:167: mscs-test-161.budzdorov.ru    Mon Nov 16 16:27:33 2020
:168:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:169: 
--- end of diff output ---

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

16.11.20 16:29:05. 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-16 16:29:07 No severe PSQL-related problems occured
16.11.20 16:29:09. End of report.