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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17165480 kB
MemAvailable 31590100 kB
Buffers 0 kB
Cached 14480440 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-07 01:27:19
DTS_END                         2021-03-07 01:27:19.3200
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/39772
TRN_ID                          245845
ATT_ID                          668
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: 9395.13 18687 1127416
customer order: creation 181.53 329 21783
customer order: refuse 14.96 346 1795
order to supplier: creation 47.85 1284 5742
order to supplier: removal 3.62 99753 434
invoice (draft): creation 48.39 3257 5807
invoice (draft): removal 52.06 798 6247
invoice accept: apply 44.11 18017 5293
invoice accept: cancel 46.86 851 5623
customer reserve: creation 4036.17 180 484340
customer reserve: removal 4611.68 61 553402
realization accept: apply 88.83 180 10659
realization accept: cancel 83.63 106 10035
payment from customer: creation 61.89 106 7427
payment from customer: removal 5.87 83 704
payment to supplier: creation 51.36 112 6163
payment to supplier: removal 3.59 73 431
service: total inventory turnovers 4.82 1216 578
service: total monetary turnovers 7.15 33 858
service: aggregate perf. data 0.76 22130 91
service: refresh index statistics 0.03 224829 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4712
TEST_TIME 2 4571
TEST_TIME 3 4307
TEST_TIME 4 4829
TEST_TIME 5 4686
TEST_TIME 6 5200
TEST_TIME 7 5530
TEST_TIME 8 5881
TEST_TIME 9 6273
TEST_TIME 10 6435
TEST_TIME 11 6761
TEST_TIME 12 6751
TEST_TIME 13 7197
TEST_TIME 14 7201
TEST_TIME 15 7302
TEST_TIME 16 7417
TEST_TIME 17 7803
TEST_TIME 18 8024
TEST_TIME 19 8338
TEST_TIME 20 8570
TEST_TIME 21 8959
TEST_TIME 22 8850
TEST_TIME 23 8958
TEST_TIME 24 9279
TEST_TIME 25 9536
TEST_TIME 26 10000
TEST_TIME 27 10296
TEST_TIME 28 10400
TEST_TIME 29 11316
TEST_TIME 30 11093
TEST_TIME 31 11099
TEST_TIME 32 10903
TEST_TIME 33 10827
TEST_TIME 34 10782
TEST_TIME 35 10783
TEST_TIME 36 10679
TEST_TIME 37 10699
TEST_TIME 38 10700
TEST_TIME 39 10675
TEST_TIME 40 10602
TEST_TIME 41 10679
TEST_TIME 42 10518
TEST_TIME 43 10298
TEST_TIME 44 10377
TEST_TIME 45 10409
TEST_TIME 46 10312
TEST_TIME 47 10174
TEST_TIME 48 10224
TEST_TIME 49 10111
TEST_TIME 50 10140
TEST_TIME 51 10146
TEST_TIME 52 10242
TEST_TIME 53 10209
TEST_TIME 54 10136
TEST_TIME 55 10043
TEST_TIME 56 9939
TEST_TIME 57 9974
TEST_TIME 58 9890
TEST_TIME 59 9926
TEST_TIME 60 9819
TEST_TIME 61 9860
TEST_TIME 62 9758
TEST_TIME 63 9785
TEST_TIME 64 9810
TEST_TIME 65 9817
TEST_TIME 66 9855
TEST_TIME 67 9828
TEST_TIME 68 9808
TEST_TIME 69 9872
TEST_TIME 70 9912
TEST_TIME 71 9970
TEST_TIME 72 9925
TEST_TIME 73 9978
TEST_TIME 74 10052
TEST_TIME 75 9997
TEST_TIME 76 10046
TEST_TIME 77 10059
TEST_TIME 78 9961
TEST_TIME 79 9899
TEST_TIME 80 9942
TEST_TIME 81 9857
TEST_TIME 82 9851
TEST_TIME 83 9790
TEST_TIME 84 9756
TEST_TIME 85 9708
TEST_TIME 86 9667
TEST_TIME 87 9592
TEST_TIME 88 9570
TEST_TIME 89 9574
TEST_TIME 90 9513
TEST_TIME 91 9519
TEST_TIME 92 9495
TEST_TIME 93 9548
TEST_TIME 94 9575
TEST_TIME 95 9555
TEST_TIME 96 9614
TEST_TIME 97 9621
TEST_TIME 98 9655
TEST_TIME 99 9644
TEST_TIME 100 9648
TEST_TIME 101 9658
TEST_TIME 102 9642
TEST_TIME 103 9665
TEST_TIME 104 9708
TEST_TIME 105 9742
TEST_TIME 106 9768
TEST_TIME 107 9682
TEST_TIME 108 9614
TEST_TIME 109 9596
TEST_TIME 110 9588
TEST_TIME 111 9569
TEST_TIME 112 9562
TEST_TIME 113 9526
TEST_TIME 114 9499
TEST_TIME 115 9479
TEST_TIME 116 9487
TEST_TIME 117 9478
TEST_TIME 118 9480
TEST_TIME 119 9459
TEST_TIME 120 9400

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 07-03-2021 01:28:29 to 07-03-2021 01:28:33.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1576218 1576218 0 0.00 0 24686 6 0 0
doc_list_biud 1576214 1576214 0 0.00 0 23581 28 0 0
sp_add_invoice_to_stock 5375 5293 82 1.52 44 187022 18018 0 82
sp_cancel_adding_invoice 5623 5623 0 0.00 5 87223 852 0 0
sp_cancel_client_order 1795 1795 0 0.00 4 12086 347 0 0
sp_cancel_customer_reserve 553402 553402 0 0.00 1 18723 62 0 0
sp_cancel_pay_from_customer 704 704 0 0.00 2 6050 83 0 0
sp_cancel_pay_to_supplier 431 431 0 0.00 3 2955 74 0 0
sp_cancel_supplier_invoice 6253 6247 6 0.09 2 17222 799 0 6
sp_cancel_supplier_order 434 434 0 0.00 8 1173454 99753 0 0
sp_cancel_write_off 10035 10035 0 0.00 1 23639 106 0 0
sp_client_order 21783 21783 0 0.00 4 21938 330 0 0
sp_customer_reserve 484340 484340 0 0.00 0 101254 180 0 0
sp_fill_shopping_cart 33324 33324 0 0.00 1 12756 37 0 0
sp_fill_shopping_cart_clo_res 484322 484322 0 0.00 0 11800 12 0 0
sp_get_clo_for_invoice 5275 5275 0 0.00 0 30038 292 0 0
sp_kill_cost_storno 16793 16793 0 0.00 0 7094 56 0 0
sp_kill_qstorno_ret_qs2qd 1123520 1123520 0 0.00 0 23579 33 0 0
sp_kill_qty_storno 593470 593470 0 0.00 0 23581 72 0 0
sp_lock_selected_doc 21917 21917 0 0.00 0 8815 4 0 0
sp_make_cost_storno 29524 29524 0 0.00 0 17788 52 0 0
sp_multiply_rows_for_pdistr 29524 29524 0 0.00 0 7830 29 0 0
sp_multiply_rows_for_qdistr 21783 21783 0 0.00 0 17541 142 0 0
sp_pay_from_customer 7427 7427 0 0.00 4 10269 107 0 0
sp_pay_to_supplier 6163 6163 0 0.00 5 10801 113 0 0
sp_payment_common 13590 13590 0 0.00 1 9041 23 0 0
sp_qd_handle_on_cancel_clo 1795 1795 0 0.00 0 12074 322 0 0
sp_qd_handle_on_invoice_upd_sts 10898 10898 0 0.00 0 19367 363 0 0
sp_qd_handle_on_reserve_upd_sts 10659 10659 0 0.00 0 17966 67 0 0
sp_reserve_write_off 10659 10659 0 0.00 6 17984 180 0 0
sp_supplier_invoice 5807 5807 0 0.00 6 84178 3258 0 0
sp_supplier_order 5742 5742 0 0.00 5 52355 1285 0 0
srv_aggregate_perf_data 91 91 0 0.00 3053 274237 22130 0 0
srv_fill_mon_cache_memory 174 174 0 0.00 899 146466 29777 0 0
srv_find_qd_qs_mism 1077489 1077489 0 0.00 0 24685 5 0 0
srv_make_invnt_saldo 578 578 0 0.00 37 72867 1216 0 0
srv_make_money_saldo 858 858 0 0.00 0 3197 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 100010 299645 224829 0 0
t$perf-abend:sp_add_invoice_to_stock 82 82 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5293 5293 0 0.00 0 10443 165 0 0
t$perf-norm:sp_cancel_adding_invoice 442 442 0 0.00 0 5636 123 0 0
t$perf-norm:sp_cancel_client_order 1795 1795 0 0.00 0 1617 11 0 0
t$perf-norm:sp_cancel_customer_reserve 714 714 0 0.00 0 916 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 704 704 0 0.00 0 13109 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 431 431 0 0.00 0 578 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 391 391 0 0.00 0 978 17 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 23536 1538 0 0
t$perf-norm:sp_cancel_write_off 1074 1074 0 0.00 0 2543 10 0 0
t$perf-norm:sp_client_order 21783 21783 0 0.00 0 18084 18 0 0
t$perf-norm:sp_customer_reserve 1019 1019 0 0.00 0 14391 19 0 0
t$perf-norm:sp_pay_from_customer 7427 7427 0 0.00 0 15578 15 0 0
t$perf-norm:sp_pay_to_supplier 6163 6163 0 0.00 0 18085 10 0 0
t$perf-norm:sp_reserve_write_off 10659 10659 0 0.00 0 15573 18 0 0
t$perf-norm:sp_supplier_invoice 5807 5807 0 0.00 0 7807 20 0 0
t$perf-norm:sp_supplier_order 5742 5742 0 0.00 0 9565 23 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 193 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 174 174 0 0.00 0 1355 12 0 0
t$perf-norm:srv_make_invnt_saldo 578 578 0 0.00 0 908 21 0 0
t$perf-norm:srv_make_money_saldo 858 858 0 0.00 0 1001 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 11 5 0 0
v_add_invoice_to_stock 10710 10546 164 1.53 0 10599 20 0 164
v_all_customers 39286 39286 0 0.00 0 16 1 0 0
v_all_suppliers 32016 32016 0 0.00 0 16 1 0 0
v_all_wares 43566 43566 0 0.00 0 121 1 0 0
v_cancel_adding_invoice 884 884 0 0.00 0 3080 13 0 0
v_cancel_client_order 3590 3590 0 0.00 0 3497 3 0 0
v_cancel_customer_prepayment 1408 1408 0 0.00 0 4010 7 0 0
v_cancel_customer_reserve 1428 1428 0 0.00 0 4587 8 0 0
v_cancel_payment_to_supplier 862 862 0 0.00 0 2934 11 0 0
v_cancel_supplier_invoice 794 782 12 1.51 0 3029 18 0 12
v_cancel_supplier_order 868 868 0 0.00 0 663 5 0 0
v_cancel_write_off 2148 2148 0 0.00 0 4607 15 0 0
v_max_id_clo_ord 5741 5741 0 0.00 0 5489 2 0 0
v_max_id_clo_res 1019 1019 0 0.00 0 1968 10 0 0
v_max_id_ord_sup 5800 5800 0 0.00 0 4498 3 0 0
v_max_non_paid_invoice 1696 1696 0 0.00 0 3827 10 0 0
v_max_non_paid_realizn 4049 4049 0 0.00 0 4992 5 0 0
v_min_id_clo_ord 5741 5741 0 0.00 0 3425 6 0 0
v_min_id_clo_res 1019 1019 0 0.00 0 4898 9 0 0
v_min_id_ord_sup 5800 5800 0 0.00 0 5571 7 0 0
v_min_non_paid_invoice 6163 6163 0 0.00 0 5024 10 0 0
v_min_non_paid_realizn 7427 7427 0 0.00 0 5764 13 0 0
v_our_firm 11036 11036 0 0.00 0 13 1 0 0
v_reserve_write_off 21318 21318 0 0.00 0 4229 6 0 0
x_lock_depdocs_on_canc_invoice 11479 11479 0 0.00 0 22948 117 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 24132 392 0 0
x_make_qstorno_1000_1200 5742 5742 0 0.00 2 51795 1201 0 0
x_make_qstorno_1200_2000 5807 5807 0 0.00 3 84151 3134 0 0
x_make_qstorno_2100_3300 484340 484340 0 0.00 0 101253 165 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:23 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:29 7424 8192000000 10118519392 10404032512 830763248 9.207 66 57 114 0 852776464 2362672 19650544
22:57:44 25718 8192000000 10299947040 10611425280 1342517728 14.080 100 86 171 1 1375082704 4423200 28141776
22:58:20 35941 8192000000 10349102352 10671923200 1396834096 14.567 100 86 172 0 1431444816 6036544 28574176
22:59:04 22118 8192000000 10395487840 10715979776 1437947120 14.932 100 91 182 0 1474822976 7029392 29846464
22:59:37 13030 8192000000 10400049024 10724970496 1462109824 15.144 100 86 172 1 1498103584 8080272 27913488
23:00:08 29667 8192000000 10432162368 10760998912 1484512992 15.341 100 87 174 0 1521771440 9435312 27823136
23:00:45 7744 8192000000 10438663264 10769768448 1492847120 15.414 100 90 180 0 1531263200 9664848 28751232
23:01:01 18639 8192000000 10455269552 10792636416 1508674768 15.552 100 88 176 0 1546139200 9879808 27584624
23:01:30 14443 8192000000 10483461728 10828754944 1537499440 15.802 100 82 164 0 1572718752 9993280 25226032
23:01:56 13593 8192000000 10519281600 10868903936 1572411904 16.103 100 79 158 0 1607321792 10698592 24211296
23:02:18 11093 8192000000 10544782256 10893127680 1595791376 16.303 100 85 170 0 1633142832 11386224 25965232
23:02:40 13402 8192000000 10559968000 10918481920 1617984464 16.493 100 80 160 1 1654284768 11564240 24736064
23:03:02 14613 8192000000 10594062336 10952462336 1640501600 16.684 100 83 166 1 1677909856 11867376 25540880
23:03:24 11151 8192000000 10601235120 10963841024 1658092096 16.833 100 87 174 2 1696940736 12796064 26052576
23:03:46 10923 8192000000 10624286480 10988515328 1681257312 17.028 100 85 170 0 1718866944 13008288 24601344
23:04:04 8913 8192000000 10639851968 11008675840 1694871216 17.142 100 78 157 1 1730096272 12633888 22591168
23:04:21 7571 8192000000 10653335328 11021758464 1708002128 17.252 100 80 159 1 1744271808 13266720 23002960
23:04:37 4813 8192000000 10666531024 11035095040 1723918192 17.385 100 80 160 0 1759818048 12894704 23005152
23:04:49 10180 8192000000 10677454656 11052675072 1736152384 17.487 100 73 146 0 1769438256 12322432 20963440
23:05:06 6205 8192000000 10690691440 11071520768 1750169776 17.603 100 69 138 0 1785575120 16156064 19249280
23:05:20 5074 8192000000 10704918592 11086401536 1769672768 17.764 100 73 145 0 1801621552 12079536 19869248
23:05:31 3750 8192000000 10729230784 11107704832 1784487216 17.886 100 83 166 0 1820144880 12378400 23279264
23:05:42 3847 8192000000 10731339712 11111923712 1790103840 17.933 100 85 171 1 1826800304 13153552 23542912
23:05:52 3095 8192000000 10735461312 11118833664 1795693808 17.979 100 85 169 2 1833884512 13463760 24726944
23:06:02 3484 8192000000 10749285936 11127713792 1799656336 18.011 100 84 166 2 1837292768 14030624 23605808
23:06:12 3621 8192000000 10749616304 11131584512 1805559168 18.059 100 83 165 0 1842931248 14274048 23098032
23:06:22 3928 8192000000 10744235776 11133534208 1811342448 18.107 100 82 164 1 1848683264 14925632 22415184
23:06:33 3833 8192000000 10752827472 11144982528 1811635184 18.109 100 75 148 2 1845789760 13603968 20550608
23:06:44 2057 8192000000 10777251552 11162591232 1836186192 18.310 100 84 163 1 1871785120 11711648 23887280
23:06:53 1559 8192000000 10777842464 11168780288 1843640736 18.370 100 91 183 2 1881272656 12130528 25501392
23:07:00 2070 8192000000 10796837168 11184435200 1850261440 18.424 100 81 161 1 1884937776 11504816 23171520
23:07:09 2387 8192000000 10798566640 11183345664 1852980336 18.446 100 88 176 1 1890279616 12090528 25208752
23:07:17 2241 8192000000 10799633616 11187363840 1855057424 18.463 100 94 189 2 1894989248 13696672 26235152
23:07:26 1644 8192000000 10806986912 11192287232 1860357024 18.506 100 94 189 3 1899868560 13163456 26348080
23:07:34 1505 8192000000 10807304816 11195953152 1860613984 18.508 100 92 185 3 1899114336 13725616 24774736
23:07:41 2975 8192000000 10812065632 11201499136 1860245312 18.505 100 91 179 2 1900135424 13609680 26280432
23:07:51 27893 8192000000 10797587360 11197489152 1867251440 18.562 100 74 146 1 1897297104 9964480 20081184
23:08:26 4257 8192000000 10792363632 11202985984 1870412112 18.588 100 53 106 1 1895702064 10557008 14732944
23:08:39 5195 8192000000 10792059920 11209887744 1872989952 18.608 100 43 86 0 1894876064 10289024 11597088
23:08:51 5020 8192000000 10785396272 11207933952 1875180144 18.626 100 39 77 2 1895016768 9211104 10625520
23:09:02 3659 8192000000 10790947424 11209760768 1876946528 18.640 100 40 81 1 1895637520 7797408 10893584
23:09:12 7483 8192000000 10803097776 11211051008 1882027520 18.681 100 36 72 2 1898857776 6557472 10272784
23:09:26 8922 8192000000 10794437424 11216564224 1884097024 18.698 100 29 59 1 1899506400 7286912 8122464
23:09:45 5818 8192000000 10790297152 11219542016 1884890736 18.705 100 29 58 0 1899840496 6645584 8304176
23:09:57 10625 8192000000 10790698144 11224432640 1887322064 18.724 100 24 48 1 1900130160 6669760 6138336
23:10:14 3862 8192000000 10803512048 11225640960 1891770160 18.760 100 36 70 0 1908136992 6929680 9437152
23:10:24 5200 8192000000 10815295248 11231653888 1893500736 18.774 100 30 61 2 1908916752 5951296 9464720
23:10:37 11270 8192000000 10801787360 11231244288 1894743136 18.784 100 16 32 2 1905189872 5566224 4880512
23:10:57 25310 8192000000 10799661792 11244904448 1901331472 18.837 100 28 56 1 1914861968 5866768 7663728
23:11:53 27714 8192000000 10800716320 11246002176 1903841472 18.857 100 22 43 1 1919919536 9826256 6251808
23:12:29 11430 8192000000 10825778016 11251748864 1901668560 18.840 100 20 40 1 1912263424 5049376 5545488
23:12:49 3528 8192000000 10831314976 11258470400 1906470352 18.878 100 43 85 1 1927522304 8382480 12669472
23:12:59 4191 8192000000 10821845888 11251363840 1904988592 18.866 100 30 60 0 1920686848 6541584 9156672
23:13:10 4231 8192000000 10843281888 11266072576 1910392496 18.910 100 43 86 2 1930687280 8665888 11628896
23:13:22 3353 8192000000 10840212352 11265093632 1911996080 18.923 100 43 86 2 1933557232 9060592 12500560
23:13:33 6072 8192000000 10830124512 11259699200 1912142496 18.924 100 31 63 1 1927698384 6320512 9235376
23:13:47 6103 8192000000 10835034784 11263807488 1912116176 18.924 100 30 60 2 1927196800 6442400 8638224
23:14:00 4288 8192000000 10838044672 11265052672 1916146384 18.956 100 40 78 1 1934707472 6821920 11739168
23:14:13 9295 8192000000 10826549648 11261956096 1915267360 18.949 100 24 48 1 1927809856 5987888 6554608
23:14:29 7419 8192000000 10833673232 11266043904 1915044352 18.947 100 22 42 2 1927215552 5859344 6311856
23:14:46 7064 8192000000 10827823088 11265720320 1916291888 18.957 100 14 28 2 1926018896 5521600 4205408
23:15:00 11007 8192000000 10825761056 11267055616 1920049216 18.987 100 17 33 2 1930713536 6020224 4644096
23:15:18 5120 8192000000 10831043088 11270782976 1919418928 18.982 100 24 48 1 1932375648 6483280 6473440
23:15:29 13029 8192000000 10828902096 11267289088 1899301552 18.821 99 15 30 0 1909018080 5833952 3882576
23:15:54 61399 8192000000 10814986608 11255713792 1881122080 18.674 98 25 50 1 1893494880 4949392 7423408
23:17:03 9407 8192000000 10810451904 11236593664 1833794288 18.290 96 31 61 1 1848435440 6331696 8309456
23:17:21 5602 8192000000 10763988176 11182759936 1844015424 18.373 98 21 41 0 1854656304 5379952 5260928
23:17:33 2350 8192000000 10826845632 11243360256 1890501088 18.750 100 61 123 0 1920986176 13775312 16709776
23:17:44 4417 8192000000 10790782000 11208302592 1830471808 18.263 97 36 73 1 1847677296 6612176 10593312
23:17:56 4730 8192000000 10767266368 11186360320 1793217040 17.958 96 34 68 2 1810228336 7238768 9772528
23:18:08 6915 8192000000 10765335136 11187134464 1818262064 18.163 98 23 46 1 1829915024 4911424 6741536
23:18:24 8768 8192000000 10735802864 11155443712 1783749632 17.880 97 32 64 0 1799231584 6464128 9017824
23:18:42 7352 8192000000 10725867600 11140427776 1762165088 17.702 96 28 55 3 1775650576 5753264 7732224
23:18:58 7825 8192000000 10750616320 11170594816 1813050400 18.121 99 19 38 1 1824854784 6212944 5591440
23:19:15 6826 8192000000 10717078864 11135070208 1788800640 17.922 99 22 43 0 1800745728 5628544 6316544
23:19:29 5711 8192000000 10711501504 11125047296 1788930960 17.923 100 37 75 1 1806377248 6722064 10724224
23:19:44 8615 8192000000 10714244928 11128569856 1767239040 17.744 98 20 39 0 1778442176 4695856 6507280
23:20:03 8902 8192000000 10712680560 11128156160 1780710864 17.855 99 25 50 2 1794469984 6409472 7349648
23:20:20 63888 8192000000 10718876208 11115106304 1693381232 17.130 94 34 68 1 1707741696 4861968 9498496
23:21:32 10368 8192000000 10716155584 11141361664 1791404112 17.943 99 30 60 1 1807618160 7884960 8329088
23:21:53 7708 8192000000 10722053104 11138224128 1793097904 17.957 99 34 68 1 1810944688 7538864 10307920
23:22:12 3189 8192000000 10731791136 11144937472 1809256816 18.090 100 31 62 1 1825210976 6952976 9001184
23:22:23 5093 8192000000 10735426800 11152052224 1801296496 18.025 99 25 50 1 1814107328 5685616 7125216
23:22:34 6461 8192000000 10744656832 11158011904 1825277152 18.221 100 41 82 2 1843923264 7000144 11645968
23:22:50 7897 8192000000 10722068736 11135336448 1781689408 17.863 98 13 26 0 1790859200 5440544 3729248
23:23:06 7832 8192000000 10716479200 11142184960 1795853632 17.980 99 21 42 1 1807637856 5947840 5836384
23:23:22 8057 8192000000 10739144256 11163238400 1829787120 18.258 100 35 70 0 1845949408 6273104 9889184
23:23:39 9309 8192000000 10741434320 11168681984 1832228976 18.278 100 22 43 3 1844616560 5455264 6932320
23:23:57 6886 8192000000 10776017856 11191586816 1839432000 18.336 100 37 72 1 1864277424 14154896 10690528
23:24:11 10926 8192000000 10750700576 11179790336 1839548176 18.337 100 17 33 1 1849675824 5411168 4716480
23:24:28 5254 8192000000 10763525184 11186257920 1845204192 18.383 100 33 66 0 1861079504 5861632 10013680
23:24:41 8054 8192000000 10765730640 11191721984 1848682320 18.411 100 27 53 0 1862164144 5951344 7530480
23:24:56 8397 8192000000 10767797392 11197902848 1851822432 18.437 100 21 41 1 1862974912 5379248 5773232
23:25:14 8692 8192000000 10775179680 11199156224 1860054688 18.504 100 14 27 3 1869133712 4879696 4199328
23:25:32 81099 8192000000 10770194048 11207512064 1865800112 18.550 100 32 67 0 1880387840 4935344 9652384
23:27:00 6904 8192000000 10791288752 11221684224 1875101568 18.626 100 28 55 1 1888781504 6067312 7612624
23:27:13 7535 8192000000 10804024768 11232079872 1888339552 18.732 100 25 50 1 1900073184 5164000 6569632
23:27:28 30821 8192000000 10828243568 11251298304 1901499312 18.838 100 48 93 1 1920956672 5616992 13840368
23:28:07 16630 8192000000 10849986800 11262255104 1912810016 18.929 100 55 110 1 1936031536 7939216 15282304
23:28:31 10287 8192000000 10860594768 11272642560 1918353792 18.974 100 58 115 1 1944290736 9508256 16428688
23:28:49 8742 8192000000 10865760992 11280748544 1920284720 18.989 100 60 119 2 1951762864 14685696 16792448
23:29:08 32670 8192000000 10861138400 11276402688 1923949488 19.018 100 57 114 0 1951520144 11585456 15985200
23:29:51 6871 8192000000 10862089280 11284975616 1926841088 19.042 100 54 106 2 1952327936 10634352 14852496
23:30:15 20801 8192000000 10869904784 11293122560 1934607136 19.104 100 57 114 0 1962402880 11367808 16427936
23:30:52 7002 8192000000 10877263808 11296538624 1937798560 19.129 100 52 104 0 1965236912 12264864 15173488
23:31:10 19082 8192000000 10886217664 11310645248 1946096320 19.195 100 60 119 1 1976162720 12567776 17498624
23:31:47 10630 8192000000 10874434864 11306332160 1946808512 19.201 100 45 89 1 1971827648 11941152 13077984
23:32:11 20580 8192000000 10898085312 11323703296 1955044592 19.267 100 55 107 0 1985243216 14253024 15945600
23:32:39 28329 8192000000 10905681872 11339812864 1960693616 19.312 100 48 96 0 1991261472 16484448 14083408
23:33:15 20643 8192000000 10901927824 11338121216 1963837968 19.337 100 38 76 2 1993258592 17815984 11604640
23:33:47 27484 8192000000 10913081664 11345969152 1971674256 19.399 100 47 94 3 2004418992 18242864 14501872
23:34:27 7114 8192000000 10908737904 11344302080 1969868208 19.384 100 34 66 3 1997284752 16830192 10586352
23:34:42 3489 8192000000 10917490048 11353124864 1976976832 19.441 100 54 107 2 2011570816 17880176 16713808
23:34:53 5299 8192000000 10934997088 11365318656 1987112752 19.521 100 67 131 1 2025899728 19390912 19396064
23:35:05 22080 8192000000 10930942384 11367456768 1968722640 19.375 99 55 109 0 2005264720 20429776 16112304
23:35:39 6781 8192000000 10934484448 11369431040 1988132160 19.529 100 53 105 1 2023267424 19691936 15443328
23:35:55 10435 8192000000 10941849232 11381563392 1994296384 19.578 100 46 89 3 2028134240 20558208 13279648
23:36:16 10503 8192000000 10955075648 11395362816 2008223488 19.688 100 59 118 1 2048000000 21792128 17984384
23:36:34 4621 8192000000 10970739984 11399630848 2013666544 19.730 100 74 148 1 2058477344 22839328 21971472
23:36:48 10580 8192000000 10962681856 11397410816 2009436128 19.697 100 52 104 0 2047451024 22012576 16002320
23:37:07 4951 8192000000 10971021296 11402715136 2016458048 19.752 100 70 140 0 2061536976 23154320 21924608
23:37:20 7284 8192000000 10985998864 11413155840 2020092640 19.781 100 70 139 0 2068434816 25904656 22437520
23:37:34 4392 8192000000 10977008912 11411558400 2021031776 19.788 100 69 138 0 2069720448 28191200 20497472
23:37:46 4366 8192000000 10987337920 11415605248 2026274704 19.829 100 71 140 1 2074394976 26872512 21247760
23:37:58 4832 8192000000 10974864656 11404812288 2011050976 19.710 100 66 129 0 2056571328 26250208 19270144
23:38:16 2997 8192000000 10978072736 11406520320 2014264528 19.735 100 85 170 2 2069151808 29343776 25543504
23:38:26 3632 8192000000 10967653008 11393290240 2002200432 19.640 100 70 139 0 2050775776 27930144 20645200
23:38:37 3962 8192000000 10978651024 11408031744 2014064464 19.733 100 69 137 1 2064148640 29862976 20221200
23:38:58 2597 8192000000 10980538656 11408535552 2018540784 19.769 100 82 162 0 2073299904 30482240 24276880
23:39:07 1801 8192000000 10988579712 11411922944 2016899184 19.756 100 84 163 2 2068997728 28192992 23905552
23:39:17 5347 8192000000 10981846528 11404812288 2012095712 19.718 100 82 163 1 2066987376 30143920 24747744
23:39:28 2307 8192000000 10995323552 11411005440 2017925616 19.764 100 82 161 1 2072869568 30593056 24350896
23:39:38 2719 8192000000 10996405744 11417772032 2022128448 19.797 100 88 175 1 2080720544 31766224 26825872
23:39:53 23448 8192000000 10993432976 11422777344 2019927520 19.780 100 66 132 3 2074650080 33880272 20842288
23:40:30 13423 8192000000 10977737392 11426263040 2020867392 19.787 100 48 96 2 2068313392 32183168 15262832
23:40:54 11950 8192000000 10973774320 11413139456 1998927744 19.614 99 60 120 0 2046781840 29012224 18841872
23:41:15 10434 8192000000 10957669552 11399622656 1957991360 19.290 97 55 108 2 2006583408 31144832 17447216
23:41:35 5795 8192000000 10969755632 11403636736 2002194096 19.640 100 56 112 0 2051568672 31708016 17666560
23:41:47 5316 8192000000 10961310336 11389063168 1980077744 19.465 99 67 133 0 2032869760 32270112 20521904
23:42:00 3345 8192000000 10978380960 11391877120 1996689040 19.597 100 84 164 0 2055957040 33858128 25409872
23:42:13 4884 8192000000 10967616160 11396341760 1993092048 19.568 100 76 152 1 2051202048 34047376 24062624
23:42:27 2878 8192000000 10944822384 11362652160 1965124608 19.347 99 79 157 2 2024453888 34234048 25095232
23:42:42 4222 8192000000 10967739136 11387863040 1984939376 19.504 100 77 153 1 2046421936 37249872 24232688
23:42:53 4062 8192000000 10964420464 11391287296 1989006400 19.536 100 67 133 0 2047735792 37927344 20802048
23:43:07 4407 8192000000 10981579824 11396820992 1994930928 19.583 100 85 166 4 2060759328 39037584 26790816
23:43:21 2963 8192000000 10981470720 11402645504 1979783904 19.463 99 87 174 1 2053460240 46511552 27164784
23:43:31 1955 8192000000 10997273200 11413327872 2000200672 19.624 100 83 165 1 2067569504 42146528 25222304
23:43:41 2101 8192000000 10978268720 11393650688 1989302480 19.538 100 84 168 2 2059457376 43554496 26600400
23:43:50 3257 8192000000 10940466720 11351203840 1927065824 19.043 98 80 159 1 1995512560 43083296 25363440
23:44:01 2090 8192000000 10934121264 11351519232 1945508080 19.191 99 83 165 0 2015282352 43330640 26443632
23:44:12 2046 8192000000 10955407264 11373678592 1965901760 19.353 100 80 159 1 2034121776 43698016 24522000
23:44:23 3468 8192000000 10946115600 11360940032 1956658016 19.279 99 80 159 2 2025120704 44201264 24261424
23:44:33 3781 8192000000 10932155024 11341676544 1934340624 19.102 98 87 174 2 2005348320 44302592 26705104
23:44:44 1688 8192000000 10962266208 11371180032 1964475568 19.342 100 90 177 2 2038170384 46423968 27270848
23:44:52 899 8192000000 10968915072 11380580352 1976005216 19.433 100 89 179 0 2047084208 44249024 26829968
23:44:59 3945 8192000000 10959691936 11375992832 1969741040 19.383 100 76 152 0 2036378848 43246192 23391616
23:45:10 2678 8192000000 10933786384 11356221440 1951842720 19.241 99 72 143 1 2016943344 42914064 22186560
23:45:24 1815 8192000000 10937446016 11352305664 1949412384 19.222 100 90 174 1 2019483328 43024144 27046800
23:45:33 2938 8192000000 10940053152 11360210944 1952440288 19.246 100 71 142 1 2019135536 44139552 22555696
23:45:43 5613 8192000000 10951286304 11371749376 1966951792 19.361 100 79 158 0 2040670528 48144096 25574640
23:45:56 2243 8192000000 10940899072 11354161152 1946916864 19.202 99 79 160 1 2014485824 41681760 25887200
23:46:06 4232 8192000000 10947092592 11366838272 1948887328 19.218 99 80 159 5 2017545120 43774048 24883744
23:46:18 1408 8192000000 10948138896 11359555584 1945347376 19.189 99 86 168 4 2013926032 41651056 26927600
23:46:27 2458 8192000000 10960512384 11368099840 1961049968 19.314 100 90 180 1 2032568128 43607504 27910656
23:46:38 2512 8192000000 10959833616 11368284160 1964307472 19.340 100 89 176 1 2035367680 43794592 27265616
23:46:48 2150 8192000000 10966659904 11380654080 1975751344 19.431 100 84 168 1 2046452096 44610080 26090672
23:47:01 1340 8192000000 10971851744 11387781120 1982344896 19.483 100 84 166 2 2053002128 44850016 25807216
23:47:12 7162 8192000000 10952043664 11370389504 1963690096 19.335 99 68 137 0 2029065632 44440208 20935328
23:47:35 2323 8192000000 10962834432 11382763520 1971288928 19.396 100 78 156 0 2041340144 45454560 24596656
23:47:45 4559 8192000000 10928243536 11362349056 1950817344 19.233 100 56 110 1 2013849056 45536912 17494800
23:48:04 6636 8192000000 10936725024 11375431680 1963447648 19.333 100 49 98 1 2023647280 44062352 16137280
23:48:23 6686 8192000000 10946328320 11384803328 1976447408 19.437 100 53 106 1 2035521632 42167632 16906592
23:48:37 17273 8192000000 10942357584 11395522560 1978240160 19.451 100 42 83 3 2036949712 44724400 13985152
23:49:01 8080 8192000000 10959537312 11393712128 1981542896 19.477 100 47 94 3 2036996576 40231072 15222608
23:49:24 3418 8192000000 10962025584 11373682688 1966005632 19.354 99 79 160 1 2032014576 41038096 24970848
23:49:35 2957 8192000000 10980853392 11396161536 1974178544 19.419 99 93 186 2 2046365264 43845376 28341344
23:49:44 3085 8192000000 10988486960 11398795264 1988713312 19.534 100 88 175 1 2062716528 45963280 28039936
23:49:55 11043 8192000000 10962405552 11397750784 1984098528 19.497 100 60 121 0 2053505840 49842384 19564928
23:50:14 3370 8192000000 10952987424 11385126912 1943242976 19.173 98 69 135 1 2013308992 48720288 21345728
23:50:28 11261 8192000000 10946626032 11385950208 1949760400 19.225 99 49 98 0 2016442288 51056624 15625264
23:51:07 18196 8192000000 10917191424 11360137216 1937453184 19.126 100 31 60 0 1999943600 51876992 10613424
23:51:32 9735 8192000000 10926155968 11369574400 1940919968 19.154 100 34 68 3 2009997904 57118400 11959536
23:52:03 10833 8192000000 10926566208 11363643392 1930314864 19.069 99 38 76 0 1994358528 51119648 12924016
23:52:24 14337 8192000000 10931478624 11371720704 1945044784 19.187 100 31 61 3 2007217424 50514000 11658640
23:52:47 8104 8192000000 10954161904 11384926208 1963386368 19.333 100 67 135 1 2038749872 53755040 21608464
23:53:02 4286 8192000000 10950714976 11390451712 1966867728 19.361 100 55 106 2 2032179136 48126336 17185072
23:53:13 23315 8192000000 10933802768 11383922688 1961642464 19.319 100 36 72 3 2021785376 47646240 12496672
23:53:48 12612 8192000000 10932403392 11391807488 1963272640 19.332 100 28 56 4 2019687088 46919280 9495168
23:54:14 35253 8192000000 10911608320 11368259584 1937739056 19.129 99 22 44 0 1990179872 44229824 8210992
23:54:59 43901 8192000000 10931072112 11384295424 1952997632 19.250 100 23 46 1 2003340368 41512144 8830592
23:55:51 13184 8192000000 10901781872 11366068224 1936714352 19.121 100 24 48 0 1987977136 43223792 8038992
23:56:11 10726 8192000000 10881553440 11350192128 1901416080 18.838 99 12 24 0 1949373456 43723264 4234112
23:56:30 5565 8192000000 10861014640 11356450816 1897208256 18.804 99 7 14 0 1941305632 40666960 3430416
23:56:48 77916 8192000000 10860400144 11298893824 1861416816 18.515 97 22 42 1 1877467168 9627376 6422976
23:58:14 47248 8192000000 10846348608 11307659264 1884980736 18.705 98 15 30 0 1903170368 14189232 4000400
23:59:12 64542 8192000000 10873427136 11316719616 1909788016 18.905 99 16 31 1 1920999824 7605248 3606560
00:00:28 14707 8192000000 10887091008 11334594560 1947229696 19.204 100 15 30 0 1958531664 7400672 3901296
00:00:59 66063 8192000000 10886895840 11341787136 1911837952 18.921 98 11 23 1 1924890288 9683440 3368896
00:02:41 85539 8192000000 10899028416 11353923584 1923080800 19.012 98 18 37 1 1941118112 13731504 4305808
00:04:23 36968 8192000000 10923182672 11371995136 1963136928 19.331 100 23 46 2 1986411568 16840928 6433712
00:05:12 146466 8192000000 10889666368 11359506432 1876688560 18.638 95 15 29 0 1901223600 21064080 3470960
00:07:45 86622 8192000000 10899388976 11357593600 1927678704 19.048 98 18 36 2 1949450336 16928032 4843600
00:09:24 89197 8192000000 10911307888 11358052352 1966498960 19.358 100 33 66 0 1986930816 10078928 10352928
00:11:02 69910 8192000000 10915389408 11379236864 1982362608 19.483 100 21 42 1 2000623616 12621920 5639088
00:12:22 51313 8192000000 10910028912 11363315712 1924860752 19.026 97 27 54 0 1940808432 8096672 7851008
00:13:24 6836 8192000000 10942907824 11379601408 1985336160 19.507 100 63 124 2 2015178016 12194976 17646880
00:13:38 16153 8192000000 10913656800 11362934784 1942938928 19.170 98 69 139 0 1972643056 9905216 19798912
00:14:09 60210 8192000000 10922686848 11371704320 1976883680 19.440 100 43 85 2 2000853264 11019600 12949984
00:15:38 28262 8192000000 10905545856 11376263168 1984160784 19.498 100 19 38 1 1997340112 7258432 5920896
00:16:15 33290 8192000000 10897492064 11358539776 1946753920 19.201 98 14 28 1 1960570672 9461552 4355200
00:17:03 44064 8192000000 10919961968 11387731968 1966349648 19.356 99 27 54 0 1998890720 23944480 8596592
00:17:54 27024 8192000000 10935457408 11389292544 1989149680 19.537 100 34 68 0 2015582528 16075776 10357072
00:18:31 50889 8192000000 10893467856 11383050240 1960607728 19.311 99 44 86 2 1990234048 16661472 12964848
00:19:28 25400 8192000000 10894044096 11388133376 1965309216 19.348 100 10 20 0 1984560128 16415488 2835424
00:21:34 67158 8192000000 10888636784 11369390080 1964578928 19.342 100 16 32 0 1983836176 14562608 4694640
00:22:47 111253 8192000000 10862775664 11350036480 1890846384 18.753 96 13 26 1 1913689648 18542896 4300368
00:24:59 73789 8192000000 10837253008 11306164224 1859951568 18.503 95 23 46 3 1880276272 13748320 6576384
00:26:21 46814 8192000000 10869318432 11349774336 1942501664 19.167 100 16 32 3 1961988912 14986448 4500800
00:27:14 33782 8192000000 10883886416 11353563136 1926193600 19.036 99 13 26 0 1944211440 14727248 3290592
00:27:55 81356 8192000000 10864515376 11352432640 1917394592 18.966 98 18 35 1 1943126208 21072064 4659552
00:29:23 49495 8192000000 10863725504 11349413888 1920258528 18.989 99 7 13 0 1939862832 17788768 1815536
00:30:20 106920 8192000000 10858477744 11331809280 1744148608 17.553 89 15 30 1 1759132736 11818720 3165408
00:32:13 83099 8192000000 10859904176 11308457984 1781885984 17.865 92 26 53 0 1805422352 15673744 7862624
00:33:45 49702 8192000000 10859400688 11332005888 1887663456 18.727 98 19 38 2 1907542608 14802496 5076656
00:34:41 25308 8192000000 10841508816 11290570752 1835202736 18.302 95 32 64 0 1851834960 7585104 9047120
00:35:25 15354 8192000000 10863216512 11318829056 1922764800 19.009 100 38 76 0 1945778912 12288448 10725664
00:35:47 54340 8192000000 10857794800 11334692864 1931205968 19.077 100 19 38 0 1949235040 12511584 5517488
00:37:18 88394 8192000000 10872829568 11349708800 1883519744 18.694 97 21 42 4 1906299632 16460800 6319088
00:38:57 26964 8192000000 10876069440 11327680512 1901325920 18.837 98 30 60 2 1919634624 10311264 7997440
00:39:38 22924 8192000000 10888569936 11340824576 1939828832 19.145 100 43 86 2 1969286944 17471824 11986288
00:40:14 98576 8192000000 10827943152 11300663296 1811355184 18.107 94 22 44 0 1831171248 13700720 6115344
00:42:07 21905 8192000000 10856006080 11300458496 1854752240 18.461 97 30 60 0 1874548576 11185648 8610688
00:42:40 23370 8192000000 10847888176 11296276480 1874345296 18.619 98 46 92 0 1906255648 19188752 12721600
00:43:23 35212 8192000000 10869314528 11328839680 1913529888 18.935 100 31 62 2 1937084384 14766560 8787936
00:44:07 138578 8192000000 10838718640 11311349760 1887420640 18.725 98 18 36 0 1909565296 16707408 5437248
00:46:32 78966 8192000000 10852928144 11339624448 1914523760 18.943 99 19 37 1 1934390864 14837120 5029984
00:48:01 32755 8192000000 10874132992 11331162112 1939460736 19.142 100 17 34 0 1955265088 10127184 5677168
00:48:41 39710 8192000000 10872349536 11339243520 1947480208 19.206 100 36 72 1 1966532224 9005872 10046144
00:49:31 34193 8192000000 10827380672 11300397056 1884113200 18.698 97 12 24 1 1893447632 5965168 3369264
00:50:12 44083 8192000000 10842992064 11319001088 1915231392 18.949 99 16 31 0 1925190816 5689184 4270240
00:51:05 57207 8192000000 10857127712 11334385664 1936802144 19.121 100 12 24 0 1946599632 6720256 3077232
00:52:15 67599 8192000000 10865935264 11346006016 1932970112 19.091 99 19 38 0 1945493600 7052320 5471168
00:53:29 50403 8192000000 10867736832 11352363008 1935237600 19.109 99 11 23 0 1949639488 11022816 3379072
00:54:26 99786 8192000000 10883957504 11358838784 1951272672 19.237 100 21 42 1 1970617616 13346912 5998032
00:56:12 29771 8192000000 10881226912 11357503488 1953034512 19.251 100 20 40 2 1975122400 15343296 6744592
00:56:53 38903 8192000000 10870273344 11340050432 1934928368 19.106 99 20 40 0 1954004448 13185584 5890496
00:57:41 78104 8192000000 10884633728 11370762240 1964352720 19.341 100 18 35 1 1982112240 12093008 5666512
00:59:19 46507 8192000000 10903530320 11378831360 1938943312 19.138 98 25 50 1 1960366640 14215152 7208176
01:00:35 61066 8192000000 10895339088 11381301248 1936724336 19.121 98 14 28 0 1954169408 13135520 4309552
01:01:59 66814 8192000000 10914043072 11385184256 1929857168 19.066 97 40 81 2 1953070480 11910192 11303120
01:03:14 80230 8192000000 10910752512 11404255232 1961787312 19.320 99 16 32 0 1984370752 17556336 5027104
01:05:33 33884 8192000000 10922218496 11403505664 1993880080 19.574 100 43 82 6 2014891056 8864592 12146384
01:06:25 37531 8192000000 10918281136 11385487360 1957450928 19.286 98 18 36 1 1970338720 8426832 4460960
01:07:12 52445 8192000000 10917549312 11391156224 1949544832 19.223 98 19 38 1 1964424480 9789056 5090592
01:08:54 50161 8192000000 10892930464 11360743424 1956831056 19.281 99 25 50 0 1971971504 7563984 7576464
01:09:56 58398 8192000000 10902011168 11388604416 1942567632 19.167 98 23 46 2 1959499216 10548864 6382720
01:11:18 103630 8192000000 10927380048 11412168704 1964840704 19.344 99 6 12 0 1984629744 18010272 1778768
01:13:07 143659 8192000000 10888606336 11361226752 1912655920 18.928 96 20 41 1 1931639232 12728272 6255040
01:15:56 44053 8192000000 10905868688 11363209216 1934083168 19.100 98 26 52 1 1952446272 10988320 7374784
01:16:47 56382 8192000000 10862770816 11353841664 1888777712 18.736 96 12 23 2 1904865072 13212640 2874720
01:17:53 54217 8192000000 10872166880 11363418112 1948278064 19.213 100 6 12 0 1964438208 14222576 1937568
01:18:54 3005 8192000000 10868041040 11363885056 1948913168 19.218 100 3 6 0 1964562800 14786592 863040
01:19:03 7182 8192000000 10868137600 11358277632 1927661008 19.048 99 4 9 0 1942390880 13903552 826320
01:19:40 58634 8192000000 10846410800 11329622016 1823500064 18.206 94 5 10 0 1835541568 10876512 1164992
01:20:52 87845 8192000000 10844293872 11320950784 1852106128 18.439 96 17 32 2 1864813872 8571760 4135984
01:22:27 37972 8192000000 10836200928 11315281920 1888288000 18.732 98 17 34 1 1902604992 9366288 4950704
01:23:13 72614 8192000000 10821039840 11299225600 1809251584 18.090 94 9 18 0 1819326480 7674848 2400048
01:24:32 45274 8192000000 10846339568 11328802816 1921916704 19.002 100 32 64 5 1938196672 7441600 8838368
01:25:46 32870 8192000000 10856596000 11321868288 1889195136 18.739 98 38 75 0 1911424768 11777648 10451984
01:26:25 62475 8192000000 9419707648 9723387904 567597776 6.479 30 5 9 0 575297712 6186864 1513072

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 07-03-2021 01:28:40 to 07-03-2021 01:29:12.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-03-2021 01:29:13 to 07-03-2021 01:29:15.

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          245260
MON$OLDEST_ACTIVE               246127
MON$OLDEST_SNAPSHOT             246127
MON$NEXT_TRANSACTION            246127
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                       2062944
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:124: 
:125: mscs-test-161.budzdorov.ru    Sun Mar  7 01:27:29 2021
:126:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:127: 
:128: 
:129: mscs-test-161.budzdorov.ru    Sun Mar  7 01:27:43 2021
:130:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:131: 
--- end of diff output ---

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

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