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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17196292 kB
MemAvailable 31437968 kB
Buffers 0 kB
Cached 14440716 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-04-01 19:27:27
DTS_END                         2021-04-01 19:27:27.7870
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/43842
TRN_ID                          246885
ATT_ID                          646
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: 9484.43 20647 1138132
customer order: creation 180.32 333 21638
customer order: refuse 15.52 322 1862
order to supplier: creation 47.88 1251 5746
order to supplier: removal 3.76 87643 451
invoice (draft): creation 48.15 3481 5778
invoice (draft): removal 54.12 722 6494
invoice accept: apply 42.86 16232 5143
invoice accept: cancel 48.41 803 5809
customer reserve: creation 3944.84 161 473381
customer reserve: removal 4792.71 53 575125
realization accept: apply 87.36 181 10483
realization accept: cancel 82.03 113 9844
payment from customer: creation 61.76 136 7411
payment from customer: removal 6.26 72 751
payment to supplier: creation 52.52 146 6302
payment to supplier: removal 3.60 99 432
service: total inventory turnovers 4.90 1294 588
service: total monetary turnovers 6.49 44 779
service: aggregate perf. data 0.93 19264 111
service: refresh index statistics 0.03 280597 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-04-2021 19:28:19 to 01-04-2021 19:28:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2814
TEST_TIME 2 4449
TEST_TIME 3 4228
TEST_TIME 4 4452
TEST_TIME 5 4658
TEST_TIME 6 4940
TEST_TIME 7 5336
TEST_TIME 8 5315
TEST_TIME 9 6068
TEST_TIME 10 6898
TEST_TIME 11 7432
TEST_TIME 12 7848
TEST_TIME 13 7880
TEST_TIME 14 7713
TEST_TIME 15 7674
TEST_TIME 16 7630
TEST_TIME 17 7574
TEST_TIME 18 7669
TEST_TIME 19 7909
TEST_TIME 20 8786
TEST_TIME 21 9033
TEST_TIME 22 9258
TEST_TIME 23 9191
TEST_TIME 24 9469
TEST_TIME 25 10209
TEST_TIME 26 10380
TEST_TIME 27 10112
TEST_TIME 28 10420
TEST_TIME 29 10261
TEST_TIME 30 10303
TEST_TIME 31 10256
TEST_TIME 32 10362
TEST_TIME 33 10289
TEST_TIME 34 10303
TEST_TIME 35 10342
TEST_TIME 36 10367
TEST_TIME 37 10312
TEST_TIME 38 10181
TEST_TIME 39 9983
TEST_TIME 40 10051
TEST_TIME 41 9984
TEST_TIME 42 9866
TEST_TIME 43 9777
TEST_TIME 44 9751
TEST_TIME 45 9710
TEST_TIME 46 9632
TEST_TIME 47 9744
TEST_TIME 48 9771
TEST_TIME 49 9724
TEST_TIME 50 9724
TEST_TIME 51 9576
TEST_TIME 52 9472
TEST_TIME 53 9587
TEST_TIME 54 9499
TEST_TIME 55 9410
TEST_TIME 56 9551
TEST_TIME 57 9572
TEST_TIME 58 9576
TEST_TIME 59 9716
TEST_TIME 60 9666
TEST_TIME 61 9756
TEST_TIME 62 9716
TEST_TIME 63 9887
TEST_TIME 64 9837
TEST_TIME 65 9924
TEST_TIME 66 9871
TEST_TIME 67 9872
TEST_TIME 68 9868
TEST_TIME 69 9937
TEST_TIME 70 9867
TEST_TIME 71 9839
TEST_TIME 72 9857
TEST_TIME 73 9778
TEST_TIME 74 9753
TEST_TIME 75 9759
TEST_TIME 76 9715
TEST_TIME 77 9704
TEST_TIME 78 9669
TEST_TIME 79 9613
TEST_TIME 80 9560
TEST_TIME 81 9555
TEST_TIME 82 9516
TEST_TIME 83 9481
TEST_TIME 84 9481
TEST_TIME 85 9446
TEST_TIME 86 9432
TEST_TIME 87 9391
TEST_TIME 88 9504
TEST_TIME 89 9486
TEST_TIME 90 9518
TEST_TIME 91 9586
TEST_TIME 92 9615
TEST_TIME 93 9566
TEST_TIME 94 9583
TEST_TIME 95 9709
TEST_TIME 96 9715
TEST_TIME 97 9720
TEST_TIME 98 9679
TEST_TIME 99 9695
TEST_TIME 100 9701
TEST_TIME 101 9685
TEST_TIME 102 9664
TEST_TIME 103 9653
TEST_TIME 104 9614
TEST_TIME 105 9589
TEST_TIME 106 9549
TEST_TIME 107 9511
TEST_TIME 108 9512
TEST_TIME 109 9447
TEST_TIME 110 9456
TEST_TIME 111 9456
TEST_TIME 112 9432
TEST_TIME 113 9458
TEST_TIME 114 9454
TEST_TIME 115 9456
TEST_TIME 116 9472
TEST_TIME 117 9476
TEST_TIME 118 9476
TEST_TIME 119 9537
TEST_TIME 120 9490

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 01-04-2021 19:28:22 to 01-04-2021 19:28:26.

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 1577449 1577449 0 0.00 0 31004 6 0 0
doc_list_biud 1577449 1577449 0 0.00 0 67841 25 0 0
sp_add_invoice_to_stock 5211 5143 68 1.30 41 145944 16233 0 68
sp_cancel_adding_invoice 5809 5809 0 0.00 3 67003 803 0 0
sp_cancel_client_order 1862 1862 0 0.00 5 11838 322 0 0
sp_cancel_customer_reserve 575125 575125 0 0.00 1 67842 54 0 0
sp_cancel_pay_from_customer 751 751 0 0.00 2 4705 73 0 0
sp_cancel_pay_to_supplier 432 432 0 0.00 3 6250 99 0 0
sp_cancel_supplier_invoice 6499 6494 5 0.07 2 20593 722 0 5
sp_cancel_supplier_order 451 451 0 0.00 15 1040109 87644 0 0
sp_cancel_write_off 9844 9844 0 0.00 1 8378 114 0 0
sp_client_order 21638 21638 0 0.00 3 39115 334 0 0
sp_customer_reserve 473381 473381 0 0.00 0 71373 161 0 0
sp_fill_shopping_cart 33159 33159 0 0.00 1 13949 39 0 0
sp_fill_shopping_cart_clo_res 473367 473367 0 0.00 0 10596 10 0 0
sp_get_clo_for_invoice 5129 5129 0 0.00 0 17457 230 0 0
sp_kill_cost_storno 16836 16836 0 0.00 0 14844 60 0 0
sp_kill_qstorno_ret_qs2qd 1167039 1167039 0 0.00 0 67835 29 0 0
sp_kill_qty_storno 615197 615197 0 0.00 0 67840 64 0 0
sp_lock_selected_doc 21725 21725 0 0.00 0 7498 5 0 0
sp_make_cost_storno 29325 29325 0 0.00 0 16945 57 0 0
sp_multiply_rows_for_pdistr 29325 29325 0 0.00 0 7514 33 0 0
sp_multiply_rows_for_qdistr 21638 21638 0 0.00 0 39105 153 0 0
sp_pay_from_customer 7411 7411 0 0.00 4 23730 137 0 0
sp_pay_to_supplier 6302 6302 0 0.00 5 17814 146 0 0
sp_payment_common 13713 13713 0 0.00 1 14777 37 0 0
sp_qd_handle_on_cancel_clo 1862 1862 0 0.00 0 11829 297 0 0
sp_qd_handle_on_invoice_upd_sts 10938 10938 0 0.00 0 16669 337 0 0
sp_qd_handle_on_reserve_upd_sts 10483 10483 0 0.00 0 16926 67 0 0
sp_reserve_write_off 10483 10483 0 0.00 6 17162 182 0 0
sp_supplier_invoice 5778 5778 0 0.00 6 97623 3482 0 0
sp_supplier_order 5746 5746 0 0.00 5 103258 1251 0 0
srv_aggregate_perf_data 111 111 0 0.00 1963 305310 19264 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 922 127747 31583 0 0
srv_find_qd_qs_mism 1088879 1088879 0 0.00 0 30914 5 0 0
srv_make_invnt_saldo 588 588 0 0.00 39 103998 1295 0 0
srv_make_money_saldo 779 779 0 0.00 1 8378 44 0 0
srv_recalc_idx_stat 4 4 0 0.00 198334 413774 280598 0 0
t$perf-abend:sp_add_invoice_to_stock 68 68 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5143 5143 0 0.00 0 16333 196 0 0
t$perf-norm:sp_cancel_adding_invoice 419 419 0 0.00 0 9295 119 0 0
t$perf-norm:sp_cancel_client_order 1862 1862 0 0.00 0 3516 15 0 0
t$perf-norm:sp_cancel_customer_reserve 697 697 0 0.00 0 1170 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 751 751 0 0.00 0 3313 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 432 432 0 0.00 0 2859 18 0 0
t$perf-norm:sp_cancel_supplier_invoice 440 440 0 0.00 0 564 13 0 0
t$perf-norm:sp_cancel_supplier_order 451 451 0 0.00 0 40228 1492 0 0
t$perf-norm:sp_cancel_write_off 1062 1062 0 0.00 0 1483 7 0 0
t$perf-norm:sp_client_order 21638 21638 0 0.00 0 9496 17 0 0
t$perf-norm:sp_customer_reserve 1112 1112 0 0.00 0 1533 4 0 0
t$perf-norm:sp_pay_from_customer 7411 7411 0 0.00 0 8391 13 0 0
t$perf-norm:sp_pay_to_supplier 6302 6302 0 0.00 0 9326 12 0 0
t$perf-norm:sp_reserve_write_off 10483 10483 0 0.00 0 12361 14 0 0
t$perf-norm:sp_supplier_invoice 5778 5778 0 0.00 0 8498 21 0 0
t$perf-norm:sp_supplier_order 5746 5746 0 0.00 0 7461 17 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 409 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 2671 23 0 0
t$perf-norm:srv_make_invnt_saldo 588 588 0 0.00 0 825 25 0 0
t$perf-norm:srv_make_money_saldo 779 779 0 0.00 0 2153 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10394 10258 136 1.30 0 5776 17 0 136
v_all_customers 38838 38838 0 0.00 0 20 1 0 0
v_all_suppliers 32120 32120 0 0.00 0 135 1 0 0
v_all_wares 43274 43274 0 0.00 0 60 1 0 0
v_cancel_adding_invoice 838 838 0 0.00 0 125 5 0 0
v_cancel_client_order 3724 3724 0 0.00 0 3637 6 0 0
v_cancel_customer_prepayment 1502 1502 0 0.00 0 1456 5 0 0
v_cancel_customer_reserve 1394 1394 0 0.00 0 923 5 0 0
v_cancel_payment_to_supplier 864 864 0 0.00 0 2673 8 0 0
v_cancel_supplier_invoice 890 880 10 1.12 0 926 15 0 10
v_cancel_supplier_order 902 902 0 0.00 0 3706 8 0 0
v_cancel_write_off 2124 2124 0 0.00 0 3601 15 0 0
v_max_id_clo_ord 5745 5745 0 0.00 0 286 1 0 0
v_max_id_clo_res 1112 1112 0 0.00 0 3953 17 0 0
v_max_id_ord_sup 5777 5777 0 0.00 0 9460 7 0 0
v_max_non_paid_invoice 1764 1764 0 0.00 0 1732 3 0 0
v_max_non_paid_realizn 4209 4209 0 0.00 0 6066 6 0 0
v_min_id_clo_ord 5745 5745 0 0.00 0 2708 5 0 0
v_min_id_clo_res 1112 1112 0 0.00 0 2638 10 0 0
v_min_id_ord_sup 5777 5777 0 0.00 0 6312 6 0 0
v_min_non_paid_invoice 6302 6302 0 0.00 0 14772 29 0 0
v_min_non_paid_realizn 7411 7411 0 0.00 0 11323 25 0 0
v_our_firm 10840 10840 0 0.00 0 139 1 0 0
v_reserve_write_off 20964 20964 0 0.00 0 4187 5 0 0
x_lock_depdocs_on_canc_invoice 11863 11863 0 0.00 0 10951 109 0 0
x_lock_depdocs_on_canc_sup_ord 451 451 0 0.00 0 8200 318 0 0
x_make_qstorno_1000_1200 5746 5746 0 0.00 1 103034 1169 0 0
x_make_qstorno_1200_2000 5778 5778 0 0.00 2 97616 3341 0 0
x_make_qstorno_2100_3300 473381 473381 0 0.00 0 71361 148 0 0

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

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:31 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:38 12337 8192000000 10193994992 10495696896 774358096 8.636 62 49 100 0 793278064 2143632 16776336
16:57:59 16315 8192000000 10295594896 10611466240 1349106240 14.139 100 82 164 1 1380207408 4089104 27012064
16:58:26 29951 8192000000 10355496832 10676609024 1411264752 14.695 100 85 170 0 1444062816 5605664 27192400
16:59:04 16617 8192000000 10382970624 10705534976 1435153008 14.907 100 85 170 0 1470343056 7014224 28175824
16:59:31 16663 8192000000 10397008400 10727194624 1459594176 15.122 100 87 174 0 1495899456 7662352 28642928
16:59:59 15780 8192000000 10436807056 10768039936 1486088176 15.355 100 89 178 0 1523367440 8320512 28958752
17:00:42 23374 8192000000 10459984784 10796146688 1511003248 15.572 100 91 182 0 1550055872 9632912 29419712
17:01:16 24080 8192000000 10484534400 10826080256 1525500960 15.698 100 83 166 0 1561446000 9769200 26175840
17:01:55 15302 8192000000 10513092592 10861113344 1565606912 16.044 100 84 168 0 1601992208 10611184 25774112
17:02:20 17192 8192000000 10527148208 10878296064 1582513360 16.190 100 89 178 2 1621054816 11330032 27211424
17:02:46 11936 8192000000 10549820656 10900885504 1601115216 16.349 100 86 172 1 1638931600 11780384 26036000
17:03:06 16358 8192000000 10567763008 10925490176 1620603392 16.515 100 84 168 1 1657833024 11936560 25293072
17:03:31 10349 8192000000 10577894416 10939101184 1640901856 16.687 100 81 161 1 1677109568 12240752 23966960
17:03:50 12908 8192000000 10598185232 10965336064 1660935728 16.857 100 76 152 1 1695502512 12227440 22339344
17:04:11 7177 8192000000 10619892624 10990002176 1675923712 16.983 100 79 158 1 1711569088 11887616 23757760
17:04:25 9753 8192000000 10628679680 11003305984 1691723888 17.116 100 77 154 0 1725677488 11142304 22811296
17:04:42 8126 8192000000 10648633280 11019763712 1708135680 17.253 100 80 161 0 1742945296 11626448 23183168
17:04:58 7526 8192000000 10667454080 11040960512 1724815888 17.392 100 81 162 0 1760393120 12096432 23480800
17:05:13 7253 8192000000 10684389072 11055640576 1740813168 17.525 100 84 168 1 1778120832 12929872 24377792
17:05:29 4551 8192000000 10693062304 11069566976 1752290976 17.621 100 81 160 0 1788745440 13477328 22977136
17:05:40 5771 8192000000 10708707568 11085611008 1765993616 17.734 100 87 174 1 1804291600 13677888 24620096
17:05:53 3634 8192000000 10717201168 11096502272 1775118432 17.809 100 87 176 1 1813670368 13608544 24943392
17:06:04 3286 8192000000 10721351424 11100479488 1787743296 17.913 100 81 160 0 1822304720 12165264 22396160
17:06:14 3177 8192000000 10729990880 11107782656 1789717248 17.929 100 76 152 1 1824359328 12902560 21739520
17:06:23 2642 8192000000 10736471792 11116797952 1795450992 17.977 100 88 177 2 1833606080 13404016 24751072
17:06:32 2872 8192000000 10736702128 11116163072 1798492208 18.002 100 89 178 1 1836517792 13633168 24392416
17:06:42 3229 8192000000 10747209680 11128037376 1804878720 18.054 100 92 182 1 1844427520 14079088 25469712
17:06:53 3473 8192000000 10748280176 11133366272 1814365776 18.132 100 89 178 1 1852563408 13101328 25096304
17:07:03 1661 8192000000 10756990784 11139710976 1816970464 18.153 100 86 173 3 1854345120 13379312 23995344
17:07:11 6040 8192000000 10750932256 11142406144 1821107600 18.187 100 87 174 2 1858829648 13806048 23916000
17:07:24 2681 8192000000 10775658576 11159007232 1823444432 18.206 100 86 172 1 1861242816 13555360 24243024
17:07:34 2520 8192000000 10767803552 11163369472 1839380464 18.336 100 89 174 0 1876670896 13302208 23988224
17:07:43 1815 8192000000 10789324256 11172728832 1841031584 18.349 100 95 188 1 1881166080 13686368 26448128
17:07:51 1680 8192000000 10792859472 11176665088 1845580784 18.386 100 93 186 3 1885179776 14010192 25588800
17:07:59 1653 8192000000 10795418656 11179298816 1848881392 18.413 100 91 182 1 1889077056 14246112 25949552
17:08:07 1735 8192000000 10800320544 11184525312 1853920032 18.454 100 94 186 2 1894272592 13676432 26676128
17:08:15 1864 8192000000 10802871248 11185807360 1855920144 18.470 100 89 178 0 1894907376 14279792 24707440
17:08:23 1098 8192000000 10810249936 11195469824 1858656496 18.492 100 90 181 2 1898687296 14617872 25412928
17:08:31 1278 8192000000 10799656960 11193159680 1859875968 18.502 100 88 176 1 1897706816 13488944 24341904
17:08:38 23429 8192000000 10779215744 11185401856 1857743616 18.485 100 68 136 0 1890034048 13278400 19012032
17:09:10 6131 8192000000 10788549936 11191263232 1859678880 18.501 100 47 95 0 1881594640 7822912 14092848
17:09:23 5798 8192000000 10771956048 11192356864 1859390864 18.498 100 35 68 1 1876003648 7353856 9258928
17:09:35 4692 8192000000 10800750416 11207221248 1871054912 18.593 100 51 102 4 1896032928 10866272 14111744
17:09:47 6970 8192000000 10791440544 11208302592 1874108464 18.618 100 42 83 0 1895323344 9601728 11613152
17:10:00 5124 8192000000 10778245760 11207413760 1869547184 18.581 100 17 34 1 1880617664 6416320 4654160
17:10:11 8025 8192000000 10790341840 11217285120 1880223136 18.667 100 34 66 1 1898227760 8567456 9437168
17:10:26 6265 8192000000 10793679872 11219349504 1884734848 18.703 100 27 53 0 1899182272 6125216 8322208
17:10:38 15688 8192000000 10788473728 11221417984 1885536160 18.710 100 17 34 2 1896581776 6113328 4932288
17:11:00 9310 8192000000 10813170592 11232452608 1893233152 18.772 100 29 58 2 1907576624 6771424 7572048
17:11:16 2771 8192000000 10809755232 11236532224 1894770176 18.784 100 40 80 0 1914210048 8186624 11253248
17:11:28 7201 8192000000 10802619120 11234447360 1897842656 18.809 100 27 54 0 1912326992 6971840 7512496
17:11:43 11544 8192000000 10811767568 11242840064 1901021136 18.835 100 20 40 0 1913956816 7208096 5727584
17:12:02 30607 8192000000 10810580992 11250671616 1906037936 18.875 100 42 81 6 1924618160 5047856 13532368
17:12:54 27537 8192000000 10852891120 11264765952 1912789600 18.929 100 62 123 0 1937924320 6019968 19114752
17:13:27 7273 8192000000 10822123024 11256471552 1907395504 18.886 100 31 62 2 1924276224 8226464 8654256
17:13:41 7009 8192000000 10828378000 11257577472 1907876224 18.890 100 31 63 2 1924401712 7510480 9015008
17:13:54 4463 8192000000 10835234688 11262607360 1909574976 18.903 100 41 80 2 1928448256 8085888 10787392
17:14:07 6110 8192000000 10831280544 11262095360 1911883664 18.922 100 39 78 0 1930015696 7323424 10808608
17:14:20 5883 8192000000 10833072544 11262844928 1913964352 18.938 100 39 75 0 1931676144 7149776 10562016
17:14:33 4448 8192000000 10839531344 11263524864 1912786656 18.929 100 40 80 1 1932332032 7905440 11639936
17:14:45 4000 8192000000 10830228848 11258212352 1908028272 18.891 100 33 64 2 1924492992 7711920 8752800
17:14:57 6540 8192000000 10826151824 11261378560 1909560192 18.903 100 35 70 1 1927344544 7739632 10044720
17:15:12 16682 8192000000 10819565024 11253317632 1886108992 18.714 99 12 24 0 1895002032 5690464 3202576
17:15:35 16027 8192000000 10810397504 11242016768 1878414928 18.652 99 16 31 1 1888801952 5848480 4538544
17:16:04 14841 8192000000 10803250192 11246141440 1881941200 18.681 99 16 32 1 1892864320 5699152 5223968
17:16:55 28098 8192000000 10788224048 11219169280 1812151504 18.113 96 18 36 1 1822550176 5595424 4803248
17:17:31 10194 8192000000 10808234432 11242762240 1884294304 18.700 100 25 49 1 1897465760 6036944 7134512
17:17:49 8858 8192000000 10815110304 11240591360 1892162960 18.763 100 28 56 1 1906578704 5944384 8471360
17:18:07 3551 8192000000 10798303920 11225370624 1878617312 18.654 100 36 70 3 1896367536 7008944 10741280
17:18:18 8048 8192000000 10769150144 11188224000 1792045632 17.949 96 26 52 0 1805382768 6452864 6884272
17:18:33 10852 8192000000 10728192080 11152007168 1743035408 17.544 94 16 32 1 1752674688 5003648 4635632
17:18:51 6972 8192000000 10735225200 11161899008 1800282544 18.016 98 18 36 0 1811348400 5628368 5437488
17:19:05 6406 8192000000 10726087824 11138981888 1760700816 17.690 96 24 48 1 1773589904 5188400 7700688
17:19:21 7445 8192000000 10704958336 11131338752 1754831872 17.642 97 17 34 2 1765131040 5498672 4800496
17:19:35 6834 8192000000 10705793440 11123269632 1733949056 17.468 96 17 34 2 1744274608 5562784 4762768
17:19:49 12186 8192000000 10721032656 11139092480 1762422928 17.704 98 17 32 1 1772572816 5502064 4647824
17:20:07 10750 8192000000 10686232640 11105026048 1708543088 17.257 94 20 40 1 1719849696 4791232 6515376
17:20:26 9281 8192000000 10696633840 11115921408 1747912384 17.584 97 20 39 3 1759418160 5682272 5823504
17:20:44 9748 8192000000 10703028928 11093266432 1721123264 17.362 96 26 52 2 1734611824 6160480 7328080
17:21:03 59288 8192000000 10703933904 11117563904 1770637936 17.772 99 37 74 2 1786509760 5159952 10711872
17:22:08 11653 8192000000 10687059056 11108007936 1726278832 17.405 96 21 42 0 1737653680 5120144 6254704
17:22:26 10781 8192000000 10702942016 11124256768 1760647776 17.690 98 26 52 0 1774132976 6287136 7198064
17:22:43 9018 8192000000 10729418176 11139198976 1768553888 17.755 98 41 82 0 1791178800 11654496 10970416
17:22:59 6362 8192000000 10736582688 11148513280 1812105744 18.113 100 40 80 1 1830129216 6649408 11374064
17:23:13 6321 8192000000 10760266064 11166212096 1827001904 18.235 100 37 74 1 1844400160 6548528 10849728
17:23:26 7909 8192000000 10743287984 11165147136 1826990960 18.235 100 24 48 1 1839521072 5154112 7376000
17:23:41 6399 8192000000 10742207616 11166007296 1825440592 18.222 100 15 29 1 1834331312 4888720 4002000
17:23:54 4624 8192000000 10735470272 11168735232 1830018880 18.259 100 13 26 0 1839998672 6139584 3840208
17:24:07 9787 8192000000 10743663200 11174010880 1837412992 18.320 100 20 40 1 1848307040 5173248 5720800
17:24:23 7389 8192000000 10754763920 11183734784 1845506320 18.386 100 21 42 4 1858059616 6000960 6552336
17:24:40 8896 8192000000 10766064848 11190427648 1847326432 18.400 100 25 50 0 1859959280 5527552 7105296
17:24:55 8795 8192000000 10756533760 11191218176 1850877984 18.429 100 19 38 2 1861932112 5634672 5419456
17:25:16 9652 8192000000 10767016832 11193913344 1852927600 18.446 100 21 43 0 1865108112 5270144 6910368
17:25:36 13159 8192000000 10774893552 11200720896 1855582048 18.467 100 19 38 1 1870922992 9988224 5352720
17:25:56 67764 8192000000 10800121824 11218395136 1866303568 18.554 100 27 53 0 1879780656 5129728 8347360
17:27:13 47502 8192000000 10820886384 11239763968 1889200384 18.739 100 28 56 2 1902748720 5372784 8175552
17:28:11 18322 8192000000 10848049056 11267424256 1915353840 18.950 100 47 90 4 1935568224 7124832 13089552
17:28:40 39883 8192000000 10854696192 11279757312 1923060208 19.011 100 44 88 1 1944827424 8902608 12864608
17:29:41 12662 8192000000 10864288240 11293114368 1937228864 19.125 100 43 86 4 1958018912 8965696 11824352
17:30:02 27374 8192000000 10888448880 11311587328 1947049456 19.203 100 45 90 0 1970978496 10217920 13711120
17:30:36 14784 8192000000 10894370112 11321356288 1953542064 19.255 100 48 94 2 1979277408 12523024 13212320
17:30:57 9275 8192000000 10888861632 11322068992 1957439952 19.286 100 45 89 1 1983836592 13213696 13182944
17:31:17 11503 8192000000 10898363536 11326320640 1960297344 19.308 100 50 100 0 1987930096 13464656 14168096
17:31:35 16794 8192000000 10896204960 11328929792 1962802320 19.328 100 49 99 1 1991520992 14563584 14155088
17:32:09 6244 8192000000 10903815680 11335127040 1968795136 19.376 100 45 87 1 1994012128 12107504 13109488
17:32:26 9057 8192000000 10921751120 11344695296 1973922096 19.417 100 56 112 0 2004127248 13051536 17153616
17:32:49 2584 8192000000 10920186544 11350056960 1979258240 19.459 100 57 114 0 2010838080 15016192 16563648
17:33:02 8676 8192000000 10918621456 11352682496 1983092688 19.489 100 56 112 0 2013359120 13606016 16660416
17:33:18 2680 8192000000 10920696064 11345616896 1979047728 19.457 100 59 117 1 2010782064 13992384 17741952
17:33:33 7533 8192000000 10916218000 11345264640 1974208800 19.419 100 56 112 0 2005891776 15300080 16382896
17:33:51 9972 8192000000 10918040096 11348385792 1977853264 19.448 100 49 98 2 2009122320 16438560 14830496
17:34:13 3285 8192000000 10916631568 11344621568 1961598160 19.319 99 55 110 0 1995637232 16692704 17346368
17:34:25 4204 8192000000 10927365088 11353841664 1978257632 19.451 100 59 118 2 2014406272 18403712 17744928
17:34:38 7879 8192000000 10924287264 11356360704 1981312624 19.475 100 46 91 1 2011834304 17221856 13299824
17:35:08 7240 8192000000 10929980624 11355389952 1980618224 19.470 100 55 110 0 2016223520 19641216 15964080
17:35:27 10366 8192000000 10933748896 11366809600 1985884416 19.511 100 51 102 0 2021536512 20103472 15548624
17:35:52 5985 8192000000 10928823344 11347562496 1954702112 19.264 99 57 113 0 1993352400 21645264 17005024
17:36:06 15889 8192000000 10930248768 11359318016 1978535872 19.453 100 64 128 0 2021678208 22560272 20582064
17:36:31 3613 8192000000 10943220496 11364343808 1981778192 19.479 100 71 139 5 2025394544 22336224 21280128
17:36:42 1765 8192000000 10947477648 11360821248 1984045216 19.497 100 73 144 0 2029836000 23648624 22142160
17:36:50 4846 8192000000 10942028768 11372941312 1988376496 19.531 100 67 135 0 2032438832 24033632 20028704
17:37:05 4778 8192000000 10956707440 11370639360 1987939328 19.528 100 79 157 1 2034681104 23849072 22892704
17:37:17 919 8192000000 10970148400 11381956608 1998729872 19.613 100 92 187 1 2049560992 23413744 27417376
17:37:24 2490 8192000000 10963722560 11386580992 1999313472 19.617 100 87 174 1 2049437248 24892352 25231424
17:37:34 2920 8192000000 10965848720 11379744768 1992323344 19.562 100 77 154 1 2041305088 26785680 22196064
17:37:44 2687 8192000000 10956933392 11375861760 1990879920 19.551 100 83 165 2 2042124944 26947360 24297664
17:37:54 2771 8192000000 10960426624 11380379648 1993568624 19.572 100 84 169 3 2043652528 24808352 25275552
17:38:04 7271 8192000000 10951710496 11374870528 1989085568 19.537 100 69 138 0 2033016576 24158544 19772464
17:38:19 1183 8192000000 10956641232 11381616640 1994819520 19.582 100 79 156 4 2041815232 24083168 22912544
17:38:28 14622 8192000000 10942909248 11359264768 1977263840 19.443 99 76 152 5 2021412224 21926672 22221712
17:38:49 6488 8192000000 10950508448 11385225216 1995658624 19.588 100 62 124 1 2036316080 22241568 18415888
17:39:03 9482 8192000000 10940951008 11382513664 1994792816 19.582 100 52 105 0 2030100176 20190160 15117200
17:39:20 3303 8192000000 10962986608 11390615552 2002147792 19.640 100 62 124 0 2041780208 20926000 18706416
17:39:33 1983 8192000000 10950490784 11374903296 1978972304 19.457 99 89 178 1 2025997440 21478816 25546320
17:39:41 2410 8192000000 10963601232 11378307072 1990903456 19.551 100 94 188 1 2041927728 23654128 27370144
17:39:50 1670 8192000000 10969316464 11389313024 2000477712 19.627 100 91 182 0 2051041664 23412512 27151440
17:39:59 9456 8192000000 10925425904 11347746816 1963606992 19.335 99 69 137 2 2007972800 23320320 21045488
17:40:18 2236 8192000000 10925388704 11345793024 1951372480 19.237 98 78 155 1 1996520560 22170128 22977952
17:40:27 3317 8192000000 10945130336 11365683200 1980273744 19.467 100 79 158 0 2026962416 23451056 23237616
17:40:36 1605 8192000000 10950853248 11362738176 1976144464 19.434 100 94 186 1 2029852432 25217968 28490000
17:40:45 2392 8192000000 10929957280 11339624448 1957470912 19.286 99 83 168 3 2007710704 25187008 25052784
17:40:55 2945 8192000000 10953320464 11361918976 1977692496 19.446 100 92 181 1 2031499456 25898160 27908800
17:41:05 1416 8192000000 10938413840 11360501760 1973240240 19.411 100 82 162 4 2024075008 25625248 25209520
17:41:16 4030 8192000000 10939415376 11364470784 1978797824 19.455 100 79 158 0 2028870272 26234096 23838352
17:41:29 7352 8192000000 10944346432 11366064128 1975303536 19.427 100 62 124 1 2020525520 25823568 19398416
17:41:45 10152 8192000000 10936775696 11363557376 1964862992 19.345 99 69 136 0 2012704352 26328256 21513104
17:42:02 4546 8192000000 10952750144 11376541696 1983707488 19.494 100 70 139 1 2032699840 28270272 20722080
17:42:16 6253 8192000000 10942910336 11375370240 1983147296 19.490 100 64 128 0 2030751248 27660304 19943648
17:42:30 2101 8192000000 10965129648 11378163712 1976371632 19.436 99 82 162 1 2029669376 28253152 25044592
17:42:39 5326 8192000000 10966830192 11377688576 1990788096 19.550 100 83 168 1 2045095216 29112816 25194304
17:42:56 1516 8192000000 10967645264 11389698048 1992895808 19.567 100 90 180 2 2050577792 29759600 27922384
17:43:06 4805 8192000000 10973981104 11395207168 2001717808 19.636 100 78 155 0 2056650592 30379312 24553472
17:43:18 4525 8192000000 10960665376 11370864640 1975806144 19.431 99 78 156 1 2031288512 30912384 24569984
17:43:35 2264 8192000000 10966655840 11390386176 1995883504 19.590 100 76 152 0 2051529648 31539760 24106384
17:43:45 1981 8192000000 10970191520 11391692800 1997005776 19.599 100 86 169 0 2056769136 32573424 27189936
17:43:54 4189 8192000000 10953955472 11380748288 1973311472 19.412 99 69 135 4 2028239824 32442032 22486320
17:44:06 3057 8192000000 10954034736 11366895616 1963766528 19.336 99 84 168 4 2024893392 34520992 26605872
17:44:18 4125 8192000000 10951967824 11364392960 1966560464 19.358 100 84 167 1 2028428736 35388816 26479456
17:44:30 3001 8192000000 10955799280 11366023168 1961446016 19.318 99 90 175 4 2025427952 35741584 28240352
17:44:40 6162 8192000000 10941155104 11367673856 1971148688 19.395 100 68 136 1 2030258256 36458096 22651472
17:44:54 5189 8192000000 10940939888 11359813632 1931938272 19.082 98 66 130 3 1990807264 37326096 21542896
17:45:06 2504 8192000000 10946947648 11367178240 1966622528 19.359 100 75 150 3 2030126944 39278384 24226032
17:45:16 4721 8192000000 10949040240 11366432768 1966966608 19.361 100 82 164 2 2030364224 36856400 26541216
17:45:29 3745 8192000000 10950228784 11366526976 1968994016 19.377 100 76 151 1 2030007504 36503392 24510096
17:45:40 1610 8192000000 10965536336 11380150272 1981237984 19.474 100 89 178 0 2048263632 38563536 28462112
17:45:49 1967 8192000000 10958682368 11370405888 1971945888 19.401 100 94 186 3 2040659696 39945104 28768704
17:45:58 5956 8192000000 10971450816 11386171392 1975343984 19.428 100 85 168 0 2047898320 45250288 27304048
17:46:12 2887 8192000000 10972103088 11384238080 1964951904 19.345 99 90 181 1 2036312624 41649616 29711104
17:46:23 5033 8192000000 10965201520 11384778752 1981765344 19.479 100 78 154 0 2046224832 39579760 24879728
17:46:34 6135 8192000000 10967742128 11390582784 1986773296 19.518 100 74 145 1 2050905040 41068352 23063392
17:46:50 2572 8192000000 10956949488 11364802560 1957625040 19.287 99 82 160 1 2026355728 43439136 25291552
17:47:01 2099 8192000000 10972332144 11383967744 1979539184 19.461 100 89 178 1 2052534336 44032992 28962160
17:47:10 3254 8192000000 10959961760 11371560960 1950472752 19.230 99 83 166 2 2024601600 47207472 26921376
17:47:20 1677 8192000000 10965253088 11373355008 1965112592 19.347 100 88 176 0 2041560752 48720688 27727472
17:47:29 3946 8192000000 10956096528 11381092352 1965272432 19.348 100 75 150 2 2039517808 49316848 24928528
17:47:42 7612 8192000000 10918651888 11355152384 1954847280 19.265 100 56 112 2 2009065376 35969344 18248752
17:48:04 17769 8192000000 10921585392 11366195200 1959054064 19.299 100 39 77 2 2006260112 34953664 12252384
17:48:36 8279 8192000000 10913110528 11360923648 1956129104 19.275 100 31 62 1 1997264784 30421744 10713936
17:48:51 9599 8192000000 10921256832 11366363136 1959903776 19.305 100 39 78 0 2005194240 32329568 12960896
17:49:13 18683 8192000000 10905761584 11355893760 1957310288 19.285 100 30 59 0 1995592784 28557264 9725232
17:49:39 17165 8192000000 10913517200 11365658624 1963161808 19.331 100 27 54 3 1999503952 27672320 8669824
17:50:15 14431 8192000000 10902579232 11348865024 1930395440 19.070 99 37 74 0 1976524736 32960096 13169200
17:50:38 30116 8192000000 10889247232 11339935744 1917831360 18.969 99 21 42 2 1960953680 35344080 7778240
17:51:18 24737 8192000000 10902628496 11363565568 1940910320 19.154 100 26 52 2 1992303280 42173360 9219600
17:51:51 29307 8192000000 10895214848 11351719936 1933032368 19.091 100 23 46 1 1979388304 38384832 7971104
17:52:28 29354 8192000000 10889219040 11342585856 1940258720 19.149 100 15 30 0 1972573728 26992736 5322272
17:53:03 17709 8192000000 10874513680 11341545472 1919336896 18.982 99 14 29 2 1951221760 27813728 4071136
17:53:58 68290 8192000000 10921522048 11349520384 1935012720 19.107 99 35 68 3 1962273888 17866096 9395072
17:55:18 43102 8192000000 10843770736 11301343232 1861321856 18.514 96 19 39 0 1877230400 9680928 6227616
17:56:09 85408 8192000000 10891395408 11350687744 1937065952 19.123 100 16 32 1 1959372992 17888896 4418144
17:57:49 58128 8192000000 10922453088 11360333824 1947010176 19.203 99 34 70 0 1972568992 15316752 10242064
17:59:22 83616 8192000000 10881797952 11348123648 1910558160 18.911 97 14 28 0 1925374672 11552768 3263744
18:00:51 101889 8192000000 10878481152 11346771968 1905912224 18.874 97 8 16 1 1922148256 14146912 2089120
18:02:40 127746 8192000000 10900118288 11366236160 1935347120 19.110 98 3 5 1 1948048224 12292112 408992
18:05:02 80805 8192000000 10905787984 11368128512 1975289408 19.427 100 15 31 0 1988577664 8827088 4461168
18:06:42 77376 8192000000 10924723520 11396116480 1996192176 19.593 100 30 60 2 2015017968 10544704 8281088
18:08:09 43807 8192000000 10940374576 11403268096 1978439120 19.452 99 31 62 0 1999749520 12590032 8720368
18:09:00 68669 8192000000 10928726208 11383709696 1973934496 19.417 99 18 36 0 1986150640 6341808 5874336
18:10:16 11780 8192000000 10916649488 11382345728 1977112688 19.442 99 21 43 0 1989945728 6555632 6277408
18:10:38 30127 8192000000 10903621536 11363315712 1936983120 19.123 97 23 47 0 1952263952 8514784 6766048
18:11:22 39467 8192000000 10943539504 11396165632 1989229760 19.538 100 24 48 1 2008783856 11841296 7712800
18:12:22 51602 8192000000 10920447168 11378888704 1917738608 18.969 96 32 63 1 1941615872 14540816 9336448
18:13:22 28473 8192000000 10916990080 11377094656 1967388576 19.365 99 37 74 1 1991961104 13619520 10953008
18:13:57 24112 8192000000 10919486528 11385348096 1987236048 19.522 100 38 74 1 2012971920 15355632 10380240
18:14:41 48246 8192000000 10887771088 11379896320 1954760656 19.264 99 7 14 1 1968274256 11397792 2115808
18:15:36 92543 8192000000 10912383248 11393478656 1976032544 19.433 100 10 20 0 1986610480 7665296 2912640
18:17:18 67030 8192000000 10912324240 11386376192 1969603568 19.382 99 6 12 1 1980523344 9061664 1858112
18:18:32 76490 8192000000 10912948624 11386478592 1978544960 19.453 99 20 40 2 1994681408 9997376 6139072
18:19:55 37076 8192000000 10906258480 11397394432 1986263440 19.514 100 19 36 0 2010287328 17575680 6448208
18:20:44 54611 8192000000 10915435040 11395325952 1992833696 19.566 100 18 36 1 2007195888 9341232 5020960
18:22:00 70830 8192000000 10914114928 11397222400 1942219600 19.164 97 21 43 1 1963419808 14907696 6292512
18:23:18 107019 8192000000 10885221024 11366293504 1846139600 18.391 93 15 30 1 1867308480 16881456 4287424
18:25:16 90490 8192000000 10885817168 11358412800 1877705040 18.647 95 19 38 1 1898818800 15864928 5248832
18:26:57 71592 8192000000 10878876064 11354148864 1889207664 18.739 96 14 28 0 1906278128 12804288 4266176
18:28:41 72237 8192000000 10880324080 11345829888 1807187504 18.073 91 13 26 0 1824628320 14180736 3260080
18:30:21 37850 8192000000 10850705136 11320725504 1870122448 18.585 96 18 37 0 1890399488 15354144 4922896
18:31:12 84996 8192000000 10876438032 11354767360 1860706848 18.509 95 24 48 0 1877439104 10152576 6579680
18:32:44 43337 8192000000 10860095344 11321442304 1846597840 18.394 95 19 38 1 1861718304 9899712 5220752
18:33:33 53406 8192000000 10855259904 11317071872 1824840688 18.217 94 15 30 0 1836131984 7465744 3825552
18:34:49 42831 8192000000 10898496384 11356839936 1946431360 19.198 100 39 75 1 1967574672 10985408 10157904
18:35:39 36570 8192000000 10903642784 11364884480 1939301456 19.141 99 18 36 0 1957800224 13580480 4918288
18:36:21 63732 8192000000 10893622560 11376746496 1921999904 19.003 98 14 28 2 1941808880 15445024 4363952
18:38:39 99222 8192000000 10892536240 11372904448 1952958560 19.250 100 21 42 0 1972026736 12689760 6378416
18:40:43 12557 8192000000 10874437696 11350233088 1938662816 19.136 99 24 47 1 1960515136 14589776 7262544
18:41:03 21343 8192000000 10878079888 11342131200 1921803120 19.001 98 29 58 0 1941076896 11061184 8212592
18:41:32 37085 8192000000 10863597600 11329904640 1895315280 18.789 97 27 54 0 1914984720 12103072 7566368
18:42:28 49291 8192000000 10877610912 11362598912 1952838400 19.249 100 6 12 0 1964907520 10525760 1543360
18:43:30 37869 8192000000 10857562000 11351764992 1929857664 19.066 99 9 18 0 1943788480 11507632 2423184
18:44:23 71033 8192000000 10876677440 11357974528 1940938592 19.154 99 11 22 1 1954869360 10693808 3236960
18:45:45 49650 8192000000 10890382144 11370078208 1946882304 19.202 99 19 38 0 1961561488 9256016 5423168
18:46:51 76143 8192000000 10850620656 11323670528 1887952352 18.729 96 14 28 0 1900188048 8174160 4061536
18:48:13 55121 8192000000 10869155232 11342905344 1940586944 19.151 100 19 36 1 1954246592 7938080 5721568
18:49:16 50047 8192000000 10860086480 11338366976 1899486240 18.822 97 29 58 1 1918760416 10770944 8503232
18:50:28 80889 8192000000 10848820400 11341901824 1921089760 18.996 99 8 16 0 1937528336 13814144 2624432
18:52:03 44023 8192000000 10840184400 11324579840 1862240368 18.521 96 6 12 0 1870186720 6636256 1310096
18:52:53 58937 8192000000 10870808320 11343994880 1892864608 18.769 98 9 18 0 1904902000 9573920 2463472
18:54:00 59320 8192000000 10884680272 11361357824 1946806464 19.201 100 28 56 1 1971486800 16670784 8009552
18:55:05 55773 8192000000 10882412672 11376963584 1937905744 19.130 99 19 39 0 1963226192 19808928 5511520
18:56:11 52309 8192000000 10878244576 11352006656 1933961920 19.099 99 25 50 1 1956863712 15512304 7389488
18:57:09 96500 8192000000 10897610768 11380543488 1926246448 19.037 98 15 30 0 1943502016 12499152 4756416
18:58:52 82892 8192000000 10880035904 11357954048 1888570064 18.734 96 5 10 0 1901485248 11857264 1057920
19:00:21 60089 8192000000 10904810592 11389501440 1955754496 19.272 99 27 54 1 1974744112 11394496 7595120
19:01:37 80094 8192000000 10901370096 11390173184 1918371792 18.974 97 8 16 0 1934241888 13763168 2106928
19:03:03 119434 8192000000 10912865808 11378475008 1879719536 18.663 95 10 20 0 1901630960 19468896 2442528
19:05:11 41430 8192000000 10936124608 11403358208 1960312240 19.309 99 34 68 0 1990156624 20652496 9191888
19:06:18 27586 8192000000 10946346688 11399565312 1964204336 19.339 99 36 72 2 1994141392 19598880 10338176
19:07:05 99281 8192000000 10897052208 11391991808 1948071088 19.211 99 15 30 0 1973359568 20721360 4567120
19:09:16 33205 8192000000 10900924416 11371429888 1956172224 19.276 99 25 50 1 1972586944 8888032 7526688
19:09:57 50898 8192000000 10891133424 11375603712 1969424064 19.381 100 26 52 0 1986799536 9943120 7432352
19:10:55 39439 8192000000 10903876608 11387772928 1980129264 19.466 100 9 18 1 1992916112 10328736 2458112
19:11:43 35783 8192000000 10882293152 11370639360 1956029088 19.274 99 5 10 0 1966659936 9313424 1317424
19:12:25 34166 8192000000 10877506256 11365404672 1953479744 19.254 99 9 18 0 1970830736 14714096 2636896
19:13:15 81704 8192000000 10896455312 11378302976 1904285072 18.861 96 10 20 2 1917546496 10332272 2929152
19:15:08 79680 8192000000 10875931504 11353464832 1874927872 18.624 95 12 24 0 1890216688 11567504 3721312
19:16:34 105177 8192000000 10879932448 11361796096 1921427952 18.998 98 22 43 0 1936419200 9446800 5544448
19:18:42 70720 8192000000 10872730496 11364761600 1923816272 19.017 98 11 22 1 1939229552 12130864 3282416
19:19:59 38588 8192000000 10882385600 11361280000 1939318352 19.141 99 14 28 0 1956553808 13452400 3783056
19:20:44 49389 8192000000 10853701408 11324665856 1859866896 18.502 95 21 42 0 1873779712 7724208 6188608
19:21:41 45017 8192000000 10871191744 11346067456 1905389072 18.870 98 21 42 1 1921844656 9595824 6859760
19:22:59 58839 8192000000 10874184304 11352211456 1878299696 18.651 96 18 36 1 1896239920 12890896 5049328
19:24:05 71734 8192000000 10855583744 11333079040 1864836560 18.542 96 16 31 3 1884577616 15086032 4655024
19:25:24 41070 8192000000 10876591472 11350642688 1926657248 19.040 99 31 61 3 1952001648 16085088 9259312
19:26:30 34114 8192000000 10862148944 11325927424 1911472800 18.918 99 29 58 1 1927807632 7869552 8465280
19:27:15 23021 8192000000 9317850256 9595215872 473856368 5.468 25 4 8 0 482831808 8005424 970016

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 01-04-2021 19:28:33 to 01-04-2021 19:29:05.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 68 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-04-2021 19:29:06 to 01-04-2021 19:29:08.

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          247360
MON$OLDEST_ACTIVE               247361
MON$OLDEST_SNAPSHOT             247361
MON$NEXT_TRANSACTION            247361
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                       2042784
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.33430 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33430 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33430 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33430 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 ---
:23: 
:24: mscs-test-161.budzdorov.ru    Thu Apr  1 19:27:44 2021
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
--- end of diff output ---

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

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