Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 05.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 17577768 kB
MemAvailable 31594816 kB
Buffers 0 kB
Cached 14077632 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-05 19:27:23
DTS_END                         2021-03-05 19:27:23.0390
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/48278
TRN_ID                          238856
ATT_ID                          670
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: 9133.03 20865 1095964
customer order: creation 170.02 379 20402
customer order: refuse 14.34 338 1721
order to supplier: creation 45.13 1307 5416
order to supplier: removal 3.24 105202 389
invoice (draft): creation 46.13 3723 5535
invoice (draft): removal 52.27 782 6272
invoice accept: apply 40.70 20641 4884
invoice accept: cancel 46.61 845 5593
customer reserve: creation 3807.78 202 456934
customer reserve: removal 4614.88 58 553785
realization accept: apply 84.18 189 10102
realization accept: cancel 77.07 125 9248
payment from customer: creation 59.98 114 7198
payment from customer: removal 5.55 79 666
payment to supplier: creation 48.84 122 5861
payment to supplier: removal 3.40 73 408
service: total inventory turnovers 5.26 1102 631
service: total monetary turnovers 6.70 109 804
service: aggregate perf. data 0.93 16674 111
service: refresh index statistics 0.03 265228 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-03-2021 19:28:18 to 05-03-2021 19:28:20.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2873
TEST_TIME 2 3675
TEST_TIME 3 4574
TEST_TIME 4 4452
TEST_TIME 5 5234
TEST_TIME 6 5949
TEST_TIME 7 6005
TEST_TIME 8 6665
TEST_TIME 9 7215
TEST_TIME 10 7063
TEST_TIME 11 7083
TEST_TIME 12 7495
TEST_TIME 13 8137
TEST_TIME 14 8362
TEST_TIME 15 8725
TEST_TIME 16 8766
TEST_TIME 17 8666
TEST_TIME 18 8622
TEST_TIME 19 8690
TEST_TIME 20 8663
TEST_TIME 21 8865
TEST_TIME 22 8797
TEST_TIME 23 9202
TEST_TIME 24 9252
TEST_TIME 25 9277
TEST_TIME 26 9253
TEST_TIME 27 9373
TEST_TIME 28 9403
TEST_TIME 29 9688
TEST_TIME 30 10439
TEST_TIME 31 11159
TEST_TIME 32 10932
TEST_TIME 33 10661
TEST_TIME 34 10495
TEST_TIME 35 10537
TEST_TIME 36 10342
TEST_TIME 37 10162
TEST_TIME 38 10109
TEST_TIME 39 10084
TEST_TIME 40 10029
TEST_TIME 41 9953
TEST_TIME 42 9824
TEST_TIME 43 9715
TEST_TIME 44 9784
TEST_TIME 45 9598
TEST_TIME 46 9509
TEST_TIME 47 9486
TEST_TIME 48 9552
TEST_TIME 49 9392
TEST_TIME 50 9349
TEST_TIME 51 9273
TEST_TIME 52 9305
TEST_TIME 53 9209
TEST_TIME 54 9182
TEST_TIME 55 9060
TEST_TIME 56 8925
TEST_TIME 57 8904
TEST_TIME 58 9002
TEST_TIME 59 9080
TEST_TIME 60 9025
TEST_TIME 61 9034
TEST_TIME 62 9102
TEST_TIME 63 9109
TEST_TIME 64 9150
TEST_TIME 65 9179
TEST_TIME 66 9148
TEST_TIME 67 9108
TEST_TIME 68 9228
TEST_TIME 69 9148
TEST_TIME 70 9297
TEST_TIME 71 9222
TEST_TIME 72 9316
TEST_TIME 73 9367
TEST_TIME 74 9350
TEST_TIME 75 9256
TEST_TIME 76 9175
TEST_TIME 77 9200
TEST_TIME 78 9158
TEST_TIME 79 9183
TEST_TIME 80 9110
TEST_TIME 81 9082
TEST_TIME 82 9051
TEST_TIME 83 8979
TEST_TIME 84 9026
TEST_TIME 85 8978
TEST_TIME 86 9026
TEST_TIME 87 9033
TEST_TIME 88 9061
TEST_TIME 89 9049
TEST_TIME 90 9094
TEST_TIME 91 9089
TEST_TIME 92 9090
TEST_TIME 93 9122
TEST_TIME 94 9104
TEST_TIME 95 9173
TEST_TIME 96 9179
TEST_TIME 97 9207
TEST_TIME 98 9208
TEST_TIME 99 9178
TEST_TIME 100 9263
TEST_TIME 101 9267
TEST_TIME 102 9197
TEST_TIME 103 9187
TEST_TIME 104 9142
TEST_TIME 105 9112
TEST_TIME 106 9094
TEST_TIME 107 9052
TEST_TIME 108 9063
TEST_TIME 109 9063
TEST_TIME 110 9032
TEST_TIME 111 9052
TEST_TIME 112 9052
TEST_TIME 113 9053
TEST_TIME 114 9058
TEST_TIME 115 9125
TEST_TIME 116 9147
TEST_TIME 117 9143
TEST_TIME 118 9144
TEST_TIME 119 9186
TEST_TIME 120 9135

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 05-03-2021 19:28:21 to 05-03-2021 19:28:25.

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 1519755 1519755 0 0.00 0 14055 7 0 0
doc_list_biud 1519755 1519755 0 0.00 0 24467 27 0 0
sp_add_invoice_to_stock 4979 4884 95 1.90 28 233549 20642 0 95
sp_cancel_adding_invoice 5593 5593 0 0.00 5 93864 845 0 0
sp_cancel_client_order 1721 1721 0 0.00 5 9274 339 0 0
sp_cancel_customer_reserve 553785 553785 0 0.00 1 24353 59 0 0
sp_cancel_pay_from_customer 666 666 0 0.00 2 5056 79 0 0
sp_cancel_pay_to_supplier 408 408 0 0.00 3 4497 74 0 0
sp_cancel_supplier_invoice 6279 6272 7 0.11 2 14579 783 0 7
sp_cancel_supplier_order 389 389 0 0.00 7 897023 105202 0 0
sp_cancel_write_off 9248 9248 0 0.00 1 13916 125 0 0
sp_client_order 20402 20402 0 0.00 4 42099 379 0 0
sp_customer_reserve 456934 456934 0 0.00 0 54675 202 0 0
sp_fill_shopping_cart 31334 31334 0 0.00 1 26159 45 0 0
sp_fill_shopping_cart_clo_res 456929 456929 0 0.00 0 14884 13 0 0
sp_get_clo_for_invoice 4879 4879 0 0.00 0 34005 357 0 0
sp_kill_cost_storno 15915 15915 0 0.00 0 7876 56 0 0
sp_kill_qstorno_ret_qs2qd 1123479 1123479 0 0.00 0 24344 32 0 0
sp_kill_qty_storno 591989 591989 0 0.00 0 24466 69 0 0
sp_lock_selected_doc 20657 20657 0 0.00 0 7599 4 0 0
sp_make_cost_storno 28040 28040 0 0.00 0 13212 49 0 0
sp_multiply_rows_for_pdistr 28040 28040 0 0.00 0 7547 30 0 0
sp_multiply_rows_for_qdistr 20402 20402 0 0.00 0 42087 176 0 0
sp_pay_from_customer 7198 7198 0 0.00 4 9216 114 0 0
sp_pay_to_supplier 5861 5861 0 0.00 4 10291 122 0 0
sp_payment_common 13059 13059 0 0.00 1 10274 26 0 0
sp_qd_handle_on_cancel_clo 1721 1721 0 0.00 0 9267 308 0 0
sp_qd_handle_on_invoice_upd_sts 10472 10472 0 0.00 0 24465 345 0 0
sp_qd_handle_on_reserve_upd_sts 10102 10102 0 0.00 0 11502 74 0 0
sp_reserve_write_off 10102 10102 0 0.00 6 11895 189 0 0
sp_supplier_invoice 5535 5535 0 0.00 5 93849 3724 0 0
sp_supplier_order 5416 5416 0 0.00 4 38765 1308 0 0
srv_aggregate_perf_data 111 111 0 0.00 3128 142134 16675 0 0
srv_fill_mon_cache_memory 176 176 0 0.00 1307 133299 29532 0 0
srv_find_qd_qs_mism 1048813 1048813 0 0.00 0 13936 6 0 0
srv_make_invnt_saldo 631 631 0 0.00 40 78896 1103 0 0
srv_make_money_saldo 804 804 0 0.00 0 62416 109 0 0
srv_recalc_idx_stat 4 4 0 0.00 187946 383608 265228 0 0
t$perf-abend:sp_add_invoice_to_stock 95 95 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4884 4884 0 0.00 0 12306 197 0 0
t$perf-norm:sp_cancel_adding_invoice 417 417 0 0.00 0 8242 118 0 0
t$perf-norm:sp_cancel_client_order 1721 1721 0 0.00 0 6350 27 0 0
t$perf-norm:sp_cancel_customer_reserve 660 660 0 0.00 0 3767 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 666 666 0 0.00 0 2049 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 408 408 0 0.00 0 354 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 1046 14 0 0
t$perf-norm:sp_cancel_supplier_order 389 389 0 0.00 0 22925 1734 0 0
t$perf-norm:sp_cancel_write_off 1010 1010 0 0.00 0 4745 13 0 0
t$perf-norm:sp_client_order 20402 20402 0 0.00 0 5577 19 0 0
t$perf-norm:sp_customer_reserve 1004 1004 0 0.00 0 1760 6 0 0
t$perf-norm:sp_pay_from_customer 7198 7198 0 0.00 0 16593 15 0 0
t$perf-norm:sp_pay_to_supplier 5861 5861 0 0.00 0 15255 15 0 0
t$perf-norm:sp_reserve_write_off 10102 10102 0 0.00 0 6593 14 0 0
t$perf-norm:sp_supplier_invoice 5535 5535 0 0.00 0 5683 23 0 0
t$perf-norm:sp_supplier_order 5416 5416 0 0.00 0 7586 17 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 1486 23 0 0
t$perf-norm:srv_fill_mon_cache_memory 176 176 0 0.00 0 393 9 0 0
t$perf-norm:srv_make_invnt_saldo 631 631 0 0.00 0 1369 27 0 0
t$perf-norm:srv_make_money_saldo 804 804 0 0.00 0 576 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 39 13 0 0
v_add_invoice_to_stock 9948 9758 190 1.90 0 4745 20 0 190
v_all_customers 37014 37014 0 0.00 0 22 1 0 0
v_all_suppliers 30632 30632 0 0.00 0 18 1 0 0
v_all_wares 40804 40804 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 834 834 0 0.00 0 1797 9 0 0
v_cancel_client_order 3442 3442 0 0.00 0 4481 7 0 0
v_cancel_customer_prepayment 1332 1332 0 0.00 0 1177 5 0 0
v_cancel_customer_reserve 1320 1320 0 0.00 0 4702 9 0 0
v_cancel_payment_to_supplier 816 816 0 0.00 0 4480 9 0 0
v_cancel_supplier_invoice 824 810 14 1.69 0 3534 23 0 14
v_cancel_supplier_order 778 778 0 0.00 0 2921 9 0 0
v_cancel_write_off 2020 2020 0 0.00 0 1675 13 0 0
v_max_id_clo_ord 5411 5411 0 0.00 0 1327 1 0 0
v_max_id_clo_res 1004 1004 0 0.00 0 2303 13 0 0
v_max_id_ord_sup 5521 5521 0 0.00 0 7339 6 0 0
v_max_non_paid_invoice 1477 1477 0 0.00 0 926 4 0 0
v_max_non_paid_realizn 3887 3887 0 0.00 0 5842 5 0 0
v_min_id_clo_ord 5411 5411 0 0.00 0 2683 7 0 0
v_min_id_clo_res 1004 1004 0 0.00 0 6179 18 0 0
v_min_id_ord_sup 5521 5521 0 0.00 0 6569 12 0 0
v_min_non_paid_invoice 5861 5861 0 0.00 0 10269 17 0 0
v_min_non_paid_realizn 7198 7198 0 0.00 0 9205 18 0 0
v_our_firm 10412 10412 0 0.00 0 16 1 0 0
v_reserve_write_off 20204 20204 0 0.00 0 4702 6 0 0
x_lock_depdocs_on_canc_invoice 11460 11460 0 0.00 0 16981 129 0 0
x_lock_depdocs_on_canc_sup_ord 389 389 0 0.00 0 8238 408 0 0
x_make_qstorno_1000_1200 5416 5416 0 0.00 1 35648 1220 0 0
x_make_qstorno_1200_2000 5535 5535 0 0.00 2 93003 3533 0 0
x_make_qstorno_2100_3300 456934 456934 0 0.00 0 54646 186 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-03-2021 19:28:26 to 05-03-2021 19:28:30.

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 7 8192000000 8806222992 8819146752 8973408 0.109 2 1 2 0 9144432 61552 109472
16:57:33 19574 8192000000 10279592608 10586013696 874832880 9.648 67 55 110 1 895210416 2328208 18049328
16:58:01 17840 8192000000 10340778736 10656854016 1387447920 14.483 100 86 172 1 1420045296 4630512 27966864
16:58:30 27737 8192000000 10377329280 10698305536 1421865552 14.789 100 87 174 0 1456975168 6255472 28854144
16:59:08 38393 8192000000 10410768112 10736132096 1455597808 15.087 100 90 178 1 1492159008 7189936 29371264
17:00:02 22000 8192000000 10421305264 10749788160 1474550304 15.254 100 90 178 3 1511851696 8093264 29208128
17:00:34 12014 8192000000 10431283984 10765295616 1485512496 15.350 100 84 168 0 1521486368 8588784 27385088
17:00:56 20003 8192000000 10465395168 10802941952 1514210192 15.600 100 92 183 0 1553317824 9233488 29874144
17:01:25 13234 8192000000 10484630608 10825510912 1538144160 15.808 100 87 174 0 1575009344 9434864 27430320
17:01:51 19102 8192000000 10507802672 10855960576 1559325856 15.990 100 80 160 0 1594464752 9996048 25142848
17:02:18 13932 8192000000 10541393520 10894450688 1590833824 16.261 100 82 164 2 1625440000 10002096 24604080
17:02:45 14644 8192000000 10562389792 10919415808 1614456272 16.463 100 70 140 1 1646261248 10859264 20945712
17:03:09 11397 8192000000 10589995552 10945236992 1643202128 16.707 100 86 173 0 1680881488 11726112 25953248
17:03:29 11559 8192000000 10582963632 10948833280 1646013568 16.731 100 75 150 0 1680730240 12229984 22486688
17:03:51 9085 8192000000 10594138256 10960711680 1657915856 16.831 100 74 148 2 1691768096 12076352 21775888
17:04:18 6241 8192000000 10620972496 10990530560 1686869936 17.075 100 80 158 3 1720763888 11900928 21993024
17:04:32 9028 8192000000 10647228352 11016454144 1703271664 17.212 100 77 154 1 1738679568 12999168 22408736
17:04:48 5048 8192000000 10650804864 11026898944 1712679584 17.291 100 78 156 1 1748579296 13413104 22486608
17:05:01 7489 8192000000 10659240784 11036221440 1722824832 17.376 100 80 160 1 1758964608 13390160 22749616
17:05:16 5713 8192000000 10669177328 11048910848 1736680112 17.491 100 81 161 2 1776540480 17273056 22587312
17:05:29 5570 8192000000 10678558256 11059019776 1744341536 17.555 100 66 131 1 1774549488 11993088 18214864
17:05:41 4835 8192000000 10690686528 11071090688 1758542704 17.672 100 78 156 1 1793212928 12612592 22057632
17:05:53 5425 8192000000 10697336080 11079856128 1766286976 17.736 100 87 175 0 1803908096 12863296 24757824
17:06:07 10418 8192000000 10707878240 11092582400 1771661744 17.781 100 76 148 2 1805513664 13179072 20672848
17:06:25 3340 8192000000 10728595264 11113025536 1782879584 17.873 100 83 165 0 1819407472 13547168 22980720
17:06:35 3530 8192000000 10726723744 11114401792 1795687376 17.979 100 87 173 0 1834044128 13844832 24511920
17:06:45 1935 8192000000 10746990320 11133607936 1810837216 18.103 100 85 166 2 1848260128 12905408 24517504
17:06:53 3821 8192000000 10765889520 11150143488 1821957344 18.194 100 85 171 0 1860216080 13659616 24599120
17:07:04 2848 8192000000 10761781344 11154788352 1831258784 18.270 100 85 169 1 1868612192 13573216 23780192
17:07:13 2714 8192000000 10783623600 11165249536 1838912928 18.332 100 86 173 0 1876477216 13186624 24377664
17:07:23 3038 8192000000 10779930672 11169230848 1842378560 18.360 100 81 162 1 1878302528 12948320 22975648
17:07:33 1476 8192000000 10790362800 11177234432 1846115344 18.391 100 93 182 2 1884602528 13259616 25227568
17:07:41 2165 8192000000 10790734704 11175481344 1847402128 18.401 100 88 176 1 1886665552 14139568 25123856
17:07:50 2560 8192000000 10790669936 11182133248 1853161296 18.448 100 84 169 1 1890098960 12497280 24440384
17:07:59 1813 8192000000 10792181312 11183988736 1851885472 18.437 100 84 168 0 1887759968 12956416 22918080
17:08:07 1713 8192000000 10805474912 11189383168 1857540544 18.483 100 91 182 3 1896023184 12854144 25628496
17:08:15 2835 8192000000 10793496880 11190059008 1860656416 18.509 100 79 158 2 1896176976 13570032 21950528
17:08:25 1616 8192000000 10811862704 11201355776 1866801200 18.558 100 96 194 1 1907552992 13686560 27065232
17:08:33 2062 8192000000 10809396368 11199311872 1867788928 18.566 100 93 183 2 1908234752 14184784 26261040
17:08:41 2187 8192000000 10811532944 11205107712 1869422992 18.580 100 87 173 1 1907912912 13113600 25376320
17:08:50 1453 8192000000 10820798192 11208257536 1870055040 18.585 100 85 168 3 1907011936 12894256 24062640
17:08:58 2536 8192000000 10802346912 11204100096 1873364000 18.611 100 72 142 0 1906063296 12898768 19800528
17:09:07 1489 8192000000 10816474352 11209117696 1875352688 18.628 100 84 165 0 1910267008 12038560 22875760
17:09:15 8034 8192000000 10787964160 11200970752 1867732384 18.566 100 46 92 1 1890266128 9591248 12942496
17:09:29 47145 8192000000 10818806112 11216461824 1880371072 18.668 100 64 126 1 1907339632 8650272 18318288
17:10:22 2619 8192000000 10804866048 11216678912 1878969536 18.657 100 63 126 0 1908406256 11649264 17787456
17:10:37 2589 8192000000 10812676432 11219795968 1879042896 18.657 100 56 112 0 1905359552 10297552 16019104
17:10:48 7805 8192000000 10786695440 11214086144 1878315136 18.651 100 29 59 2 1893680016 6503952 8860928
17:11:03 4080 8192000000 10784775104 11218812928 1878233312 18.651 100 24 48 0 1891570064 6800992 6535760
17:11:13 10561 8192000000 10786171728 11218731008 1883404880 18.693 100 25 51 2 1896956560 6012336 7539344
17:11:31 9383 8192000000 10797071264 11225714688 1882373088 18.684 100 22 44 0 1894801376 5822512 6605776
17:11:50 6404 8192000000 10791998672 11224662016 1880288592 18.667 100 11 23 0 1888635424 5313232 3033600
17:12:03 7463 8192000000 10792625024 11224047616 1884080192 18.698 100 17 35 0 1894866352 6016704 4769456
17:12:22 15230 8192000000 10813502064 11235684352 1890629664 18.751 100 25 50 1 1903781408 5285616 7866128
17:12:44 68686 8192000000 10808479344 11245428736 1894422800 18.781 100 17 34 0 1905314016 5215952 5675264
17:13:59 11164 8192000000 10821516064 11252498432 1908448656 18.894 100 33 67 1 1924753648 7447008 8857984
17:14:17 5975 8192000000 10821527520 11252981760 1904782096 18.865 100 29 58 1 1919923168 6959456 8181616
17:14:30 8504 8192000000 10824815680 11254435840 1904860080 18.865 100 30 60 1 1919482496 6660880 7961536
17:14:47 8798 8192000000 10830966544 11257556992 1905950032 18.874 100 21 42 1 1917582192 5330448 6301712
17:15:03 4020 8192000000 10827027232 11255898112 1908312976 18.893 100 31 61 1 1924303280 6486096 9504208
17:15:14 7423 8192000000 10814972432 11256868864 1907500768 18.887 100 22 44 1 1920040560 6230384 6309408
17:15:29 9463 8192000000 10828138192 11261169664 1908895616 18.898 100 22 43 1 1921394976 5947504 6551856
17:15:50 8520 8192000000 10823366608 11252424704 1886090304 18.714 99 20 41 1 1897238768 5681872 5466592
17:16:05 11090 8192000000 10798364592 11239845888 1877965344 18.649 99 19 38 1 1889332992 6206192 5161456
17:16:22 6722 8192000000 10815372416 11247276032 1882893952 18.688 99 22 42 0 1894291264 6059952 5337360
17:16:40 11230 8192000000 10803993088 11242123264 1879571312 18.662 99 17 34 0 1890809360 5676336 5561712
17:17:03 21916 8192000000 10790254032 11222822912 1834476496 18.296 97 24 48 0 1846497888 5340704 6680688
17:17:49 32587 8192000000 10785252112 11221250048 1845632448 18.387 98 33 64 1 1860752016 5720560 9399008
17:18:32 8665 8192000000 10772679968 11202842624 1799030048 18.006 95 18 36 2 1809181152 5405024 4746080
17:18:49 3659 8192000000 10775665168 11197415424 1812429344 18.116 97 28 56 0 1826712848 6753104 7530400
17:18:59 7192 8192000000 10766007920 11199373312 1830391904 18.263 98 30 60 1 1845977200 7201888 8383408
17:19:12 3725 8192000000 10752843616 11176710144 1827471008 18.239 99 41 84 2 1847678192 8536576 11670608
17:19:23 3949 8192000000 10773713376 11193966592 1852985456 18.446 100 35 69 3 1869474656 6114768 10374432
17:19:33 6968 8192000000 10740217232 11161104384 1815927248 18.144 98 23 46 1 1828574864 5265152 7382464
17:19:47 9481 8192000000 10721164720 11141320704 1750939264 17.609 95 29 58 1 1765163328 5657744 8566320
17:20:05 7179 8192000000 10703273104 11120005120 1730114384 17.436 95 24 48 1 1747212848 10270848 6827616
17:20:18 8656 8192000000 10685094304 11099668480 1664055792 16.883 92 22 42 2 1674868864 4792000 6021072
17:20:33 7784 8192000000 10705765040 11128913920 1777160256 17.826 99 24 48 1 1789997184 6407968 6428960
17:20:49 7704 8192000000 10704075520 11118112768 1769569296 17.763 98 19 38 0 1780720688 5344304 5807088
17:21:03 10358 8192000000 10712349408 11126374400 1728897264 17.426 96 21 42 1 1744699584 9797120 6005200
17:21:19 9640 8192000000 10736744288 11142848512 1784402816 17.886 99 28 56 2 1798775888 5877312 8495760
17:21:37 66533 8192000000 10694524704 11115560960 1702083488 17.203 93 26 52 1 1714555232 5238416 7233328
17:22:51 19263 8192000000 10719466016 11144634368 1756879536 17.659 97 14 25 2 1765841360 5288944 3672880
17:23:17 6837 8192000000 10742068560 11154960384 1818115888 18.162 100 31 62 1 1832945648 6506928 8322832
17:23:30 6478 8192000000 10723720464 11133767680 1786873008 17.906 98 30 60 1 1801512256 4948544 9690704
17:23:44 7432 8192000000 10741213392 11158982656 1806913904 18.071 99 25 47 2 1819242512 4721328 7607280
17:24:02 8172 8192000000 10759338000 11178676224 1839535952 18.337 100 31 62 1 1854082992 5420672 9126368
17:24:16 8810 8192000000 10765057984 11189338112 1848863056 18.413 100 23 45 2 1861108720 5067664 7178000
17:24:33 9010 8192000000 10763072064 11198488576 1854560352 18.459 100 17 34 0 1864680240 5556800 4563088
17:24:51 9481 8192000000 10771360448 11204567040 1861912288 18.519 100 25 50 3 1874992368 6129008 6951072
17:25:06 7183 8192000000 10786592400 11210493952 1862896320 18.527 100 21 41 1 1877661264 8942816 5822128
17:25:22 8076 8192000000 10775871248 11205578752 1864004976 18.536 100 24 48 0 1877177568 6182080 6990512
17:25:37 7975 8192000000 10789125568 11211370496 1863913792 18.535 100 20 41 1 1875496432 5917984 5664656
17:25:52 8432 8192000000 10785074912 11209895936 1864244400 18.538 100 13 26 1 1873975408 5236704 4494304
17:26:10 11089 8192000000 10772113488 11211345920 1868887584 18.575 100 23 44 3 1880978400 5909424 6181392
17:26:28 31742 8192000000 10784083776 11218112512 1873697216 18.614 100 21 44 2 1885446048 5569312 6179520
17:28:15 12676 8192000000 10838323344 11260514304 1909722032 18.904 100 44 86 2 1928054096 5904544 12427520
17:28:40 39988 8192000000 10838190272 11268911104 1916379344 18.958 100 43 87 1 1936732416 8157392 12195680
17:29:30 10099 8192000000 10853003552 11279515648 1926500144 19.039 100 45 90 1 1947439152 8718784 12220224
17:29:48 13476 8192000000 10872775360 11293839360 1938185568 19.132 100 64 123 2 1965599328 9466032 17947728
17:30:09 10552 8192000000 10877424800 11302596608 1944608464 19.184 100 66 132 1 1974525600 10705264 19211872
17:30:27 7009 8192000000 10885841744 11308945408 1946899968 19.202 100 59 118 2 1976574592 12846208 16828416
17:30:42 9415 8192000000 10894136240 11315900416 1948670720 19.216 100 61 122 0 1984367968 17803936 17893312
17:31:03 31559 8192000000 10893932864 11315707904 1951329376 19.237 100 41 82 0 1976682224 13481120 11871728
17:31:47 25673 8192000000 10882980864 11311992832 1945768848 19.193 100 42 84 1 1972921088 14718112 12434128
17:32:26 10024 8192000000 10892806480 11319939072 1951546192 19.239 100 35 70 1 1974926880 12575056 10805632
17:32:45 13376 8192000000 10903224400 11330048000 1957945232 19.290 100 54 107 1 1989994288 16198032 15851024
17:33:06 3261 8192000000 10913357536 11330621440 1961943824 19.321 100 57 111 1 1995366800 16543968 16879008
17:33:18 16490 8192000000 10909873040 11341045760 1968222096 19.371 100 50 98 2 1997027344 14339088 14466160
17:33:47 17263 8192000000 10906602432 11346235392 1969553120 19.382 100 45 89 1 1997786656 14970544 13262992
17:34:14 13846 8192000000 10917811232 11344977920 1977438624 19.444 100 56 110 2 2010601536 16610880 16552032
17:34:37 10649 8192000000 10919852960 11351502848 1977703136 19.447 100 50 99 1 2008335120 16120320 14511664
17:34:56 4251 8192000000 10930535456 11349299200 1963714224 19.336 99 68 135 0 2000840272 17228656 19897392
17:35:07 5453 8192000000 10926896560 11352604672 1979604464 19.462 100 53 103 0 2012408432 17190768 15613200
17:35:19 15271 8192000000 10925617520 11354759168 1975531440 19.429 100 57 114 0 2012198928 19306352 17361136
17:35:49 11088 8192000000 10922426560 11353636864 1961891264 19.321 99 51 101 2 1998098864 20360176 15847424
17:36:07 23470 8192000000 10901903696 11354832896 1979068880 19.457 100 38 75 1 2009194192 18346976 11778336
17:36:39 7210 8192000000 10911990368 11350011904 1967939408 19.369 100 39 79 1 1997455024 17794464 11721152
17:36:53 3181 8192000000 10916262992 11347693568 1974785344 19.423 100 43 84 2 2003550560 14904432 13860784
17:37:02 4055 8192000000 10923705024 11353985024 1978070768 19.449 100 60 120 0 2012135488 15880528 18184192
17:37:14 1962 8192000000 10933371312 11356876800 1979435776 19.460 100 77 154 4 2019215280 17553888 22225616
17:37:24 8666 8192000000 10918583472 11333496832 1958684992 19.296 99 80 159 3 2000848848 18864576 23299280
17:37:41 5450 8192000000 10940370736 11356991488 1977216064 19.443 100 80 159 1 2021371984 20526464 23629456
17:37:54 15290 8192000000 10921060816 11346587648 1955735024 19.272 99 63 125 1 1995001504 21193248 18073232
17:38:18 3103 8192000000 10921817184 11345682432 1967633088 19.367 100 65 130 1 2007085904 20268960 19183856
17:38:29 5916 8192000000 10933691680 11357106176 1974910112 19.424 100 72 143 0 2017885504 21390256 21585136
17:38:43 8012 8192000000 10911838848 11340197888 1956265440 19.276 99 61 122 0 1997028752 22567680 18195632
17:39:05 4261 8192000000 10940201440 11360772096 1976065696 19.434 100 65 130 0 2019846176 23668432 20112048
17:39:16 8449 8192000000 10932773648 11357134848 1972991296 19.409 100 79 157 0 2019409936 22915168 23503472
17:39:33 5152 8192000000 10933070320 11360694272 1977807760 19.447 100 70 140 0 2021771024 22975632 20987632
17:39:48 3629 8192000000 10936206528 11360944128 1961175872 19.315 99 73 144 0 2003409168 21663888 20569408
17:39:59 1945 8192000000 10954508720 11370999808 1986403296 19.515 100 87 174 2 2035049392 22326832 26319264
17:40:08 3188 8192000000 10952333040 11375194112 1987982320 19.528 100 76 152 0 2034517072 23787024 22747728
17:40:19 1654 8192000000 10959736560 11374092288 1988488912 19.532 100 91 180 2 2038783392 23612752 26681728
17:40:27 4274 8192000000 10956509456 11382501376 1990197024 19.545 100 81 164 2 2038278784 24190688 23891072
17:40:38 1984 8192000000 10945300400 11364552704 1974531936 19.421 99 83 163 2 2023213520 23543904 25137680
17:40:48 5709 8192000000 10922485152 11349897216 1963061680 19.330 99 64 126 0 2005084992 23328112 18695200
17:41:04 2378 8192000000 10935584304 11359797248 1979604528 19.462 100 71 142 1 2016712656 16756448 20351680
17:41:13 3591 8192000000 10944874544 11372306432 1988877104 19.535 100 77 153 2 2028593952 17281936 22434912
17:41:24 2148 8192000000 10957411200 11372281856 1976773792 19.439 99 87 174 2 2021068112 18991664 25302656
17:41:32 1904 8192000000 10933532016 11348598784 1953828720 19.257 99 82 162 1 1996724416 18775920 24119776
17:41:42 5900 8192000000 10923110240 11340075008 1945837936 19.193 99 84 166 3 1990291872 19800208 24653728
17:41:58 4689 8192000000 10928621984 11337412608 1959711792 19.304 100 91 181 4 2008333056 21737552 26883712
17:42:11 5644 8192000000 10911069936 11332415488 1954454048 19.262 100 72 144 1 1997786480 22410432 20922000
17:42:24 2038 8192000000 10913490464 11318964224 1942753200 19.169 100 88 176 1 1988575808 19422720 26399888
17:42:33 2575 8192000000 10917995952 11325337600 1937546064 19.127 99 86 170 0 1983655456 20820128 25289264
17:42:45 3022 8192000000 10920563440 11331710976 1955909264 19.274 100 81 160 0 2000196672 20101760 24185648
17:42:56 1391 8192000000 10913236176 11323293696 1935923008 19.114 99 92 183 3 1983501856 20616400 26962448
17:43:04 11187 8192000000 10908209984 11325321216 1916901280 18.962 98 69 138 2 1964101808 26402832 20797696
17:43:22 1306 8192000000 10916538448 11330678784 1945392160 19.190 100 72 144 0 1994000544 27243952 21364432
17:43:31 4276 8192000000 10914658912 11336441856 1948747136 19.216 100 75 148 0 1998789696 27224928 22817632
17:43:49 6444 8192000000 10915544656 11343196160 1952562368 19.247 100 61 120 0 1999634240 29260208 17811664
17:44:04 8091 8192000000 10911840256 11342319616 1939143552 19.140 99 58 116 0 1985052080 27662944 18245584
17:44:19 12324 8192000000 10904744720 11333382144 1935031024 19.107 99 54 108 2 1979508400 28064944 16412432
17:44:43 5197 8192000000 10900988528 11332268032 1946719536 19.200 100 49 98 0 1989624272 27946976 14957760
17:44:56 3012 8192000000 10900511328 11316105216 1930122464 19.068 99 83 165 0 1982994528 28102544 24769520
17:45:06 3840 8192000000 10902453520 11323469824 1938154224 19.132 100 70 140 0 1989775376 30539408 21081744
17:45:17 5728 8192000000 10919096592 11336212480 1950531264 19.231 100 81 161 1 2004741952 31013360 23197328
17:45:29 1328 8192000000 10925458496 11334291456 1948448176 19.214 100 89 179 1 2007499984 32229872 26821936
17:45:39 2793 8192000000 10929647136 11340865536 1954858736 19.265 100 84 165 2 2011669968 32182512 24628720
17:45:49 2766 8192000000 10931738976 11341778944 1951208032 19.236 100 87 173 2 2011393584 33082128 27103424
17:45:59 2652 8192000000 10931815536 11347095552 1958019840 19.290 100 75 150 1 2012629984 32358736 22251408
17:46:09 2214 8192000000 10917333488 11331543040 1944616544 19.184 100 67 130 1 1996118384 32356080 19145760
17:46:19 2361 8192000000 10913726800 11323457536 1923939072 19.018 99 84 168 0 1981446736 32726000 24781664
17:46:28 3592 8192000000 10917800704 11331895296 1942271792 19.165 100 81 159 3 1999122192 33034064 23816336
17:46:39 1324 8192000000 10932572320 11344338944 1949415360 19.222 100 83 166 0 2014448384 39812640 25220384
17:46:49 2993 8192000000 10934768032 11350417408 1957577552 19.287 100 63 124 2 2012872864 36420720 18874592
17:46:58 3372 8192000000 10939177200 11360751616 1962087008 19.323 100 57 115 2 2016669280 36812896 17769376
17:47:09 5014 8192000000 10935005520 11360362496 1964060784 19.338 100 56 111 1 2017665936 36244704 17360448
17:47:23 3830 8192000000 10933143920 11351584768 1941484368 19.159 99 66 132 3 1997865856 35899648 20481840
17:47:36 2538 8192000000 10928931424 11335778304 1940536576 19.151 99 91 181 2 2006527616 37889328 28101712
17:47:45 1830 8192000000 10920900752 11330777088 1934771120 19.105 100 79 158 0 1999610192 39896896 24942176
17:47:57 2881 8192000000 10923948784 11334463488 1940095408 19.148 100 82 164 0 2008212144 41396224 26720512
17:48:10 3961 8192000000 10930819648 11349241856 1948595104 19.215 100 75 150 1 2014231520 42024016 23612400
17:48:24 6910 8192000000 10935429280 11361042432 1952922592 19.250 100 59 118 1 2013720208 42078656 18718960
17:48:39 7080 8192000000 10927494480 11358474240 1957750656 19.288 100 47 90 1 2014716832 42039120 14927056
17:48:53 6713 8192000000 10945747920 11364851712 1960241328 19.308 100 55 106 2 2019567808 42743072 16583408
17:49:07 2585 8192000000 10923372384 11335233536 1924709504 19.025 98 67 132 0 1989727424 44211968 20805952
17:49:21 4945 8192000000 10935406096 11363778560 1957488224 19.286 100 61 120 0 2022768640 45687824 19592592
17:49:39 3405 8192000000 10955739568 11374313472 1968891168 19.377 100 68 135 0 2035494752 44999856 21603728
17:49:51 2723 8192000000 10960080928 11377266688 1964921520 19.345 100 83 167 0 2043203008 51774448 26507040
17:50:01 4636 8192000000 10948866480 11375964160 1964034352 19.338 100 54 108 1 2030850112 49028224 17787536
17:50:14 7559 8192000000 10946346352 11381940224 1971667760 19.399 100 45 90 1 2033752496 47609008 14475728
17:50:29 13654 8192000000 10922589600 11369299968 1929985952 19.067 98 39 78 1 1991756208 48713440 13056816
17:50:54 8161 8192000000 10933375760 11372584960 1938893984 19.138 99 41 82 0 1999610464 47091200 13625280
17:51:11 13343 8192000000 10916520416 11356864512 1940150128 19.148 99 36 72 1 1994527440 42202752 12174560
17:51:31 9621 8192000000 10935636304 11370504192 1960363088 19.309 100 50 99 1 2017994016 42006352 15624576
17:51:55 7837 8192000000 10940553648 11379331072 1966959936 19.361 100 42 83 4 2025127392 45340256 12827200
17:52:15 6538 8192000000 10942241632 11377045504 1949852752 19.225 99 50 100 0 2009660672 43214320 16593600
17:52:37 16380 8192000000 10941996240 11389919232 1954261680 19.260 99 37 74 1 2011696496 45066800 12368016
17:53:10 23684 8192000000 10938336032 11392548864 1969025344 19.378 100 25 50 1 2024185168 45985984 9173840
17:53:53 21767 8192000000 10937124272 11396710400 1965058272 19.346 100 27 54 1 2024824128 50296192 9469664
17:54:27 36236 8192000000 10935001360 11373441024 1945635296 19.192 99 33 65 1 2004483424 47832240 11015888
17:55:12 34861 8192000000 10921586624 11381354496 1949895024 19.226 100 26 52 2 2008832096 49455184 9481888
17:56:13 24607 8192000000 10923100288 11383971840 1940396704 19.150 100 22 44 1 2008693712 59611568 8685440
17:56:44 25964 8192000000 10922745872 11382308864 1928192704 19.052 99 17 34 0 1990473392 55391376 6889312
17:57:22 21377 8192000000 10919258464 11376574464 1924955488 19.027 99 13 27 1 1979607312 50017632 4634192
17:58:07 39144 8192000000 10897204752 11379527680 1959278640 19.300 100 9 18 1 1990286800 28194384 2813776
17:58:55 29350 8192000000 10922018464 11357790208 1973081184 19.410 100 31 55 3 1991791952 10590624 8120144
17:59:31 78437 8192000000 10906358160 11349434368 1917487440 18.967 97 27 54 1 1935677968 11166880 7023648
18:01:01 48928 8192000000 10899766848 11355295744 1966159008 19.355 100 26 52 1 1987170016 12781296 8229712
18:02:03 35717 8192000000 10902688256 11371274240 1969812400 19.384 100 19 38 1 1995714944 20462864 5439680
18:02:46 34869 8192000000 10873281872 11329351680 1907627600 18.888 97 15 30 0 1923361392 11686960 4046832
18:03:32 73376 8192000000 10906284896 11354505216 1966890240 19.361 100 32 64 1 1987053680 10952608 9210832
18:05:40 69633 8192000000 10898651696 11350302720 1932619632 19.088 98 14 28 1 1952313536 15195664 4498240
18:06:58 131752 8192000000 10911836960 11376103424 1981039280 19.473 100 23 45 0 2000559312 12711088 6808944
18:09:16 82781 8192000000 10936920576 11392872448 1988154016 19.529 100 23 46 0 2010326576 15244480 6928080
18:10:46 81987 8192000000 10899014528 11365613568 1949407440 19.222 98 37 74 1 1969611712 9641328 10562944
18:12:16 49637 8192000000 10931772064 11379146752 1985602112 19.509 100 48 97 4 2005861456 5729728 14529616
18:13:25 56953 8192000000 10903397792 11363774464 1928744176 19.057 97 26 52 0 1945737200 9477376 7515648
18:14:31 83277 8192000000 10885276256 11374960640 1957979712 19.290 99 21 42 0 1974368144 10444576 5943856
18:16:55 8515 8192000000 10911903968 11368017920 1984085664 19.497 100 54 108 0 2008620512 8734048 15800800
18:17:13 18216 8192000000 10891221616 11359576064 1969849040 19.384 100 19 38 0 1983746352 8479504 5417808
18:17:38 43288 8192000000 10925644448 11369316352 1966966432 19.361 99 45 89 1 1989585920 9290720 13328768
18:18:42 54337 8192000000 10886696480 11362045952 1934035264 19.099 98 21 42 2 1949815504 10286000 5494240
18:19:51 51149 8192000000 10884973760 11363790848 1916838832 18.962 97 8 16 1 1927438992 8484784 2115376
18:20:55 40448 8192000000 10892173920 11374870528 1977544048 19.445 100 16 32 0 1994006208 11984048 4478112
18:21:41 63281 8192000000 10897393440 11379650560 1960618032 19.311 99 16 32 0 1978365184 12905376 4841776
18:22:53 69922 8192000000 10906085728 11372396544 1977066544 19.441 100 23 45 0 1999724224 14624368 8033312
18:24:23 26322 8192000000 10910578144 11372466176 1974108432 19.418 100 32 65 5 2001125856 17060704 9956720
18:24:58 89995 8192000000 10893576784 11378954240 1952354944 19.245 99 7 14 0 1968082352 13733184 1994224
18:26:34 93798 8192000000 10904472704 11370905600 1904499792 18.862 96 9 18 0 1918927920 12184208 2243920
18:28:15 89913 8192000000 10850401600 11324252160 1836518800 18.312 93 8 16 0 1849397792 10888992 1990000
18:29:55 43932 8192000000 10857146080 11313209344 1838022672 18.325 94 16 32 0 1849546512 7024496 4499344
18:30:47 52363 8192000000 10872734832 11344228352 1915029536 18.947 98 26 52 1 1935010880 12603600 7377744
18:31:46 61282 8192000000 10855727360 11326337024 1902803632 18.849 98 11 22 0 1922346816 16030352 3512832
18:32:54 93220 8192000000 10869116864 11326058496 1834780080 18.298 94 23 46 1 1854444992 13586800 6078112
18:34:36 72900 8192000000 10867510160 11329220608 1864741232 18.542 96 15 30 1 1882150528 12873984 4535312
18:35:55 26692 8192000000 10853720256 11315326976 1900596448 18.831 98 35 69 1 1920551344 9587184 10367712
18:36:31 68166 8192000000 10861504720 11346202624 1925531952 19.031 99 24 48 0 1949425600 16774144 7119504
18:37:46 60727 8192000000 10878125664 11319500800 1873811696 18.615 96 27 54 3 1890940400 9892976 7235728
18:38:53 24775 8192000000 10871334720 11329200128 1893578640 18.775 98 29 58 0 1919908560 18284528 8045392
18:39:23 41437 8192000000 10865144352 11322691584 1887121392 18.723 98 37 74 3 1912551024 14891952 10537680
18:40:12 46972 8192000000 10841447344 11307573248 1871929280 18.600 97 17 34 1 1886418464 10225968 4263216
18:41:06 80874 8192000000 10835318048 11308761088 1884373712 18.700 98 18 36 2 1899888944 10317600 5197632
18:42:33 88253 8192000000 10856904400 11304894464 1881765776 18.679 98 27 54 0 1897446640 7768448 7912416
18:44:07 50756 8192000000 10852689600 11317178368 1891398528 18.757 98 32 64 1 1914169184 13596928 9173728
18:45:05 34573 8192000000 10849751344 11324747776 1922441664 19.006 100 20 40 0 1941725392 13505280 5778448
18:48:13 56643 8192000000 10873514480 11347337216 1931155616 19.076 99 21 42 1 1950010560 12990688 5864256
18:49:25 85971 8192000000 10857371696 11332358144 1895734064 18.792 97 11 22 0 1910956272 11924784 3297424
18:51:07 57521 8192000000 10866944976 11338166272 1926319488 19.037 99 20 40 0 1941253136 9050080 5883568
18:52:12 45977 8192000000 10871004416 11348008960 1947574736 19.207 100 9 18 2 1962021472 11542000 2904736
18:53:08 66719 8192000000 10875053472 11366690816 1949673136 19.224 100 13 26 1 1971031056 17047008 4310912
18:54:22 53832 8192000000 10892546000 11347808256 1935034688 19.107 99 17 32 2 1951801024 12504640 4261696
18:55:29 56447 8192000000 10888244784 11352133632 1923640816 19.016 98 19 38 2 1938637104 9488784 5507504
18:56:32 60316 8192000000 10887628784 11358760960 1925585920 19.032 98 20 40 1 1939907456 8961104 5360432
18:57:42 65797 8192000000 10905089856 11371384832 1957450928 19.286 99 22 44 0 1976031968 12908576 5672464
18:59:02 28486 8192000000 10929263600 11375337472 1975814784 19.432 100 45 89 3 1999988240 12130224 12043232
18:59:37 22732 8192000000 10918652512 11378507776 1980500368 19.469 100 28 56 2 1997435376 9299360 7635648
19:00:11 62380 8192000000 10918425376 11379924992 1945787568 19.193 98 19 38 0 1968975840 18344192 4844080
19:01:25 56188 8192000000 10896734656 11372507136 1942539296 19.167 98 23 46 3 1959242288 10455824 6247168
19:02:29 90140 8192000000 10915313696 11371577344 1938156128 19.132 98 16 32 3 1957029088 14077712 4795248
19:04:17 60876 8192000000 10907209920 11381030912 1939603472 19.144 98 26 52 1 1958362384 11773120 6985792
19:05:30 40788 8192000000 10914253392 11372167168 1956082416 19.275 99 24 48 0 1976342528 13822592 6437520
19:06:22 14916 8192000000 10949377600 11400306688 1991936992 19.559 100 49 98 0 2023937952 16824016 15176944
19:06:49 71614 8192000000 10915973520 11403694080 1975539584 19.429 99 35 70 0 2005622096 20152048 9930464
19:08:15 133299 8192000000 10902547328 11385135104 1983925552 19.496 100 18 36 0 2002351392 13463904 4961936
19:10:44 68697 8192000000 10912498176 11383828480 1950583120 19.231 98 28 56 1 1970708128 13055104 7069904
19:12:00 55048 8192000000 10890777728 11366535168 1953108560 19.251 98 21 42 1 1970553648 11346928 6098160
19:13:51 49353 8192000000 10888589136 11361894400 1912222208 18.924 97 15 28 2 1927369520 11288256 3859056
19:14:57 76341 8192000000 10893258512 11375099904 1930418544 19.070 98 21 42 0 1952126464 15441056 6266864
19:16:22 78956 8192000000 10879645744 11360989184 1935128640 19.108 98 17 33 2 1951511760 11100784 5282336
19:17:48 38531 8192000000 10882736960 11351691264 1927234240 19.045 98 28 56 2 1943026384 7271632 8520512
19:18:34 66356 8192000000 10862516016 11351511040 1882042928 18.682 96 11 22 1 1898357440 13195152 3119360
19:19:47 66701 8192000000 10894934960 11371159552 1936983712 19.123 99 20 40 1 1959566128 16693248 5889168
19:21:15 79988 8192000000 10869345200 11341852672 1862423568 18.523 95 26 52 3 1888811680 18437984 7950128
19:22:46 67806 8192000000 10828878544 11291426816 1778292368 17.835 92 4 8 0 1797167216 17862624 1012224
19:24:00 18322 8192000000 10865190272 11315539968 1889284432 18.740 98 45 90 1 1909523888 7859472 12379984
19:24:30 22964 8192000000 10851186400 11308113920 1899996832 18.826 99 44 89 0 1924240832 11864896 12379104
19:25:11 39420 8192000000 10839121712 11293171712 1871538080 18.597 98 38 76 0 1897196384 15227680 10430624
19:26:00 20653 8192000000 10853455296 11309846528 1894233136 18.780 99 32 64 0 1916625264 13524032 8868096
19:26:30 64970 8192000000 9659769712 9995546624 777580240 8.669 40 6 12 0 787196528 8152768 1463520

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 05-03-2021 19:28:31 to 05-03-2021 19:29:04.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 95 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-03-2021 19:29:05 to 05-03-2021 19:29:07.

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          238192
MON$OLDEST_ACTIVE               239148
MON$OLDEST_SNAPSHOT             239148
MON$NEXT_TRANSACTION            239148
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                       2023040
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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 ---
:62: 
:63: mscs-test-161.budzdorov.ru    Fri Mar  5 19:27:43 2021
:64:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:65: 
:66: 
:67: mscs-test-161.budzdorov.ru    Fri Mar  5 19:27:43 2021
:68:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:69: 
--- end of diff output ---

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

05.03.21 19:29:08. 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-05 19:29:10 No severe PSQL-related problems occured
05.03.21 19:29:12. End of report.