Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.01.2021 22: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 e0e7b46250ba4f9795ceb55e0face73f
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 2020-09-25 13:42
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.00
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 16829236 kB
MemAvailable 31244900 kB
Buffers 0 kB
Cached 14827680 kB
SwapCached 4868 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-01-27 22:27:12
DTS_END                         2021-01-27 22:27:12.7160
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/58570
TRN_ID                          239568
ATT_ID                          707
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: 9336.31 22782 1120357
customer order: creation 170.52 356 20462
customer order: refuse 14.76 376 1771
order to supplier: creation 45.98 1256 5517
order to supplier: removal 3.33 120204 399
invoice (draft): creation 44.23 3772 5307
invoice (draft): removal 53.02 1015 6362
invoice accept: apply 41.84 18795 5021
invoice accept: cancel 48.20 865 5784
customer reserve: creation 3874.97 183 464996
customer reserve: removal 4745.38 64 569445
realization accept: apply 82.79 186 9935
realization accept: cancel 83.00 123 9960
payment from customer: creation 58.93 111 7072
payment from customer: removal 5.28 86 633
payment to supplier: creation 48.38 110 5805
payment to supplier: removal 3.59 90 431
service: total inventory turnovers 4.46 1574 535
service: total monetary turnovers 6.83 56 820
service: aggregate perf. data 0.82 24339 98
service: refresh index statistics 0.03 282086 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 27-01-2021 22:28:20 to 27-01-2021 22:28:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2756
TEST_TIME 2 2970
TEST_TIME 3 4639
TEST_TIME 4 4529
TEST_TIME 5 4843
TEST_TIME 6 5773
TEST_TIME 7 5904
TEST_TIME 8 6277
TEST_TIME 9 6657
TEST_TIME 10 6798
TEST_TIME 11 7192
TEST_TIME 12 7191
TEST_TIME 13 7219
TEST_TIME 14 7679
TEST_TIME 15 7900
TEST_TIME 16 8245
TEST_TIME 17 8433
TEST_TIME 18 8528
TEST_TIME 19 8917
TEST_TIME 20 8910
TEST_TIME 21 9089
TEST_TIME 22 9382
TEST_TIME 23 9229
TEST_TIME 24 9345
TEST_TIME 25 9442
TEST_TIME 26 9450
TEST_TIME 27 9335
TEST_TIME 28 9359
TEST_TIME 29 9761
TEST_TIME 30 10488
TEST_TIME 31 11433
TEST_TIME 32 11835
TEST_TIME 33 11488
TEST_TIME 34 11356
TEST_TIME 35 11493
TEST_TIME 36 11339
TEST_TIME 37 11124
TEST_TIME 38 11016
TEST_TIME 39 10892
TEST_TIME 40 10816
TEST_TIME 41 10735
TEST_TIME 42 10584
TEST_TIME 43 10505
TEST_TIME 44 10379
TEST_TIME 45 10218
TEST_TIME 46 10064
TEST_TIME 47 10261
TEST_TIME 48 10279
TEST_TIME 49 10220
TEST_TIME 50 10082
TEST_TIME 51 9985
TEST_TIME 52 9991
TEST_TIME 53 9890
TEST_TIME 54 9947
TEST_TIME 55 9937
TEST_TIME 56 9825
TEST_TIME 57 9747
TEST_TIME 58 9640
TEST_TIME 59 9518
TEST_TIME 60 9533
TEST_TIME 61 9533
TEST_TIME 62 9438
TEST_TIME 63 9439
TEST_TIME 64 9426
TEST_TIME 65 9412
TEST_TIME 66 9434
TEST_TIME 67 9509
TEST_TIME 68 9488
TEST_TIME 69 9504
TEST_TIME 70 9499
TEST_TIME 71 9646
TEST_TIME 72 9680
TEST_TIME 73 9644
TEST_TIME 74 9631
TEST_TIME 75 9740
TEST_TIME 76 9757
TEST_TIME 77 9692
TEST_TIME 78 9621
TEST_TIME 79 9635
TEST_TIME 80 9555
TEST_TIME 81 9543
TEST_TIME 82 9487
TEST_TIME 83 9471
TEST_TIME 84 9495
TEST_TIME 85 9470
TEST_TIME 86 9400
TEST_TIME 87 9418
TEST_TIME 88 9368
TEST_TIME 89 9374
TEST_TIME 90 9377
TEST_TIME 91 9463
TEST_TIME 92 9449
TEST_TIME 93 9483
TEST_TIME 94 9485
TEST_TIME 95 9445
TEST_TIME 96 9537
TEST_TIME 97 9558
TEST_TIME 98 9521
TEST_TIME 99 9537
TEST_TIME 100 9579
TEST_TIME 101 9597
TEST_TIME 102 9590
TEST_TIME 103 9537
TEST_TIME 104 9463
TEST_TIME 105 9440
TEST_TIME 106 9396
TEST_TIME 107 9371
TEST_TIME 108 9404
TEST_TIME 109 9412
TEST_TIME 110 9424
TEST_TIME 111 9386
TEST_TIME 112 9359
TEST_TIME 113 9341
TEST_TIME 114 9290
TEST_TIME 115 9305
TEST_TIME 116 9318
TEST_TIME 117 9301
TEST_TIME 118 9390
TEST_TIME 119 9393
TEST_TIME 120 9338

