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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-04-05 22:27:26
DTS_END                         2021-04-05 22:27:26.8760
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/51832
TRN_ID                          232894
ATT_ID                          602
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: 9290.67 25391 1114880
customer order: creation 162.06 339 19447
customer order: refuse 13.74 345 1649
order to supplier: creation 43.78 1251 5253
order to supplier: removal 3.48 113621 417
invoice (draft): creation 44.25 3684 5310
invoice (draft): removal 55.48 801 6657
invoice accept: apply 40.14 17439 4817
invoice accept: cancel 50.10 774 6012
customer reserve: creation 3708.34 171 445001
customer reserve: removal 4877.07 63 585248
realization accept: apply 77.79 185 9335
realization accept: cancel 90.07 101 10808
payment from customer: creation 56.68 149 6802
payment from customer: removal 5.74 90 689
payment to supplier: creation 46.94 147 5633
payment to supplier: removal 3.31 134 397
service: total inventory turnovers 4.48 1302 538
service: total monetary turnovers 6.39 29 767
service: aggregate perf. data 0.80 21630 96
service: refresh index statistics 0.03 345570 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-04-2021 22:28:23 to 05-04-2021 22:28:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4030
TEST_TIME 2 3854
TEST_TIME 3 3052
TEST_TIME 4 3468
TEST_TIME 5 3977
TEST_TIME 6 3734
TEST_TIME 7 4092
TEST_TIME 8 4297
TEST_TIME 9 4818
TEST_TIME 10 4970
TEST_TIME 11 5520
TEST_TIME 12 5953
TEST_TIME 13 6002
TEST_TIME 14 6312
TEST_TIME 15 6309
TEST_TIME 16 6778
TEST_TIME 17 6846
TEST_TIME 18 6976
TEST_TIME 19 7488
TEST_TIME 20 7441
TEST_TIME 21 7443
TEST_TIME 22 8135
TEST_TIME 23 8283
TEST_TIME 24 8752
TEST_TIME 25 9208
TEST_TIME 26 9282
TEST_TIME 27 9488
TEST_TIME 28 10124
TEST_TIME 29 10518
TEST_TIME 30 11204
TEST_TIME 31 11351
TEST_TIME 32 11213
TEST_TIME 33 10997
TEST_TIME 34 11171
TEST_TIME 35 11087
TEST_TIME 36 11129
TEST_TIME 37 10886
TEST_TIME 38 10624
TEST_TIME 39 10474
TEST_TIME 40 10364
TEST_TIME 41 10274
TEST_TIME 42 10333
TEST_TIME 43 10245
TEST_TIME 44 10097
TEST_TIME 45 10016
TEST_TIME 46 9983
TEST_TIME 47 10097
TEST_TIME 48 9980
TEST_TIME 49 9887
TEST_TIME 50 9846
TEST_TIME 51 9690
TEST_TIME 52 9663
TEST_TIME 53 9586
TEST_TIME 54 9561
TEST_TIME 55 9476
TEST_TIME 56 9384
TEST_TIME 57 9341
TEST_TIME 58 9385
TEST_TIME 59 9416
TEST_TIME 60 9393
TEST_TIME 61 9381
TEST_TIME 62 9427
TEST_TIME 63 9441
TEST_TIME 64 9437
TEST_TIME 65 9500
TEST_TIME 66 9554
TEST_TIME 67 9617
TEST_TIME 68 9570
TEST_TIME 69 9610
TEST_TIME 70 9591
TEST_TIME 71 9621
TEST_TIME 72 9618
TEST_TIME 73 9625
TEST_TIME 74 9550
TEST_TIME 75 9467
TEST_TIME 76 9515
TEST_TIME 77 9435
TEST_TIME 78 9436
TEST_TIME 79 9386
TEST_TIME 80 9392
TEST_TIME 81 9331
TEST_TIME 82 9266
TEST_TIME 83 9327
TEST_TIME 84 9337
TEST_TIME 85 9301
TEST_TIME 86 9303
TEST_TIME 87 9330
TEST_TIME 88 9362
TEST_TIME 89 9449
TEST_TIME 90 9468
TEST_TIME 91 9471
TEST_TIME 92 9522
TEST_TIME 93 9571
TEST_TIME 94 9562
TEST_TIME 95 9547
TEST_TIME 96 9609
TEST_TIME 97 9663
TEST_TIME 98 9630
TEST_TIME 99 9541
TEST_TIME 100 9547
TEST_TIME 101 9494
TEST_TIME 102 9465
TEST_TIME 103 9480
TEST_TIME 104 9526
TEST_TIME 105 9489
TEST_TIME 106 9472
TEST_TIME 107 9439
TEST_TIME 108 9452
TEST_TIME 109 9409
TEST_TIME 110 9382
TEST_TIME 111 9350
TEST_TIME 112 9317
TEST_TIME 113 9290
TEST_TIME 114 9268
TEST_TIME 115 9284
TEST_TIME 116 9340
TEST_TIME 117 9307
TEST_TIME 118 9307
TEST_TIME 119 9298
TEST_TIME 120 9297

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-04-2021 22:28:27 to 05-04-2021 22:28:30.

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 1528435 1528435 0 0.00 0 44788 6 0 0
doc_list_biud 1528433 1528433 0 0.00 0 78632 30 0 0
sp_add_invoice_to_stock 4918 4817 101 2.05 29 206107 17440 0 101
sp_cancel_adding_invoice 6012 6012 0 0.00 3 55371 774 0 0
sp_cancel_client_order 1649 1649 0 0.00 4 20367 346 0 0
sp_cancel_customer_reserve 585248 585248 0 0.00 1 78634 64 0 0
sp_cancel_pay_from_customer 689 689 0 0.00 2 8450 90 0 0
sp_cancel_pay_to_supplier 397 397 0 0.00 3 10214 134 0 0
sp_cancel_supplier_invoice 6665 6657 8 0.12 1 12332 801 0 8
sp_cancel_supplier_order 417 417 0 0.00 7 1157472 113622 0 0
sp_cancel_write_off 10808 10808 0 0.00 1 10316 102 0 0
sp_client_order 19447 19447 0 0.00 4 30255 340 0 0
sp_customer_reserve 445001 445001 0 0.00 0 100825 172 0 0
sp_fill_shopping_cart 29991 29991 0 0.00 1 9850 37 0 0
sp_fill_shopping_cart_clo_res 444994 444994 0 0.00 0 26572 13 0 0
sp_get_clo_for_invoice 4809 4809 0 0.00 0 34899 311 0 0
sp_kill_cost_storno 17906 17906 0 0.00 0 6848 56 0 0
sp_kill_qstorno_ret_qs2qd 1188378 1188378 0 0.00 0 78628 34 0 0
sp_kill_qty_storno 624934 624934 0 0.00 0 78631 73 0 0
sp_lock_selected_doc 19726 19726 0 0.00 0 8389 5 0 0
sp_make_cost_storno 26578 26578 0 0.00 0 44743 60 0 0
sp_multiply_rows_for_pdistr 26578 26578 0 0.00 0 19178 36 0 0
sp_multiply_rows_for_qdistr 19447 19447 0 0.00 0 29906 160 0 0
sp_pay_from_customer 6802 6802 0 0.00 4 19691 150 0 0
sp_pay_to_supplier 5633 5633 0 0.00 4 19458 147 0 0
sp_payment_common 12435 12435 0 0.00 1 19682 43 0 0
sp_qd_handle_on_cancel_clo 1649 1649 0 0.00 0 20360 312 0 0
sp_qd_handle_on_invoice_upd_sts 10820 10820 0 0.00 0 39861 357 0 0
sp_qd_handle_on_reserve_upd_sts 9335 9335 0 0.00 0 19886 50 0 0
sp_reserve_write_off 9335 9335 0 0.00 6 19897 186 0 0
sp_supplier_invoice 5310 5310 0 0.00 7 89162 3684 0 0
sp_supplier_order 5253 5253 0 0.00 6 39652 1252 0 0
srv_aggregate_perf_data 96 96 0 0.00 2470 179174 21631 0 0
srv_fill_mon_cache_memory 154 154 0 0.00 1687 136930 33385 0 0
srv_find_qd_qs_mism 1069934 1069934 0 0.00 0 16442 5 0 0
srv_make_invnt_saldo 538 538 0 0.00 51 73783 1303 0 0
srv_make_money_saldo 767 767 0 0.00 0 1124 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 136706 504330 345571 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4818 4818 0 0.00 0 15328 205 0 0
t$perf-norm:sp_cancel_adding_invoice 383 383 0 0.00 0 7507 124 0 0
t$perf-norm:sp_cancel_client_order 1649 1649 0 0.00 0 3567 13 0 0
t$perf-norm:sp_cancel_customer_reserve 671 671 0 0.00 0 3136 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 689 689 0 0.00 0 1373 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 397 397 0 0.00 0 4553 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 389 389 0 0.00 0 14232 78 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 24900 1615 0 0
t$perf-norm:sp_cancel_write_off 989 989 0 0.00 0 8810 15 0 0
t$perf-norm:sp_client_order 19447 19447 0 0.00 0 12779 20 0 0
t$perf-norm:sp_customer_reserve 997 997 0 0.00 0 3768 9 0 0
t$perf-norm:sp_pay_from_customer 6802 6802 0 0.00 0 3762 10 0 0
t$perf-norm:sp_pay_to_supplier 5633 5633 0 0.00 0 7335 13 0 0
t$perf-norm:sp_reserve_write_off 9335 9335 0 0.00 0 9354 16 0 0
t$perf-norm:sp_supplier_invoice 5310 5310 0 0.00 0 7086 17 0 0
t$perf-norm:sp_supplier_order 5253 5253 0 0.00 0 7433 19 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 993 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 154 154 0 0.00 0 727 11 0 0
t$perf-norm:srv_make_invnt_saldo 538 538 0 0.00 0 4087 33 0 0
t$perf-norm:srv_make_money_saldo 767 767 0 0.00 0 919 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 9816 9614 202 2.05 0 10149 23 0 202
v_all_customers 35826 35826 0 0.00 0 18 1 0 0
v_all_suppliers 29528 29528 0 0.00 0 21 1 0 0
v_all_wares 38894 38894 0 0.00 0 50 1 0 0
v_cancel_adding_invoice 766 766 0 0.00 0 2063 8 0 0
v_cancel_client_order 3298 3298 0 0.00 0 10159 10 0 0
v_cancel_customer_prepayment 1378 1378 0 0.00 0 4607 9 0 0
v_cancel_customer_reserve 1342 1342 0 0.00 0 6285 10 0 0
v_cancel_payment_to_supplier 794 794 0 0.00 0 10093 27 0 0
v_cancel_supplier_invoice 794 778 16 2.01 0 3398 19 0 16
v_cancel_supplier_order 834 834 0 0.00 0 880 4 0 0
v_cancel_write_off 1978 1978 0 0.00 0 10025 21 0 0
v_max_id_clo_ord 5249 5249 0 0.00 0 7131 2 0 0
v_max_id_clo_res 997 997 0 0.00 0 5859 22 0 0
v_max_id_ord_sup 5295 5295 0 0.00 0 4089 2 0 0
v_max_non_paid_invoice 1413 1413 0 0.00 0 1260 3 0 0
v_max_non_paid_realizn 3438 3438 0 0.00 0 1267 3 0 0
v_min_id_clo_ord 5249 5249 0 0.00 0 2464 5 0 0
v_min_id_clo_res 997 997 0 0.00 0 4577 13 0 0
v_min_id_ord_sup 5295 5295 0 0.00 0 4758 7 0 0
v_min_non_paid_invoice 5633 5633 0 0.00 0 17585 30 0 0
v_min_non_paid_realizn 6802 6802 0 0.00 0 19676 37 0 0
v_our_firm 9796 9796 0 0.00 0 25 1 0 0
v_reserve_write_off 18670 18670 0 0.00 0 7239 9 0 0
x_lock_depdocs_on_canc_invoice 12280 12280 0 0.00 0 17481 118 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 11525 363 0 0
x_make_qstorno_1000_1200 5253 5253 0 0.00 1 39640 1174 0 0
x_make_qstorno_1200_2000 5310 5310 0 0.00 3 89153 3556 0 0
x_make_qstorno_2100_3300 445001 445001 0 0.00 0 100743 156 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-04-2021 22:28:31 to 05-04-2021 22:28:35.

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
19:57:30 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:37 5972 8192000000 9917552000 10161393664 683801776 7.704 57 38 80 0 698902176 1912560 13187840
19:57:52 16555 8192000000 10261403584 10569551872 1301860176 13.712 100 77 154 0 1331037744 3831152 25346416
19:58:17 9503 8192000000 10300208160 10608971776 1348662080 14.135 100 83 166 0 1381364896 4773936 27928880
19:58:34 26149 8192000000 10347992192 10662838272 1391519952 14.519 100 88 176 1 1426523024 5747024 29256048
19:59:13 22803 8192000000 10370188768 10690142208 1425684192 14.823 100 91 182 0 1462666304 6894384 30087728
19:59:46 26700 8192000000 10400298032 10724564992 1460378160 15.129 100 92 184 1 1498044832 7704592 29962080
20:00:34 19173 8192000000 10433139744 10762244096 1484706432 15.343 100 87 174 0 1521488032 8585248 28196352
20:01:09 11604 8192000000 10448988240 10783744000 1508311984 15.549 100 87 174 0 1545579776 9519872 27747920
20:01:32 13088 8192000000 10471170544 10811002880 1523884384 15.684 100 80 160 0 1558571344 9588976 25097984
20:02:06 13231 8192000000 10500875744 10846748672 1561991888 16.013 100 85 171 2 1599280928 10506416 26782624
20:02:27 13241 8192000000 10512205552 10860834816 1572846176 16.107 100 77 154 0 1607151056 10522912 23781968
20:02:56 10778 8192000000 10534791008 10890477568 1594796688 16.295 100 76 150 1 1627817040 10123840 22896512
20:03:16 15001 8192000000 10565298048 10924965888 1629921376 16.594 100 80 160 3 1664881216 11299120 23660720
20:03:40 8288 8192000000 10594395024 10955206656 1653053968 16.790 100 81 160 2 1689441264 12540224 23847072
20:03:57 11659 8192000000 10613500352 10977959936 1675271152 16.978 100 85 170 2 1713241584 12968304 25002128
20:04:16 12309 8192000000 10622685520 10991677440 1681082320 17.026 100 80 160 1 1717954752 13332688 23539744
20:04:37 5839 8192000000 10629900944 10998083584 1693423664 17.130 100 79 158 0 1729614448 13359312 22831472
20:04:52 8464 8192000000 10645682640 11015032832 1706501696 17.240 100 80 159 1 1742170144 13019024 22649424
20:05:07 8081 8192000000 10662472880 11034980352 1720857248 17.359 100 75 150 0 1755476880 12919712 21699920
20:05:24 4963 8192000000 10684901280 11057106944 1741149408 17.528 100 84 168 0 1777785792 12382560 24253824
20:05:37 4267 8192000000 10690395536 11062751232 1748238304 17.587 100 84 168 1 1784510720 12687216 23585200
20:05:49 4745 8192000000 10697617360 11074437120 1760418704 17.688 100 84 169 0 1798032368 13114256 24499408
20:06:01 4326 8192000000 10715017200 11091808256 1770783056 17.773 100 83 165 0 1807192400 13438432 22970912
20:06:12 3610 8192000000 10716962272 11097616384 1783212256 17.876 100 90 178 0 1822382912 13344336 25826320
20:06:23 4025 8192000000 10725434208 11104075776 1789760608 17.930 100 87 172 1 1827041872 13540272 23740992
20:06:33 4970 8192000000 10737219056 11121524736 1793928256 17.964 100 87 170 1 1831048464 13660864 23459344
20:06:44 3184 8192000000 10749023472 11128348672 1804867264 18.054 100 90 180 1 1843843872 14133248 24843360
20:06:55 2543 8192000000 10747616384 11134046208 1808109024 18.080 100 88 173 2 1845961088 14019424 23832640
20:07:04 6950 8192000000 10753765936 11141779456 1818350176 18.164 100 85 170 2 1855179120 13774464 23054480
20:07:17 1985 8192000000 10765512880 11151585280 1827875520 18.242 100 94 187 2 1868429440 14246176 26307744
20:07:29 3004 8192000000 10784022464 11167956992 1844047456 18.374 100 92 183 1 1882766112 13257744 25460912
20:07:38 2210 8192000000 10784364336 11170082816 1844883664 18.381 100 87 174 3 1883075376 14014768 24176944
20:07:47 2326 8192000000 10796329904 11181588480 1851211024 18.432 100 92 185 2 1891322880 14410064 25701792
20:07:55 2406 8192000000 10801250448 11187335168 1853947680 18.454 100 94 189 1 1894640048 14353280 26339088
20:08:04 1630 8192000000 10805153024 11191328768 1857806800 18.485 100 91 181 2 1897707216 13993008 25907408
20:08:12 2129 8192000000 10802603536 11190702080 1860972688 18.511 100 89 178 0 1898113264 12778112 24362464
20:08:21 2043 8192000000 10806248720 11193864192 1865676048 18.549 100 90 178 1 1903096864 12409312 25011504
20:08:29 2823 8192000000 10800834080 11190824960 1865195936 18.545 100 89 178 1 1904350768 14285920 24868912
20:08:38 1192 8192000000 10811602560 11197435904 1867770704 18.566 100 98 195 0 1910846064 15301648 27773712
20:08:46 2092 8192000000 10812838288 11202125824 1869239968 18.578 100 95 188 2 1910957840 13805264 27912608
20:08:55 1433 8192000000 10813526320 11201273856 1869459648 18.580 100 94 189 2 1908534032 12122320 26952064
20:09:02 33561 8192000000 10804367184 11199639552 1868288880 18.570 100 74 149 2 1899370528 8635392 22446256
20:09:42 13844 8192000000 10789991392 11206295552 1867371344 18.563 100 49 98 0 1893800272 13010288 13418640
20:10:03 6987 8192000000 10774332368 11202404352 1868490784 18.572 100 29 58 2 1884074992 7653200 7931008
20:10:16 5787 8192000000 10783107856 11203047424 1871656016 18.598 100 31 62 1 1888101872 8085168 8360688
20:10:29 2986 8192000000 10792275648 11217326080 1876481456 18.637 100 35 70 2 1894763504 8316576 9965472
20:10:40 3471 8192000000 10784414288 11215081472 1881178368 18.675 100 33 66 1 1897669024 6831360 9659296
20:10:49 6950 8192000000 10790900608 11218722816 1881275024 18.675 100 26 52 0 1895677136 6941440 7460672
20:11:11 5524 8192000000 10790482976 11221180416 1885394400 18.709 100 37 74 2 1907682752 11568400 10719952
20:11:24 7741 8192000000 10795498960 11224834048 1885814400 18.712 100 16 32 2 1896250224 5737920 4697904
20:11:41 7548 8192000000 10803682960 11230666752 1890429312 18.749 100 25 49 0 1903393024 5869520 7094192
20:12:02 6982 8192000000 10799108400 11230400512 1893465488 18.774 100 16 32 2 1903795440 5987792 4342160
20:12:15 20056 8192000000 10800615152 11235364864 1896212464 18.796 100 14 28 1 1904828880 5035488 3580928
20:12:43 11214 8192000000 10802479408 11241787392 1901162016 18.836 100 22 44 1 1914429552 6626576 6640960
20:13:05 9104 8192000000 10813353280 11243245568 1904616544 18.863 100 25 50 1 1919316512 6824240 7875728
20:13:20 19649 8192000000 10820279360 11248680960 1910892384 18.914 100 30 60 1 1925861088 5818848 9149856
20:13:46 70295 8192000000 10834940160 11262767104 1875385488 18.628 98 24 49 1 1887763728 5305936 7072304
20:15:04 8624 8192000000 10821347728 11260411904 1911659008 18.920 100 25 49 0 1926297024 7623936 7014080
20:15:21 6898 8192000000 10831201568 11266150400 1917928592 18.970 100 24 48 2 1931202640 6809008 6465040
20:15:35 5795 8192000000 10833384672 11269652480 1918054752 18.971 100 30 61 0 1932731488 6037168 8639568
20:15:49 5814 8192000000 10827269216 11262763008 1912633360 18.928 100 20 41 0 1924612720 5141328 6838032
20:16:03 6672 8192000000 10825667584 11263619072 1917402496 18.966 100 32 65 2 1932994368 5661648 9930224
20:16:20 7913 8192000000 10826208528 11266809856 1916019424 18.955 100 16 31 2 1927145008 6167984 4957600
20:16:35 5998 8192000000 10829124624 11268722688 1918206992 18.972 100 19 38 4 1929376576 5858144 5311440
20:16:48 7950 8192000000 10828017856 11264663552 1918751440 18.977 100 25 50 0 1931852560 5982496 7118624
20:17:05 6410 8192000000 10827114976 11260866560 1911625936 18.920 100 22 44 3 1923834896 5739744 6469216
20:17:23 6350 8192000000 10814233392 11241951232 1897395712 18.805 100 27 52 2 1910786096 5530256 7860128
20:17:36 12003 8192000000 10799867120 11236237312 1877194656 18.642 99 16 32 0 1887508688 5429648 4884384
20:17:56 7161 8192000000 10799796000 11236253696 1866637840 18.557 98 25 50 1 1880173088 6523808 7011440
20:18:11 4867 8192000000 10802582592 11228712960 1867967920 18.568 99 24 48 4 1880264384 5592960 6703504
20:18:23 8285 8192000000 10783002672 11218153472 1845704144 18.387 98 18 36 2 1861656064 11263840 4688080
20:18:38 14876 8192000000 10795569632 11214876672 1805001504 18.055 96 26 52 0 1817626832 5367840 7257488
20:19:40 28357 8192000000 10732897728 11161210880 1782589552 17.871 95 32 63 2 1797607456 4963040 10054864
20:20:14 10132 8192000000 10740457744 11164364800 1743092640 17.544 94 18 37 1 1753350960 5073712 5184608
20:20:31 5373 8192000000 10741795776 11158044672 1795393200 17.976 98 37 73 0 1813402208 7218080 10790928
20:20:45 7161 8192000000 10724043936 11144286208 1768506112 17.755 97 30 60 2 1783198416 6083184 8609120
20:20:59 9180 8192000000 10669662496 11091808256 1701359328 17.196 94 18 35 1 1711558480 5369008 4830144
20:21:16 8566 8192000000 10678237264 11087253504 1705233632 17.229 95 25 50 0 1718547728 5771712 7542384
20:21:31 10274 8192000000 10691087712 11110670336 1760557680 17.689 99 17 34 0 1770223952 5167024 4499248
20:21:49 8253 8192000000 10709879904 11128147968 1781143424 17.859 99 32 64 1 1800792400 10837040 8811936
20:22:05 13492 8192000000 10720285536 11133714432 1771274672 17.778 98 25 50 0 1784375360 5590144 7510544
20:22:26 5979 8192000000 10708808784 11128160256 1756620000 17.656 97 33 66 1 1772690912 5621136 10449776
20:22:38 10424 8192000000 10736362240 11152609280 1799306112 18.008 99 31 61 0 1813734320 5151264 9276944
20:22:58 9634 8192000000 10740287456 11157610496 1788455840 17.919 98 26 52 2 1801442816 4987536 7999440
20:23:14 13103 8192000000 10732110368 11160059904 1816221504 18.147 100 17 34 0 1826612896 5720432 4670960
20:23:36 11325 8192000000 10727749344 11157352448 1808249520 18.082 99 17 34 1 1818358384 5759792 4349072
20:23:57 63761 8192000000 10739102720 11164913664 1816075456 18.146 99 45 91 0 1835412480 5890160 13446864
20:25:10 12873 8192000000 10757662464 11176931328 1831407600 18.271 100 13 26 0 1840190704 5187168 3595936
20:25:30 6842 8192000000 10760000896 11179433984 1840894960 18.348 100 26 52 2 1855259616 6427712 7936944
20:25:44 7702 8192000000 10760365616 11192209408 1846001504 18.390 100 15 30 2 1855768768 5582144 4185120
20:26:02 6940 8192000000 10765835552 11201679360 1858634624 18.492 100 24 48 1 1876700432 10723600 7342208
20:26:15 8255 8192000000 10781992416 11209699328 1865805376 18.550 100 27 54 0 1879374112 5771040 7797696
20:26:34 5996 8192000000 10793352560 11217588224 1868078592 18.569 100 34 67 1 1884030416 6260736 9691088
20:26:51 9794 8192000000 10789197952 11222216704 1872628656 18.606 100 29 58 1 1886647872 5830976 8188240
20:27:10 11321 8192000000 10796492720 11229229056 1892190064 18.763 100 28 56 0 1904870752 4617152 8063536
20:27:28 58836 8192000000 10846644688 11265261568 1906602384 18.879 100 38 76 1 1922956784 4875056 11479344
20:28:35 11531 8192000000 10857732992 11278618624 1924465536 19.023 100 51 100 2 1950409712 10598992 15345184
20:28:53 19428 8192000000 10862999072 11287007232 1925931408 19.034 100 48 96 1 1951982816 12454752 13596656
20:29:22 52812 8192000000 10873314288 11303120896 1935018480 19.107 100 51 102 2 1966829024 16057392 15753152
20:31:04 53857 8192000000 10866395792 11309780992 1938491792 19.135 100 29 58 0 1966190688 18754080 8944816
20:32:06 9179 8192000000 10881496272 11318091776 1945464368 19.190 100 25 50 1 1973238800 20506352 7268080
20:32:29 62466 8192000000 10887183232 11330228224 1950727040 19.232 100 23 45 0 1976132240 18587296 6817904
20:33:39 33848 8192000000 10906386752 11344543744 1968699568 19.375 100 37 73 1 2002162848 22267632 11195648
20:34:20 30571 8192000000 10930212784 11364102144 1976912672 19.440 100 37 74 1 2012990432 25121264 10956496
20:35:07 10183 8192000000 10937608880 11369943040 1970851360 19.392 99 53 102 2 2014644352 28008128 15784864
20:35:26 2310 8192000000 10968133200 11383283712 1997362848 19.602 100 68 135 1 2046995136 29696144 19936144
20:35:35 7323 8192000000 10960434240 11391258624 1998686672 19.612 100 61 123 0 2052062048 35120864 18254512
20:35:54 4484 8192000000 10955911712 11382575104 1980768512 19.471 99 60 118 1 2030230176 31957056 17504608
20:36:08 5335 8192000000 10962534128 11389906944 2001288096 19.633 100 76 153 3 2055910352 31886032 22736224
20:36:29 5410 8192000000 10963614368 11391856640 2000995536 19.631 100 54 108 1 2050340688 33420480 15924672
20:36:45 2118 8192000000 10983453632 11408166912 2009113904 19.695 100 76 152 1 2070849472 38028560 23707008
20:36:58 2430 8192000000 10989526880 11405082624 2010636176 19.707 100 75 144 3 2067103328 34921760 21545392
20:37:08 2611 8192000000 10988501488 11409489920 2018590032 19.769 100 76 152 2 2076449344 35543840 22315472
20:37:20 6433 8192000000 10994934192 11415826432 2019962992 19.780 100 77 154 0 2079629744 37078112 22588640
20:37:35 7832 8192000000 10999126272 11422773248 2020681760 19.786 100 73 146 3 2080726464 38370384 21674320
20:37:50 6285 8192000000 11002320080 11428622336 2024434768 19.815 100 69 138 1 2084611664 39647616 20529280
20:38:04 3749 8192000000 11002771328 11428233216 2026766272 19.833 100 68 136 1 2088103856 40579376 20758208
20:38:16 4904 8192000000 10977191200 11401486336 1999019216 19.615 99 73 147 1 2062128624 41132784 21976624
20:38:32 9184 8192000000 10988443536 11420319744 2015078048 19.741 100 71 141 4 2074329424 38115920 21135456
20:38:49 4380 8192000000 10987917104 11419639808 2016558480 19.753 100 60 118 2 2070395104 35781520 18055104
20:39:03 9097 8192000000 10991970288 11425431552 2019508176 19.776 100 54 107 0 2072816528 36921792 16386560
20:39:22 3369 8192000000 10980610752 11410145280 2007599088 19.683 100 64 128 3 2065154304 37647808 19907408
20:39:33 5036 8192000000 10980042368 11404890112 1997144672 19.600 99 80 156 0 2057360768 37004272 23211824
20:39:51 5404 8192000000 10985473808 11425607680 2020876896 19.787 100 57 114 1 2073150112 34422256 17850960
20:40:05 4826 8192000000 10963256576 11383177216 1996243968 19.593 99 74 145 1 2052375472 33256656 22874848
20:40:20 11866 8192000000 10977260784 11412692992 2012834368 19.724 100 58 116 0 2066621088 35124784 18661936
20:40:39 4007 8192000000 10990896880 11418763264 2020530640 19.784 100 65 129 1 2075284032 34981600 19771792
20:40:52 2631 8192000000 10995091536 11418263552 2016583088 19.753 100 79 158 2 2080067264 38882240 24601936
20:41:03 4702 8192000000 11003088208 11422703616 2020033280 19.780 100 87 174 1 2088393648 41629056 26731312
20:41:14 3829 8192000000 11013751248 11431079936 2023975344 19.811 100 84 168 0 2092267696 42882224 25410128
20:41:27 1911 8192000000 11010944224 11432386560 2024125760 19.813 100 86 172 1 2095548528 45531264 25891504
20:41:37 2118 8192000000 11012534912 11434881024 2030247168 19.861 100 86 170 1 2096290624 39761904 26281552
20:41:49 3634 8192000000 11006061840 11434962944 2027548688 19.839 100 72 144 1 2090289872 40712512 22028672
20:41:59 9956 8192000000 11000285872 11430686720 2024434816 19.815 100 73 146 0 2087745808 41140864 22170128
20:42:18 11589 8192000000 11008400544 11441242112 2028770176 19.849 100 68 134 1 2095167344 44603728 21793440
20:42:37 2743 8192000000 11028346896 11458097152 2032805568 19.881 100 66 130 2 2105011568 51690448 20515552
20:42:48 4464 8192000000 10972921184 11405623296 1966090464 19.354 97 63 126 3 2033561760 47616048 19855248
20:43:00 3311 8192000000 10998094256 11423105024 2007663968 19.683 100 79 159 0 2079020912 47230288 24126656
20:43:12 2204 8192000000 10997574192 11420549120 2008662624 19.691 100 73 145 1 2079088368 47026528 23399216
20:43:26 3586 8192000000 10988913600 11416338432 2009165280 19.695 100 71 140 1 2072417680 41675200 21577200
20:43:37 2822 8192000000 10994929504 11425021952 2014273296 19.735 100 72 143 0 2078085376 41995424 21816656
20:43:47 5611 8192000000 11009964224 11436433408 2025172128 19.821 100 77 153 3 2092121248 42551680 24397440
20:44:03 4511 8192000000 11014554864 11441934336 2030300688 19.861 100 75 150 2 2097077456 42980928 23795840
20:44:17 1685 8192000000 11000420528 11423432704 2012961264 19.725 99 64 124 3 2075810416 43324432 19524720
20:44:26 8140 8192000000 11011286992 11436228608 2013177952 19.727 99 73 146 0 2079700224 43998352 22523920
20:44:41 3180 8192000000 11024140800 11450060800 2031848992 19.873 100 69 138 0 2100010064 46275408 21885664
20:44:51 3855 8192000000 11005369520 11436318720 2021361152 19.791 100 66 129 1 2087522624 46102160 20059312
20:45:02 4879 8192000000 11020385440 11451875328 2029939104 19.858 100 62 124 0 2101803264 52607440 19256720
20:45:15 3518 8192000000 11040753712 11461472256 2041343696 19.947 100 76 152 0 2113576752 48867008 23366048
20:45:26 5282 8192000000 11045613872 11469815808 2047723344 19.997 100 77 154 1 2122683216 50623200 24336672
20:45:39 2586 8192000000 11025631824 11448242176 2004626912 19.659 98 78 154 1 2078712368 50003728 24081728
20:45:48 3356 8192000000 11029651408 11452518400 2031322144 19.869 100 83 166 0 2109204176 51568432 26313600
20:46:00 6638 8192000000 10994883184 11424587776 2007724960 19.684 100 69 138 0 2082414576 52296160 22393456
20:46:16 9418 8192000000 10982233872 11420057600 1989291152 19.538 99 57 115 1 2058307920 50390128 18626640
20:46:34 4726 8192000000 10975788800 11408961536 1980701040 19.470 99 63 125 2 2047739088 47173200 19864848
20:46:46 2906 8192000000 10961217888 11374002176 1967533136 19.366 98 72 146 0 2038588304 48525840 22529328
20:46:56 6911 8192000000 10971323920 11410894848 1992521600 19.564 100 49 98 0 2055545504 47316480 15707424
20:47:12 7030 8192000000 10958135936 11399626752 1983631264 19.493 100 40 76 2 2043553600 47276944 12645392
20:47:33 9607 8192000000 10955349472 11386073088 1971066304 19.394 100 57 114 0 2042202400 50695072 20441024
20:47:50 3452 8192000000 10959835312 11386327040 1967512976 19.366 100 60 121 1 2040039200 51996672 20529552
20:48:02 5688 8192000000 10961684416 11383693312 1965618288 19.351 100 63 128 1 2041474896 54773968 21082640
20:48:18 4663 8192000000 10975118816 11401449472 1976514720 19.437 100 66 132 1 2053963888 55491344 21957824
20:48:32 4279 8192000000 10992347312 11416227840 1990037760 19.544 100 71 141 1 2071975968 58811568 23126640
20:48:51 2347 8192000000 11000888224 11428405248 2000386320 19.626 100 67 135 1 2082258688 59992896 21879472
20:49:01 5271 8192000000 10989067472 11425308672 1996294608 19.594 100 62 124 1 2075392192 58885968 20211616
20:49:13 9027 8192000000 10972302928 11414716416 1983525936 19.493 100 42 82 0 2054875200 56732032 14617232
20:49:38 3832 8192000000 11004463360 11432517632 1995045712 19.584 100 68 133 1 2074403728 57028768 22329248
20:49:50 7370 8192000000 10960775568 11407511552 1969585952 19.382 99 45 90 1 2036706176 51751920 15368304
20:50:05 10515 8192000000 10980278032 11417001984 1987322832 19.523 100 42 83 1 2055268192 53597152 14348208
20:50:24 4379 8192000000 10975710448 11407941632 1976556688 19.437 100 57 114 0 2052061200 56560608 18943904
20:50:37 8775 8192000000 10980119392 11421208576 1982065616 19.481 100 46 93 1 2058116944 60009392 16041936
20:50:57 8797 8192000000 10978456768 11425476608 1988235696 19.530 100 46 93 3 2061200432 56744608 16220128
20:51:20 14245 8192000000 10992860592 11438055424 1997414928 19.602 100 50 99 0 2077837568 63891632 16531008
20:51:45 4520 8192000000 11000745792 11442044928 2001471696 19.634 100 57 112 1 2080381200 60529120 18380384
20:51:56 7848 8192000000 10962515648 11407462400 1969250096 19.379 99 48 94 1 2038279344 53443872 15585376
20:52:18 12853 8192000000 10979951616 11430088704 1991554048 19.556 100 45 90 0 2060677328 54375376 14747904
20:52:53 22286 8192000000 10982287440 11432378368 1996608560 19.596 100 35 70 1 2060736272 52048896 12078816
20:53:40 28180 8192000000 10954284848 11406901248 1953394256 19.254 98 33 66 0 2029877920 63860336 12623328
20:54:20 22247 8192000000 10953524624 11408404480 1969027152 19.378 100 29 58 3 2037406864 57517872 10861840
20:54:52 17717 8192000000 10952939968 11418451968 1969595200 19.382 100 26 52 3 2040124272 60976704 9552368
20:55:16 22162 8192000000 10953839840 11424821248 1970609920 19.390 100 26 52 2 2040903808 61282864 9011024
20:55:58 18971 8192000000 10914641040 11383328768 1905554400 18.871 97 15 30 2 1959138656 48431984 5152272
20:56:34 9630 8192000000 10909797152 11381460992 1933000576 19.091 100 12 23 1 1995139024 57582256 4556192
20:57:44 92010 8192000000 10829801248 11280244736 1783646496 17.880 93 4 8 0 1806126032 21609584 869952
21:00:12 45402 8192000000 10902088016 11353333760 1955097680 19.267 100 38 72 2 1976333968 10942752 10293536
21:01:04 126202 8192000000 10896850416 11355795456 1900591696 18.831 97 8 16 0 1919738768 16631552 2515520
21:03:42 75254 8192000000 10880572848 11331334144 1910075280 18.907 98 28 51 2 1931550928 13237792 8237856
21:05:10 28212 8192000000 10931144416 11364085760 1973320272 19.412 100 67 128 2 1999687104 7398640 18968192
21:05:45 136930 8192000000 10890489648 11352965120 1871835248 18.599 95 31 62 0 1891762592 11130128 8797216
21:08:25 126905 8192000000 10875181296 11354255360 1930997856 19.075 99 21 42 0 1950724816 13226576 6500384
21:10:51 104635 8192000000 10894416336 11356000256 1937541360 19.127 99 23 44 0 1956654256 12531040 6581856
21:12:46 79182 8192000000 10886288144 11361304576 1950815872 19.233 99 21 41 0 1970752656 14021424 5915360
21:14:22 66893 8192000000 10874194144 11356934144 1918206272 18.972 98 6 12 1 1935079680 15419184 1454224
21:15:38 25192 8192000000 10871438720 11345354752 1956678912 19.280 100 13 25 3 1974823072 14465584 3678576
21:16:12 54630 8192000000 10875307920 11359019008 1964543424 19.342 100 17 34 1 1979039776 9882208 4614144
21:17:14 16868 8192000000 10873764400 11361464320 1958479392 19.294 100 5 9 1 1968764256 9295328 989536
21:18:26 108327 8192000000 10915482832 11369123840 1956329680 19.277 99 27 54 1 1976212336 12382464 7500192
21:20:29 103748 8192000000 10894916960 11372990464 1941518096 19.159 98 20 40 0 1958108000 11069712 5520192
21:22:20 50381 8192000000 10910633296 11374661632 1963956768 19.337 99 18 34 1 1979158080 9992960 5208352
21:23:27 77555 8192000000 10911463120 11383939072 1985934928 19.512 100 20 40 0 2006637680 14663920 6038832
21:24:58 62086 8192000000 10909044352 11395989504 1987565600 19.525 100 16 32 0 2006040960 13646320 4829040
21:26:07 97579 8192000000 10896981248 11392765952 1968037536 19.370 99 12 24 0 1986044224 14427840 3578848
21:27:50 89251 8192000000 10899188240 11387453440 1948203792 19.212 98 13 26 0 1964421280 12657664 3559824
21:29:26 114700 8192000000 10908698784 11387600896 1890846224 18.753 95 7 14 1 1907777088 14865952 2064912
21:32:39 114157 8192000000 10885245680 11353931776 1879904144 18.664 95 17 35 2 1900858752 16454096 4500512
21:34:40 62363 8192000000 10914593488 11366240256 1932009360 19.083 98 18 36 0 1948371424 11887280 4474784
21:35:48 47386 8192000000 10915681456 11385212928 1970003504 19.385 100 34 68 0 1995257072 15659120 9594448
21:36:45 62097 8192000000 10901044816 11372617728 1889463664 18.741 96 22 43 0 1917312976 22054976 5794336
21:37:55 18742 8192000000 10905677280 11357851648 1940950192 19.154 99 40 80 1 1966679824 14038720 11690912
21:38:24 17786 8192000000 10894846928 11348807680 1942012128 19.163 99 37 74 1 1962182176 9431728 10738320
21:38:48 60409 8192000000 10903310288 11366977536 1964316624 19.340 100 32 64 0 1984882992 11895984 8670384
21:39:56 40611 8192000000 10900999232 11364450304 1931540752 19.079 98 24 48 1 1948170912 10107568 6522592
21:40:46 20255 8192000000 10870180512 11316174848 1870206832 18.586 95 35 70 1 1890063696 10362608 9494256
21:42:42 68222 8192000000 10866474608 11341598720 1912608224 18.928 98 21 42 1 1933070224 14825136 5636864
21:44:01 55875 8192000000 10868006720 11315933184 1878135696 18.650 96 32 64 0 1894936304 7547648 9252960
21:45:26 57710 8192000000 10838469840 11316215808 1904098592 18.859 99 18 34 1 1923238992 13548672 5591728
21:46:32 37698 8192000000 10821848160 11306942464 1865359584 18.547 97 4 8 0 1884862048 18431616 1070848
21:47:17 12348 8192000000 10823836976 11302367232 1872531616 18.605 98 4 8 0 1886475024 13100032 843376
21:47:40 16740 8192000000 10822624416 11306127360 1904589440 18.863 100 4 8 0 1918321152 12684720 1046992
21:48:03 113812 8192000000 10843819664 11313242112 1869588464 18.581 97 18 36 1 1885411616 10470384 5352768
21:50:47 63378 8192000000 10865603408 11326197760 1925889616 19.034 100 15 30 0 1941617968 11456080 4272272
21:51:57 46745 8192000000 10878502192 11342053376 1929605200 19.064 99 34 68 1 1953201312 14010432 9585680
21:52:58 46333 8192000000 10888905904 11352190976 1951726288 19.240 100 26 52 1 1977391520 17885456 7779776
21:54:08 52822 8192000000 10863673296 11340816384 1887901456 18.729 97 13 26 1 1910140688 18239904 3999328
21:55:08 85856 8192000000 10860329696 11346415616 1897183952 18.804 98 11 22 1 1915888080 15678128 3026000
21:56:43 97123 8192000000 10869918352 11329953792 1849640112 18.419 95 12 24 1 1865151888 12286464 3225312
21:58:28 72298 8192000000 10885703840 11354689536 1953380768 19.253 100 19 38 0 1968375088 10115680 4878640
21:59:47 74796 8192000000 10861764016 11336548352 1862250448 18.522 95 13 26 0 1875279920 9888336 3141136
22:01:08 99248 8192000000 10906663920 11366256640 1924473600 19.023 98 17 34 1 1942582608 13675344 4433664
22:02:57 79452 8192000000 10901666832 11396407296 1945341376 19.189 99 16 32 0 1967742960 17418880 4982704
22:05:43 105549 8192000000 10909648256 11375951872 1971452544 19.397 100 15 30 0 1984817968 9190288 4175136
22:07:35 113102 8192000000 10921012080 11372703744 1938992496 19.139 97 35 68 1 1960971056 12769824 9208736
22:09:34 37543 8192000000 10926606912 11385106432 1944429616 19.182 98 36 72 0 1972396928 17731200 10236112
22:10:24 109683 8192000000 10890321648 11378720768 1960437072 19.310 99 10 20 0 1977525696 14323984 2764640
22:12:20 57013 8192000000 10916759952 11370737664 1963190992 19.331 99 34 67 0 1983261376 10593424 9476960
22:13:40 33262 8192000000 10898434192 11368255488 1945775184 19.193 98 29 54 3 1965090560 11243792 8071584
22:14:29 76423 8192000000 10900105200 11387355136 1981568928 19.477 100 8 16 1 1995275552 11404032 2302592
22:15:56 80278 8192000000 10880627696 11366318080 1939063536 19.139 98 13 27 0 1949606272 6349040 4193696
22:18:23 19012 8192000000 10884982832 11357200384 1937929984 19.130 98 31 61 1 1953476080 6779360 8766736
22:18:48 90490 8192000000 10886115824 11379490816 1971663040 19.399 100 12 24 0 1983191952 8361024 3167888
22:20:47 58937 8192000000 10888217568 11364278272 1928353456 19.054 98 18 36 0 1945034432 11618720 5062256
22:21:52 45604 8192000000 10886137472 11372556288 1932983904 19.091 98 14 28 0 1946445664 9529024 3932736
22:22:48 54250 8192000000 10886741872 11377025024 1953376000 19.253 99 19 38 1 1968974608 9365440 6233168
22:23:51 53843 8192000000 10896510752 11366436864 1948626992 19.216 99 21 42 1 1963080560 8595744 5857824
22:24:53 14248 8192000000 10887228064 11340988416 1907020960 18.883 97 41 82 1 1928249168 9175632 12052576
22:25:20 34239 8192000000 10890142000 11361161216 1942676752 19.168 99 33 66 0 1963376784 11371152 9328880
22:26:01 22830 8192000000 10915080336 11371470848 1968193472 19.371 100 34 68 3 1991683584 13286464 10203648
22:26:31 35802 8192000000 10904154192 11367370752 1951472912 19.238 99 27 54 2 1971783808 12598208 7712688
22:27:23 19261 8192000000 9156896032 9400487936 318669536 3.744 17 2 4 0 321385920 2591760 124624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 05-04-2021 22:28:37 to 05-04-2021 22:29:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 101 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-04-2021 22:29:08 to 05-04-2021 22:29:10.

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          233209
MON$OLDEST_ACTIVE               233210
MON$OLDEST_SNAPSHOT             233210
MON$NEXT_TRANSACTION            233210
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                       2056480
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.33438 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33438 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33438 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33438 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 ---
--- end of diff output ---

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

05.04.21 22:29:11. 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-04-05 22:29:13 No severe PSQL-related problems occured
05.04.21 22:29:14. End of report.