Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.01.2021 22: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 17383120 kB
MemAvailable 31300440 kB
Buffers 0 kB
Cached 14285996 kB
SwapCached 4864 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-18 22:27:12
DTS_END                         2021-01-18 22:27:12.6670
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/59556
TRN_ID                          238815
ATT_ID                          714
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: 9546.85 24050 1145622
customer order: creation 173.12 367 20774
customer order: refuse 14.60 292 1752
order to supplier: creation 47.48 1246 5697
order to supplier: removal 3.48 102372 418
invoice (draft): creation 46.35 3237 5562
invoice (draft): removal 54.80 751 6576
invoice accept: apply 42.47 18081 5096
invoice accept: cancel 50.26 783 6031
customer reserve: creation 3921.00 179 470520
customer reserve: removal 4887.81 58 586537
realization accept: apply 83.04 149 9965
realization accept: cancel 90.91 118 10909
payment from customer: creation 59.83 96 7179
payment from customer: removal 6.16 85 739
payment to supplier: creation 49.78 123 5974
payment to supplier: removal 3.24 68 389
service: total inventory turnovers 5.11 928 613
service: total monetary turnovers 6.59 21 791
service: aggregate perf. data 0.80 20277 96
service: refresh index statistics 0.03 331776 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 18-01-2021 22:27:45 to 18-01-2021 22:27:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3062
TEST_TIME 2 3363
TEST_TIME 3 3353
TEST_TIME 4 3487
TEST_TIME 5 3725
TEST_TIME 6 3839
TEST_TIME 7 4023
TEST_TIME 8 4818
TEST_TIME 9 5099
TEST_TIME 10 5583
TEST_TIME 11 6201
TEST_TIME 12 6548
TEST_TIME 13 7007
TEST_TIME 14 7353
TEST_TIME 15 7692
TEST_TIME 16 8115
TEST_TIME 17 8621
TEST_TIME 18 8517
TEST_TIME 19 8638
TEST_TIME 20 8496
TEST_TIME 21 8685
TEST_TIME 22 9256
TEST_TIME 23 10032
TEST_TIME 24 9947
TEST_TIME 25 10476
TEST_TIME 26 11000
TEST_TIME 27 11671
TEST_TIME 28 11349
TEST_TIME 29 11060
TEST_TIME 30 10860
TEST_TIME 31 10673
TEST_TIME 32 10642
TEST_TIME 33 10627
TEST_TIME 34 10689
TEST_TIME 35 10544
TEST_TIME 36 10421
TEST_TIME 37 10312
TEST_TIME 38 10267
TEST_TIME 39 10242
TEST_TIME 40 10243
TEST_TIME 41 10263
TEST_TIME 42 10175
TEST_TIME 43 10092
TEST_TIME 44 10124
TEST_TIME 45 10125
TEST_TIME 46 10139
TEST_TIME 47 10137
TEST_TIME 48 10135
TEST_TIME 49 10211
TEST_TIME 50 10188
TEST_TIME 51 10180
TEST_TIME 52 10181
TEST_TIME 53 10226
TEST_TIME 54 10102
TEST_TIME 55 10001
TEST_TIME 56 9887
TEST_TIME 57 9830
TEST_TIME 58 9852
TEST_TIME 59 9790
TEST_TIME 60 9761
TEST_TIME 61 9654
TEST_TIME 62 9740
TEST_TIME 63 9662
TEST_TIME 64 9652
TEST_TIME 65 9654
TEST_TIME 66 9811
TEST_TIME 67 9771
TEST_TIME 68 9777
TEST_TIME 69 9771
TEST_TIME 70 9829
TEST_TIME 71 9843
TEST_TIME 72 9813
TEST_TIME 73 9816
TEST_TIME 74 9859
TEST_TIME 75 9980
TEST_TIME 76 9988
TEST_TIME 77 9905
TEST_TIME 78 9786
TEST_TIME 79 9781
TEST_TIME 80 9768
TEST_TIME 81 9689
TEST_TIME 82 9628
TEST_TIME 83 9665
TEST_TIME 84 9605
TEST_TIME 85 9669
TEST_TIME 86 9640
TEST_TIME 87 9617
TEST_TIME 88 9579
TEST_TIME 89 9552
TEST_TIME 90 9619
TEST_TIME 91 9585
TEST_TIME 92 9637
TEST_TIME 93 9683
TEST_TIME 94 9743
TEST_TIME 95 9714
TEST_TIME 96 9704
TEST_TIME 97 9718
TEST_TIME 98 9737
TEST_TIME 99 9706
TEST_TIME 100 9673
TEST_TIME 101 9646
TEST_TIME 102 9592
TEST_TIME 103 9555
TEST_TIME 104 9495
TEST_TIME 105 9501
TEST_TIME 106 9532
TEST_TIME 107 9544
TEST_TIME 108 9545
TEST_TIME 109 9542
TEST_TIME 110 9521
TEST_TIME 111 9539
TEST_TIME 112 9582
TEST_TIME 113 9563
TEST_TIME 114 9592
TEST_TIME 115 9583
TEST_TIME 116 9563
TEST_TIME 117 9618
TEST_TIME 118 9643
TEST_TIME 119 9622
TEST_TIME 120 9550

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 18-01-2021 22:27:49 to 18-01-2021 22:27:53.

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 1582169 1582169 0 0.00 0 17477 6 0 0
doc_list_biud 1582169 1582169 0 0.00 0 68091 27 0 0
sp_add_invoice_to_stock 5226 5096 130 2.48 29 208371 18082 0 130
sp_cancel_adding_invoice 6031 6031 0 0.00 3 63450 784 0 0
sp_cancel_client_order 1752 1752 0 0.00 4 8488 292 0 0
sp_cancel_customer_reserve 586537 586537 0 0.00 1 27755 58 0 0
sp_cancel_pay_from_customer 739 739 0 0.00 2 4914 85 0 0
sp_cancel_pay_to_supplier 389 389 0 0.00 3 3031 68 0 0
sp_cancel_supplier_invoice 6588 6576 12 0.18 2 27044 751 0 12
sp_cancel_supplier_order 418 418 0 0.00 7 1323366 102372 0 0
sp_cancel_write_off 10909 10909 0 0.00 1 15157 119 0 0
sp_client_order 20774 20774 0 0.00 3 40709 367 0 0
sp_customer_reserve 470520 470520 0 0.00 0 167915 180 0 0
sp_fill_shopping_cart 32007 32007 0 0.00 1 16275 37 0 0
sp_fill_shopping_cart_clo_res 470510 470510 0 0.00 0 18048 14 0 0
sp_get_clo_for_invoice 5085 5085 0 0.00 0 31262 300 0 0
sp_kill_cost_storno 18068 18068 0 0.00 0 10779 57 0 0
sp_kill_qstorno_ret_qs2qd 1190977 1190977 0 0.00 0 26952 31 0 0
sp_kill_qty_storno 627273 627273 0 0.00 0 68090 67 0 0
sp_lock_selected_doc 20828 20828 0 0.00 0 7451 5 0 0
sp_make_cost_storno 28203 28203 0 0.00 0 12058 46 0 0
sp_multiply_rows_for_pdistr 28203 28203 0 0.00 0 11837 26 0 0
sp_multiply_rows_for_qdistr 20774 20774 0 0.00 0 40696 171 0 0
sp_pay_from_customer 7179 7179 0 0.00 4 10694 97 0 0
sp_pay_to_supplier 5974 5974 0 0.00 5 16967 123 0 0
sp_payment_common 13153 13153 0 0.00 1 16297 29 0 0
sp_qd_handle_on_cancel_clo 1752 1752 0 0.00 0 8477 265 0 0
sp_qd_handle_on_invoice_upd_sts 11116 11116 0 0.00 0 68090 326 0 0
sp_qd_handle_on_reserve_upd_sts 9965 9965 0 0.00 0 17610 50 0 0
sp_reserve_write_off 9965 9965 0 0.00 6 17715 149 0 0
sp_supplier_invoice 5562 5562 0 0.00 5 100307 3238 0 0
sp_supplier_order 5697 5697 0 0.00 5 51382 1246 0 0
srv_aggregate_perf_data 96 96 0 0.00 2864 128051 20278 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1154 207818 34392 0 0
srv_find_qd_qs_mism 1097598 1097598 0 0.00 0 17476 5 0 0
srv_make_invnt_saldo 613 613 0 0.00 27 51377 928 0 0
srv_make_money_saldo 791 791 0 0.00 0 415 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 191112 424183 331777 0 0
t$perf-abend:sp_add_invoice_to_stock 130 130 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 5096 5096 0 0.00 0 15636 164 0 0
t$perf-norm:sp_cancel_adding_invoice 428 428 0 0.00 0 8824 95 0 0
t$perf-norm:sp_cancel_client_order 1752 1752 0 0.00 0 4619 13 0 0
t$perf-norm:sp_cancel_customer_reserve 667 667 0 0.00 0 6820 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 739 739 0 0.00 0 7776 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 389 389 0 0.00 0 430 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 385 385 0 0.00 0 3459 24 0 0
t$perf-norm:sp_cancel_supplier_order 418 418 0 0.00 0 26883 1741 0 0
t$perf-norm:sp_cancel_write_off 1001 1001 0 0.00 0 1379 9 0 0
t$perf-norm:sp_client_order 20775 20775 0 0.00 0 12279 17 0 0
t$perf-norm:sp_customer_reserve 1047 1047 0 0.00 0 1622 9 0 0
t$perf-norm:sp_pay_from_customer 7179 7179 0 0.00 0 7625 12 0 0
t$perf-norm:sp_pay_to_supplier 5974 5974 0 0.00 0 5525 13 0 0
t$perf-norm:sp_reserve_write_off 9965 9965 0 0.00 0 7628 13 0 0
t$perf-norm:sp_supplier_invoice 5562 5562 0 0.00 0 10046 21 0 0
t$perf-norm:sp_supplier_order 5697 5697 0 0.00 0 10603 19 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 78 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 265 3 0 0
t$perf-norm:srv_make_invnt_saldo 613 613 0 0.00 0 10221 34 0 0
t$perf-norm:srv_make_money_saldo 791 791 0 0.00 0 1256 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10428 10168 260 2.49 0 5618 19 0 260
v_all_customers 37926 37926 0 0.00 0 127 1 0 0
v_all_suppliers 31358 31358 0 0.00 0 142 1 0 0
v_all_wares 41548 41548 0 0.00 0 52 1 0 0
v_cancel_adding_invoice 856 856 0 0.00 0 1340 11 0 0
v_cancel_client_order 3504 3504 0 0.00 0 3644 7 0 0
v_cancel_customer_prepayment 1478 1478 0 0.00 0 1451 4 0 0
v_cancel_customer_reserve 1334 1334 0 0.00 0 525 4 0 0
v_cancel_payment_to_supplier 778 778 0 0.00 0 2420 8 0 0
v_cancel_supplier_invoice 794 770 24 3.02 0 6111 26 0 24
v_cancel_supplier_order 836 836 0 0.00 0 1466 8 0 0
v_cancel_write_off 2002 2002 0 0.00 0 2555 13 0 0
v_max_id_clo_ord 5697 5697 0 0.00 0 684 1 0 0
v_max_id_clo_res 1047 1047 0 0.00 0 4840 22 0 0
v_max_id_ord_sup 5536 5536 0 0.00 0 2581 2 0 0
v_max_non_paid_invoice 1528 1528 0 0.00 0 127 2 0 0
v_max_non_paid_realizn 3764 3764 0 0.00 0 6879 8 0 0
v_min_id_clo_ord 5697 5697 0 0.00 0 3214 5 0 0
v_min_id_clo_res 1047 1047 0 0.00 0 8058 13 0 0
v_min_id_ord_sup 5536 5536 0 0.00 0 7114 8 0 0
v_min_non_paid_invoice 5974 5974 0 0.00 0 14795 20 0 0
v_min_non_paid_realizn 7179 7179 0 0.00 0 9959 18 0 0
v_our_firm 10452 10452 0 0.00 0 11 1 0 0
v_reserve_write_off 19930 19930 0 0.00 0 2854 6 0 0
x_lock_depdocs_on_canc_invoice 12222 12222 0 0.00 0 17630 122 0 0
x_lock_depdocs_on_canc_sup_ord 418 418 0 0.00 0 6569 293 0 0
x_make_qstorno_1000_1200 5697 5697 0 0.00 2 51354 1170 0 0
x_make_qstorno_1200_2000 5562 5562 0 0.00 2 90926 3087 0 0
x_make_qstorno_2100_3300 470520 470520 0 0.00 0 167913 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-01-2021 22:27:54 to 18-01-2021 22:27:58.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:22 13801 8192000000 10222220928 10520444928 888866752 9.788 72 54 111 0 910636192 2501776 19267664
19:57:46 17083 8192000000 10306262320 10626473984 1372783888 14.352 100 83 166 0 1404079056 4450368 26844800
19:58:15 28015 8192000000 10371151008 10693451776 1422126912 14.792 100 85 170 0 1455390944 5719680 27544352
19:59:06 24302 8192000000 10423734416 10748280832 1466850544 15.186 100 92 184 0 1503798176 7561904 29385728
19:59:41 24775 8192000000 10433003840 10764587008 1484562624 15.341 100 89 178 0 1521702544 8642368 28497552
20:00:18 11498 8192000000 10451244384 10781732864 1504182432 15.513 100 93 186 0 1543197184 9311552 29703200
20:00:38 14790 8192000000 10457847152 10795925504 1507939680 15.545 100 85 169 0 1544068112 9226096 26902336
20:01:06 23437 8192000000 10467438640 10809794560 1528005440 15.720 100 83 166 1 1563835680 9629328 26200912
20:01:38 19160 8192000000 10496391936 10840006656 1545514912 15.871 100 80 160 1 1579956688 9810256 24631520
20:02:10 10088 8192000000 10511692960 10865258496 1574625232 16.122 100 72 144 1 1605768016 9432864 21709920
20:02:30 14254 8192000000 10542855664 10899226624 1600981440 16.348 100 77 154 0 1634094928 10054560 23058928
20:02:53 14396 8192000000 10563697360 10927009792 1628816240 16.585 100 83 166 0 1664450928 11233936 24400752
20:03:18 10793 8192000000 10587979408 10950008832 1644167504 16.715 100 78 156 0 1678375632 11412576 22795552
20:03:37 9081 8192000000 10608948592 10971025408 1660934832 16.857 100 74 147 2 1694289488 11936080 21418576
20:03:53 13519 8192000000 10634421648 11005607936 1687809840 17.083 100 75 149 2 1721827520 12529152 21488528
20:04:14 6752 8192000000 10645035200 11015897088 1706076240 17.236 100 79 158 1 1741369984 12648384 22645360
20:04:29 8004 8192000000 10665509904 11037016064 1718395488 17.339 100 85 170 0 1755756304 13335776 24025040
20:04:44 9924 8192000000 10665944512 11044339712 1733178032 17.462 100 79 158 3 1768993328 13375808 22439488
20:05:01 4638 8192000000 10683407264 11060445184 1743177712 17.545 100 80 160 0 1778880272 12900448 22802112
20:05:13 4272 8192000000 10702792624 11077259264 1756210624 17.653 100 84 169 0 1792777744 12908160 23658960
20:05:24 3374 8192000000 10687976288 11067121664 1758486016 17.672 100 84 169 1 1795953808 13455376 24012416
20:05:34 6762 8192000000 10701681920 11084345344 1770460288 17.771 100 77 154 2 1804274064 12725776 21088000
20:05:48 3201 8192000000 10719748000 11100688384 1777737184 17.831 100 84 168 2 1814471664 13102656 23631824
20:05:58 2330 8192000000 10737440208 11116806144 1789496704 17.928 100 84 165 1 1824889280 12460368 22932208
20:06:08 3281 8192000000 10735385184 11120005120 1802212944 18.032 100 85 168 1 1839056128 12752064 24091120
20:06:18 3062 8192000000 10747098640 11131490304 1807832224 18.078 100 86 172 0 1845218720 13116352 24270144
20:06:28 2576 8192000000 10746408688 11134140416 1812198288 18.114 100 83 167 0 1848496752 13020496 23277968
20:06:37 2919 8192000000 10760886736 11142963200 1817396416 18.156 100 87 173 1 1854207840 12593920 24217504
20:06:48 8730 8192000000 10753761296 11145793536 1820056720 18.178 100 78 156 2 1854981040 13481952 21442368
20:07:03 4141 8192000000 10772381840 11157880832 1828474816 18.247 100 80 160 0 1865162224 14546736 22140672
20:07:14 2416 8192000000 10778316016 11166457856 1842268160 18.359 100 87 173 1 1880501728 13668848 24564720
20:07:23 2382 8192000000 10789888704 11175489536 1847404624 18.401 100 96 192 2 1889160528 13810624 27945280
20:07:32 1849 8192000000 10795969616 11184844800 1850859120 18.429 100 93 187 2 1895999168 18387440 26752608
20:07:40 2099 8192000000 10797084144 11184209920 1856206608 18.473 100 84 167 1 1892280432 12684256 23389568
20:07:48 2236 8192000000 10801576128 11189129216 1858212064 18.489 100 92 182 0 1895943696 12460608 25271024
20:07:56 1565 8192000000 10818494288 11203616768 1863692816 18.533 100 95 189 0 1903938752 13458784 26787152
20:08:04 1567 8192000000 10806574784 11192893440 1868001200 18.568 100 95 191 0 1908927120 13856992 27068928
20:08:12 1581 8192000000 10815690304 11202146304 1869487792 18.580 100 96 190 0 1910831952 14562288 26781872
20:08:20 1550 8192000000 10814481584 11203158016 1870356224 18.587 100 90 178 0 1908607392 13437520 24813648
20:08:28 1564 8192000000 10813760832 11204349952 1870339392 18.587 100 90 182 2 1907247856 12511504 24396960
20:08:36 17714 8192000000 10786238544 11196952576 1865599952 18.549 100 57 114 1 1892652416 11302736 15749728
20:09:12 1549 8192000000 10828341872 11217096704 1877408208 18.644 100 94 188 0 1916530000 12659808 26461984
20:09:20 5170 8192000000 10799231904 11204239360 1870954080 18.592 100 57 115 0 1899551536 12424304 16173152
20:09:33 5142 8192000000 10784549232 11204345856 1869252816 18.578 100 44 88 0 1890954512 9279776 12421920
20:09:45 10388 8192000000 10780128400 11200987136 1866958816 18.560 100 30 60 1 1882645968 7326608 8360544
20:10:06 7150 8192000000 10785176432 11207528448 1868586256 18.573 100 25 50 0 1883397488 8036240 6774992
20:10:19 6313 8192000000 10784311680 11209228288 1872293552 18.603 100 38 77 2 1891351984 8151520 10906912
20:10:32 7969 8192000000 10780898032 11209416704 1873602240 18.613 100 36 72 2 1890791328 6764144 10424944
20:10:47 11315 8192000000 10779944336 11210457088 1876851168 18.640 100 23 46 1 1889678032 6135504 6691360
20:11:05 7865 8192000000 10778291920 11210809344 1874778560 18.623 100 19 38 3 1886174496 5629504 5766432
20:11:21 23564 8192000000 10784877344 11219603456 1877296176 18.643 100 19 36 6 1888275216 6100336 4878704
20:11:52 60910 8192000000 10793308800 11227099136 1882482464 18.685 100 31 62 2 1896538112 5804416 8251232
20:13:01 6666 8192000000 10786932016 11227189248 1882735024 18.687 100 18 36 2 1894410800 5975584 5700192
20:13:15 6501 8192000000 10804700528 11234508800 1888536976 18.734 100 24 48 1 1900551200 5576560 6437664
20:13:30 4649 8192000000 10814672656 11241316352 1895409952 18.789 100 44 88 1 1915610176 7999232 12200992
20:13:45 6804 8192000000 10803208656 11239489536 1894788400 18.784 100 33 66 1 1911390672 7417728 9184544
20:13:58 6532 8192000000 10807609424 11240148992 1892919280 18.769 100 27 53 1 1907509488 6278960 8311248
20:14:11 7028 8192000000 10802330416 11240783872 1896367072 18.797 100 26 52 2 1910154016 5874016 7912928
20:14:29 7254 8192000000 10809182960 11242491904 1896139728 18.795 100 29 58 2 1911048960 6878256 8030976
20:14:44 11569 8192000000 10812357328 11247104000 1901176448 18.836 100 19 38 0 1912479840 5670672 5632720
20:15:01 9669 8192000000 10808472864 11247767552 1899473824 18.822 100 17 34 1 1910822096 6133136 5215136
20:15:22 11617 8192000000 10822260208 11259449344 1904924880 18.866 100 19 37 1 1915699344 5610608 5163856
20:15:45 7620 8192000000 10814297488 11257589760 1904494480 18.862 100 17 34 2 1919299552 10166608 4638464
20:15:59 5695 8192000000 10808542544 11236413440 1860169984 18.505 98 27 54 0 1873802256 5730112 7902160
20:16:11 9533 8192000000 10808206976 11245215744 1894287088 18.780 100 16 32 1 1904776048 6076304 4412656
20:16:29 68116 8192000000 10801245392 11235106816 1849783120 18.420 97 45 91 1 1868295648 5068544 13443984
20:17:44 8084 8192000000 10814633968 11243929600 1876661760 18.638 99 18 36 1 1887472832 5771088 5039984
20:18:00 6110 8192000000 10814702944 11240189952 1877235072 18.643 99 41 82 2 1896181904 7746320 11200512
20:18:12 8047 8192000000 10792171280 11224489984 1830988000 18.267 97 25 50 0 1843411120 5781696 6641424
20:18:26 4149 8192000000 10776477792 11199463424 1841495072 18.353 98 35 69 4 1858362704 6883568 9984064
20:18:38 6341 8192000000 10807584336 11221139456 1859201392 18.497 99 28 55 1 1873069984 6770608 7097984
20:18:51 6718 8192000000 10770673536 11196624896 1825590400 18.223 98 24 48 1 1838837104 6084528 7162176
20:19:06 9859 8192000000 10747761808 11175497728 1780652144 17.855 96 24 48 0 1796905216 9413344 6839728
20:19:22 5023 8192000000 10733582544 11156164608 1817596352 18.158 99 28 55 3 1832074960 5567872 8910736
20:19:36 4855 8192000000 10752702688 11172818944 1830222848 18.261 100 30 58 4 1852545584 14688768 7633968
20:19:47 6529 8192000000 10731084944 11145641984 1756724752 17.657 96 23 46 0 1767347120 4645456 5976912
20:20:02 7304 8192000000 10689160208 11099947008 1721670640 17.366 96 23 45 2 1737596368 9673168 6252560
20:20:16 13738 8192000000 10687031616 11094040576 1672884880 16.957 92 20 40 0 1683650704 4783808 5982016
20:20:36 11094 8192000000 10727320880 11153375232 1805896912 18.062 100 28 54 2 1824060592 9911328 8252352
20:21:00 9040 8192000000 10697398608 11115024384 1741641616 17.532 97 20 41 1 1753359808 6053152 5665040
20:21:18 73034 8192000000 10700351536 11121659904 1711654448 17.283 94 29 57 0 1725168256 4962880 8550928
20:22:39 11311 8192000000 10716490656 11127468032 1739695264 17.516 96 26 51 1 1752222704 5468400 7059040
20:22:57 6226 8192000000 10739445360 11153080320 1817358752 18.156 100 29 58 1 1831475440 6232768 7883920
20:23:11 9957 8192000000 10735205312 11158695936 1804603360 18.052 99 33 66 2 1820545984 5973136 9969488
20:23:28 10340 8192000000 10742297632 11160227840 1792417968 17.952 98 22 44 2 1805320736 6519248 6383520
20:23:46 8817 8192000000 10752296256 11171643392 1832355344 18.279 100 23 46 1 1844979568 5478752 7145472
20:24:06 10635 8192000000 10748218272 11175751680 1840192832 18.342 100 31 62 1 1855133712 5721088 9219792
20:24:25 5597 8192000000 10761503744 11186049024 1844542352 18.378 100 30 60 0 1860004816 6527024 8935440
20:24:39 9225 8192000000 10760949712 11184443392 1845836816 18.388 100 22 44 2 1858135200 5594384 6704000
20:24:58 10380 8192000000 10756317216 11185405952 1848135424 18.407 100 16 32 2 1858317664 5162128 5020112
20:25:21 11881 8192000000 10768271456 11194486784 1854091792 18.455 100 14 28 0 1863502416 5367920 4042704
20:25:42 9760 8192000000 10774399024 11201802240 1859238064 18.497 100 17 34 1 1869812288 5570864 5003360
20:25:58 8959 8192000000 10779756512 11207446528 1863162416 18.529 100 23 46 2 1875581312 5906672 6512224
20:26:13 132286 8192000000 10794997184 11229196288 1873811600 18.615 100 34 66 1 1891268000 7314384 10142016
20:28:31 7261 8192000000 10836023600 11248832512 1899126064 18.819 100 51 103 4 1921909552 8546848 14236640
20:28:46 30278 8192000000 10839609312 11263553536 1909634704 18.904 100 44 85 1 1932009520 10309216 12065600
20:29:25 31568 8192000000 10854510944 11280674816 1921713616 19.001 100 37 74 1 1945457840 12782144 10962080
20:30:06 29007 8192000000 10872790336 11299274752 1934502880 19.103 100 35 70 0 1958483744 13973808 10007056
20:30:58 23419 8192000000 10889301680 11315617792 1952392592 19.246 100 46 92 3 1984858416 18910864 13554960
20:31:31 9072 8192000000 10897198112 11320152064 1959155248 19.299 100 66 126 2 1993893184 16141408 18596528
20:31:52 18337 8192000000 10893416800 11323768832 1958784896 19.296 100 47 94 0 1989583776 17061984 13736896
20:32:33 25432 8192000000 10910814800 11352592384 1976129952 19.434 100 50 98 4 2016408176 25670416 14607808
20:33:22 11493 8192000000 10936777664 11355480064 1980817680 19.471 100 53 107 1 2018947616 21561696 16568240
20:33:47 8266 8192000000 10931149712 11359334400 1984095664 19.497 100 58 115 2 2024313600 23076688 17141248
20:34:07 5891 8192000000 10943788688 11363164160 1987623472 19.525 100 62 120 2 2027938928 22456128 17859328
20:34:26 14443 8192000000 10951700656 11372285952 1991965200 19.559 100 59 118 1 2035665056 25716672 17983184
20:34:50 17173 8192000000 10947947184 11377999872 1993113440 19.568 100 56 112 1 2038850880 29101216 16636224
20:35:15 9155 8192000000 10952854464 11382505472 1996472800 19.595 100 53 106 1 2044830864 32016736 16341328
20:35:44 3392 8192000000 10956524128 11385004032 2000637680 19.628 100 61 122 1 2051845072 32627776 18579616
20:35:56 3471 8192000000 10965644048 11384938496 2002757680 19.644 100 73 144 2 2054491472 30496512 21237280
20:36:07 4988 8192000000 10959927536 11389546496 2002326496 19.641 100 63 126 1 2052735520 31339952 19069072
20:36:21 2756 8192000000 10961723680 11375210496 1985252912 19.506 99 82 161 0 2041935520 32127008 24555600
20:36:32 4178 8192000000 10975753328 11387084800 2000133760 19.624 100 83 162 0 2056099520 32354672 23611088
20:36:43 3971 8192000000 10970856096 11389665280 1999961024 19.622 100 77 153 0 2056859888 33259728 23639136
20:36:54 3971 8192000000 10965379872 11382239232 1995832288 19.590 100 83 164 0 2054090144 33972160 24285696
20:37:08 1583 8192000000 10975517888 11394412544 2000603632 19.627 100 80 161 0 2060247328 35325312 24318384
20:37:20 5131 8192000000 10962693424 11389050880 1997137024 19.600 100 76 151 1 2055495536 35324608 23033904
20:37:42 7388 8192000000 10971812784 11403304960 2006250640 19.672 100 68 134 2 2062981216 35982736 20747840
20:38:00 5777 8192000000 10969146112 11397775360 2000752064 19.629 100 62 124 2 2057149904 36214496 20183344
20:38:17 7294 8192000000 10968573440 11402911744 2003305904 19.649 100 64 129 2 2061880112 37565200 21009008
20:38:39 12073 8192000000 10959676992 11400175616 1984130272 19.497 99 46 92 0 2035604352 36381952 15092128
20:39:06 4224 8192000000 10982882784 11407081472 2011023808 19.710 100 75 149 0 2068573584 34151344 23398432
20:39:22 4498 8192000000 10987123312 11420266496 2014305824 19.735 100 63 125 3 2074865600 41241296 19318480
20:39:34 5075 8192000000 10995480800 11419803648 2016000608 19.749 100 64 124 2 2074107088 38166928 19939552
20:39:46 3364 8192000000 10986492736 11404787712 2003602976 19.651 99 86 170 2 2067980528 38318400 26059152
20:39:57 3488 8192000000 11008516512 11428777984 2021815648 19.794 100 85 171 2 2087327408 39686032 25825728
20:40:11 3043 8192000000 11007508080 11429462016 2023786320 19.810 100 86 170 3 2090065104 39884112 26394672
20:40:20 6975 8192000000 10997730464 11423457280 2018698784 19.770 100 80 160 0 2081281888 38310544 24272560
20:40:35 1435 8192000000 11001646896 11416154112 2016606016 19.753 100 87 171 2 2081058848 38661456 25791376
20:40:48 5481 8192000000 11010021104 11433275392 2024164192 19.813 100 83 166 2 2090571392 41194320 25212880
20:41:06 6298 8192000000 10997101184 11425046528 2018983792 19.772 100 71 144 1 2080918560 40591136 21343632
20:41:19 1153 8192000000 11001670800 11416592384 2008842336 19.692 99 90 178 2 2078309632 42810256 26657040
20:41:27 2681 8192000000 11017098704 11434897408 2025335616 19.822 100 85 167 1 2094435824 43792464 25307744
20:41:36 4008 8192000000 11009252736 11435544576 2028957904 19.850 100 84 169 5 2098980720 44960608 25062208
20:41:48 2614 8192000000 11008988336 11430690816 2021137504 19.789 100 79 158 2 2087283872 41468096 24678272
20:42:00 3219 8192000000 11009030448 11426508800 2019910800 19.779 100 89 179 1 2089643632 42596336 27136496
20:42:10 4056 8192000000 11010779984 11427123200 2015557408 19.745 100 93 186 1 2087737120 43474640 28705072
20:42:21 3920 8192000000 11003140336 11426689024 2019222608 19.774 100 83 164 3 2086393760 41037056 26134096
20:42:34 3279 8192000000 10998329216 11434655744 2018746144 19.770 100 60 120 1 2080454048 43140816 18567088
20:42:47 1655 8192000000 11025766528 11445022720 2031865056 19.873 100 87 170 0 2102053904 44246944 25941904
20:42:55 1477 8192000000 11023337360 11444662272 2031292992 19.869 100 93 187 1 2105771984 46468912 28010080
20:43:06 1875 8192000000 11004184960 11423526912 2010209248 19.703 99 78 157 1 2082213616 47175856 24828512
20:43:21 13100 8192000000 10982197488 11423350784 1980891328 19.472 98 41 82 0 2034956480 40717200 13347952
20:43:46 9322 8192000000 10986477424 11426394112 2008251808 19.688 100 59 119 0 2069697424 42570032 18875584
20:44:02 2437 8192000000 10996790592 11422371840 1992887568 19.567 99 79 158 1 2064604272 47296224 24420480
20:44:12 3694 8192000000 10998518912 11424092160 2007974704 19.686 100 67 132 0 2071367104 42892336 20500064
20:44:23 3731 8192000000 10977426448 11410534400 1973546944 19.414 98 57 114 2 2035349616 44433408 17369264
20:44:38 14042 8192000000 10966652432 11417907200 1983775776 19.495 99 27 54 0 2038504208 45595104 9133328
20:45:02 11148 8192000000 10955999184 11404963840 1976370176 19.436 99 31 59 0 2029226848 43296288 9560384
20:45:20 3777 8192000000 10969085744 11410530304 1989706224 19.541 99 50 100 1 2046384288 40107392 16570672
20:45:34 8309 8192000000 10956418272 11398561792 1963806128 19.336 98 39 79 3 2018049008 40998352 13244528
20:45:58 6327 8192000000 10944698256 11388755968 1977531216 19.445 100 38 76 1 2033438176 43192000 12714960
20:46:12 4894 8192000000 10949242768 11386351616 1977059824 19.441 100 51 99 1 2039337328 44948512 17328992
20:46:24 8180 8192000000 10970274960 11401519104 1968452112 19.373 99 41 82 0 2027918784 45830672 13636000
20:46:39 2007 8192000000 10963671280 11377025024 1958718736 19.296 98 67 133 1 2026826544 47916608 20191200
20:46:48 9743 8192000000 10945822352 11375718400 1959678672 19.303 99 50 103 0 2026976016 50347808 16949536
20:47:05 6950 8192000000 10935246480 11381313536 1951432432 19.238 99 35 70 3 2013653120 49951024 12269664
20:47:22 12316 8192000000 10941077152 11380707328 1961829600 19.321 100 37 74 2 2026304736 51483008 12992128
20:47:45 6763 8192000000 10969322256 11382726656 1964290080 19.340 100 72 144 3 2041532064 53743824 23498160
20:47:58 4420 8192000000 10976705504 11403419648 1979724192 19.463 100 68 136 0 2059178128 57238272 22215664
20:48:13 3226 8192000000 10993825696 11404484608 1964172688 19.339 99 88 175 0 2055401904 62718864 28510352
20:48:23 3793 8192000000 10989146960 11403829248 1961372768 19.317 99 82 164 1 2049219440 62318512 25528160
20:48:36 2715 8192000000 11009864240 11422105600 1987980208 19.528 100 86 172 0 2083239968 68335856 26923904
20:48:45 3204 8192000000 10987306704 11407007744 1977881600 19.448 100 80 157 1 2068407760 66117216 24408944
20:48:56 6968 8192000000 10978489472 11405791232 1974998032 19.425 100 65 130 0 2061457488 65063152 21396304
20:49:12 11507 8192000000 10985350752 11416068096 1979720064 19.462 100 60 119 1 2066022400 66672992 19629344
20:49:36 2120 8192000000 11004587424 11424894976 1985775424 19.510 100 85 169 1 2080872368 68178736 26918208
20:49:46 2416 8192000000 11000661568 11423129600 1973957344 19.417 99 79 159 0 2069337328 69926320 25453664
20:50:06 33113 8192000000 10945000144 11406815232 1980694128 19.470 100 27 54 0 2034302432 44475552 9132752
20:51:20 27664 8192000000 10943272352 11402276864 1961756768 19.320 99 24 48 0 2011708608 41629440 8322400
20:51:54 26578 8192000000 10933303392 11392753664 1946982976 19.202 99 21 42 0 2006880768 51246192 8651600
20:52:41 34491 8192000000 10901378960 11369234432 1907926288 18.890 98 14 28 0 1955327440 42533984 4867168
20:53:28 46772 8192000000 10857051312 11336581120 1883391392 18.692 97 13 26 0 1932458192 43995488 5071312
20:54:21 44369 8192000000 10832980176 11299024896 1857563408 18.484 97 19 38 0 1878546944 15937840 5045696
20:55:13 85916 8192000000 10854685840 11308007424 1895935696 18.794 99 36 69 3 1916946704 10806000 10205008
20:56:46 32708 8192000000 10858463552 11317796864 1931488560 19.079 100 54 110 2 1960683248 13746816 15447872
20:57:25 70949 8192000000 10828245312 11280592896 1819742368 18.176 94 26 52 2 1834144544 7937968 6464208
20:59:08 79189 8192000000 10882783184 11338264576 1924241392 19.021 99 31 62 0 1946881136 14470992 8168752
21:00:46 207818 8192000000 10856342608 11315904512 1829643024 18.256 94 18 37 0 1845740224 11308080 4789120
21:04:20 124254 8192000000 10878703744 11352264704 1891840752 18.761 97 12 24 1 1909705472 14407376 3457344
21:08:25 73605 8192000000 10905336304 11339497472 1921491936 18.999 98 32 64 3 1941185376 10121840 9571600
21:09:44 53585 8192000000 10892827312 11357282304 1965163952 19.347 100 36 72 1 1984167072 9343968 9659152
21:10:55 44364 8192000000 10890052816 11354865664 1933963968 19.099 98 32 64 0 1952282048 9969408 8348672
21:12:29 38942 8192000000 10886748896 11337035776 1921865728 19.002 98 24 48 0 1944732272 16793792 6072752
21:13:15 52975 8192000000 10878930096 11345747968 1941939616 19.162 99 27 54 0 1960286144 10992736 7353792
21:14:14 36942 8192000000 10898475280 11354750976 1945019424 19.187 99 25 50 1 1961425664 8798016 7608224
21:15:27 99608 8192000000 10909587808 11362041856 1932477408 19.087 98 14 28 1 1948942096 12509456 3955232
21:17:15 41055 8192000000 10900740592 11365376000 1972416176 19.405 100 21 42 1 1987537824 9279296 5842352
21:18:09 89630 8192000000 10911118816 11390947328 1958415488 19.293 99 24 48 0 1982315488 17686256 6213744
21:19:45 75562 8192000000 10917428672 11384053760 1968320304 19.372 99 17 34 0 1987922512 15061440 4540768
21:21:16 131272 8192000000 10911572672 11379027968 1967406032 19.365 99 25 50 0 1987160080 12678272 7075776
21:24:11 3255 8192000000 10931520528 11378868224 1979702176 19.462 99 38 78 1 1999827600 9876208 10249216
21:24:22 22854 8192000000 10939487264 11397967872 1998139776 19.608 100 45 91 0 2022387840 11324960 12923104
21:24:54 38014 8192000000 10913344192 11395645440 1995709728 19.589 100 10 20 1 2008781024 10185664 2885632
21:26:12 37882 8192000000 10902349744 11394674688 1988861360 19.535 100 6 12 1 2001413696 10618208 1934128
21:26:56 24502 8192000000 10888177904 11366952960 1969474896 19.381 99 10 20 1 1981632432 9120192 3037344
21:27:27 25498 8192000000 10886115840 11358728192 1947321360 19.205 98 11 22 1 1960224032 9958976 2943696
21:27:58 86028 8192000000 10886118720 11367366656 1912975712 18.931 97 11 22 0 1923940640 8250752 2714176
21:29:31 42767 8192000000 10863339840 11354120192 1925895648 19.034 98 5 10 0 1942757568 15538944 1322976
21:30:31 34902 8192000000 10854236848 11315392512 1918666384 18.976 98 19 38 0 1933430160 9336976 5426800
21:31:20 42456 8192000000 10883244960 11336134656 1919612272 18.984 98 19 37 1 1936266096 11636832 5016992
21:32:16 82427 8192000000 10878599552 11353235456 1869285808 18.578 95 15 30 0 1887018160 13492288 4240064
21:33:45 83793 8192000000 10898480672 11360690176 1904756720 18.865 97 14 28 0 1923053120 14287120 4009280
21:35:15 46248 8192000000 10888071104 11339214848 1883778272 18.696 96 22 44 1 1900943456 10610752 6554432
21:36:16 22476 8192000000 10910938160 11353706496 1953389632 19.253 100 60 120 1 1984995344 14251504 17354208
21:36:47 36272 8192000000 10847374704 11315101696 1847585536 18.403 95 35 70 0 1872524336 15223680 9715120
21:37:42 58511 8192000000 10847359440 11305099264 1858282384 18.489 96 18 36 1 1871329312 8199824 4847104
21:39:06 24664 8192000000 10874666448 11320803328 1903410048 18.854 98 48 95 0 1927000864 10541712 13049104
21:39:37 41717 8192000000 10880597312 11331010560 1913855344 18.938 99 34 68 0 1933893552 10559072 9479136
21:40:30 32663 8192000000 10886333616 11347415040 1928609920 19.056 99 38 76 1 1951095552 11861040 10624592
21:41:15 89455 8192000000 10900569936 11369828352 1925251280 19.029 98 23 46 0 1953121664 21505440 6364944
21:42:55 111871 8192000000 10862516512 11334070272 1875667296 18.630 96 10 20 1 1890371136 12178448 2525392
21:45:29 72438 8192000000 10848913280 11322523648 1901186464 18.836 98 15 30 1 1915954880 10834992 3933424
21:46:48 56611 8192000000 10848274976 11335860224 1899555088 18.823 98 10 20 0 1911786000 9532672 2698240
21:47:51 48768 8192000000 10836005392 11310825472 1878978256 18.657 97 10 20 0 1895469552 13806528 2684768
21:48:46 46169 8192000000 10851211008 11321745408 1932032176 19.083 100 12 24 0 1943684736 8264976 3387584
21:49:43 59883 8192000000 10859072400 11333140480 1905555408 18.871 98 19 38 0 1922438176 11007744 5875024
21:50:51 46360 8192000000 10850813168 11322314752 1915155408 18.948 99 13 26 0 1939644224 20648896 3839920
21:51:44 53469 8192000000 10868664784 11335045120 1931275632 19.077 100 16 32 2 1953922960 17845200 4802128
21:53:00 34614 8192000000 10843579584 11322376192 1905780144 18.873 98 19 39 1 1921528976 10131120 5617712
21:53:45 61523 8192000000 10838739440 11314061312 1890998720 18.754 98 6 12 1 1900817120 8236992 1581408
21:55:00 40748 8192000000 10835287600 11288588288 1827401744 18.238 95 28 56 0 1846062784 11397840 7263200
21:55:49 43142 8192000000 10821911536 11279319040 1853971264 18.454 97 39 77 2 1874101120 8877536 11252320
21:56:44 82014 8192000000 10859680304 11323760640 1906701056 18.880 99 12 24 2 1917839936 8558928 2579952
21:58:44 90876 8192000000 10866259856 11327856640 1835915360 18.308 94 15 30 0 1851672352 11139280 4617712
22:00:26 97941 8192000000 10869852384 11338551296 1902866992 18.849 98 13 26 2 1925771952 18379552 4525408
22:02:10 43745 8192000000 10898123168 11355668480 1951592896 19.239 100 19 38 1 1965215648 8322416 5300336
22:03:05 11500 8192000000 10914582752 11360186368 1972849488 19.408 100 64 126 0 2002773328 10758112 19165728
22:03:26 45815 8192000000 10916272704 11372539904 1954732096 19.264 99 34 68 2 1984623152 20437760 9453296
22:04:21 37462 8192000000 10914271184 11374256128 1952025168 19.243 99 32 64 3 1974520768 13578704 8916896
22:05:06 74648 8192000000 10896939328 11353210880 1930903952 19.074 98 18 36 2 1947589728 11944720 4741056
22:06:28 24347 8192000000 10936854304 11375394816 1974826864 19.424 100 35 70 0 1995063296 10609312 9627120
22:07:00 15913 8192000000 10921616464 11377475584 1982060528 19.481 100 48 95 0 2006993280 11929344 13003408
22:07:22 132227 8192000000 10918201984 11380133888 1936928272 19.122 98 20 40 0 1949296256 6814576 5553408
22:09:49 93951 8192000000 10910140320 11387699200 1971198608 19.395 99 20 40 0 1988816400 11535088 6082704
22:11:31 67157 8192000000 10912444416 11398803456 1991305952 19.554 100 10 20 1 2009293248 14866624 3120672
22:12:45 41971 8192000000 10915221552 11393720320 1991382016 19.555 100 12 24 0 2012275520 17093616 3799888
22:13:36 47104 8192000000 10912009264 11396038656 1991492032 19.556 100 15 29 1 2005644848 9466624 4686192
22:14:29 72180 8192000000 10883102400 11374051328 1890946368 18.753 95 11 21 1 1905504736 10922960 3635408
22:15:48 71616 8192000000 10913498672 11391324160 1980449120 19.468 100 18 36 0 1992535568 6521184 5565264
22:17:11 70303 8192000000 10911854112 11388604416 1932135840 19.084 97 16 30 1 1948463200 12014496 4312864
22:18:39 75246 8192000000 10928675056 11388919808 1961479696 19.318 99 16 32 0 1977882896 12142544 4260656
22:20:07 83535 8192000000 10902732224 11383775232 1911660624 18.920 96 21 42 0 1931961392 14758704 5542064
22:21:37 61800 8192000000 10904814816 11375554560 1919967776 18.987 97 15 30 1 1936494752 12173776 4353200
22:22:48 27496 8192000000 10924178224 11386761216 1967306480 19.364 99 45 90 1 1990338912 9615872 13416560
22:23:21 53300 8192000000 10880668752 11350609920 1861270320 18.514 94 27 54 1 1881119056 12619760 7228976
22:24:23 97814 8192000000 10871766672 11346264064 1856233552 18.473 95 13 26 0 1881431840 21360288 3838000
22:26:08 30748 8192000000 10873938928 11339026432 1913389344 18.934 98 28 55 4 1930165712 8575216 8201152
22:26:47 30874 8192000000 9330669264 9599029248 467774144 5.401 24 8 15 0 472761744 2796560 2191040

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 18-01-2021 22:28:00 to 18-01-2021 22:28:30.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 130 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 18-01-2021 22:28:31 to 18-01-2021 22:28:33.

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          239319
MON$OLDEST_ACTIVE               239320
MON$OLDEST_SNAPSHOT             239320
MON$NEXT_TRANSACTION            239320
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                       2008384
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 ---
:20: 
:21: mscs-test-161.budzdorov.ru    Mon Jan 18 22:27:21 2021
:22:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:23: 
:24: 
:25: mscs-test-161.budzdorov.ru    Mon Jan 18 22:27:22 2021
:26:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:27: 
:28: 
:29: mscs-test-161.budzdorov.ru    Mon Jan 18 22:27:22 2021
:30:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:31: 
:32: 
:33: mscs-test-161.budzdorov.ru    Mon Jan 18 22:27:22 2021
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
--- end of diff output ---

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

18.01.21 22:28:34. 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-18 22:28:36 No severe PSQL-related problems occured
18.01.21 22:28:38. End of report.