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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17235436 kB
MemAvailable 31302232 kB
Buffers 0 kB
Cached 14431928 kB
SwapCached 4864 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-18 19:27:11
DTS_END                         2021-01-18 19:27:11.1080
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/57556
TRN_ID                          240574
ATT_ID                          708
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: 9367.12 23265 1124054
customer order: creation 174.01 376 20881
customer order: refuse 15.29 342 1835
order to supplier: creation 46.51 1376 5581
order to supplier: removal 3.68 92649 442
invoice (draft): creation 47.28 3558 5673
invoice (draft): removal 52.39 726 6287
invoice accept: apply 42.15 17967 5058
invoice accept: cancel 47.83 711 5739
customer reserve: creation 3924.18 176 470902
customer reserve: removal 4705.47 56 564656
realization accept: apply 86.67 176 10400
realization accept: cancel 88.46 108 10615
payment from customer: creation 60.43 100 7252
payment from customer: removal 6.03 75 723
payment to supplier: creation 50.68 122 6082
payment to supplier: removal 3.28 72 394
service: total inventory turnovers 4.93 994 591
service: total monetary turnovers 6.90 57 828
service: aggregate perf. data 0.93 20647 111
service: refresh index statistics 0.03 325016 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-01-2021 19:28:13 to 18-01-2021 19:28:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5050
TEST_TIME 2 5984
TEST_TIME 3 5880
TEST_TIME 4 6184
TEST_TIME 5 5893
TEST_TIME 6 5659
TEST_TIME 7 5694
TEST_TIME 8 5961
TEST_TIME 9 5827
TEST_TIME 10 5907
TEST_TIME 11 5890
TEST_TIME 12 6277
TEST_TIME 13 6305
TEST_TIME 14 6352
TEST_TIME 15 6507
TEST_TIME 16 7004
TEST_TIME 17 6936
TEST_TIME 18 6954
TEST_TIME 19 8132
TEST_TIME 20 8548
TEST_TIME 21 8760
TEST_TIME 22 8854
TEST_TIME 23 9261
TEST_TIME 24 9578
TEST_TIME 25 9855
TEST_TIME 26 10183
TEST_TIME 27 10781
TEST_TIME 28 10771
TEST_TIME 29 10615
TEST_TIME 30 10285
TEST_TIME 31 10292
TEST_TIME 32 10204
TEST_TIME 33 10274
TEST_TIME 34 10205
TEST_TIME 35 10021
TEST_TIME 36 9972
TEST_TIME 37 9834
TEST_TIME 38 9802
TEST_TIME 39 10082
TEST_TIME 40 9990
TEST_TIME 41 9841
TEST_TIME 42 9775
TEST_TIME 43 9619
TEST_TIME 44 9765
TEST_TIME 45 9631
TEST_TIME 46 9627
TEST_TIME 47 9479
TEST_TIME 48 9383
TEST_TIME 49 9401
TEST_TIME 50 9424
TEST_TIME 51 9530
TEST_TIME 52 9593
TEST_TIME 53 9526
TEST_TIME 54 9672
TEST_TIME 55 9661
TEST_TIME 56 9715
TEST_TIME 57 9707
TEST_TIME 58 9869
TEST_TIME 59 9876
TEST_TIME 60 9904
TEST_TIME 61 9761
TEST_TIME 62 9666
TEST_TIME 63 9641
TEST_TIME 64 9641
TEST_TIME 65 9588
TEST_TIME 66 9590
TEST_TIME 67 9586
TEST_TIME 68 9583
TEST_TIME 69 9575
TEST_TIME 70 9603
TEST_TIME 71 9632
TEST_TIME 72 9594
TEST_TIME 73 9668
TEST_TIME 74 9640
TEST_TIME 75 9660
TEST_TIME 76 9650
TEST_TIME 77 9677
TEST_TIME 78 9697
TEST_TIME 79 9720
TEST_TIME 80 9721
TEST_TIME 81 9706
TEST_TIME 82 9615
TEST_TIME 83 9565
TEST_TIME 84 9498
TEST_TIME 85 9522
TEST_TIME 86 9532
TEST_TIME 87 9485
TEST_TIME 88 9453
TEST_TIME 89 9434
TEST_TIME 90 9377
TEST_TIME 91 9358
TEST_TIME 92 9385
TEST_TIME 93 9391
TEST_TIME 94 9362
TEST_TIME 95 9430
TEST_TIME 96 9449
TEST_TIME 97 9485
TEST_TIME 98 9499
TEST_TIME 99 9479
TEST_TIME 100 9519
TEST_TIME 101 9575
TEST_TIME 102 9601
TEST_TIME 103 9619
TEST_TIME 104 9656
TEST_TIME 105 9602
TEST_TIME 106 9574
TEST_TIME 107 9541
TEST_TIME 108 9472
TEST_TIME 109 9467
TEST_TIME 110 9479
TEST_TIME 111 9428
TEST_TIME 112 9430
TEST_TIME 113 9406
TEST_TIME 114 9396
TEST_TIME 115 9360
TEST_TIME 116 9403
TEST_TIME 117 9379
TEST_TIME 118 9385
TEST_TIME 119 9435
TEST_TIME 120 9369

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 18-01-2021 19:28:16 to 18-01-2021 19:28:20.

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 1559523 1559523 0 0.00 0 20129 6 0 0
doc_list_biud 1559523 1559523 0 0.00 0 28405 26 0 0
sp_add_invoice_to_stock 5183 5058 125 2.41 39 196720 17968 0 125
sp_cancel_adding_invoice 5739 5739 0 0.00 5 39223 711 0 0
sp_cancel_client_order 1835 1835 0 0.00 4 13662 342 0 0
sp_cancel_customer_reserve 564656 564656 0 0.00 1 22183 57 0 0
sp_cancel_pay_from_customer 723 723 0 0.00 3 3938 76 0 0
sp_cancel_pay_to_supplier 394 394 0 0.00 3 2605 72 0 0
sp_cancel_supplier_invoice 6297 6287 10 0.15 1 14806 727 0 10
sp_cancel_supplier_order 442 442 0 0.00 6 1021376 92649 0 0
sp_cancel_write_off 10615 10615 0 0.00 1 19290 109 0 0
sp_client_order 20881 20881 0 0.00 3 13732 377 0 0
sp_customer_reserve 470902 470902 0 0.00 0 39297 176 0 0
sp_fill_shopping_cart 32120 32120 0 0.00 1 12289 36 0 0
sp_fill_shopping_cart_clo_res 470899 470899 0 0.00 0 19923 14 0 0
sp_get_clo_for_invoice 5049 5049 0 0.00 0 33252 306 0 0
sp_kill_cost_storno 17471 17471 0 0.00 0 7995 54 0 0
sp_kill_qstorno_ret_qs2qd 1146656 1146656 0 0.00 0 22178 31 0 0
sp_kill_qty_storno 605021 605021 0 0.00 0 28405 66 0 0
sp_lock_selected_doc 21468 21468 0 0.00 0 6123 5 0 0
sp_make_cost_storno 28781 28781 0 0.00 0 13733 51 0 0
sp_multiply_rows_for_pdistr 28781 28781 0 0.00 0 10398 27 0 0
sp_multiply_rows_for_qdistr 20881 20881 0 0.00 0 9296 168 0 0
sp_pay_from_customer 7252 7252 0 0.00 4 14902 101 0 0
sp_pay_to_supplier 6082 6082 0 0.00 4 11726 123 0 0
sp_payment_common 13334 13334 0 0.00 2 14340 28 0 0
sp_qd_handle_on_cancel_clo 1835 1835 0 0.00 0 13653 304 0 0
sp_qd_handle_on_invoice_upd_sts 10786 10786 0 0.00 0 28403 329 0 0
sp_qd_handle_on_reserve_upd_sts 10400 10400 0 0.00 0 18817 58 0 0
sp_reserve_write_off 10400 10400 0 0.00 6 18912 176 0 0
sp_supplier_invoice 5673 5673 0 0.00 6 68639 3558 0 0
sp_supplier_order 5581 5581 0 0.00 5 47531 1376 0 0
srv_aggregate_perf_data 111 111 0 0.00 2495 638251 20648 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1509 108525 32860 0 0
srv_find_qd_qs_mism 1075055 1075055 0 0.00 0 20127 5 0 0
srv_make_invnt_saldo 591 591 0 0.00 10 56411 995 0 0
srv_make_money_saldo 828 828 0 0.00 1 20301 58 0 0
srv_recalc_idx_stat 4 4 0 0.00 180326 546489 325016 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 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 5058 5058 0 0.00 0 13751 171 0 0
t$perf-norm:sp_cancel_adding_invoice 427 427 0 0.00 0 4928 87 0 0
t$perf-norm:sp_cancel_client_order 1835 1835 0 0.00 0 18087 32 0 0
t$perf-norm:sp_cancel_customer_reserve 721 721 0 0.00 0 1426 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 723 723 0 0.00 0 4565 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 394 394 0 0.00 0 1985 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 414 414 0 0.00 0 1027 13 0 0
t$perf-norm:sp_cancel_supplier_order 442 442 0 0.00 0 17243 1320 0 0
t$perf-norm:sp_cancel_write_off 1067 1067 0 0.00 0 4384 11 0 0
t$perf-norm:sp_client_order 20881 20881 0 0.00 0 16819 21 0 0
t$perf-norm:sp_customer_reserve 993 993 0 0.00 0 587 3 0 0
t$perf-norm:sp_pay_from_customer 7252 7252 0 0.00 0 7914 9 0 0
t$perf-norm:sp_pay_to_supplier 6082 6082 0 0.00 0 9360 15 0 0
t$perf-norm:sp_reserve_write_off 10400 10400 0 0.00 0 8454 10 0 0
t$perf-norm:sp_supplier_invoice 5673 5673 0 0.00 0 5848 19 0 0
t$perf-norm:sp_supplier_order 5581 5581 0 0.00 0 7825 15 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 188 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 5667 41 0 0
t$perf-norm:srv_make_invnt_saldo 591 591 0 0.00 0 2928 21 0 0
t$perf-norm:srv_make_money_saldo 828 828 0 0.00 0 2533 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10340 10090 250 2.41 0 10205 18 0 250
v_all_customers 38176 38176 0 0.00 0 32 1 0 0
v_all_suppliers 31668 31668 0 0.00 0 105 1 0 0
v_all_wares 41762 41762 0 0.00 0 112 1 0 0
v_cancel_adding_invoice 854 854 0 0.00 0 5405 12 0 0
v_cancel_client_order 3670 3670 0 0.00 0 2729 4 0 0
v_cancel_customer_prepayment 1446 1446 0 0.00 0 2439 5 0 0
v_cancel_customer_reserve 1442 1442 0 0.00 0 2556 7 0 0
v_cancel_payment_to_supplier 788 788 0 0.00 0 2595 9 0 0
v_cancel_supplier_invoice 848 828 20 2.35 0 2184 17 0 20
v_cancel_supplier_order 884 884 0 0.00 0 2770 11 0 0
v_cancel_write_off 2134 2134 0 0.00 0 2411 15 0 0
v_max_id_clo_ord 5581 5581 0 0.00 0 729 1 0 0
v_max_id_clo_res 993 993 0 0.00 0 5306 22 0 0
v_max_id_ord_sup 5658 5658 0 0.00 0 1907 2 0 0
v_max_non_paid_invoice 1487 1487 0 0.00 0 1543 3 0 0
v_max_non_paid_realizn 3800 3800 0 0.00 0 354 2 0 0
v_min_id_clo_ord 5581 5581 0 0.00 0 3817 7 0 0
v_min_id_clo_res 993 993 0 0.00 0 5872 19 0 0
v_min_id_ord_sup 5658 5658 0 0.00 0 4650 9 0 0
v_min_non_paid_invoice 6082 6082 0 0.00 0 7815 13 0 0
v_min_non_paid_realizn 7252 7252 0 0.00 0 14333 18 0 0
v_our_firm 10490 10490 0 0.00 0 12 1 0 0
v_reserve_write_off 20800 20800 0 0.00 0 2595 5 0 0
x_lock_depdocs_on_canc_invoice 11612 11612 0 0.00 0 16051 120 0 0
x_lock_depdocs_on_canc_sup_ord 442 442 0 0.00 0 5023 309 0 0
x_make_qstorno_1000_1200 5581 5581 0 0.00 2 47517 1308 0 0
x_make_qstorno_1200_2000 5673 5673 0 0.00 2 68628 3422 0 0
x_make_qstorno_2100_3300 470902 470902 0 0.00 0 39295 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-01-2021 19:28:21 to 18-01-2021 19:28:25.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:14 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:21 16283 8192000000 10239592736 10542170112 969213872 10.579 77 55 111 0 991149888 2865968 19070048
16:57:47 25536 8192000000 10317127552 10631561216 1370104416 14.328 100 84 168 1 1401550336 4784944 26660976
16:58:24 27753 8192000000 10369647520 10690629632 1413296816 14.713 100 85 170 0 1447626624 6370064 27959744
16:59:02 24713 8192000000 10382660064 10707931136 1441718160 14.965 100 88 176 0 1477905584 7521792 28665632
16:59:38 19668 8192000000 10398040576 10726821888 1452964672 15.064 100 91 183 1 1490139520 7783472 29391376
17:00:08 32361 8192000000 10424846528 10756833280 1473155024 15.241 100 89 177 0 1510720768 8706880 28858864
17:00:49 23345 8192000000 10449005072 10784120832 1497683568 15.456 100 87 174 0 1534638128 8740432 28214128
17:01:22 23837 8192000000 10461656720 10806456320 1527047232 15.711 100 85 170 0 1562934192 9084864 26802096
17:02:05 17800 8192000000 10507807488 10856153088 1556027584 15.962 100 83 166 2 1591388400 9437968 25922848
17:02:35 16589 8192000000 10558452960 10915299328 1609566544 16.421 100 80 160 0 1643651088 10035024 24049520
17:03:06 7797 8192000000 10577163152 10939310080 1639985264 16.680 100 76 152 1 1674375760 11374960 23015536
17:03:23 9372 8192000000 10590344288 10956460032 1652481904 16.785 100 74 146 1 1686057808 11924496 21651408
17:03:42 9336 8192000000 10618263040 10984869888 1679232496 17.011 100 81 162 1 1715770640 12571440 23966704
17:04:01 11417 8192000000 10638282752 11013423104 1694218272 17.137 100 71 142 1 1726907872 12338400 20351200
17:04:21 8448 8192000000 10644789744 11023519744 1712433328 17.289 100 75 150 2 1746356512 12576496 21346688
17:04:38 8634 8192000000 10673484704 11052007424 1730485136 17.440 100 74 146 0 1763414320 12251680 20677504
17:04:55 8727 8192000000 10688458496 11067256832 1745986096 17.568 100 77 154 1 1780864544 12865792 22012656
17:05:12 6131 8192000000 10698856288 11075842048 1754046656 17.635 100 81 162 0 1789834896 13249104 22539136
17:05:24 6209 8192000000 10696994096 11079180288 1761826704 17.699 100 82 164 1 1798544768 14004416 22713648
17:05:37 7247 8192000000 10702677104 11083816960 1763397344 17.712 100 79 156 2 1800067520 14894288 21775888
17:05:54 5609 8192000000 10721498000 11106557952 1777485264 17.829 100 76 152 0 1812977776 14020048 21472464
17:06:07 3159 8192000000 10738215504 11119468544 1790527504 17.936 100 88 176 3 1830623120 15167120 24928496
17:06:18 3175 8192000000 10726597424 11112435712 1798131616 17.999 100 81 163 2 1835052096 13820288 23100192
17:06:28 3703 8192000000 10749223312 11137622016 1807759792 18.078 100 84 168 1 1846009616 14414912 23834912
17:06:38 3265 8192000000 10747693856 11137945600 1815260736 18.139 100 80 158 1 1851534480 13459840 22813904
17:06:48 2014 8192000000 10752742432 11144474624 1820573456 18.182 100 87 173 2 1858208640 12745456 24889728
17:06:57 2569 8192000000 10749914496 11144036352 1821448352 18.190 100 76 152 0 1854931824 11656384 21827088
17:07:07 3140 8192000000 10778255632 11164053504 1832701280 18.281 100 84 168 0 1868039936 11017952 24320704
17:07:17 2234 8192000000 10786130480 11171614720 1842567936 18.362 100 81 162 2 1876454880 10729168 23157776
17:07:26 2816 8192000000 10785777184 11180630016 1847959408 18.406 100 83 166 2 1883205456 10558368 24687680
17:07:36 3630 8192000000 10786420224 11181735936 1849635008 18.419 100 74 148 1 1882315680 11060896 21619776
17:07:48 4159 8192000000 10786114848 11184754688 1852552080 18.443 100 72 142 1 1884457776 11670928 20234768
17:07:58 2625 8192000000 10801716496 11191304192 1857038256 18.479 100 85 170 1 1893230048 12896224 23295568
17:08:08 1618 8192000000 10804927104 11192885248 1860782176 18.510 100 92 183 1 1899751168 13527600 25441392
17:08:15 2121 8192000000 10798177360 11192901632 1863034672 18.528 100 91 180 1 1902087616 13286656 25766288
17:08:24 3254 8192000000 10812074592 11202387968 1867428912 18.563 100 91 182 0 1906361344 13196016 25736416
17:08:34 2032 8192000000 10806049920 11205775360 1867585712 18.565 100 83 166 0 1904326640 12911040 23829888
17:08:44 18794 8192000000 10803838560 11203973120 1869233536 18.578 100 75 149 1 1900528208 9638560 21656112
17:09:09 18926 8192000000 10802888704 11203350528 1870544592 18.589 100 68 136 0 1899431520 9847264 19039664
17:09:34 1236 8192000000 10829467232 11219795968 1875584816 18.629 100 96 195 3 1913929712 11368336 26976560
17:09:43 2850 8192000000 10805185696 11209662464 1872098128 18.601 100 73 146 2 1904458800 11699520 20661152
17:09:54 4556 8192000000 10795123168 11211313152 1871772608 18.599 100 68 136 1 1902464816 12121712 18570496
17:10:09 2348 8192000000 10801169824 11207663616 1872440272 18.604 100 53 106 0 1896770400 10016176 14313952
17:10:21 4451 8192000000 10796049728 11207438336 1872378320 18.604 100 56 112 1 1897697024 9266752 16051952
17:10:35 2775 8192000000 10789960880 11205091328 1871747856 18.598 100 49 98 0 1895076688 9609168 13719664
17:10:45 4680 8192000000 10798032224 11211169792 1876372544 18.636 100 52 105 1 1900395408 9548160 14474704
17:10:57 5564 8192000000 10791662400 11209158656 1875013728 18.625 100 44 87 1 1895619008 8306912 12298368
17:11:10 3668 8192000000 10780565344 11209924608 1872563968 18.605 100 30 60 3 1889689696 7741216 9384512
17:11:28 10621 8192000000 10773971936 11204583424 1869198736 18.578 100 12 23 2 1878850384 5917056 3734592
17:11:45 8074 8192000000 10781741744 11210756096 1875598768 18.630 100 21 42 2 1887804720 6261616 5944336
17:12:03 7159 8192000000 10784702720 11215355904 1873388576 18.612 100 20 40 2 1889041232 9845232 5807424
17:12:19 7666 8192000000 10792779328 11219202048 1877655760 18.646 100 26 51 2 1891037520 6073136 7308624
17:12:34 6293 8192000000 10801208032 11223158784 1884511472 18.702 100 30 60 2 1899838160 7382544 7944144
17:12:49 12731 8192000000 10785460240 11221929984 1883668816 18.695 100 29 58 0 1899370240 6656144 9045280
17:13:07 42093 8192000000 10810442080 11230949376 1887773680 18.728 100 32 64 2 1902811664 5757808 9280176
17:13:57 22992 8192000000 10850276688 11246874624 1896498096 18.798 100 73 144 4 1924331936 6774336 21059504
17:14:26 4863 8192000000 10807023184 11238072320 1889719872 18.744 100 44 88 3 1911317344 9466960 12130512
17:14:38 5440 8192000000 10802132352 11232272384 1887658384 18.727 100 35 68 1 1903456864 5051920 10746560
17:14:52 4729 8192000000 10808442160 11238268928 1890765280 18.752 100 37 74 0 1908113088 7084240 10263568
17:15:05 11811 8192000000 10811661456 11245568000 1892277840 18.764 100 23 46 0 1905447568 6319104 6850624
17:15:27 5100 8192000000 10804234032 11241672704 1894485168 18.782 100 28 55 2 1908822976 6041168 8296640
17:15:42 4022 8192000000 10806024992 11243405312 1895065216 18.787 100 31 61 1 1910984896 7289920 8629760
17:15:53 8249 8192000000 10811617392 11246055424 1898468976 18.814 100 25 50 0 1911254288 5382544 7402768
17:16:12 7641 8192000000 10809747744 11242463232 1880596048 18.670 99 29 59 3 1895960144 7226912 8137184
17:16:30 8153 8192000000 10801290384 11234721792 1876884272 18.640 99 22 44 2 1889260512 6125200 6251040
17:16:45 7297 8192000000 10808258032 11244953600 1894600368 18.783 100 35 69 2 1910217456 5733040 9884048
17:16:58 5238 8192000000 10815153536 11235979264 1876373408 18.636 99 40 79 3 1892765472 4929616 11462448
17:17:09 7457 8192000000 10805258528 11231846400 1851919984 18.438 98 22 44 2 1864084320 6351376 5812960
17:17:24 64518 8192000000 10741594176 11154178048 1756928288 17.659 93 43 87 0 1775132096 5134672 13069136
17:18:36 6132 8192000000 10733453264 11153539072 1759930192 17.684 95 31 61 0 1776009840 7683680 8395968
17:18:50 6692 8192000000 10746659856 11170361344 1799473536 18.010 98 23 46 2 1811881520 5834336 6573648
17:19:05 8898 8192000000 10758506816 11190054912 1816543824 18.149 98 27 54 0 1830757376 6151024 8062528
17:19:20 6515 8192000000 10755077952 11180810240 1811242000 18.106 98 28 56 0 1825125936 6086720 7797216
17:19:32 12697 8192000000 10754842752 11182727168 1811940848 18.112 98 28 56 2 1825975680 6579008 7455824
17:19:53 7462 8192000000 10729094768 11149914112 1760435232 17.688 96 22 42 3 1771941184 5866768 5639184
17:20:11 12062 8192000000 10728865360 11157250048 1777117184 17.826 97 23 46 3 1789918464 5744880 7056400
17:20:29 8078 8192000000 10721267744 11139072000 1749842704 17.600 96 23 44 1 1762066992 5934720 6289568
17:20:46 3738 8192000000 10699860608 11113140224 1757939728 17.667 98 37 72 1 1774352480 6026720 10386032
17:20:56 8575 8192000000 10707733616 11116122112 1768629936 17.756 99 31 62 1 1783198496 5630480 8938080
17:21:13 11277 8192000000 10699792592 11111047168 1720430736 17.356 96 17 34 2 1731274832 6173184 4670912
17:21:30 15557 8192000000 10711279104 11117453312 1711744624 17.283 95 42 84 2 1730102176 4539024 13818528
17:21:54 62771 8192000000 10734884976 11161346048 1805396112 18.058 99 30 60 1 1819287056 5145504 8745440
17:23:05 10777 8192000000 10732870352 11158745088 1796608880 17.986 98 28 55 4 1812112400 6244720 9258800
17:23:22 7991 8192000000 10732858080 11147952128 1759777056 17.683 96 34 68 3 1776259440 7305088 9177296
17:23:38 7048 8192000000 10727174736 11151118336 1816003280 18.145 100 30 60 0 1829754944 5185664 8566000
17:23:53 6098 8192000000 10760274288 11167825920 1836001296 18.308 100 36 70 2 1851850736 4815776 11033664
17:24:06 10740 8192000000 10752888576 11166371840 1819598160 18.174 99 27 53 2 1832361312 5138016 7625136
17:24:25 8689 8192000000 10761241328 11175981056 1836194368 18.310 100 31 62 1 1851439984 7024368 8221248
17:24:42 8285 8192000000 10746431328 11177172992 1841077280 18.350 100 23 46 0 1853588128 5990272 6520576
17:24:56 7803 8192000000 10750971120 11179708416 1843816816 18.372 100 19 39 1 1855023392 5691984 5514592
17:25:10 10438 8192000000 10755650880 11184558080 1844971856 18.381 100 14 27 3 1853947776 4987792 3988128
17:25:28 8912 8192000000 10772172208 11197956096 1854410400 18.458 100 22 44 1 1866985472 5688864 6886208
17:25:43 12360 8192000000 10774707632 11199971328 1858355696 18.490 100 16 32 2 1868871952 5504640 5011616
17:26:02 6278 8192000000 10776567008 11202330624 1862126288 18.521 100 25 50 0 1876291136 6536576 7628272
17:26:14 11548 8192000000 10781115168 11208343552 1863999824 18.536 100 27 54 1 1878437984 7178240 7259920
17:26:35 90160 8192000000 10815295296 11234643968 1879779808 18.663 100 40 76 1 1896031152 5956144 10295200
17:28:14 5033 8192000000 10829316352 11244896256 1897930560 18.810 100 53 106 0 1921930320 8940256 15059504
17:28:31 5725 8192000000 10842619440 11251187712 1904190848 18.860 100 63 126 0 1932295712 10630992 17473872
17:28:47 36440 8192000000 10849485968 11266449408 1913625808 18.936 100 62 124 0 1942190752 11411120 17153824
17:29:40 36699 8192000000 10855600416 11279568896 1918800736 18.977 100 37 74 0 1938678560 9141808 10736016
17:30:23 32194 8192000000 10861529936 11296231424 1932317392 19.085 100 52 104 1 1962348112 14529200 15501520
17:31:05 10219 8192000000 10870933600 11302637568 1939598016 19.144 100 42 82 2 1965218944 13766672 11854256
17:31:24 17352 8192000000 10888410448 11312689152 1948163536 19.212 100 48 95 1 1975418912 13024864 14230512
17:31:54 14488 8192000000 10896127696 11321155584 1952890272 19.249 100 58 116 1 1984432416 14594640 16947504
17:32:17 5316 8192000000 10903683264 11323392000 1957100864 19.283 100 58 116 1 1988786976 15170592 16515520
17:32:31 8887 8192000000 10916359136 11338948608 1964795568 19.344 100 62 123 1 2001407408 18288160 18323680
17:32:56 13761 8192000000 10901368800 11335983104 1967059408 19.362 100 48 95 0 1999316016 18807872 13448736
17:33:32 13998 8192000000 10910501264 11341590528 1973188768 19.411 100 48 94 0 2007680096 18970480 15520848
17:34:05 23238 8192000000 10918797600 11350716416 1972354704 19.404 100 39 78 0 2004014672 20364448 11295520
17:34:36 19267 8192000000 10921167136 11357876224 1977191984 19.442 100 41 80 1 2008138432 18961584 11984864
17:35:04 5437 8192000000 10938990016 11365076992 1988981808 19.536 100 59 118 1 2029172288 22768720 17421760
17:35:16 2964 8192000000 10954604752 11373780992 1995759040 19.589 100 84 164 1 2043287440 23318608 24209792
17:35:27 9911 8192000000 10943567856 11374264320 1993279632 19.570 100 59 114 0 2033702752 23901568 16521552
17:35:51 4145 8192000000 10948610944 11381952512 1999192496 19.616 100 62 123 2 2042143616 25028224 17922896
17:36:06 7654 8192000000 10959715824 11387129856 2005162080 19.663 100 69 138 0 2051829872 26486720 20181072
17:36:23 7827 8192000000 10968984080 11399876608 2011054768 19.710 100 62 124 0 2056631280 27404784 18171728
17:36:40 6908 8192000000 10972513680 11402514432 2015771776 19.747 100 62 122 0 2062333920 28106912 18455232
17:37:00 6864 8192000000 10979347792 11411824640 2020431408 19.784 100 60 117 1 2068075440 30283776 17360256
17:37:14 8183 8192000000 11003317232 11426496512 2032767136 19.880 100 65 130 0 2086159456 33731184 19661136
17:37:32 8715 8192000000 10987363216 11422416896 2029417008 19.854 100 59 116 1 2081055392 34047136 17591248
17:37:50 4785 8192000000 10983246768 11415015424 2021347968 19.791 100 53 105 1 2069732832 32427856 15957008
17:38:06 11255 8192000000 10994800448 11427483648 2029094000 19.852 100 61 122 1 2084440784 36507120 18839664
17:38:26 13793 8192000000 10991654448 11426156544 2025268576 19.822 100 59 118 0 2079451984 35642560 18540848
17:38:48 1994 8192000000 10994410272 11421843456 2026821840 19.834 100 75 145 4 2085619056 36600576 22196640
17:38:58 9337 8192000000 10987026080 11419033600 2019688448 19.778 100 62 124 0 2075470048 36642240 19139360
17:39:16 3603 8192000000 10995968160 11418472448 2008380704 19.689 99 73 145 0 2069970992 38978864 22611424
17:39:26 6167 8192000000 10992886000 11415924736 2017121248 19.758 100 74 148 1 2079609552 39927344 22560960
17:39:41 2585 8192000000 10986600960 11402276864 2003515280 19.650 100 81 161 0 2068105888 39961552 24629056
17:39:52 5985 8192000000 10987397056 11404607488 2008208432 19.687 100 74 147 0 2068367120 38008368 22150320
17:40:07 6312 8192000000 10987979360 11402686464 1992220784 19.561 99 78 152 1 2053370304 38367168 22782352
17:40:23 6969 8192000000 10980746816 11410550784 2010704416 19.707 100 63 126 2 2071480384 40700944 20075024
17:40:39 5905 8192000000 10988295872 11413692416 2012651136 19.722 100 60 119 1 2072516384 41157152 18708096
17:40:55 2786 8192000000 10982309440 11410063360 2008126448 19.687 100 64 127 1 2068974144 41504800 19342896
17:41:04 2880 8192000000 10990272224 11415531520 2014514128 19.737 100 82 163 2 2081420864 42168368 24738368
17:41:16 4369 8192000000 10982157616 11403735040 2000473184 19.626 100 82 164 1 2069810656 44507536 24829936
17:41:29 3328 8192000000 10998428576 11415793664 2006466496 19.674 100 77 154 1 2075116608 44814432 23835680
17:41:39 3264 8192000000 10976163952 11394428928 1980482880 19.469 99 89 176 0 2054668496 47389200 26796416
17:41:49 5878 8192000000 10976409328 11395432448 1975308880 19.428 99 79 158 1 2047179168 47737808 24132480
17:42:02 4787 8192000000 10985963968 11407323136 1999721424 19.621 100 84 170 4 2072759008 47743504 25294080
17:42:17 2517 8192000000 10990365344 11405955072 1997728368 19.605 100 84 168 1 2070457568 47243680 25485520
17:42:27 3970 8192000000 10978239408 11391148032 1985445808 19.508 100 84 168 2 2059439504 48077328 25916368
17:42:38 7373 8192000000 10962332976 11379998720 1974092576 19.418 100 79 158 0 2047697808 48986928 24618304
17:42:56 15289 8192000000 10967569936 11391729664 1981251728 19.475 100 68 136 1 2051873808 49420320 21201760
17:43:21 7838 8192000000 10957236448 11389763584 1980547920 19.469 100 56 112 0 2047712912 49053536 18111456
17:43:38 3705 8192000000 10968572000 11393261568 1983278320 19.491 100 55 107 2 2051759824 51289024 17192480
17:43:50 2973 8192000000 10977525584 11396571136 1973476464 19.413 99 74 148 0 2044124592 47771232 22876896
17:44:01 2345 8192000000 10987287056 11399561216 1992146080 19.561 100 84 166 4 2065823760 47791408 25886272
17:44:10 7522 8192000000 10977162032 11398111232 1990475408 19.548 100 72 144 1 2063370656 50054592 22840656
17:44:28 3896 8192000000 10982377968 11404976128 1993014656 19.568 100 70 141 1 2068834576 52666992 23152928
17:44:46 2459 8192000000 10986419376 11402215424 1986208032 19.514 99 86 171 1 2069256848 55348064 27700752
17:45:03 3792 8192000000 10986429344 11403829248 1979141376 19.458 99 77 152 0 2064211024 58893776 26175872
17:45:14 2038 8192000000 11004815296 11418505216 1993991792 19.575 100 87 173 1 2084599696 63059696 27548208
17:45:24 4554 8192000000 11001286224 11412938752 1974998944 19.425 99 80 159 1 2064620384 63473248 26148192
17:45:36 1508 8192000000 11005941104 11420504064 1993454160 19.571 100 87 170 3 2086549584 65743872 27351552
17:45:46 2987 8192000000 11016092544 11430428672 2003036992 19.647 100 91 183 1 2097745776 65437664 29271120
17:45:56 8480 8192000000 11014718832 11432075264 1999038160 19.615 100 87 173 1 2094845376 68141040 27666176
17:46:14 4552 8192000000 11009972992 11422576640 1981707856 19.478 99 86 170 2 2074392528 65478768 27205904
17:46:26 2013 8192000000 11007942160 11425075200 1997040128 19.599 100 88 176 0 2092552880 66609888 28902864
17:46:36 2148 8192000000 10999874336 11416391680 1991666096 19.557 100 87 174 1 2084615232 64913296 28035840
17:46:46 21043 8192000000 10968986992 11422089216 1990454320 19.547 100 51 102 1 2074956640 66744320 17758000
17:47:16 16498 8192000000 10948914464 11403128832 1973425216 19.413 99 32 64 1 2026760448 42477248 10857984
17:47:56 16832 8192000000 10957293264 11402579968 1990392928 19.547 100 40 80 1 2048156592 44666736 13096928
17:48:19 8729 8192000000 10954987632 11402436608 1975408784 19.428 99 36 72 0 2028671440 41811840 11450816
17:48:37 13592 8192000000 10944778592 11397525504 1968123792 19.371 99 25 50 1 2020672800 43887808 8661200
17:49:14 21510 8192000000 10924442272 11384700928 1966027616 19.354 100 23 46 0 2020682256 46810016 7844624
17:49:52 18138 8192000000 10932788176 11373645824 1949732544 19.224 99 22 44 2 1999997296 42153040 8111712
17:50:19 20694 8192000000 10908318848 11362635776 1905317664 18.869 97 31 60 1 1968099648 52622464 10159520
17:50:50 15405 8192000000 10920352256 11365548032 1945011952 19.187 100 30 59 2 1996457360 42268864 9176544
17:51:15 24812 8192000000 10901429872 11359932416 1901542672 18.839 98 24 48 1 1959942608 49853296 8546640
17:52:01 16410 8192000000 10904200576 11359535104 1939846768 19.146 100 28 56 3 1988293680 39840160 8606752
17:53:15 36844 8192000000 10867891248 11321159680 1855571536 18.467 96 18 36 0 1896380656 34459520 6349600
17:53:58 39777 8192000000 10853872912 11321380864 1880635456 18.670 98 12 24 1 1918379344 32918848 4825040
17:54:46 45658 8192000000 10813307984 11273043968 1780302112 17.852 93 9 18 1 1792450496 9222272 2926112
17:55:38 25303 8192000000 10841816848 11281932288 1890945152 18.753 99 44 86 2 1912314176 8915072 12453952
17:56:10 105351 8192000000 10861018368 11307696128 1913105232 18.932 100 25 50 1 1934172096 14007552 7059312
17:58:08 45819 8192000000 10848914640 11270033408 1810185920 18.097 94 36 72 0 1830242304 9516992 10539392
17:59:05 81045 8192000000 10857578976 11312517120 1877083472 18.642 97 27 52 2 1892520128 7864624 7572032
18:00:34 65825 8192000000 10870183072 11338420224 1904962560 18.866 98 20 41 2 1917412864 7600000 4850304
18:01:54 32671 8192000000 10887040608 11344723968 1958479792 19.294 100 22 41 2 1974599840 10330064 5789984
18:03:29 18803 8192000000 10853878016 11316633600 1929275552 19.061 100 15 31 0 1948481792 14578976 4627264
18:03:54 51933 8192000000 10884192752 11322109952 1890950256 18.753 97 35 70 0 1917932736 16487456 10495024
18:04:52 32640 8192000000 10900818112 11337863168 1941766768 19.161 100 50 98 2 1974568448 18756608 14045072
18:05:32 66319 8192000000 10871501760 11346116608 1922323632 19.005 99 25 51 1 1960395168 30146528 7925008
18:06:45 32264 8192000000 10872052320 11362627584 1940550000 19.151 100 5 10 1 1963672880 21870320 1252560
18:07:51 16431 8192000000 10876475488 11360186368 1946686416 19.200 100 6 12 1 1966302592 17858976 1757200
18:08:19 28342 8192000000 10884787744 11342835712 1937657952 19.128 99 28 55 1 1961144208 15465712 8020544
18:08:55 47284 8192000000 10875525808 11346878464 1957955248 19.290 100 15 30 0 1972389664 10009216 4425200
18:09:49 67215 8192000000 10893372464 11362848768 1965544736 19.350 100 23 46 0 1981532560 9142736 6845088
18:11:45 49098 8192000000 10887748000 11357335552 1962851568 19.329 100 18 36 1 1974637696 6514624 5271504
18:12:44 33587 8192000000 10885493312 11359059968 1954466864 19.262 99 21 42 0 1972287056 12207008 5613184
18:13:25 42841 8192000000 10874322384 11357118464 1949142112 19.220 99 13 26 0 1961788176 7660528 4985536
18:14:15 48330 8192000000 10868304208 11341697024 1924935856 19.026 98 6 12 1 1933425920 6886512 1603552
18:15:10 32997 8192000000 10903886832 11373719552 1973488672 19.413 100 34 68 1 1990924176 8185408 9250096
18:15:55 60824 8192000000 10892601456 11369361408 1931904240 19.082 98 14 28 0 1948599696 12585200 4110256
18:17:03 83169 8192000000 10902566896 11374608384 1968351824 19.372 100 11 22 2 1986124832 14728160 3044848
18:18:32 35714 8192000000 10901811600 11367219200 1958943152 19.298 99 14 28 1 1970894848 8547376 3404320
18:19:22 62072 8192000000 10908707904 11391193088 1977288176 19.443 100 13 26 0 1999042128 17870640 3883312
18:20:47 97144 8192000000 10906932064 11360489472 1897856512 18.809 96 13 26 0 1910486448 8602480 4027456
18:22:30 44024 8192000000 10898640384 11364786176 1951570912 19.239 99 24 48 1 1967189664 8997088 6621664
18:23:20 56003 8192000000 10904637616 11369259008 1950511824 19.231 99 19 38 1 1967806512 12013712 5280976
18:24:28 105930 8192000000 10871237616 11350597632 1828486784 18.247 93 11 23 0 1846686384 15196784 3002816
18:26:20 108524 8192000000 10868517280 11324723200 1792871632 17.955 92 7 14 1 1805244768 10646912 1726224
18:28:23 75616 8192000000 10888491376 11342295040 1928010112 19.051 99 33 66 0 1951640960 14827648 8803200
18:29:45 44343 8192000000 10879100112 11332644864 1926369168 19.038 99 32 64 1 1949248704 13831792 9047744
18:30:36 57593 8192000000 10837081744 11304415232 1902561152 18.847 98 21 42 0 1921511664 13239184 5711328
18:32:47 56437 8192000000 10873839344 11360706560 1938749376 19.137 99 10 20 0 1955325776 14504640 2071760
18:33:51 26359 8192000000 10882744768 11353231360 1956609072 19.279 100 21 44 4 1969346336 7313296 5423968
18:34:24 23874 8192000000 10876878400 11336482816 1901687584 18.840 97 20 38 1 1914944400 8361664 4895152
18:34:54 50192 8192000000 10871410272 11339296768 1901553152 18.839 97 14 28 1 1912185904 7082176 3550576
18:35:51 53686 8192000000 10902606160 11371364352 1958944560 19.298 100 15 30 0 1970163056 6931184 4287312
18:36:55 39496 8192000000 10897690640 11373232128 1954112592 19.259 99 34 68 2 1976565072 12187760 10264720
18:37:40 69871 8192000000 10877758224 11342811136 1887781104 18.728 96 16 30 1 1902463664 10060800 4621760
18:39:00 35397 8192000000 10901163712 11356196864 1957286592 19.284 100 29 58 1 1973108656 7994320 7827744
18:39:43 10870 8192000000 10885500896 11323359232 1907421616 18.886 97 51 102 1 1936270400 14278912 14569872
18:40:00 80186 8192000000 10871646880 11313037312 1831989280 18.276 94 12 24 0 1845677648 10074880 3613488
18:41:26 26850 8192000000 10880833424 11320582144 1900876928 18.833 98 34 66 1 1920267088 9623648 9766512
18:42:00 36352 8192000000 10876294528 11344035840 1922993408 19.011 99 23 46 0 1938861232 10187808 5680016
18:42:42 47763 8192000000 10859022544 11319918592 1867154240 18.561 96 21 41 2 1883334400 10153120 6027040
18:43:44 42392 8192000000 10888188688 11342876672 1930305616 19.069 99 26 52 1 1948864592 11167024 7391952
18:44:42 93500 8192000000 10870687712 11341529088 1850520080 18.426 95 14 28 1 1866048000 12112704 3415216
18:46:26 72473 8192000000 10900785408 11351207936 1921082352 18.996 98 27 54 1 1940966976 12659936 7224688
18:47:45 85334 8192000000 10836321008 11308691456 1860984432 18.511 96 16 32 0 1880164480 14597984 4582064
18:49:41 97757 8192000000 10877635136 11333042176 1887744496 18.728 97 26 50 1 1903836368 9123344 6968528
18:51:26 35275 8192000000 10870928048 11329462272 1919978224 18.987 99 28 56 1 1944285792 15953904 8353664
18:52:11 29367 8192000000 10858318464 11320168448 1915831632 18.953 99 30 60 0 1936791152 12591664 8367856
18:53:00 50667 8192000000 10859086624 11328835584 1930404512 19.070 100 13 26 1 1947004432 13039360 3560560
18:53:58 43694 8192000000 10871718416 11340824576 1940885536 19.154 100 9 18 0 1957423072 14095520 2442016
18:54:55 64310 8192000000 10877843056 11347329024 1938374832 19.134 99 15 30 1 1952840240 9805760 4659648
18:56:05 51271 8192000000 10885050032 11355045888 1960153728 19.307 100 16 32 0 1977152832 12383872 4615232
18:57:06 49971 8192000000 10879381072 11354447872 1959815152 19.305 100 11 22 1 1973827360 10848608 3163600
18:58:16 39861 8192000000 10904367008 11369668608 1967924832 19.369 100 13 26 0 1988220576 16259552 4036192
18:59:46 49955 8192000000 10907344160 11378061312 1970313824 19.388 99 19 38 0 1986985664 11237376 5434464
19:00:42 92053 8192000000 10906852528 11371225088 1935511840 19.111 97 16 32 1 1957905952 17701216 4692896
19:02:20 57743 8192000000 10927731904 11399524352 1987803344 19.526 100 15 30 0 2006850480 14613568 4433568
19:03:27 34766 8192000000 10931913776 11385868288 1981687472 19.478 99 29 58 1 1998732480 8239264 8805744
19:04:14 52987 8192000000 10906832128 11378921472 1951288384 19.237 98 23 46 1 1973397328 15372784 6736160
19:05:25 32267 8192000000 10938404032 11382599680 1957962560 19.290 98 39 78 2 1977536720 7826000 11748160
19:06:04 27175 8192000000 10933486672 11388055552 1971972272 19.401 99 54 106 2 1999028800 11528640 15527888
19:06:45 59425 8192000000 10908823904 11382976512 1961113824 19.315 99 16 32 1 1985415808 20342320 3959664
19:07:55 49913 8192000000 10919864096 11396280320 1938880880 19.138 98 14 28 0 1962188512 19340624 3967008
19:08:57 37611 8192000000 10926521600 11403538432 1990533152 19.548 100 17 33 3 2014882176 19171312 5177712
19:09:49 79863 8192000000 10913257856 11392671744 1934304000 19.101 97 21 42 1 1953483552 13389696 5789856
19:11:15 91575 8192000000 10920581856 11355406336 1878311856 18.651 95 24 48 1 1896130144 10986944 6831344
19:12:54 45279 8192000000 10891745776 11351732224 1945711888 19.192 99 49 98 1 1970710896 10865424 14133584
19:14:25 97347 8192000000 10891015360 11345006592 1897131376 18.803 96 31 61 1 1915401152 9811152 8458624
19:16:15 57232 8192000000 10875842256 11348340736 1925671328 19.032 99 10 20 0 1939395888 9438336 4286224
19:17:25 30699 8192000000 10876346016 11359940608 1949925152 19.226 100 11 22 1 1970523360 17356752 3241456
19:18:09 34816 8192000000 10873662368 11358052352 1937502704 19.127 99 8 16 0 1954082416 14403664 2176048
19:18:50 31600 8192000000 10890863344 11350315008 1940329120 19.149 99 15 29 0 1958704080 14360992 4013968
19:20:34 66896 8192000000 10902843632 11380383744 1960627024 19.311 99 20 40 0 1983454672 16622976 6204672
19:21:52 69930 8192000000 10901246720 11380940800 1978393264 19.452 100 11 22 0 1994813232 12902336 3517632
19:23:12 63004 8192000000 10919810048 11411959808 1980733200 19.471 100 11 22 0 2001756144 17905344 3117600
19:24:21 60351 8192000000 10910221168 11392446464 1955494496 19.270 98 18 36 0 1971943792 11146512 5302784
19:26:12 36291 8192000000 10883027984 11350822912 1936284816 19.117 98 26 52 1 1954734864 11336448 7113600
19:27:00 15124 8192000000 9067927792 9289494528 216283344 2.572 12 2 4 0 217548816 911696 353776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 18-01-2021 19:28:27 to 18-01-2021 19:28:58.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 125 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 18-01-2021 19:28:59 to 18-01-2021 19:29:01.

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          241060
MON$OLDEST_ACTIVE               241061
MON$OLDEST_SNAPSHOT             241061
MON$NEXT_TRANSACTION            241061
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                       2022016
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:11: 
:12: mscs-test-161.budzdorov.ru    Mon Jan 18 19:27:19 2021
:13:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:14: 
--- end of diff output ---

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

18.01.21 19:29:02. 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-18 19:29:04 No severe PSQL-related problems occured
18.01.21 19:29:06. End of report.