Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.02.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 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 16851156 kB
MemAvailable 31194452 kB
Buffers 0 kB
Cached 14865664 kB
SwapCached 4724 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-02-15 01:27:20
DTS_END                         2021-02-15 01:27:20.2950
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/53542
TRN_ID                          247970
ATT_ID                          702
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: 9429.99 23913 1131599
customer order: creation 179.56 318 21547
customer order: refuse 15.58 349 1870
order to supplier: creation 47.27 1198 5672
order to supplier: removal 3.59 107086 431
invoice (draft): creation 47.50 3370 5700
invoice (draft): removal 53.38 892 6406
invoice accept: apply 42.67 17994 5120
invoice accept: cancel 48.57 766 5828
customer reserve: creation 3975.78 176 477094
customer reserve: removal 4710.18 63 565222
realization accept: apply 86.80 183 10416
realization accept: cancel 84.93 113 10192
payment from customer: creation 61.58 99 7389
payment from customer: removal 5.73 104 687
payment to supplier: creation 50.64 121 6077
payment to supplier: removal 3.62 115 434
service: total inventory turnovers 4.84 956 581
service: total monetary turnovers 6.84 28 821
service: aggregate perf. data 0.90 20701 108
service: refresh index statistics 0.03 323621 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-02-2021 01:29:09 to 15-02-2021 01:29:11.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3531
TEST_TIME 2 2309
TEST_TIME 3 2964
TEST_TIME 4 3283
TEST_TIME 5 3557
TEST_TIME 6 3660
TEST_TIME 7 3857
TEST_TIME 8 4061
TEST_TIME 9 4117
TEST_TIME 10 5029
TEST_TIME 11 5300
TEST_TIME 12 5740
TEST_TIME 13 6465
TEST_TIME 14 6830
TEST_TIME 15 6995
TEST_TIME 16 7294
TEST_TIME 17 7492
TEST_TIME 18 7584
TEST_TIME 19 7859
TEST_TIME 20 7820
TEST_TIME 21 8267
TEST_TIME 22 8604
TEST_TIME 23 8818
TEST_TIME 24 8700
TEST_TIME 25 9139
TEST_TIME 26 9113
TEST_TIME 27 10411
TEST_TIME 28 11238
TEST_TIME 29 11158
TEST_TIME 30 11282
TEST_TIME 31 11033
TEST_TIME 32 10970
TEST_TIME 33 10867
TEST_TIME 34 11029
TEST_TIME 35 11007
TEST_TIME 36 10921
TEST_TIME 37 10720
TEST_TIME 38 10562
TEST_TIME 39 10328
TEST_TIME 40 10470
TEST_TIME 41 10349
TEST_TIME 42 10385
TEST_TIME 43 10313
TEST_TIME 44 10260
TEST_TIME 45 10155
TEST_TIME 46 10119
TEST_TIME 47 10290
TEST_TIME 48 10349
TEST_TIME 49 10260
TEST_TIME 50 10179
TEST_TIME 51 10027
TEST_TIME 52 9916
TEST_TIME 53 9826
TEST_TIME 54 9937
TEST_TIME 55 9896
TEST_TIME 56 9816
TEST_TIME 57 9747
TEST_TIME 58 9641
TEST_TIME 59 9659
TEST_TIME 60 9625
TEST_TIME 61 9538
TEST_TIME 62 9542
TEST_TIME 63 9732
TEST_TIME 64 9710
TEST_TIME 65 9810
TEST_TIME 66 9890
TEST_TIME 67 9879
TEST_TIME 68 9908
TEST_TIME 69 9975
TEST_TIME 70 9942
TEST_TIME 71 10028
TEST_TIME 72 9942
TEST_TIME 73 9920
TEST_TIME 74 9841
TEST_TIME 75 9813
TEST_TIME 76 9817
TEST_TIME 77 9816
TEST_TIME 78 9760
TEST_TIME 79 9718
TEST_TIME 80 9660
TEST_TIME 81 9695
TEST_TIME 82 9708
TEST_TIME 83 9663
TEST_TIME 84 9617
TEST_TIME 85 9588
TEST_TIME 86 9624
TEST_TIME 87 9787
TEST_TIME 88 9790
TEST_TIME 89 9773
TEST_TIME 90 9723
TEST_TIME 91 9787
TEST_TIME 92 9773
TEST_TIME 93 9838
TEST_TIME 94 9893
TEST_TIME 95 9810
TEST_TIME 96 9747
TEST_TIME 97 9720
TEST_TIME 98 9679
TEST_TIME 99 9618
TEST_TIME 100 9673
TEST_TIME 101 9618
TEST_TIME 102 9668
TEST_TIME 103 9618
TEST_TIME 104 9605
TEST_TIME 105 9615
TEST_TIME 106 9613
TEST_TIME 107 9599
TEST_TIME 108 9613
TEST_TIME 109 9626
TEST_TIME 110 9609
TEST_TIME 111 9652
TEST_TIME 112 9631
TEST_TIME 113 9635
TEST_TIME 114 9593
TEST_TIME 115 9534
TEST_TIME 116 9517
TEST_TIME 117 9528
TEST_TIME 118 9503
TEST_TIME 119 9493
TEST_TIME 120 9436

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 15-02-2021 01:29:12 to 15-02-2021 01:29:16.

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 1574438 1574438 0 0.00 0 20938 6 0 0
doc_list_biud 1574437 1574437 0 0.00 0 27236 29 0 0
sp_add_invoice_to_stock 5198 5120 78 1.50 32 186853 17994 0 78
sp_cancel_adding_invoice 5828 5828 0 0.00 5 39415 766 0 0
sp_cancel_client_order 1870 1870 0 0.00 5 7837 350 0 0
sp_cancel_customer_reserve 565222 565222 0 0.00 1 27245 64 0 0
sp_cancel_pay_from_customer 687 687 0 0.00 3 7079 105 0 0
sp_cancel_pay_to_supplier 434 434 0 0.00 3 5853 115 0 0
sp_cancel_supplier_invoice 6414 6406 8 0.12 2 13781 892 0 8
sp_cancel_supplier_order 431 431 0 0.00 7 1162635 107086 0 0
sp_cancel_write_off 10192 10192 0 0.00 1 11740 113 0 0
sp_client_order 21547 21547 0 0.00 4 55560 319 0 0
sp_customer_reserve 477094 477094 0 0.00 0 53865 176 0 0
sp_fill_shopping_cart 32894 32894 0 0.00 1 14852 38 0 0
sp_fill_shopping_cart_clo_res 477086 477086 0 0.00 0 27287 13 0 0
sp_get_clo_for_invoice 5108 5108 0 0.00 0 33615 305 0 0
sp_kill_cost_storno 17141 17141 0 0.00 0 6299 59 0 0
sp_kill_qstorno_ret_qs2qd 1147473 1147473 0 0.00 0 27217 34 0 0
sp_kill_qty_storno 605473 605473 0 0.00 0 27235 74 0 0
sp_lock_selected_doc 21607 21607 0 0.00 0 8777 7 0 0
sp_make_cost_storno 28990 28990 0 0.00 0 20844 49 0 0
sp_multiply_rows_for_pdistr 28990 28990 0 0.00 0 12139 29 0 0
sp_multiply_rows_for_qdistr 21547 21547 0 0.00 0 55518 147 0 0
sp_pay_from_customer 7389 7389 0 0.00 4 12152 100 0 0
sp_pay_to_supplier 6077 6077 0 0.00 5 18650 121 0 0
sp_payment_common 13466 13466 0 0.00 1 9418 24 0 0
sp_qd_handle_on_cancel_clo 1870 1870 0 0.00 0 7828 315 0 0
sp_qd_handle_on_invoice_upd_sts 10936 10936 0 0.00 0 20611 340 0 0
sp_qd_handle_on_reserve_upd_sts 10416 10416 0 0.00 0 15846 62 0 0
sp_reserve_write_off 10416 10416 0 0.00 6 15887 183 0 0
sp_supplier_invoice 5700 5700 0 0.00 6 85359 3370 0 0
sp_supplier_order 5672 5672 0 0.00 5 32321 1198 0 0
srv_aggregate_perf_data 108 108 0 0.00 2302 498293 20701 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 845 140366 30190 0 0
srv_find_qd_qs_mism 1082671 1082671 0 0.00 0 20896 5 0 0
srv_make_invnt_saldo 581 581 0 0.00 23 21159 956 0 0
srv_make_money_saldo 821 821 0 0.00 1 885 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 211631 463061 323621 0 0
t$perf-abend:sp_add_invoice_to_stock 78 78 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5120 5120 0 0.00 0 18370 172 0 0
t$perf-norm:sp_cancel_adding_invoice 458 458 0 0.00 0 4439 76 0 0
t$perf-norm:sp_cancel_client_order 1870 1870 0 0.00 0 3812 19 0 0
t$perf-norm:sp_cancel_customer_reserve 738 738 0 0.00 0 1198 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 687 687 0 0.00 0 9319 21 0 0
t$perf-norm:sp_cancel_pay_to_supplier 434 434 0 0.00 0 3857 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 387 387 0 0.00 0 2231 29 0 0
t$perf-norm:sp_cancel_supplier_order 431 431 0 0.00 0 33259 1702 0 0
t$perf-norm:sp_cancel_write_off 1078 1078 0 0.00 0 6759 12 0 0
t$perf-norm:sp_client_order 21547 21547 0 0.00 0 15967 23 0 0
t$perf-norm:sp_customer_reserve 1109 1109 0 0.00 0 2021 5 0 0
t$perf-norm:sp_pay_from_customer 7389 7389 0 0.00 0 7226 10 0 0
t$perf-norm:sp_pay_to_supplier 6077 6077 0 0.00 0 11731 11 0 0
t$perf-norm:sp_reserve_write_off 10416 10416 0 0.00 0 7071 13 0 0
t$perf-norm:sp_supplier_invoice 5700 5700 0 0.00 0 6207 17 0 0
t$perf-norm:sp_supplier_order 5672 5672 0 0.00 0 5830 17 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 335 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 259 4 0 0
t$perf-norm:srv_make_invnt_saldo 581 581 0 0.00 0 1205 22 0 0
t$perf-norm:srv_make_money_saldo 821 821 0 0.00 0 1911 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 2 2 0 0
v_add_invoice_to_stock 10372 10216 156 1.50 0 9514 19 0 156
v_all_customers 39344 39344 0 0.00 0 19 1 0 0
v_all_suppliers 31538 31538 0 0.00 0 15 1 0 0
v_all_wares 43094 43094 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 916 916 0 0.00 0 3727 12 0 0
v_cancel_client_order 3740 3740 0 0.00 0 3665 6 0 0
v_cancel_customer_prepayment 1374 1374 0 0.00 0 7042 11 0 0
v_cancel_customer_reserve 1476 1476 0 0.00 0 7057 13 0 0
v_cancel_payment_to_supplier 868 868 0 0.00 0 5827 19 0 0
v_cancel_supplier_invoice 790 774 16 2.02 0 8679 24 0 16
v_cancel_supplier_order 862 862 0 0.00 0 2177 7 0 0
v_cancel_write_off 2156 2156 0 0.00 0 3639 19 0 0
v_max_id_clo_ord 5670 5670 0 0.00 0 592 2 0 0
v_max_id_clo_res 1109 1109 0 0.00 0 5782 12 0 0
v_max_id_ord_sup 5672 5672 0 0.00 0 3582 5 0 0
v_max_non_paid_invoice 1650 1650 0 0.00 0 1636 4 0 0
v_max_non_paid_realizn 3827 3827 0 0.00 0 1225 4 0 0
v_min_id_clo_ord 5670 5670 0 0.00 0 2969 6 0 0
v_min_id_clo_res 1109 1109 0 0.00 0 2866 5 0 0
v_min_id_ord_sup 5672 5672 0 0.00 0 6833 5 0 0
v_min_non_paid_invoice 6077 6077 0 0.00 0 6503 13 0 0
v_min_non_paid_realizn 7389 7389 0 0.00 0 9413 14 0 0
v_our_firm 10874 10874 0 0.00 0 21 1 0 0
v_reserve_write_off 20832 20832 0 0.00 0 5292 6 0 0
x_lock_depdocs_on_canc_invoice 11847 11847 0 0.00 0 18895 126 0 0
x_lock_depdocs_on_canc_sup_ord 431 431 0 0.00 0 14049 442 0 0
x_make_qstorno_1000_1200 5672 5672 0 0.00 2 32316 1112 0 0
x_make_qstorno_1200_2000 5700 5700 0 0.00 2 78834 3237 0 0
x_make_qstorno_2100_3300 477094 477094 0 0.00 0 43540 161 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-02-2021 01:29:17 to 15-02-2021 01:29:21.

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:24 3 8192000000 8799425440 8810299392 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:30 17260 8192000000 10224517728 10531422208 917467296 10.071 73 55 112 0 938024896 2371136 18186464
22:57:55 23823 8192000000 10308975488 10619822080 1357204736 14.212 100 84 168 1 1389932048 4762960 27964352
22:58:28 14591 8192000000 10342767392 10657771520 1402521056 14.617 100 90 180 0 1438512448 5950960 30040432
22:58:55 6443 8192000000 10369691648 10685931520 1430085952 14.862 100 92 184 0 1466691952 6452144 30153856
22:59:12 21176 8192000000 10385784736 10712252416 1442870848 14.975 100 87 174 0 1478227040 7072672 28283520
22:59:47 6956 8192000000 10399234176 10726821888 1461807776 15.142 100 87 174 0 1497831568 7366128 28657664
23:00:04 21512 8192000000 10428442736 10755670016 1474578992 15.254 100 86 173 0 1510170032 7821616 27769424
23:00:39 17227 8192000000 10452304016 10783985664 1506541472 15.533 100 88 177 2 1543292464 8779136 27971856
23:01:07 21926 8192000000 10477769792 10821464064 1530105056 15.738 100 82 164 2 1565294176 9507840 25681280
23:01:54 11665 8192000000 10509047744 10857680896 1567123552 16.058 100 80 160 1 1602952400 10339152 25489696
23:02:15 10674 8192000000 10533860928 10886881280 1589390448 16.249 100 82 164 0 1625291024 10888800 25011776
23:02:36 11736 8192000000 10556759472 10913808384 1618752080 16.499 100 79 157 2 1653391376 11145168 23494128
23:02:56 12011 8192000000 10588477456 10945073152 1638643376 16.668 100 80 160 0 1674698096 12107152 23947568
23:03:17 15677 8192000000 10609844592 10972360704 1669116032 16.926 100 90 180 1 1709091568 13032160 26943376
23:03:43 13010 8192000000 10617496352 10985541632 1678147424 17.002 100 80 160 0 1714205184 13067184 22990576
23:04:07 9408 8192000000 10630113808 11000197120 1692141376 17.119 100 84 168 2 1731095872 13787040 25167456
23:04:27 8241 8192000000 10654295584 11024748544 1708462240 17.256 100 81 162 0 1745227872 13643040 23122592
23:04:42 7246 8192000000 10651703872 11028250624 1719480896 17.348 100 78 154 4 1753977024 12646080 21850048
23:04:57 8206 8192000000 10673051904 11049598976 1737391296 17.497 100 79 158 3 1772729808 13233648 22104864
23:05:11 7938 8192000000 10678019424 11053596672 1742715632 17.541 100 87 175 2 1781620352 13867632 25037088
23:05:33 5034 8192000000 10686621536 11064377344 1754071808 17.635 100 81 162 0 1790495712 13289760 23134144
23:05:45 4474 8192000000 10693969248 11071889408 1758936144 17.676 100 82 164 2 1795954960 13966176 23052640
23:05:56 4322 8192000000 10705853040 11082784768 1767836208 17.749 100 82 162 0 1802978608 12415360 22727040
23:06:07 2879 8192000000 10708979840 11087478784 1776786912 17.823 100 88 177 4 1815094816 12990320 25317584
23:06:18 3249 8192000000 10718334944 11099082752 1784317440 17.885 100 86 172 2 1821489232 12607568 24564224
23:06:27 2539 8192000000 10732992256 11111657472 1789307984 17.926 100 84 168 0 1826598288 13088448 24201856
23:06:36 2861 8192000000 10734951952 11112505344 1795221136 17.975 100 86 172 2 1832761968 12892880 24647952
23:06:46 2543 8192000000 10740120208 11118600192 1801231424 18.024 100 83 166 1 1836429056 12301920 22895712
23:06:55 2122 8192000000 10750639856 11128107008 1809887744 18.095 100 96 189 2 1849872464 13636064 26348656
23:07:04 9953 8192000000 10744954672 11130150912 1808431344 18.083 100 78 157 1 1844638016 14555456 21651216
23:07:20 2766 8192000000 10751892960 11136454656 1813116144 18.121 100 77 154 2 1848476368 14173216 21187008
23:07:29 2603 8192000000 10775832160 11162075136 1834685120 18.298 100 88 173 0 1871805536 12697280 24423136
23:07:38 1864 8192000000 10780764000 11165745152 1840616816 18.346 100 91 182 1 1878183040 11470416 26095808
23:07:47 1427 8192000000 10791284448 11172765696 1846244944 18.392 100 95 191 1 1886510240 12998432 27266864
23:07:54 1594 8192000000 10791778304 11178033152 1852991456 18.446 100 90 180 1 1890475200 12777696 24706048
23:08:02 1738 8192000000 10794853824 11181584384 1853733872 18.452 100 89 178 1 1892032320 13484128 24814320
23:08:10 1999 8192000000 10805945872 11189899264 1856801216 18.477 100 91 183 1 1896878224 13690416 26386592
23:08:19 2265 8192000000 10807592384 11191840768 1860996368 18.511 100 93 188 4 1899941216 12429248 26515600
23:08:27 1325 8192000000 10807065424 11195793408 1864386336 18.539 100 92 186 3 1904303040 13735600 26181104
23:08:35 1594 8192000000 10813381280 11198046208 1868745808 18.574 100 91 180 1 1907869968 12846496 26277664
23:08:43 1457 8192000000 10813749744 11200716800 1868862272 18.575 100 95 191 1 1908873888 13078416 26933200
23:08:51 21395 8192000000 10800398384 11200286720 1864437664 18.539 100 63 126 1 1892008368 9164240 18406464
23:09:19 2864 8192000000 10801801280 11204898816 1869326672 18.579 100 64 128 0 1898091392 9973632 18791088
23:09:28 3706 8192000000 10803424960 11207118848 1871455024 18.596 100 60 121 0 1897996672 9321680 17219968
23:09:40 3894 8192000000 10789676976 11205197824 1869578512 18.581 100 42 84 1 1890233024 8663984 11990528
23:09:50 5294 8192000000 10788049728 11211165696 1875163360 18.626 100 40 80 0 1896028176 9800592 11064224
23:10:07 5794 8192000000 10785763568 11208769536 1872996352 18.609 100 31 62 1 1888288304 6463088 8828864
23:10:18 5655 8192000000 10795109136 11211747328 1879959360 18.665 100 36 72 1 1897224224 7021648 10243216
23:10:31 6202 8192000000 10788718672 11213340672 1881329744 18.676 100 41 82 3 1899728832 6235104 12163984
23:10:46 10948 8192000000 10783033040 11214704640 1880211936 18.667 100 22 44 2 1893288928 6491552 6585440
23:11:04 11640 8192000000 10779998800 11217063936 1881235504 18.675 100 13 26 0 1890669824 5794384 3639936
23:11:25 9164 8192000000 10787530432 11218997248 1885495696 18.709 100 17 34 2 1895946240 5857952 4592592
23:11:49 10677 8192000000 10802317904 11230973952 1890810448 18.752 100 13 26 4 1900317664 5925328 3581888
23:12:08 71499 8192000000 10840632160 11250499584 1901410368 18.838 100 39 78 3 1919476528 5733760 12332400
23:13:26 3706 8192000000 10822114480 11251503104 1903045216 18.851 100 40 80 1 1923196000 9019744 11131040
23:13:39 3658 8192000000 10817230480 11252871168 1905395696 18.870 100 33 64 2 1921174048 6502016 9276336
23:13:52 7043 8192000000 10828306832 11258421248 1910936592 18.914 100 28 56 2 1924319808 5867824 7515392
23:14:06 6117 8192000000 10831380544 11261161472 1912817376 18.929 100 23 46 1 1925210912 5946480 6447056
23:14:19 3933 8192000000 10827601632 11262976000 1911982512 18.923 100 18 37 1 1923447248 6581776 4882960
23:14:30 5767 8192000000 10835096224 11260334080 1913442208 18.934 100 27 55 1 1925953568 4861168 7650192
23:14:43 7286 8192000000 10831875056 11265298432 1915289120 18.949 100 27 56 2 1928770624 5383088 8098416
23:14:56 10547 8192000000 10828851488 11264110592 1914199632 18.940 100 23 47 1 1926840400 6118064 6522704
23:15:13 6421 8192000000 10829849936 11263565824 1914183952 18.940 100 23 46 2 1926144656 5447840 6512864
23:15:29 5734 8192000000 10830482400 11266019328 1916769312 18.961 100 24 46 2 1930018656 6784128 6465216
23:15:43 9740 8192000000 10827474960 11262873600 1914321104 18.941 100 23 46 2 1927534224 5859552 7353568
23:16:03 12264 8192000000 10827954640 11268800512 1918541200 18.975 100 22 44 1 1931318784 6035904 6741680
23:16:22 12140 8192000000 10797993152 11237576704 1841698480 18.355 96 17 34 0 1851668016 5121216 4848320
23:16:42 17595 8192000000 10803518896 11233751040 1861028672 18.512 98 19 38 1 1872720256 5916144 5775440
23:17:07 48517 8192000000 10776335952 11200700416 1798778736 18.004 95 23 46 0 1810769472 4945648 7045088
23:18:02 18970 8192000000 10781780256 11207823360 1786772400 17.905 95 27 52 2 1805160672 10551488 7836784
23:18:33 5625 8192000000 10746392800 11169341440 1793900384 17.964 96 37 74 1 1811678432 7141504 10636544
23:18:45 5968 8192000000 10774015824 11196084224 1833717488 18.290 99 40 81 2 1856981376 12197296 11066592
23:18:57 5227 8192000000 10767262976 11185147904 1817696512 18.159 98 43 84 1 1836572480 7036848 11839120
23:19:10 3441 8192000000 10732278208 11145142272 1773702112 17.798 97 42 84 2 1792459136 6565344 12191680
23:19:22 6668 8192000000 10733622176 11156021248 1808855360 18.087 99 23 46 2 1821666640 6189936 6621344
23:19:34 8462 8192000000 10692089952 11101036544 1677140992 16.993 93 23 46 1 1688890288 5276752 6472544
23:19:49 5111 8192000000 10717815872 11128176640 1782502272 17.870 99 31 62 2 1797441024 5155728 9783024
23:20:01 10570 8192000000 10725900976 11142811648 1740951184 17.527 96 32 63 2 1756464768 6466672 9046912
23:20:19 8428 8192000000 10712053968 11124867072 1738706272 17.508 96 18 36 2 1749700384 4767680 6226432
23:20:37 13313 8192000000 10723199744 11142672384 1742418832 17.539 96 25 50 0 1759313024 9802368 7091824
23:20:56 7226 8192000000 10716351984 11137482752 1766182528 17.735 97 35 71 0 1782369888 5638032 10549328
23:21:11 7722 8192000000 10701921568 11115540480 1766531200 17.738 98 23 44 1 1778749648 5676480 6541968
23:21:28 8885 8192000000 10710918672 11125194752 1772240704 17.786 98 16 29 0 1782076272 4713760 5121808
23:21:49 23904 8192000000 10750911920 11172163584 1774570352 17.805 97 22 43 1 1786480688 4898640 7011696
23:23:03 21141 8192000000 10756313616 11191177216 1849476256 18.418 100 23 46 0 1866907344 11040160 6390928
23:23:33 12337 8192000000 10771519984 11195441152 1842843680 18.364 99 23 46 0 1855148960 5952048 6353232
23:23:52 5247 8192000000 10785579584 11209605120 1861469824 18.515 100 38 76 0 1880197472 7946192 10781456
23:24:04 7585 8192000000 10776556176 11203395584 1858104912 18.488 100 23 46 2 1871431424 6565072 6761440
23:24:21 6164 8192000000 10767344608 11201744896 1846006576 18.390 99 29 58 2 1860108768 5150736 8951456
23:24:33 6228 8192000000 10784978288 11207876608 1862104384 18.520 100 33 66 3 1877266016 5778736 9382896
23:24:48 4983 8192000000 10775222976 11199172608 1856272768 18.473 100 25 51 0 1869391440 5742640 7376032
23:25:02 6957 8192000000 10785265792 11202379776 1858837104 18.494 100 28 55 1 1872014192 4363072 8814016
23:25:17 12280 8192000000 10776216800 11207520256 1862299696 18.522 100 24 48 1 1879308288 9412416 7596176
23:25:36 8923 8192000000 10778872512 11207852032 1864325168 18.538 100 23 46 0 1876878800 4876480 7677152
23:25:51 7149 8192000000 10771993008 11212722176 1868101680 18.569 100 28 56 1 1882670192 6400704 8167808
23:26:05 8215 8192000000 10778014032 11216695296 1868209552 18.570 100 17 34 2 1879063344 5987600 4866192
23:26:21 12161 8192000000 10781416816 11220828160 1873688816 18.614 100 20 39 0 1885444176 5607776 6147584
23:26:41 10090 8192000000 10787009840 11221311488 1880141456 18.666 100 21 42 2 1891834736 5591504 6101776
23:26:59 31241 8192000000 10827841472 11252195328 1885874720 18.713 100 22 44 3 1897495600 5129344 6491536
23:29:07 57634 8192000000 10863826864 11292266496 1927637600 19.048 100 33 65 1 1944239680 7331184 9270896
23:30:17 21857 8192000000 10894779040 11316555776 1950690656 19.232 100 53 106 2 1982825312 16717280 15417376
23:30:53 19634 8192000000 10896351424 11328544768 1959119344 19.299 100 43 86 5 1989365312 17430384 12815584
23:31:22 11271 8192000000 10897901648 11333382144 1963553248 19.334 100 56 111 1 1998393008 17678656 17161104
23:31:55 38238 8192000000 10896353872 11333922816 1961710784 19.320 100 44 88 1 1993288160 18323360 13254016
23:32:51 13247 8192000000 10904615040 11337912320 1951150512 19.236 99 43 87 1 1983168592 18994688 13023392
23:33:21 25602 8192000000 10913880368 11341877248 1955081888 19.267 99 45 89 0 1989333424 20775488 13476048
23:33:57 11875 8192000000 10921727632 11348398080 1973160768 19.411 100 53 103 1 2011552944 22874944 15517232
23:34:27 18901 8192000000 10922992624 11359985664 1980168128 19.466 100 50 99 1 2017078992 22279552 14631312
23:34:55 11851 8192000000 10930005936 11368607744 1985447040 19.508 100 48 94 1 2023919440 24242416 14229984
23:35:15 9942 8192000000 10924610640 11360030720 1971022160 19.394 99 43 86 3 2007599872 23008208 13569504
23:35:35 5532 8192000000 10947379936 11376005120 1995107024 19.584 100 66 128 1 2039045552 24024992 19913536
23:35:49 2744 8192000000 10951819616 11379847168 1998495376 19.611 100 60 120 0 2041949344 25125808 18328160
23:36:01 3347 8192000000 10955123200 11382779904 1997356720 19.602 100 58 116 2 2041791728 26230064 18204944
23:36:13 26079 8192000000 10962813680 11387162624 1978956320 19.456 99 56 112 2 2025068464 29453232 16658912
23:36:48 2384 8192000000 10964490352 11390242816 1998564768 19.611 100 60 120 0 2049390944 32416112 18410064
23:36:58 12268 8192000000 10960398400 11392786432 2000324912 19.625 100 58 116 1 2051396736 33279264 17792560
23:37:17 7970 8192000000 10961760944 11396300800 2000702656 19.628 100 52 104 0 2052523040 34334512 17485872
23:37:36 1106 8192000000 10974235552 11393142784 2000689536 19.628 100 65 129 2 2053465952 32844624 19931792
23:37:44 1965 8192000000 10988682576 11405221888 2012866096 19.724 100 90 181 4 2071335760 32045936 26423728
23:37:53 3823 8192000000 10970815920 11396739072 2003334560 19.649 100 62 125 0 2053658912 31869936 18454416
23:38:06 4713 8192000000 10977553728 11399319552 2005785904 19.668 100 72 144 1 2059727712 32632656 21309152
23:38:18 10280 8192000000 10979026608 11396812800 2005838624 19.669 100 72 141 1 2061209776 34615696 20755456
23:38:35 2645 8192000000 10991439264 11411406848 2013244368 19.727 100 89 174 1 2073654384 35512544 24897472
23:38:46 1907 8192000000 10997820624 11419340800 2018676464 19.770 100 91 182 0 2082019344 36218912 27123968
23:38:55 3927 8192000000 10983575904 11407163392 2009918112 19.701 100 81 163 2 2070962608 36000272 25044224
23:39:17 2975 8192000000 10989953040 11417206784 2019933088 19.780 100 75 149 3 2081329136 38148784 23247264
23:39:27 6340 8192000000 10985131504 11412369408 1992283632 19.562 99 70 141 1 2054872400 40734032 21854736
23:39:40 2570 8192000000 10987442768 11411849216 1993762640 19.574 99 82 164 2 2061556704 40880208 26913856
23:39:52 2868 8192000000 10995584352 11416735744 2008091136 19.686 100 74 147 0 2071685696 41018864 22575696
23:40:04 9499 8192000000 10975492000 11411996672 2003596768 19.651 100 57 112 1 2060016080 38788384 17630928
23:40:20 2412 8192000000 10955964944 11381993472 1982546944 19.485 100 75 148 3 2044169984 38804864 22818176
23:40:29 4654 8192000000 10949102544 11375792128 1978102240 19.450 100 63 126 2 2035398400 37384832 19911328
23:40:43 2670 8192000000 10947904800 11374821376 1977071840 19.442 100 60 115 2 2030480976 34968416 18440720
23:40:55 2427 8192000000 10972583984 11395309568 1988730272 19.534 100 78 157 0 2048400592 35534640 24135680
23:41:06 2854 8192000000 10965275136 11393941504 1991450992 19.555 100 79 154 2 2052642496 36963136 24228368
23:41:20 5287 8192000000 10979321008 11397861376 1993252448 19.569 100 75 151 1 2052401424 35667024 23481952
23:41:32 3654 8192000000 10979558976 11403476992 1997919264 19.606 100 85 168 1 2065841216 41751584 26170368
23:41:42 7833 8192000000 10969722016 11392839680 1991450160 19.555 100 82 164 1 2054238144 38188128 24599856
23:41:57 4849 8192000000 10970898592 11389083648 1988430752 19.531 100 76 152 0 2047510640 36690976 22388912
23:42:10 3699 8192000000 10972534448 11392389120 1987387696 19.523 100 90 182 2 2054145888 39427840 27330352
23:42:20 3912 8192000000 10946823136 11364012032 1968710080 19.375 99 83 164 1 2032988944 38601120 25677744
23:42:32 2915 8192000000 10963768944 11378900992 1976277696 19.435 100 78 156 1 2040802960 39939136 24586128
23:42:41 3857 8192000000 10977951952 11393642496 1988356544 19.531 100 85 170 2 2056593888 42219888 26017456
23:42:52 2547 8192000000 10974194400 11386695680 1982698624 19.486 100 84 168 1 2049732112 41756528 25276960
23:43:02 2881 8192000000 10947849920 11364208640 1959045264 19.298 99 86 172 3 2027277200 42517584 25714352
23:43:13 2171 8192000000 10973184832 11386908672 1977633504 19.446 100 85 169 1 2046531840 43324672 25573664
23:43:22 4950 8192000000 10974590896 11392712704 1989586928 19.541 100 89 175 2 2056632288 40391040 26654320
23:43:35 5669 8192000000 10958787440 11377885184 1975091472 19.426 99 82 164 4 2042120256 41309024 25719760
23:43:50 10763 8192000000 10963637552 11390033920 1968959696 19.377 99 70 140 0 2035392624 44996512 21436416
23:44:09 4729 8192000000 10973053664 11393654784 1964115120 19.339 99 78 154 0 2036137664 47787360 24235184
23:44:23 3000 8192000000 10973189168 11399495680 1985088416 19.505 100 75 150 2 2058139760 48759744 24291600
23:44:32 2746 8192000000 10993465456 11415793664 1998083200 19.608 100 81 167 2 2073804288 50299312 25421776
23:44:41 2079 8192000000 10930664624 11340480512 1937428416 19.126 98 82 159 1 2007519056 45422976 24667664
23:44:54 2222 8192000000 10973944560 11384639488 1977694064 19.446 100 87 174 0 2049937376 45733312 26510000
23:45:03 2853 8192000000 10962696704 11379499008 1970228240 19.387 100 85 170 2 2043246832 46731760 26286832
23:45:13 1386 8192000000 10965021168 11378761728 1972044128 19.402 100 93 182 0 2047591424 47372496 28174800
23:45:24 2297 8192000000 10963867280 11374391296 1953405456 19.254 99 85 168 0 2028194768 48468112 26321200
23:45:33 2659 8192000000 10954512944 11365228544 1954425648 19.262 100 94 182 2 2034288656 51666656 28196352
23:45:43 2532 8192000000 10943804112 11350429696 1940404384 19.150 99 79 156 0 2015913152 51777840 23730928
23:45:55 4025 8192000000 10963261648 11377025024 1966243056 19.356 100 90 181 1 2046137792 52686592 27208144
23:46:06 1688 8192000000 10970918480 11386634240 1972118464 19.402 100 87 170 2 2052555344 53570704 26866176
23:46:15 1878 8192000000 10974589904 11384180736 1973711024 19.415 100 87 176 2 2054110752 53125056 27274672
23:46:24 6433 8192000000 10958243504 11394494464 1972242816 19.403 100 50 99 1 2043002272 54776368 15983088
23:46:42 10523 8192000000 10949173008 11393306624 1971563472 19.398 100 46 92 1 2043439872 56206832 15669568
23:47:07 7190 8192000000 10963680208 11395862528 1968860080 19.376 100 50 100 1 2044117696 58325472 16932144
23:47:22 6983 8192000000 10981858912 11416346624 1981629072 19.478 100 62 124 1 2065319696 62920480 20770144
23:47:39 8253 8192000000 10953252720 11381608448 1943596432 19.175 98 50 101 1 2021325264 60939344 16789488
23:47:58 11088 8192000000 10960924944 11395682304 1961688800 19.319 100 51 103 2 2043140832 64259392 17192640
23:48:24 3983 8192000000 10984397280 11405766656 1970088576 19.386 100 69 137 0 2058602720 65613344 22900800
23:48:35 6464 8192000000 10961271872 11399151616 1970372160 19.388 100 54 108 2 2046930944 58161856 18396928
23:48:51 12559 8192000000 10958405712 11388305408 1937127216 19.124 98 48 95 0 2009237968 55523840 16586912
23:49:13 12223 8192000000 10967204496 11399835648 1969882832 19.385 100 46 92 0 2044023344 58394720 15745792
23:49:32 10069 8192000000 10971246160 11411533824 1974602912 19.422 100 42 83 0 2044153136 55686672 13863552
23:49:54 9661 8192000000 10960054016 11400376320 1977346576 19.444 100 39 78 1 2044405920 53617744 13441600
23:50:25 20669 8192000000 10945569248 11394908160 1950047024 19.227 99 33 66 2 2007085280 45973488 11064768
23:50:53 25789 8192000000 10938202352 11378417664 1925897488 19.034 98 30 60 0 1986487664 50128944 10461232
23:51:35 21336 8192000000 10950246144 11396915200 1957082560 19.283 100 32 64 1 2026984544 58163040 11738944
23:52:15 19513 8192000000 10947163392 11404267520 1956332640 19.277 100 36 73 1 2038859664 69035952 13491072
23:53:01 9400 8192000000 10941884384 11401076736 1955600496 19.271 100 34 68 3 2026202528 58551456 12050576
23:53:23 19627 8192000000 10933015920 11391717376 1928117008 19.052 99 29 58 0 2006421568 67149792 11154768
23:53:53 24333 8192000000 10928219616 11406860288 1937385088 19.126 100 24 48 1 2013727968 66675584 9667296
23:54:32 28160 8192000000 10906153456 11380535296 1933725760 19.097 100 19 38 1 1990513536 50657744 6130032
23:55:46 37035 8192000000 10872826720 11347619840 1898804880 18.817 98 6 12 2 1917733520 17643984 1284656
23:56:50 98669 8192000000 10907131872 11359662080 1897605872 18.807 98 8 17 0 1913748048 14412560 1729616
23:58:40 21867 8192000000 10888283920 11338133504 1916064176 18.955 98 36 72 3 1938627472 12144032 10419264
23:59:17 40514 8192000000 10901600480 11338096640 1944151856 19.180 100 15 25 1 1957898096 10461024 3285216
00:00:41 24392 8192000000 10915046672 11362070528 1967036112 19.362 100 38 79 0 1985595168 7908960 10650096
00:01:15 98147 8192000000 10911966000 11375747072 1949491952 19.222 99 11 22 0 1962479776 10317648 2670176
00:03:06 104229 8192000000 10891046144 11337928704 1855686048 18.468 94 27 54 1 1871037072 7701488 7649536
00:04:57 100464 8192000000 10925345952 11374354432 1963559840 19.334 100 30 59 2 1984924960 11851616 9513504
00:06:46 58638 8192000000 10893217984 11367657472 1971559344 19.398 100 27 54 0 1996268608 15974464 8734800
00:07:52 66688 8192000000 10946073824 11383468032 1944947296 19.186 98 48 96 0 1972694032 13442896 14303840
00:09:16 64035 8192000000 10904556816 11378049024 1972258336 19.403 100 16 32 1 1990108032 13116384 4733312
00:10:27 35604 8192000000 10918681952 11383451648 1980928736 19.472 100 25 48 2 1999854000 11631488 7293776
00:11:31 23344 8192000000 10915971760 11378339840 1981964096 19.480 100 20 40 1 1996820016 8804384 6051536
00:12:11 40779 8192000000 10927600512 11390636032 1989773984 19.542 100 21 42 0 2006900128 10969152 6156992
00:13:02 39349 8192000000 10946724960 11404529664 1999464992 19.619 100 25 50 0 2020181264 12878608 7837664
00:13:53 39894 8192000000 10954535872 11406389248 2006127056 19.671 100 46 92 2 2034169232 13502480 14539696
00:15:18 27683 8192000000 10919245424 11398070272 1984584784 19.501 100 17 34 0 2003169728 14004912 4580032
00:15:53 39540 8192000000 10892738688 11370037248 1946995536 19.203 98 20 40 2 1961185664 8751728 5438400
00:17:19 23169 8192000000 10890748720 11357933568 1954653776 19.264 99 18 37 0 1966552704 7061344 4837584
00:17:51 29739 8192000000 10891941088 11361398784 1937629776 19.128 98 14 28 1 1953133680 10942960 4560944
00:19:27 67808 8192000000 10893329136 11377713152 1968368064 19.372 100 12 24 0 1987701712 15712512 3621136
00:20:47 79085 8192000000 10884643776 11372056576 1894024528 18.778 96 22 44 0 1915547936 15355600 6167808
00:22:18 54819 8192000000 10898026960 11369488384 1967761088 19.368 100 11 22 0 1979130512 7948944 3420480
00:23:20 13818 8192000000 10884934896 11354075136 1960253408 19.308 100 19 38 0 1973678464 7659472 5765584
00:23:41 843 8192000000 10905671792 11361546240 1966744336 19.360 100 43 84 4 1988111168 8574352 12792480
00:23:47 61238 8192000000 10883361968 11358470144 1942087280 19.163 98 31 62 0 1960618016 10239136 8291600
00:24:55 67180 8192000000 10886027760 11367153664 1936151408 19.116 98 21 42 0 1953088656 10611536 6325712
00:26:15 41122 8192000000 10871949456 11361361920 1923966560 19.019 98 3 6 1 1934317264 9616096 734608
00:27:02 55147 8192000000 10908166720 11394195456 1979072256 19.457 100 10 20 2 1993299120 11508320 2718544
00:28:04 30789 8192000000 10910838432 11384279040 1947327648 19.205 98 13 24 2 1962648592 12059808 3261136
00:28:41 70876 8192000000 10890558160 11368312832 1894062592 18.779 95 22 44 2 1918190912 17052720 7075600
00:30:02 38729 8192000000 10900612288 11381374976 1948527440 19.215 99 7 14 1 1964464496 13600816 2336240
00:30:49 37532 8192000000 10880339280 11347431424 1899216256 18.820 96 27 54 1 1917658560 11289440 7152864
00:31:34 24911 8192000000 10912214976 11377643520 1970202000 19.387 100 29 58 1 1993495840 14765280 8528560
00:32:07 25958 8192000000 10905464176 11368423424 1950561904 19.231 99 25 50 0 1968525056 10884576 7078576
00:32:46 27569 8192000000 10909641040 11370639360 1948017632 19.211 99 47 94 0 1973335904 12378896 12939376
00:33:23 49774 8192000000 10889174848 11362340864 1890811552 18.752 96 36 72 1 1916339104 15416976 10110576
00:34:21 9778 8192000000 10909347936 11341074432 1915689888 18.952 98 65 130 3 1942603872 8146720 18767264
00:34:39 31969 8192000000 10887174640 11340496896 1886798432 18.720 97 34 69 2 1906534464 9913536 9822496
00:35:21 77524 8192000000 10868817120 11348447232 1888026640 18.730 97 27 54 1 1908162608 12526992 7608976
00:36:45 79064 8192000000 10855826512 11313369088 1744207952 17.554 90 17 34 2 1759966544 10655232 5103360
00:38:14 80966 8192000000 10854211968 11317174272 1897358496 18.805 99 19 38 0 1918349008 15540640 5449872
00:39:45 12045 8192000000 10894195296 11331067904 1917002496 18.963 99 60 120 0 1943525696 9311040 17212160
00:40:10 23721 8192000000 10873768432 11324067840 1899885616 18.825 98 45 90 0 1923453840 11441328 12126896
00:40:41 140365 8192000000 10871116064 11340673024 1901279616 18.837 98 42 84 3 1922940928 10095664 11565648
00:43:12 54092 8192000000 10840403616 11321786368 1904073264 18.859 99 16 32 1 1931257296 21881296 5302736
00:44:13 29124 8192000000 10831568544 11313942528 1887230288 18.723 99 4 8 0 1909184656 20779696 1174672
00:44:54 4893 8192000000 10832309552 11299151872 1887274768 18.724 99 30 59 4 1906764944 10356480 9133696
00:45:34 47339 8192000000 10843123904 11318767616 1920613584 18.992 100 11 22 0 1935559600 11318464 3627552
00:46:28 39042 8192000000 10843469088 11315302400 1906065856 18.875 99 15 30 0 1921108080 10641072 4401152
00:47:19 57352 8192000000 10879845408 11327000576 1895085760 18.787 98 17 31 2 1910328464 10099232 5143472
00:48:23 72742 8192000000 10854163392 11330215936 1895532128 18.790 98 8 16 1 1907855888 10042992 2280768
00:49:56 60847 8192000000 10854576480 11319578624 1875084784 18.625 97 12 24 3 1888286944 10101408 3100752
00:51:04 53040 8192000000 10865380096 11327795200 1882790336 18.688 97 24 48 1 1902926480 12793696 7342448
00:52:03 38526 8192000000 10886982560 11347980288 1939904576 19.146 100 36 70 1 1968894640 18420000 10570064
00:52:48 91478 8192000000 10875597600 11368996864 1905666128 18.872 98 18 36 0 1935261600 23750496 5844976
00:54:33 51876 8192000000 10876929808 11355131904 1923701760 19.016 99 12 24 0 1946578592 19280144 3596688
00:55:38 96483 8192000000 10892916032 11356389376 1940145040 19.148 99 25 48 3 1955813696 9038080 6630576
00:57:22 16209 8192000000 10911012272 11373391872 1971700880 19.399 100 25 50 0 1988757056 10283104 6773072
00:57:51 55342 8192000000 10895340000 11372490752 1930892640 19.074 98 24 48 1 1953470608 16337776 6240192
00:58:57 49905 8192000000 10891288864 11348815872 1911495392 18.919 97 20 40 0 1926576176 9891536 5189248
00:59:54 46232 8192000000 10907106064 11372175360 1945898832 19.194 99 21 42 2 1962088048 10633072 5556144
01:00:46 85319 8192000000 10883197376 11362213888 1929058640 19.059 98 9 18 0 1944679312 13245136 2375536
01:02:17 72077 8192000000 10890678304 11355848704 1948482560 19.214 99 29 58 0 1964720288 7717184 8520544
01:03:36 44251 8192000000 10881542544 11360317440 1948226912 19.212 99 30 60 0 1966984256 10303072 8454272
01:05:25 49079 8192000000 10879542496 11363528704 1902585040 18.847 97 6 12 1 1911916048 7702304 1628704
01:06:21 12792 8192000000 10884605568 11367759872 1956905584 19.281 100 6 12 0 1970693952 12188800 1599568
01:07:44 126526 8192000000 10884402288 11374096384 1944960128 19.186 99 16 32 0 1963065936 14087792 4018016
01:10:07 47095 8192000000 10904767760 11361587200 1923981472 19.019 98 16 32 0 1935867424 7320480 4565472
01:11:11 35731 8192000000 10887600000 11353116672 1945023552 19.187 99 30 60 2 1962268576 9382192 7862832
01:11:53 78743 8192000000 10840983424 11316383744 1833708256 18.290 94 20 41 1 1848322560 9454880 5159424
01:13:32 24203 8192000000 10863678016 11336728576 1932416112 19.086 100 20 40 3 1944890448 6691120 5783216
01:14:03 62321 8192000000 10872292912 11338485760 1889497008 18.742 97 27 53 2 1905462208 8644384 7320816
01:15:36 62690 8192000000 10863385536 11333959680 1886079136 18.714 97 11 22 1 1904970016 16122992 2767888
01:16:53 64951 8192000000 10868532736 11332349952 1872074192 18.601 96 26 52 1 1889359312 10256992 7028128
01:18:09 93489 8192000000 10838364688 11302993920 1763857536 17.716 91 11 22 4 1778798496 12113488 2827472
01:19:53 43685 8192000000 10840485776 11299110912 1816697600 18.151 95 24 48 0 1831333696 7922864 6713232
01:20:44 80050 8192000000 10836667456 11317182464 1899409280 18.822 99 13 26 0 1913003024 10364080 3229664
01:22:23 46097 8192000000 10844949376 11304787968 1887535696 18.726 98 25 49 2 1900206880 5698464 6972720
01:23:20 49919 8192000000 10862132752 11322085376 1889668240 18.743 98 26 51 3 1907456640 11039248 6749152
01:24:16 56970 8192000000 10858011264 11335712768 1926451520 19.038 100 19 38 1 1949226224 17197216 5577488
01:25:20 12275 8192000000 10817222752 11284455424 1869010896 18.576 98 28 56 0 1888430688 11522624 7897168
01:25:40 37739 8192000000 10829065824 11306184704 1908275392 18.893 100 18 36 2 1930678048 15852240 6550416

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 15-02-2021 01:29:23 to 15-02-2021 01:29:55.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 78 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

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

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          246563
MON$OLDEST_ACTIVE               248097
MON$OLDEST_SNAPSHOT             248097
MON$NEXT_TRANSACTION            248097
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                       2054752
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:401: 
:402: mscs-test-161.budzdorov.ru    Mon Feb 15 01:27:35 2021
:403:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:404: 
:405: 
:406: mscs-test-161.budzdorov.ru    Mon Feb 15 01:27:35 2021
:407:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:408: 
--- end of diff output ---

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

15.02.21 01:29:58. 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-02-15 01:30:01 No severe PSQL-related problems occured
15.02.21 01:30:02. End of report.