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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-23 19:27:09
DTS_END                         2020-12-23 19:27:09.4850
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/50948
TRN_ID                          253605
ATT_ID                          735
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: 9952.64 17520 1194317
customer order: creation 184.69 312 22163
customer order: refuse 15.20 271 1824
order to supplier: creation 48.08 1147 5770
order to supplier: removal 3.72 78696 446
invoice (draft): creation 48.41 2525 5809
invoice (draft): removal 56.10 719 6732
invoice accept: apply 44.31 14937 5317
invoice accept: cancel 51.23 626 6147
customer reserve: creation 4174.98 146 500998
customer reserve: removal 5006.29 45 600755
realization accept: apply 89.30 154 10716
realization accept: cancel 93.65 97 11238
payment from customer: creation 62.81 99 7537
payment from customer: removal 6.24 45 749
payment to supplier: creation 51.39 109 6167
payment to supplier: removal 3.55 48 426
service: total inventory turnovers 5.07 1147 608
service: total monetary turnovers 6.66 23 799
service: aggregate perf. data 0.93 15534 112
service: refresh index statistics 0.03 233728 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-12-2020 19:29:15 to 23-12-2020 19:29:17.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3187
TEST_TIME 2 3572
TEST_TIME 3 5348
TEST_TIME 4 5753
TEST_TIME 5 5812
TEST_TIME 6 6161
TEST_TIME 7 6007
TEST_TIME 8 6293
TEST_TIME 9 6527
TEST_TIME 10 6732
TEST_TIME 11 6928
TEST_TIME 12 7118
TEST_TIME 13 7837
TEST_TIME 14 7843
TEST_TIME 15 8232
TEST_TIME 16 9092
TEST_TIME 17 9703
TEST_TIME 18 10245
TEST_TIME 19 10355
TEST_TIME 20 11085
TEST_TIME 21 12076
TEST_TIME 22 12618
TEST_TIME 23 12245
TEST_TIME 24 12318
TEST_TIME 25 12301
TEST_TIME 26 12022
TEST_TIME 27 11777
TEST_TIME 28 11513
TEST_TIME 29 11581
TEST_TIME 30 11361
TEST_TIME 31 11360
TEST_TIME 32 11545
TEST_TIME 33 11402
TEST_TIME 34 11301
TEST_TIME 35 11420
TEST_TIME 36 11295
TEST_TIME 37 11257
TEST_TIME 38 11113
TEST_TIME 39 11269
TEST_TIME 40 11174
TEST_TIME 41 11244
TEST_TIME 42 11271
TEST_TIME 43 11146
TEST_TIME 44 10988
TEST_TIME 45 10870
TEST_TIME 46 10711
TEST_TIME 47 10821
TEST_TIME 48 10768
TEST_TIME 49 10687
TEST_TIME 50 10738
TEST_TIME 51 10736
TEST_TIME 52 10715
TEST_TIME 53 10597
TEST_TIME 54 10504
TEST_TIME 55 10405
TEST_TIME 56 10327
TEST_TIME 57 10256
TEST_TIME 58 10306
TEST_TIME 59 10313
TEST_TIME 60 10254
TEST_TIME 61 10266
TEST_TIME 62 10271
TEST_TIME 63 10246
TEST_TIME 64 10339
TEST_TIME 65 10317
TEST_TIME 66 10466
TEST_TIME 67 10445
TEST_TIME 68 10413
TEST_TIME 69 10355
TEST_TIME 70 10501
TEST_TIME 71 10599
TEST_TIME 72 10613
TEST_TIME 73 10648
TEST_TIME 74 10516
TEST_TIME 75 10507
TEST_TIME 76 10440
TEST_TIME 77 10419
TEST_TIME 78 10348
TEST_TIME 79 10284
TEST_TIME 80 10256
TEST_TIME 81 10199
TEST_TIME 82 10108
TEST_TIME 83 10206
TEST_TIME 84 10176
TEST_TIME 85 10146
TEST_TIME 86 10171
TEST_TIME 87 10159
TEST_TIME 88 10223
TEST_TIME 89 10223
TEST_TIME 90 10268
TEST_TIME 91 10284
TEST_TIME 92 10287
TEST_TIME 93 10269
TEST_TIME 94 10394
TEST_TIME 95 10414
TEST_TIME 96 10431
TEST_TIME 97 10349
TEST_TIME 98 10297
TEST_TIME 99 10247
TEST_TIME 100 10215
TEST_TIME 101 10163
TEST_TIME 102 10130
TEST_TIME 103 10091
TEST_TIME 104 10025
TEST_TIME 105 10050
TEST_TIME 106 10052
TEST_TIME 107 10025
TEST_TIME 108 10013
TEST_TIME 109 9992
TEST_TIME 110 9998
TEST_TIME 111 10001
TEST_TIME 112 9992
TEST_TIME 113 10007
TEST_TIME 114 9984
TEST_TIME 115 9970
TEST_TIME 116 10026
TEST_TIME 117 10055
TEST_TIME 118 10034
TEST_TIME 119 10033
TEST_TIME 120 9953

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 23-12-2020 19:29:18 to 23-12-2020 19:29:22.

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 1658585 1658585 0 0.00 0 35153 5 0 0
doc_list_biud 1658574 1658574 0 0.00 0 55173 21 0 0
sp_add_invoice_to_stock 5481 5317 164 2.99 60 166624 14937 0 164
sp_cancel_adding_invoice 6147 6147 0 0.00 5 53284 627 0 0
sp_cancel_client_order 1824 1824 0 0.00 4 15598 271 0 0
sp_cancel_customer_reserve 600755 600755 0 0.00 1 22201 45 0 0
sp_cancel_pay_from_customer 749 749 0 0.00 2 3282 46 0 0
sp_cancel_pay_to_supplier 426 426 0 0.00 3 3011 49 0 0
sp_cancel_supplier_invoice 6746 6732 14 0.20 2 55179 720 0 14
sp_cancel_supplier_order 446 446 0 0.00 5 863956 78696 0 0
sp_cancel_write_off 11238 11238 0 0.00 1 16492 98 0 0
sp_client_order 22163 22163 0 0.00 4 22783 313 0 0
sp_customer_reserve 500998 500998 0 0.00 0 74258 147 0 0
sp_fill_shopping_cart 33738 33738 0 0.00 1 12046 30 0 0
sp_fill_shopping_cart_clo_res 500995 500995 0 0.00 0 16174 12 0 0
sp_get_clo_for_invoice 5314 5314 0 0.00 0 22366 287 0 0
sp_kill_cost_storno 18560 18560 0 0.00 0 16413 39 0 0
sp_kill_qstorno_ret_qs2qd 1219926 1219926 0 0.00 0 55170 25 0 0
sp_kill_qty_storno 643168 643168 0 0.00 0 55172 54 0 0
sp_lock_selected_doc 22206 22206 0 0.00 0 8415 5 0 0
sp_make_cost_storno 29734 29734 0 0.00 0 35140 51 0 0
sp_multiply_rows_for_pdistr 29730 29730 0 0.00 0 10833 24 0 0
sp_multiply_rows_for_qdistr 22163 22163 0 0.00 0 21043 142 0 0
sp_pay_from_customer 7537 7537 0 0.00 4 21601 99 0 0
sp_pay_to_supplier 6167 6167 0 0.00 5 15069 110 0 0
sp_payment_common 13704 13704 0 0.00 1 10757 24 0 0
sp_qd_handle_on_cancel_clo 1824 1824 0 0.00 0 15590 249 0 0
sp_qd_handle_on_invoice_upd_sts 11458 11458 0 0.00 0 19804 252 0 0
sp_qd_handle_on_reserve_upd_sts 10715 10715 0 0.00 0 10390 50 0 0
sp_reserve_write_off 10716 10716 0 0.00 6 21687 155 0 0
sp_supplier_invoice 5809 5809 0 0.00 6 78394 2526 0 0
sp_supplier_order 5770 5770 0 0.00 5 49443 1148 0 0
srv_aggregate_perf_data 112 112 0 0.00 2971 171601 15534 0 0
srv_fill_mon_cache_memory 145 145 0 0.00 1031 163344 36863 0 0
srv_find_qd_qs_mism 1143435 1143435 0 0.00 0 17648 5 0 0
srv_make_invnt_saldo 608 608 0 0.00 40 112980 1148 0 0
srv_make_money_saldo 799 799 0 0.00 0 3834 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 115821 352450 233729 0 0
t$perf-abend:sp_add_invoice_to_stock 164 164 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5317 5317 0 0.00 0 10031 144 0 0
t$perf-norm:sp_cancel_adding_invoice 450 450 0 0.00 1 9002 91 0 0
t$perf-norm:sp_cancel_client_order 1824 1824 0 0.00 0 811 7 0 0
t$perf-norm:sp_cancel_customer_reserve 745 745 0 0.00 0 3489 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 749 749 0 0.00 0 9443 22 0 0
t$perf-norm:sp_cancel_pay_to_supplier 426 426 0 0.00 0 1138 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 447 447 0 0.00 0 5042 38 0 0
t$perf-norm:sp_cancel_supplier_order 446 446 0 0.00 0 23446 1211 0 0
t$perf-norm:sp_cancel_write_off 1093 1093 0 0.00 0 2932 11 0 0
t$perf-norm:sp_client_order 22163 22163 0 0.00 0 9077 14 0 0
t$perf-norm:sp_customer_reserve 1079 1079 0 0.00 0 2836 7 0 0
t$perf-norm:sp_pay_from_customer 7537 7537 0 0.00 0 9091 9 0 0
t$perf-norm:sp_pay_to_supplier 6167 6167 0 0.00 0 6879 9 0 0
t$perf-norm:sp_reserve_write_off 10716 10716 0 0.00 0 18403 13 0 0
t$perf-norm:sp_supplier_invoice 5809 5809 0 0.00 0 9158 15 0 0
t$perf-norm:sp_supplier_order 5770 5770 0 0.00 0 8494 18 0 0
t$perf-norm:srv_aggregate_perf_data 112 112 0 0.00 0 70 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 145 145 0 0.00 0 222 5 0 0
t$perf-norm:srv_make_invnt_saldo 608 608 0 0.00 0 2110 14 0 0
t$perf-norm:srv_make_money_saldo 799 799 0 0.00 0 4645 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 10 4 0 0
v_add_invoice_to_stock 10950 10622 328 2.99 0 6640 20 0 328
v_all_customers 40514 40514 0 0.00 0 16 0 0 0
v_all_suppliers 32156 32156 0 0.00 0 13 1 0 0
v_all_wares 44320 44320 0 0.00 0 60 1 0 0
v_cancel_adding_invoice 900 900 0 0.00 0 594 6 0 0
v_cancel_client_order 3648 3648 0 0.00 0 5820 7 0 0
v_cancel_customer_prepayment 1498 1498 0 0.00 0 1966 6 0 0
v_cancel_customer_reserve 1490 1490 0 0.00 0 2406 5 0 0
v_cancel_payment_to_supplier 852 852 0 0.00 0 2987 5 0 0
v_cancel_supplier_invoice 922 894 28 3.03 0 217 13 0 28
v_cancel_supplier_order 892 892 0 0.00 0 3196 8 0 0
v_cancel_write_off 2186 2186 0 0.00 0 13551 18 0 0
v_max_id_clo_ord 5768 5768 0 0.00 0 626 1 0 0
v_max_id_clo_res 1079 1079 0 0.00 0 3236 11 0 0
v_max_id_ord_sup 5809 5809 0 0.00 0 9897 4 0 0
v_max_non_paid_invoice 1666 1666 0 0.00 0 1343 3 0 0
v_max_non_paid_realizn 3854 3854 0 0.00 0 3008 4 0 0
v_min_id_clo_ord 5768 5768 0 0.00 0 6382 7 0 0
v_min_id_clo_res 1079 1079 0 0.00 0 616 3 0 0
v_min_id_ord_sup 5809 5809 0 0.00 0 7415 7 0 0
v_min_non_paid_invoice 6167 6167 0 0.00 0 5928 12 0 0
v_min_non_paid_realizn 7537 7537 0 0.00 0 10753 16 0 0
v_our_firm 11172 11172 0 0.00 0 12 1 0 0
v_reserve_write_off 21430 21430 0 0.00 0 5014 6 0 0
x_lock_depdocs_on_canc_invoice 12432 12432 0 0.00 0 18241 91 0 0
x_lock_depdocs_on_canc_sup_ord 446 446 0 0.00 0 6372 227 0 0
x_make_qstorno_1000_1200 5770 5770 0 0.00 1 49433 1086 0 0
x_make_qstorno_1200_2000 5809 5809 0 0.00 3 78372 2424 0 0
x_make_qstorno_2100_3300 500998 500998 0 0.00 0 74257 133 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-12-2020 19:29:23 to 23-12-2020 19:29:27.

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:12 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:19 24729 8192000000 10271773744 10586046464 966192272 10.550 74 59 119 0 987574336 2586752 18795312
16:57:51 35365 8192000000 10358755504 10681532416 1406396224 14.652 100 87 174 0 1438893072 4610944 27885904
16:58:35 19915 8192000000 10378131712 10709635072 1440007568 14.950 100 79 158 0 1472546512 6580768 25958176
16:59:07 38049 8192000000 10436316912 10769444864 1481872768 15.318 100 88 176 0 1518434016 7666704 28894544
16:59:53 27281 8192000000 10469016320 10804285440 1513532064 15.594 100 83 166 0 1548402336 8598752 26271520
17:00:31 16867 8192000000 10483421216 10821136384 1532954224 15.763 100 94 188 0 1572452608 9993360 29505024
17:00:57 20840 8192000000 10492490128 10837262336 1548278992 15.895 100 86 172 1 1585406176 10619264 26507920
17:01:36 16366 8192000000 10525514448 10875334656 1574411536 16.120 100 74 148 1 1606887280 10282384 22193360
17:02:05 6868 8192000000 10539229232 10895998976 1600626736 16.345 100 79 158 0 1635716368 10869216 24220416
17:02:23 11781 8192000000 10578411408 10932633600 1628251184 16.580 100 84 169 0 1664832624 11429824 25151616
17:02:44 9986 8192000000 10593063472 10954821632 1650162928 16.766 100 83 166 1 1687253776 11998256 25092592
17:03:04 5026 8192000000 10612683136 10973741056 1667101296 16.909 100 87 174 0 1705608064 12404704 26102064
17:03:18 12485 8192000000 10621923920 10989682688 1685069456 17.060 100 86 172 3 1723121616 12834048 25218112
17:03:38 10680 8192000000 10630472688 11003117568 1692179648 17.120 100 81 161 1 1728911568 13240368 23491552
17:03:57 4952 8192000000 10645090464 11018100736 1709151808 17.262 100 80 159 2 1744648944 12617488 22879648
17:04:09 7990 8192000000 10659037632 11031543808 1723040880 17.378 100 73 146 1 1756209152 12487248 20681024
17:04:24 4343 8192000000 10667697344 11042770944 1730283056 17.438 100 83 166 0 1766782128 13293728 23205344
17:04:35 4594 8192000000 10682884544 11058950144 1739357648 17.513 100 74 148 0 1772560080 12146784 21055648
17:04:47 4656 8192000000 10701306976 11073572864 1755278112 17.645 100 85 170 1 1791486512 12386864 23821536
17:04:59 4083 8192000000 10704420032 11085668352 1764592624 17.722 100 79 158 1 1799815008 13284480 21937904
17:05:10 3180 8192000000 10718044768 11096809472 1778520560 17.837 100 87 172 0 1816036256 13323632 24192064
17:05:19 2461 8192000000 10727857744 11104493568 1781392336 17.861 100 85 166 0 1818492416 13643008 23457072
17:05:29 2384 8192000000 10726317824 11107999744 1793248032 17.958 100 84 164 1 1829385936 12833968 23303936
17:05:37 2101 8192000000 10735597808 11118600192 1796250976 17.983 100 84 167 1 1831978784 12277856 23449952
17:05:46 1970 8192000000 10742529440 11124441088 1804795472 18.053 100 87 172 2 1840356000 11252880 24307648
17:05:55 2005 8192000000 10748881168 11131580416 1807127648 18.072 100 88 176 0 1844195088 11688576 25378864
17:06:03 2825 8192000000 10745397984 11135479808 1812759712 18.118 100 83 168 1 1847602944 10932560 23910672
17:06:12 5979 8192000000 10749019104 11139313664 1812560480 18.117 100 69 138 0 1843723216 12634784 18527952
17:06:25 4513 8192000000 10763815920 11153342464 1824001568 18.210 100 84 168 1 1860501392 13532320 22967504
17:06:36 2040 8192000000 10782506464 11169955840 1839736896 18.339 100 90 180 1 1879198512 14214816 25246800
17:06:45 1288 8192000000 10794666224 11180580864 1849040352 18.414 100 98 196 0 1892298016 16267008 26990656
17:06:52 1806 8192000000 10797061920 11186327552 1855681840 18.468 100 87 174 1 1894504912 14834128 23988944
17:07:00 1883 8192000000 10812960496 11199111168 1864849168 18.543 100 96 192 0 1906816448 13942208 28025072
17:07:08 1632 8192000000 10811364352 11198128128 1864695664 18.541 100 94 185 2 1904662400 14306560 25660176
17:07:16 1471 8192000000 10816312560 11206852608 1869638768 18.581 100 90 180 0 1907761296 12168432 25954096
17:07:24 1380 8192000000 10811459248 11199627264 1869302128 18.579 100 95 192 2 1909216000 13161104 26752768
17:07:31 1241 8192000000 10817025312 11205013504 1868366992 18.571 100 96 190 2 1908686176 13436880 26882304
17:07:39 41887 8192000000 10791517104 11202105344 1866031840 18.552 100 68 136 0 1897290656 12100016 19158800
17:08:27 4011 8192000000 10782620576 11209084928 1863650832 18.533 100 42 84 2 1884597072 9263664 11682576
17:08:40 6166 8192000000 10780190656 11208687616 1869356720 18.579 100 38 76 2 1887821088 7950368 10514000
17:09:01 8148 8192000000 10780323504 11209428992 1871918896 18.600 100 26 52 3 1886916992 6887920 8110176
17:09:15 8666 8192000000 10779836752 11213320192 1872061152 18.601 100 23 46 0 1885224160 6646480 6516528
17:09:32 5058 8192000000 10780780144 11213623296 1874410448 18.620 100 27 54 1 1890036976 7774560 7851968
17:09:46 6607 8192000000 10784196096 11215749120 1873836064 18.615 100 24 46 1 1887172880 6710912 6625904
17:10:00 22785 8192000000 10779902528 11218247680 1882716464 18.687 100 11 22 1 1890582800 5081136 2785200
17:10:32 12272 8192000000 10792259216 11225800704 1884058304 18.698 100 16 32 0 1895207232 6108528 5040400
17:10:53 10594 8192000000 10794922736 11231653888 1884966960 18.705 100 14 28 1 1894554272 5657728 3929584
17:11:10 9764 8192000000 10798248336 11234074624 1892188720 18.763 100 24 48 3 1906259520 7071136 6999664
17:11:28 13774 8192000000 10796867232 11237527552 1891986896 18.762 100 15 30 1 1901734528 5704544 4043088
17:11:51 8376 8192000000 10800532544 11239124992 1892675440 18.767 100 11 22 1 1901346880 5365776 3305664
17:12:08 17773 8192000000 10811183056 11242913792 1898016672 18.810 100 26 52 1 1911992336 5867504 8108160
17:12:33 69473 8192000000 10816883872 11252785152 1900365040 18.829 100 31 62 2 1914224016 5297072 8561904
17:13:50 4467 8192000000 10815836256 11251351552 1901507664 18.838 100 30 62 1 1915805392 5755328 8542400
17:14:01 6196 8192000000 10821167808 11259592704 1903425024 18.854 100 31 62 0 1923659312 12009600 8224688
17:14:14 4727 8192000000 10823351616 11257315328 1903525872 18.855 100 29 56 1 1919135664 7399712 8210080
17:14:28 5246 8192000000 10827749104 11263275008 1901873824 18.841 100 28 54 4 1920882032 11333024 7675184
17:14:40 10023 8192000000 10817687072 11254812672 1886831968 18.720 99 22 44 1 1898528352 5568064 6128320
17:14:58 7633 8192000000 10820248704 11257225216 1905437184 18.870 100 21 40 3 1916963008 6140160 5385664
17:15:14 7497 8192000000 10823481392 11259645952 1888203360 18.731 99 22 44 2 1911874144 18272912 5397872
17:15:31 5168 8192000000 10810394304 11246931968 1898161248 18.812 100 31 62 1 1912872048 5141328 9569472
17:15:45 7461 8192000000 10794764464 11223670784 1854958032 18.462 98 18 34 2 1869848320 10460960 4429328
17:15:59 11408 8192000000 10775262432 11213549568 1824333872 18.213 97 11 22 3 1832676944 5084672 3258400
17:16:17 12868 8192000000 10772788896 11213426688 1826525712 18.231 97 12 25 1 1835829216 6155200 3148304
17:16:36 11143 8192000000 10772411616 11205025792 1814704192 18.134 97 19 37 0 1824648528 4915952 5028384
17:16:54 11416 8192000000 10726982144 11159465984 1769305776 17.761 96 10 20 0 1777652096 5660176 2686144
17:17:12 17439 8192000000 10753426528 11168538624 1801444096 18.026 98 10 20 1 1809137648 5480112 2213440
17:17:37 45325 8192000000 10780166576 11192963072 1822422400 18.197 98 40 80 0 1839801728 5580736 11798592
17:18:31 15483 8192000000 10720070048 11142967296 1739711632 17.516 94 21 42 2 1751212288 5581392 5919264
17:18:56 5419 8192000000 10700996480 11114123264 1743495808 17.548 97 31 60 2 1758609776 6686464 8427504
17:19:10 6488 8192000000 10725368544 11143127040 1807607856 18.076 100 37 74 2 1826562400 8705280 10249264
17:19:23 5620 8192000000 10733535648 11143565312 1780253040 17.852 98 41 82 0 1798708240 6658656 11796544
17:19:35 7470 8192000000 10695752880 11119910912 1752888432 17.626 97 27 54 1 1767676416 6644032 8143952
17:19:50 4020 8192000000 10714850160 11135778816 1799409056 18.009 100 25 50 3 1813651744 6391168 7851520
17:20:03 6781 8192000000 10693845488 11105865728 1698525760 17.173 95 19 37 1 1708587808 4832352 5229696
17:20:17 8923 8192000000 10693726672 11109715968 1746641568 17.574 97 28 56 1 1760284448 4928896 8713984
17:20:32 9633 8192000000 10702836128 11111878656 1725388000 17.397 96 15 30 0 1734637968 5094352 4155616
17:20:50 10407 8192000000 10709747984 11123879936 1761579632 17.697 98 27 54 1 1775166032 5355520 8230880
17:21:09 10328 8192000000 10711649632 11122909184 1752376224 17.621 97 24 48 5 1764406768 5773040 6257504
17:21:28 8402 8192000000 10728275104 11146489856 1810018288 18.096 100 26 52 0 1824259168 5596080 8644800
17:21:42 15161 8192000000 10729674464 11155468288 1813214768 18.122 100 22 42 1 1824928944 5352032 6362144
17:22:04 42281 8192000000 10750691040 11167744000 1824244944 18.212 100 13 26 1 1834005488 5640176 4120368
17:22:54 29400 8192000000 10742609328 11172360192 1835566816 18.305 100 40 81 0 1853875120 6585360 11722944
17:23:31 8875 8192000000 10747770432 11170631680 1820128368 18.179 99 21 42 3 1831671008 5124112 6418528
17:23:47 8535 8192000000 10755799744 11179298816 1840204432 18.342 100 30 59 0 1854425040 6050288 8170320
17:24:04 5653 8192000000 10764907936 11183185920 1843462928 18.369 100 28 56 1 1858999568 6768304 8768336
17:24:15 7329 8192000000 10761873584 11188862976 1848645824 18.411 100 23 46 0 1861579472 6465840 6467808
17:24:29 9341 8192000000 10767606224 11192770560 1851847952 18.437 100 26 52 1 1864736272 5543520 7344800
17:24:51 9236 8192000000 10796498544 11218731008 1862488224 18.523 100 11 22 0 1874784832 8902720 3393888
17:25:09 6597 8192000000 10777937968 11213492224 1869974256 18.584 100 23 45 2 1882356704 6588384 5794064
17:25:21 11102 8192000000 10789480352 11216891904 1870931824 18.592 100 17 34 0 1881587040 5536496 5118720
17:25:44 12082 8192000000 10784021824 11221401600 1875063568 18.625 100 16 32 1 1884860256 5116000 4680688
17:26:06 7285 8192000000 10790607952 11221839872 1878423648 18.652 100 18 36 2 1889149520 5251840 5474032
17:26:19 15601 8192000000 10785781248 11222364160 1878991040 18.657 100 14 27 4 1888061392 5080448 3989904
17:26:41 11208 8192000000 10795373904 11226181632 1880160736 18.666 100 20 40 1 1890881856 5377984 5343136
17:26:59 21750 8192000000 10820271488 11241615360 1888403232 18.733 100 19 38 2 1899389376 5005488 5980656
17:27:38 85622 8192000000 10854381136 11280777216 1918325296 18.973 100 32 62 2 1935036320 8384864 8326160
17:29:19 13109 8192000000 10872910416 11296616448 1939662784 19.144 100 51 101 0 1965300592 11955984 13681824
17:29:51 12866 8192000000 10873954208 11306446848 1947342128 19.205 100 50 100 1 1973458240 11756544 14359568
17:30:10 13267 8192000000 10875435136 11312996352 1950655760 19.232 100 38 74 4 1972504736 10891024 10957952
17:30:31 28372 8192000000 10886546544 11321098240 1926451520 19.038 98 46 92 0 1952028016 12365712 13210784
17:31:14 3386 8192000000 10900771856 11334537216 1960249504 19.308 100 55 110 1 1994892320 18714832 15927984
17:31:26 3897 8192000000 10896035664 11329409024 1963369904 19.333 100 57 113 1 1995263952 14353920 17540128
17:31:37 12859 8192000000 10903966624 11334520832 1949420752 19.222 99 54 105 1 1981422368 16903904 15097712
17:31:59 3499 8192000000 10917003520 11344535552 1968844048 19.376 100 62 123 2 2004453152 17368640 18240464
17:32:16 7244 8192000000 10916952384 11343966208 1969491376 19.381 100 67 130 0 2006024640 17929392 18603872
17:32:33 13405 8192000000 10920569696 11351040000 1977065312 19.441 100 57 112 3 2013042624 18879936 17097376
17:32:59 1635 8192000000 10951422720 11373142016 1992146768 19.561 100 78 153 1 2037832928 23536208 22149952
17:33:09 8085 8192000000 10942732944 11367182336 1966052880 19.354 99 61 120 0 2007346144 24310336 16982928
17:33:24 4307 8192000000 10930781344 11358621696 1977524768 19.445 100 60 120 1 2026472720 31443920 17504032
17:33:35 10927 8192000000 10934271824 11363074048 1984583440 19.501 100 65 128 2 2028589600 25063552 18942608
17:33:57 5936 8192000000 10953122960 11381800960 1992717248 19.565 100 59 118 0 2036525776 26289504 17519024
17:34:12 2910 8192000000 10954969520 11378683904 1996101920 19.592 100 65 130 0 2043102080 27406080 19594080
17:34:22 11403 8192000000 10958034448 11386519552 1982828272 19.487 99 69 136 0 2036313184 33385632 20099280
17:34:40 7284 8192000000 10960020080 11385569280 1999949856 19.622 100 64 126 1 2047094992 28976032 18169104
17:34:57 3652 8192000000 10958604176 11384868864 1983058576 19.489 99 67 133 1 2034954784 31680384 20215824
17:35:09 8391 8192000000 10936092144 11363352576 1959275600 19.300 98 70 141 1 2016614224 36406352 20932272
17:35:26 4525 8192000000 10933037376 11360739328 1976416576 19.436 100 62 123 2 2026564288 31553328 18594384
17:35:37 3793 8192000000 10950422608 11373645824 1980516528 19.469 100 63 120 0 2031063664 32176832 18370304
17:35:48 8741 8192000000 10951466176 11381387264 1975473776 19.429 99 62 124 0 2027137712 32983664 18680272
17:36:06 7036 8192000000 10969752960 11391148032 1998463568 19.611 100 70 139 0 2054504928 35016688 21024672
17:36:20 10184 8192000000 10956496480 11385245696 1991693568 19.557 100 59 118 3 2044557664 35043600 17820496
17:36:37 3010 8192000000 10961200928 11377516544 1970046816 19.386 99 83 166 6 2030169408 35228752 24893840
17:36:49 3061 8192000000 10966243760 11384877056 1991930784 19.559 100 89 174 2 2052992880 35242784 25819312
17:37:02 3514 8192000000 10969648384 11388362752 1995064288 19.584 100 80 160 0 2057008864 37455648 24488928
17:37:20 1852 8192000000 10950749216 11370803200 1964969456 19.346 99 80 160 0 2028924800 39456944 24498400
17:37:31 4177 8192000000 10935768928 11360890880 1955895728 19.273 99 70 139 2 2014535008 37557952 21081328
17:37:42 15784 8192000000 10948950336 11367882752 1967731040 19.367 99 70 139 1 2027952368 39156720 21064608
17:38:12 8199 8192000000 10967053280 11392073728 1974946000 19.425 99 55 110 1 2035367952 42998800 17423152
17:38:32 3611 8192000000 10982048112 11405451264 1999750592 19.621 100 72 141 0 2068055392 46198864 22105936
17:38:45 8957 8192000000 10982060912 11411443712 2009220528 19.695 100 68 135 1 2078047552 47050320 21776704
17:39:03 6063 8192000000 10963887968 11389419520 1971210304 19.395 98 68 135 2 2038458000 45265968 21981728
17:39:20 3060 8192000000 10948639360 11376070656 1952628848 19.247 98 58 117 3 2018624416 47093152 18902416
17:39:36 2123 8192000000 10935191504 11347677184 1918424032 18.974 97 72 143 0 1988068448 48120544 21523872
17:39:45 2864 8192000000 10974251984 11387514880 1978880320 19.456 100 80 160 1 2056597168 51388720 26328128
17:39:54 3683 8192000000 10980306848 11394465792 1984512256 19.500 100 78 156 2 2059947248 51552912 23882080
17:40:04 1097 8192000000 10989264576 11394269184 1987672896 19.525 100 84 169 0 2065034416 51495184 25866336
17:40:12 2083 8192000000 10974992208 11381530624 1974027024 19.417 99 87 172 2 2052239136 51763264 26448848
17:40:20 2079 8192000000 10968824960 11377377280 1960894848 19.313 99 74 148 0 2036982624 52521504 23566272
17:40:30 1690 8192000000 10988259344 11397292032 1987671568 19.525 100 88 176 1 2069826608 53994528 28160512
17:40:39 3514 8192000000 10978617328 11401670656 1988318592 19.531 100 71 142 0 2066117040 55442128 22356320
17:40:49 5345 8192000000 10966986912 11394318336 1968686576 19.375 99 54 108 0 2040134080 54125200 17322304
17:41:03 16210 8192000000 10946390384 11372474368 1965423040 19.349 99 51 101 0 2030933648 49661376 15849232
17:41:25 1030 8192000000 10992510864 11408510976 1995319632 19.586 100 71 140 0 2073474112 55756784 22397696
17:41:33 9820 8192000000 10965918992 11396337664 1951889696 19.242 98 53 106 1 2028169936 58472880 17807360
17:41:50 11342 8192000000 10968982416 11406950400 1982215696 19.482 100 47 92 1 2057665472 59584112 15865664
17:42:13 15529 8192000000 10950502720 11389198336 1955808384 19.273 99 41 82 0 2028281696 57972160 14501152
17:42:42 10468 8192000000 10946555392 11375009792 1949760752 19.225 100 44 89 2 2025986560 60511648 15714160
17:43:03 11921 8192000000 10956109632 11390541824 1955657600 19.272 100 39 78 0 2032360288 62638192 14064496
17:43:30 16400 8192000000 10955866080 11401310208 1966190464 19.355 100 41 82 0 2044886368 64818240 13877664
17:44:10 21059 8192000000 10928661136 11370156032 1910013456 18.907 97 34 68 0 1981734400 59933104 11787840
17:44:37 15135 8192000000 10937490352 11390238720 1935095152 19.108 99 35 70 0 2007430064 59951952 12382960
17:45:09 14404 8192000000 10926428064 11379130368 1946575504 19.199 100 27 54 2 2012475856 56462928 9437424
17:45:37 21420 8192000000 10935136784 11394015232 1958613328 19.295 100 21 42 1 2017080688 51275856 7191504
17:46:19 40423 8192000000 10925563952 11373514752 1906299056 18.877 98 29 59 3 1973374576 56482224 10593296
17:47:18 30327 8192000000 10912280352 11369750528 1893754016 18.776 98 18 36 1 1955795104 54220512 7820576
17:48:09 30214 8192000000 10887997152 11351113728 1933544240 19.095 100 18 36 2 1979380112 39392880 6442992
17:48:52 67220 8192000000 10872410336 11346247680 1907136656 18.884 98 13 26 1 1936463952 25358352 3968944
17:51:02 89458 8192000000 10852798848 11332378624 1871117344 18.593 96 20 40 1 1892472592 15293904 6061344
17:52:48 65493 8192000000 10835072048 11293286400 1822379520 18.197 95 13 25 0 1838944560 12843120 3721920
17:54:11 104292 8192000000 10889107360 11330441216 1898476560 18.814 98 24 48 0 1915855056 10547248 6831248
17:56:13 80465 8192000000 10890071888 11347341312 1947445488 19.206 100 15 29 1 1961884160 10879344 3559328
17:57:40 45753 8192000000 10891578512 11352657920 1929754384 19.065 98 17 34 1 1946715392 12133424 4827584
17:58:48 39542 8192000000 10903952464 11370618880 1962587008 19.327 100 16 31 2 1983899216 16964896 4347312
17:59:40 109453 8192000000 10899474208 11349364736 1912705600 18.928 97 21 42 3 1930887888 12257712 5924576
18:03:09 56584 8192000000 10898570128 11364278272 1941862432 19.162 99 9 18 0 1958579872 14318016 2399424
18:04:14 68258 8192000000 10906220544 11358797824 1917084736 18.963 97 19 38 3 1935159856 12967328 5107792
18:05:49 33693 8192000000 10913745872 11370868736 1959818464 19.305 99 29 58 0 1983993968 14918624 9256880
18:06:29 102315 8192000000 10913209456 11385446400 1970983136 19.393 100 9 18 2 1990866032 16647200 3235696
18:08:18 163344 8192000000 10906651984 11377451008 1881314080 18.676 95 6 12 0 1898754432 15221664 2218688
18:12:04 67452 8192000000 10927148656 11382800384 1967461152 19.365 99 28 56 1 1984696704 9708816 7526736
18:13:26 43391 8192000000 10937386320 11383848960 1964453472 19.341 99 35 68 2 1995252400 20503616 10295312
18:14:25 37577 8192000000 10931791408 11396304896 1990483056 19.548 100 38 74 2 2018145824 15540912 12121856
18:15:22 9134 8192000000 10919449408 11382767616 1985792608 19.511 100 30 61 2 2007504960 13225040 8487312
18:16:07 56817 8192000000 10946642640 11401342976 1990158352 19.545 100 18 36 0 2010738096 14892048 5687696
18:17:14 49113 8192000000 10920923584 11389923328 1969034464 19.378 99 16 32 0 1985900672 12055744 4810464
18:18:09 65471 8192000000 10876673168 11351101440 1877317504 18.643 94 18 36 2 1888966928 6772976 4876448
18:19:29 52981 8192000000 10883134816 11364118528 1962624880 19.327 100 9 18 1 1972606000 7343632 2637488
18:20:28 31119 8192000000 10893380624 11377299456 1973840384 19.416 100 11 22 0 1983452016 6552992 3058640
18:21:11 85291 8192000000 10859239248 11331383296 1841334016 18.352 93 12 24 1 1856536432 11064480 4137936
18:22:42 51652 8192000000 10874986096 11357200384 1951134000 19.236 100 9 18 1 1962582032 8665280 2782752
18:24:15 65907 8192000000 10877141968 11372232704 1936335376 19.118 99 16 32 2 1962486480 21602736 4548368
18:25:30 38230 8192000000 10878664224 11367149568 1953599920 19.255 100 3 6 0 1970056800 15760320 696560
18:26:14 63315 8192000000 10866607920 11347869696 1903388736 18.854 97 7 14 0 1912678368 7515264 1774368
18:27:23 46784 8192000000 10874096928 11331993600 1876591600 18.638 96 14 28 0 1886441568 6362608 3487360
18:28:16 61673 8192000000 10849963024 11308572672 1796320336 17.984 92 31 62 0 1816463520 11675328 8467856
18:29:24 48137 8192000000 10840153088 11304865792 1812398416 18.116 94 20 40 0 1830920560 12880400 5641744
18:30:21 46626 8192000000 10840489888 11308462080 1861685392 18.517 97 18 36 0 1880571568 13209216 5676960
18:31:18 50260 8192000000 10883820096 11336937472 1911318336 18.917 99 14 28 2 1926836208 11824624 3693248
18:32:17 14809 8192000000 10873200528 11324805120 1930463632 19.071 99 28 56 0 1950117472 11909712 7744128
18:32:40 56175 8192000000 10851043552 11327086592 1872097904 18.601 96 25 50 1 1895947040 16838016 7011120
18:33:42 42519 8192000000 10871799152 11328679936 1915981504 18.955 99 27 53 0 1931588160 8811040 6795616
18:34:41 44534 8192000000 10901423408 11362316288 1960880656 19.313 100 25 50 4 1978968912 11145920 6942336
18:35:35 33772 8192000000 10906314736 11360493568 1935738896 19.113 98 23 45 1 1953723840 11959904 6025040
18:36:15 32380 8192000000 10876966592 11328745472 1902257776 18.844 97 30 61 3 1924649648 13895344 8496528
18:37:02 64871 8192000000 10882223360 11355914240 1910924528 18.914 98 15 30 1 1938474112 22680576 4869008
18:38:14 69773 8192000000 10871754912 11347726336 1901035712 18.835 98 18 36 0 1927314960 21791648 4487600
18:39:40 42288 8192000000 10892368080 11349864448 1910510496 18.911 98 19 38 3 1928293008 12564320 5218192
18:40:28 98631 8192000000 10848222736 11328581632 1865764816 18.550 96 10 20 1 1889532784 20577456 3190512
18:42:49 67760 8192000000 10874623776 11345575936 1901116064 18.835 98 25 48 1 1926482560 18756640 6609856
18:44:03 21673 8192000000 10858444784 11342905344 1920546432 18.991 99 11 22 0 1938790192 15321616 2922144
18:44:43 34423 8192000000 10828975664 11306864640 1883736624 18.695 97 14 26 1 1894121120 6643440 3741056
18:45:27 27735 8192000000 10848346736 11328131072 1930903056 19.074 100 4 8 0 1938436208 6765808 767344
18:46:01 50177 8192000000 10864659344 11336278016 1941639040 19.160 100 12 24 0 1955187136 10315248 3232848
18:46:58 59434 8192000000 10879006272 11351793664 1939542112 19.143 99 16 32 1 1955958592 12124368 4292112
18:48:03 89284 8192000000 10887818080 11359551488 1946546944 19.199 99 20 40 2 1965176960 11800208 6829808
18:50:13 38752 8192000000 10896193984 11377618944 1957809040 19.289 100 10 20 1 1974270400 13354288 3107072
18:51:10 52707 8192000000 10899610896 11379855360 1971590992 19.398 100 20 40 1 1985488064 7975936 5921136
18:52:09 69038 8192000000 10893303440 11365343232 1927129184 19.044 97 17 35 1 1940264608 8492912 4642512
18:53:26 29660 8192000000 10927534944 11382546432 1959190704 19.300 99 36 70 0 1976514352 6779328 10544320
18:54:05 70344 8192000000 10918023552 11394285568 1968371600 19.373 99 32 64 0 1991363840 14065728 8926512
18:55:34 60876 8192000000 10897454928 11375996928 1924617408 19.024 97 14 28 0 1943497776 14790448 4089920
18:56:41 56751 8192000000 10889298352 11372482560 1913063072 18.931 97 14 28 0 1928149792 11207584 3879136
18:58:36 87391 8192000000 10931523744 11397029888 1955838464 19.273 98 22 44 0 1970600848 8946960 5815424
19:00:10 55166 8192000000 10942734144 11406790656 1986932688 19.520 100 16 32 1 2001160288 10297392 3930208
19:01:11 96881 8192000000 10886303552 11351126016 1834186256 18.293 92 10 20 1 1859121968 22482624 2453088
19:02:54 107597 8192000000 10894008720 11377561600 1928951152 19.058 98 9 18 1 1953804032 22054448 2798432
19:04:53 76387 8192000000 10871606272 11355271168 1939609696 19.144 99 20 40 1 1954956080 9586320 5760064
19:06:17 44990 8192000000 10864921536 11336146944 1878331584 18.652 96 11 21 2 1887290080 6625040 2333456
19:07:08 83502 8192000000 10856323824 11337596928 1879246528 18.659 96 7 14 0 1888271792 7274400 1750864
19:08:38 31913 8192000000 10860373648 11346477056 1942201504 19.164 100 12 24 1 1954981120 9174256 3605360
19:09:16 25955 8192000000 10871746352 11352592384 1950094832 19.227 100 11 23 0 1963541600 10502304 2944464
19:09:49 73889 8192000000 10876789744 11347398656 1883577824 18.694 96 15 30 0 1899722096 11931680 4212592
19:11:32 89349 8192000000 10875788480 11339083776 1919345152 18.982 98 17 34 0 1932592016 7748672 5498192
19:13:10 71645 8192000000 10860048480 11346427904 1875651760 18.630 96 21 42 0 1894589568 12784592 6153216
19:14:27 56849 8192000000 10877037920 11336978432 1894364112 18.781 97 30 59 1 1911218784 8206624 8648048
19:15:32 56213 8192000000 10868323360 11339739136 1925290928 19.029 99 20 40 2 1938507184 8420576 4795680
19:16:37 31881 8192000000 10882420848 11345362944 1916446240 18.958 98 30 58 3 1931464128 7511872 7506016
19:17:29 30676 8192000000 10870097344 11342155776 1926566048 19.039 99 26 52 0 1944474912 10386896 7521968
19:18:07 49004 8192000000 10848916624 11320762368 1867042832 18.560 96 26 52 3 1884343600 10467952 6832816
19:19:04 23982 8192000000 10847638464 11298603008 1876895072 18.640 97 38 76 0 1895129984 7771104 10463808
19:19:39 54125 8192000000 10875070640 11345547264 1918026048 18.971 99 34 68 0 1937593456 11017504 8549904
19:20:41 46774 8192000000 10880370064 11346518016 1896052112 18.795 97 27 52 1 1918449504 15245552 7151840
19:22:12 36227 8192000000 10874092864 11332624384 1920707088 18.993 99 36 72 4 1944967232 13836560 10423584
19:22:55 37863 8192000000 10868940848 11338727424 1922071824 19.003 99 13 26 2 1934292080 8764800 3455456
19:23:46 73277 8192000000 10853734048 11308847104 1885284288 18.708 97 30 60 0 1901840832 8553104 8003440
19:25:08 15196 8192000000 10878999680 11321671680 1909026656 18.899 99 35 70 1 1927177056 8520048 9630352
19:25:30 9412 8192000000 10888848384 11332440064 1941022384 19.155 100 66 132 2 1969432384 9964128 18445872
19:25:49 21524 8192000000 10878736112 11324190720 1916947568 18.962 99 39 78 0 1938311968 10914784 10449616
19:26:35 62505 8192000000 10327899872 10741383168 1417636992 14.752 74 26 51 1 1437234768 12575024 7022752

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 23-12-2020 19:29:29 to 23-12-2020 19:29:58.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 164 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-12-2020 19:29:59 to 23-12-2020 19:30:01.

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          253343
MON$OLDEST_ACTIVE               254914
MON$OLDEST_SNAPSHOT             254914
MON$NEXT_TRANSACTION            254914
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                       2056992
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:275: 
:276: mscs-test-161.budzdorov.ru    Wed Dec 23 19:27:55 2020
:277:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:278: 
:279: 
:280: mscs-test-161.budzdorov.ru    Wed Dec 23 19:28:01 2020
:281:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:282: 
--- end of diff output ---

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

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