Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.01.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 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 17081780 kB
MemAvailable 31235664 kB
Buffers 0 kB
Cached 14573536 kB
SwapCached 4868 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-27 19:27:16
DTS_END                         2021-01-27 19:27:16.3090
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/56382
TRN_ID                          239138
ATT_ID                          662
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: 9468.11 23194 1136173
customer order: creation 169.58 352 20350
customer order: refuse 14.58 365 1749
order to supplier: creation 45.43 1283 5451
order to supplier: removal 3.43 112867 411
invoice (draft): creation 44.78 3358 5374
invoice (draft): removal 53.73 816 6448
invoice accept: apply 41.58 19158 4989
invoice accept: cancel 48.57 812 5828
customer reserve: creation 3942.57 184 473108
customer reserve: removal 4816.11 63 577933
realization accept: apply 84.03 177 10084
realization accept: cancel 73.54 123 8825
payment from customer: creation 59.29 123 7115
payment from customer: removal 5.88 87 706
payment to supplier: creation 49.03 130 5883
payment to supplier: removal 3.59 66 431
service: total inventory turnovers 4.78 1213 573
service: total monetary turnovers 6.79 83 815
service: aggregate perf. data 0.80 23645 96
service: refresh index statistics 0.03 298982 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-01-2021 19:28:05 to 27-01-2021 19:28:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2358
TEST_TIME 2 3573
TEST_TIME 3 4245
TEST_TIME 4 4430
TEST_TIME 5 5064
TEST_TIME 6 5288
TEST_TIME 7 5423
TEST_TIME 8 5307
TEST_TIME 9 5335
TEST_TIME 10 5715
TEST_TIME 11 5711
TEST_TIME 12 5989
TEST_TIME 13 6600
TEST_TIME 14 6892
TEST_TIME 15 6912
TEST_TIME 16 7352
TEST_TIME 17 7580
TEST_TIME 18 7669
TEST_TIME 19 7966
TEST_TIME 20 7901
TEST_TIME 21 8377
TEST_TIME 22 8700
TEST_TIME 23 8956
TEST_TIME 24 8843
TEST_TIME 25 9467
TEST_TIME 26 9502
TEST_TIME 27 10158
TEST_TIME 28 10812
TEST_TIME 29 10559
TEST_TIME 30 11794
TEST_TIME 31 11573
TEST_TIME 32 11224
TEST_TIME 33 11127
TEST_TIME 34 11072
TEST_TIME 35 10940
TEST_TIME 36 10878
TEST_TIME 37 10671
TEST_TIME 38 10682
TEST_TIME 39 10502
TEST_TIME 40 10400
TEST_TIME 41 10329
TEST_TIME 42 10242
TEST_TIME 43 10140
TEST_TIME 44 10202
TEST_TIME 45 10000
TEST_TIME 46 9931
TEST_TIME 47 10195
TEST_TIME 48 10098
TEST_TIME 49 10035
TEST_TIME 50 9940
TEST_TIME 51 9840
TEST_TIME 52 9847
TEST_TIME 53 9794
TEST_TIME 54 9686
TEST_TIME 55 9537
TEST_TIME 56 9550
TEST_TIME 57 9528
TEST_TIME 58 9453
TEST_TIME 59 9385
TEST_TIME 60 9367
TEST_TIME 61 9328
TEST_TIME 62 9455
TEST_TIME 63 9408
TEST_TIME 64 9464
TEST_TIME 65 9512
TEST_TIME 66 9506
TEST_TIME 67 9503
TEST_TIME 68 9527
TEST_TIME 69 9553
TEST_TIME 70 9502
TEST_TIME 71 9683
TEST_TIME 72 9692
TEST_TIME 73 9656
TEST_TIME 74 9696
TEST_TIME 75 9668
TEST_TIME 76 9606
TEST_TIME 77 9588
TEST_TIME 78 9561
TEST_TIME 79 9579
TEST_TIME 80 9522
TEST_TIME 81 9446
TEST_TIME 82 9388
TEST_TIME 83 9375
TEST_TIME 84 9383
TEST_TIME 85 9413
TEST_TIME 86 9400
TEST_TIME 87 9375
TEST_TIME 88 9387
TEST_TIME 89 9379
TEST_TIME 90 9428
TEST_TIME 91 9529
TEST_TIME 92 9489
TEST_TIME 93 9527
TEST_TIME 94 9577
TEST_TIME 95 9610
TEST_TIME 96 9576
TEST_TIME 97 9583
TEST_TIME 98 9612
TEST_TIME 99 9571
TEST_TIME 100 9608
TEST_TIME 101 9524
TEST_TIME 102 9474
TEST_TIME 103 9475
TEST_TIME 104 9484
TEST_TIME 105 9409
TEST_TIME 106 9394
TEST_TIME 107 9435
TEST_TIME 108 9437
TEST_TIME 109 9405
TEST_TIME 110 9378
TEST_TIME 111 9439
TEST_TIME 112 9413
TEST_TIME 113 9419
TEST_TIME 114 9451
TEST_TIME 115 9469
TEST_TIME 116 9458
TEST_TIME 117 9479
TEST_TIME 118 9457
TEST_TIME 119 9531
TEST_TIME 120 9468

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-01-2021 19:28:09 to 27-01-2021 19:28:12.

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 1571445 1571445 0 0.00 0 16350 6 0 0
doc_list_biud 1571445 1571445 0 0.00 0 38470 29 0 0
sp_add_invoice_to_stock 5146 4989 157 3.05 35 169292 19158 0 157
sp_cancel_adding_invoice 5828 5828 0 0.00 3 61552 812 0 0
sp_cancel_client_order 1749 1749 0 0.00 4 14324 366 0 0
sp_cancel_customer_reserve 577933 577933 0 0.00 1 38472 63 0 0
sp_cancel_pay_from_customer 706 706 0 0.00 3 4243 88 0 0
sp_cancel_pay_to_supplier 431 431 0 0.00 2 3622 66 0 0
sp_cancel_supplier_invoice 6459 6448 11 0.17 1 35967 816 0 11
sp_cancel_supplier_order 411 411 0 0.00 10 1135425 112868 0 0
sp_cancel_write_off 8825 8825 0 0.00 1 8629 124 0 0
sp_client_order 20350 20350 0 0.00 4 30497 352 0 0
sp_customer_reserve 473108 473108 0 0.00 0 73816 184 0 0
sp_fill_shopping_cart 31163 31163 0 0.00 1 18635 39 0 0
sp_fill_shopping_cart_clo_res 473108 473108 0 0.00 0 24752 13 0 0
sp_get_clo_for_invoice 4989 4989 0 0.00 0 25845 318 0 0
sp_kill_cost_storno 15790 15790 0 0.00 0 7965 63 0 0
sp_kill_qstorno_ret_qs2qd 1171550 1171550 0 0.00 0 38468 34 0 0
sp_kill_qty_storno 616267 616267 0 0.00 0 38470 73 0 0
sp_lock_selected_doc 20845 20845 0 0.00 0 9180 5 0 0
sp_make_cost_storno 28071 28071 0 0.00 0 16347 53 0 0
sp_multiply_rows_for_pdistr 28071 28071 0 0.00 0 8928 30 0 0
sp_multiply_rows_for_qdistr 20350 20350 0 0.00 0 30490 157 0 0
sp_pay_from_customer 7115 7115 0 0.00 4 22197 124 0 0
sp_pay_to_supplier 5883 5883 0 0.00 5 13016 130 0 0
sp_payment_common 12998 12998 0 0.00 1 15709 32 0 0
sp_qd_handle_on_cancel_clo 1749 1749 0 0.00 0 12114 324 0 0
sp_qd_handle_on_invoice_upd_sts 10817 10817 0 0.00 0 26216 379 0 0
sp_qd_handle_on_reserve_upd_sts 10084 10084 0 0.00 0 11719 59 0 0
sp_reserve_write_off 10084 10084 0 0.00 6 16358 178 0 0
sp_supplier_invoice 5374 5374 0 0.00 6 67400 3359 0 0
sp_supplier_order 5451 5451 0 0.00 5 45301 1284 0 0
srv_aggregate_perf_data 96 96 0 0.00 3189 193055 23645 0 0
srv_fill_mon_cache_memory 170 170 0 0.00 903 136767 30787 0 0
srv_find_qd_qs_mism 1086794 1086794 0 0.00 0 14297 5 0 0
srv_make_invnt_saldo 573 573 0 0.00 24 106054 1213 0 0
srv_make_money_saldo 815 815 0 0.00 1 26333 84 0 0
srv_recalc_idx_stat 4 4 0 0.00 243546 420728 298983 0 0
t$perf-abend:sp_add_invoice_to_stock 157 157 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4989 4989 0 0.00 0 9498 185 0 0
t$perf-norm:sp_cancel_adding_invoice 391 391 0 0.00 0 3329 100 0 0
t$perf-norm:sp_cancel_client_order 1749 1749 0 0.00 0 3736 14 0 0
t$perf-norm:sp_cancel_customer_reserve 695 695 0 0.00 0 2041 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 706 706 0 0.00 0 252 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 431 431 0 0.00 0 569 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 391 391 0 0.00 0 1630 16 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 27829 1953 0 0
t$perf-norm:sp_cancel_write_off 998 998 0 0.00 0 2074 9 0 0
t$perf-norm:sp_client_order 20350 20350 0 0.00 0 12459 21 0 0
t$perf-norm:sp_customer_reserve 1054 1054 0 0.00 0 2388 10 0 0
t$perf-norm:sp_pay_from_customer 7115 7115 0 0.00 0 8109 17 0 0
t$perf-norm:sp_pay_to_supplier 5883 5883 0 0.00 0 10747 14 0 0
t$perf-norm:sp_reserve_write_off 10084 10084 0 0.00 0 7688 11 0 0
t$perf-norm:sp_supplier_invoice 5374 5374 0 0.00 0 8520 21 0 0
t$perf-norm:sp_supplier_order 5451 5451 0 0.00 0 15375 17 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 535 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 170 170 0 0.00 0 514 10 0 0
t$perf-norm:srv_make_invnt_saldo 573 573 0 0.00 0 1579 28 0 0
t$perf-norm:srv_make_money_saldo 815 815 0 0.00 0 5297 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 4 0 0
v_add_invoice_to_stock 10292 9978 314 3.05 0 9283 25 0 314
v_all_customers 36804 36804 0 0.00 0 20 1 0 0
v_all_suppliers 30302 30302 0 0.00 0 23 1 0 0
v_all_wares 40700 40700 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 782 782 0 0.00 0 1868 8 0 0
v_cancel_client_order 3498 3498 0 0.00 0 3305 8 0 0
v_cancel_customer_prepayment 1412 1412 0 0.00 0 4228 9 0 0
v_cancel_customer_reserve 1390 1390 0 0.00 0 1860 5 0 0
v_cancel_payment_to_supplier 862 862 0 0.00 0 694 4 0 0
v_cancel_supplier_invoice 804 782 22 2.73 0 2232 25 0 22
v_cancel_supplier_order 822 822 0 0.00 0 2299 8 0 0
v_cancel_write_off 1996 1996 0 0.00 0 2287 16 0 0
v_max_id_clo_ord 5451 5451 0 0.00 0 7728 3 0 0
v_max_id_clo_res 1054 1054 0 0.00 0 1595 12 0 0
v_max_id_ord_sup 5361 5361 0 0.00 0 1866 2 0 0
v_max_non_paid_invoice 1544 1544 0 0.00 0 8317 10 0 0
v_max_non_paid_realizn 3978 3978 0 0.00 0 3377 5 0 0
v_min_id_clo_ord 5451 5451 0 0.00 0 3376 8 0 0
v_min_id_clo_res 1054 1054 0 0.00 0 5571 11 0 0
v_min_id_ord_sup 5361 5361 0 0.00 0 2529 4 0 0
v_min_non_paid_invoice 5883 5883 0 0.00 0 6693 14 0 0
v_min_non_paid_realizn 7115 7115 0 0.00 0 7920 21 0 0
v_our_firm 10170 10170 0 0.00 0 12 1 0 0
v_reserve_write_off 20168 20168 0 0.00 0 4963 6 0 0
x_lock_depdocs_on_canc_invoice 11885 11885 0 0.00 0 18948 121 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 8319 381 0 0
x_make_qstorno_1000_1200 5451 5451 0 0.00 1 45282 1198 0 0
x_make_qstorno_1200_2000 5374 5374 0 0.00 3 65540 3219 0 0
x_make_qstorno_2100_3300 473108 473108 0 0.00 0 73813 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-01-2021 19:28:13 to 27-01-2021 19:28:17.

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:20 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:26 11960 8192000000 10201242272 10500993024 868209504 9.582 70 52 104 0 887599168 2309728 17079936
16:57:48 30880 8192000000 10341306608 10657353728 1375213440 14.374 100 81 162 0 1406149024 4455408 26480176
16:58:32 18743 8192000000 10375074592 10699763712 1427755008 14.841 100 82 164 0 1460346992 6286928 26305056
16:59:06 12194 8192000000 10393137536 10724593664 1454920496 15.081 100 82 164 0 1489138992 7265440 26953056
16:59:31 16435 8192000000 10432826992 10767142912 1485085744 15.346 100 89 178 0 1522017120 7875024 29056352
17:00:01 12332 8192000000 10451823472 10787123200 1511551328 15.577 100 92 184 1 1549726048 8982960 29191760
17:00:23 20389 8192000000 10464534912 10805243904 1519599360 15.647 100 87 174 0 1556272688 9312720 27360608
17:00:53 14728 8192000000 10488038880 10830807040 1536410848 15.793 100 83 166 0 1571892032 9601120 25880064
17:01:15 10370 8192000000 10497413584 10841444352 1552754048 15.934 100 83 166 0 1588482352 10224320 25503984
17:01:34 20322 8192000000 10526626128 10875207680 1574085472 16.117 100 81 162 1 1609198656 10267776 24845408
17:02:07 14038 8192000000 10545089440 10901544960 1604755072 16.380 100 78 156 2 1643257440 15232752 23269616
17:02:32 16449 8192000000 10565762608 10923270144 1625696912 16.558 100 78 156 1 1660164128 10928480 23538736
17:03:04 14027 8192000000 10600664288 10962587648 1655546896 16.811 100 76 152 1 1689600544 11391168 22662480
17:03:27 13366 8192000000 10610568096 10976432128 1673547760 16.963 100 84 168 0 1711153328 12340368 25265200
17:03:52 11415 8192000000 10625515152 10993201152 1683802224 17.049 100 83 166 1 1720525664 12175728 24547712
17:04:13 9299 8192000000 10632881728 11003633664 1699209888 17.178 100 83 166 0 1736544320 12986672 24347760
17:04:31 6716 8192000000 10648173936 11021131776 1707766928 17.250 100 73 144 0 1741058944 12776032 20515984
17:04:45 6623 8192000000 10659137344 11032535040 1721988080 17.369 100 81 162 2 1757441872 12539984 22913808
17:04:58 6739 8192000000 10674696656 11053842432 1738310992 17.505 100 79 159 0 1773021040 12310880 22399168
17:05:12 5654 8192000000 10694154496 11068190720 1750300320 17.604 100 76 151 1 1784304784 12872368 21132096
17:05:25 5023 8192000000 10691356560 11072471040 1761173024 17.694 100 83 166 1 1797173696 12687168 23313504
17:05:39 4643 8192000000 10708423344 11086188544 1769627264 17.764 100 85 170 0 1806757488 13093728 24036496
17:05:52 3998 8192000000 10721320896 11102101504 1779209456 17.843 100 83 165 0 1816940336 15009664 22721216
17:06:04 3450 8192000000 10727557680 11107946496 1788389184 17.919 100 85 169 3 1825178128 13762464 23026480
17:06:13 3444 8192000000 10737550864 11119722496 1792993856 17.956 100 90 180 2 1837537152 19752592 24790704
17:06:24 5397 8192000000 10736182816 11121070080 1800796480 18.020 100 87 174 0 1840136064 14619312 24720272
17:06:36 5833 8192000000 10737635456 11125006336 1800055872 18.014 100 77 152 1 1835034160 13776048 21202240
17:06:49 5032 8192000000 10754778768 11144122368 1811384544 18.107 100 81 158 1 1847301872 13856896 22060432
17:07:01 1606 8192000000 10762327488 11156070400 1827586496 18.240 100 80 161 2 1863053024 13058096 22408432
17:07:09 2055 8192000000 10778774400 11165200384 1840046192 18.341 100 82 164 2 1875728992 12574928 23107872
17:07:18 1240 8192000000 10783500464 11170254848 1841126528 18.350 100 92 184 0 1879965936 13049440 25789968
17:07:26 2560 8192000000 10786556240 11171065856 1844904944 18.381 100 89 178 1 1881522928 12372832 24245152
17:07:34 1572 8192000000 10788422464 11178049536 1846848208 18.397 100 84 165 0 1882437104 12985520 22603376
17:07:43 2709 8192000000 10786482592 11174567936 1848937488 18.413 100 86 172 1 1886611200 13252976 24420736
17:07:52 3392 8192000000 10795409216 11185577984 1857632448 18.484 100 92 187 3 1897034864 14051056 25351360
17:08:02 2158 8192000000 10803803360 11189395456 1853309392 18.449 100 83 164 1 1892094080 15029696 23754992
17:08:11 1839 8192000000 10805836992 11192508416 1858006368 18.487 100 88 175 1 1896266736 13822096 24438272
17:08:20 1166 8192000000 10802290416 11190894592 1861457136 18.515 100 88 175 0 1898053200 12007824 24588240
17:08:27 2103 8192000000 10808896464 11197505536 1870039360 18.585 100 93 184 2 1909396064 12838464 26518240
17:08:36 1355 8192000000 10816572336 11205013504 1870938848 18.592 100 88 175 0 1909159712 13265536 24955328
17:08:43 1619 8192000000 10819210336 11209355264 1872632160 18.606 100 86 172 0 1911214256 13016880 25565216
17:08:51 31748 8192000000 10786605824 11197898752 1865297344 18.546 100 43 86 0 1886223856 8609872 12316640
17:09:30 14227 8192000000 10811138224 11206086656 1873352576 18.611 100 83 166 2 1904727936 6866048 24509312
17:09:50 2096 8192000000 10819301888 11221319680 1880768784 18.671 100 84 168 1 1915482736 9778224 24935728
17:09:59 7182 8192000000 10796303616 11213275136 1874224288 18.618 100 48 96 0 1897133552 9724800 13184464
17:10:16 3055 8192000000 10788001680 11211104256 1874839696 18.623 100 42 83 2 1894747824 8768096 11140032
17:10:28 3010 8192000000 10808385984 11221934080 1881763024 18.679 100 52 106 0 1904568224 8112544 14692656
17:10:40 3745 8192000000 10807159616 11219841024 1883756560 18.695 100 54 109 2 1906810592 8367472 14686560
17:10:51 6019 8192000000 10798163824 11224240128 1880801344 18.672 100 28 56 1 1896203360 7891296 7510720
17:11:04 4562 8192000000 10801940080 11222716416 1882431232 18.685 100 36 72 1 1899707312 6624208 10651872
17:11:17 6090 8192000000 10792218528 11222728704 1883849248 18.696 100 30 58 3 1897509056 5670464 7989344
17:11:30 12298 8192000000 10797919456 11227705344 1887333216 18.724 100 25 48 1 1900061248 5944400 6783632
17:11:49 12491 8192000000 10807831040 11234140160 1890355824 18.749 100 26 48 1 1903722096 6213424 7152848
17:12:09 4154 8192000000 10805967056 11236413440 1893810160 18.776 100 37 73 1 1919783792 16031888 9941744
17:12:19 12720 8192000000 10800015680 11232010240 1892552656 18.766 100 22 42 0 1904380624 5451408 6376560
17:12:38 8506 8192000000 10803738672 11234586624 1891926464 18.761 100 19 38 1 1903535040 6814000 4794576
17:12:54 14944 8192000000 10803443472 11237089280 1898224960 18.812 100 20 40 1 1909780016 5869424 5685632
17:13:17 8769 8192000000 10804768256 11238350848 1895507440 18.790 100 16 31 1 1905567232 5556688 4503104
17:13:32 8821 8192000000 10821396736 11244138496 1902434816 18.846 100 34 69 1 1917607952 5656752 9516384
17:13:48 54209 8192000000 10831371552 11254624256 1904767776 18.865 100 38 77 2 1921922784 5814112 11340896
17:15:12 2648 8192000000 10843501520 11265617920 1913817184 18.937 100 66 132 0 1943284672 10166944 19300544
17:15:23 7150 8192000000 10830160384 11258019840 1908201872 18.892 100 33 66 0 1924144384 6868368 9074144
17:15:38 4888 8192000000 10827830704 11256188928 1909162224 18.900 100 37 74 2 1926029024 6101376 10765424
17:15:51 5794 8192000000 10824342240 11257749504 1908329712 18.893 100 26 52 2 1921833744 5962656 7541376
17:16:04 8730 8192000000 10818123312 11241570304 1893875312 18.777 99 32 63 3 1909507552 6154400 9477840
17:16:20 5394 8192000000 10816595584 11250507776 1892940464 18.769 99 33 66 3 1908613648 6694784 8978400
17:16:32 4625 8192000000 10827821168 11256573952 1908635536 18.896 100 24 48 1 1921276688 6160544 6480608
17:16:44 6685 8192000000 10815015488 11248873472 1889237792 18.740 99 28 56 2 1903696576 5939120 8519664
17:17:00 12125 8192000000 10789195712 11220602880 1827841344 18.242 96 19 38 2 1838456048 5221392 5393312
17:17:19 6634 8192000000 10787151760 11222011904 1866103216 18.553 99 20 41 2 1877666192 5547536 6015440
17:17:32 43011 8192000000 10789257456 11213115392 1807801568 18.078 96 29 58 2 1821803312 5628896 8372848
17:18:26 18310 8192000000 10755562048 11195162624 1801569488 18.027 96 31 63 0 1816393696 5055072 9769136
17:18:53 4666 8192000000 10780429872 11193909248 1849587568 18.419 100 38 78 1 1867925904 5406240 12932096
17:19:04 7423 8192000000 10735801088 11151224832 1790255424 17.934 97 36 72 3 1806927152 6483968 10187760
17:19:19 4632 8192000000 10743381392 11163828224 1827630880 18.240 100 29 58 2 1840955952 5743760 7581312
17:19:32 5534 8192000000 10710349680 11114127360 1722579152 17.374 95 39 78 1 1740506320 6062720 11864448
17:19:44 6014 8192000000 10702777312 11115032576 1743115584 17.544 97 25 50 0 1756307872 5901776 7290512
17:19:56 4510 8192000000 10706946608 11120156672 1783350640 17.877 99 33 66 1 1799041824 6299952 9391232
17:20:08 8809 8192000000 10685732144 11088257024 1659369728 16.844 92 21 42 2 1670542256 4647440 6525088
17:20:25 8708 8192000000 10711579536 11128627200 1761552384 17.697 98 27 54 1 1775668416 6200992 7915040
17:20:40 6414 8192000000 10732173968 11153399808 1806220064 18.065 100 18 36 2 1816890736 5298272 5372400
17:20:54 8348 8192000000 10703883360 11131203584 1785985168 17.899 99 10 20 0 1793977616 5427472 2564976
17:21:09 5353 8192000000 10719292464 11138961408 1804793680 18.053 100 21 42 1 1816280544 5170432 6316432
17:21:20 7264 8192000000 10684133664 11104858112 1764408480 17.721 98 23 45 1 1777207776 5602048 7197248
17:21:35 12626 8192000000 10732118864 11152281600 1775966752 17.816 98 21 42 0 1786959008 5284160 5708096
17:21:53 64813 8192000000 10719198960 11145195520 1754157696 17.636 96 29 58 2 1767865152 5048352 8659104
17:23:04 10954 8192000000 10750118624 11162918912 1808428720 18.083 99 26 52 1 1829526608 13728496 7369392
17:23:25 8522 8192000000 10762634288 11177320448 1840212240 18.343 100 31 60 1 1855654608 6954240 8488128
17:23:41 11861 8192000000 10751828128 11176747008 1824897344 18.218 99 31 62 1 1839800272 6115008 8787920
17:23:59 8411 8192000000 10750035200 11179945984 1845775520 18.388 100 28 55 2 1860494192 6292256 8426416
17:24:18 7003 8192000000 10752724496 11183300608 1847906848 18.405 100 20 40 1 1859229920 5752128 5570944
17:24:34 7138 8192000000 10774953232 11190108160 1847758976 18.404 100 19 38 0 1858880432 6026592 5094864
17:24:48 12026 8192000000 10765634432 11190915072 1850647968 18.427 100 21 42 2 1862658640 5306080 6704592
17:25:08 12063 8192000000 10768386864 11196334080 1860701680 18.509 100 27 53 3 1873471344 4941328 7828336
17:25:26 9556 8192000000 10768822000 11201531904 1861655152 18.517 100 20 39 1 1873232992 5674448 5903392
17:25:41 12895 8192000000 10778986512 11210911744 1869290736 18.579 100 26 52 0 1885835584 9911856 6632992
17:26:03 6966 8192000000 10777998160 11211505664 1867385216 18.563 100 15 29 1 1877420064 6253584 3781264
17:26:16 11282 8192000000 10782545296 11212574720 1867588080 18.565 100 16 31 1 1878104048 5834400 4681568
17:26:34 15630 8192000000 10805037168 11217002496 1874638368 18.622 100 22 45 2 1886206272 5090128 6477776
17:26:57 78438 8192000000 10824850800 11240161280 1886190640 18.715 100 31 62 0 1900019392 4890928 8937824
17:28:24 31127 8192000000 10851662336 11267493888 1915276352 18.949 100 47 93 0 1935751296 7686432 12788512
17:29:13 15363 8192000000 10848579904 11270443008 1922314608 19.005 100 47 92 1 1944367760 9161648 12891504
17:29:34 5935 8192000000 10862505472 11282345984 1929959120 19.067 100 53 106 1 1954498528 9526000 15013408
17:29:48 4284 8192000000 10866520032 11283374080 1937056512 19.123 100 65 130 1 1964434672 9658960 17719200
17:30:00 11071 8192000000 10871382416 11291815936 1934371888 19.102 100 50 100 0 1959311328 10588528 14350912
17:30:18 17481 8192000000 10870507296 11294482432 1937711808 19.128 100 48 96 0 1961683056 10585696 13385552
17:30:44 39243 8192000000 10859640688 11298004992 1939592704 19.144 100 31 62 2 1956703536 8524384 8586448
17:31:30 32333 8192000000 10879014304 11310190592 1948050704 19.211 100 38 75 1 1969268080 9858640 11358736
17:32:10 32099 8192000000 10881994496 11320926208 1956086304 19.275 100 38 75 3 1977847872 10175536 11586032
17:32:56 29741 8192000000 10905603104 11338608640 1965447696 19.349 100 38 77 3 1988465696 11387648 11630352
17:33:34 15931 8192000000 10925855440 11350179840 1974202976 19.419 100 46 90 2 2000448720 13295376 12950368
17:34:04 18416 8192000000 10921425072 11350835200 1980469888 19.468 100 51 102 0 2009870416 14783968 14616560
17:34:41 9154 8192000000 10939263808 11364438016 1987766592 19.526 100 53 106 1 2025134496 22143200 15224704
17:34:57 10988 8192000000 10936177648 11370409984 1991204256 19.553 100 50 101 1 2027044640 21284640 14555744
17:35:23 6372 8192000000 10937724096 11369820160 1993265088 19.570 100 41 81 4 2021523760 16486992 11771680
17:35:41 3581 8192000000 10955806464 11376422912 2000836528 19.629 100 63 124 2 2037057584 17025088 19195968
17:35:52 13043 8192000000 10950635136 11381952512 2001826032 19.637 100 61 121 1 2040679280 21207488 17645760
17:36:21 6447 8192000000 10942048064 11376955392 1998841584 19.614 100 56 112 1 2038173552 22495856 16836112
17:36:35 7263 8192000000 10960712064 11384799232 2002894720 19.646 100 65 130 1 2045649424 24113648 18641056
17:36:53 6895 8192000000 10954225792 11386118144 2004678528 19.660 100 57 114 0 2044786608 23392144 16715936
17:37:08 12351 8192000000 10960023936 11393114112 2009038080 19.694 100 52 103 2 2046542704 21848336 15656288
17:37:27 5603 8192000000 10970827328 11400089600 2017455088 19.760 100 65 130 1 2061127376 24020096 19652192
17:37:41 6491 8192000000 10936921296 11358482432 1943231536 19.173 97 62 124 0 1984379376 22544336 18603504
17:37:57 3989 8192000000 10949799760 11369553920 1990098896 19.545 100 66 131 2 2033431888 23809424 19523568
17:38:08 10665 8192000000 10957731072 11376410624 1993707360 19.573 100 65 130 0 2037564032 24371360 19485312
17:38:30 4784 8192000000 10948484176 11373772800 1989598720 19.541 100 74 147 0 2037508720 25390432 22519568
17:38:43 2417 8192000000 10950219328 11366465536 1977412784 19.444 99 75 150 0 2025595200 25059728 23122688
17:38:53 4624 8192000000 10941335952 11364466688 1986239456 19.514 100 65 130 0 2032781040 26187328 20354256
17:39:10 5822 8192000000 10944025200 11369693184 1985277680 19.506 100 62 124 4 2031310416 27317552 18715184
17:39:24 1679 8192000000 10978403456 11388858368 2003684016 19.652 100 93 183 2 2059826416 28564624 27577776
17:39:32 3144 8192000000 10973607872 11388530688 1996706976 19.597 100 85 168 0 2053529824 30924080 25898768
17:39:43 8822 8192000000 10955103328 11378245632 1989958208 19.543 100 78 156 2 2044968624 31754960 23255456
17:39:58 4968 8192000000 10974458192 11394576384 2003089696 19.647 100 80 158 1 2059963200 32781520 24091984
17:40:14 3844 8192000000 10964243440 11390607360 1992816256 19.566 100 70 140 2 2046215712 32526880 20872576
17:40:25 2150 8192000000 10966780928 11390406656 1996523840 19.595 100 76 153 1 2050966672 31686192 22756640
17:40:38 9386 8192000000 10965889744 11398959104 2004719440 19.660 100 65 130 0 2053500128 29083232 19697456
17:41:01 8928 8192000000 10962224448 11394195456 1999226272 19.617 100 54 107 0 2045544112 30014224 16303616
17:41:17 9646 8192000000 10956348032 11385606144 1988574048 19.533 99 62 122 0 2037042544 30476048 17992448
17:41:35 2782 8192000000 10975224864 11395010560 1998553712 19.611 100 87 173 0 2055885376 31998144 25333520
17:41:47 1898 8192000000 10965469456 11375955968 1958182816 19.292 98 84 163 0 2014298368 31430992 24684560
17:41:56 4583 8192000000 10962077792 11373432832 1980727808 19.470 100 79 155 1 2036034080 32545056 22761216
17:42:10 2345 8192000000 10953136224 11373559808 1977667312 19.446 100 73 146 1 2032945920 33566864 21711744
17:42:20 3978 8192000000 10953362336 11379281920 1979512752 19.461 100 65 130 1 2037140128 37996448 19630928
17:42:34 5748 8192000000 10962587728 11385372672 1988573520 19.533 100 83 166 0 2051649648 38426752 24649376
17:42:49 2512 8192000000 10981071392 11392647168 1996779168 19.597 100 88 174 2 2063647248 40720512 26147568
17:42:58 2530 8192000000 10981179888 11393736704 1984812928 19.503 99 90 179 2 2053457584 41900240 26744416
17:43:10 4245 8192000000 10969408368 11387146240 1974561712 19.422 99 81 162 1 2041371104 41949312 24860080
17:43:26 903 8192000000 10981789472 11391811584 1988782992 19.534 100 85 168 3 2056671456 41847280 26041184
17:43:34 2727 8192000000 10985159328 11398459392 1997603104 19.604 100 85 167 1 2065153584 42936304 24614176
17:43:43 1365 8192000000 10984234240 11394269184 1987468528 19.524 100 89 178 1 2059222176 44796768 26956880
17:43:52 2270 8192000000 10993281328 11401064448 1999804592 19.621 100 89 179 1 2068183040 42479296 25899152
17:44:01 3086 8192000000 10985429184 11398758400 2000394320 19.626 100 86 171 1 2068570032 42722416 25453296
17:44:11 1996 8192000000 10970853328 11385229312 1989410480 19.539 100 85 170 1 2058573600 43128512 26034608
17:44:21 1553 8192000000 10979792784 11386527744 1984079680 19.497 100 90 179 2 2056923840 44830416 28013744
17:44:33 3813 8192000000 10972644256 11387850752 1985889600 19.511 100 77 152 0 2054659072 44385920 24383552
17:44:43 1943 8192000000 10955715056 11358089216 1956650656 19.279 99 90 179 0 2029261264 46152240 26458368
17:44:53 2567 8192000000 10968844992 11381895168 1981467840 19.476 100 89 180 0 2054716624 46329552 26919232
17:45:03 3463 8192000000 10958932624 11374133248 1961731792 19.320 99 82 163 1 2038595056 51934896 24928368
17:45:13 5105 8192000000 10961790448 11381923840 1961814896 19.320 99 77 154 1 2033729584 47589568 24325120
17:45:29 1492 8192000000 10979469424 11384721408 1978872176 19.456 100 84 168 1 2054015920 49508336 25635408
17:45:38 3833 8192000000 10985741920 11391569920 1982685744 19.486 100 91 180 2 2060546512 50573856 27286912
17:45:51 2455 8192000000 10967809600 11378167808 1963503632 19.334 99 92 184 1 2045086240 52637584 28945024
17:46:03 4132 8192000000 10982582160 11395043328 1982344960 19.483 100 87 174 2 2065565760 56521312 26699488
17:46:15 3545 8192000000 10988178672 11401715712 1989466720 19.540 100 82 163 2 2071518864 56994752 25057392
17:46:26 4945 8192000000 10982573760 11400937472 1984621200 19.501 100 82 162 2 2068607184 57862464 26123520
17:46:41 1365 8192000000 10996495168 11402772480 1989844192 19.543 100 95 189 0 2073719856 55076592 28799072
17:46:50 4278 8192000000 10988414752 11398021120 1983389040 19.492 100 82 160 3 2063868912 55801008 24678864
17:47:02 6926 8192000000 10972096624 11377745920 1963731264 19.336 99 81 161 0 2045119904 56283776 25104864
17:47:18 5321 8192000000 10972641888 11382960128 1963944560 19.337 99 85 167 1 2047750016 56522368 27283088
17:47:32 2533 8192000000 10967535536 11383246848 1968238672 19.371 100 75 151 1 2050106368 57518272 24349424
17:47:41 2993 8192000000 10958268912 11368386560 1943439024 19.174 99 77 153 1 2026115088 58262176 24413888
17:47:51 6324 8192000000 10962697936 11377823744 1956282864 19.276 100 80 159 0 2042703488 60014144 26406480
17:48:04 3327 8192000000 10977249264 11387121664 1968235888 19.371 100 87 174 1 2060302992 62317392 29749712
17:48:15 1884 8192000000 10983590080 11389452288 1966185280 19.355 100 82 165 1 2056034800 62315792 27533728
17:48:26 4979 8192000000 10970200320 11394564096 1970726064 19.391 100 68 135 3 2054459056 61834768 21898224
17:48:51 8775 8192000000 10970518192 11407564800 1977741552 19.447 100 46 92 4 2058977280 65723744 15511984
17:49:07 2570 8192000000 10937856672 11352711168 1924042368 19.019 98 69 138 2 2009518752 63199264 22277120
17:49:19 4697 8192000000 10960626336 11379130368 1952114224 19.243 100 72 144 1 2041141936 65887408 23140304
17:49:32 3366 8192000000 10943545456 11367198720 1942045344 19.163 99 68 137 1 2029253968 64300624 22908000
17:49:43 9502 8192000000 10931543712 11363287040 1943096496 19.171 100 45 89 2 2017334272 59030192 15207584
17:50:02 4915 8192000000 10967083312 11376824320 1954917408 19.266 100 74 148 1 2036273984 57434288 23922288
17:50:15 2160 8192000000 10991249856 11399974912 1972557040 19.406 100 82 165 0 2058114704 59853296 25704368
17:50:28 1876 8192000000 10977073744 11391328256 1968091968 19.370 100 82 164 2 2057716944 62564224 27060752
17:50:39 2359 8192000000 10988781280 11401891840 1984492976 19.500 100 87 176 1 2070960272 58945904 27521392
17:50:50 5558 8192000000 10969071168 11404271616 1977519008 19.445 100 48 96 1 2052762640 59174816 16068816
17:51:17 13623 8192000000 10967163424 11396448256 1956648224 19.279 99 45 91 0 2031148544 58795920 15704400
17:51:39 13602 8192000000 10968128416 11407753216 1973545744 19.414 100 48 96 1 2056215856 65918192 16751920
17:52:16 14100 8192000000 10939910432 11382636544 1940837552 19.153 99 42 84 1 2015125536 59807632 14480352
17:52:51 15484 8192000000 10950397920 11396460544 1963772032 19.336 100 32 64 1 2030176416 55192368 11212016
17:53:22 17848 8192000000 10955036576 11397013504 1962201568 19.324 100 36 72 2 2035878272 60852096 12824608
17:53:49 15790 8192000000 10940121584 11398103040 1957340992 19.285 100 27 54 2 2029471200 62207488 9922720
17:54:20 3516 8192000000 10936250608 11400466432 1952715520 19.248 100 24 48 2 2019781392 57422704 9643168
17:54:30 21882 8192000000 10940398672 11397046272 1952412656 19.246 100 27 54 0 2018844768 56711856 9720256
17:55:03 22220 8192000000 10958802224 11406512128 1965473312 19.350 100 30 61 1 2034507456 58903632 10130512
17:56:10 38384 8192000000 10924320032 11387428864 1948225504 19.212 100 15 30 1 2002394768 48656480 5512784
17:56:55 26356 8192000000 10935329888 11393802240 1949162848 19.220 100 19 38 0 2015972400 59871680 6937872
17:58:37 105345 8192000000 10876833920 11328499712 1910286016 18.909 98 41 77 2 1931777872 10360464 11131392
18:00:29 59216 8192000000 10870442144 11308457984 1894862848 18.785 98 21 42 2 1916164144 15649616 5651680
18:01:35 40344 8192000000 10889444848 11343716352 1956313328 19.277 100 24 48 1 1971163248 7828832 7021088
18:02:28 21505 8192000000 10895787552 11337371648 1947437216 19.206 99 32 64 1 1964295584 7943872 8914496
18:02:57 59198 8192000000 10873536144 11340414976 1927194256 19.044 98 12 24 2 1937762208 7720016 2847936
18:04:29 66831 8192000000 10875397584 11340017664 1953229968 19.252 100 20 41 0 1968540592 9527872 5782752
18:05:44 106201 8192000000 10914515712 11376300032 1969717072 19.383 100 24 49 0 1988255648 11711632 6826944
18:07:55 101317 8192000000 10912589776 11368304640 1966229328 19.356 99 38 77 2 1992214016 15355248 10629440
18:10:31 43554 8192000000 10924393888 11394510848 1992635296 19.565 100 14 28 1 2014664816 17502736 4526784
18:11:21 38329 8192000000 10938067424 11416473600 1991549808 19.556 100 15 30 2 2027224960 31233248 4441904
18:12:07 136767 8192000000 10911662704 11392745472 1978902016 19.456 99 23 46 0 2007008896 21484400 6622480
18:14:35 52363 8192000000 10907657088 11384070144 1967635840 19.367 99 16 32 1 1982378528 10305152 4437536
18:15:45 37975 8192000000 10909766448 11376685056 1976471840 19.437 100 10 20 1 1990252784 10746704 3034240
18:16:32 69862 8192000000 10895661136 11352506368 1944158096 19.180 98 21 43 3 1957448736 7154304 6136336
18:17:48 67330 8192000000 10897328464 11374247936 1964008016 19.338 99 8 16 0 1974673664 8135104 2530544
18:19:01 34791 8192000000 10912196624 11382870016 1988590080 19.533 100 25 52 1 2002216496 6961424 6664992
18:19:46 74418 8192000000 10919188464 11379396608 1991563824 19.556 100 14 29 0 2003538576 7833248 4141504
18:21:07 86265 8192000000 10922378288 11389263872 1999209552 19.616 100 26 52 0 2013136736 6004224 7922960
18:22:56 100569 8192000000 10893938304 11367796736 1917788592 18.969 96 26 51 2 1933799792 8303232 7707968
18:24:49 28633 8192000000 10890315888 11359883264 1944506944 19.183 98 17 34 0 1956275248 6423728 5344576
18:25:25 3304 8192000000 10908871600 11369246720 1985020256 19.504 100 41 78 3 2003815920 7235632 11560032
18:25:34 29902 8192000000 10902317696 11372343296 1966460800 19.357 99 33 66 1 1985799424 9989008 9349616
18:26:15 46054 8192000000 10896229056 11381280768 1979325392 19.459 100 20 39 0 1998684352 14113536 5245424
18:28:07 36669 8192000000 10894736832 11365830656 1915299280 18.949 97 14 28 0 1932689536 13364496 4025760
18:28:50 99289 8192000000 10885530592 11370004480 1939571344 19.143 98 12 24 1 1958381904 15538160 3272400
18:30:42 76089 8192000000 10887116672 11355197440 1874255952 18.619 95 24 47 2 1896532960 15850496 6426512
18:32:20 60697 8192000000 10891771600 11350777856 1948093616 19.211 100 15 30 1 1962597216 10230720 4272880
18:33:28 38120 8192000000 10877072848 11348361216 1922641904 19.008 98 22 44 1 1937806304 8688800 6475600
18:34:13 25953 8192000000 10876248192 11339120640 1923856464 19.018 98 38 74 2 1942150960 7800336 10494160
18:34:49 33580 8192000000 10898950864 11365756928 1953001584 19.250 99 34 68 2 1976234176 13568176 9664416
18:35:30 59748 8192000000 10862373360 11333779456 1845721232 18.387 94 26 52 0 1864049008 11157152 7170624
18:36:36 43315 8192000000 10881923184 11336990720 1924973424 19.027 99 29 58 1 1945129808 11742208 8414176
18:37:31 32064 8192000000 10870477728 11329224704 1882963040 18.689 97 34 68 1 1906619472 14026976 9629456
18:38:13 52071 8192000000 10849318272 11330678784 1894751744 18.784 98 20 40 1 1918347584 17965376 5630464
18:39:11 70129 8192000000 10853266032 11321483264 1832435792 18.279 95 21 42 1 1851610688 12825104 6349792
18:40:32 49420 8192000000 10862016688 11314208768 1842357600 18.360 95 28 56 0 1860583728 10972608 7253520
18:41:28 92735 8192000000 10869403920 11344007168 1933760256 19.097 100 21 41 3 1951663392 12351376 5551760
18:43:22 88954 8192000000 10878061264 11341053952 1907242736 18.885 98 21 42 1 1921272800 8153088 5876976
18:44:59 67087 8192000000 10860938080 11343032320 1927688656 19.048 99 9 18 0 1944677760 14683504 2305600
18:46:17 13034 8192000000 10868407488 11335503872 1927154880 19.044 99 23 46 3 1949938720 16690576 6093264
18:46:43 44441 8192000000 10827436240 11296829440 1863262864 18.530 96 10 20 0 1871481184 5979856 2238464
18:47:38 67442 8192000000 10840449504 11302187008 1855869056 18.470 96 7 14 0 1866569200 8602544 2097600
18:48:52 68220 8192000000 10839906752 11307765760 1894499536 18.782 98 16 32 0 1911891840 12860944 4531360
18:50:10 53307 8192000000 10846442704 11322789888 1919635344 18.984 100 8 16 0 1939510272 17371280 2503648
18:51:16 85909 8192000000 10843024752 11329572864 1890550096 18.750 98 16 31 3 1907620144 12457856 4612192
18:52:48 37573 8192000000 10875547008 11329323008 1899704416 18.824 98 10 20 2 1910627472 8149872 2773184
18:53:32 43391 8192000000 10859651760 11318071296 1862346384 18.522 96 41 82 1 1882571696 9074848 11150464
18:54:26 31784 8192000000 10855044912 11308212224 1875287280 18.627 97 28 55 1 1893094400 9563376 8243744
18:55:10 44501 8192000000 10837795344 11303174144 1881784560 18.680 98 26 52 1 1899814656 10489104 7540992
18:56:11 49158 8192000000 10878339408 11335520256 1929135184 19.060 100 29 56 0 1947904768 10637088 8132496
18:57:07 69526 8192000000 10890468880 11366170624 1954004336 19.258 100 19 38 0 1975119888 15811280 5304272
18:58:23 76903 8192000000 10890181792 11352846336 1899386112 18.821 97 11 22 1 1916177648 14218512 2573024
18:59:46 32989 8192000000 10890816576 11348922368 1940935696 19.154 99 15 30 1 1952413776 7589296 3888784
19:00:26 73058 8192000000 10884453472 11363631104 1911511424 18.919 97 18 36 1 1925464656 9357936 4595296
19:01:50 65768 8192000000 10904621040 11383410688 1928711376 19.057 98 13 26 0 1947814096 16004976 3097744
19:03:02 82802 8192000000 10918309120 11372883968 1935674464 19.112 98 20 40 1 1951793920 10803152 5316304
19:04:36 17969 8192000000 10922222256 11368456192 1975117008 19.426 100 41 82 1 1999594672 12972400 11505264
19:05:03 94711 8192000000 10925929392 11378999296 1947439152 19.206 98 29 58 1 1967171200 11955072 7776976
19:06:45 57192 8192000000 10901155504 11382857728 1987359152 19.523 100 38 76 1 2012288064 13623664 11305248
19:08:32 84480 8192000000 10914239040 11378212864 1964784352 19.344 99 23 46 2 1977639504 6419328 6435824
19:10:22 52265 8192000000 10910397120 11391803392 1981652016 19.478 100 27 55 1 2000656336 11581104 7423216
19:11:21 98936 8192000000 10917535408 11400564736 1953470992 19.254 98 10 20 0 1975748656 19138432 3139232
19:13:06 55829 8192000000 10899946368 11372625920 1965703264 19.351 99 13 26 0 1987517136 17788960 4024912
19:15:08 82810 8192000000 10909215808 11390246912 1979161584 19.458 100 14 28 0 1992590528 9165520 4263424
19:16:45 38007 8192000000 10910341040 11389714432 1960776080 19.312 99 10 20 0 1972070128 8916624 2377424
19:17:30 77144 8192000000 10905832768 11385126912 1910450464 18.910 96 26 52 0 1936614416 18666176 7497776
19:18:57 71445 8192000000 10886810304 11348234240 1887678016 18.727 95 17 33 1 1906488176 12398864 6411296
19:20:16 67676 8192000000 10879950224 11366158336 1927027648 19.043 98 13 25 1 1943213040 12191248 3994144
19:21:41 85808 8192000000 10878019664 11352928256 1899531840 18.823 97 5 10 0 1911403552 10416496 1455216
19:23:13 48532 8192000000 10890688592 11341914112 1900337424 18.829 97 27 54 1 1917130704 9209840 7583440
19:24:07 47773 8192000000 10865264688 11329847296 1904651120 18.864 98 30 60 2 1924344640 11384672 8308848
19:25:36 54642 8192000000 10859546880 11334443008 1884617296 18.702 97 21 42 2 1903941424 13727344 5596784
19:26:39 47591 8192000000 9343231664 9620037632 473512224 5.464 25 2 4 0 479070304 5192496 365584

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 27-01-2021 19:28:19 to 27-01-2021 19:28:52.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 27-01-2021 19:28:53 to 27-01-2021 19:28:54.

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          238925
MON$OLDEST_ACTIVE               239761
MON$OLDEST_SNAPSHOT             239761
MON$NEXT_TRANSACTION            239761
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                       2036960
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.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 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 ---
:95: 
:96: mscs-test-161.budzdorov.ru    Wed Jan 27 19:27:32 2021
:97:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:98: 
--- end of diff output ---

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

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