Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.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 17393888 kB
MemAvailable 31465640 kB
Buffers 0 kB
Cached 14250888 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-27 01:27:27
DTS_END                         2021-03-27 01:27:27.2800
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/39506
TRN_ID                          243045
ATT_ID                          716
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: 9378.09 22962 1125371
customer order: creation 173.10 390 20772
customer order: refuse 15.28 322 1834
order to supplier: creation 45.45 1284 5454
order to supplier: removal 3.53 85827 424
invoice (draft): creation 45.71 3595 5485
invoice (draft): removal 53.26 680 6391
invoice accept: apply 42.23 18394 5068
invoice accept: cancel 47.87 746 5744
customer reserve: creation 3927.40 180 471288
customer reserve: removal 4728.86 50 567463
realization accept: apply 83.54 165 10025
realization accept: cancel 80.22 105 9626
payment from customer: creation 60.35 103 7242
payment from customer: removal 5.74 66 689
payment to supplier: creation 49.80 110 5976
payment to supplier: removal 3.59 75 431
service: total inventory turnovers 4.96 1059 595
service: total monetary turnovers 6.36 19 763
service: aggregate perf. data 0.81 22010 97
service: refresh index statistics 0.03 324062 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 27-03-2021 01:28:26 to 27-03-2021 01:28:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 599
TEST_TIME 2 2914
TEST_TIME 3 3502
TEST_TIME 4 4343
TEST_TIME 5 4507
TEST_TIME 6 4670
TEST_TIME 7 4556
TEST_TIME 8 4956
TEST_TIME 9 5095
TEST_TIME 10 5306
TEST_TIME 11 5803
TEST_TIME 12 5951
TEST_TIME 13 6220
TEST_TIME 14 6837
TEST_TIME 15 6875
TEST_TIME 16 7380
TEST_TIME 17 7689
TEST_TIME 18 8196
TEST_TIME 19 8230
TEST_TIME 20 8416
TEST_TIME 21 8816
TEST_TIME 22 8775
TEST_TIME 23 9609
TEST_TIME 24 9697
TEST_TIME 25 10391
TEST_TIME 26 10260
TEST_TIME 27 10394
TEST_TIME 28 10184
TEST_TIME 29 10167
TEST_TIME 30 10312
TEST_TIME 31 10155
TEST_TIME 32 10000
TEST_TIME 33 10025
TEST_TIME 34 9837
TEST_TIME 35 9781
TEST_TIME 36 9624
TEST_TIME 37 9818
TEST_TIME 38 9748
TEST_TIME 39 9721
TEST_TIME 40 9666
TEST_TIME 41 9571
TEST_TIME 42 9516
TEST_TIME 43 9599
TEST_TIME 44 9865
TEST_TIME 45 9858
TEST_TIME 46 9725
TEST_TIME 47 9670
TEST_TIME 48 9685
TEST_TIME 49 9733
TEST_TIME 50 9913
TEST_TIME 51 9940
TEST_TIME 52 9907
TEST_TIME 53 9936
TEST_TIME 54 9839
TEST_TIME 55 9710
TEST_TIME 56 9737
TEST_TIME 57 9701
TEST_TIME 58 9623
TEST_TIME 59 9625
TEST_TIME 60 9579
TEST_TIME 61 9548
TEST_TIME 62 9528
TEST_TIME 63 9427
TEST_TIME 64 9379
TEST_TIME 65 9321
TEST_TIME 66 9425
TEST_TIME 67 9378
TEST_TIME 68 9507
TEST_TIME 69 9478
TEST_TIME 70 9618
TEST_TIME 71 9613
TEST_TIME 72 9546
TEST_TIME 73 9600
TEST_TIME 74 9605
TEST_TIME 75 9602
TEST_TIME 76 9673
TEST_TIME 77 9687
TEST_TIME 78 9717
TEST_TIME 79 9662
TEST_TIME 80 9600
TEST_TIME 81 9559
TEST_TIME 82 9559
TEST_TIME 83 9570
TEST_TIME 84 9513
TEST_TIME 85 9488
TEST_TIME 86 9476
TEST_TIME 87 9459
TEST_TIME 88 9423
TEST_TIME 89 9397
TEST_TIME 90 9392
TEST_TIME 91 9398
TEST_TIME 92 9376
TEST_TIME 93 9378
TEST_TIME 94 9374
TEST_TIME 95 9418
TEST_TIME 96 9400
TEST_TIME 97 9432
TEST_TIME 98 9410
TEST_TIME 99 9494
TEST_TIME 100 9517
TEST_TIME 101 9521
TEST_TIME 102 9492
TEST_TIME 103 9568
TEST_TIME 104 9559
TEST_TIME 105 9535
TEST_TIME 106 9462
TEST_TIME 107 9433
TEST_TIME 108 9392
TEST_TIME 109 9430
TEST_TIME 110 9388
TEST_TIME 111 9347
TEST_TIME 112 9345
TEST_TIME 113 9283
TEST_TIME 114 9330
TEST_TIME 115 9319
TEST_TIME 116 9347
TEST_TIME 117 9370
TEST_TIME 118 9413
TEST_TIME 119 9421
TEST_TIME 120 9378

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-03-2021 01:28:30 to 27-03-2021 01:28:33.

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 1560541 1560541 0 0.00 0 32178 6 0 0
doc_list_biud 1560541 1560541 0 0.00 0 31298 24 0 0
sp_add_invoice_to_stock 5174 5068 106 2.04 34 201983 18394 0 106
sp_cancel_adding_invoice 5744 5744 0 0.00 5 59033 747 0 0
sp_cancel_client_order 1834 1834 0 0.00 4 10107 323 0 0
sp_cancel_customer_reserve 567463 567463 0 0.00 1 27726 51 0 0
sp_cancel_pay_from_customer 689 689 0 0.00 2 4098 67 0 0
sp_cancel_pay_to_supplier 431 431 0 0.00 3 3664 75 0 0
sp_cancel_supplier_invoice 6397 6391 6 0.09 1 14485 681 0 6
sp_cancel_supplier_order 424 424 0 0.00 8 740052 85827 0 0
sp_cancel_write_off 9626 9626 0 0.00 1 23446 105 0 0
sp_client_order 20772 20772 0 0.00 4 32189 391 0 0
sp_customer_reserve 471288 471288 0 0.00 0 57091 181 0 0
sp_fill_shopping_cart 31698 31698 0 0.00 1 15437 38 0 0
sp_fill_shopping_cart_clo_res 471288 471288 0 0.00 0 17272 14 0 0
sp_get_clo_for_invoice 5068 5068 0 0.00 0 24311 339 0 0
sp_kill_cost_storno 16490 16490 0 0.00 0 12067 50 0 0
sp_kill_qstorno_ret_qs2qd 1151367 1151367 0 0.00 0 27132 27 0 0
sp_kill_qty_storno 606575 606575 0 0.00 0 31297 60 0 0
sp_lock_selected_doc 20913 20913 0 0.00 0 9258 4 0 0
sp_make_cost_storno 28311 28311 0 0.00 0 16940 47 0 0
sp_multiply_rows_for_pdistr 28311 28311 0 0.00 0 7611 26 0 0
sp_multiply_rows_for_qdistr 20772 20772 0 0.00 0 22826 166 0 0
sp_pay_from_customer 7242 7242 0 0.00 4 12011 104 0 0
sp_pay_to_supplier 5976 5976 0 0.00 5 8193 111 0 0
sp_payment_common 13218 13218 0 0.00 1 8163 22 0 0
sp_qd_handle_on_cancel_clo 1834 1834 0 0.00 0 10100 292 0 0
sp_qd_handle_on_invoice_upd_sts 10812 10812 0 0.00 0 31297 320 0 0
sp_qd_handle_on_reserve_upd_sts 10025 10025 0 0.00 0 22293 60 0 0
sp_reserve_write_off 10025 10025 0 0.00 6 22302 166 0 0
sp_supplier_invoice 5485 5485 0 0.00 6 100309 3596 0 0
sp_supplier_order 5454 5454 0 0.00 5 55016 1284 0 0
srv_aggregate_perf_data 97 97 0 0.00 2495 704012 22011 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 1720 153626 33984 0 0
srv_find_qd_qs_mism 1076394 1076394 0 0.00 0 32178 6 0 0
srv_make_invnt_saldo 595 595 0 0.00 10 125965 1060 0 0
srv_make_money_saldo 763 763 0 0.00 1 674 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 178322 443822 324062 0 0
t$perf-abend:sp_add_invoice_to_stock 106 106 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5068 5068 0 0.00 0 10243 160 0 0
t$perf-norm:sp_cancel_adding_invoice 393 393 0 0.00 0 3922 99 0 0
t$perf-norm:sp_cancel_client_order 1834 1834 0 0.00 0 4408 18 0 0
t$perf-norm:sp_cancel_customer_reserve 662 662 0 0.00 0 1178 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 689 689 0 0.00 0 3367 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 431 431 0 0.00 0 1944 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 401 401 0 0.00 0 2464 21 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 22984 1641 0 0
t$perf-norm:sp_cancel_write_off 986 986 0 0.00 0 4199 14 0 0
t$perf-norm:sp_client_order 20772 20772 0 0.00 0 5800 17 0 0
t$perf-norm:sp_customer_reserve 1063 1063 0 0.00 0 9161 34 0 0
t$perf-norm:sp_pay_from_customer 7242 7242 0 0.00 0 7551 12 0 0
t$perf-norm:sp_pay_to_supplier 5976 5976 0 0.00 0 9979 12 0 0
t$perf-norm:sp_reserve_write_off 10025 10025 0 0.00 0 4807 8 0 0
t$perf-norm:sp_supplier_invoice 5485 5485 0 0.00 0 4743 15 0 0
t$perf-norm:sp_supplier_order 5454 5454 0 0.00 0 4731 17 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 24 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 2892 22 0 0
t$perf-norm:srv_make_invnt_saldo 595 595 0 0.00 0 853 14 0 0
t$perf-norm:srv_make_money_saldo 763 763 0 0.00 0 2704 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 9 4 0 0
v_add_invoice_to_stock 10348 10136 212 2.04 0 14088 21 0 212
v_all_customers 37934 37934 0 0.00 0 18 1 0 0
v_all_suppliers 30348 30348 0 0.00 0 24 1 0 0
v_all_wares 41542 41542 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 786 786 0 0.00 0 2308 10 0 0
v_cancel_client_order 3668 3668 0 0.00 0 3145 7 0 0
v_cancel_customer_prepayment 1378 1378 0 0.00 0 208 2 0 0
v_cancel_customer_reserve 1324 1324 0 0.00 0 15976 18 0 0
v_cancel_payment_to_supplier 862 862 0 0.00 0 3506 8 0 0
v_cancel_supplier_invoice 814 802 12 1.47 0 1022 14 0 12
v_cancel_supplier_order 848 848 0 0.00 0 2043 9 0 0
v_cancel_write_off 1972 1972 0 0.00 0 5758 21 0 0
v_max_id_clo_ord 5453 5453 0 0.00 0 4449 2 0 0
v_max_id_clo_res 1063 1063 0 0.00 0 7184 22 0 0
v_max_id_ord_sup 5474 5474 0 0.00 0 5110 6 0 0
v_max_non_paid_invoice 1729 1729 0 0.00 0 3473 5 0 0
v_max_non_paid_realizn 3850 3850 0 0.00 0 4091 5 0 0
v_min_id_clo_ord 5453 5453 0 0.00 0 1611 5 0 0
v_min_id_clo_res 1063 1063 0 0.00 0 10581 28 0 0
v_min_id_ord_sup 5474 5474 0 0.00 0 6511 9 0 0
v_min_non_paid_invoice 5976 5976 0 0.00 0 4187 12 0 0
v_min_non_paid_realizn 7242 7242 0 0.00 0 4518 13 0 0
v_our_firm 10392 10392 0 0.00 0 121 1 0 0
v_reserve_write_off 20050 20050 0 0.00 0 12017 8 0 0
x_lock_depdocs_on_canc_invoice 11734 11734 0 0.00 0 29914 108 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 9107 342 0 0
x_make_qstorno_1000_1200 5454 5454 0 0.00 2 54982 1214 0 0
x_make_qstorno_1200_2000 5485 5485 0 0.00 3 99810 3448 0 0
x_make_qstorno_2100_3300 471288 471288 0 0.00 0 57088 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-03-2021 01:28:34 to 27-03-2021 01:28:38.

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:30 7 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:37 9274 8192000000 10176056608 10474299392 949172704 10.383 75 59 119 0 970954896 2405776 19376416
22:57:56 23562 8192000000 10332241200 10645364736 1359000288 14.228 100 87 174 0 1392399504 4389840 29009376
22:58:43 9647 8192000000 10371113456 10690301952 1429734112 14.859 100 90 180 0 1465810608 6428064 29648432
22:59:01 16127 8192000000 10383519920 10705498112 1442469952 14.971 100 92 184 0 1480128256 7131984 30526320
22:59:29 17893 8192000000 10402333840 10728460288 1452061216 15.056 100 85 170 0 1487800912 7991360 27748336
23:00:02 21102 8192000000 10425997904 10754195456 1474515856 15.253 100 90 180 0 1512613520 8886672 29210992
23:00:34 17274 8192000000 10435575904 10766262272 1488899728 15.379 100 91 182 0 1527390448 9392736 29097984
23:01:06 17718 8192000000 10450469744 10782240768 1499240864 15.470 100 90 180 0 1538195696 10221120 28733712
23:01:40 21316 8192000000 10486383792 10830934016 1534019376 15.772 100 79 158 1 1569059584 10531984 24508224
23:02:08 15613 8192000000 10521215792 10872946688 1570479776 16.086 100 76 152 0 1605351744 11421392 23450576
23:02:31 11384 8192000000 10557291808 10909454336 1608277648 16.410 100 83 166 1 1645099968 11758736 25063584
23:02:52 8306 8192000000 10569245936 10926010368 1631474096 16.607 100 77 154 0 1666223280 11858352 22890832
23:03:08 11602 8192000000 10602943904 10965041152 1657015616 16.824 100 80 160 1 1693089472 12435392 23638464
23:03:28 7090 8192000000 10601205024 10967019520 1667608240 16.913 100 81 162 3 1704410544 13429568 23372736
23:03:45 9399 8192000000 10622432752 10987012096 1678367632 17.004 100 80 159 2 1715294304 13263856 23662816
23:04:03 7579 8192000000 10630360544 10997714944 1691924976 17.117 100 83 163 1 1729275008 13321760 24028272
23:04:20 9816 8192000000 10655456976 11025473536 1703774896 17.217 100 73 146 1 1739202768 13690976 21736896
23:04:38 7854 8192000000 10666290976 11039047680 1725056848 17.394 100 82 164 3 1761950464 13605104 23288512
23:04:53 5480 8192000000 10674334048 11048615936 1734501744 17.473 100 80 160 1 1770161728 13525760 22134224
23:05:05 6035 8192000000 10682113856 11058647040 1743559952 17.548 100 83 166 1 1781331536 13707904 24063680
23:05:18 4170 8192000000 10694489680 11069677568 1754309888 17.637 100 79 158 0 1790401376 13714272 22377216
23:05:29 2655 8192000000 10699416352 11075682304 1762112496 17.702 100 86 170 1 1800691472 14419712 24159264
23:05:40 3000 8192000000 10701731648 11079024640 1766222624 17.736 100 88 176 0 1806506896 14613232 25671040
23:05:50 6507 8192000000 10700022528 11084767232 1767693072 17.748 100 72 144 1 1802396512 14466432 20237008
23:06:03 3992 8192000000 10706420560 11093446656 1777587728 17.830 100 72 143 2 1810166976 12837552 19741696
23:06:13 3140 8192000000 10739146320 11123429376 1796328416 17.984 100 72 144 0 1829005168 12623232 20053520
23:06:23 3580 8192000000 10750465440 11135995904 1813332016 18.123 100 80 161 0 1848511520 12634448 22545056
23:06:34 3026 8192000000 10756089056 11141959680 1816846624 18.152 100 83 167 1 1853680880 13037536 23796720
23:06:44 1599 8192000000 10763923664 11150802944 1824671456 18.216 100 86 172 1 1861926928 12609488 24645984
23:06:52 2787 8192000000 10776549360 11160141824 1834417824 18.295 100 90 180 0 1873965648 13542656 26005168
23:07:02 1529 8192000000 10787136928 11170111488 1840305168 18.343 100 95 190 0 1881765648 14521312 26939168
23:07:10 1919 8192000000 10787668752 11176878080 1845956160 18.389 100 85 169 2 1884869376 14311504 24601712
23:07:19 2547 8192000000 10790942784 11185602560 1855998784 18.471 100 83 166 0 1891526480 12509920 23017776
23:07:28 1795 8192000000 10806562512 11192131584 1860953344 18.511 100 93 186 0 1899528112 12361936 26212832
23:07:36 1343 8192000000 10813063968 11198091264 1865711328 18.550 100 98 194 1 1906334560 13325360 27297872
23:07:44 1692 8192000000 10804273280 11196723200 1866553600 18.556 100 88 174 1 1903598656 12177552 24867504
23:07:52 1539 8192000000 10813238720 11200454656 1871661648 18.598 100 93 187 2 1909089312 10518832 26908832
23:08:00 2111 8192000000 10810123200 11201409024 1871058864 18.593 100 87 174 1 1908993136 13163568 24770704
23:08:08 2170 8192000000 10819812576 11210620928 1877486640 18.645 100 91 182 1 1915354912 12299520 25568752
23:08:18 1845 8192000000 10820923520 11208896512 1875840912 18.632 100 86 175 2 1911766480 11918784 24006784
23:08:26 20616 8192000000 10794053376 11204288512 1871993744 18.600 100 57 115 1 1899290064 11640096 15656224
23:08:54 5783 8192000000 10787105232 11204804608 1872851264 18.607 100 34 68 2 1889147728 7068400 9228064
23:09:06 4891 8192000000 10787482704 11207692288 1878158816 18.650 100 51 102 5 1899801936 7749344 13893776
23:09:20 3836 8192000000 10782224400 11208421376 1874845712 18.623 100 24 48 2 1892522512 11192368 6484432
23:09:30 8499 8192000000 10782286688 11209146368 1878739552 18.655 100 37 75 3 1897285520 7326976 11218992
23:09:52 7006 8192000000 10779668384 11209179136 1876052064 18.633 100 21 43 1 1888490784 6887488 5551232
23:10:05 6829 8192000000 10782047360 11213942784 1876218272 18.635 100 18 35 1 1887513760 6310800 4984688
23:10:19 11276 8192000000 10781500368 11217862656 1879876608 18.664 100 23 46 1 1897332656 11036480 6419568
23:10:39 8353 8192000000 10795388784 11218718720 1882946640 18.689 100 33 66 3 1897453504 5652592 8854272
23:10:53 14640 8192000000 10788038112 11220713472 1882696928 18.687 100 24 49 2 1895437296 6543984 6196384
23:11:17 10189 8192000000 10784659984 11222630400 1885064384 18.706 100 13 26 1 1894356864 5688384 3604096
23:11:37 10711 8192000000 10795779952 11225919488 1886733856 18.719 100 21 42 4 1898885504 6132656 6018992
23:11:54 12570 8192000000 10787462512 11225452544 1887098752 18.722 100 23 46 1 1899444128 5893920 6451456
23:12:12 76537 8192000000 10798089424 11237150720 1893846256 18.777 100 39 76 3 1912100512 5739056 12515200
23:13:37 14708 8192000000 10822536480 11247538176 1892714016 18.768 100 21 42 1 1904144960 5742944 5688000
23:13:58 7247 8192000000 10823218112 11248308224 1895130368 18.787 100 32 63 0 1910948256 7066640 8751248
23:14:13 5908 8192000000 10814473712 11242475520 1895364048 18.789 100 32 64 3 1910823536 6258128 9201360
23:14:26 6618 8192000000 10806269376 11243921408 1898393104 18.813 100 31 61 2 1913306000 5718832 9194064
23:14:39 6383 8192000000 10814699584 11247529984 1896644432 18.799 100 21 43 2 1912233712 9676288 5912992
23:14:52 7560 8192000000 10814070464 11246514176 1895845616 18.793 100 27 55 2 1909685840 6333968 7506256
23:15:06 9662 8192000000 10811064544 11247456256 1895967488 18.794 100 13 26 1 1905327392 5502672 3857232
23:15:25 6866 8192000000 10815875664 11250929664 1902009584 18.842 100 31 62 1 1922677136 11259728 9407824
23:15:41 7595 8192000000 10821849024 11260559360 1904715536 18.864 100 25 50 1 1918120080 6311648 7092896
23:15:55 10150 8192000000 10815485936 11251470336 1884066688 18.698 99 20 40 0 1895452624 6020976 5364960
23:16:12 10591 8192000000 10824199856 11257745408 1904103376 18.859 100 22 43 0 1916182096 5598704 6480016
23:16:29 9500 8192000000 10805829024 11239182336 1847106816 18.399 97 16 30 1 1856717984 5044512 4566656
23:16:45 7783 8192000000 10793821200 11228499968 1858618864 18.492 98 24 48 1 1871307920 5728016 6961040
23:16:59 10868 8192000000 10778217888 11217158144 1840957600 18.349 98 17 34 2 1851927952 5633248 5337104
23:17:18 68570 8192000000 10766319232 11194372096 1784706016 17.888 95 25 50 1 1797455088 5426848 7322224
23:18:36 14393 8192000000 10730300288 11150569472 1681231056 17.028 91 17 34 0 1694840640 9227456 4382128
23:19:00 2888 8192000000 10749585792 11158315008 1822762896 18.200 100 45 90 3 1844053856 9162512 12128448
23:19:10 6729 8192000000 10741575456 11160961024 1768230688 17.752 96 37 74 0 1785147200 5550688 11365824
23:19:25 6970 8192000000 10680243344 11098800128 1728925856 17.427 96 25 50 0 1741591136 4817936 7847344
23:19:39 7842 8192000000 10692097696 11103166464 1757277632 17.662 99 27 54 0 1771212832 6059088 7876112
23:19:55 8950 8192000000 10697938768 11121487872 1746610528 17.573 97 20 40 0 1757790928 5621280 5559120
23:20:10 8826 8192000000 10709265488 11130118144 1778680080 17.839 99 18 36 2 1789656848 5605776 5370992
23:20:27 5833 8192000000 10733887856 11149656064 1792884784 17.955 99 21 42 0 1804286592 5328064 6073744
23:20:41 9518 8192000000 10730663040 11149189120 1776530656 17.821 98 9 18 0 1784352288 5380112 2441520
23:20:59 13938 8192000000 10711352000 11118866432 1712797872 17.292 95 30 60 0 1727919696 5876992 9244832
23:21:21 9674 8192000000 10700643120 11117084672 1764019424 17.718 99 26 52 1 1777351120 5486192 7845504
23:21:40 7560 8192000000 10712221872 11137282048 1794379616 17.968 100 18 36 0 1805982288 5755056 5847616
23:21:54 64123 8192000000 10744439776 11150352384 1757170144 17.661 97 32 64 1 1772282352 5058640 10053568
23:23:04 18712 8192000000 10717128448 11148197888 1796620736 17.986 99 24 48 2 1809215232 5408864 7185632
23:23:29 9348 8192000000 10727445680 11145228288 1792890272 17.956 99 22 44 0 1805211424 5837376 6483776
23:23:48 6641 8192000000 10731695728 11151663104 1797589696 17.994 99 29 58 2 1812792464 6633840 8568928
23:24:02 9037 8192000000 10737110592 11161636864 1821171344 18.187 100 27 54 1 1838788672 10291440 7325888
23:24:18 5691 8192000000 10757563440 11178565632 1830640160 18.265 100 20 40 1 1841478352 5534864 5303328
23:24:30 9484 8192000000 10759809120 11186569216 1840253344 18.343 100 35 70 0 1856942928 7306208 9383376
23:24:49 10509 8192000000 10758457072 11180908544 1839971520 18.341 100 30 60 1 1854789728 6243696 8574512
23:25:07 12644 8192000000 10753779456 11185106944 1843828336 18.372 100 16 32 0 1853711744 5491952 4391456
23:25:25 11371 8192000000 10758373312 11188875264 1843762096 18.371 100 14 28 2 1853202896 5697136 3743664
23:25:44 16485 8192000000 10785008480 11209113600 1851067040 18.431 100 17 31 3 1865633680 9791392 4775248
23:26:09 9223 8192000000 10773155216 11201536000 1855008800 18.463 100 12 24 1 1864949728 5635536 4305392
23:26:29 22533 8192000000 10776538512 11208900608 1860783472 18.510 100 12 24 0 1868941728 5224128 2934128
23:27:00 10278 8192000000 10800894320 11222577152 1876990928 18.641 100 28 55 0 1891583120 5839408 8752784
23:27:22 73756 8192000000 10834007408 11251351552 1897900912 18.809 100 36 72 1 1913433472 5096896 10435664
23:28:48 18610 8192000000 10846703856 11260801024 1908615024 18.896 100 48 90 3 1928845424 7534160 12696240
23:29:16 1720 8192000000 10871429232 11277946880 1921596240 19.000 100 72 142 0 1951645088 9320064 20728784
23:29:24 3482 8192000000 10857705440 11276648448 1923013312 19.011 100 58 112 0 1948848448 9362256 16472880
23:29:40 12450 8192000000 10862281872 11286487040 1927596752 19.048 100 52 104 1 1952177776 9502464 15078560
23:29:59 11592 8192000000 10867391888 11293622272 1932424624 19.086 100 51 101 0 1957133840 10110896 14598320
23:30:24 20778 8192000000 10880214528 11301568512 1939384928 19.142 100 60 120 0 1968123424 11699360 17039136
23:31:02 14238 8192000000 10879249136 11303260160 1940949232 19.154 100 53 106 1 1968569792 12490048 15130512
23:31:27 16900 8192000000 10884449024 11309834240 1944563056 19.183 100 55 110 0 1973032080 12822928 15646096
23:31:54 31241 8192000000 10874582224 11314102272 1947526352 19.207 100 42 84 1 1972188464 12658592 12003520
23:32:41 27508 8192000000 10892509024 11328557056 1956446688 19.278 100 44 89 1 1980580784 11107120 13026976
23:33:48 20584 8192000000 10897286368 11334688768 1966469216 19.357 100 41 82 2 1989701232 11519744 11712272
23:34:17 9086 8192000000 10914142400 11343220736 1975420784 19.428 100 54 108 3 2004691456 13482384 15788288
23:34:40 12560 8192000000 10919927472 11352707072 1976880288 19.440 100 50 100 0 2004610720 13558768 14171664
23:35:01 3289 8192000000 10919317216 11344035840 1972916688 19.409 100 56 110 1 2003497008 14100000 16480320
23:35:19 4574 8192000000 10921407552 11350474752 1979369488 19.460 100 59 118 1 2011281440 14960064 16951888
23:35:31 7792 8192000000 10920761248 11350089728 1979787952 19.463 100 56 110 2 2010671008 14795072 16087984
23:35:47 7349 8192000000 10925152272 11356467200 1982763376 19.487 100 62 123 1 2016659840 15334064 18562400
23:36:06 3905 8192000000 10935070624 11359735808 1985666336 19.510 100 59 114 0 2016281200 14409968 16204896
23:36:24 6684 8192000000 10940711168 11368538112 1992723920 19.565 100 62 122 3 2027255472 16103200 18428352
23:36:39 14176 8192000000 10940712848 11376005120 1992364592 19.562 100 55 110 1 2024390080 15998048 16027440
23:37:04 2496 8192000000 10935886816 11366170624 1978461392 19.453 99 68 135 3 2014217888 16169472 19587024
23:37:13 6866 8192000000 10944066960 11372777472 1992936304 19.567 100 63 124 2 2028608704 17037904 18634496
23:37:27 7928 8192000000 10944365200 11377586176 1995795584 19.590 100 55 108 1 2029040224 17342112 15902528
23:37:44 5927 8192000000 10957628560 11387183104 2003040848 19.647 100 72 140 1 2041286016 17789664 20455504
23:37:58 5284 8192000000 10950088576 11372158976 1974722208 19.423 99 71 142 0 2016614656 20461840 21430608
23:38:15 5275 8192000000 10925386944 11350609920 1954595232 19.263 99 77 153 3 2002723888 24977904 23150752
23:38:31 3125 8192000000 10936196512 11358740480 1958958912 19.298 99 69 138 3 1998942624 19294464 20689248
23:38:45 6557 8192000000 10944942384 11369357312 1985432656 19.508 100 69 139 1 2025603024 19655936 20514432
23:39:01 10224 8192000000 10937001024 11371859968 1991780080 19.558 100 63 126 1 2028258496 17706512 18771904
23:39:20 3572 8192000000 10946909696 11369377792 1988554736 19.532 100 70 140 1 2028583504 18792400 21236368
23:39:31 3251 8192000000 10938342400 11357384704 1977295392 19.443 100 77 152 2 2020410016 20572672 22541952
23:39:41 2306 8192000000 10949506880 11363549184 1979853232 19.464 100 80 159 1 2022608512 19775408 22979872
23:39:50 3779 8192000000 10939943888 11361595392 1983249584 19.490 100 82 161 2 2028658032 21401600 24006848
23:40:01 5326 8192000000 10925385216 11345104896 1962659472 19.327 99 76 153 1 2006571424 20631616 23280336
23:40:15 11304 8192000000 10941088304 11364061184 1977876144 19.448 100 63 124 1 2019350528 21973744 19500640
23:40:42 2342 8192000000 10953760672 11369259008 1969178416 19.379 99 84 167 3 2018431888 23981088 25272384
23:40:52 5594 8192000000 10958551536 11371810816 1985610864 19.509 100 71 141 3 2031500480 24159024 21730592
23:41:04 3919 8192000000 10935972384 11358793728 1972830288 19.408 100 74 147 2 2019164288 24448272 21885728
23:41:15 1915 8192000000 10946084864 11364417536 1975395296 19.428 100 70 140 1 2024804976 28066736 21342944
23:41:24 2897 8192000000 10944280512 11366354944 1962146912 19.323 99 75 150 0 2013589536 28312912 23129712
23:41:34 1919 8192000000 10926847472 11341623296 1951860096 19.241 99 85 169 1 2004718672 26905200 25953376
23:41:44 4779 8192000000 10942080832 11365515264 1974364240 19.420 100 77 154 1 2025212032 27587552 23260240
23:41:58 3918 8192000000 10889927104 11301912576 1899519200 18.822 96 71 140 1 1947179072 26038368 21621504
23:42:09 2843 8192000000 10933259776 11349250048 1957251456 19.284 100 73 146 2 2007326928 27943312 22132160
23:42:20 4822 8192000000 10924680320 11343478784 1944509040 19.183 99 77 154 0 1996110528 28682208 22919280
23:42:34 7487 8192000000 10921846240 11344650240 1943460624 19.174 99 73 144 0 1995883536 30712992 21709920
23:42:52 3402 8192000000 10926596432 11351273472 1941178240 19.156 99 72 142 0 1995069696 32638768 21252688
23:43:05 3877 8192000000 10930167584 11348606976 1941141552 19.156 99 73 146 0 1997531504 33742240 22647712
23:43:17 9121 8192000000 10920016896 11345911808 1945085040 19.187 99 68 135 1 1993950208 28752176 20112992
23:43:36 2533 8192000000 10919620688 11345088512 1939253072 19.141 99 63 124 2 1989545296 31736880 18555344
23:43:48 5165 8192000000 10888551184 11309006848 1910478032 18.910 99 66 132 0 1963102752 31161040 21463680
23:44:01 5648 8192000000 10915130960 11331330048 1931971488 19.083 100 64 125 1 1989221728 38102656 19147584
23:44:13 6442 8192000000 10931117136 11341254656 1942734080 19.169 100 81 160 0 2003042256 35620352 24687824
23:44:30 2630 8192000000 10932009872 11338366976 1937951584 19.130 99 90 179 3 2002169024 37246560 26970880
23:44:39 4665 8192000000 10918966896 11337375744 1950393280 19.230 100 79 159 0 2012477952 37668032 24416640
23:44:51 7606 8192000000 10919867664 11346436096 1951197408 19.236 100 63 124 1 2006411040 35974736 19238896
23:45:09 3957 8192000000 10930915504 11350880256 1939203904 19.140 99 66 132 1 1994239520 34979184 20056432
23:45:22 5560 8192000000 10908544896 11342802944 1934610912 19.104 99 64 126 1 1991120208 37111648 19397648
23:45:40 17091 8192000000 10884939568 11325681664 1901604704 18.839 98 36 72 0 1940884144 28047920 11231520
23:46:06 10748 8192000000 10896492144 11333709824 1927927632 19.050 99 36 73 1 1969687808 30151168 11609008
23:46:28 8606 8192000000 10908582208 11337379840 1912601600 18.928 98 58 111 0 1962979600 33348000 17030000
23:46:45 6056 8192000000 10922386672 11348127744 1953204832 19.252 100 69 136 1 2007801344 34117808 20478704
23:46:59 18756 8192000000 10892189088 11331907584 1926285488 19.037 99 32 64 1 1972644016 35393264 10965264
23:47:25 4185 8192000000 10900401632 11332460544 1938445184 19.134 100 47 93 1 1986380528 33225280 14710064
23:47:40 13403 8192000000 10896766304 11333853184 1908623168 18.896 98 40 81 1 1956335424 34059712 13652544
23:48:02 5351 8192000000 10899962976 11331215360 1923371216 19.014 99 46 92 2 1974784480 35495952 15917312
23:48:16 7835 8192000000 10905599360 11342520320 1947208160 19.204 100 67 130 1 2005886880 37604800 21073920
23:48:41 26707 8192000000 10894670912 11338412032 1934027792 19.099 100 30 58 1 1977513200 32861312 10624096
23:49:15 10179 8192000000 10903492528 11341934592 1938880096 19.138 100 38 76 2 1986630080 35066928 12683056
23:49:39 14926 8192000000 10909818048 11348815872 1932128448 19.084 99 40 80 1 1981514912 36693184 12693280
23:50:02 7677 8192000000 10887897088 11324772352 1897610976 18.807 98 62 122 2 1954444368 37017296 19816096
23:50:18 13359 8192000000 10908070992 11342413824 1942725376 19.168 100 50 100 3 1995120608 37042112 15353120
23:50:38 17761 8192000000 10887263568 11350564864 1938605936 19.136 100 25 50 1 1982150576 35056880 8487760
23:51:03 30819 8192000000 10883750064 11354501120 1938424304 19.134 100 8 16 1 1969498480 28422768 2651408
23:51:41 42153 8192000000 10871654864 11329159168 1896249888 18.796 98 11 22 0 1928822688 28789840 3782960
23:52:49 29475 8192000000 10858102192 11297910784 1873535536 18.613 97 11 22 1 1892920048 16667664 2716848
23:53:25 45380 8192000000 10853441360 11310059520 1903260160 18.853 99 25 50 1 1922528800 12138688 7129952
23:54:17 50804 8192000000 10848975232 11301314560 1856015056 18.471 96 6 12 1 1865798144 8148496 1634592
23:55:17 31405 8192000000 10871775152 11304554496 1909847952 18.905 99 20 39 1 1924926000 9669920 5408128
23:55:54 37958 8192000000 10893573104 11321888768 1939232960 19.141 100 47 94 0 1963783104 11205648 13344496
23:56:40 82878 8192000000 10876633136 11334344704 1928975472 19.059 99 33 66 3 1953865152 15967200 8922480
23:58:13 153626 8192000000 10891278384 11351560192 1946804880 19.201 99 31 62 1 1968222752 12378560 9039312
00:00:55 71209 8192000000 10904242736 11346092032 1931897920 19.082 98 26 52 0 1950519936 10430416 8191600
00:02:13 26683 8192000000 10899761840 11360636928 1971690416 19.399 100 30 59 0 1991329008 11310384 8328208
00:02:56 55451 8192000000 10913067072 11368734720 1967401216 19.365 99 42 84 2 1995426704 15196016 12829472
00:04:00 49795 8192000000 10895827008 11374579712 1957092208 19.283 99 27 53 1 1990611632 25534624 7984800
00:04:59 32695 8192000000 10887693616 11362938880 1947507120 19.207 99 6 12 0 1967890256 18910192 1472944
00:05:42 63532 8192000000 10878828144 11345883136 1952937280 19.250 99 9 18 0 1969355568 14002080 2416208
00:06:52 13169 8192000000 10888783376 11363860480 1968258208 19.372 100 8 16 0 1983374432 12752464 2363760
00:07:12 4420 8192000000 10899859808 11366973440 1973414848 19.413 100 6 12 0 1990787424 15265024 2107552
00:07:23 10256 8192000000 10900901136 11370373120 1974508656 19.421 100 9 18 0 1992924240 15755824 2659760
00:07:39 15701 8192000000 10891860272 11361026048 1957568176 19.287 99 15 30 0 1975263776 13314560 4381040
00:08:38 20965 8192000000 10913929936 11376123904 1982030240 19.481 100 20 40 1 2001484464 12340208 7114016
00:09:07 59556 8192000000 10940555936 11397292032 2000484816 19.627 100 44 88 2 2030232592 17041408 12706368
00:10:23 77879 8192000000 10930412736 11419693056 2002104352 19.639 100 18 36 2 2032015776 24515088 5396336
00:11:47 77210 8192000000 10920756176 11394453504 1980234496 19.467 99 21 43 2 1993620288 7284336 6101456
00:13:11 26363 8192000000 10952854928 11398344704 2007532032 19.682 100 45 90 1 2028078368 7799008 12747328
00:13:44 7251 8192000000 10964099984 11409264640 2018051872 19.765 100 59 118 2 2046859536 11626544 17181120
00:14:05 13186 8192000000 10949646240 11411316736 2015633696 19.746 100 34 67 3 2037470528 12380000 9456832
00:14:38 73033 8192000000 10935970880 11411968000 1976660640 19.438 98 30 59 1 2002947856 17873568 8413648
00:16:02 116865 8192000000 10917323984 11405287424 1919251952 18.981 96 12 24 3 1940285408 17713968 3319488
00:18:05 109636 8192000000 10905721936 11373559808 1870410224 18.588 94 6 12 0 1884719296 13051264 1257808
00:20:00 117005 8192000000 10890741264 11361214464 1885037520 18.706 95 8 16 0 1897777760 10854672 1885568
00:22:08 83061 8192000000 10899561616 11373080576 1923185392 19.012 97 22 44 0 1939463104 10066240 6211472
00:23:43 83939 8192000000 10909733968 11369484288 1919513968 18.983 97 32 64 0 1946304384 17438928 9351488
00:25:28 3077 8192000000 10889163728 11344670720 1936250624 19.117 98 51 101 2 1962334080 11250640 14832816
00:25:38 48680 8192000000 10847541520 11323031552 1864477824 18.540 95 27 52 3 1880128592 7996832 7653936
00:26:35 60618 8192000000 10853166944 11324063744 1893653696 18.775 97 10 20 0 1905316416 9054032 2608688
00:27:49 84225 8192000000 10838775296 11301187584 1792577888 17.953 92 18 36 2 1808039344 11010736 4450720
00:29:36 62081 8192000000 10865403744 11337355264 1934052784 19.099 100 16 33 1 1952646784 14137744 4456256
00:30:44 59855 8192000000 10880572816 11355783168 1952217120 19.244 100 19 38 0 1973616080 15807936 5591024
00:31:59 29277 8192000000 10866440912 11343867904 1930885824 19.074 99 16 32 0 1953168832 17771024 4511984
00:32:40 33199 8192000000 10850771552 11311013888 1831585440 18.272 94 22 44 1 1856629184 17870224 7173520
00:33:20 33539 8192000000 10834709632 11294515200 1830102480 18.260 95 17 34 0 1840500320 6248560 4149280
00:34:00 25078 8192000000 10856042576 11312943104 1910293168 18.909 99 41 82 1 1934859664 13234320 11332176
00:34:33 49052 8192000000 10864083696 11329470464 1905509776 18.871 99 22 44 1 1930585920 18659312 6416832
00:35:56 52620 8192000000 10877456256 11334463488 1888083728 18.730 97 25 50 0 1910832288 15451888 7296672
00:37:12 30927 8192000000 10859066144 11333357568 1904199904 18.860 98 21 42 0 1930341488 20103520 6038064
00:37:52 96097 8192000000 10848584208 11307094016 1835780192 18.306 95 16 32 1 1849716800 9735696 4200912
00:39:38 33443 8192000000 10853934048 11302494208 1855489456 18.467 96 46 92 0 1880543024 12397648 12655920
00:40:18 46241 8192000000 10850148416 11306336256 1889270320 18.740 99 29 58 0 1912744544 15658000 7816224
00:41:11 52494 8192000000 10856050000 11313467392 1897025168 18.802 99 25 50 1 1921627104 17674400 6927536
00:42:21 62560 8192000000 10847236000 11331457024 1889997744 18.746 98 23 46 1 1918678704 21837408 6843552
00:43:30 90860 8192000000 10857699840 11334303744 1897177648 18.804 98 9 18 1 1911116032 11441472 2496912
00:45:11 67153 8192000000 10882703520 11343257600 1908571184 18.895 98 10 20 1 1920578032 9204896 2801952
00:46:25 110413 8192000000 10887194448 11351613440 1926714848 19.041 98 30 60 1 1949422192 13569616 9137728
00:48:22 81245 8192000000 10911270368 11373821952 1958104512 19.291 100 30 60 3 1976895312 9595104 9195696
00:49:54 25898 8192000000 10883731072 11351592960 1949750432 19.224 99 26 52 1 1972714064 15443648 7519984
00:51:10 57010 8192000000 10882528304 11361255424 1946838688 19.201 99 13 26 2 1965487728 14770368 3878672
00:52:14 45069 8192000000 10879570368 11356098560 1941205248 19.156 99 15 30 0 1963304864 17484096 4615520
00:53:11 60332 8192000000 10884992576 11355217920 1951915184 19.242 100 9 18 0 1970471216 16136512 2419520
00:54:21 62827 8192000000 10890944896 11372593152 1969699536 19.383 100 18 36 1 1983540512 8547984 5292992
00:55:47 80255 8192000000 10907819232 11370766336 1956002272 19.274 99 18 36 1 1970224864 8751264 5471328
00:57:15 54552 8192000000 10900509776 11379204096 1980303424 19.467 100 15 30 0 1991533072 6772144 4457504
00:58:24 68661 8192000000 10909714432 11399974912 1989072192 19.536 100 8 16 0 1999339232 8492592 1774448
00:59:39 60677 8192000000 10922862560 11402993664 1976294624 19.435 99 13 26 0 1989110560 9488608 3327328
01:00:46 40499 8192000000 10923253888 11393794048 1959888352 19.305 98 16 32 0 1974392976 10349488 4155136
01:02:04 85100 8192000000 10932112704 11404201984 1977796032 19.447 99 17 34 2 1992870368 10696304 4378032
01:03:38 48456 8192000000 10906707968 11379191808 1946542992 19.199 98 19 38 0 1965061648 13114800 5403856
01:05:21 60914 8192000000 10936318400 11400970240 1981551600 19.477 99 37 74 0 2006811920 15155248 10105072
01:06:30 66503 8192000000 10935306928 11415986176 1954130048 19.259 98 21 42 2 1981473920 21320048 6023824
01:08:00 66840 8192000000 10898675904 11367018496 1877341904 18.644 94 17 34 0 1892370704 10465792 4563008
01:09:13 40061 8192000000 10902881296 11355348992 1880245488 18.667 95 26 52 1 1898131536 10645024 7241024
01:09:59 30127 8192000000 10912368368 11373834240 1946166448 19.196 99 39 78 0 1971270928 14167376 10937104
01:10:41 46680 8192000000 10913645312 11385593856 1925228016 19.029 98 20 40 1 1945451712 14798720 5424976
01:11:38 70057 8192000000 10885271344 11357970432 1896778400 18.800 96 18 36 0 1913892256 12477168 4636688
01:13:37 115890 8192000000 10872970080 11342835712 1854091472 18.455 94 19 38 1 1873206256 13385536 5729248
01:15:39 34682 8192000000 10879198816 11356712960 1953600320 19.255 100 9 18 3 1969098048 13127600 2370128
01:16:28 69717 8192000000 10870453008 11362852864 1938126656 19.132 99 18 36 2 1956731312 13286160 5318496
01:17:44 69328 8192000000 10865816688 11339423744 1878961024 18.657 96 9 18 0 1889915488 8296800 2657664
01:20:10 75989 8192000000 10837507552 11326095360 1891771456 18.760 98 17 34 1 1910080464 13087568 5221440
01:21:32 61921 8192000000 10852779248 11330646016 1883216496 18.691 98 12 24 0 1900403008 13641824 3544688
01:22:42 48732 8192000000 10843432672 11323240448 1862222608 18.521 96 32 64 0 1883017664 11407936 9387120
01:23:41 52415 8192000000 10855807920 11332681728 1915655696 18.952 99 15 30 0 1932945552 12968160 4321696
01:24:43 73680 8192000000 10850115456 11322044416 1820361888 18.181 94 17 34 0 1841902528 16764976 4775664
01:26:07 34311 8192000000 10860773296 11322003456 1923296256 19.013 100 42 83 1 1944294896 9416640 11582000
01:26:47 44867 8192000000 10005445216 10384904192 1095633280 11.796 57 18 36 1 1108631712 8297904 4700528

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 27-03-2021 01:28:40 to 27-03-2021 01:29:11.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 106 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

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

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          243209
MON$OLDEST_ACTIVE               243713
MON$OLDEST_SNAPSHOT             243713
MON$NEXT_TRANSACTION            243713
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                       2022720
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:368: 
:369: mscs-test-161.budzdorov.ru    Sat Mar 27 01:27:37 2021
:370:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:371: 
:372: 
:373: mscs-test-161.budzdorov.ru    Sat Mar 27 01:27:37 2021
:374:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:375: 
:376: 
:377: mscs-test-161.budzdorov.ru    Sat Mar 27 01:27:37 2021
:378:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:379: 
:380: 
:381: mscs-test-161.budzdorov.ru    Sat Mar 27 01:27:37 2021
:382:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:383: 
--- end of diff output ---

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

27.03.21 01:29:15. 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-27 01:29:17 No severe PSQL-related problems occured
27.03.21 01:29:19. End of report.