Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.03.2021 19: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 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 17487136 kB
MemAvailable 31539208 kB
Buffers 0 kB
Cached 14166256 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-15 19:27:23
DTS_END                         2021-03-15 19:27:23.2610
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/35040
TRN_ID                          242826
ATT_ID                          669
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: 9165.78 26004 1099894
customer order: creation 171.38 349 20566
customer order: refuse 14.89 307 1787
order to supplier: creation 46.72 1277 5606
order to supplier: removal 3.38 103029 406
invoice (draft): creation 46.99 3347 5639
invoice (draft): removal 52.92 772 6350
invoice accept: apply 41.28 17646 4953
invoice accept: cancel 47.28 770 5674
customer reserve: creation 3761.53 175 451384
customer reserve: removal 4678.46 59 561415
realization accept: apply 85.20 164 10224
realization accept: cancel 83.52 118 10022
payment from customer: creation 60.13 112 7215
payment from customer: removal 5.73 81 687
payment to supplier: creation 49.95 117 5994
payment to supplier: removal 3.77 59 452
service: total inventory turnovers 5.32 1094 638
service: total monetary turnovers 6.59 29 791
service: aggregate perf. data 0.73 23296 87
service: refresh index statistics 0.03 367276 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 15-03-2021 19:28:07 to 15-03-2021 19:28:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3751
TEST_TIME 2 4113
TEST_TIME 3 3933
TEST_TIME 4 3882
TEST_TIME 5 4570
TEST_TIME 6 5218
TEST_TIME 7 5623
TEST_TIME 8 5647
TEST_TIME 9 5815
TEST_TIME 10 6193
TEST_TIME 11 6447
TEST_TIME 12 7136
TEST_TIME 13 7241
TEST_TIME 14 7638
TEST_TIME 15 7834
TEST_TIME 16 7584
TEST_TIME 17 7893
TEST_TIME 18 7997
TEST_TIME 19 7962
TEST_TIME 20 8448
TEST_TIME 21 8289
TEST_TIME 22 8272
TEST_TIME 23 9031
TEST_TIME 24 9115
TEST_TIME 25 9287
TEST_TIME 26 9323
TEST_TIME 27 9679
TEST_TIME 28 10357
TEST_TIME 29 10768
TEST_TIME 30 10670
TEST_TIME 31 10702
TEST_TIME 32 10422
TEST_TIME 33 10473
TEST_TIME 34 10304
TEST_TIME 35 10176
TEST_TIME 36 9992
TEST_TIME 37 9883
TEST_TIME 38 9796
TEST_TIME 39 9669
TEST_TIME 40 9634
TEST_TIME 41 9690
TEST_TIME 42 9601
TEST_TIME 43 9850
TEST_TIME 44 9733
TEST_TIME 45 9700
TEST_TIME 46 9629
TEST_TIME 47 9464
TEST_TIME 48 9436
TEST_TIME 49 9464
TEST_TIME 50 9370
TEST_TIME 51 9260
TEST_TIME 52 9198
TEST_TIME 53 9272
TEST_TIME 54 9192
TEST_TIME 55 9098
TEST_TIME 56 9016
TEST_TIME 57 9176
TEST_TIME 58 9169
TEST_TIME 59 9172
TEST_TIME 60 9141
TEST_TIME 61 9191
TEST_TIME 62 9157
TEST_TIME 63 9202
TEST_TIME 64 9207
TEST_TIME 65 9254
TEST_TIME 66 9288
TEST_TIME 67 9259
TEST_TIME 68 9294
TEST_TIME 69 9286
TEST_TIME 70 9229
TEST_TIME 71 9290
TEST_TIME 72 9277
TEST_TIME 73 9330
TEST_TIME 74 9276
TEST_TIME 75 9226
TEST_TIME 76 9195
TEST_TIME 77 9179
TEST_TIME 78 9154
TEST_TIME 79 9129
TEST_TIME 80 9094
TEST_TIME 81 9040
TEST_TIME 82 8942
TEST_TIME 83 8950
TEST_TIME 84 9060
TEST_TIME 85 9018
TEST_TIME 86 9055
TEST_TIME 87 9064
TEST_TIME 88 9072
TEST_TIME 89 9069
TEST_TIME 90 9145
TEST_TIME 91 9202
TEST_TIME 92 9251
TEST_TIME 93 9264
TEST_TIME 94 9311
TEST_TIME 95 9400
TEST_TIME 96 9411
TEST_TIME 97 9381
TEST_TIME 98 9373
TEST_TIME 99 9291
TEST_TIME 100 9298
TEST_TIME 101 9243
TEST_TIME 102 9232
TEST_TIME 103 9232
TEST_TIME 104 9187
TEST_TIME 105 9216
TEST_TIME 106 9187
TEST_TIME 107 9126
TEST_TIME 108 9100
TEST_TIME 109 9118
TEST_TIME 110 9119
TEST_TIME 111 9119
TEST_TIME 112 9118
TEST_TIME 113 9137
TEST_TIME 114 9198
TEST_TIME 115 9171
TEST_TIME 116 9177
TEST_TIME 117 9214
TEST_TIME 118 9192
TEST_TIME 119 9199
TEST_TIME 120 9170

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-03-2021 19:28:11 to 15-03-2021 19:28:14.

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 1518818 1518818 0 0.00 0 16593 6 0 0
doc_list_biud 1518818 1518818 0 0.00 0 67484 28 0 0
sp_add_invoice_to_stock 5028 4953 75 1.49 47 183465 17647 0 75
sp_cancel_adding_invoice 5674 5674 0 0.00 5 77736 771 0 0
sp_cancel_client_order 1787 1787 0 0.00 4 7365 308 0 0
sp_cancel_customer_reserve 561415 561415 0 0.00 1 41581 59 0 0
sp_cancel_pay_from_customer 687 687 0 0.00 3 4352 81 0 0
sp_cancel_pay_to_supplier 452 452 0 0.00 3 1513 59 0 0
sp_cancel_supplier_invoice 6355 6350 5 0.07 2 27350 773 0 5
sp_cancel_supplier_order 406 406 0 0.00 6 925545 103029 0 0
sp_cancel_write_off 10022 10022 0 0.00 1 67512 118 0 0
sp_client_order 20566 20566 0 0.00 3 26312 350 0 0
sp_customer_reserve 451384 451384 0 0.00 0 46638 176 0 0
sp_fill_shopping_cart 31804 31804 0 0.00 1 16030 38 0 0
sp_fill_shopping_cart_clo_res 451380 451380 0 0.00 0 16026 12 0 0
sp_get_clo_for_invoice 4946 4946 0 0.00 0 28041 303 0 0
sp_kill_cost_storno 16835 16835 0 0.00 0 6964 54 0 0
sp_kill_qstorno_ret_qs2qd 1139608 1139608 0 0.00 0 67481 32 0 0
sp_kill_qty_storno 600823 600823 0 0.00 0 67482 69 0 0
sp_lock_selected_doc 21031 21031 0 0.00 0 7040 4 0 0
sp_make_cost_storno 28378 28378 0 0.00 0 14301 50 0 0
sp_multiply_rows_for_pdistr 28378 28378 0 0.00 0 6726 27 0 0
sp_multiply_rows_for_qdistr 20566 20566 0 0.00 0 10209 147 0 0
sp_pay_from_customer 7215 7215 0 0.00 4 26109 112 0 0
sp_pay_to_supplier 5994 5994 0 0.00 5 12087 118 0 0
sp_payment_common 13209 13209 0 0.00 1 26091 32 0 0
sp_qd_handle_on_cancel_clo 1787 1787 0 0.00 0 7332 287 0 0
sp_qd_handle_on_invoice_upd_sts 10619 10619 0 0.00 0 29345 343 0 0
sp_qd_handle_on_reserve_upd_sts 10224 10224 0 0.00 0 26518 55 0 0
sp_reserve_write_off 10224 10224 0 0.00 6 26555 165 0 0
sp_supplier_invoice 5639 5639 0 0.00 6 75879 3347 0 0
sp_supplier_order 5606 5606 0 0.00 5 40087 1278 0 0
srv_aggregate_perf_data 87 87 0 0.00 3605 352190 23297 0 0
srv_fill_mon_cache_memory 154 154 0 0.00 1037 145440 35229 0 0
srv_find_qd_qs_mism 1052652 1052652 0 0.00 0 16591 5 0 0
srv_make_invnt_saldo 638 638 0 0.00 26 51049 1095 0 0
srv_make_money_saldo 791 791 0 0.00 1 1738 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 132745 553491 367277 0 0
t$perf-abend:sp_add_invoice_to_stock 75 75 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4954 4954 0 0.00 0 9133 160 0 0
t$perf-norm:sp_cancel_adding_invoice 405 405 0 0.00 1 6243 87 0 0
t$perf-norm:sp_cancel_client_order 1787 1787 0 0.00 0 1974 13 0 0
t$perf-norm:sp_cancel_customer_reserve 699 699 0 0.00 0 693 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 687 687 0 0.00 0 5612 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 452 452 0 0.00 0 1849 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 420 420 0 0.00 0 11312 59 0 0
t$perf-norm:sp_cancel_supplier_order 406 406 0 0.00 0 34761 1516 0 0
t$perf-norm:sp_cancel_write_off 1006 1006 0 0.00 0 1336 6 0 0
t$perf-norm:sp_client_order 20566 20566 0 0.00 0 9198 19 0 0
t$perf-norm:sp_customer_reserve 1027 1027 0 0.00 0 1688 8 0 0
t$perf-norm:sp_pay_from_customer 7215 7215 0 0.00 0 9240 9 0 0
t$perf-norm:sp_pay_to_supplier 5994 5994 0 0.00 0 9496 12 0 0
t$perf-norm:sp_reserve_write_off 10224 10224 0 0.00 0 6936 12 0 0
t$perf-norm:sp_supplier_invoice 5639 5639 0 0.00 0 12244 27 0 0
t$perf-norm:sp_supplier_order 5606 5606 0 0.00 0 9277 24 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 43 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 154 154 0 0.00 0 161 2 0 0
t$perf-norm:srv_make_invnt_saldo 638 638 0 0.00 0 5099 25 0 0
t$perf-norm:srv_make_money_saldo 791 791 0 0.00 0 754 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10040 9890 150 1.49 0 5402 20 0 150
v_all_customers 37118 37118 0 0.00 0 219 1 0 0
v_all_suppliers 31006 31006 0 0.00 0 46 1 0 0
v_all_wares 41132 41132 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 810 810 0 0.00 0 1053 8 0 0
v_cancel_client_order 3574 3574 0 0.00 0 4343 5 0 0
v_cancel_customer_prepayment 1374 1374 0 0.00 0 4345 6 0 0
v_cancel_customer_reserve 1398 1398 0 0.00 0 2506 7 0 0
v_cancel_payment_to_supplier 904 904 0 0.00 0 1506 5 0 0
v_cancel_supplier_invoice 850 840 10 1.17 0 2403 19 0 10
v_cancel_supplier_order 812 812 0 0.00 0 278 4 0 0
v_cancel_write_off 2012 2012 0 0.00 0 324 11 0 0
v_max_id_clo_ord 5603 5603 0 0.00 0 192 1 0 0
v_max_id_clo_res 1027 1027 0 0.00 0 1123 5 0 0
v_max_id_ord_sup 5635 5635 0 0.00 0 3381 5 0 0
v_max_non_paid_invoice 1729 1729 0 0.00 0 2705 5 0 0
v_max_non_paid_realizn 4004 4004 0 0.00 0 6490 5 0 0
v_min_id_clo_ord 5603 5603 0 0.00 0 5045 9 0 0
v_min_id_clo_res 1027 1027 0 0.00 0 1846 8 0 0
v_min_id_ord_sup 5635 5635 0 0.00 0 2623 3 0 0
v_min_non_paid_invoice 5994 5994 0 0.00 0 6240 13 0 0
v_min_non_paid_realizn 7215 7215 0 0.00 0 13210 24 0 0
v_our_firm 10436 10436 0 0.00 0 29 1 0 0
v_reserve_write_off 20448 20448 0 0.00 0 5128 6 0 0
x_lock_depdocs_on_canc_invoice 11604 11604 0 0.00 0 19813 121 0 0
x_lock_depdocs_on_canc_sup_ord 406 406 0 0.00 0 10748 384 0 0
x_make_qstorno_1000_1200 5606 5606 0 0.00 2 40021 1191 0 0
x_make_qstorno_1200_2000 5639 5639 0 0.00 3 71417 3221 0 0
x_make_qstorno_2100_3300 451384 451384 0 0.00 0 46636 161 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 15-03-2021 19:28:15 to 15-03-2021 19:28:20.

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
16:57:26 3 8192000000 8800799232 8812068864 6918096 0.084 2 1 2 0 7037472 56816 62560
16:57:33 22097 8192000000 10280496592 10596294656 1043454128 11.298 79 66 131 0 1068208192 3069408 21684656
16:58:06 25089 8192000000 10349135456 10671030272 1406700176 14.655 100 83 166 0 1439954560 5589328 27665056
16:58:43 19284 8192000000 10398087632 10725097472 1448462272 15.024 100 85 168 1 1482321792 6826144 27033376
16:59:21 25511 8192000000 10444549648 10775977984 1499826976 15.475 100 93 186 1 1537500000 8206448 29466576
16:59:58 18974 8192000000 10455725680 10788855808 1508010208 15.546 100 90 180 1 1546142736 9192400 28940128
17:00:28 18695 8192000000 10463484112 10797813760 1517516064 15.629 100 91 182 0 1556464048 9692608 29255376
17:00:58 18212 8192000000 10477063280 10815881216 1530478672 15.741 100 88 176 0 1568531136 9834640 28217824
17:01:25 17402 8192000000 10492845680 10833641472 1545607296 15.872 100 87 174 1 1583123488 10317360 27198832
17:01:51 15002 8192000000 10510708752 10857365504 1562611952 16.019 100 81 162 0 1598363888 10093680 25658256
17:02:30 13294 8192000000 10544611904 10899275776 1599142128 16.332 100 75 150 0 1632299232 9680000 23477104
17:02:52 16376 8192000000 10569082208 10925920256 1627631152 16.575 100 82 164 0 1663105408 10477312 24996944
17:03:17 13072 8192000000 10580045728 10944311296 1636115488 16.647 100 75 150 0 1669882720 11401232 22366000
17:03:38 10411 8192000000 10596344032 10963521536 1660270096 16.851 100 71 140 0 1692071840 11378896 20422848
17:04:04 8743 8192000000 10630026992 10998812672 1687921088 17.084 100 78 155 2 1722854960 12192752 22741120
17:04:20 6574 8192000000 10651143904 11022884864 1710653664 17.274 100 79 156 1 1746079776 12812720 22613392
17:04:35 7789 8192000000 10660092032 11036119040 1720246656 17.354 100 78 156 1 1756208160 13455264 22506240
17:04:49 5393 8192000000 10677581424 11049975808 1735001760 17.477 100 77 154 2 1770006864 12446080 22559024
17:05:01 8701 8192000000 10675815296 11057070080 1743636048 17.549 100 72 144 1 1776501312 12141600 20723664
17:05:18 4683 8192000000 10691014256 11068575744 1754974784 17.643 100 66 130 1 1785165344 11245024 18945536
17:05:32 4830 8192000000 10715263040 11098054656 1780063520 17.850 100 74 148 0 1812697744 12206368 20427856
17:05:44 4581 8192000000 10728747376 11104194560 1784962720 17.890 100 82 164 0 1820651664 13257088 22431856
17:05:55 4916 8192000000 10729855440 11106484224 1791216064 17.942 100 89 177 1 1830667904 14800880 24650960
17:06:06 13007 8192000000 10727520656 11112833024 1791872080 17.947 100 81 159 0 1828401632 14494512 22035040
17:06:27 3012 8192000000 10742546976 11124281344 1795730432 17.979 100 85 169 1 1833088512 13210912 24147168
17:06:37 2665 8192000000 10755454912 11139645440 1815109616 18.138 100 85 169 0 1852326320 13834240 23382464
17:06:47 3940 8192000000 10757673552 11144118272 1822398368 18.197 100 85 170 0 1860013248 13700944 23913936
17:06:57 2653 8192000000 10765663248 11151335424 1829861888 18.258 100 95 190 1 1870558528 13923472 26773168
17:07:07 2311 8192000000 10783977408 11168165888 1841876032 18.356 100 85 169 1 1877371664 11483024 24012608
17:07:16 2441 8192000000 10789404576 11175092224 1847498624 18.402 100 87 173 1 1884789984 12016800 25274560
17:07:25 2383 8192000000 10796373152 11184304128 1856575408 18.476 100 92 182 1 1895302432 13054496 25672528
17:07:34 2316 8192000000 10797530512 11185565696 1855953312 18.470 100 90 180 1 1896432304 14322064 26156928
17:07:43 2355 8192000000 10807272384 11195150336 1862688656 18.525 100 95 191 1 1904205280 14324192 27192432
17:07:52 1910 8192000000 10808994800 11196428288 1867280896 18.562 100 93 186 3 1908079472 14023792 26774784
17:08:00 1385 8192000000 10810071312 11201249280 1869651104 18.581 100 88 177 1 1906323776 12465360 24207312
17:08:08 2425 8192000000 10810248704 11201388544 1872439712 18.604 100 84 167 3 1908522336 11942016 24140608
17:08:17 1651 8192000000 10813128064 11207942144 1875584704 18.629 100 84 168 1 1911633840 12414832 23634304
17:08:25 1742 8192000000 10826106768 11213447168 1878417568 18.652 100 95 191 2 1918815920 12840752 27557600
17:08:33 2160 8192000000 10824599040 11218128896 1885398832 18.709 100 89 178 2 1924414160 13698896 25316432
17:08:42 25282 8192000000 10806092656 11216257024 1883241376 18.691 100 64 126 1 1911646512 9614448 18790688
17:09:14 21541 8192000000 10821912768 11214852096 1886511616 18.718 100 55 105 1 1907556496 6944624 14100256
17:09:42 21788 8192000000 10811163648 11223273472 1885730576 18.711 100 58 116 1 1912252992 9952608 16569808
17:10:15 4438 8192000000 10800160864 11219218432 1884456832 18.701 100 37 73 3 1903073840 8449248 10167760
17:10:28 7771 8192000000 10784394160 11214422016 1882509520 18.685 100 17 33 1 1893317760 6423296 4384944
17:10:42 5972 8192000000 10789666432 11222507520 1889408736 18.741 100 29 58 1 1903658736 5810096 8439904
17:10:55 3412 8192000000 10798639392 11228053504 1888973872 18.738 100 30 61 2 1907914784 10422560 8518352
17:11:06 8298 8192000000 10804403344 11229417472 1893182816 18.771 100 28 56 2 1906362848 5348928 7831104
17:11:24 6604 8192000000 10812467264 11231825920 1893382304 18.773 100 27 54 1 1907259568 6056992 7820272
17:11:43 11139 8192000000 10797146608 11230572544 1894506304 18.782 100 26 50 1 1908243632 6649488 7087840
17:12:07 13041 8192000000 10802691600 11238924288 1896323424 18.797 100 21 43 0 1912330192 10222912 5783856
17:12:26 14194 8192000000 10801449840 11236327424 1903273264 18.853 100 21 41 1 1914379504 5002176 6104064
17:12:47 11918 8192000000 10815069280 11242131456 1902199568 18.844 100 21 42 1 1914510992 6098288 6213136
17:13:05 11025 8192000000 10811926624 11246153728 1903410832 18.854 100 22 43 4 1915241920 5693440 6137648
17:13:23 10711 8192000000 10814247072 11247513600 1905893776 18.874 100 23 46 4 1918754480 6964816 5895888
17:13:44 11638 8192000000 10818747968 11246583808 1908668112 18.896 100 32 65 1 1922273504 4615200 8990192
17:14:03 66974 8192000000 10861648800 11273322496 1914824992 18.945 100 53 106 3 1935744736 5742848 15176896
17:15:19 17356 8192000000 10836444464 11268018176 1911596464 18.919 100 28 55 0 1929385664 10143632 7645568
17:15:42 5240 8192000000 10823266416 11266465792 1913070992 18.931 100 21 42 0 1929313360 10746544 5495824
17:15:54 9021 8192000000 10830411472 11265527808 1914198192 18.940 100 27 54 1 1927469440 6544768 6726480
17:16:09 5043 8192000000 10827316624 11260772352 1912485440 18.927 100 44 89 2 1932498336 7661632 12351264
17:16:21 8150 8192000000 10812967760 11239976960 1865567600 18.548 98 28 56 1 1879331664 5412464 8351600
17:16:36 8726 8192000000 10802901488 11241807872 1878899968 18.656 99 17 34 2 1889088816 5329088 4859760
17:16:51 7876 8192000000 10808362064 11245363200 1898770256 18.816 100 23 46 2 1911716480 6239568 6706656
17:17:06 8008 8192000000 10812275808 11250216960 1901494416 18.838 100 18 36 1 1912598608 6290048 4814144
17:17:20 8324 8192000000 10803716080 11231727616 1868455184 18.572 98 35 70 1 1884843504 6210256 10178064
17:17:38 7103 8192000000 10796737376 11231215616 1874883408 18.624 99 24 48 2 1888188336 6317904 6987024
17:17:55 11550 8192000000 10749638368 11175649280 1783831472 17.881 95 16 32 1 1793377824 4813328 4733024
17:18:13 9737 8192000000 10766975200 11192360960 1793971600 17.964 96 28 56 2 1807622912 5111696 8539616
17:18:31 13407 8192000000 10701262016 11124682752 1654281920 16.801 90 16 32 0 1663654864 4957600 4415344
17:18:51 12328 8192000000 10711889120 11129147392 1745443152 17.564 96 28 52 1 1759264816 5304528 8517136
17:19:14 50730 8192000000 10749746432 11134644224 1768724576 17.756 97 76 155 2 1798571984 6297088 23550320
17:20:11 8119 8192000000 10709912128 11144970240 1777995456 17.833 98 22 43 0 1791143312 7462048 5685808
17:20:26 7850 8192000000 10698173952 11107147776 1637553312 16.659 90 12 24 0 1645875408 4790704 3531392
17:20:40 7592 8192000000 10702683632 11119771648 1772761024 17.790 99 24 48 3 1785591744 5639216 7191504
17:20:54 6428 8192000000 10687380624 11106889728 1733330976 17.463 97 32 64 0 1749472192 6203312 9937904
17:21:06 6881 8192000000 10682797984 11089285120 1694321616 17.138 95 27 54 2 1707349376 4853776 8173984
17:21:21 5231 8192000000 10720841904 11140149248 1801344496 18.025 100 23 46 1 1818505664 10727824 6433344
17:21:36 9567 8192000000 10704293296 11126403072 1779693152 17.847 98 21 42 1 1791145488 5155968 6296368
17:21:54 9582 8192000000 10733012656 11139432448 1791935808 17.948 99 25 50 0 1804714752 5553536 7225408
17:22:10 11064 8192000000 10713415456 11133296640 1772359392 17.786 98 11 22 1 1781121664 5574720 3187552
17:22:29 10390 8192000000 10736990080 11152912384 1800960640 18.022 99 30 60 0 1819697792 9585056 9152096
17:22:48 7149 8192000000 10725524800 11149246464 1791726416 17.946 98 26 52 1 1804617584 5499120 7392048
17:23:04 8943 8192000000 10738477104 11169259520 1830264304 18.261 100 31 62 1 1845873296 6045792 9563200
17:23:23 8327 8192000000 10722143440 11144564736 1788933888 17.923 98 21 40 3 1800519840 5280080 6305872
17:23:38 71554 8192000000 10754803680 11184373760 1840615648 18.346 100 27 54 3 1853932000 5475904 7840448
17:24:58 13206 8192000000 10772751200 11196055552 1852426768 18.442 100 25 50 0 1865895232 6453632 7014832
17:25:21 8043 8192000000 10773391872 11195756544 1856360016 18.474 100 36 72 2 1872500112 5798704 10341392
17:25:36 5953 8192000000 10782167760 11202174976 1859684048 18.501 100 37 74 0 1877374416 7656464 10033904
17:25:49 9820 8192000000 10787977312 11206209536 1858502704 18.491 100 23 46 0 1871211392 6192912 6515776
17:26:06 8641 8192000000 10771133168 11203481600 1863098208 18.528 100 26 51 1 1875684736 5237168 7349360
17:26:22 11749 8192000000 10770150240 11205545984 1866711632 18.558 100 25 50 1 1879917936 5327680 7878624
17:26:40 9903 8192000000 10777836128 11213889536 1871635472 18.598 100 27 54 1 1885919840 6832624 7451744
17:26:56 8813 8192000000 10796199744 11221172224 1877979232 18.649 100 18 36 0 1887460720 4627232 4854256
17:27:12 8135 8192000000 10799976048 11234127872 1892175344 18.763 100 14 28 2 1900494208 4570416 3748448
17:27:30 13454 8192000000 10837430592 11256066048 1907053520 18.883 100 42 82 1 1925022304 5462048 12506736
17:27:52 50217 8192000000 10848312576 11270881280 1912539936 18.927 100 42 84 0 1931665984 7601936 11524112
17:29:06 17373 8192000000 10848159648 11282878464 1929862624 19.066 100 54 108 1 1956959792 10597696 16499472
17:30:01 47621 8192000000 10864490080 11295289344 1935749856 19.113 100 38 76 0 1957870480 11312320 10808304
17:30:56 19578 8192000000 10870720592 11301584896 1941643328 19.160 100 39 78 2 1964432416 11287648 11501440
17:31:25 34555 8192000000 10882878960 11314094080 1947593040 19.207 100 39 76 1 1968873904 11202464 10078400
17:32:13 26998 8192000000 10881153312 11321004032 1958743728 19.296 100 41 82 3 1984969424 14380496 11845200
17:32:50 10231 8192000000 10904074000 11336753152 1966913984 19.361 100 45 88 1 1995725200 15706000 13105216
17:33:09 2237 8192000000 10915888512 11341733888 1972965712 19.409 100 60 121 1 2008683952 17478416 18239824
17:33:19 16837 8192000000 10914938416 11344584704 1974783520 19.423 100 57 114 0 2009387744 18484576 16119648
17:33:45 9998 8192000000 10936427520 11362504704 1982422064 19.484 100 75 149 2 2023528752 19082624 22024064
17:34:03 5083 8192000000 10920794656 11355242496 1984060960 19.497 100 59 118 1 2020020128 18761840 17197328
17:34:16 22452 8192000000 10925697664 11357868032 1986789120 19.518 100 52 103 0 2018203568 17025088 14389360
17:34:48 15245 8192000000 10923330160 11356815360 1968446816 19.373 99 52 104 3 2000627376 16798992 15381568
17:35:15 14923 8192000000 10919861872 11358150656 1985969520 19.512 100 43 86 1 2014219536 16081008 12169008
17:35:38 4358 8192000000 10923941200 11359330304 1989341136 19.539 100 49 93 3 2018159200 14915408 13902656
17:35:52 10822 8192000000 10928579712 11360747520 1986406208 19.515 100 57 114 0 2021493968 17259936 17827824
17:36:11 4180 8192000000 10929002192 11360317440 1983306560 19.491 100 59 116 0 2018584208 18429040 16848608
17:36:26 7109 8192000000 10950992480 11377258496 1997860880 19.606 100 74 146 0 2042812416 23159184 21792352
17:36:40 10879 8192000000 10950007936 11382882304 2002796864 19.645 100 57 114 1 2044699872 23667952 18235056
17:37:01 3964 8192000000 10948202528 11382022144 2003459632 19.650 100 53 105 1 2039159616 19361280 16338704
17:37:14 2323 8192000000 10978108720 11396268032 2016412064 19.752 100 88 174 6 2064012944 21673296 25927584
17:37:25 4014 8192000000 10978311488 11399880704 2013429696 19.729 100 74 147 0 2057813904 23326640 21057568
17:37:35 2380 8192000000 10972699600 11394535424 1999599216 19.620 99 88 175 3 2051319936 26494176 25226544
17:37:46 4674 8192000000 10980193584 11401314304 2012191584 19.719 100 80 160 1 2062779168 27781632 22805952
17:37:58 4773 8192000000 10973841168 11393712128 2007789248 19.684 100 79 156 0 2059799840 28664608 23345984
17:38:12 2236 8192000000 10974543984 11401031680 2010031888 19.702 100 77 153 1 2062184448 28886816 23265744
17:38:22 2399 8192000000 10973675536 11391774720 1990975632 19.552 99 79 157 0 2045601328 31411744 23213952
17:38:31 10863 8192000000 10968424928 11388116992 1999972272 19.623 100 80 157 2 2056710240 33728480 23009488
17:38:56 9067 8192000000 10971008544 11398578176 2001102880 19.631 100 69 138 1 2056895232 34186640 21605712
17:39:13 1462 8192000000 10981137568 11397554176 2003687808 19.652 100 83 165 1 2059949344 32178816 24082720
17:39:21 2646 8192000000 10968683648 11392413696 1999363088 19.618 100 84 168 2 2058614192 33407968 25843136
17:39:36 2586 8192000000 10914968528 11330887680 1905382464 18.870 96 79 156 1 1958456400 30816608 22257328
17:39:45 2442 8192000000 10931623328 11351273472 1952188080 19.244 99 89 174 3 2011323136 32514832 26620224
17:39:56 4212 8192000000 10945170048 11362398208 1970470224 19.389 100 81 161 0 2028797264 33633888 24693152
17:40:08 4546 8192000000 10953893216 11372756992 1981179136 19.474 100 77 153 0 2039080496 34337920 23563440
17:40:21 7134 8192000000 10924090624 11345592320 1941791872 19.161 98 75 149 0 1999795296 35646288 22357136
17:40:36 1037 8192000000 10945757104 11353038848 1961428240 19.317 99 90 180 2 2024176576 35253920 27494416
17:40:44 3248 8192000000 10946091008 11366359040 1975769088 19.431 100 83 163 1 2038022304 36891392 25361824
17:40:55 3366 8192000000 10950790272 11363565568 1956737232 19.280 99 78 155 2 2015772128 35959216 23075680
17:41:05 4246 8192000000 10938258848 11357900800 1953641712 19.255 99 78 153 0 2013828768 37076928 23110128
17:41:17 7914 8192000000 10934893904 11351199744 1952904400 19.250 99 66 132 3 2011102528 37667232 20530896
17:41:32 9783 8192000000 10926211952 11353255936 1957141104 19.283 100 68 136 1 2020912320 42371184 21400032
17:41:50 4465 8192000000 10938240384 11364954112 1964759600 19.344 100 54 108 1 2022578624 40483328 17335696
17:42:11 2677 8192000000 10943176480 11359526912 1950513856 19.231 99 86 170 2 2012863168 36906400 25442912
17:42:24 7068 8192000000 10918655920 11340750848 1946937936 19.202 100 66 131 2 2004895296 37031760 20925600
17:42:39 6691 8192000000 10912561152 11331964928 1945409600 19.190 100 66 132 3 1998396720 32213760 20773360
17:42:56 12215 8192000000 10892642304 11329114112 1938220224 19.133 100 43 85 0 1984726096 33274016 13231856
17:43:30 11186 8192000000 10943897488 11361267712 1958684432 19.296 100 56 109 2 2009660160 34759248 16216480
17:43:51 9415 8192000000 10935846464 11355889664 1948883040 19.218 99 73 144 0 2006357776 35624112 21850624
17:44:11 6019 8192000000 10947186000 11369897984 1968887488 19.377 100 65 127 0 2025351632 36976704 19487440
17:44:29 3431 8192000000 10953425216 11367305216 1968696512 19.375 100 72 143 0 2029642000 38791104 22154384
17:44:41 2485 8192000000 10935327056 11357163520 1947379328 19.206 99 80 159 2 2014058288 42419456 24259504
17:44:56 2759 8192000000 10947738832 11367747584 1965414832 19.349 100 76 152 0 2027400688 38188992 23796864
17:45:08 6244 8192000000 10937657984 11369586688 1970029392 19.386 100 55 110 1 2027417392 40199392 17188608
17:45:22 3751 8192000000 10964189792 11383623680 1980928560 19.472 100 83 163 0 2049491056 43609392 24953104
17:45:32 4250 8192000000 10945697344 11373641728 1969365504 19.380 100 64 128 2 2033786224 44902608 19518112
17:45:52 7873 8192000000 10921822960 11352911872 1946309424 19.197 99 38 76 1 2000305200 41775760 12220016
17:46:08 3206 8192000000 10946272768 11364913152 1963744720 19.336 100 72 144 0 2027236848 40745936 22746192
17:46:20 1912 8192000000 10959665280 11375288320 1975822144 19.432 100 76 150 0 2043244160 44955312 22466704
17:46:29 8506 8192000000 10953698432 11378249728 1960629392 19.311 99 71 142 0 2029383808 47071504 21682912
17:46:44 1741 8192000000 10967406528 11372539904 1963821024 19.336 100 90 180 2 2042613040 51439280 27352736
17:46:54 2157 8192000000 10959576464 11379023872 1968694240 19.375 100 76 152 1 2043413040 51242368 23476432
17:47:06 2207 8192000000 10957619072 11381424128 1971369664 19.396 100 73 147 1 2045321968 51650960 22301344
17:47:15 4657 8192000000 10959549600 11374882816 1954070272 19.259 99 65 128 1 2022280576 48404640 19805664
17:47:31 3058 8192000000 10959118048 11373117440 1962987216 19.330 100 75 149 1 2033061952 47014768 23059968
17:47:41 6874 8192000000 10937727200 11374235648 1961592992 19.319 100 40 80 1 2023544240 48838336 13112912
17:48:04 6206 8192000000 10945380528 11375140864 1967136720 19.363 100 54 102 5 2023855840 40161264 16557856
17:48:17 6201 8192000000 10931005008 11356143616 1943832800 19.177 99 51 101 3 2002699312 43001264 15865248
17:48:32 1848 8192000000 10959464256 11368411136 1966445312 19.357 100 71 142 1 2031628608 43994368 21188928
17:48:41 3952 8192000000 10956115152 11380723712 1973041440 19.410 100 62 124 0 2038901680 46354016 19506224
17:48:54 5036 8192000000 10952024192 11382239232 1970785152 19.392 100 50 100 2 2033580736 46606720 16188864
17:49:06 4560 8192000000 10948352112 11375845376 1967186048 19.363 100 52 104 0 2031620016 47525984 16907984
17:49:27 3447 8192000000 10962941536 11382198272 1972416480 19.405 100 75 150 1 2047528976 50925168 24187328
17:49:37 9461 8192000000 10964139408 11398389760 1979537184 19.461 100 52 104 2 2052600752 55753072 17310496
17:49:59 17151 8192000000 10973183152 11403501568 1980477520 19.468 100 46 93 1 2054233280 58093856 15661904
17:50:27 9891 8192000000 10952161472 11393933312 1955936960 19.274 99 47 92 2 2031781728 60023456 15821312
17:50:45 13795 8192000000 10935329088 11378081792 1928795072 19.057 98 32 62 0 1996228944 56341152 11092720
17:51:14 17891 8192000000 10913928368 11353550848 1913689840 18.936 98 34 68 1 1969489824 44640480 11159504
17:51:52 27329 8192000000 10896909264 11343454208 1937155568 19.124 100 29 59 2 1988444416 41839264 9449584
17:52:35 21608 8192000000 10875390320 11316678656 1876109984 18.634 97 26 52 1 1924617728 39609728 8898016
17:53:19 21990 8192000000 10892007488 11340066816 1922569056 19.007 100 23 46 2 1980942144 50096608 8276480
17:54:15 16469 8192000000 10882077136 11330191360 1893008896 18.770 99 20 40 0 1951534640 49936016 8589728
17:54:40 55115 8192000000 10904585888 11356426240 1918784272 18.977 100 20 40 1 1980456928 53895600 7777056
17:55:42 44439 8192000000 10881530112 11331510272 1925697120 19.032 100 25 50 2 1977163168 43037376 8428672
17:56:37 37429 8192000000 10850695520 11306893312 1885752784 18.712 98 19 38 1 1907038464 15662352 5623328
17:57:24 66421 8192000000 10846318656 11300155392 1850358720 18.425 96 22 45 4 1871089360 14426864 6303776
17:58:40 82570 8192000000 10869601024 11306491904 1913283936 18.933 99 35 71 0 1934942272 12112304 9546032
18:00:13 91598 8192000000 10854730448 11312099328 1891142416 18.755 98 19 38 0 1907983488 10827008 6014064
18:01:51 124515 8192000000 10906889616 11334201344 1886810304 18.720 97 19 39 1 1900217984 7422560 5985120
18:04:02 27652 8192000000 10876048256 11330236416 1940614976 19.152 99 31 62 2 1962626240 13488784 8522480
18:04:54 49082 8192000000 10899428544 11364601856 1940510048 19.151 99 14 28 0 1960536768 16005616 4021104
18:05:51 54879 8192000000 10937172736 11380056064 1983187136 19.490 100 28 56 1 2011172208 19332448 8652624
18:06:53 72474 8192000000 10922047472 11389853696 1967945616 19.369 99 30 60 1 2002396976 25003920 9447440
18:08:12 23228 8192000000 10917592912 11381624832 1979429904 19.460 100 13 26 0 2006286096 22558544 4297648
18:08:47 48039 8192000000 10911896688 11390078976 1969753824 19.383 100 12 24 0 2003160448 29568352 3838272
18:09:41 110393 8192000000 10909645888 11372269568 1976471408 19.437 100 19 39 1 1994946736 13291680 5183648
18:11:38 61201 8192000000 10911467152 11372023808 1963775744 19.336 99 25 48 2 1980901216 9424512 7700960
18:12:46 117939 8192000000 10907867952 11382542336 1962638272 19.327 99 9 19 0 1979903728 14561600 2703856
18:15:16 63466 8192000000 10928313248 11375390720 1967411072 19.365 99 28 56 0 1990220032 15180736 7628224
18:16:28 68540 8192000000 10899280160 11372994560 1964754016 19.344 99 12 24 0 1975955920 7656896 3545008
18:17:43 36137 8192000000 10917107776 11381161984 1991961184 19.559 100 16 32 5 2005108976 8218560 4929232
18:18:46 43389 8192000000 10901439936 11368173568 1947766224 19.209 98 14 28 1 1961494848 9715696 4012928
18:19:37 45270 8192000000 10890771264 11372154880 1974769792 19.423 100 21 42 0 1994651712 12925616 6956304
18:20:42 43495 8192000000 10907524096 11381964800 1981411456 19.476 100 7 14 0 1996475664 13153792 1910416
18:22:04 64435 8192000000 10882571616 11353468928 1933156928 19.092 98 34 68 1 1956737824 13113808 10467088
18:23:25 82258 8192000000 10875837936 11364007936 1941375344 19.158 99 20 40 1 1964376496 16618288 6382864
18:24:57 71897 8192000000 10868430944 11352723456 1905659456 18.872 97 7 14 1 1916025808 8633232 1733120
18:26:16 80358 8192000000 10871343840 11339448320 1848972928 18.414 94 23 47 0 1862761184 7050480 6737776
18:27:42 74405 8192000000 10870380672 11345145856 1903492976 18.854 97 17 34 1 1917189136 9395440 4300720
18:29:16 22311 8192000000 10891957104 11351035904 1943844848 19.177 99 29 58 0 1960293104 7778016 8670240
18:29:55 72710 8192000000 10868577280 11342807040 1890158960 18.747 96 19 38 0 1904042992 8734960 5149072
18:31:18 79021 8192000000 10883232688 11345276928 1824767632 18.217 93 21 42 0 1840338112 10268128 5302352
18:32:43 80401 8192000000 10872586400 11332993024 1840159488 18.342 94 18 36 0 1854607168 10194368 4253312
18:34:10 34829 8192000000 10888689728 11351478272 1930078288 19.068 99 21 42 2 1945108864 9698384 5332192
18:34:51 19980 8192000000 10889688688 11336392704 1914722464 18.945 98 43 86 2 1936872800 10189696 11960640
18:35:19 22575 8192000000 10882043856 11350065152 1956464800 19.278 100 43 87 1 1981605232 12293184 12847248
18:35:54 81967 8192000000 10893601008 11342905344 1859176144 18.497 95 22 44 1 1874661328 8775344 6709840
18:37:24 54017 8192000000 10867922688 11333537792 1906108304 18.875 98 44 88 0 1931875552 14108352 11658896
18:38:30 69751 8192000000 10853338160 11317481472 1850054512 18.423 95 15 30 1 1865315104 11011504 4249088
18:39:49 50219 8192000000 10880071232 11348094976 1940460032 19.150 100 20 40 1 1958243088 12477152 5305904
18:40:46 145437 8192000000 10883363968 11352186880 1928385488 19.054 99 17 34 1 1942682544 8724064 5572992
18:43:17 58701 8192000000 10875862320 11347025920 1931698848 19.080 99 14 28 0 1949378224 13742976 3936400
18:44:23 64653 8192000000 10864623680 11338981376 1927860384 19.050 99 9 16 0 1941886736 11167328 2859024
18:45:40 77490 8192000000 10851127792 11332960256 1891630528 18.759 97 12 24 0 1903940688 9004640 3305520
18:47:05 65872 8192000000 10843119888 11301769216 1847653392 18.403 95 14 29 0 1860540272 8634880 4252000
18:49:21 76527 8192000000 10847600688 11328483328 1897752416 18.808 98 15 30 0 1916960448 14509984 4698048
18:50:46 73009 8192000000 10861862016 11356622848 1935857952 19.114 100 12 24 1 1958362688 18890448 3614288
18:52:17 45092 8192000000 10881189600 11347337216 1948456880 19.214 100 11 19 1 1961553600 10544704 2552016
18:53:32 42948 8192000000 10876865824 11327938560 1901148480 18.836 97 20 39 1 1913386320 6894544 5343296
18:54:30 55332 8192000000 10888439632 11362861056 1935943168 19.114 99 13 26 1 1953458992 13895440 3620384
18:55:32 55340 8192000000 10878843568 11347177472 1905160384 18.868 97 23 46 2 1928707024 16607536 6939104
18:56:36 94444 8192000000 10901884032 11374247936 1935537584 19.111 99 12 23 0 1952365456 13930608 2897264
18:58:31 87488 8192000000 10896448688 11372851200 1954171712 19.260 99 11 21 0 1967386112 10738192 2476208
19:00:05 110715 8192000000 10902591904 11382677504 1903973904 18.858 96 12 24 2 1924548624 17727504 2847216
19:02:03 92977 8192000000 10898572640 11366445056 1938860736 19.138 98 15 30 0 1964202128 21266352 4075040
19:03:44 63427 8192000000 10920237136 11378401280 1950983232 19.234 99 17 34 0 1968371264 12752480 4635552
19:04:57 107588 8192000000 10920303632 11371380736 1940471696 19.151 98 30 60 0 1957664128 8424592 8767840
19:06:55 114820 8192000000 10895141808 11357257728 1916081536 18.955 97 23 46 1 1930509392 8128144 6299712
19:10:02 65237 8192000000 10863895104 11351736320 1936078384 19.115 99 8 16 0 1951180592 12361632 2740576
19:11:22 53074 8192000000 10887475072 11366633472 1964063280 19.338 100 16 32 1 1977607424 8973280 4570864
19:12:28 72245 8192000000 10855546944 11331969024 1846516496 18.394 94 14 27 1 1857856496 7332896 4007104
19:13:55 77587 8192000000 10842914160 11318579200 1874659664 18.622 97 8 16 1 1884464176 7586304 2218208
19:15:18 48484 8192000000 10813612736 11292942336 1853748544 18.453 96 10 20 1 1865560208 8828528 2983136
19:16:13 73100 8192000000 10844026752 11313328128 1847623248 18.403 96 10 20 2 1858036400 7829664 2583488
19:17:35 53267 8192000000 10858324272 11323891712 1887956784 18.729 98 13 26 2 1899563296 7981152 3625360
19:18:40 45011 8192000000 10894853376 11357442048 1947390464 19.206 100 32 65 0 1970262464 13239040 9632960
19:19:39 78684 8192000000 10904749952 11381223424 1937835456 19.129 99 14 28 2 1962089248 20162672 4091120
19:21:09 134405 8192000000 10873292512 11348844544 1873288224 18.611 95 8 16 0 1887891696 12404240 2199232
19:23:32 36746 8192000000 10890488432 11349278720 1897206640 18.804 97 28 55 1 1915215488 10107600 7901248
19:24:17 76786 8192000000 10902843648 11352952832 1926672064 19.040 98 21 41 1 1943331104 10872768 5786272
19:25:44 21581 8192000000 10900008384 11353485312 1921681632 19.000 98 45 90 0 1942702944 8399856 12621456
19:26:13 18627 8192000000 10897555264 11352268800 1933935776 19.098 99 48 96 0 1959745456 12957472 12852208
19:26:40 52896 8192000000 9548556080 9865097216 686224704 7.729 36 14 28 1 696689728 6768160 3696864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 15-03-2021 19:28:21 to 15-03-2021 19:28:52.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 75 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-03-2021 19:28:53 to 15-03-2021 19:28:55.

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          243426
MON$OLDEST_ACTIVE               243427
MON$OLDEST_SNAPSHOT             243427
MON$NEXT_TRANSACTION            243427
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                       2023552
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.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 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 ---
:111: 
:112: mscs-test-161.budzdorov.ru    Mon Mar 15 19:27:41 2021
:113:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:114: 
--- end of diff output ---

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

15.03.21 19:28:56. 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-15 19:28:58 No severe PSQL-related problems occured
15.03.21 19:28:59. End of report.