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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-13 19:27:24
DTS_END                         2021-03-13 19:27:24.2900
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/60150
TRN_ID                          239866
ATT_ID                          664
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: 9126.89 21328 1095227
customer order: creation 172.07 369 20648
customer order: refuse 14.53 364 1743
order to supplier: creation 44.35 1345 5322
order to supplier: removal 3.28 117439 394
invoice (draft): creation 45.05 3493 5406
invoice (draft): removal 50.94 900 6113
invoice accept: apply 41.56 17867 4987
invoice accept: cancel 46.31 924 5557
customer reserve: creation 3829.57 176 459548
customer reserve: removal 4579.37 66 549524
realization accept: apply 84.02 213 10082
realization accept: cancel 86.97 127 10436
payment from customer: creation 58.89 145 7067
payment from customer: removal 6.10 70 732
payment to supplier: creation 48.15 140 5778
payment to supplier: removal 3.40 86 408
service: total inventory turnovers 4.86 1035 583
service: total monetary turnovers 6.74 23 809
service: aggregate perf. data 0.72 24582 86
service: refresh index statistics 0.03 257195 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-03-2021 19:29:48 to 13-03-2021 19:29:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4831
TEST_TIME 2 4319
TEST_TIME 3 3438
TEST_TIME 4 5662
TEST_TIME 5 5498
TEST_TIME 6 5093
TEST_TIME 7 5573
TEST_TIME 8 5708
TEST_TIME 9 5543
TEST_TIME 10 5508
TEST_TIME 11 5663
TEST_TIME 12 5619
TEST_TIME 13 5748
TEST_TIME 14 5945
TEST_TIME 15 6175
TEST_TIME 16 6728
TEST_TIME 17 6599
TEST_TIME 18 7203
TEST_TIME 19 7260
TEST_TIME 20 7430
TEST_TIME 21 8325
TEST_TIME 22 8848
TEST_TIME 23 9188
TEST_TIME 24 8994
TEST_TIME 25 9468
TEST_TIME 26 10262
TEST_TIME 27 11328
TEST_TIME 28 11076
TEST_TIME 29 10744
TEST_TIME 30 10695
TEST_TIME 31 10753
TEST_TIME 32 10663
TEST_TIME 33 10449
TEST_TIME 34 10233
TEST_TIME 35 10114
TEST_TIME 36 10067
TEST_TIME 37 9860
TEST_TIME 38 9814
TEST_TIME 39 9779
TEST_TIME 40 9752
TEST_TIME 41 9753
TEST_TIME 42 9613
TEST_TIME 43 9536
TEST_TIME 44 9455
TEST_TIME 45 9409
TEST_TIME 46 9497
TEST_TIME 47 9606
TEST_TIME 48 9472
TEST_TIME 49 9317
TEST_TIME 50 9199
TEST_TIME 51 9301
TEST_TIME 52 9177
TEST_TIME 53 9194
TEST_TIME 54 9119
TEST_TIME 55 9185
TEST_TIME 56 9246
TEST_TIME 57 9200
TEST_TIME 58 9138
TEST_TIME 59 9271
TEST_TIME 60 9326
TEST_TIME 61 9332
TEST_TIME 62 9396
TEST_TIME 63 9323
TEST_TIME 64 9586
TEST_TIME 65 9578
TEST_TIME 66 9603
TEST_TIME 67 9631
TEST_TIME 68 9732
TEST_TIME 69 9644
TEST_TIME 70 9560
TEST_TIME 71 9578
TEST_TIME 72 9542
TEST_TIME 73 9482
TEST_TIME 74 9508
TEST_TIME 75 9451
TEST_TIME 76 9396
TEST_TIME 77 9374
TEST_TIME 78 9332
TEST_TIME 79 9375
TEST_TIME 80 9330
TEST_TIME 81 9321
TEST_TIME 82 9355
TEST_TIME 83 9391
TEST_TIME 84 9333
TEST_TIME 85 9414
TEST_TIME 86 9492
TEST_TIME 87 9458
TEST_TIME 88 9516
TEST_TIME 89 9519
TEST_TIME 90 9512
TEST_TIME 91 9522
TEST_TIME 92 9607
TEST_TIME 93 9534
TEST_TIME 94 9447
TEST_TIME 95 9421
TEST_TIME 96 9408
TEST_TIME 97 9335
TEST_TIME 98 9310
TEST_TIME 99 9259
TEST_TIME 100 9243
TEST_TIME 101 9267
TEST_TIME 102 9241
TEST_TIME 103 9216
TEST_TIME 104 9262
TEST_TIME 105 9218
TEST_TIME 106 9270
TEST_TIME 107 9272
TEST_TIME 108 9311
TEST_TIME 109 9343
TEST_TIME 110 9344
TEST_TIME 111 9307
TEST_TIME 112 9315
TEST_TIME 113 9368
TEST_TIME 114 9311
TEST_TIME 115 9284
TEST_TIME 116 9291
TEST_TIME 117 9247
TEST_TIME 118 9209
TEST_TIME 119 9174
TEST_TIME 120 9131

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-03-2021 19:29:52 to 13-03-2021 19:29:55.

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 1519672 1519672 0 0.00 0 25059 7 0 0
doc_list_biud 1519669 1519669 0 0.00 0 40714 30 0 0
sp_add_invoice_to_stock 5062 4987 75 1.48 34 196805 17868 0 75
sp_cancel_adding_invoice 5557 5557 0 0.00 5 64561 924 0 0
sp_cancel_client_order 1743 1743 0 0.00 4 22076 365 0 0
sp_cancel_customer_reserve 549524 549524 0 0.00 1 31843 66 0 0
sp_cancel_pay_from_customer 732 732 0 0.00 2 5309 71 0 0
sp_cancel_pay_to_supplier 408 408 0 0.00 3 3768 86 0 0
sp_cancel_supplier_invoice 6124 6113 11 0.17 2 16937 901 0 11
sp_cancel_supplier_order 394 394 0 0.00 11 1084043 117439 0 0
sp_cancel_write_off 10436 10436 0 0.00 1 26853 127 0 0
sp_client_order 20648 20648 0 0.00 3 35799 370 0 0
sp_customer_reserve 459548 459548 0 0.00 0 82845 177 0 0
sp_fill_shopping_cart 31361 31361 0 0.00 1 14340 42 0 0
sp_fill_shopping_cart_clo_res 459538 459538 0 0.00 0 24942 14 0 0
sp_get_clo_for_invoice 4977 4977 0 0.00 0 32192 305 0 0
sp_kill_cost_storno 17133 17133 0 0.00 0 10512 63 0 0
sp_kill_qstorno_ret_qs2qd 1115991 1115991 0 0.00 0 31835 36 0 0
sp_kill_qty_storno 588826 588826 0 0.00 0 40713 77 0 0
sp_lock_selected_doc 20858 20858 0 0.00 0 10897 6 0 0
sp_make_cost_storno 27904 27904 0 0.00 0 25026 67 0 0
sp_multiply_rows_for_pdistr 27904 27904 0 0.00 0 15572 32 0 0
sp_multiply_rows_for_qdistr 20648 20648 0 0.00 0 22947 162 0 0
sp_pay_from_customer 7067 7067 0 0.00 4 35916 146 0 0
sp_pay_to_supplier 5778 5778 0 0.00 4 19161 141 0 0
sp_payment_common 12845 12845 0 0.00 1 35911 45 0 0
sp_qd_handle_on_cancel_clo 1743 1743 0 0.00 0 22069 331 0 0
sp_qd_handle_on_invoice_upd_sts 10534 10534 0 0.00 0 40712 357 0 0
sp_qd_handle_on_reserve_upd_sts 10082 10082 0 0.00 0 34251 74 0 0
sp_reserve_write_off 10082 10082 0 0.00 6 34341 214 0 0
sp_supplier_invoice 5406 5406 0 0.00 6 86852 3494 0 0
sp_supplier_order 5322 5322 0 0.00 5 44427 1345 0 0
srv_aggregate_perf_data 86 86 0 0.00 2562 520278 24582 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1331 128648 31443 0 0
srv_find_qd_qs_mism 1047265 1047265 0 0.00 0 14756 5 0 0
srv_make_invnt_saldo 583 583 0 0.00 33 36443 1036 0 0
srv_make_money_saldo 809 809 0 0.00 1 2065 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 137799 375325 257195 0 0
t$perf-abend:sp_add_invoice_to_stock 75 75 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4988 4988 0 0.00 0 16625 208 0 0
t$perf-norm:sp_cancel_adding_invoice 448 448 0 0.00 1 6834 133 0 0
t$perf-norm:sp_cancel_client_order 1743 1743 0 0.00 0 8858 20 0 0
t$perf-norm:sp_cancel_customer_reserve 684 684 0 0.00 0 10599 46 0 0
t$perf-norm:sp_cancel_pay_from_customer 732 732 0 0.00 0 536 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 408 408 0 0.00 0 4302 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 397 397 0 0.00 0 5336 34 0 0
t$perf-norm:sp_cancel_supplier_order 394 394 0 0.00 0 45644 1972 0 0
t$perf-norm:sp_cancel_write_off 994 994 0 0.00 0 2090 9 0 0
t$perf-norm:sp_client_order 20648 20648 0 0.00 0 10759 18 0 0
t$perf-norm:sp_customer_reserve 988 988 0 0.00 0 4954 11 0 0
t$perf-norm:sp_pay_from_customer 7067 7067 0 0.00 0 23444 18 0 0
t$perf-norm:sp_pay_to_supplier 5778 5778 0 0.00 0 8460 17 0 0
t$perf-norm:sp_reserve_write_off 10082 10082 0 0.00 0 7854 14 0 0
t$perf-norm:sp_supplier_invoice 5406 5406 0 0.00 0 9813 26 0 0
t$perf-norm:sp_supplier_order 5322 5322 0 0.00 0 5418 16 0 0
t$perf-norm:srv_aggregate_perf_data 86 86 0 0.00 0 901 19 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 905 12 0 0
t$perf-norm:srv_make_invnt_saldo 583 583 0 0.00 0 5922 34 0 0
t$perf-norm:srv_make_money_saldo 809 809 0 0.00 0 1012 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 4 0 0
v_add_invoice_to_stock 10102 9952 150 1.48 0 7561 17 0 150
v_all_customers 37378 37378 0 0.00 0 100 1 0 0
v_all_suppliers 30104 30104 0 0.00 0 101 1 0 0
v_all_wares 41296 41296 0 0.00 0 140 1 0 0
v_cancel_adding_invoice 896 896 0 0.00 0 1360 7 0 0
v_cancel_client_order 3486 3486 0 0.00 0 2452 4 0 0
v_cancel_customer_prepayment 1464 1464 0 0.00 0 2692 6 0 0
v_cancel_customer_reserve 1368 1368 0 0.00 0 2757 8 0 0
v_cancel_payment_to_supplier 816 816 0 0.00 0 1357 5 0 0
v_cancel_supplier_invoice 816 794 22 2.69 0 1066 16 0 22
v_cancel_supplier_order 788 788 0 0.00 0 447 4 0 0
v_cancel_write_off 1988 1988 0 0.00 0 2701 14 0 0
v_max_id_clo_ord 5320 5320 0 0.00 0 6245 3 0 0
v_max_id_clo_res 988 988 0 0.00 0 2020 14 0 0
v_max_id_ord_sup 5393 5393 0 0.00 0 5650 6 0 0
v_max_non_paid_invoice 1439 1439 0 0.00 0 1562 3 0 0
v_max_non_paid_realizn 3905 3905 0 0.00 0 1663 3 0 0
v_min_id_clo_ord 5320 5320 0 0.00 0 5791 5 0 0
v_min_id_clo_res 988 988 0 0.00 0 720 4 0 0
v_min_id_ord_sup 5393 5393 0 0.00 0 13920 12 0 0
v_min_non_paid_invoice 5778 5778 0 0.00 0 11135 30 0 0
v_min_non_paid_realizn 7067 7067 0 0.00 0 35908 37 0 0
v_our_firm 10242 10242 0 0.00 0 99 1 0 0
v_reserve_write_off 20164 20164 0 0.00 0 4189 6 0 0
x_lock_depdocs_on_canc_invoice 11273 11273 0 0.00 0 15330 123 0 0
x_lock_depdocs_on_canc_sup_ord 394 394 0 0.00 0 22144 506 0 0
x_make_qstorno_1000_1200 5322 5322 0 0.00 2 44419 1266 0 0
x_make_qstorno_1200_2000 5406 5406 0 0.00 3 86834 3335 0 0
x_make_qstorno_2100_3300 459548 459548 0 0.00 0 79054 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-03-2021 19:29:56 to 13-03-2021 19:30:00.

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:28 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:34 18914 8192000000 10245316752 10551910400 806678064 8.964 64 53 108 0 827279984 2302368 18299552
16:58:01 42108 8192000000 10361266016 10677370880 1398655520 14.583 100 90 180 1 1433348800 5560752 29132528
16:58:55 8245 8192000000 10375331424 10695114752 1429851424 14.860 100 92 184 0 1467553008 7262560 30439024
16:59:11 23441 8192000000 10407718624 10731909120 1451497856 15.051 100 91 182 0 1489836176 8323056 30015264
16:59:59 14996 8192000000 10421251504 10750205952 1479894048 15.300 100 91 182 0 1518320752 9276048 29150656
17:00:25 23015 8192000000 10442858128 10771345408 1491560384 15.403 100 98 196 1 1533327952 10078192 31689376
17:00:59 20688 8192000000 10445997184 10782400512 1501829936 15.492 100 87 174 0 1540151504 10407392 27914176
17:01:31 18426 8192000000 10474497072 10821513216 1530358896 15.740 100 74 148 0 1564147248 10334176 23454176
17:01:58 10475 8192000000 10522702032 10868895744 1577975056 16.151 100 85 171 0 1614960432 10817696 26167680
17:02:18 14379 8192000000 10549403264 10905190400 1590448752 16.258 100 78 156 0 1626195952 11199728 24547472
17:02:42 1960 8192000000 10562101904 10916708352 1619517312 16.506 100 85 170 0 1657443312 11851152 26074848
17:02:51 11453 8192000000 10571059040 10934972416 1628224688 16.580 100 75 152 1 1663176096 11713072 23238336
17:03:10 12047 8192000000 10603781824 10964721664 1651631296 16.778 100 83 166 2 1689561104 12744400 25185408
17:03:32 9093 8192000000 10614177072 10978168832 1672086816 16.951 100 80 160 0 1708363712 12783488 23493408
17:03:50 9535 8192000000 10617856624 10989780992 1681665840 17.031 100 72 144 1 1715417408 12167248 21584320
17:04:09 7532 8192000000 10648424816 11020759040 1708606064 17.257 100 82 162 1 1744996528 12679952 23710512
17:04:26 6948 8192000000 10662256704 11032641536 1721926096 17.368 100 82 164 3 1758791600 13713872 23151632
17:04:40 5422 8192000000 10675770128 11050893312 1739678576 17.516 100 81 162 0 1779646080 17023216 22944288
17:04:54 5756 8192000000 10684812624 11067179008 1752565360 17.623 100 75 151 0 1786148816 12343840 21239616
17:05:10 5866 8192000000 10709425904 11085201408 1764904528 17.725 100 81 162 1 1800369808 12343024 23122256
17:05:25 4567 8192000000 10704277680 11085242368 1769911600 17.766 100 76 152 1 1804761968 12800464 22049904
17:05:37 3474 8192000000 10717616928 11097034752 1777879696 17.832 100 81 161 0 1813285888 12726544 22679648
17:05:48 4167 8192000000 10729920640 11109081088 1789951344 17.931 100 84 169 0 1825583056 12672176 22959536
17:05:59 2736 8192000000 10731190576 11113623552 1795506384 17.977 100 88 174 1 1833977280 13884016 24586880
17:06:09 9704 8192000000 10723032416 11113586688 1796817744 17.988 100 67 134 4 1829166400 13346752 19001904
17:06:26 3708 8192000000 10750461376 11137114112 1816399744 18.148 100 81 162 1 1852262048 13121696 22740608
17:06:36 1807 8192000000 10767548720 11148849152 1823318480 18.205 100 84 166 0 1858179808 11933280 22928048
17:06:47 2682 8192000000 10768568144 11155042304 1830378128 18.262 100 84 166 1 1865603472 11532800 23692544
17:06:56 2740 8192000000 10781454256 11171000320 1841086688 18.350 100 92 182 1 1880271376 12906864 26277824
17:07:05 2040 8192000000 10789844880 11176448000 1852428608 18.442 100 86 174 1 1889336016 12603968 24303440
17:07:14 3316 8192000000 10792032080 11179790336 1854625600 18.460 100 87 173 3 1892436640 12698000 25113040
17:07:24 2215 8192000000 10804117120 11192246272 1856739056 18.477 100 92 182 0 1896265168 13720640 25805472
17:07:33 2150 8192000000 10805790448 11192938496 1861175440 18.513 100 93 186 1 1902375216 14765408 26434368
17:07:42 2014 8192000000 10801328048 11193372672 1859165312 18.497 100 84 166 0 1896401328 13388400 23847616
17:07:51 1431 8192000000 10806674032 11191848960 1861666592 18.517 100 95 190 3 1903538304 13582288 28289424
17:07:58 1864 8192000000 10800355072 11191119872 1862130720 18.521 100 89 178 0 1899840672 12860752 24849200
17:08:06 1958 8192000000 10806977904 11195777024 1863558128 18.532 100 89 178 1 1901501104 12278080 25664896
17:08:15 1512 8192000000 10808619040 11196952576 1864402032 18.539 100 87 170 1 1900689984 11356880 24931072
17:08:23 8139 8192000000 10784062048 11189760000 1860692512 18.509 100 54 104 0 1885021056 8957264 15371280
17:08:38 4858 8192000000 10792165424 11200909312 1868263232 18.570 100 64 129 4 1895903328 9930144 17709952
17:08:51 13987 8192000000 10801929136 11203211264 1872206880 18.602 100 65 128 0 1899634240 9523184 17904176
17:09:11 4070 8192000000 10811491728 11216805888 1880564032 18.670 100 80 160 1 1915030992 11791568 22675392
17:09:31 2287 8192000000 10819473024 11215523840 1880275344 18.667 100 77 147 1 1912032608 10062048 21695216
17:09:39 16425 8192000000 10776022384 11210063872 1874198672 18.618 100 33 65 1 1892511872 9037968 9275232
17:10:03 5686 8192000000 10779410032 11205619712 1874235136 18.619 100 29 57 3 1889261200 6227616 8798448
17:10:18 9701 8192000000 10797247664 11211653120 1877573984 18.646 100 45 90 0 1899665504 9389792 12701728
17:10:36 5251 8192000000 10779011424 11209367552 1873989904 18.617 100 27 54 3 1888731520 6956016 7785600
17:10:48 7361 8192000000 10794972048 11213127680 1874394368 18.620 100 29 57 1 1888847600 6820288 7632944
17:11:03 6946 8192000000 10776397264 11209359360 1873983552 18.616 100 25 50 1 1887870368 6790144 7096672
17:11:20 5787 8192000000 10784914976 11211190272 1874857056 18.624 100 29 58 4 1889950912 6374800 8719056
17:11:34 7029 8192000000 10786432512 11213778944 1876642432 18.638 100 31 62 2 1896630000 10842048 9145520
17:11:50 9443 8192000000 10781619664 11213864960 1874773872 18.623 100 21 40 1 1886698048 6199840 5724336
17:12:07 11041 8192000000 10781815248 11214446592 1875262592 18.627 100 16 31 3 1884927600 5557520 4107488
17:12:29 7879 8192000000 10783141360 11216572416 1878161216 18.650 100 17 34 2 1888503472 5616992 4725264
17:12:43 12218 8192000000 10787563840 11220701184 1883997888 18.697 100 25 51 2 1897030880 5851584 7181408
17:13:04 7859 8192000000 10795465872 11225165824 1887489184 18.726 100 23 44 4 1899720288 6321376 5909728
17:13:22 12200 8192000000 10821685632 11235102720 1890343920 18.749 100 14 28 1 1899488224 5243312 3900992
17:13:43 9329 8192000000 10795213504 11236331520 1898633824 18.815 100 29 58 1 1913381088 7017056 7730208
17:14:02 66818 8192000000 10812351536 11249405952 1901835792 18.841 100 28 56 0 1915527440 5564976 8126672
17:15:18 8871 8192000000 10815349808 11246989312 1903288224 18.853 100 24 48 0 1916231936 6265712 6678000
17:15:35 4538 8192000000 10820870160 11254018048 1902288832 18.845 100 26 51 2 1915945520 6535440 7121248
17:15:48 5042 8192000000 10824839808 11256496128 1905914080 18.874 100 25 50 1 1919851920 6648784 7289056
17:16:01 9523 8192000000 10818815984 11255910400 1890027120 18.746 99 17 34 0 1900532864 5413136 5092608
17:16:17 10135 8192000000 10816544560 11252776960 1888570272 18.734 99 25 50 1 1901167584 5556000 7041312
17:16:34 7467 8192000000 10829593696 11261501440 1910462336 18.910 100 22 44 0 1922739008 5692576 6584096
17:16:49 9731 8192000000 10797640432 11231412224 1854019424 18.455 97 20 40 1 1869848736 10341328 5487984
17:17:05 10463 8192000000 10775627168 11207405568 1838898832 18.332 97 25 48 3 1851878032 6214272 6764928
17:17:24 5887 8192000000 10794763552 11223302144 1877473440 18.645 100 25 49 1 1890873744 5841184 7559120
17:17:38 8532 8192000000 10789998128 11227312128 1864312256 18.538 99 21 42 4 1875122176 4921440 5888480
17:17:53 9120 8192000000 10790523696 11222618112 1862671424 18.525 99 14 28 0 1871971728 5309120 3991184
17:18:09 13589 8192000000 10745160080 11173724160 1792392080 17.951 97 19 38 0 1803410928 5579216 5439632
17:18:34 65928 8192000000 10766662896 11182329856 1781429568 17.861 96 32 64 1 1796477280 5310160 9737552
17:19:46 22069 8192000000 10740051632 11161059328 1722198208 17.371 93 19 38 0 1732429312 4980064 5251040
17:20:16 5834 8192000000 10718699840 11132633088 1767208912 17.744 97 36 72 0 1784216768 6884688 10123168
17:20:29 6332 8192000000 10692091856 11100581888 1692703264 17.124 95 25 50 2 1713294576 13839728 6751584
17:20:42 5943 8192000000 10691696944 11101208576 1770284864 17.769 100 31 62 1 1786017120 7424800 8307456
17:20:54 7390 8192000000 10706328432 11123761152 1785402272 17.894 100 22 44 1 1797497328 5192608 6902448
17:21:12 7714 8192000000 10697475664 11116511232 1740748240 17.525 97 40 82 2 1757345168 5186272 11410656
17:21:27 7606 8192000000 10708406688 11118309376 1756603872 17.656 98 38 75 0 1773671184 6697696 10369616
17:21:45 10091 8192000000 10697496560 11109982208 1732440192 17.456 96 26 51 1 1745192016 5345632 7406192
17:22:04 6336 8192000000 10731038688 11140087808 1776851808 17.824 98 45 90 2 1795744384 5367328 13525248
17:22:17 8580 8192000000 10721728448 11143839744 1810590784 18.101 100 25 50 2 1823704736 5293712 7820240
17:22:36 10025 8192000000 10738294832 11160993792 1803681328 18.044 99 20 40 1 1814840560 5336944 5822288
17:22:55 9067 8192000000 10751536768 11174055936 1833745968 18.290 100 34 70 0 1850044480 5504032 10794480
17:23:14 8744 8192000000 10751261376 11171889152 1831831456 18.274 100 26 52 0 1845061504 5433840 7796208
17:23:29 50469 8192000000 10756609744 11174567936 1821634240 18.191 99 34 67 2 1836547888 5394960 9518688
17:24:34 18553 8192000000 10769646720 11189243904 1844569360 18.378 100 27 55 0 1858371392 5403568 8398464
17:24:59 10867 8192000000 10760119776 11189456896 1848345920 18.409 100 13 26 0 1856571760 4720064 3505776
17:25:18 7415 8192000000 10776872720 11198636032 1853820176 18.453 100 30 60 3 1868878848 6215088 8843584
17:25:36 8775 8192000000 10775416624 11200634880 1858044384 18.487 100 32 63 1 1873590848 5512672 10033792
17:25:55 9465 8192000000 10781253040 11203952640 1860909296 18.511 100 30 60 1 1875447872 6032208 8506368
17:26:11 9241 8192000000 10771606960 11202965504 1859891792 18.502 100 23 45 3 1872041296 5517376 6632128
17:26:26 8779 8192000000 10768589744 11204304896 1862086384 18.520 100 25 51 0 1874927056 5342320 7498352
17:26:45 7933 8192000000 10779467744 11214979072 1869493952 18.580 100 26 52 0 1891808304 15053712 7260640
17:27:01 10881 8192000000 10809734016 11231842304 1881283856 18.675 100 22 44 0 1892501296 4754832 6462608
17:27:19 9743 8192000000 10820530480 11239763968 1892535744 18.766 100 28 55 2 1905392544 4809968 8046832
17:27:57 33172 8192000000 10841024048 11259150336 1902238512 18.844 100 31 62 2 1916690768 5508688 8943568
17:28:37 6023 8192000000 10859156384 11271970816 1917640336 18.968 100 53 106 0 1943061648 10034912 15386400
17:28:50 3873 8192000000 10858510304 11277893632 1923698672 19.016 100 60 121 1 1953296864 11706336 17891856
17:29:04 21774 8192000000 10856795056 11275227136 1927336784 19.046 100 44 88 1 1951908752 11100848 13471120
17:29:40 92983 8192000000 10857502720 11290693632 1912636208 18.928 99 44 88 1 1942746480 17203152 12907120
17:31:20 8667 8192000000 10838817824 11272880128 1906296960 18.877 99 40 80 1 1934818128 16835744 11685424
17:31:36 8521 8192000000 10858089216 11291983872 1927293920 19.045 100 39 73 2 1951932784 13605328 11033536
17:31:51 9971 8192000000 10872013472 11303948288 1934245168 19.101 100 41 82 2 1961028112 14917040 11865904
17:32:10 8326 8192000000 10879834544 11306033152 1939714944 19.144 100 37 74 1 1965569552 15479984 10374624
17:32:30 11753 8192000000 10891975920 11323936768 1955850112 19.273 100 58 114 2 1987770368 15137328 16782928
17:32:52 29984 8192000000 10911119920 11339911168 1963365920 19.333 100 64 128 0 2000228672 18024176 18838576
17:33:32 10225 8192000000 10921881312 11349237760 1968036528 19.370 100 49 97 0 2003925920 21712720 14176672
17:33:51 4503 8192000000 10912935792 11335524352 1953215728 19.252 99 61 123 1 1992784624 21824880 17744016
17:34:06 13739 8192000000 10919522416 11350548480 1969971952 19.385 100 55 110 0 2008941600 22411216 16558432
17:34:42 8781 8192000000 10947464544 11367215104 1983610128 19.493 100 64 128 1 2026370832 23642112 19118592
17:34:57 9948 8192000000 10944799376 11371577344 1988995344 19.536 100 59 118 0 2031096560 24982704 17118512
17:35:16 1618 8192000000 10944067504 11365707776 1981057664 19.473 100 73 143 1 2026415792 25009184 20348944
17:35:27 10274 8192000000 10945128368 11368374272 1980104896 19.466 100 75 146 3 2027681360 25376976 22199488
17:35:58 8816 8192000000 10942913744 11377352704 1994936128 19.583 100 66 132 0 2040547472 25773488 19837856
17:36:16 8481 8192000000 10951529248 11383877632 1996157808 19.592 100 55 110 1 2038554160 25986400 16409952
17:36:36 9310 8192000000 10953655856 11384557568 1995749216 19.589 100 56 112 2 2041197792 28994496 16454080
17:36:54 6251 8192000000 10959359024 11373813760 1985582848 19.509 99 75 151 1 2038525056 29967408 22974800
17:37:07 5187 8192000000 10971968784 11394998272 2007339056 19.681 100 76 153 1 2061654032 31515600 22799376
17:37:23 4274 8192000000 10965006416 11382124544 1990693520 19.549 99 70 138 1 2041727248 30575472 20458256
17:37:37 5957 8192000000 10969970096 11395084288 2005397776 19.665 100 73 146 0 2058979280 32041360 21540144
17:37:52 18026 8192000000 10959568528 11387465728 1998505120 19.611 100 59 118 2 2048501552 32266352 17730080
17:38:17 6862 8192000000 10973416496 11402014720 2008151728 19.687 100 67 134 1 2063329120 34016512 21160880
17:38:33 4699 8192000000 10947823552 11377438720 1969909776 19.385 98 65 128 1 2024389472 35151344 19328352
17:38:45 2909 8192000000 10978823104 11398205440 2006453312 19.674 100 70 135 1 2061576704 34180016 20943376
17:38:56 5006 8192000000 10978741744 11403505664 2007255408 19.680 100 75 149 2 2066582336 36040464 23286464
17:39:13 2559 8192000000 10985438080 11409940480 2013573568 19.730 100 80 158 1 2075116240 37131824 24410848
17:39:25 9536 8192000000 10977775856 11406561280 1993423776 19.571 99 68 136 2 2052295888 37493184 21378928
17:39:43 6907 8192000000 10987591136 11418124288 2014968512 19.741 100 71 140 0 2076862768 40288928 21605328
17:40:00 5618 8192000000 10986694256 11421843456 2016187920 19.750 100 61 123 0 2077255760 41721440 19346400
17:40:14 5721 8192000000 10992338000 11421425664 2018902960 19.772 100 73 146 0 2084083840 42403072 22777808
17:40:34 6751 8192000000 11015492288 11438948352 2026291696 19.830 100 70 137 1 2090372592 42279536 21801360
17:40:47 3123 8192000000 11022289408 11447033856 2035843056 19.904 100 85 169 2 2109399536 46648928 26907552
17:40:57 16547 8192000000 11012043552 11446538240 2034962272 19.898 100 68 136 1 2101544464 45479424 21102768
17:41:29 6893 8192000000 11023960704 11453124608 2030739360 19.864 100 64 128 3 2102723968 51358960 20625648
17:41:47 3517 8192000000 11029050384 11460636672 2038375632 19.924 100 63 125 0 2109677264 51464864 19836768
17:41:59 3487 8192000000 11038303456 11467530240 2047012976 19.992 100 83 166 0 2125514464 52640416 25861072
17:42:10 2894 8192000000 11027710256 11445379072 2019151216 19.773 98 85 170 0 2099820304 54581376 26087712
17:42:21 2773 8192000000 11040606480 11467841536 2042971184 19.960 100 77 153 1 2121128752 54830000 23327568
17:42:32 1330 8192000000 11060634496 11482779648 2055692832 20.060 100 93 185 1 2139330384 56013824 27623728
17:42:39 1472 8192000000 11047458016 11467689984 2043501392 19.964 100 87 169 4 2127697248 57430128 26765728
17:42:54 3634 8192000000 11055164928 11483873280 2052858704 20.037 100 85 170 3 2137421600 57585536 26977360
17:43:07 2381 8192000000 11031175712 11456614400 2026386464 19.830 99 79 160 1 2108836976 57394528 25055984
17:43:19 2008 8192000000 11031139168 11450048512 2016312640 19.751 99 92 182 1 2096533968 51884400 28336928
17:43:29 2800 8192000000 11016763664 11436810240 2011357008 19.712 99 73 146 0 2087898432 53856544 22684880
17:43:40 9026 8192000000 11013412448 11442528256 2019740848 19.778 100 74 148 1 2097882992 54762512 23379632
17:44:02 8839 8192000000 11013701760 11441844224 2018597696 19.769 100 68 136 2 2093753696 53553872 21602128
17:44:27 2769 8192000000 10997167792 11422797824 1989664016 19.541 99 69 137 0 2067153040 54765648 22723376
17:44:42 3345 8192000000 11004840720 11422429184 1998244032 19.609 100 78 154 1 2082302624 59981968 24076624
17:44:53 2830 8192000000 11017793248 11438997504 2006927184 19.677 100 81 161 1 2095435952 63088144 25420624
17:45:02 2014 8192000000 11028129984 11445956608 2019027616 19.773 100 90 178 0 2109795072 62508096 28259360
17:45:15 1921 8192000000 11027167024 11444916224 2021259376 19.790 100 84 169 1 2106532688 58782400 26490912
17:45:23 1985 8192000000 11029644960 11447066624 2018947024 19.772 100 88 176 0 2105815696 59080368 27788304
17:45:32 3877 8192000000 11033213968 11453624320 2022486336 19.800 100 87 174 1 2107560400 57501200 27572864
17:45:42 3243 8192000000 11014012352 11435077632 2011117184 19.710 100 84 167 1 2096129744 59391856 25620704
17:45:55 2825 8192000000 11024924064 11444293632 2011054144 19.710 100 77 153 1 2097831136 61310512 25466480
17:46:08 3066 8192000000 11023052496 11441786880 2013862192 19.732 100 81 161 1 2102647664 63320864 25464608
17:46:22 3183 8192000000 11019936192 11437490176 1996673296 19.596 99 89 177 3 2088842400 63655600 28513504
17:46:31 2228 8192000000 11005079808 11426959360 1986661600 19.517 99 86 170 1 2077808304 63741760 27404944
17:46:41 2452 8192000000 11007823008 11428048896 1998473168 19.611 100 82 162 2 2090345216 65509648 26362400
17:46:51 2471 8192000000 11016946416 11435675648 2001913312 19.638 100 78 156 1 2094642208 67011232 25717664
17:47:00 1728 8192000000 11009601504 11429687296 1995797648 19.590 100 82 165 2 2089838496 67114416 26926432
17:47:10 4663 8192000000 11008777328 11436437504 1996845008 19.598 100 72 144 0 2090070080 69483072 23742000
17:47:27 4352 8192000000 11009477136 11428782080 1993985584 19.575 100 77 154 2 2088792944 68987216 25820144
17:47:38 7198 8192000000 11005933376 11440066560 1998888416 19.614 100 66 129 1 2092725360 71402320 22434624
17:48:04 2486 8192000000 11002777712 11427520512 1985686752 19.510 100 74 148 0 2083352160 72509376 25156032
17:48:14 9244 8192000000 10983744032 11424235520 1978190960 19.450 100 54 108 1 2072238192 75320096 18727136
17:48:31 6368 8192000000 10970081968 11419389952 1962546176 19.326 99 44 88 2 2047381264 68463040 16372048
17:48:47 7192 8192000000 10981021824 11414028288 1981392384 19.476 100 54 107 0 2062872608 63412736 18067488
17:49:03 7747 8192000000 10979037456 11423834112 1981317088 19.475 100 45 88 1 2054237984 57245632 15675264
17:49:19 24506 8192000000 10961404144 11406794752 1958932976 19.298 99 29 58 2 2028995408 59530176 10532256
17:49:50 20021 8192000000 10945211920 11397103616 1937571792 19.127 98 30 60 1 2004479632 56453280 10454560
17:50:23 9913 8192000000 10939593632 11386789888 1948272720 19.213 99 28 55 3 2008759328 51273056 9213552
17:50:48 7601 8192000000 10927344464 11372126208 1950012560 19.227 100 34 68 2 2012620000 51205696 11401744
17:51:11 18199 8192000000 10905403904 11341619200 1912070336 18.923 98 30 60 2 1973382608 50497968 10814304
17:51:38 28260 8192000000 10917622128 11353505792 1914459536 18.942 99 32 64 2 1990161456 63900064 11801856
17:52:12 23917 8192000000 10924143920 11381108736 1936213968 19.117 100 27 53 3 2011000688 64264448 10522272
17:52:46 31017 8192000000 10915267456 11377729536 1937393040 19.126 100 20 40 1 2008309248 62815008 8101200
17:53:27 19446 8192000000 10925874944 11390177280 1947386800 19.206 100 20 40 1 2002702720 48556128 6759792
17:53:53 10361 8192000000 10912765920 11362406400 1925279888 19.029 99 21 42 1 1980160400 47636416 7244096
17:54:11 18197 8192000000 10892044736 11350347776 1908741600 18.897 98 26 52 2 1957693920 40368720 8583600
17:54:35 42717 8192000000 10859067344 11309084672 1876473696 18.637 97 20 40 2 1896289664 13724384 6091584
17:55:24 86716 8192000000 10874438080 11314520064 1909471568 18.902 99 44 82 1 1932969696 10897984 12600144
17:57:21 19765 8192000000 10865075056 11311452160 1909854928 18.905 98 54 106 1 1940314960 14832928 15627104
17:57:49 40845 8192000000 10847359600 11321966592 1913659520 18.936 99 18 36 1 1937348864 18705552 4983792
18:00:45 97200 8192000000 10839694608 11298541568 1845121248 18.382 95 19 38 2 1857597152 7235088 5240816
18:02:40 48928 8192000000 10855271344 11318059008 1930105712 19.068 100 17 34 1 1942764640 7613200 5045728
18:03:52 128648 8192000000 10867863072 11329425408 1899016192 18.818 98 35 70 3 1914813680 6341040 9456448
18:06:17 110775 8192000000 10858666736 11316977664 1880699344 18.671 97 18 35 1 1897801808 12122832 4979632
18:08:13 64948 8192000000 10852994624 11312992256 1904697408 18.864 98 19 38 0 1919465696 9908896 4859392
18:09:30 42018 8192000000 10841272240 11300941824 1920932336 18.994 99 20 40 1 1936959248 10140896 5886016
18:11:01 43529 8192000000 10905616880 11358998528 1961435120 19.317 100 27 54 1 1981544880 12528832 7580928
18:11:54 23564 8192000000 10909603456 11362476032 1977994720 19.449 100 31 61 0 2000752224 13565040 9192464
18:12:33 64490 8192000000 10902918272 11374993408 1961312880 19.316 99 25 51 0 1984903536 15592416 7998240
18:13:53 22735 8192000000 10900572128 11382788096 1965502000 19.350 100 16 32 1 1997469696 26704384 5263312
18:14:34 10649 8192000000 10890946208 11381329920 1964520208 19.342 100 8 17 0 1989064928 22218192 2326528
18:14:55 23264 8192000000 10873108368 11358298112 1959182288 19.300 100 6 12 1 1976630496 15673168 1775040
18:15:27 43950 8192000000 10890787408 11360829440 1968370624 19.373 100 15 31 0 1983440192 10618224 4451344
18:17:06 122431 8192000000 10889371360 11381575680 1962865040 19.329 100 9 18 0 1983699760 17961296 2873424
18:19:15 47706 8192000000 10889027888 11385036800 1945621904 19.192 99 3 6 0 1968462064 22165776 674384
18:20:09 16657 8192000000 10885940896 11385970688 1961009712 19.314 100 4 8 1 1983590016 20997088 1583216
18:20:33 36873 8192000000 10887025840 11363897344 1968038112 19.370 100 11 22 0 1981871648 11103888 2729648
18:21:25 50203 8192000000 10909131952 11375443968 1963083744 19.331 99 28 56 0 1983862208 13083504 7694960
18:22:31 87460 8192000000 10881101776 11360763904 1916024784 18.955 97 9 18 1 1930407856 12235424 2147648
18:24:05 37197 8192000000 10912925360 11368284160 1951828496 19.241 99 23 46 0 1965347920 7197424 6322000
18:24:54 17094 8192000000 10913686272 11376586752 1977157728 19.442 100 32 63 1 1994673632 8709072 8806832
18:25:18 41639 8192000000 10916932048 11383779328 1987055280 19.521 100 42 85 1 2013635280 14502768 12077232
18:26:10 75951 8192000000 10907133184 11399454720 1970602976 19.390 99 20 40 0 1994446944 18010720 5833248
18:27:34 41472 8192000000 10910064528 11374981120 1945478608 19.190 98 14 28 0 1958534000 9671936 3383456
18:28:25 25609 8192000000 10896061280 11357626368 1918135088 18.972 97 15 30 0 1930101680 8226592 3740000
18:29:01 52248 8192000000 10909272400 11387461632 1981474240 19.476 100 29 58 1 2000309232 10944960 7890032
18:29:59 57602 8192000000 10917045536 11379277824 1926645904 19.040 97 13 26 1 1945520848 15260736 3614208
18:31:09 44260 8192000000 10915935344 11390595072 1965528720 19.350 100 14 28 1 1993022288 23089104 4404464
18:32:04 26548 8192000000 10911409872 11376185344 1915119168 18.948 97 6 13 1 1935846288 18475424 2251696
18:32:41 41180 8192000000 10900398112 11369103360 1908708128 18.896 97 10 20 1 1927600544 15791648 3100768
18:33:30 70685 8192000000 10905202848 11380092928 1914509504 18.943 97 14 28 0 1933618832 15338032 3771296
18:34:47 105112 8192000000 10870080544 11333931008 1794264672 17.967 91 18 36 2 1811854016 12618976 4970368
18:36:44 85938 8192000000 10892106896 11348471808 1949593184 19.223 100 16 32 1 1963848528 9600640 4654704
18:38:23 91380 8192000000 10868283856 11338387456 1901467152 18.838 97 15 29 2 1915649712 9978544 4204016
18:40:05 13542 8192000000 10856551312 11320070144 1910052160 18.907 98 26 52 0 1925624816 8930560 6642096
18:40:25 17511 8192000000 10865940976 11316346880 1911780384 18.921 99 35 72 0 1928993616 7587328 9625904
18:41:00 38489 8192000000 10857632288 11327315968 1917063408 18.963 99 15 30 2 1930634640 8312704 5258528
18:41:49 37652 8192000000 10824113616 11276718080 1782230928 17.868 92 24 47 1 1796820672 8567408 6022336
18:42:38 37474 8192000000 10840552800 11302633472 1879271376 18.659 98 14 28 1 1895905424 12923504 3710544
18:43:21 45662 8192000000 10855753488 11323715584 1914729120 18.945 99 19 38 2 1930693248 10388560 5575568
18:44:13 74612 8192000000 10846542208 11323224064 1917967376 18.971 99 16 30 1 1934254416 11757584 4529456
18:45:34 38208 8192000000 10846048000 11322884096 1909282976 18.901 99 16 32 0 1927411744 13589536 4539232
18:46:19 46251 8192000000 10847165344 11327692800 1926756320 19.041 100 14 28 3 1938012416 7458752 3797344
18:47:11 43529 8192000000 10822975056 11285725184 1825345184 18.221 95 13 26 0 1834506640 5733088 3428368
18:48:09 65343 8192000000 10836640240 11314216960 1884779072 18.704 98 8 17 0 1898223440 11192064 2252304
18:49:37 34413 8192000000 10857937488 11315748864 1924508384 19.023 100 37 74 0 1947411408 12727968 10175056
18:50:18 39915 8192000000 10842690800 11307642880 1864545584 18.540 97 24 48 3 1880295104 8743456 7006064
18:51:06 38194 8192000000 10882983904 11328032768 1931154464 19.076 100 21 41 2 1950540928 13548576 5837888
18:51:53 39617 8192000000 10844748944 11296911360 1893944944 18.778 98 37 74 2 1918944176 14452768 10546464
18:52:40 42306 8192000000 10850241472 11319541760 1904599296 18.863 99 22 44 1 1928437536 17344096 6494144
18:53:34 85928 8192000000 10849257968 11307180032 1849925936 18.422 96 19 38 3 1870808384 15609616 5272832
18:55:07 108393 8192000000 10864830944 11332759552 1889071824 18.738 98 25 50 1 1906340064 9937856 7330384
18:57:32 23559 8192000000 10886687088 11334230016 1942872000 19.170 100 46 92 0 1964061648 9050240 12139408
18:58:04 72368 8192000000 10882106560 11353845760 1933359616 19.094 99 14 28 1 1948732368 11847648 3525104
18:59:24 123547 8192000000 10882584800 11339440128 1918544016 18.975 98 18 36 0 1936815936 12964896 5307024
19:01:38 54741 8192000000 10870843888 11343908864 1922711680 19.009 98 26 52 2 1938255408 8305456 7238272
19:02:39 56170 8192000000 10856308736 11328667648 1893988048 18.778 97 6 12 0 1903144496 7711872 1444576
19:03:45 68709 8192000000 10865103376 11337596928 1949849984 19.225 100 12 23 1 1960030160 6885440 3294736
19:05:04 83987 8192000000 10890413664 11376738304 1971345152 19.396 100 10 19 0 1985219536 10687664 3186720
19:06:34 73349 8192000000 10893988736 11379752960 1963094048 19.331 99 14 29 3 1980096816 12010224 4992544
19:07:54 98940 8192000000 10903114544 11363495936 1913887440 18.938 97 14 28 2 1925144896 7360304 3897152
19:09:43 57134 8192000000 10919404032 11385229312 1989137712 19.537 100 27 54 4 2006790848 9928048 7725088
19:10:49 52335 8192000000 10873258400 11349651456 1921001760 18.995 97 25 50 2 1940633248 11739760 7891728
19:11:54 52465 8192000000 10904510512 11376050176 1956154368 19.275 99 23 46 0 1978456752 15839696 6462688
19:12:57 70160 8192000000 10902410288 11381227520 1954548368 19.263 99 17 34 1 1979290512 19620912 5121232
19:14:21 90361 8192000000 10887402448 11362316288 1870768224 18.590 95 11 22 0 1886488464 12212336 3507904
19:15:58 59870 8192000000 10896018432 11370680320 1956254560 19.276 99 17 34 1 1970914048 9854272 4805216
19:17:05 71232 8192000000 10912584112 11372703744 1916324224 18.957 97 24 48 1 1932477248 9777808 6375216
19:18:29 40650 8192000000 10923158176 11386089472 1979896112 19.464 100 38 76 1 2000534432 9773536 10864784
19:19:17 14373 8192000000 10899799792 11360292864 1941846496 19.161 98 45 90 0 1966457840 11148432 13462912
19:19:40 20882 8192000000 10898101536 11351846912 1936793104 19.121 99 39 78 1 1957961888 10622784 10546000
19:20:09 16691 8192000000 10887572512 11346419712 1916603280 18.960 98 44 88 1 1941055712 12667840 11784592
19:20:32 96640 8192000000 10878851232 11347906560 1932263056 19.085 99 34 68 0 1953312384 11480384 9568944
19:22:15 93183 8192000000 10851055760 11341135872 1859905024 18.503 95 22 44 0 1874159376 7576384 6677968
19:24:10 17872 8192000000 10845484080 11325313024 1921324576 18.997 99 16 30 3 1934923728 9194640 4404512
19:24:51 50788 8192000000 10848387936 11326902272 1900601200 18.831 98 19 38 1 1915003568 8733584 5668784
19:25:52 38676 8192000000 10858164080 11337740288 1940416528 19.150 100 15 29 0 1953203152 8475936 4310688
19:26:37 48348 8192000000 10768430000 11240239104 1833547920 18.288 94 12 25 1 1849527680 12487712 3492048

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 13-03-2021 19:30:02 to 13-03-2021 19:30:34.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 75 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:02, from 13-03-2021 19:30:35 to 13-03-2021 19:30:37.

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          239276
MON$OLDEST_ACTIVE               240084
MON$OLDEST_SNAPSHOT             240084
MON$NEXT_TRANSACTION            240084
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                       2010496
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:15: 
:16: mscs-test-161.budzdorov.ru    Sat Mar 13 19:27:40 2021
:17:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:18: 
:19: 
:20: mscs-test-161.budzdorov.ru    Sat Mar 13 19:27:40 2021
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
--- end of diff output ---

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

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