Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.03.2021 01: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 17642608 kB
MemAvailable 31567224 kB
Buffers 0 kB
Cached 14009548 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-11 01:27:22
DTS_END                         2021-03-11 01:27:22.4370
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/45516
TRN_ID                          227160
ATT_ID                          620
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: 9109.57 29353 1093148
customer order: creation 158.22 393 18986
customer order: refuse 13.78 382 1654
order to supplier: creation 42.52 1289 5102
order to supplier: removal 3.38 111019 405
invoice (draft): creation 43.01 3381 5161
invoice (draft): removal 52.90 809 6348
invoice accept: apply 40.00 21360 4800
invoice accept: cancel 48.39 902 5807
customer reserve: creation 3708.28 211 444994
customer reserve: removal 4719.98 62 566397
realization accept: apply 78.34 197 9401
realization accept: cancel 80.42 117 9650
payment from customer: creation 55.54 135 6665
payment from customer: removal 5.13 97 616
payment to supplier: creation 45.33 156 5440
payment to supplier: removal 2.98 83 358
service: total inventory turnovers 4.32 982 518
service: total monetary turnovers 6.25 27 750
service: aggregate perf. data 0.77 18433 92
service: refresh index statistics 0.03 427032 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-03-2021 01:28:28 to 11-03-2021 01:28:30.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6773
TEST_TIME 2 6886
TEST_TIME 3 6501
TEST_TIME 4 6885
TEST_TIME 5 7125
TEST_TIME 6 7081
TEST_TIME 7 7081
TEST_TIME 8 6811
TEST_TIME 9 6853
TEST_TIME 10 6919
TEST_TIME 11 6906
TEST_TIME 12 7079
TEST_TIME 13 7645
TEST_TIME 14 7619
TEST_TIME 15 7789
TEST_TIME 16 7766
TEST_TIME 17 7948
TEST_TIME 18 7993
TEST_TIME 19 8494
TEST_TIME 20 9477
TEST_TIME 21 9548
TEST_TIME 22 9614
TEST_TIME 23 9512
TEST_TIME 24 9967
TEST_TIME 25 10481
TEST_TIME 26 11073
TEST_TIME 27 11148
TEST_TIME 28 10835
TEST_TIME 29 10719
TEST_TIME 30 10757
TEST_TIME 31 10494
TEST_TIME 32 10215
TEST_TIME 33 10196
TEST_TIME 34 10093
TEST_TIME 35 9960
TEST_TIME 36 9896
TEST_TIME 37 9867
TEST_TIME 38 10028
TEST_TIME 39 9813
TEST_TIME 40 9799
TEST_TIME 41 9758
TEST_TIME 42 9701
TEST_TIME 43 9606
TEST_TIME 44 9716
TEST_TIME 45 9639
TEST_TIME 46 9542
TEST_TIME 47 9564
TEST_TIME 48 9671
TEST_TIME 49 9605
TEST_TIME 50 9599
TEST_TIME 51 9742
TEST_TIME 52 9661
TEST_TIME 53 9615
TEST_TIME 54 9625
TEST_TIME 55 9635
TEST_TIME 56 9576
TEST_TIME 57 9761
TEST_TIME 58 9655
TEST_TIME 59 9520
TEST_TIME 60 9470
TEST_TIME 61 9423
TEST_TIME 62 9426
TEST_TIME 63 9337
TEST_TIME 64 9337
TEST_TIME 65 9285
TEST_TIME 66 9184
TEST_TIME 67 9176
TEST_TIME 68 9306
TEST_TIME 69 9325
TEST_TIME 70 9451
TEST_TIME 71 9432
TEST_TIME 72 9475
TEST_TIME 73 9436
TEST_TIME 74 9404
TEST_TIME 75 9452
TEST_TIME 76 9413
TEST_TIME 77 9485
TEST_TIME 78 9461
TEST_TIME 79 9457
TEST_TIME 80 9464
TEST_TIME 81 9434
TEST_TIME 82 9367
TEST_TIME 83 9350
TEST_TIME 84 9288
TEST_TIME 85 9281
TEST_TIME 86 9278
TEST_TIME 87 9244
TEST_TIME 88 9203
TEST_TIME 89 9149
TEST_TIME 90 9094
TEST_TIME 91 9147
TEST_TIME 92 9159
TEST_TIME 93 9208
TEST_TIME 94 9250
TEST_TIME 95 9268
TEST_TIME 96 9277
TEST_TIME 97 9289
TEST_TIME 98 9341
TEST_TIME 99 9328
TEST_TIME 100 9335
TEST_TIME 101 9387
TEST_TIME 102 9402
TEST_TIME 103 9411
TEST_TIME 104 9381
TEST_TIME 105 9334
TEST_TIME 106 9277
TEST_TIME 107 9300
TEST_TIME 108 9254
TEST_TIME 109 9234
TEST_TIME 110 9202
TEST_TIME 111 9183
TEST_TIME 112 9142
TEST_TIME 113 9185
TEST_TIME 114 9196
TEST_TIME 115 9183
TEST_TIME 116 9170
TEST_TIME 117 9185
TEST_TIME 118 9196
TEST_TIME 119 9179
TEST_TIME 120 9125

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 11-03-2021 01:28:31 to 11-03-2021 01:28:35.

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 1501998 1501998 0 0.00 0 20011 7 0 0
doc_list_biud 1501996 1501996 0 0.00 0 50171 30 0 0
sp_add_invoice_to_stock 4991 4800 191 3.82 40 163387 21361 0 191
sp_cancel_adding_invoice 5807 5807 0 0.00 5 79182 902 0 0
sp_cancel_client_order 1654 1654 0 0.00 4 14098 382 0 0
sp_cancel_customer_reserve 566397 566397 0 0.00 1 50173 63 0 0
sp_cancel_pay_from_customer 616 616 0 0.00 3 7870 98 0 0
sp_cancel_pay_to_supplier 358 358 0 0.00 3 5919 83 0 0
sp_cancel_supplier_invoice 6363 6348 15 0.23 1 19723 809 0 15
sp_cancel_supplier_order 405 405 0 0.00 6 1136903 111020 0 0
sp_cancel_write_off 9650 9650 0 0.00 1 10479 117 0 0
sp_client_order 18986 18986 0 0.00 3 41753 394 0 0
sp_customer_reserve 444994 444994 0 0.00 0 93107 212 0 0
sp_fill_shopping_cart 29247 29247 0 0.00 1 20247 37 0 0
sp_fill_shopping_cart_clo_res 444972 444972 0 0.00 0 13285 15 0 0
sp_get_clo_for_invoice 4771 4771 0 0.00 0 41321 372 0 0
sp_kill_cost_storno 16431 16431 0 0.00 0 12720 65 0 0
sp_kill_qstorno_ret_qs2qd 1149197 1149197 0 0.00 0 50167 34 0 0
sp_kill_qty_storno 604431 604431 0 0.00 0 50171 73 0 0
sp_lock_selected_doc 19624 19624 0 0.00 0 8829 7 0 0
sp_make_cost_storno 26276 26276 0 0.00 0 14641 61 0 0
sp_multiply_rows_for_pdistr 26275 26275 0 0.00 0 7885 31 0 0
sp_multiply_rows_for_qdistr 18986 18986 0 0.00 0 19371 171 0 0
sp_pay_from_customer 6665 6665 0 0.00 4 12161 136 0 0
sp_pay_to_supplier 5440 5440 0 0.00 5 13110 156 0 0
sp_payment_common 12105 12105 0 0.00 1 11177 31 0 0
sp_qd_handle_on_cancel_clo 1654 1654 0 0.00 0 14092 342 0 0
sp_qd_handle_on_invoice_upd_sts 10576 10576 0 0.00 0 23255 355 0 0
sp_qd_handle_on_reserve_upd_sts 9401 9401 0 0.00 0 12771 60 0 0
sp_reserve_write_off 9401 9401 0 0.00 6 15814 197 0 0
sp_supplier_invoice 5161 5161 0 0.00 5 88959 3381 0 0
sp_supplier_order 5102 5102 0 0.00 5 31082 1289 0 0
srv_aggregate_perf_data 92 92 0 0.00 3003 124706 18434 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 849 141116 31511 0 0
srv_find_qd_qs_mism 1046682 1046682 0 0.00 0 20005 6 0 0
srv_make_invnt_saldo 518 518 0 0.00 57 26511 982 0 0
srv_make_money_saldo 750 750 0 0.00 1 1286 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 57590 654252 427032 0 0
t$perf-abend:sp_add_invoice_to_stock 191 191 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4800 4800 0 0.00 0 38182 179 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 0 12167 189 0 0
t$perf-norm:sp_cancel_client_order 1654 1654 0 0.00 0 2029 11 0 0
t$perf-norm:sp_cancel_customer_reserve 669 669 0 0.00 0 832 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 616 616 0 0.00 0 587 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 358 358 0 0.00 0 5106 18 0 0
t$perf-norm:sp_cancel_supplier_invoice 367 367 0 0.00 0 563 10 0 0
t$perf-norm:sp_cancel_supplier_order 405 405 0 0.00 0 23178 1539 0 0
t$perf-norm:sp_cancel_write_off 972 972 0 0.00 0 2024 10 0 0
t$perf-norm:sp_client_order 18986 18986 0 0.00 0 5706 18 0 0
t$perf-norm:sp_customer_reserve 880 880 0 0.00 0 907 4 0 0
t$perf-norm:sp_pay_from_customer 6665 6665 0 0.00 0 6375 12 0 0
t$perf-norm:sp_pay_to_supplier 5440 5440 0 0.00 0 8400 12 0 0
t$perf-norm:sp_reserve_write_off 9401 9401 0 0.00 0 8032 13 0 0
t$perf-norm:sp_supplier_invoice 5161 5161 0 0.00 0 11294 25 0 0
t$perf-norm:sp_supplier_order 5102 5102 0 0.00 0 12076 17 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 310 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 519 10 0 0
t$perf-norm:srv_make_invnt_saldo 518 518 0 0.00 0 2003 26 0 0
t$perf-norm:srv_make_money_saldo 750 750 0 0.00 0 6322 30 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 2 0 0
v_add_invoice_to_stock 9920 9538 382 3.85 0 10333 25 0 382
v_all_customers 35086 35086 0 0.00 0 24 1 0 0
v_all_suppliers 28564 28564 0 0.00 0 20 1 0 0
v_all_wares 37970 37970 0 0.00 0 49 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 2394 10 0 0
v_cancel_client_order 3308 3308 0 0.00 0 5098 12 0 0
v_cancel_customer_prepayment 1232 1232 0 0.00 0 2904 8 0 0
v_cancel_customer_reserve 1338 1338 0 0.00 0 2971 7 0 0
v_cancel_payment_to_supplier 716 716 0 0.00 0 1266 6 0 0
v_cancel_supplier_invoice 764 734 30 3.92 0 4504 20 0 30
v_cancel_supplier_order 810 810 0 0.00 0 2659 12 0 0
v_cancel_write_off 1944 1944 0 0.00 0 4939 24 0 0
v_max_id_clo_ord 5102 5102 0 0.00 0 292 1 0 0
v_max_id_clo_res 880 880 0 0.00 0 5665 13 0 0
v_max_id_ord_sup 5160 5160 0 0.00 0 3973 4 0 0
v_max_non_paid_invoice 1420 1420 0 0.00 0 933 3 0 0
v_max_non_paid_realizn 3435 3435 0 0.00 0 4517 8 0 0
v_min_id_clo_ord 5102 5102 0 0.00 0 2760 6 0 0
v_min_id_clo_res 880 880 0 0.00 0 5540 26 0 0
v_min_id_ord_sup 5160 5160 0 0.00 0 5681 6 0 0
v_min_non_paid_invoice 5440 5440 0 0.00 0 10679 22 0 0
v_min_non_paid_realizn 6665 6665 0 0.00 0 10806 18 0 0
v_our_firm 9344 9344 0 0.00 0 15 1 0 0
v_reserve_write_off 18802 18802 0 0.00 0 15732 11 0 0
x_lock_depdocs_on_canc_invoice 11788 11788 0 0.00 0 15135 137 0 0
x_lock_depdocs_on_canc_sup_ord 405 405 0 0.00 0 22522 400 0 0
x_make_qstorno_1000_1200 5102 5102 0 0.00 1 31056 1208 0 0
x_make_qstorno_1200_2000 5161 5161 0 0.00 3 86403 3258 0 0
x_make_qstorno_2100_3300 444994 444994 0 0.00 0 93106 194 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-03-2021 01:28:36 to 11-03-2021 01:28:40.

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
22:57:26 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:32 10586 8192000000 10203088880 10501890048 885027392 9.750 71 47 92 0 902774896 2225168 15522336
22:57:51 32318 8192000000 10352284288 10669334528 1397464576 14.572 100 92 184 0 1432354304 5048880 29840848
22:58:37 21257 8192000000 10378324800 10697691136 1429095408 14.853 100 91 182 0 1466232240 7020576 30116256
22:59:07 19769 8192000000 10403010272 10728525824 1450876384 15.046 100 88 176 0 1487661952 7564816 29220752
22:59:39 15546 8192000000 10416453056 10746138624 1473136960 15.241 100 87 174 0 1509428912 8049152 28242800
23:00:06 18094 8192000000 10444839952 10778714112 1499232208 15.469 100 89 178 0 1536287584 8512624 28542752
23:00:41 18925 8192000000 10467626608 10807685120 1523631072 15.682 100 83 166 1 1558872816 9279728 25962016
23:01:13 18093 8192000000 10500971424 10845995008 1549494192 15.906 100 82 164 1 1585184496 9736528 25953776
23:01:38 19265 8192000000 10528279264 10875600896 1573579648 16.113 100 79 158 0 1608273344 10368592 24325104
23:02:11 15051 8192000000 10550069024 10902425600 1605837744 16.389 100 86 172 0 1643633024 11456976 26338304
23:02:34 12087 8192000000 10563670464 10916696064 1614258864 16.461 100 79 158 0 1649344048 11380976 23704208
23:02:54 13251 8192000000 10587676160 10946007040 1639428896 16.675 100 82 164 1 1675974240 12731904 23813440
23:03:16 4533 8192000000 10596270592 10959466496 1655727344 16.813 100 81 162 0 1692522464 12586256 24208864
23:03:28 10866 8192000000 10607841200 10973073408 1666602592 16.905 100 82 164 0 1703729312 12442976 24683744
23:03:46 11044 8192000000 10620369712 10986676224 1682506016 17.038 100 89 179 3 1721674352 12741152 26427184
23:04:05 7981 8192000000 10639916096 11008602112 1698636960 17.174 100 74 148 0 1732903952 12254320 22012672
23:04:19 8956 8192000000 10657279232 11025084416 1706747824 17.242 100 83 167 0 1744106128 13532544 23825760
23:04:35 6730 8192000000 10668155168 11039608832 1722243952 17.371 100 79 156 3 1757416688 12648320 22524416
23:04:50 8035 8192000000 10680879120 11054268416 1739294432 17.513 100 88 175 1 1778016240 13571104 25150704
23:05:04 7128 8192000000 10676246976 11054419968 1744202272 17.554 100 79 158 1 1779554320 12777904 22574144
23:05:18 5082 8192000000 10693543904 11067604992 1752869968 17.625 100 83 166 5 1789396144 13041648 23484528
23:05:30 4576 8192000000 10695737856 11076612096 1757704816 17.665 100 72 144 2 1791055680 11968912 21381952
23:05:42 5155 8192000000 10713203296 11091505152 1769273520 17.761 100 81 158 0 1803253248 12013440 21966288
23:05:53 4652 8192000000 10716016336 11097518080 1778026560 17.833 100 85 168 3 1815415312 13006256 24382496
23:06:04 3247 8192000000 10731628288 11107921920 1787426288 17.911 100 84 167 1 1825191040 13628736 24136016
23:06:14 4019 8192000000 10732473888 11111333888 1796374048 17.984 100 88 176 3 1834982800 14276704 24332048
23:06:25 7486 8192000000 10735892016 11123523584 1798259712 18.000 100 77 154 0 1833633072 14269536 21103824
23:06:41 5230 8192000000 10739782880 11131166720 1803347856 18.041 100 74 148 1 1835997552 10705088 21944608
23:06:53 3250 8192000000 10762678416 11146518528 1822318032 18.197 100 79 158 3 1857572256 11984192 23270032
23:07:04 3689 8192000000 10775861472 11157590016 1836664128 18.314 100 90 181 1 1874739616 12691920 25383568
23:07:14 2999 8192000000 10782453712 11167592448 1843615008 18.370 100 88 176 1 1881520752 12790048 25115696
23:07:23 3809 8192000000 10790810800 11172954112 1843598640 18.370 100 85 167 2 1880178528 13007712 23572176
23:07:34 2412 8192000000 10789734288 11178971136 1849679920 18.420 100 86 169 0 1886729008 13465936 23583152
23:07:43 2652 8192000000 10793611072 11182624768 1856301088 18.473 100 89 175 1 1894135968 13767408 24067472
23:07:53 2177 8192000000 10800618768 11188666368 1858957200 18.495 100 92 182 1 1898567488 13898704 25711584
23:08:01 2673 8192000000 10806561840 11195613184 1862638672 18.525 100 90 179 1 1902312064 15304624 24368768
23:08:11 3498 8192000000 10811179600 11199897600 1867224672 18.562 100 93 186 1 1907695264 15157136 25313456
23:08:22 2263 8192000000 10816353248 11201945600 1870227072 18.586 100 89 178 1 1909903536 15121008 24555456
23:08:31 1539 8192000000 10811667088 11202154496 1870388560 18.587 100 93 187 1 1911335424 14379648 26567216
23:08:38 1679 8192000000 10815863888 11206668288 1871609824 18.597 100 90 180 3 1911536432 14686336 25240272
23:08:46 1874 8192000000 10822406304 11213033472 1879084192 18.658 100 93 183 4 1917507200 12511984 25911024
23:08:54 2306 8192000000 10818541808 11211948032 1878679168 18.654 100 89 178 2 1915474656 11762912 25032576
23:09:03 1519 8192000000 10823128464 11216580608 1881219584 18.675 100 95 190 2 1920618768 13083712 26315472
23:09:13 37010 8192000000 10816400128 11222962176 1880168560 18.666 100 65 129 1 1913262832 14836480 18257792
23:09:57 1674 8192000000 10826372144 11224342528 1891899136 18.761 100 91 179 1 1928566624 10835120 25832368
23:10:05 3267 8192000000 10793001584 11215814656 1879792400 18.663 100 43 86 1 1902558160 10306976 12458784
23:10:15 2159 8192000000 10818002704 11222167552 1884449008 18.701 100 68 135 2 1912720416 8186992 20084416
23:10:24 6749 8192000000 10801035648 11219705856 1883226672 18.691 100 43 86 2 1904977472 10096096 11654704
23:10:37 4393 8192000000 10801515504 11220480000 1885458656 18.709 100 48 93 2 1907878400 8408176 14011568
23:10:49 8123 8192000000 10796219376 11221008384 1883038288 18.690 100 30 60 0 1898540464 6932560 8569616
23:11:03 6373 8192000000 10795428336 11220365312 1886644560 18.719 100 34 68 0 1902740624 6358912 9737152
23:11:16 5264 8192000000 10808709184 11227578368 1889260544 18.740 100 26 52 3 1903513584 6783936 7469104
23:11:28 3811 8192000000 10817882624 11237879808 1896542640 18.798 100 42 82 0 1916417264 8740848 11133776
23:11:38 5103 8192000000 10807289552 11238154240 1899944752 18.826 100 29 58 0 1915191024 7299296 7946976
23:11:50 9918 8192000000 10804901136 11241222144 1898197584 18.812 100 19 37 0 1909348656 5941872 5209200
23:12:07 9325 8192000000 10808739536 11244367872 1903821504 18.857 100 33 66 0 1919954416 6706176 9426736
23:12:23 71969 8192000000 10814445616 11252830208 1904827680 18.865 100 27 52 1 1918035888 5265216 7942992
23:13:41 8362 8192000000 10830002928 11259072512 1912510384 18.927 100 30 60 1 1926682608 6207280 7964944
23:13:57 5347 8192000000 10828761344 11262156800 1914288832 18.941 100 32 64 2 1928672768 5506496 8877440
23:14:09 7035 8192000000 10829920048 11263873024 1915093808 18.948 100 35 71 2 1932275712 7366464 9815440
23:14:25 4356 8192000000 10823660656 11262332928 1916811008 18.961 100 30 59 1 1931577168 6543728 8222432
23:14:37 8387 8192000000 10826826000 11265241088 1916095280 18.956 100 19 37 0 1931312896 9431824 5785792
23:14:51 5261 8192000000 10840424976 11271933952 1920689728 18.992 100 22 42 4 1932854704 5965584 6199392
23:15:02 10774 8192000000 10827214960 11270402048 1921583312 19.000 100 20 40 2 1933320688 5948592 5788784
23:15:22 10253 8192000000 10842018736 11277721600 1927039920 19.043 100 16 32 1 1936880352 5053920 4786512
23:15:40 7962 8192000000 10849944384 11277238272 1926509824 19.039 100 24 47 1 1939074912 5327120 7237968
23:15:56 8670 8192000000 10836020256 11272519680 1908720784 18.896 99 20 40 0 1920604192 6181344 5702064
23:16:15 10444 8192000000 10836307872 11271925760 1923255600 19.013 100 15 30 1 1933234960 5778112 4201248
23:16:33 7511 8192000000 10840278624 11271462912 1919665312 18.984 100 19 38 2 1930716912 5854592 5197008
23:16:53 6118 8192000000 10836700768 11274326016 1925955392 19.035 100 27 56 1 1940314176 5557664 8801120
23:17:07 48848 8192000000 10872567760 11282661376 1916939472 18.962 99 62 125 2 1942280864 6873472 18467920
23:18:02 5701 8192000000 10821192384 11257544704 1891848848 18.761 99 32 64 0 1909505712 8838016 8818848
23:18:14 6092 8192000000 10793044112 11227840512 1873329616 18.611 99 26 52 1 1886025776 6198544 6497616
23:18:27 5174 8192000000 10820239344 11249111040 1886774512 18.720 99 36 69 3 1902468464 5460608 10233344
23:18:38 5475 8192000000 10782676288 11214295040 1834189632 18.293 97 27 54 1 1847428400 6063616 7175152
23:18:50 9948 8192000000 10777377488 11208146944 1840346704 18.344 98 20 40 0 1852119744 5653056 6119984
23:19:07 3305 8192000000 10804399328 11217367040 1875322528 18.627 100 53 105 2 1899034416 8112400 15599488
23:19:17 6479 8192000000 10770593776 11191472128 1817610112 18.158 97 25 48 3 1834167472 9061904 7495456
23:19:30 7734 8192000000 10765396992 11193556992 1835466832 18.304 99 30 61 1 1854898384 10723088 8708464
23:19:47 5675 8192000000 10756879920 11177959424 1823215136 18.204 98 31 62 2 1838169232 6158528 8795568
23:19:59 8851 8192000000 10755319664 11168882688 1780515632 17.854 96 23 46 2 1792235200 5059952 6659616
23:20:15 6287 8192000000 10735490976 11156242432 1760548752 17.689 96 30 60 0 1775588112 6234480 8804880
23:20:27 7228 8192000000 10720037712 11138543616 1749889504 17.601 96 26 51 3 1763414208 5524272 8000432
23:20:44 8525 8192000000 10677825776 11087314944 1667548704 16.913 93 21 42 1 1678843664 4458784 6836176
23:21:02 29606 8192000000 10692272336 11104657408 1749174000 17.595 98 24 46 1 1761160256 5171792 6814464
23:21:40 27053 8192000000 10749363072 11140513792 1792564704 17.953 99 84 170 2 1824178976 6593696 25020576
23:22:16 17559 8192000000 10707832656 11116208128 1728590144 17.424 95 30 59 1 1743297968 5319584 9388240
23:22:40 6524 8192000000 10733293392 11151032320 1805755616 18.061 100 30 60 1 1819704496 5605136 8343744
23:22:54 5931 8192000000 10749718320 11165753344 1829064704 18.252 100 38 76 1 1846909360 7332480 10512176
23:23:06 5366 8192000000 10754087152 11176529920 1834778912 18.298 100 32 64 1 1851119744 6970752 9370080
23:23:21 7130 8192000000 10736690336 11153784832 1806525136 18.067 99 42 83 1 1824750544 6259728 11965680
23:23:34 5896 8192000000 10741171248 11151880192 1783282672 17.877 98 27 55 1 1796192048 4442592 8466784
23:23:49 8013 8192000000 10737553856 11150139392 1773176432 17.793 97 26 51 1 1786247264 5380960 7689872
23:24:04 10020 8192000000 10733969488 11155984384 1823797744 18.209 100 20 38 0 1835385888 6036464 5551680
23:24:20 12418 8192000000 10743465296 11161976832 1796259328 17.983 98 32 65 1 1811395456 4851536 10284592
23:24:39 6515 8192000000 10770764688 11183697920 1847269744 18.400 100 35 69 1 1863529712 5965200 10294768
23:24:56 9859 8192000000 10761070368 11184574464 1845270080 18.384 100 15 30 1 1854687152 5425680 3991392
23:25:13 6735 8192000000 10766477552 11192229888 1850680912 18.428 100 15 30 1 1860463664 5367952 4414800
23:25:29 9067 8192000000 10770308704 11198124032 1856559200 18.475 100 13 26 2 1865527808 5442704 3525904
23:25:45 65184 8192000000 10772870096 11205718016 1860495072 18.507 100 21 41 0 1871682192 4848000 6339120
23:27:00 12027 8192000000 10786967920 11216207872 1874560848 18.621 100 28 56 3 1888530128 5156144 8813136
23:27:18 4516 8192000000 10807172576 11232292864 1891307392 18.756 100 41 82 0 1909221664 7278736 10635536
23:27:31 4283 8192000000 10844836976 11254714368 1904756368 18.865 100 68 131 4 1930910560 8277120 17877072
23:27:43 11869 8192000000 10845861104 11260682240 1911774240 18.921 100 68 136 3 1940915984 9768800 19372944
23:28:09 18272 8192000000 10860977520 11270901760 1914843488 18.946 100 62 124 1 1945555152 13271872 17439792
23:28:35 3650 8192000000 10861026688 11275653120 1921906768 19.002 100 71 142 1 1955549840 13415024 20228048
23:28:47 9960 8192000000 10861239776 11279998976 1924623392 19.024 100 62 123 3 1955306640 13090688 17592560
23:29:08 14585 8192000000 10865432512 11283562496 1926661968 19.040 100 54 109 0 1955792528 12913840 16216720
23:29:29 12976 8192000000 10866124736 11287396352 1932451232 19.086 100 58 116 1 1962290976 13167328 16672416
23:29:52 10844 8192000000 10875304432 11300126720 1938397552 19.134 100 56 114 0 1967234976 12965632 15871792
23:30:10 18581 8192000000 10888724496 11311599616 1942863360 19.170 100 46 90 2 1969255344 13027920 13364064
23:30:38 30143 8192000000 10880039504 11312033792 1948033344 19.211 100 49 98 2 1976613056 14337776 14241936
23:31:15 8906 8192000000 10895915936 11315789824 1954035168 19.259 100 54 108 0 1982683104 12619232 16028704
23:31:31 7255 8192000000 10901042880 11320987648 1956320496 19.277 100 59 118 3 1987647840 14019440 17307904
23:32:04 5598 8192000000 10919581120 11337928704 1965485168 19.350 100 67 134 0 2003011168 17725520 19800480
23:32:16 5509 8192000000 10900839392 11332616192 1965112768 19.347 100 60 120 1 1998799360 16339552 17347040
23:32:31 2179 8192000000 10918796400 11335184384 1970849088 19.392 100 66 133 2 2005497264 15706480 18941696
23:32:41 7546 8192000000 10915655856 11343925248 1968468736 19.373 100 58 115 1 2001888928 16877392 16542800
23:32:56 20253 8192000000 10922864912 11345698816 1972422832 19.405 100 68 134 1 2010296304 18043408 19830064
23:33:25 19845 8192000000 10919530320 11350650880 1975152608 19.426 100 64 125 0 2013548464 20611872 17783984
23:33:56 13728 8192000000 10928459008 11353423872 1981315936 19.475 100 56 110 3 2014812320 17587664 15908720
23:34:19 7574 8192000000 10927317520 11358584832 1983116192 19.489 100 54 108 1 2017436720 17983536 16336992
23:34:35 6424 8192000000 10926518976 11361427456 1988451120 19.532 100 50 100 0 2018781696 15782208 14548368
23:34:49 17965 8192000000 10928256384 11364839424 1989798496 19.542 100 51 102 2 2022261952 17301824 15161632
23:35:20 8851 8192000000 10942295440 11375624192 1996679328 19.597 100 54 108 0 2030126480 17289952 16157200
23:35:38 6152 8192000000 10947021712 11378421760 2003265424 19.648 100 68 136 0 2041650576 17744544 20640608
23:35:51 19288 8192000000 10941561040 11372969984 1981800224 19.479 99 59 118 1 2020087424 19629056 18658144
23:36:18 3277 8192000000 10943985008 11364143104 1975940224 19.433 99 56 110 0 2011702848 19485248 16277376
23:36:28 4692 8192000000 10954033408 11380183040 1999250640 19.617 100 68 135 1 2038684496 19122080 20311776
23:36:40 10181 8192000000 10952427920 11377065984 1981571088 19.477 99 75 150 3 2024723264 21082512 22069664
23:36:58 5087 8192000000 10953671072 11381395456 1996497664 19.595 100 69 134 3 2043670752 27435008 19738080
23:37:13 6532 8192000000 10958578112 11383332864 1999138336 19.616 100 70 138 1 2043038240 23538080 20361824
23:37:26 9845 8192000000 10965754896 11392737280 2000688704 19.628 100 61 122 1 2047976016 29063664 18223648
23:37:50 9356 8192000000 10970811088 11393736704 2007240976 19.680 100 76 150 2 2060362384 30891472 22229936
23:38:07 2689 8192000000 10970884128 11387838464 2004513680 19.658 100 81 160 1 2055946528 27740304 23692544
23:38:17 6833 8192000000 10967569264 11393740800 2009895248 19.701 100 76 152 2 2060474480 28012736 22566496
23:38:32 4548 8192000000 10962916864 11393945600 1985129248 19.505 99 64 125 1 2032367888 28173136 19065504
23:38:45 5934 8192000000 10965168752 11391307776 1997569104 19.604 100 73 143 3 2050716048 31027568 22119376
23:38:58 5100 8192000000 10971110368 11398873088 2005476192 19.666 100 71 139 0 2058351584 31045600 21829792
23:39:13 2687 8192000000 10987474048 11408715776 2012545120 19.722 100 86 171 3 2071388768 32802976 26040672
23:39:24 2697 8192000000 10960739824 11387396096 2002382272 19.642 100 75 151 2 2056183072 31356336 22444464
23:39:40 2360 8192000000 10973732928 11399499776 2006969936 19.678 100 77 154 0 2062898224 32985840 22942448
23:39:49 4401 8192000000 10973738992 11395637248 1991849520 19.558 99 86 170 1 2051280384 34061776 25369088
23:40:02 1146 8192000000 10980118416 11397017600 2005224320 19.664 100 67 134 0 2059150784 33110416 20816048
23:40:10 3969 8192000000 10987786960 11400232960 2008885680 19.693 100 89 177 1 2068851360 34031376 25934304
23:40:22 3411 8192000000 10982634624 11408228352 2012807472 19.724 100 68 136 1 2068795344 34640320 21347552
23:40:32 2282 8192000000 10981489376 11405418496 2011453760 19.713 100 83 166 3 2071860400 34358080 26048560
23:40:42 1361 8192000000 10992063392 11402170368 2001078336 19.631 99 89 179 0 2064140320 35832448 27229536
23:40:50 3317 8192000000 10980470048 11400847360 2007546336 19.682 100 86 170 4 2066600416 33474752 25579328
23:41:04 8430 8192000000 10977359168 11404726272 2008641264 19.691 100 69 139 1 2065560528 35146864 21772400
23:41:28 4291 8192000000 10981529232 11400146944 1990710576 19.549 99 73 146 2 2051236832 38569760 21956496
23:41:41 3767 8192000000 10983380624 11404242944 2012083328 19.718 100 71 142 2 2067910992 34652112 21175552
23:41:52 6896 8192000000 10971619568 11394650112 1989274656 19.538 99 72 142 1 2045638384 34542608 21821120
23:42:08 1151 8192000000 10972147824 11382792192 1994106432 19.576 99 83 164 3 2055623808 34128176 27389200
23:42:19 12038 8192000000 10972458640 11395698688 1997654608 19.604 100 69 134 1 2055475104 35687232 22133264
23:42:38 5971 8192000000 10958013120 11387375616 1990123472 19.545 100 63 126 1 2048924880 38721984 20079424
23:42:51 7856 8192000000 10973752800 11404013568 2002181216 19.640 100 64 128 1 2060700544 38042352 20476976
23:43:09 5461 8192000000 10970274416 11391209472 1988478464 19.532 100 80 160 1 2057989328 44261264 25249600
23:43:21 2252 8192000000 10972590368 11389435904 1972974224 19.409 99 82 165 0 2041078368 42135600 25968544
23:43:30 4150 8192000000 10979287552 11391537152 1975170976 19.426 99 85 170 1 2045783312 44332976 26279360
23:43:43 2792 8192000000 10981497312 11400425472 1999354928 19.618 100 82 164 1 2068889392 43863328 25671136
23:43:52 2301 8192000000 10986739856 11397431296 1995081600 19.584 100 85 166 3 2065126336 43291136 26753600
23:44:01 6427 8192000000 10980529840 11403042816 1996831168 19.598 100 70 140 2 2063188464 43744592 22612704
23:44:18 4270 8192000000 10992826160 11413291008 2004630976 19.659 100 79 158 0 2075564672 45426880 25506816
23:44:34 2292 8192000000 11002340512 11418157056 2012284256 19.719 100 76 150 1 2078950368 43283248 23382864
23:44:43 2695 8192000000 11014837296 11431129088 2022041808 19.796 100 88 175 2 2095116144 45648256 27426080
23:44:52 1445 8192000000 11020791600 11432443904 2020988832 19.788 100 93 186 1 2098125392 47803072 29333488
23:45:01 1947 8192000000 10994801840 11407249408 1997140896 19.600 99 84 164 3 2069525968 47203680 25181392
23:45:10 2748 8192000000 10983086960 11400437760 1976464544 19.437 99 89 176 1 2052329056 47377504 28487008
23:45:19 2417 8192000000 10976327536 11388588032 1975775152 19.431 99 92 180 4 2054292032 48374944 30141936
23:45:28 4049 8192000000 10981101712 11398737920 1976839728 19.440 99 85 170 1 2054658416 49600416 28218272
23:45:39 3454 8192000000 10993224752 11403546624 1985081088 19.505 100 88 175 1 2064170384 50697264 28392032
23:45:49 5257 8192000000 10991420560 11410948096 1997335200 19.602 100 79 156 1 2075253328 53015392 24902736
23:46:01 2472 8192000000 11004244496 11419934720 2003691152 19.652 100 81 161 1 2082558816 52919792 25947872
23:46:11 1321 8192000000 10995765792 11408683008 1992538800 19.564 99 88 177 0 2076061504 55292064 28230640
23:46:18 5401 8192000000 10984029728 11416027136 1980435520 19.468 99 70 141 0 2060635920 57157680 23042720
23:46:35 15987 8192000000 10969162464 11412357120 1970156352 19.387 99 39 78 0 2038048960 53573360 14319248
23:46:58 5331 8192000000 10973090880 11406970880 1993189296 19.569 100 58 116 2 2060043264 47432480 19421488
23:47:14 10494 8192000000 10954704000 11402391552 1991303200 19.554 100 45 90 1 2048429040 42120976 15004864
23:47:37 20548 8192000000 10928323728 11383500800 1959129984 19.299 99 35 70 0 2010233264 39081824 12021456
23:48:52 18123 8192000000 10928662032 11372179456 1953768224 19.256 99 27 54 2 1993310784 30764784 8777776
23:49:20 20582 8192000000 10911537872 11367542784 1947587584 19.207 99 27 54 0 1988701376 32285248 8828544
23:49:47 19736 8192000000 10921262832 11376836608 1968975792 19.377 100 24 48 0 2010888976 33795184 8118000
23:50:14 18767 8192000000 10909568688 11359154176 1920488800 18.991 98 27 54 1 1966096160 36680976 8926384
23:50:51 13281 8192000000 10924500928 11370815488 1952752144 19.248 100 26 50 1 2002796576 40993072 9051360
23:51:14 12154 8192000000 10914562336 11364003840 1942708048 19.168 100 25 50 2 1997794416 45818240 9268128
23:51:33 14775 8192000000 10872762064 11322175488 1844004144 18.373 95 20 41 0 1893915376 42499616 7411616
23:51:56 33037 8192000000 10892473632 11336876032 1894767712 18.784 99 20 40 0 1945930384 43272528 7890144
23:52:35 69812 8192000000 10855118736 11318755328 1801737504 18.028 94 19 39 2 1836699184 29486224 5475456
23:53:52 35101 8192000000 10858707120 11312193536 1905103056 18.867 99 24 48 1 1935349488 23124320 7122112
23:54:33 62642 8192000000 10845466640 11287601152 1880577904 18.670 98 22 42 1 1906442272 19374432 6489936
23:55:43 32887 8192000000 10879239824 11310551040 1928707536 19.057 100 73 140 0 1961586576 11919168 20959872
23:56:22 847 8192000000 10891500464 11309060096 1930089136 19.068 100 92 184 1 1971548480 14058320 27401024
23:56:30 5950 8192000000 10895092064 11322585088 1943330080 19.173 100 81 162 1 1978459472 11576416 23552976
23:56:56 13082 8192000000 10882987792 11323830272 1942196976 19.164 100 52 103 0 1969455712 13050560 14208176
23:58:11 58410 8192000000 10873517968 11330560000 1922976736 19.011 98 26 52 2 1942938624 12602832 7359056
23:59:16 26524 8192000000 10902038208 11349671936 1964020448 19.338 100 39 78 0 1992210480 17193248 10996784
00:00:01 27876 8192000000 10885928176 11354161152 1959032784 19.298 100 24 47 1 1988483520 22413088 7037648
00:00:42 107331 8192000000 10885195008 11346456576 1887986160 18.730 96 20 40 1 1916205472 22369648 5849664
00:03:04 62029 8192000000 10880346736 11344105472 1936033408 19.115 99 16 32 0 1967835424 26510048 5291968
00:05:08 120866 8192000000 10890528832 11341524992 1904576928 18.863 97 32 64 1 1925420880 11682272 9161680
00:08:01 25315 8192000000 10887075456 11351732224 1949103008 19.219 99 26 52 2 1974539264 18084144 7352112
00:08:39 64215 8192000000 10888086096 11363635200 1948070912 19.211 99 27 54 1 1970405072 14159840 8174320
00:09:57 42379 8192000000 10892164240 11363344384 1950195840 19.228 99 13 26 0 1968293168 14507664 3589664
00:10:45 34619 8192000000 10900749280 11374587904 1965730144 19.352 100 13 26 1 1988056192 17203312 5122736
00:11:40 52882 8192000000 10887903024 11374100480 1948429472 19.214 99 9 17 1 1965261184 14547136 2284576
00:12:39 28843 8192000000 10905921280 11371335680 1977724496 19.447 100 40 81 1 2002087296 13258512 11104288
00:13:19 39253 8192000000 10911501616 11363172352 1944668496 19.184 98 20 39 0 1963827600 13515600 5643504
00:14:13 63287 8192000000 10888949904 11372224512 1951178064 19.236 99 17 34 1 1973131456 16620768 5332624
00:15:23 70914 8192000000 10904482720 11374882816 1963263456 19.332 99 17 34 1 1979106928 11010368 4833104
00:16:49 35012 8192000000 10931197328 11377917952 1975451488 19.429 99 33 66 0 1997138480 12084176 9602816
00:17:34 88889 8192000000 10913142976 11400593408 1965427776 19.349 99 14 28 0 1990211584 21015984 3767824
00:19:34 52140 8192000000 10915505072 11366273024 1965593088 19.350 99 33 64 1 1984005680 9838896 8573696
00:20:34 15215 8192000000 10935626016 11377278976 1990703936 19.549 100 50 100 1 2013707504 8892112 14111456
00:20:59 19766 8192000000 10925391568 11380281344 1988264000 19.530 100 34 68 1 2008475904 10879120 9332784
00:21:28 108812 8192000000 10926283168 11378630656 1935576944 19.111 97 37 74 2 1958296432 12876576 9842912
00:23:32 77120 8192000000 10926658464 11407654912 1997413456 19.602 100 39 78 2 2022072496 14323680 10335360
00:24:55 67984 8192000000 10921444704 11379949568 1954345296 19.261 98 14 28 2 1972078416 13427520 4305600
00:26:13 110054 8192000000 10914644688 11381526528 1961781760 19.320 98 32 64 1 1979896352 9277360 8837232
00:28:16 70246 8192000000 10941234672 11409977344 2008411776 19.689 100 32 63 1 2033095024 16270304 8412944
00:29:33 30342 8192000000 10928602400 11400527872 1964429776 19.341 98 23 46 0 1990747264 19788192 6529296
00:30:09 14521 8192000000 10928250976 11407745024 1997941072 19.606 100 17 34 0 2019742320 17269392 4531856
00:30:56 71995 8192000000 10924412128 11404107776 1988009536 19.528 99 19 38 1 2010009072 16413072 5586464
00:33:03 53262 8192000000 10946265392 11422777344 2006237648 19.672 100 18 36 1 2030049072 18132624 5678800
00:34:47 80942 8192000000 10926436016 11413983232 1968015072 19.370 98 19 36 2 1993415216 20068704 5331440
00:36:35 44213 8192000000 10902445248 11384999936 1931638640 19.080 97 12 24 1 1957017776 22401104 2978032
00:37:39 55797 8192000000 10898841136 11370700800 1947239712 19.204 98 22 44 2 1961531824 8233808 6058304
00:38:41 30052 8192000000 10922236560 11379802112 1965177824 19.347 99 33 66 1 1983225072 8820944 9226304
00:39:19 55301 8192000000 10883392528 11355992064 1881585760 18.678 95 25 50 0 1899233856 10807072 6841024
00:40:35 21527 8192000000 10876473600 11333373952 1909754512 18.905 98 26 51 0 1924292448 7863200 6674736
00:41:03 26013 8192000000 10867778544 11308736512 1907255552 18.885 99 44 87 1 1927623360 8374912 11992896
00:41:36 12074 8192000000 10892442624 11330899968 1938096912 19.132 100 63 123 1 1965618384 10031600 17489872
00:41:56 43268 8192000000 10855806352 11319660544 1853442016 18.450 95 35 68 3 1877376384 14627856 9306512
00:42:46 70602 8192000000 10831368576 11287003136 1756598912 17.656 91 11 22 1 1769875808 10213968 3062928
00:44:03 86860 8192000000 10840451456 11299921920 1809584544 18.092 95 22 44 0 1826143056 10620608 5937904
00:47:26 48476 8192000000 10861942400 11322478592 1888233152 18.732 98 26 52 0 1913056064 17610864 7212048
00:48:24 129360 8192000000 10828410208 11282989056 1873119472 18.610 98 17 34 0 1894937024 17072592 4744960
00:50:59 44789 8192000000 10856561728 11292340224 1881922544 18.681 98 44 87 2 1904736544 10479952 12334048
00:52:18 56270 8192000000 10850673712 11323551744 1904623936 18.863 99 21 42 1 1928774912 18303536 5847440
00:53:41 27064 8192000000 10845727472 11330781184 1923259456 19.013 100 5 10 1 1941877136 16590064 2027616
00:54:15 7846 8192000000 10844213664 11332874240 1923819680 19.017 100 4 8 0 1939453728 14647728 986320
00:54:49 93187 8192000000 10850027760 11314675712 1875494528 18.629 97 7 14 1 1887852288 10153344 2204416
00:56:39 59422 8192000000 10854860448 11314245632 1895154960 18.787 98 18 36 1 1911997904 11855712 4987232
00:57:46 75844 8192000000 10853666608 11325353984 1904903872 18.866 98 16 32 0 1926002544 16595856 4502816
00:59:09 112962 8192000000 10871077648 11353759744 1895540464 18.790 97 21 42 0 1920777424 19571568 5665392
01:01:08 103686 8192000000 10862817936 11326132224 1872824800 18.607 96 8 16 0 1887908096 13258736 1824560
01:03:01 80920 8192000000 10893659664 11366469632 1959120416 19.299 100 14 28 0 1977496864 14004416 4372032
01:04:30 107309 8192000000 10901850256 11377352704 1883747984 18.695 96 9 18 1 1912054048 25372256 2933808
01:06:23 40782 8192000000 10926620176 11367485440 1970757600 19.391 100 40 80 1 1992463296 10518128 11187568
01:07:10 63959 8192000000 10916325088 11392339968 1972883248 19.408 100 28 56 2 1991617392 11272272 7461872
01:08:20 141116 8192000000 10901280064 11374170112 1919112160 18.980 97 11 22 2 1938982688 17002848 2867680
01:10:52 50896 8192000000 10918097536 11376967680 1958101280 19.291 99 28 57 2 1975408224 8576640 8730304
01:11:49 44236 8192000000 10928517632 11389374464 1985246560 19.506 100 30 60 1 2008927248 15477936 8202752
01:12:39 124456 8192000000 10915866928 11401359360 1986199904 19.514 100 22 44 0 2005042544 12270944 6571696
01:15:12 60540 8192000000 10916432576 11390320640 1971399984 19.397 99 13 26 0 1988430016 12908384 4121648
01:16:21 73578 8192000000 10882822256 11363946496 1936695376 19.120 98 13 26 0 1951844032 11544352 3604304
01:17:40 46089 8192000000 10883363472 11369005056 1944620816 19.184 99 8 16 0 1959498992 12571856 2306320
01:18:49 58054 8192000000 10906281248 11388293120 1953753744 19.256 99 21 43 1 1972068096 12373168 5941184
01:19:53 98511 8192000000 10885725344 11372732416 1930467888 19.071 98 16 32 0 1949422336 14402816 4551632
01:21:39 63130 8192000000 10882891184 11360886784 1908591168 18.895 97 16 32 0 1930221104 16843248 4786688
01:22:51 36240 8192000000 10910803584 11380109312 1967474384 19.365 100 26 52 1 1985251136 10313472 7463280
01:23:36 81535 8192000000 10894133120 11376254976 1955764080 19.272 99 17 34 0 1971330320 10719936 4846304
01:25:04 47874 8192000000 10903979296 11367600128 1952732160 19.248 99 16 32 0 1967632080 10415104 4484816
01:26:01 35820 8192000000 10931850640 11394359296 1986414032 19.515 100 49 97 1 2011662560 12321248 12927280
01:26:50 51470 8192000000 9315462608 9594429440 464763552 5.368 24 4 7 0 473109936 7299520 1046864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 11-03-2021 01:28:41 to 11-03-2021 01:29:13.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 191 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-03-2021 01:29:14 to 11-03-2021 01:29:16.

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          225718
MON$OLDEST_ACTIVE               227462
MON$OLDEST_SNAPSHOT             227462
MON$NEXT_TRANSACTION            227462
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                       2008576
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:300: 
:301: mscs-test-161.budzdorov.ru    Thu Mar 11 01:27:49 2021
:302:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:303: 
:304: 
:305: mscs-test-161.budzdorov.ru    Thu Mar 11 01:27:53 2021
:306:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:307: 
--- end of diff output ---

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

11.03.21 01:29:17. 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-11 01:29:19 No severe PSQL-related problems occured
11.03.21 01:29:21. End of report.