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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17554468 kB
MemAvailable 31494604 kB
Buffers 0 kB
Cached 14089240 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-23 16:27:24
DTS_END                         2021-03-23 16:27:24.0560
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44506
TRN_ID                          239447
ATT_ID                          623
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: 8711.03 28226 1045324
customer order: creation 168.85 353 20262
customer order: refuse 14.22 315 1706
order to supplier: creation 45.65 1232 5478
order to supplier: removal 3.24 101054 389
invoice (draft): creation 44.82 3736 5378
invoice (draft): removal 49.07 838 5888
invoice accept: apply 40.60 17114 4872
invoice accept: cancel 44.43 838 5331
customer reserve: creation 3708.04 171 444965
customer reserve: removal 4298.04 60 515765
realization accept: apply 83.64 166 10037
realization accept: cancel 81.43 104 9771
payment from customer: creation 59.12 118 7094
payment from customer: removal 5.68 63 682
payment to supplier: creation 48.85 137 5862
payment to supplier: removal 3.32 72 398
service: total inventory turnovers 4.68 1115 561
service: total monetary turnovers 6.49 20 779
service: aggregate perf. data 0.85 17804 102
service: refresh index statistics 0.03 419206 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-03-2021 16:28:35 to 23-03-2021 16:28:37.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 633
TEST_TIME 2 3418
TEST_TIME 3 3897
TEST_TIME 4 4705
TEST_TIME 5 4671
TEST_TIME 6 4680
TEST_TIME 7 4567
TEST_TIME 8 4488
TEST_TIME 9 4703
TEST_TIME 10 5173
TEST_TIME 11 5080
TEST_TIME 12 5542
TEST_TIME 13 6221
TEST_TIME 14 6339
TEST_TIME 15 6548
TEST_TIME 16 6908
TEST_TIME 17 7289
TEST_TIME 18 7769
TEST_TIME 19 7870
TEST_TIME 20 7940
TEST_TIME 21 8090
TEST_TIME 22 8332
TEST_TIME 23 8921
TEST_TIME 24 9328
TEST_TIME 25 9364
TEST_TIME 26 10369
TEST_TIME 27 10507
TEST_TIME 28 10621
TEST_TIME 29 10444
TEST_TIME 30 10257
TEST_TIME 31 10098
TEST_TIME 32 10012
TEST_TIME 33 9933
TEST_TIME 34 9805
TEST_TIME 35 9608
TEST_TIME 36 9596
TEST_TIME 37 9442
TEST_TIME 38 9569
TEST_TIME 39 9396
TEST_TIME 40 9321
TEST_TIME 41 9274
TEST_TIME 42 9313
TEST_TIME 43 9318
TEST_TIME 44 9247
TEST_TIME 45 9181
TEST_TIME 46 9248
TEST_TIME 47 9220
TEST_TIME 48 9318
TEST_TIME 49 9227
TEST_TIME 50 9232
TEST_TIME 51 9270
TEST_TIME 52 9400
TEST_TIME 53 9352
TEST_TIME 54 9474
TEST_TIME 55 9412
TEST_TIME 56 9574
TEST_TIME 57 9553
TEST_TIME 58 9487
TEST_TIME 59 9429
TEST_TIME 60 9366
TEST_TIME 61 9339
TEST_TIME 62 9322
TEST_TIME 63 9342
TEST_TIME 64 9345
TEST_TIME 65 9255
TEST_TIME 66 9190
TEST_TIME 67 9147
TEST_TIME 68 9183
TEST_TIME 69 9196
TEST_TIME 70 9124
TEST_TIME 71 9180
TEST_TIME 72 9197
TEST_TIME 73 9230
TEST_TIME 74 9167
TEST_TIME 75 9182
TEST_TIME 76 9212
TEST_TIME 77 9228
TEST_TIME 78 9164
TEST_TIME 79 9215
TEST_TIME 80 9249
TEST_TIME 81 9194
TEST_TIME 82 9153
TEST_TIME 83 9092
TEST_TIME 84 9093
TEST_TIME 85 9048
TEST_TIME 86 8997
TEST_TIME 87 9005
TEST_TIME 88 8956
TEST_TIME 89 8944
TEST_TIME 90 8880
TEST_TIME 91 8855
TEST_TIME 92 8841
TEST_TIME 93 8895
TEST_TIME 94 8837
TEST_TIME 95 8853
TEST_TIME 96 8937
TEST_TIME 97 8886
TEST_TIME 98 8914
TEST_TIME 99 8961
TEST_TIME 100 8914
TEST_TIME 101 8945
TEST_TIME 102 9008
TEST_TIME 103 9018
TEST_TIME 104 9000
TEST_TIME 105 9063
TEST_TIME 106 9042
TEST_TIME 107 9027
TEST_TIME 108 9021
TEST_TIME 109 8966
TEST_TIME 110 8921
TEST_TIME 111 8903
TEST_TIME 112 8881
TEST_TIME 113 8874
TEST_TIME 114 8838
TEST_TIME 115 8810
TEST_TIME 116 8786
TEST_TIME 117 8777
TEST_TIME 118 8766
TEST_TIME 119 8755
TEST_TIME 120 8712

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 23-03-2021 16:28:38 to 23-03-2021 16:28:42.

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 1457206 1457206 0 0.00 0 28652 6 0 0
doc_list_biud 1457206 1457206 0 0.00 0 39598 27 0 0
sp_add_invoice_to_stock 4998 4872 126 2.52 34 176479 17115 0 126
sp_cancel_adding_invoice 5331 5331 0 0.00 4 72511 838 0 0
sp_cancel_client_order 1706 1706 0 0.00 4 8693 316 0 0
sp_cancel_customer_reserve 515765 515765 0 0.00 1 28615 60 0 0
sp_cancel_pay_from_customer 682 682 0 0.00 2 2895 64 0 0
sp_cancel_pay_to_supplier 398 398 0 0.00 3 4580 73 0 0
sp_cancel_supplier_invoice 5899 5888 11 0.18 1 14261 839 0 11
sp_cancel_supplier_order 389 389 0 0.00 8 1034840 101055 0 0
sp_cancel_write_off 9771 9771 0 0.00 1 10328 104 0 0
sp_client_order 20262 20262 0 0.00 4 28569 353 0 0
sp_customer_reserve 444965 444965 0 0.00 0 110589 172 0 0
sp_fill_shopping_cart 31101 31101 0 0.00 1 8877 38 0 0
sp_fill_shopping_cart_clo_res 444959 444959 0 0.00 0 14951 14 0 0
sp_get_clo_for_invoice 4866 4866 0 0.00 0 23608 295 0 0
sp_kill_cost_storno 16182 16182 0 0.00 0 10325 54 0 0
sp_kill_qstorno_ret_qs2qd 1047578 1047578 0 0.00 0 28610 33 0 0
sp_kill_qty_storno 553753 553753 0 0.00 0 39597 71 0 0
sp_lock_selected_doc 20529 20529 0 0.00 0 9905 6 0 0
sp_make_cost_storno 27859 27859 0 0.00 0 14473 52 0 0
sp_multiply_rows_for_pdistr 27859 27859 0 0.00 0 6826 26 0 0
sp_multiply_rows_for_qdistr 20262 20262 0 0.00 0 16185 145 0 0
sp_pay_from_customer 7094 7094 0 0.00 4 17339 119 0 0
sp_pay_to_supplier 5862 5862 0 0.00 4 16513 138 0 0
sp_payment_common 12956 12956 0 0.00 1 11579 29 0 0
sp_qd_handle_on_cancel_clo 1706 1706 0 0.00 0 8682 283 0 0
sp_qd_handle_on_invoice_upd_sts 10197 10197 0 0.00 0 39596 339 0 0
sp_qd_handle_on_reserve_upd_sts 10037 10037 0 0.00 0 11186 56 0 0
sp_reserve_write_off 10037 10037 0 0.00 6 18780 167 0 0
sp_supplier_invoice 5378 5378 0 0.00 6 103883 3736 0 0
sp_supplier_order 5478 5478 0 0.00 5 31840 1233 0 0
srv_aggregate_perf_data 102 102 0 0.00 2463 166846 17805 0 0
srv_fill_mon_cache_memory 147 147 0 0.00 1109 139209 36208 0 0
srv_find_qd_qs_mism 998467 998467 0 0.00 0 28612 5 0 0
srv_make_invnt_saldo 561 561 0 0.00 18 79750 1116 0 0
srv_make_money_saldo 779 779 0 0.00 1 550 21 0 0
srv_recalc_idx_stat 4 4 0 0.00 217707 603446 419206 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 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4872 4872 0 0.00 0 12809 162 0 0
t$perf-norm:sp_cancel_adding_invoice 384 384 0 0.00 1 4975 131 0 0
t$perf-norm:sp_cancel_client_order 1706 1706 0 0.00 0 4572 14 0 0
t$perf-norm:sp_cancel_customer_reserve 669 669 0 0.00 0 9354 26 0 0
t$perf-norm:sp_cancel_pay_from_customer 682 682 0 0.00 0 650 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 398 398 0 0.00 0 6286 19 0 0
t$perf-norm:sp_cancel_supplier_invoice 395 395 0 0.00 0 6020 28 0 0
t$perf-norm:sp_cancel_supplier_order 389 389 0 0.00 0 36263 1717 0 0
t$perf-norm:sp_cancel_write_off 1003 1003 0 0.00 0 13595 21 0 0
t$perf-norm:sp_client_order 20262 20262 0 0.00 0 13611 22 0 0
t$perf-norm:sp_customer_reserve 975 975 0 0.00 0 6482 13 0 0
t$perf-norm:sp_pay_from_customer 7095 7095 0 0.00 0 13341 19 0 0
t$perf-norm:sp_pay_to_supplier 5862 5862 0 0.00 0 13577 17 0 0
t$perf-norm:sp_reserve_write_off 10037 10037 0 0.00 0 13156 16 0 0
t$perf-norm:sp_supplier_invoice 5378 5378 0 0.00 0 8712 23 0 0
t$perf-norm:sp_supplier_order 5478 5478 0 0.00 0 4837 15 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 290 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 147 147 0 0.00 0 50 1 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 1034 19 0 0
t$perf-norm:srv_make_money_saldo 779 779 0 0.00 0 1344 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 9984 9732 252 2.52 0 8756 19 0 252
v_all_customers 37390 37390 0 0.00 0 15 1 0 0
v_all_suppliers 30008 30008 0 0.00 0 17 1 0 0
v_all_wares 40524 40524 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 768 768 0 0.00 0 329 6 0 0
v_cancel_client_order 3412 3412 0 0.00 0 4847 9 0 0
v_cancel_customer_prepayment 1364 1364 0 0.00 0 2889 8 0 0
v_cancel_customer_reserve 1338 1338 0 0.00 0 2159 7 0 0
v_cancel_payment_to_supplier 796 796 0 0.00 0 1678 6 0 0
v_cancel_supplier_invoice 812 790 22 2.70 0 272 12 0 22
v_cancel_supplier_order 778 778 0 0.00 0 3334 8 0 0
v_cancel_write_off 2006 2006 0 0.00 0 3566 13 0 0
v_max_id_clo_ord 5477 5477 0 0.00 0 2359 2 0 0
v_max_id_clo_res 975 975 0 0.00 0 2849 15 0 0
v_max_id_ord_sup 5362 5362 0 0.00 0 6474 5 0 0
v_max_non_paid_invoice 1697 1697 0 0.00 0 264 2 0 0
v_max_non_paid_realizn 3667 3667 0 0.00 0 6303 6 0 0
v_min_id_clo_ord 5477 5477 0 0.00 0 5580 7 0 0
v_min_id_clo_res 975 975 0 0.00 0 6011 16 0 0
v_min_id_ord_sup 5362 5362 0 0.00 0 7844 10 0 0
v_min_non_paid_invoice 5862 5862 0 0.00 0 10957 16 0 0
v_min_non_paid_realizn 7094 7094 0 0.00 0 5824 21 0 0
v_our_firm 9988 9988 0 0.00 0 15 1 0 0
v_reserve_write_off 20074 20074 0 0.00 0 8009 6 0 0
x_lock_depdocs_on_canc_invoice 10824 10824 0 0.00 0 27380 116 0 0
x_lock_depdocs_on_canc_sup_ord 389 389 0 0.00 0 8924 339 0 0
x_make_qstorno_1000_1200 5478 5478 0 0.00 2 31794 1156 0 0
x_make_qstorno_1200_2000 5378 5378 0 0.00 3 100315 3589 0 0
x_make_qstorno_2100_3300 444965 444965 0 0.00 0 110588 155 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 23-03-2021 16:28:42 to 23-03-2021 16:28:47.

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:27 7 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:34 26430 8192000000 10279648704 10586062848 837919440 9.279 65 46 94 1 855703056 2390336 15393280
13:58:10 27271 8192000000 10346915088 10662543360 1399685968 14.592 100 88 176 0 1433333040 4947344 28699728
13:58:48 23023 8192000000 10370440208 10690506752 1424580688 14.813 100 87 174 1 1459496080 5951744 28963648
13:59:21 15801 8192000000 10388777440 10713595904 1440965040 14.958 100 81 162 0 1473817056 6269120 26582896
13:59:45 13427 8192000000 10419992272 10747211776 1471174864 15.224 100 89 176 1 1506402128 6904208 28323056
14:00:12 21754 8192000000 10437344720 10767376384 1493170768 15.417 100 90 180 0 1530180016 7800368 29208880
14:00:46 27938 8192000000 10461422288 10798088192 1512074896 15.581 100 83 166 0 1546821840 8315488 26431456
14:01:21 17171 8192000000 10481303088 10821890048 1539101568 15.816 100 79 158 2 1572097808 8454688 24541552
14:01:46 12253 8192000000 10499009872 10848772096 1559947184 15.996 100 73 146 1 1592092016 8967696 23177136
14:02:09 16422 8192000000 10539606848 10891694080 1588398896 16.240 100 79 158 0 1622146576 9518960 24228720
14:02:42 17318 8192000000 10573796320 10934263808 1626065584 16.561 100 80 160 1 1660584560 10907776 23611200
14:03:08 6945 8192000000 10587768640 10953224192 1651354560 16.776 100 79 158 0 1685814256 11073408 23386288
14:03:28 9526 8192000000 10616746160 10982866944 1677609296 16.997 100 82 164 0 1713650368 11636400 24404672
14:03:47 7440 8192000000 10619255344 10989711360 1683767872 17.049 100 74 146 1 1717260848 11377040 22115936
14:04:01 10625 8192000000 10639379856 11007021056 1696161104 17.153 100 80 159 2 1731043008 11620976 23260928
14:04:20 8414 8192000000 10648638192 11019886592 1713774688 17.300 100 72 144 0 1746045968 12056256 20215024
14:04:39 10526 8192000000 10676120992 11045810176 1735895712 17.485 100 83 166 0 1773235520 13175968 24163840
14:04:58 8329 8192000000 10688082944 11063627776 1744873136 17.559 100 82 163 0 1781469200 13596704 22999360
14:05:13 5722 8192000000 10690571584 11068870656 1754607760 17.640 100 78 154 3 1791163968 14105632 22450576
14:05:26 5747 8192000000 10709117232 11082031104 1762669504 17.706 100 78 156 0 1798432512 14155648 21607360
14:05:40 4730 8192000000 10711640096 11091554304 1774252224 17.802 100 81 162 0 1810105808 13304400 22549184
14:05:52 3344 8192000000 10714360560 11091279872 1779262256 17.843 100 87 171 3 1816871776 13594224 24015296
14:06:02 4082 8192000000 10732035120 11114008576 1786523904 17.903 100 81 163 1 1823032640 13949952 22558784
14:06:14 4561 8192000000 10740001488 11118608384 1798021856 17.998 100 84 167 1 1834219008 13248608 22948544
14:06:25 3446 8192000000 10748516064 11130826752 1805462544 18.059 100 83 166 1 1842148752 13777872 22908336
14:06:36 3274 8192000000 10752006736 11134803968 1813351968 18.123 100 88 173 0 1851027680 13802000 23873712
14:06:45 3022 8192000000 10757731696 11144900608 1820854784 18.185 100 86 172 2 1858557376 14368096 23334496
14:06:56 2195 8192000000 10762693376 11147759616 1823898848 18.210 100 91 182 1 1863998272 14835552 25263872
14:07:04 4133 8192000000 10768097136 11152220160 1827120288 18.236 100 82 162 0 1863511360 14320624 22070448
14:07:15 3750 8192000000 10772459584 11158814720 1829754800 18.257 100 89 178 0 1868394304 14028336 24611168
14:07:27 1923 8192000000 10785169232 11170263040 1842595984 18.362 100 87 168 1 1877968544 12715616 22656944
14:07:36 1969 8192000000 10792141776 11175186432 1844985904 18.381 100 89 179 1 1884418224 13594800 25837520
14:07:44 1361 8192000000 10785752576 11176546304 1847792880 18.404 100 79 156 2 1882013952 12455104 21765968
14:07:53 1500 8192000000 10789062384 11175825408 1855227904 18.465 100 93 186 1 1894076944 12624208 26224832
14:08:01 1706 8192000000 10795124592 11179954176 1856731600 18.477 100 96 190 1 1897223392 14095504 26396288
14:08:09 1770 8192000000 10802628816 11185020928 1857216080 18.481 100 95 190 2 1898739696 14567536 26956080
14:08:17 1865 8192000000 10807925648 11192561664 1857060912 18.479 100 95 189 2 1896984864 13290992 26632960
14:08:25 1698 8192000000 10801110656 11190894592 1860419024 18.507 100 87 174 0 1897789488 12270144 25100320
14:08:34 1956 8192000000 10814442448 11197689856 1866272624 18.554 100 96 192 0 1906635952 13116752 27246576
14:08:42 13008 8192000000 10805007808 11197353984 1867051344 18.560 100 81 163 1 1904534240 14962480 22520416
14:09:03 1612 8192000000 10818025648 11207303168 1875126096 18.626 100 91 183 2 1913727920 12660864 25940960
14:09:12 4126 8192000000 10814744496 11207479296 1875150816 18.626 100 84 169 1 1910433424 12329616 22952992
14:09:22 1859 8192000000 10811093584 11208347648 1872288912 18.603 100 77 153 1 1907244656 13161232 21794512
14:09:31 2778 8192000000 10795711216 11207565312 1873013296 18.609 100 42 83 1 1893803904 9199472 11591136
14:09:40 3228 8192000000 10801454640 11211137024 1876805536 18.639 100 52 105 1 1901530064 9652128 15072400
14:09:51 5914 8192000000 10807080112 11221110784 1883403904 18.693 100 54 108 0 1908537072 10486896 14646272
14:10:05 3898 8192000000 10799691040 11215896576 1881082928 18.674 100 42 81 1 1901260448 9187648 10989872
14:10:15 4631 8192000000 10801499520 11216551936 1882430064 18.685 100 46 92 1 1904780448 9349680 13000704
14:10:27 4496 8192000000 10799265120 11217797120 1884148416 18.699 100 25 51 3 1896705072 5561360 6995296
14:10:38 6296 8192000000 10808699680 11220881408 1886582144 18.718 100 30 60 4 1901929552 6486944 8860464
14:10:53 14484 8192000000 10790704800 11224051712 1890199024 18.747 100 27 54 2 1906466064 7823232 8443808
14:11:14 10117 8192000000 10793242080 11224276992 1887219488 18.723 100 23 46 1 1900237488 6626320 6391680
14:11:31 9078 8192000000 10794978784 11225890816 1890838160 18.753 100 12 24 0 1900100160 5589904 3672096
14:11:47 11907 8192000000 10797590736 11229360128 1892782400 18.768 100 14 28 2 1903035968 6066816 4186752
14:12:05 11004 8192000000 10795161808 11230797824 1900233136 18.828 100 26 53 0 1913009536 5165264 7611136
14:12:24 65934 8192000000 10821417824 11247517696 1895410928 18.789 100 24 48 0 1907801008 5493872 6896208
14:13:36 6305 8192000000 10806352544 11244167168 1900176112 18.828 100 23 46 1 1912577408 5867440 6533856
14:13:50 3718 8192000000 10821924736 11253080064 1905851232 18.873 100 40 80 1 1925953680 8419872 11682576
14:14:01 3603 8192000000 10820586816 11251904512 1903627200 18.855 100 31 62 0 1918536928 6547536 8362192
14:14:11 5905 8192000000 10823852480 11255103488 1904803072 18.865 100 37 74 2 1922026128 5876896 11346160
14:14:24 3852 8192000000 10825775472 11256434688 1906642960 18.880 100 32 65 0 1923055984 7097264 9315760
14:14:35 6324 8192000000 10831431520 11260329984 1906492608 18.878 100 31 62 1 1922560672 6548848 9519216
14:14:49 8091 8192000000 10834194720 11260456960 1910705008 18.912 100 27 53 3 1923301664 5301600 7295056
14:15:09 9658 8192000000 10816811344 11259797504 1912612512 18.928 100 28 56 2 1926980240 5577296 8790432
14:15:26 9181 8192000000 10832612288 11267678208 1911321488 18.917 100 19 37 1 1922163040 5547504 5294048
14:15:41 6058 8192000000 10821605120 11258093568 1907626112 18.888 100 17 34 0 1918413568 6020288 4767168
14:15:53 6850 8192000000 10824054336 11261014016 1911301344 18.917 100 28 56 1 1925748704 6766704 7680656
14:16:08 12260 8192000000 10824779408 11265400832 1912551280 18.927 100 18 36 1 1924027344 5949984 5526080
14:16:26 6961 8192000000 10816826208 11258490880 1910077344 18.907 100 21 42 1 1921578960 5359584 6142032
14:16:40 6474 8192000000 10821117072 11249790976 1889651824 18.743 99 22 43 1 1901819776 5562688 6605264
14:16:55 67342 8192000000 10717625776 11136335872 1717852496 17.334 91 35 68 0 1732148304 5286480 9009328
14:18:09 10001 8192000000 10756891312 11190845440 1835169808 18.301 99 13 26 1 1844220928 5448144 3602976
14:18:25 8604 8192000000 10764858544 11192406016 1824905600 18.218 98 14 26 1 1834588576 5425184 4257792
14:18:42 8980 8192000000 10741108112 11165954048 1757714224 17.665 94 22 43 2 1769467104 5615488 6137392
14:18:59 6249 8192000000 10782970688 11205779456 1841688112 18.355 99 33 64 2 1865912928 15485072 8739744
14:19:16 6649 8192000000 10734277200 11157049344 1772711920 17.789 96 34 68 1 1793838608 11475920 9650768
14:19:29 7068 8192000000 10662589040 11075293184 1634309760 16.631 90 32 64 2 1649135296 5126928 9698608
14:19:47 4450 8192000000 10707627648 11123339264 1791664448 17.945 100 31 62 2 1806567968 5684800 9218720
14:19:58 9942 8192000000 10720328160 11136602112 1746728416 17.574 96 16 31 1 1756880800 5170432 4981952
14:20:15 8171 8192000000 10707192048 11120119808 1758316672 17.670 98 19 38 2 1769364016 5348768 5698576
14:20:32 9891 8192000000 10674603856 11095248896 1717405728 17.331 96 22 44 2 1729392496 5702960 6283808
14:20:48 11724 8192000000 10698369504 11104813056 1734735696 17.475 97 13 26 0 1744193024 5261280 4196048
14:21:08 11433 8192000000 10715070320 11126603776 1778366144 17.836 99 24 49 1 1791200336 5213456 7620736
14:21:26 12625 8192000000 10720708368 11144830976 1789406592 17.927 99 20 40 3 1801459120 5997136 6055392
14:21:47 67935 8192000000 10719571968 11146252288 1766538848 17.738 97 23 46 1 1782763648 9762384 6462416
14:23:02 11170 8192000000 10733996464 11155083264 1805531568 18.059 99 27 53 3 1819077488 6158752 7387168
14:23:22 6709 8192000000 10734088800 11151716352 1802506352 18.034 99 20 40 1 1813815888 6201760 5107776
14:23:35 4552 8192000000 10738879008 11140943872 1806772544 18.069 99 44 88 0 1826422960 6870432 12779984
14:23:50 8826 8192000000 10741977344 11164794880 1828856944 18.250 100 31 62 2 1844349168 6616176 8876048
14:24:07 6814 8192000000 10748310304 11180290048 1838247856 18.327 100 21 42 0 1850779728 5531408 7000464
14:24:23 7260 8192000000 10777519888 11197890560 1851212000 18.432 100 23 46 3 1868044160 9700272 7131888
14:24:39 9789 8192000000 10770805600 11195629568 1853230960 18.448 100 25 50 2 1865583696 5131760 7220976
14:24:55 11734 8192000000 10774380352 11199303680 1859063760 18.496 100 21 42 1 1870327520 5390960 5872800
14:25:13 9496 8192000000 10773068272 11203481600 1861647200 18.517 100 19 38 2 1873225760 5867168 5711392
14:25:29 8006 8192000000 10774749232 11204313088 1861955536 18.519 100 14 28 1 1870726128 4976912 3793680
14:25:43 8813 8192000000 10784015984 11207872512 1864006896 18.536 100 17 35 0 1874474272 5448208 5019168
14:25:59 10950 8192000000 10783917632 11210919936 1866416064 18.555 100 18 36 0 1878334032 5969488 5948480
14:26:18 9128 8192000000 10781679888 11211984896 1867311472 18.563 100 17 36 0 1877236848 4926976 4998400
14:26:38 25223 8192000000 10785684512 11217227776 1876238816 18.635 100 27 54 2 1888660768 5539520 6882432
14:27:29 96033 8192000000 10832557488 11251957760 1901820704 18.841 100 43 84 1 1919879424 6327488 11731232
14:29:19 8053 8192000000 10855487632 11270930432 1917504720 18.967 100 55 110 1 1945302752 12234304 15563728
14:29:35 5471 8192000000 10860910464 11278950400 1924498928 19.023 100 60 120 0 1954169088 12686496 16983664
14:29:52 1779 8192000000 10872625968 11285544960 1932516320 19.087 100 60 119 0 1961778512 12980096 16282096
14:30:04 27772 8192000000 10866892256 11293073408 1933703136 19.096 100 55 110 1 1962476032 13333168 15439728
14:30:40 4962 8192000000 10887424336 11306303488 1939939520 19.146 100 53 106 3 1972299280 16943904 15415856
14:30:52 25872 8192000000 10887765488 11312033792 1945788864 19.193 100 54 108 1 1979916816 17935888 16192064
14:31:29 36755 8192000000 10876125920 11320143872 1950612256 19.231 100 41 82 0 1979761408 17120832 12028320
14:32:21 26169 8192000000 10901596096 11333197824 1941486176 19.159 99 27 54 0 1967129696 16600640 9042880
14:32:56 22848 8192000000 10906385712 11343437824 1971595440 19.398 100 41 82 1 2004775872 20748192 12432240
14:33:26 20092 8192000000 10919099696 11351846912 1973557216 19.414 100 43 82 2 2007461712 21717600 12186896
14:33:53 18578 8192000000 10936804368 11359981568 1980597888 19.469 100 52 102 0 2018140080 21986400 15555792
14:34:21 13273 8192000000 10939622160 11365011456 1985731376 19.510 100 58 116 0 2026092224 23855488 16505360
14:34:45 15762 8192000000 10929352080 11367571456 1985649808 19.509 100 51 102 2 2026126000 25630160 14846032
14:35:07 10131 8192000000 10925883552 11364761600 1987721488 19.526 100 48 92 2 2024842960 23804512 13316960
14:35:26 12545 8192000000 10942371648 11372851200 1987498272 19.524 100 43 86 0 2024211072 23806320 12906480
14:35:50 16348 8192000000 10940503632 11376128000 1993532752 19.572 100 50 100 0 2034498816 26017264 14948800
14:36:15 7232 8192000000 10954773104 11379785728 2000339584 19.625 100 65 128 0 2044814800 25736240 18738976
14:36:30 14969 8192000000 10962906384 11391569920 2004050016 19.655 100 63 125 0 2049715760 26705712 18960032
14:36:55 5838 8192000000 10970259648 11399811072 2011019888 19.710 100 71 138 1 2060427536 29161360 20246288
14:37:11 5563 8192000000 10973869152 11402788864 2011621968 19.714 100 60 120 1 2059757392 30024960 18110464
14:37:26 9779 8192000000 10962396944 11403968512 2009419872 19.697 100 53 106 0 2053357312 27726000 16211440
14:37:43 10838 8192000000 10972082880 11413078016 2014246320 19.735 100 46 92 0 2055794304 27762560 13785424
14:38:01 9978 8192000000 10970687568 11401220096 2014585088 19.738 100 64 127 0 2063067744 28198720 20283936
14:38:18 14877 8192000000 10975988032 11411415040 2012379600 19.720 100 58 116 1 2060172608 29790208 18002800
14:38:46 7566 8192000000 10967340528 11396255744 1997355680 19.602 99 55 109 3 2049088624 34427536 17305408
14:39:10 6364 8192000000 10959767184 11398672384 1986538848 19.516 99 60 119 0 2037913504 32808128 18566528
14:39:27 3975 8192000000 10983743696 11406094336 2002956976 19.646 100 77 151 2 2063964096 38088320 22918800
14:39:41 9991 8192000000 10975399824 11401928704 2005437344 19.666 100 67 131 0 2061520112 36512848 19569920
14:39:58 2316 8192000000 10977664288 11394936832 1991972544 19.559 99 88 174 1 2059249376 41064448 26212384
14:40:07 7995 8192000000 10974156976 11404267520 1988646880 19.533 99 71 142 3 2053928096 42305712 22975504
14:40:23 2849 8192000000 10999529872 11424886784 2017645632 19.762 100 77 153 4 2083929952 42761632 23522688
14:40:33 6140 8192000000 11002292560 11429195776 2016621776 19.754 100 71 141 1 2083612176 44428320 22562080
14:40:50 9119 8192000000 10959974496 11390767104 1973672816 19.415 98 68 136 0 2034486384 39204656 21608912
14:41:06 4753 8192000000 10990242720 11419684864 2006008784 19.670 100 69 138 1 2070114896 42703296 21402816
14:41:23 5699 8192000000 10977514480 11404296192 1995631968 19.588 100 71 142 0 2062233136 44070176 22530992
14:41:36 7353 8192000000 10974891792 11406356480 1999026064 19.615 100 64 126 1 2063342080 44762176 19553840
14:41:53 7943 8192000000 10990768736 11421786112 2008998400 19.694 100 77 151 0 2079649984 47602608 23048976
14:42:10 6531 8192000000 10985579904 11418247168 1990233568 19.546 99 64 128 0 2057302736 47115760 19953408
14:42:31 3669 8192000000 10970234144 11394031616 1984286336 19.499 99 71 142 0 2055004512 48521344 22196832
14:42:44 1780 8192000000 10984157216 11401756672 1966274320 19.356 98 84 167 1 2041253888 49070192 25909376
14:42:53 3310 8192000000 10992434880 11413696512 1998919680 19.614 100 85 169 1 2075039408 50114336 26005392
14:43:05 3616 8192000000 11006091520 11426459648 2007192704 19.679 100 87 173 2 2084017200 51040176 25784320
14:43:18 4443 8192000000 11003763792 11422728192 2004690096 19.660 100 84 165 0 2082190512 52184096 25316320
14:43:29 2057 8192000000 11000437920 11416117248 2003312896 19.649 100 86 171 2 2083780160 54570704 25896560
14:43:38 1650 8192000000 10992960688 11409879040 1982272928 19.483 99 90 180 1 2065344480 54673136 28398416
14:43:47 2700 8192000000 11005077184 11417788416 1997196112 19.601 100 92 183 2 2081139376 55247840 28695424
14:43:57 2350 8192000000 10985147904 11400105984 1978001872 19.449 99 88 175 0 2054514016 50460176 26051968
14:44:07 2518 8192000000 10978450400 11393810432 1971218784 19.395 99 88 177 0 2049928896 51902400 26807712
14:44:18 4724 8192000000 10967318160 11388977152 1973813216 19.416 100 75 150 0 2049013744 51908064 23292464
14:44:30 3085 8192000000 10964262640 11390640128 1963298480 19.332 99 76 150 0 2040378592 52093168 24986944
14:44:40 1531 8192000000 10975894288 11397648384 1980830432 19.471 100 88 176 2 2061263104 52806096 27626576
14:44:50 2633 8192000000 10941480192 11360739328 1949000528 19.219 99 78 155 0 2020154208 46488656 24665024
14:45:00 1107 8192000000 10974700816 11389362176 1975593424 19.430 100 82 160 1 2048459472 47257456 25608592
14:45:08 1212 8192000000 10980871952 11398475776 1987281392 19.522 100 89 176 4 2062334656 48040208 27013056
14:45:15 5199 8192000000 10951095584 11387572224 1972762704 19.407 100 53 106 1 2036642176 46840672 17038800
14:45:30 14863 8192000000 10926303088 11369816064 1947057264 19.203 99 41 82 2 2005351088 45065248 13228576
14:45:52 11361 8192000000 10931932704 11366064128 1944725360 19.184 99 41 82 2 2000849024 43295280 12828384
14:46:10 11093 8192000000 10922977824 11371188224 1945504896 19.191 99 29 58 3 2000106416 45329680 9271840
14:46:27 4895 8192000000 10903520288 11330813952 1932103760 19.084 99 46 92 1 1987726832 41269776 14353296
14:46:39 7838 8192000000 10918866608 11355492352 1951452800 19.238 100 46 92 0 2007023760 41174144 14396816
14:47:01 5231 8192000000 10932786112 11366551552 1953334480 19.253 100 45 87 0 2010284288 43314752 13635056
14:47:13 10783 8192000000 10926460496 11362201600 1951127968 19.235 100 51 102 1 2013230192 45416048 16686176
14:47:34 2836 8192000000 10924593712 11353272320 1941694672 19.160 100 48 96 2 2002915376 45593872 15626832
14:47:44 12837 8192000000 10923748928 11364274176 1946848576 19.201 100 49 98 3 2010448128 47495104 16104448
14:48:20 15235 8192000000 10901528208 11344089088 1897876608 18.809 97 37 74 2 1959938752 48842256 13219888
14:48:43 5239 8192000000 10932296960 11361087488 1945225984 19.188 100 53 100 3 2010706928 49097056 16383888
14:48:55 24658 8192000000 10909716128 11351818240 1890980736 18.754 97 31 60 2 1953792640 51955456 10856448
14:49:27 13228 8192000000 10921080560 11349155840 1898503888 18.814 98 39 78 0 1961982752 50297792 13181072
14:49:49 7329 8192000000 10899773168 11338772480 1918326960 18.973 100 36 72 1 1982720224 51733888 12659376
14:50:03 16346 8192000000 10901885040 11354095616 1929880608 19.066 100 31 62 2 1990689552 49597664 11211280
14:50:30 23545 8192000000 10876856256 11322892288 1901063712 18.835 99 24 48 1 1951009440 41452608 8493120
14:51:06 29253 8192000000 10879026944 11323138048 1898861440 18.817 99 26 52 1 1944249632 36593872 8794320
14:51:47 12297 8192000000 10866528864 11317833728 1912998624 18.931 100 23 46 1 1959355136 37932448 8424064
14:52:06 12873 8192000000 10866300576 11303149568 1856267024 18.473 97 24 47 3 1904668288 40108992 8292272
14:52:26 25832 8192000000 10884301808 11324133376 1903094592 18.851 100 19 38 0 1950879456 40437888 7346976
14:53:00 2246 8192000000 10907823712 11337736192 1928427216 19.054 100 59 116 3 1990878272 43232688 19218368
14:53:18 14529 8192000000 10895953424 11347283968 1933353920 19.094 100 33 66 0 1989703072 44906736 11442416
14:53:41 13590 8192000000 10866012192 11333222400 1887541728 18.726 98 13 26 0 1922492896 30740944 4210224
14:54:03 22261 8192000000 10843690864 11294707712 1882334016 18.684 98 12 24 0 1902516928 16698480 3484432
14:54:32 66941 8192000000 10843680816 11317923840 1909969088 18.906 100 14 28 1 1937715008 23014064 4731856
14:56:00 31459 8192000000 10862498704 11315458048 1928667088 19.056 100 41 81 0 1948845312 9009600 11168624
14:56:44 50842 8192000000 10880062880 11326074880 1924087968 19.020 99 28 56 1 1942359216 10830704 7440544
14:57:55 52843 8192000000 10892414096 11329318912 1930453328 19.071 99 21 42 0 1950411840 13737008 6221504
14:58:57 41008 8192000000 10895548864 11354042368 1960799280 19.312 100 19 38 0 1976195152 10097472 5298400
15:00:04 66527 8192000000 10899408000 11358953472 1949772304 19.225 99 11 22 0 1965220160 12258512 3189344
15:01:19 137801 8192000000 10883540064 11349168128 1894210672 18.780 96 14 28 2 1917291264 18823808 4256784
15:04:31 86871 8192000000 10867696224 11336003584 1944301856 19.181 99 21 42 1 1973085424 22722848 6060720
15:06:06 34333 8192000000 10882709648 11346243584 1968520832 19.374 100 17 35 0 1981552688 8119344 4912512
15:07:05 3877 8192000000 10908046672 11358687232 1983520944 19.493 100 55 107 2 2007821168 9346560 14953664
15:07:15 68826 8192000000 10906041648 11368259584 1973187264 19.411 100 18 36 1 1990731600 12030336 5514000
15:09:36 47746 8192000000 10898217664 11377233920 1978302928 19.451 100 17 34 1 1996570112 13282976 4984208
15:10:30 97429 8192000000 10913153536 11388682240 1985103552 19.505 100 13 26 1 1999937792 11188816 3645424
15:12:16 44384 8192000000 10932273152 11390283776 1993227600 19.569 100 30 59 0 2016498048 15108448 8162000
15:13:15 44064 8192000000 10920459056 11396681728 1973169936 19.411 99 28 56 0 1995740336 14640048 7930352
15:14:07 69757 8192000000 10913349968 11375296512 1958281280 19.292 99 13 26 0 1973051808 11281040 3489488
15:15:33 64995 8192000000 10902478016 11355807744 1924866880 19.026 97 27 54 0 1947720512 14633424 8220208
15:16:45 94583 8192000000 10904322960 11370381312 1903761712 18.857 97 18 36 0 1924929392 16437280 4730400
15:18:26 61850 8192000000 10890303312 11366187008 1920078432 18.987 98 10 20 2 1941181520 18401696 2701392
15:19:38 95197 8192000000 10911101616 11377438720 1950995184 19.234 99 18 36 0 1974433120 18554144 4883792
15:21:28 81084 8192000000 10915461856 11371315200 1950055200 19.227 98 25 50 2 1977504768 21102144 6347424
15:23:02 48308 8192000000 10896199808 11376336896 1927596704 19.048 97 20 40 2 1954029280 20471104 5961472
15:24:19 84010 8192000000 10907936176 11387490304 1973476928 19.413 100 13 26 2 1995050528 17739680 3833920
15:26:19 49607 8192000000 10897102992 11356553216 1916401888 18.958 97 21 40 1 1928134656 6343072 5389696
15:27:19 44831 8192000000 10894168624 11347517440 1910016800 18.907 97 31 62 2 1927647328 9539536 8090992
15:29:36 24126 8192000000 10886999488 11334107136 1908008656 18.891 97 43 86 1 1933838240 14413536 11416048
15:30:07 55269 8192000000 10867490544 11344625664 1907458320 18.886 97 38 76 1 1928678736 10704576 10515840
15:32:21 97912 8192000000 10845959792 11318231040 1900095024 18.827 98 12 23 0 1915147328 11830176 3222128
15:34:05 88839 8192000000 10876360336 11339784192 1880567424 18.670 97 17 34 1 1894972976 9283872 5121680
15:35:40 52332 8192000000 10879022192 11337068544 1916959280 18.962 98 24 47 2 1934701792 10256896 7485616
15:36:50 85386 8192000000 10869590768 11340304384 1919518544 18.983 99 19 38 0 1939286864 14720592 5047728
15:38:21 80315 8192000000 10876501712 11348041728 1872750432 18.607 96 20 40 1 1885581776 7875216 4956128
15:39:52 100027 8192000000 10846069984 11294097408 1729140848 17.428 89 18 36 1 1744466048 10437136 4888064
15:41:40 51100 8192000000 10835360656 11304927232 1896351456 18.797 99 29 58 0 1914485056 10097888 8035712
15:42:37 20398 8192000000 10832352800 11276185600 1841365184 18.352 96 29 57 1 1857774368 7595200 8813984
15:43:15 56794 8192000000 10802434096 11271254016 1801660336 18.028 95 17 34 0 1815893712 9688912 4544464
15:45:10 100744 8192000000 10849087152 11308863488 1879530528 18.661 98 25 49 0 1896774720 10301552 6942640
15:47:02 104907 8192000000 10850836064 11299078144 1872862752 18.607 97 13 26 1 1886357696 10187648 3307296
15:48:57 113189 8192000000 10855760432 11315273728 1889813824 18.744 98 17 34 1 1906047552 11511408 4722320
15:51:07 99300 8192000000 10856997584 11336478720 1912759456 18.929 99 14 28 0 1931844640 14872000 4213184
15:53:01 17058 8192000000 10852701200 11331657728 1916633792 18.960 99 8 16 1 1937180944 18337248 2209904
15:53:24 71163 8192000000 10847053744 11325706240 1913451472 18.934 99 12 25 1 1929429520 13173648 2804400
15:54:43 40062 8192000000 10840831040 11315666944 1913585488 18.935 99 3 6 1 1922063024 7640496 837040
15:55:30 33253 8192000000 10829549536 11297497088 1910286368 18.909 99 14 29 0 1921474400 7376272 3811760
15:56:09 75939 8192000000 10872451568 11336937472 1897915856 18.810 98 11 19 1 1906768480 6036016 2816608
15:57:32 86959 8192000000 10866866544 11343110144 1926641504 19.040 99 19 38 1 1950324912 18805456 4877952
16:00:25 81965 8192000000 10860841840 11326287872 1879009504 18.657 96 9 18 0 1893829296 12464000 2355792
16:01:58 57541 8192000000 10879313440 11347210240 1947074416 19.203 100 18 36 0 1962175456 10325072 4775968
16:03:05 87161 8192000000 10891782512 11349782528 1921308912 18.997 98 19 37 2 1939031184 12120176 5602096
16:04:38 26593 8192000000 10903399168 11361091584 1942361056 19.166 99 19 38 2 1957148848 9537072 5250720
16:05:13 90136 8192000000 10897774192 11374895104 1954432128 19.262 99 30 60 3 1975943792 13377984 8133680
16:06:52 58986 8192000000 10910262144 11353923584 1933201440 19.092 98 30 58 0 1950303904 8951952 8150512
16:07:58 53270 8192000000 10887322416 11358867456 1923469488 19.015 98 21 42 0 1941264048 11484032 6310528
16:09:01 135702 8192000000 10876777472 11362201600 1876842928 18.640 96 9 18 0 1892435552 13204176 2388448
16:11:25 139208 8192000000 10899048800 11371773952 1934089296 19.100 98 13 26 1 1951840992 14305360 3446336
16:14:06 42419 8192000000 10901246048 11358281728 1933291152 19.093 98 32 64 1 1950394176 8212720 8890304
16:14:59 12530 8192000000 10906973904 11346534400 1948572400 19.215 99 42 84 1 1968231520 8090928 11568192
16:15:19 93926 8192000000 10895116048 11358969856 1950236928 19.228 99 29 58 0 1968987840 10948176 7802736
16:17:07 84269 8192000000 10867815552 11329974272 1925742912 19.033 98 36 72 0 1943175200 6845888 10586400
16:18:44 50357 8192000000 10858381728 11323645952 1919720128 18.985 98 13 25 1 1929833088 5826832 4286128
16:19:50 72611 8192000000 10853171232 11335606272 1917208736 18.964 99 10 20 0 1927168096 7360064 2599296
16:21:22 46151 8192000000 10863845680 11333197824 1915301776 18.949 98 12 24 0 1925066976 6554128 3211072
16:22:14 72888 8192000000 10883664352 11345031168 1916275408 18.957 98 12 24 0 1928076032 8394384 3406240
16:23:35 61775 8192000000 10849921600 11334045696 1933798256 19.097 99 13 26 0 1947776144 9940112 4037776
16:24:44 57011 8192000000 10844887888 11310817280 1811646832 18.109 93 11 22 1 1823209888 8565840 2997216
16:25:47 32532 8192000000 10853000240 11319087104 1913733088 18.937 99 25 50 0 1928566528 7978464 6854976
16:26:34 43230 8192000000 10848810064 11306704896 1848846512 18.413 96 41 82 1 1871815728 11695248 11273968

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 23-03-2021 16:28:48 to 23-03-2021 16:29:19.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 126 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-03-2021 16:29:20 to 23-03-2021 16:29:22.

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          238250
MON$OLDEST_ACTIVE               240320
MON$OLDEST_SNAPSHOT             240320
MON$NEXT_TRANSACTION            240320
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                       2010944
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:158: 
:159: mscs-test-161.budzdorov.ru    Tue Mar 23 16:27:27 2021
:160:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:161: 
:162: 
:163: mscs-test-161.budzdorov.ru    Tue Mar 23 16:27:29 2021
:164:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:165: 
--- end of diff output ---

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

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