Performance per minute, chart


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

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 1550385 1550385 0 0.00 0 16531 6 0 0
doc_list_biud 1550361 1550361 0 0.00 0 44945 31 0 0
sp_add_invoice_to_stock 5160 5021 139 2.69 43 171125 18796 0 139
sp_cancel_adding_invoice 5784 5784 0 0.00 4 67794 865 0 0
sp_cancel_client_order 1771 1771 0 0.00 4 25430 376 0 0
sp_cancel_customer_reserve 569445 569445 0 0.00 1 25210 64 0 0
sp_cancel_pay_from_customer 633 633 0 0.00 3 6534 87 0 0
sp_cancel_pay_to_supplier 431 431 0 0.00 3 6010 91 0 0
sp_cancel_supplier_invoice 6372 6362 10 0.15 1 25708 1016 0 10
sp_cancel_supplier_order 399 399 0 0.00 8 1206845 120204 0 0
sp_cancel_write_off 9960 9960 0 0.00 1 17055 123 0 0
sp_client_order 20462 20462 0 0.00 3 42104 357 0 0
sp_customer_reserve 464996 464996 0 0.00 0 38368 184 0 0
sp_fill_shopping_cart 31280 31280 0 0.00 1 19714 43 0 0
sp_fill_shopping_cart_clo_res 464993 464993 0 0.00 0 17542 13 0 0
sp_get_clo_for_invoice 5017 5017 0 0.00 0 29041 362 0 0
sp_kill_cost_storno 16808 16808 0 0.00 0 9045 61 0 0
sp_kill_qstorno_ret_qs2qd 1155611 1155611 0 0.00 0 25695 36 0 0
sp_kill_qty_storno 608654 608654 0 0.00 0 44938 77 0 0
sp_lock_selected_doc 20646 20646 0 0.00 0 9429 7 0 0
sp_make_cost_storno 27829 27829 0 0.00 0 14323 52 0 0
sp_multiply_rows_for_pdistr 27805 27805 0 0.00 0 7142 29 0 0
sp_multiply_rows_for_qdistr 20462 20462 0 0.00 0 39860 162 0 0
sp_pay_from_customer 7072 7072 0 0.00 4 15013 111 0 0
sp_pay_to_supplier 5805 5805 0 0.00 4 10162 111 0 0
sp_payment_common 12872 12872 0 0.00 1 14982 26 0 0
sp_qd_handle_on_cancel_clo 1771 1771 0 0.00 0 25420 347 0 0
sp_qd_handle_on_invoice_upd_sts 10794 10794 0 0.00 0 25755 393 0 0
sp_qd_handle_on_reserve_upd_sts 9923 9923 0 0.00 0 26708 68 0 0
sp_reserve_write_off 9935 9935 0 0.00 6 26720 187 0 0
sp_supplier_invoice 5307 5307 0 0.00 6 98726 3773 0 0
sp_supplier_order 5517 5517 0 0.00 4 40449 1256 0 0
srv_aggregate_perf_data 98 98 0 0.00 2443 412247 24340 0 0
srv_fill_mon_cache_memory 180 180 0 0.00 1029 128596 28636 0 0
srv_find_qd_qs_mism 1072543 1072543 0 0.00 0 16529 5 0 0
srv_make_invnt_saldo 535 535 0 0.00 36 152632 1575 0 0
srv_make_money_saldo 820 820 0 0.00 1 19794 57 0 0
srv_recalc_idx_stat 4 4 0 0.00 181290 335476 282086 0 0
t$perf-abend:sp_add_invoice_to_stock 139 139 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5021 5021 0 0.00 0 20050 190 0 0
t$perf-norm:sp_cancel_adding_invoice 409 409 0 0.00 0 2943 90 0 0
t$perf-norm:sp_cancel_client_order 1771 1771 0 0.00 0 8880 25 0 0
t$perf-norm:sp_cancel_customer_reserve 677 677 0 0.00 0 728 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 633 633 0 0.00 0 2090 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 431 431 0 0.00 0 1065 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 397 397 0 0.00 0 1263 15 0 0
t$perf-norm:sp_cancel_supplier_order 399 399 0 0.00 0 42472 1803 0 0
t$perf-norm:sp_cancel_write_off 996 996 0 0.00 0 4120 10 0 0
t$perf-norm:sp_client_order 20462 20462 0 0.00 0 7219 19 0 0
t$perf-norm:sp_customer_reserve 958 958 0 0.00 0 1804 9 0 0
t$perf-norm:sp_pay_from_customer 7072 7072 0 0.00 0 9727 10 0 0
t$perf-norm:sp_pay_to_supplier 5805 5805 0 0.00 0 15911 13 0 0
t$perf-norm:sp_reserve_write_off 9935 9935 0 0.00 0 8103 14 0 0
t$perf-norm:sp_supplier_invoice 5307 5307 0 0.00 0 12424 20 0 0
t$perf-norm:sp_supplier_order 5517 5517 0 0.00 0 12973 24 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 141 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 180 180 0 0.00 0 9065 62 0 0
t$perf-norm:srv_make_invnt_saldo 535 535 0 0.00 0 909 29 0 0
t$perf-norm:srv_make_money_saldo 820 820 0 0.00 0 1600 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 9 4 0 0
v_add_invoice_to_stock 10298 10020 278 2.69 0 5608 17 0 278
v_all_customers 37296 37296 0 0.00 0 39 1 0 0
v_all_suppliers 29856 29856 0 0.00 0 102 1 0 0
v_all_wares 40922 40922 0 0.00 0 46 1 0 0
v_cancel_adding_invoice 818 818 0 0.00 0 654 7 0 0
v_cancel_client_order 3542 3542 0 0.00 0 2048 7 0 0
v_cancel_customer_prepayment 1266 1266 0 0.00 0 1094 4 0 0
v_cancel_customer_reserve 1354 1354 0 0.00 0 1387 7 0 0
v_cancel_payment_to_supplier 862 862 0 0.00 0 1367 6 0 0
v_cancel_supplier_invoice 814 794 20 2.45 0 2277 19 0 20
v_cancel_supplier_order 798 798 0 0.00 0 417 3 0 0
v_cancel_write_off 1992 1992 0 0.00 0 1821 15 0 0
v_max_id_clo_ord 5513 5513 0 0.00 0 1791 2 0 0
v_max_id_clo_res 958 958 0 0.00 0 3129 17 0 0
v_max_id_ord_sup 5306 5306 0 0.00 0 3277 3 0 0
v_max_non_paid_invoice 1692 1692 0 0.00 0 235 2 0 0
v_max_non_paid_realizn 3644 3644 0 0.00 0 1027 3 0 0
v_min_id_clo_ord 5513 5513 0 0.00 0 3410 9 0 0
v_min_id_clo_res 958 958 0 0.00 0 5673 13 0 0
v_min_id_ord_sup 5306 5306 0 0.00 0 4997 7 0 0
v_min_non_paid_invoice 5803 5803 0 0.00 0 6837 14 0 0
v_min_non_paid_realizn 7068 7068 0 0.00 0 14688 16 0 0
v_our_firm 10474 10474 0 0.00 0 17 1 0 0
v_reserve_write_off 19846 19846 0 0.00 0 5285 6 0 0
x_lock_depdocs_on_canc_invoice 11749 11749 0 0.00 0 23108 128 0 0
x_lock_depdocs_on_canc_sup_ord 399 399 0 0.00 0 11665 426 0 0
x_make_qstorno_1000_1200 5517 5517 0 0.00 1 40441 1162 0 0
x_make_qstorno_1200_2000 5307 5307 0 0.00 3 98707 3617 0 0
x_make_qstorno_2100_3300 464996 464996 0 0.00 0 36636 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-01-2021 22:28:29 to 27-01-2021 22:28:33.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:22 10977 8192000000 10174338752 10474340352 936511840 10.259 75 59 118 0 959600464 2703744 20384880
19:57:41 45911 8192000000 10353800016 10675552256 1381735680 14.432 100 83 166 2 1414159840 4886976 27537184
19:58:39 20536 8192000000 10390831424 10715025408 1444021136 14.985 100 88 175 1 1479501456 6766928 28713392
19:59:10 33697 8192000000 10428299760 10760925184 1476304528 15.269 100 83 167 0 1510277216 7281568 26691120
19:59:58 17157 8192000000 10461068976 10795421696 1515894368 15.615 100 95 190 0 1554483984 8481136 30108480
20:00:35 23095 8192000000 10484299312 10820608000 1532188944 15.756 100 88 176 0 1569324000 9349440 27785616
20:01:08 19807 8192000000 10507123184 10848014336 1551340128 15.922 100 87 174 0 1588139136 9569792 27229216
20:01:36 10003 8192000000 10505630192 10853224448 1568594192 16.070 100 92 184 1 1607873696 10747520 28531984
20:01:59 12668 8192000000 10518389248 10871504896 1581817600 16.184 100 73 146 0 1614399552 10380032 22201920
20:02:21 13987 8192000000 10549116464 10910834688 1612892880 16.449 100 79 158 0 1647265312 10552368 23820064
20:02:46 11734 8192000000 10577421088 10940092416 1634400384 16.632 100 71 142 1 1666286160 10406224 21479552
20:03:08 11368 8192000000 10608834992 10971824128 1656937408 16.823 100 74 147 0 1690474720 11342192 22195120
20:03:27 5960 8192000000 10630520176 10997256192 1687952864 17.084 100 85 170 1 1725008704 12321808 24734032
20:03:44 9767 8192000000 10632903120 11004952576 1697714448 17.166 100 78 154 0 1732816400 12185408 22916544
20:04:02 6798 8192000000 10643462832 11023859712 1717400000 17.331 100 66 132 1 1747757536 11190400 19167136
20:04:16 7702 8192000000 10678635024 11057545216 1741715408 17.533 100 68 136 0 1771851968 10560416 19576144
20:04:31 10475 8192000000 10703740688 11085316096 1762509008 17.705 100 76 150 1 1795466528 11487376 21470144
20:04:49 4577 8192000000 10703669760 11085058048 1770894864 17.774 100 76 150 3 1804509312 11829920 21784528
20:05:04 4621 8192000000 10729734320 11110350848 1790725024 17.938 100 83 165 1 1826317392 12832192 22760176
20:05:16 4850 8192000000 10731773184 11117191168 1794533232 17.969 100 75 148 2 1827579696 12942784 20103680
20:05:27 4542 8192000000 10750077792 11134750720 1809560016 18.092 100 83 165 0 1845091680 12832672 22698992
20:05:39 2721 8192000000 10755260240 11141390336 1815597552 18.142 100 85 170 0 1852988880 13482768 23908560
20:05:49 3007 8192000000 10761212320 11148660736 1826052752 18.227 100 91 178 2 1864819472 13685744 25080976
20:05:59 2442 8192000000 10761945216 11151200256 1828486832 18.247 100 78 156 0 1863707568 13318336 21902400
20:06:08 2941 8192000000 10771183936 11164696576 1833271968 18.286 100 87 172 2 1871302784 14219872 23810944
20:06:18 2467 8192000000 10773739328 11165143040 1835662288 18.305 100 80 159 0 1871436304 14380880 21393136
20:06:28 4077 8192000000 10758156272 11157434368 1830640608 18.265 100 63 126 0 1860626752 12561344 17424800
20:06:39 2202 8192000000 10782067424 11176853504 1839765696 18.339 100 75 148 2 1872517792 12318144 20433952
20:06:48 3515 8192000000 10798941728 11190411264 1852628464 18.443 100 80 162 0 1888304656 13698496 21977696
20:06:58 2104 8192000000 10798457936 11192111104 1860307184 18.506 100 85 169 0 1897846384 13657664 23881536
20:07:08 2195 8192000000 10805359376 11201724416 1869705120 18.582 100 88 176 1 1908945488 14015808 25224560
20:07:16 2169 8192000000 10804871376 11205103616 1871905264 18.600 100 77 154 0 1905688320 11360080 22422976
20:07:25 2752 8192000000 10823380944 11219111936 1880233520 18.667 100 80 161 0 1913615504 11123680 22258304
20:07:35 1964 8192000000 10825670768 11222712320 1885845392 18.712 100 84 166 0 1920326400 12239664 22241344
20:07:43 1759 8192000000 10832518016 11226304512 1884974352 18.705 100 83 167 1 1921665408 13537200 23153856
20:07:52 1827 8192000000 10831710992 11228012544 1888535472 18.734 100 88 175 0 1926779136 14164384 24079280
20:08:00 1527 8192000000 10827334720 11221254144 1889828320 18.744 100 91 183 1 1929391232 13602768 25960144
20:08:08 1697 8192000000 10834551808 11229609984 1892105536 18.763 100 81 162 3 1926742288 11773424 22863328
20:08:18 8765 8192000000 10833115008 11231531008 1892874368 18.769 100 82 165 2 1928579152 12522800 23181984
20:08:33 1434 8192000000 10834601760 11233722368 1894463872 18.782 100 85 170 2 1932266000 13341760 24460368
20:08:41 24442 8192000000 10794910656 11224727552 1884784064 18.704 100 37 72 0 1904024160 9509616 9730480
20:09:13 6603 8192000000 10793367872 11222798336 1892245360 18.764 100 40 82 1 1910083168 6111840 11725968
20:09:25 4401 8192000000 10794067776 11225833472 1888801600 18.736 100 32 64 0 1905293344 7352832 9138912
20:09:36 5253 8192000000 10796859872 11227721728 1892909648 18.769 100 31 63 4 1909231968 7354608 8967712
20:09:50 4987 8192000000 10804522016 11231199232 1893746768 18.776 100 34 70 0 1911783184 8737568 9298848
20:10:02 6807 8192000000 10807739360 11233116160 1894940512 18.786 100 39 79 1 1913368128 7376752 11050864
20:10:19 7371 8192000000 10806427312 11234451456 1895340736 18.789 100 35 68 1 1913333360 8194528 9798096
20:10:33 6029 8192000000 10800384080 11233443840 1897232464 18.804 100 44 86 2 1917946304 6335216 14378624
20:10:48 6282 8192000000 10806923776 11240763392 1897755264 18.808 100 22 44 0 1910515968 6851024 5909680
20:11:00 11498 8192000000 10803708688 11246100480 1901644736 18.840 100 21 42 3 1913452752 6202560 5605456
20:11:21 15848 8192000000 10816077328 11247783936 1900803856 18.833 100 12 24 0 1910541808 6035440 3702512
20:11:44 6824 8192000000 10810812688 11246649344 1903608704 18.855 100 20 39 3 1914826032 5704704 5512624
20:11:59 10080 8192000000 10816294912 11249348608 1907068496 18.883 100 27 52 1 1921120560 6900624 7151440
20:12:16 20666 8192000000 10821160320 11255906304 1904745680 18.864 100 12 24 1 1914190096 5629168 3815248
20:13:24 34312 8192000000 10817590816 11261399040 1910637200 18.912 100 24 48 1 1922725392 5147552 6940640
20:14:04 3957 8192000000 10838925792 11269332992 1915619952 18.952 100 34 69 2 1931922032 6125056 10177024
20:14:15 8696 8192000000 10826884512 11269332992 1916761376 18.961 100 26 54 1 1930566384 5140720 8664288
20:14:31 6674 8192000000 10835786720 11273625600 1918898256 18.978 100 28 57 0 1933955376 6187440 8869680
20:14:47 5007 8192000000 10831803184 11273232384 1920352864 18.990 100 30 60 0 1935861424 5744976 9763584
20:15:00 12553 8192000000 10831361536 11271790592 1919179840 18.980 100 24 47 4 1932813792 6594272 7039680
20:15:21 7833 8192000000 10829549552 11273805824 1921290784 18.997 100 26 52 1 1934151040 6032288 6827968
20:15:37 10664 8192000000 10835507376 11274338304 1920023920 18.987 100 21 42 0 1936600768 10624592 5952256
20:15:54 7326 8192000000 10831795680 11275538432 1921989424 19.003 100 17 34 2 1932299392 5569072 4740896
20:16:12 8678 8192000000 10822729520 11257937920 1867838304 18.567 97 29 54 0 1882168640 6323952 8006384
20:16:28 11117 8192000000 10807727408 11250278400 1856640832 18.476 97 27 54 3 1871197168 6500560 8055776
20:16:45 12936 8192000000 10793059184 11227176960 1840158512 18.342 97 16 32 1 1850460784 5305280 4996992
20:17:05 11475 8192000000 10805417312 11247529984 1880412416 18.668 99 15 30 3 1889857536 4958272 4486848
20:17:22 53587 8192000000 10772770256 11199516672 1742602048 17.540 92 15 30 2 1750979312 4456880 3920384
20:18:24 26770 8192000000 10726405088 11156582400 1749709840 17.599 94 28 56 2 1763049632 5502784 7837008
20:19:03 13847 8192000000 10744505040 11169165312 1743415280 17.547 94 25 49 2 1755707200 5096688 7195232
20:19:27 4619 8192000000 10724437600 11147735040 1760854912 17.691 96 34 68 1 1776352544 6020496 9477136
20:19:40 6807 8192000000 10684613680 11099508736 1731674160 17.449 97 30 60 2 1746110000 5750368 8685472
20:19:54 6723 8192000000 10686460064 11103834112 1737055680 17.494 97 25 49 2 1750156720 5608528 7492512
20:20:07 8474 8192000000 10709796800 11130433536 1781258448 17.860 99 24 48 1 1794081184 5716416 7106320
20:20:22 14053 8192000000 10690695728 11107770368 1689963392 17.101 94 17 34 0 1699807008 4798304 5045312
20:20:43 6941 8192000000 10686895216 11084455936 1700777680 17.192 95 30 60 0 1714850048 5084368 8988000
20:20:56 7374 8192000000 10699142992 11114151936 1766471072 17.738 99 22 44 2 1778492464 5469456 6551936
20:21:11 7817 8192000000 10698166752 11118735360 1748536448 17.589 97 25 50 1 1761645504 6038576 7070480
20:21:25 7923 8192000000 10729317552 11136937984 1786344288 17.902 99 21 43 0 1798784912 4994160 7446464
20:21:42 12406 8192000000 10730399952 11141763072 1786980240 17.907 99 19 38 1 1798028928 5660176 5388512
20:22:03 8477 8192000000 10707283248 11117563904 1770978768 17.775 99 13 24 1 1779341520 5023760 3338992
20:22:18 79199 8192000000 10728831760 11149701120 1811869856 18.111 100 39 79 1 1829356144 5879744 11606544
20:23:44 13048 8192000000 10743791264 11166330880 1830331104 18.262 100 25 48 2 1843048048 5680288 7036656
20:24:06 4710 8192000000 10761679936 11177713664 1837266624 18.319 100 41 83 0 1855682448 6798944 11616880
20:24:17 8449 8192000000 10770190288 11182153728 1840016640 18.341 100 23 45 1 1852307040 5487760 6802640
20:24:33 9310 8192000000 10765997552 11189334016 1849627216 18.419 100 43 86 3 1868057952 5355056 13075680
20:24:49 7159 8192000000 10762570064 11192242176 1852884208 18.446 100 28 57 2 1867597520 5839200 8874112
20:25:03 11687 8192000000 10779449488 11200331776 1857484448 18.483 100 21 42 2 1869030736 5034016 6512272
20:25:22 15017 8192000000 10776601120 11204661248 1863048400 18.528 100 18 36 0 1873738176 5535440 5154336
20:25:51 9272 8192000000 10794588544 11211743232 1869854320 18.583 100 33 66 0 1885028928 4922192 10252416
20:26:11 14028 8192000000 10785848848 11215675392 1873783904 18.615 100 31 62 2 1888416528 5237504 9395120
20:26:37 11860 8192000000 10783297392 11218255872 1872289936 18.603 100 14 27 1 1881074608 5291632 3493040
20:26:55 103622 8192000000 10820662768 11241775104 1883191552 18.691 100 25 50 0 1895104400 5011296 6901552
20:28:51 31422 8192000000 10839294640 11263393792 1912182640 18.924 100 39 78 0 1931580688 8691344 10706704
20:29:32 14157 8192000000 10856087488 11276718080 1923160912 19.012 100 47 94 1 1947775680 11316704 13298064
20:29:56 5335 8192000000 10861386800 11282677760 1930214768 19.069 100 58 111 2 1957845104 12231168 15399168
20:30:09 2405 8192000000 10880446560 11293077504 1935928128 19.114 100 68 135 1 1968168608 12833072 19407408
20:30:25 13798 8192000000 10873344528 11298373632 1940578160 19.151 100 54 108 2 1969709312 14051696 15079456
20:30:47 10136 8192000000 10880164864 11308695552 1944902928 19.186 100 54 108 0 1978072944 17315424 15854592
20:31:07 22074 8192000000 10880524928 11310395392 1948845072 19.217 100 45 90 0 1974552016 12824928 12882016
20:31:43 14687 8192000000 10888128496 11315535872 1954654672 19.264 100 48 96 2 1981816032 13644608 13516752
20:32:09 17783 8192000000 10905852896 11319177216 1964686512 19.343 100 66 130 0 1998097456 15172848 18238096
20:32:34 11598 8192000000 10885113712 11319541760 1958635056 19.295 100 42 83 1 1984540064 14117632 11787376
20:32:55 9209 8192000000 10910166448 11338444800 1967180576 19.363 100 66 132 3 2009073136 23517168 18375392
20:33:12 4664 8192000000 10922673024 11341565952 1971184560 19.395 100 66 128 2 2010272032 20009664 19077808
20:33:25 12941 8192000000 10923280768 11343409152 1969062064 19.378 100 60 120 2 2011268032 24497648 17708320
20:33:48 5410 8192000000 10912731968 11337396224 1971211776 19.395 100 59 118 5 2006230320 17676144 17342400
20:34:07 10724 8192000000 10903479248 11332804608 1950748816 19.232 99 49 97 1 1982702592 18230752 13723024
20:34:28 14019 8192000000 10923013104 11346268160 1971794560 19.400 100 61 121 2 2009321888 20153632 17373696
20:34:50 2125 8192000000 10918720560 11345207296 1975035792 19.425 100 56 112 1 2011645024 20543552 16065680
20:35:00 6180 8192000000 10918180176 11345608704 1973588832 19.414 100 51 102 0 2012299568 24073536 14637200
20:35:13 10166 8192000000 10930299216 11355271168 1980346960 19.467 100 66 131 0 2021641520 21597424 19697136
20:35:44 8465 8192000000 10934168512 11363008512 1983250848 19.490 100 61 120 1 2022690800 22106032 17333920
20:36:02 9835 8192000000 10897886416 11333242880 1958913296 19.297 99 55 108 4 1996759280 22349984 15496000
20:36:20 17802 8192000000 10900698528 11338301440 1951104176 19.235 99 56 105 2 1985603600 19166416 15333008
20:36:49 6520 8192000000 10920405344 11350491136 1968565120 19.374 100 49 96 2 2004420720 21362736 14492864
20:37:03 7083 8192000000 10930047984 11357691904 1974267552 19.419 100 53 106 1 2012253280 22401536 15584192
20:37:17 8436 8192000000 10927682496 11346690048 1970523424 19.390 100 62 122 1 2012923552 23849744 18550384
20:37:33 12220 8192000000 10921082752 11349463040 1972895696 19.408 100 64 128 1 2016926256 24883920 19146640
20:37:56 4398 8192000000 10928652000 11339694080 1941403680 19.158 98 74 146 2 1985907872 23315904 21188288
20:38:07 5157 8192000000 10920312464 11340439552 1950442432 19.230 99 61 118 1 1996516096 28618464 17455200
20:38:22 4083 8192000000 10921519344 11334090752 1961780960 19.320 100 79 158 1 2011766336 26412816 23572560
20:38:33 1834 8192000000 10942693216 11350196224 1974666096 19.422 100 89 179 0 2027290608 26722736 25901776
20:38:42 3296 8192000000 10937888720 11355070464 1973404528 19.412 100 78 152 1 2023246656 26829376 23012752
20:38:52 6650 8192000000 10916233776 11340492800 1959677552 19.303 100 68 135 1 2007852256 28116912 20057792
20:39:10 4873 8192000000 10909644624 11319271424 1945419984 19.190 99 74 147 1 1994762656 27484096 21858576
20:39:22 10316 8192000000 10916296752 11341111296 1959475504 19.302 100 63 126 0 2005569632 27825552 18268576
20:39:39 3438 8192000000 10926251760 11344875520 1955875456 19.273 100 67 134 1 2004611840 28843552 19892832
20:39:49 4332 8192000000 10920051056 11335647232 1948695664 19.216 100 84 166 0 2007290480 33884368 24710448
20:40:01 3524 8192000000 10917163488 11332829184 1952543792 19.247 100 81 160 1 2007443600 29822480 25077328
20:40:11 7224 8192000000 10916391808 11329974272 1948437760 19.214 100 80 160 0 2003946656 31578480 23930416
20:40:28 3776 8192000000 10924653408 11344506880 1956475440 19.278 100 73 144 0 2010806928 32810112 21521376
20:40:40 2369 8192000000 10915160208 11330670592 1936793920 19.121 99 85 169 3 1994307472 32160416 25353136
20:40:50 1480 8192000000 10933966640 11339169792 1956684336 19.280 100 88 175 3 2015262240 32729312 25848592
20:40:59 6195 8192000000 10937315152 11347726336 1961037952 19.314 100 80 160 0 2020228960 34461072 24729936
20:41:12 5706 8192000000 10920859968 11328413696 1942268480 19.165 99 74 148 0 1998578576 34061936 22248160
20:41:26 4204 8192000000 10932062672 11354845184 1964652720 19.343 100 69 138 2 2021584704 35958576 20973408
20:41:38 2090 8192000000 10909750192 11324448768 1930208512 19.069 99 83 167 1 1986748096 32445952 24093632
20:41:47 2449 8192000000 10928113456 11340095488 1955962240 19.274 100 80 158 1 2013575824 33579616 24033968
20:41:56 3687 8192000000 10928659808 11338153984 1949134352 19.220 100 87 172 0 2010795024 35405168 26255504
20:42:06 3728 8192000000 10931434656 11342565376 1952293936 19.245 100 82 164 2 2013515376 36760064 24461376
20:42:17 1824 8192000000 10925494976 11335020544 1936561680 19.119 99 82 164 1 1993679520 31671072 25446768
20:42:25 1028 8192000000 10918163872 11321556992 1915944320 18.954 98 94 188 2 1980344848 35460672 28939856
20:42:33 3496 8192000000 10908739312 11322085376 1933119152 19.092 100 71 138 2 1990267472 36161344 20986976
20:42:43 7407 8192000000 10918551520 11332214784 1942127664 19.164 100 75 152 0 2000281024 34222320 23931040
20:42:58 6851 8192000000 10913020640 11332718592 1942772368 19.169 100 73 143 3 2001198160 36250320 22175472
20:43:11 2347 8192000000 10890227744 11297370112 1894870368 18.785 97 88 175 1 1960213008 38008608 27334032
20:43:21 3774 8192000000 10861955360 11266940928 1879030240 18.657 98 68 135 0 1939520096 38382480 22107376
20:43:34 2085 8192000000 10882133296 11290632192 1880465856 18.669 98 82 163 0 1942632016 37634432 24531728
20:43:43 1932 8192000000 10899224256 11305500672 1911788912 18.921 100 87 176 1 1979797280 41337184 26671184
20:43:52 2249 8192000000 10905387168 11313381376 1918683760 18.976 100 93 185 0 1990047664 43449040 27914864
20:44:01 7439 8192000000 10869504656 11279495168 1880665632 18.670 99 75 150 2 1943501136 40447392 22388112
20:44:18 2063 8192000000 10892641744 11297980416 1907778368 18.889 100 87 174 0 1972473568 38688176 26007024
20:44:29 7997 8192000000 10899815968 11306557440 1914303008 18.941 100 81 162 3 1981794240 42717440 24773792
20:44:45 4674 8192000000 10905375632 11320102912 1922246272 19.005 100 73 146 2 1991992432 46770336 22975824
20:44:58 1798 8192000000 10924459680 11328299008 1930703696 19.073 100 91 182 0 2005719792 47097568 27918528
20:45:07 5617 8192000000 10896464032 11300659200 1897506416 18.806 99 75 145 1 1967646560 47450720 22689424
20:45:20 3205 8192000000 10925080448 11326230528 1927737456 19.049 100 85 167 1 2001969616 47688512 26543648
20:45:30 2457 8192000000 10922750608 11324502016 1914043408 18.939 99 90 178 0 1990006672 48694448 27268816
20:45:40 3423 8192000000 10932112608 11340836864 1935328512 19.109 100 84 166 0 2009740944 49590496 24821936
20:45:51 1290 8192000000 10940356576 11342925824 1941148704 19.156 100 92 185 1 2020206304 51426432 27631168
20:45:59 2763 8192000000 10946145680 11348844544 1945348528 19.189 100 87 172 2 2023716240 51400160 26967552
20:46:08 5021 8192000000 10950801728 11365314560 1955861280 19.273 100 85 169 1 2034087040 52107248 26118512
20:46:23 1618 8192000000 10951868128 11363794944 1940517776 19.151 99 86 173 0 2018711888 52321296 25872816
20:46:38 2835 8192000000 10946300368 11352285184 1956364720 19.277 100 81 160 2 2031450304 50765856 24319728
20:46:48 4416 8192000000 10947853616 11359137792 1956907392 19.281 100 75 150 1 2026064176 46140928 23015856
20:47:01 3208 8192000000 10952625328 11365904384 1960596992 19.311 100 79 157 1 2031032256 46147152 24288112
20:47:15 2082 8192000000 10946064112 11358875648 1960024448 19.306 100 77 154 2 2032065088 47147552 24893088
20:47:29 5366 8192000000 10936600608 11348180992 1945985712 19.194 100 79 158 1 2018151040 47009200 25156128
20:47:42 5584 8192000000 10958017088 11359215616 1953274592 19.253 100 82 164 0 2027320192 48568256 25477344
20:47:54 7130 8192000000 10953563008 11368710144 1966922848 19.361 100 83 166 1 2041537472 49414304 25200320
20:48:09 1390 8192000000 10978412400 11381481472 1972768672 19.407 100 91 178 1 2050036384 51019856 26247856
20:48:17 4543 8192000000 10942393312 11352698880 1933144896 19.092 99 72 142 1 2006659952 51109088 22405968
20:48:28 7422 8192000000 10938254592 11364093952 1953977824 19.258 100 54 108 0 2022510944 51176944 17356176
20:48:54 7218 8192000000 10933452064 11361439744 1949748512 19.224 100 49 98 2 2015671840 48960656 16962672
20:49:09 6149 8192000000 10939443344 11362041856 1957620080 19.287 100 48 96 2 2016450928 43073008 15757840
20:49:23 10123 8192000000 10930602256 11372539904 1966387680 19.357 100 39 78 1 2024730288 44571632 13770976
20:49:42 10121 8192000000 10936389136 11368841216 1952034032 19.243 99 40 80 0 2009261872 43740144 13487696
20:49:58 11897 8192000000 10936723776 11377184768 1969016224 19.378 100 37 73 1 2024739696 43440992 12282480
20:50:18 9907 8192000000 10957043504 11388338176 1974774032 19.423 100 47 94 0 2034347184 44405696 15167456
20:50:43 5751 8192000000 10975595488 11394420736 1985144832 19.505 100 57 111 0 2048940848 45868576 17927440
20:50:57 7768 8192000000 10954675776 11388911616 1975646240 19.430 100 56 112 0 2043449744 49041856 18761648
20:51:13 7127 8192000000 10960703808 11382476800 1970965792 19.393 100 50 99 2 2033267440 45936304 16365344
20:51:26 4934 8192000000 10953835344 11379240960 1968381904 19.373 100 48 94 1 2031673168 47729904 15561360
20:51:42 5248 8192000000 10949484832 11376873472 1964863728 19.345 100 49 97 2 2028929200 48192608 15872864
20:51:54 7615 8192000000 10950578384 11387469824 1975814480 19.432 100 47 94 0 2038532272 47680832 15036960
20:52:17 8410 8192000000 10976274288 11396579328 1979223952 19.459 100 44 88 0 2045020304 50597104 15199248
20:52:36 3203 8192000000 10992860000 11411976192 1998913408 19.614 100 79 157 0 2078159392 53952496 25293488
20:52:47 10861 8192000000 10972206656 11416023040 1992625424 19.565 100 52 104 0 2063645776 53952736 17067616
20:53:06 13426 8192000000 10974318368 11415347200 1985567568 19.509 100 40 79 0 2051150608 52004400 13578640
20:53:35 16343 8192000000 10980219920 11421548544 1993759424 19.573 100 42 84 2 2066531488 58133968 14638096
20:54:00 17460 8192000000 10976977232 11414208512 1970294400 19.388 99 39 78 2 2041773328 57912896 13566032
20:54:36 19462 8192000000 10987482272 11426508800 1990251136 19.546 100 44 88 3 2070040288 64330832 15458320
20:55:18 10680 8192000000 10973011808 11422859264 1974402384 19.420 100 36 73 0 2058492160 70071872 14017904
20:55:35 7264 8192000000 10976321456 11419181056 1976601504 19.438 100 42 83 0 2063506448 71516352 15388592
20:55:53 8784 8192000000 10980711392 11425648640 1968337728 19.372 100 40 80 2 2061461760 77738000 15386032
20:56:28 14851 8192000000 10965341472 11418390528 1962818384 19.328 100 33 67 0 2060842176 84569552 13454240
20:57:05 23047 8192000000 10947658480 11403264000 1882430272 18.685 96 30 60 0 1971333840 77832896 11070672
20:57:41 30706 8192000000 10937427808 11398692864 1956575424 19.279 100 24 48 3 2024885936 60144448 8166064
20:58:19 15795 8192000000 10932599904 11392684032 1948340880 19.213 99 24 48 0 2011837280 55768496 7727904
20:58:47 62503 8192000000 10920676864 11372175360 1959671856 19.303 99 16 32 0 1989362720 24809744 4881120
21:00:22 57356 8192000000 10951650912 11385651200 1989463984 19.540 100 60 119 1 2025136928 18516688 17156256
21:01:26 33119 8192000000 10960075392 11394838528 1996256544 19.593 100 53 108 1 2032869088 21520208 15092336
21:02:06 22103 8192000000 10921938272 11396665344 1993654064 19.573 100 36 71 3 2018736864 15214304 9868496
21:02:43 60219 8192000000 10932779648 11387813888 1997137008 19.600 100 14 28 0 2014549504 13224064 4188432
21:04:25 85356 8192000000 10925864528 11400085504 1997301424 19.601 100 19 38 0 2014996240 12360640 5334176
21:05:57 98879 8192000000 10929322144 11402887168 1998829792 19.614 100 15 31 0 2017820512 15148400 3842320
21:08:03 68118 8192000000 10918885664 11391750144 1964093808 19.339 98 22 44 0 1980933696 10175040 6664848
21:09:20 37442 8192000000 10918636496 11380334592 1978603216 19.454 99 27 56 2 1998553264 12750368 7199680
21:10:04 70219 8192000000 10932442896 11407724544 2001989104 19.638 100 12 24 1 2018331072 12998448 3343520
21:11:20 95950 8192000000 10940811856 11408896000 1988764304 19.534 99 14 28 2 2009952240 16574624 4613312
21:14:08 118771 8192000000 10918140720 11400142848 1966111872 19.355 98 24 48 1 1985215984 12390000 6714112
21:16:23 80128 8192000000 10907063408 11393994752 1982822960 19.487 99 16 31 1 2003493872 16439744 4231168
21:17:49 20108 8192000000 10918002416 11382030336 1980044512 19.465 99 9 17 0 1998784256 16103408 2636336
21:18:18 13522 8192000000 10959080160 11399847936 2007519488 19.682 100 69 137 2 2035913744 8637648 19756608
21:18:40 20031 8192000000 10936164192 11396562944 2004722128 19.660 100 33 66 0 2022986640 8658336 9606176
21:19:08 75112 8192000000 10942595440 11406876672 1988840736 19.535 99 15 30 0 2002241376 9179616 4221024
21:20:30 28046 8192000000 10948597952 11415212032 2023133728 19.805 100 54 108 0 2047417664 8463184 15820752
21:21:12 44248 8192000000 10929295024 11410432000 2001012512 19.631 99 31 62 2 2023540800 13599504 8928784
21:22:04 42797 8192000000 10899736592 11386470400 1923506832 19.015 96 7 14 1 1938990112 13335104 2148176
21:22:53 17085 8192000000 10896138992 11380146176 1961348480 19.317 99 5 10 1 1973076304 10518016 1209808
21:23:16 33623 8192000000 10878334624 11365220352 1939627360 19.144 98 5 10 0 1950387248 9484192 1275696
21:23:56 73027 8192000000 10874553248 11351953408 1937357856 19.126 98 12 24 1 1947925728 7541344 3026528
21:25:28 128596 8192000000 10904658064 11392098304 1983034704 19.489 100 12 24 0 1997006992 10669536 3302752
21:27:43 53634 8192000000 10906534512 11387772928 1970420880 19.389 99 11 22 0 1988746224 15002416 3322928
21:28:42 71397 8192000000 10897171264 11393482752 1966308400 19.356 99 7 14 2 1982880208 14966656 1605152
21:30:08 45740 8192000000 10878674512 11361828864 1919128656 18.980 97 7 14 0 1927074160 6354016 1591488
21:31:10 42508 8192000000 10889594864 11365109760 1957132432 19.283 99 10 20 0 1965028848 5790016 2106400
21:31:59 22293 8192000000 10884979936 11350753280 1924702624 19.024 98 17 34 0 1938187664 8906896 4578144
21:32:43 80739 8192000000 10892490624 11379908608 1934104896 19.100 98 14 28 2 1956768528 18518112 4145520
21:34:13 43139 8192000000 10883188560 11362951168 1889234256 18.740 96 11 22 0 1902652448 10428064 2990128
21:35:09 32491 8192000000 10885177760 11347533824 1929613552 19.064 99 38 75 1 1951691408 11065584 11012272
21:36:13 68389 8192000000 10890138256 11356205056 1932442528 19.086 99 20 40 2 1958661920 19965264 6254128
21:37:32 92101 8192000000 10859407360 11346915328 1790303824 17.934 92 14 28 1 1828355152 34544288 3507040
21:39:13 50447 8192000000 10849715760 11300339712 1894751184 18.784 98 20 38 3 1915691392 16068816 4871392
21:40:11 53213 8192000000 10863698304 11326439424 1893261440 18.772 98 23 46 0 1909428464 9691248 6475776
21:41:11 39893 8192000000 10865170576 11320320000 1883146576 18.691 97 34 68 2 1907246256 14953120 9146560
21:41:57 68000 8192000000 10835778976 11305717760 1823144912 18.203 95 21 42 0 1849957504 21026224 5786368
21:43:11 118591 8192000000 10829046752 11295006720 1832923872 18.283 96 13 26 1 1858630000 22164464 3541664
21:45:41 92753 8192000000 10826051136 11299663872 1893765392 18.776 99 17 34 1 1921834160 23118496 4950272
21:47:21 9555 8192000000 10839360624 11313664000 1909492928 18.903 100 14 28 0 1932563296 19462768 3607600
21:47:42 62533 8192000000 10836832144 11309240320 1884949776 18.705 98 24 48 0 1905051536 12954528 7147232
21:48:59 83918 8192000000 10846335520 11310678016 1883249088 18.691 98 8 16 0 1900223472 14670528 2303856
21:50:30 74591 8192000000 10833735904 11309019136 1887598432 18.726 98 14 28 1 1904179104 12351408 4229264
21:51:56 68824 8192000000 10838613760 11310555136 1919730368 18.985 100 8 16 0 1929854208 7910464 2213376
21:53:15 40550 8192000000 10864026736 11326050304 1916502528 18.959 99 24 48 1 1935496256 11750928 7242800
21:54:59 52580 8192000000 10872427120 11340197888 1906913328 18.882 98 16 32 2 1921515600 10228944 4373328
21:56:33 41697 8192000000 10858726240 11311325184 1915301616 18.949 99 17 34 0 1930742528 10792880 4648032
21:57:21 39016 8192000000 10883511536 11345547264 1950075168 19.227 100 27 54 1 1971566528 13347280 8144080
21:58:07 64882 8192000000 10866794336 11327336448 1906829984 18.881 98 14 28 0 1922287552 11289936 4167632
21:59:40 63878 8192000000 10882872400 11353214976 1940352448 19.150 99 26 52 2 1961819568 14806032 6661088
22:00:57 72073 8192000000 10899271952 11364311040 1925853168 19.034 98 13 26 0 1937078080 8337936 2886976
22:02:16 29100 8192000000 10915624992 11361665024 1969407696 19.381 100 41 82 2 1995357840 14507152 11442992
22:02:51 55386 8192000000 10912899104 11386101760 1971380544 19.396 100 31 62 2 2000631856 20638768 8612544
22:03:57 109927 8192000000 10909300272 11368263680 1915120064 18.948 97 10 19 1 1931729744 14255776 2353904
22:05:54 47426 8192000000 10916182720 11383197696 1966784272 19.360 99 40 77 1 1989941424 12292704 10864448
22:06:49 76491 8192000000 10904577120 11382628352 1972830464 19.408 100 14 28 2 1989276144 12901920 3543760
22:08:12 84063 8192000000 10898697856 11374313472 1917760416 18.969 97 7 14 0 1931960704 12320224 1880064
22:09:42 81993 8192000000 10896448528 11378716672 1958455408 19.294 99 10 20 1 1972663936 11661872 2546656
22:11:10 66948 8192000000 10858672896 11318919168 1900093168 18.827 96 26 52 2 1915416112 7694608 7628336
22:12:23 77176 8192000000 10896222624 11361255424 1909187248 18.900 97 21 42 0 1922630080 7503248 5939584
22:14:13 47237 8192000000 10899914144 11374604288 1946480720 19.198 98 28 56 1 1970830832 15799952 8550160
22:15:31 75063 8192000000 10878153936 11360559104 1891288320 18.756 96 5 10 1 1909766624 16942016 1536288
22:17:04 50912 8192000000 10896039056 11366756352 1946053488 19.195 99 21 42 3 1965232368 13590496 5588384
22:18:12 60095 8192000000 10894717728 11373506560 1978159712 19.450 100 11 22 1 1990431088 9020800 3250576
22:19:58 30902 8192000000 10907243264 11367186432 1973195552 19.411 100 36 72 2 1990037552 6066928 10775072
22:20:57 77656 8192000000 10873949088 11363479552 1949590576 19.223 99 15 30 1 1962880208 9183376 4106256
22:22:24 49538 8192000000 10909816416 11376889856 1947789408 19.209 99 12 24 0 1960605584 9071920 3744256
22:23:23 47316 8192000000 10897906432 11376693248 1932066528 19.083 98 14 28 0 1953365424 17656832 3642064
22:24:34 36845 8192000000 10885695104 11354828800 1893260880 18.772 96 14 27 2 1911102576 13733440 4108256
22:25:26 69846 8192000000 10876596912 11350528000 1927352144 19.046 99 19 38 0 1943001072 10262256 5386672
22:26:42 36250 8192000000 9178020160 9434243072 335772176 3.937 18 3 6 0 338676576 2465648 438752

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 27-01-2021 22:28:34 to 27-01-2021 22:29:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 139 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          240052
MON$OLDEST_ACTIVE               240053
MON$OLDEST_SNAPSHOT             240053
MON$NEXT_TRANSACTION            240053
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                       2069856
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.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

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

Database validation

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

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

--- start of diff output ---
--- end of diff output ---

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

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