Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 31.01.2021 01:29
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 17021428 kB
MemAvailable 31272844 kB
Buffers 0 kB
Cached 14694604 kB
SwapCached 4868 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-31 01:27:15
DTS_END                         2021-01-31 01:27:15.6500
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/46516
TRN_ID                          247537
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: 9222.93 20804 1106752
customer order: creation 184.63 360 22156
customer order: refuse 15.88 354 1906
order to supplier: creation 48.78 1266 5853
order to supplier: removal 3.51 105093 421
invoice (draft): creation 48.38 3134 5806
invoice (draft): removal 52.36 720 6283
invoice accept: apply 42.08 17067 5050
invoice accept: cancel 46.80 825 5616
customer reserve: creation 3909.37 168 469124
customer reserve: removal 4561.87 64 547424
realization accept: apply 89.62 162 10754
realization accept: cancel 79.88 105 9585
payment from customer: creation 63.39 98 7607
payment from customer: removal 6.45 76 774
payment to supplier: creation 53.37 116 6404
payment to supplier: removal 3.51 70 421
service: total inventory turnovers 5.13 1002 615
service: total monetary turnovers 6.95 34 834
service: aggregate perf. data 0.96 18531 115
service: refresh index statistics 0.03 266830 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 31-01-2021 01:29:33 to 31-01-2021 01:29:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3360
TEST_TIME 2 5051
TEST_TIME 3 4902
TEST_TIME 4 5589
TEST_TIME 5 5949
TEST_TIME 6 5583
TEST_TIME 7 5179
TEST_TIME 8 5090
TEST_TIME 9 5262
TEST_TIME 10 5139
TEST_TIME 11 5912
TEST_TIME 12 6029
TEST_TIME 13 6227
TEST_TIME 14 6222
TEST_TIME 15 6511
TEST_TIME 16 6869
TEST_TIME 17 6853
TEST_TIME 18 7076
TEST_TIME 19 7407
TEST_TIME 20 7670
TEST_TIME 21 8179
TEST_TIME 22 8538
TEST_TIME 23 9048
TEST_TIME 24 9322
TEST_TIME 25 9203
TEST_TIME 26 10121
TEST_TIME 27 10578
TEST_TIME 28 10422
TEST_TIME 29 10670
TEST_TIME 30 10526
TEST_TIME 31 10408
TEST_TIME 32 10358
TEST_TIME 33 10460
TEST_TIME 34 10276
TEST_TIME 35 10287
TEST_TIME 36 10287
TEST_TIME 37 10157
TEST_TIME 38 10000
TEST_TIME 39 9831
TEST_TIME 40 9732
TEST_TIME 41 9713
TEST_TIME 42 9680
TEST_TIME 43 9637
TEST_TIME 44 9546
TEST_TIME 45 9496
TEST_TIME 46 9529
TEST_TIME 47 9598
TEST_TIME 48 9575
TEST_TIME 49 9667
TEST_TIME 50 9758
TEST_TIME 51 9702
TEST_TIME 52 9695
TEST_TIME 53 9651
TEST_TIME 54 9647
TEST_TIME 55 9629
TEST_TIME 56 9669
TEST_TIME 57 9803
TEST_TIME 58 9785
TEST_TIME 59 9749
TEST_TIME 60 9674
TEST_TIME 61 9841
TEST_TIME 62 9840
TEST_TIME 63 9873
TEST_TIME 64 9893
TEST_TIME 65 9782
TEST_TIME 66 9697
TEST_TIME 67 9681
TEST_TIME 68 9646
TEST_TIME 69 9562
TEST_TIME 70 9624
TEST_TIME 71 9578
TEST_TIME 72 9536
TEST_TIME 73 9479
TEST_TIME 74 9445
TEST_TIME 75 9420
TEST_TIME 76 9426
TEST_TIME 77 9359
TEST_TIME 78 9404
TEST_TIME 79 9368
TEST_TIME 80 9446
TEST_TIME 81 9467
TEST_TIME 82 9474
TEST_TIME 83 9461
TEST_TIME 84 9502
TEST_TIME 85 9474
TEST_TIME 86 9447
TEST_TIME 87 9552
TEST_TIME 88 9523
TEST_TIME 89 9606
TEST_TIME 90 9568
TEST_TIME 91 9483
TEST_TIME 92 9414
TEST_TIME 93 9451
TEST_TIME 94 9423
TEST_TIME 95 9370
TEST_TIME 96 9360
TEST_TIME 97 9324
TEST_TIME 98 9326
TEST_TIME 99 9371
TEST_TIME 100 9335
TEST_TIME 101 9392
TEST_TIME 102 9352
TEST_TIME 103 9400
TEST_TIME 104 9376
TEST_TIME 105 9347
TEST_TIME 106 9417
TEST_TIME 107 9393
TEST_TIME 108 9484
TEST_TIME 109 9483
TEST_TIME 110 9529
TEST_TIME 111 9458
TEST_TIME 112 9407
TEST_TIME 113 9417
TEST_TIME 114 9355
TEST_TIME 115 9371
TEST_TIME 116 9342
TEST_TIME 117 9319
TEST_TIME 118 9285
TEST_TIME 119 9293
TEST_TIME 120 9224

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 31-01-2021 01:29:36 to 31-01-2021 01:29:40.

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 1543861 1543861 0 0.00 0 23544 6 0 0
doc_list_biud 1543860 1543860 0 0.00 0 56928 28 0 0
sp_add_invoice_to_stock 5239 5050 189 3.60 34 178371 17068 0 189
sp_cancel_adding_invoice 5616 5616 0 0.00 5 66100 825 0 0
sp_cancel_client_order 1906 1906 0 0.00 4 24916 355 0 0
sp_cancel_customer_reserve 547424 547424 0 0.00 1 64068 65 0 0
sp_cancel_pay_from_customer 774 774 0 0.00 3 3136 77 0 0
sp_cancel_pay_to_supplier 421 421 0 0.00 2 4954 71 0 0
sp_cancel_supplier_invoice 6295 6283 12 0.19 2 11437 720 0 12
sp_cancel_supplier_order 421 421 0 0.00 9 1057572 105094 0 0
sp_cancel_write_off 9585 9585 0 0.00 1 12658 105 0 0
sp_client_order 22156 22156 0 0.00 3 27412 361 0 0
sp_customer_reserve 469124 469124 0 0.00 0 149997 168 0 0
sp_fill_shopping_cart 33789 33789 0 0.00 1 10232 34 0 0
sp_fill_shopping_cart_clo_res 469119 469119 0 0.00 0 22021 13 0 0
sp_get_clo_for_invoice 5045 5045 0 0.00 0 31436 304 0 0
sp_kill_cost_storno 16396 16396 0 0.00 0 3810 51 0 0
sp_kill_qstorno_ret_qs2qd 1111137 1111137 0 0.00 0 56925 34 0 0
sp_kill_qty_storno 587034 587034 0 0.00 0 56927 74 0 0
sp_lock_selected_doc 21977 21977 0 0.00 0 6468 4 0 0
sp_make_cost_storno 29810 29810 0 0.00 0 23532 52 0 0
sp_multiply_rows_for_pdistr 29810 29810 0 0.00 0 8318 24 0 0
sp_multiply_rows_for_qdistr 22156 22156 0 0.00 0 20295 158 0 0
sp_pay_from_customer 7607 7607 0 0.00 4 14704 98 0 0
sp_pay_to_supplier 6404 6404 0 0.00 5 22501 117 0 0
sp_payment_common 14011 14011 0 0.00 1 6951 22 0 0
sp_qd_handle_on_cancel_clo 1906 1906 0 0.00 0 24910 327 0 0
sp_qd_handle_on_invoice_upd_sts 10661 10661 0 0.00 0 25619 320 0 0
sp_qd_handle_on_reserve_upd_sts 10754 10754 0 0.00 0 24580 58 0 0
sp_reserve_write_off 10754 10754 0 0.00 6 24657 162 0 0
sp_supplier_invoice 5806 5806 0 0.00 8 88856 3135 0 0
sp_supplier_order 5853 5853 0 0.00 5 35912 1266 0 0
srv_aggregate_perf_data 115 115 0 0.00 2372 321394 18531 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1719 230136 34635 0 0
srv_find_qd_qs_mism 1057855 1057855 0 0.00 0 23355 5 0 0
srv_make_invnt_saldo 615 615 0 0.00 32 38089 1003 0 0
srv_make_money_saldo 834 834 0 0.00 1 10976 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 156703 398489 266830 0 0
t$perf-abend:sp_add_invoice_to_stock 189 189 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5050 5050 0 0.00 0 5672 143 0 0
t$perf-norm:sp_cancel_adding_invoice 419 419 0 0.00 0 2400 62 0 0
t$perf-norm:sp_cancel_client_order 1906 1906 0 0.00 0 1824 9 0 0
t$perf-norm:sp_cancel_customer_reserve 745 745 0 0.00 0 591 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 774 774 0 0.00 0 855 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 421 421 0 0.00 0 2605 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 413 413 0 0.00 0 4153 27 0 0
t$perf-norm:sp_cancel_supplier_order 421 421 0 0.00 0 16387 1576 0 0
t$perf-norm:sp_cancel_write_off 1079 1079 0 0.00 0 8495 18 0 0
t$perf-norm:sp_client_order 22157 22157 0 0.00 0 15419 16 0 0
t$perf-norm:sp_customer_reserve 1048 1048 0 0.00 0 1726 6 0 0
t$perf-norm:sp_pay_from_customer 7607 7607 0 0.00 0 5218 8 0 0
t$perf-norm:sp_pay_to_supplier 6406 6406 0 0.00 0 15392 9 0 0
t$perf-norm:sp_reserve_write_off 10755 10755 0 0.00 0 4338 9 0 0
t$perf-norm:sp_supplier_invoice 5806 5806 0 0.00 0 5335 13 0 0
t$perf-norm:sp_supplier_order 5853 5853 0 0.00 0 9006 17 0 0
t$perf-norm:srv_aggregate_perf_data 115 115 0 0.00 0 464 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 1952 22 0 0
t$perf-norm:srv_make_invnt_saldo 615 615 0 0.00 0 4002 28 0 0
t$perf-norm:srv_make_money_saldo 834 834 0 0.00 0 800 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 14 5 0 0
v_add_invoice_to_stock 10468 10090 378 3.61 0 9176 17 0 378
v_all_customers 40106 40106 0 0.00 0 17 1 0 0
v_all_suppliers 32814 32814 0 0.00 0 66 1 0 0
v_all_wares 44294 44294 0 0.00 0 56 1 0 0
v_cancel_adding_invoice 838 838 0 0.00 0 883 7 0 0
v_cancel_client_order 3812 3812 0 0.00 0 2790 6 0 0
v_cancel_customer_prepayment 1548 1548 0 0.00 0 3090 9 0 0
v_cancel_customer_reserve 1490 1490 0 0.00 0 1642 7 0 0
v_cancel_payment_to_supplier 842 842 0 0.00 0 4934 13 0 0
v_cancel_supplier_invoice 850 826 24 2.82 0 1593 18 0 24
v_cancel_supplier_order 842 842 0 0.00 0 2132 10 0 0
v_cancel_write_off 2158 2158 0 0.00 0 1132 12 0 0
v_max_id_clo_ord 5847 5847 0 0.00 0 853 1 0 0
v_max_id_clo_res 1048 1048 0 0.00 0 1432 9 0 0
v_max_id_ord_sup 5795 5795 0 0.00 0 5531 7 0 0
v_max_non_paid_invoice 1639 1639 0 0.00 0 841 3 0 0
v_max_non_paid_realizn 4191 4191 0 0.00 0 1231 3 0 0
v_min_id_clo_ord 5847 5847 0 0.00 0 4030 7 0 0
v_min_id_clo_res 1048 1048 0 0.00 0 5674 7 0 0
v_min_id_ord_sup 5795 5795 0 0.00 0 7624 8 0 0
v_min_non_paid_invoice 6404 6404 0 0.00 0 4057 11 0 0
v_min_non_paid_realizn 7607 7607 0 0.00 0 4417 13 0 0
v_our_firm 11020 11020 0 0.00 0 14 1 0 0
v_reserve_write_off 21508 21508 0 0.00 0 3642 6 0 0
x_lock_depdocs_on_canc_invoice 11486 11486 0 0.00 0 20488 129 0 0
x_lock_depdocs_on_canc_sup_ord 421 421 0 0.00 0 20332 358 0 0
x_make_qstorno_1000_1200 5853 5853 0 0.00 2 35899 1191 0 0
x_make_qstorno_1200_2000 5806 5806 0 0.00 3 88783 3011 0 0
x_make_qstorno_2100_3300 469124 469124 0 0.00 0 149995 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 31-01-2021 01:29:41 to 31-01-2021 01:29:45.

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:19 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:25 14796 8192000000 10191732160 10507952128 818661344 9.085 65 46 94 0 835700944 2110400 14929200
22:57:50 38275 8192000000 10353320448 10674044928 1394815760 14.549 100 87 173 1 1427947248 4827328 28304160
22:58:43 31667 8192000000 10397920624 10721923072 1446995136 15.011 100 91 182 1 1483423872 6723648 29705088
22:59:25 30988 8192000000 10428264848 10756841472 1479247760 15.295 100 93 185 0 1517158832 7876016 30035056
23:00:12 23775 8192000000 10446888672 10779918336 1497312544 15.453 100 89 178 0 1534824384 9000112 28511728
23:00:53 22196 8192000000 10466403712 10802851840 1518877904 15.640 100 88 176 1 1556264912 9480912 27906096
23:01:23 15897 8192000000 10484829632 10826633216 1534304496 15.774 100 86 172 1 1571441520 10188080 26948944
23:01:49 14860 8192000000 10508928416 10858614784 1557959648 15.979 100 83 167 0 1594258992 10175312 26124032
23:02:14 13113 8192000000 10533837600 10888790016 1596994848 16.314 100 83 167 1 1632666032 10861360 24809824
23:02:37 19245 8192000000 10560611808 10917847040 1614391216 16.462 100 78 156 0 1648979952 11033264 23555472
23:03:07 12085 8192000000 10577636640 10940387328 1637238320 16.656 100 80 161 1 1672612176 12131088 23242768
23:03:27 11352 8192000000 10605550384 10968121344 1657174192 16.825 100 79 157 2 1692313184 12327328 22811664
23:03:46 10751 8192000000 10617922736 10987106304 1678054176 17.001 100 82 164 0 1715168432 13857808 23256448
23:04:06 6165 8192000000 10634928464 11007660032 1693986736 17.135 100 73 146 3 1728394304 13401728 21005840
23:04:20 8645 8192000000 10661014032 11034390528 1724738864 17.392 100 84 167 1 1761626368 13223872 23663632
23:04:36 6792 8192000000 10670257488 11047112704 1729820592 17.434 100 72 145 1 1763245824 13278400 20146832
23:04:50 9173 8192000000 10685398448 11062804480 1744915968 17.559 100 77 152 1 1780571456 13741120 21914368
23:05:06 5685 8192000000 10694859904 11072786432 1753345888 17.629 100 76 151 1 1787631248 12518448 21766912
23:05:19 5383 8192000000 10693906480 11076755456 1762762816 17.707 100 79 157 0 1797547616 12457264 22327536
23:05:32 4357 8192000000 10703121984 11087523840 1770372592 17.770 100 73 146 1 1803785248 12174704 21237952
23:05:43 4409 8192000000 10706926144 11092488192 1771692000 17.781 100 68 136 0 1802826976 11937920 19197056
23:05:55 4743 8192000000 10720458096 11102277632 1778996672 17.841 100 85 170 0 1813937984 11413376 23527936
23:06:08 9542 8192000000 10709930864 11101331456 1782858080 17.873 100 72 145 2 1818338576 15759728 19720768
23:06:24 5142 8192000000 10735193280 11123113984 1789155408 17.925 100 78 156 0 1823875664 12809904 21910352
23:06:36 3843 8192000000 10755367088 11137081344 1811097200 18.105 100 88 175 2 1848939312 13118192 24723920
23:06:47 2496 8192000000 10756217584 11143299072 1815536544 18.141 100 81 158 3 1851754272 13609776 22607952
23:06:57 2020 8192000000 10760547376 11144699904 1817007632 18.153 100 82 164 0 1854309328 13785744 23515952
23:07:06 3518 8192000000 10766385344 11150553088 1825222752 18.220 100 92 182 2 1864245408 13918288 25104368
23:07:16 2388 8192000000 10774841600 11156217856 1829316720 18.254 100 92 181 1 1869369808 14515744 25537344
23:07:24 4400 8192000000 10774534560 11158228992 1829891584 18.258 100 84 168 2 1867823584 14319040 23612960
23:07:35 2564 8192000000 10788955600 11172929536 1837963600 18.324 100 87 175 0 1875856240 13743728 24148912
23:07:44 1659 8192000000 10794198176 11178594304 1847376016 18.401 100 92 183 4 1886758720 14389088 24993616
23:07:52 1774 8192000000 10794290784 11180879872 1852562000 18.443 100 82 165 1 1888467760 13363136 22542624
23:08:01 3435 8192000000 10794470560 11186077696 1853129104 18.448 100 86 171 1 1891150976 13374688 24647184
23:08:10 1490 8192000000 10803432528 11193049088 1861770144 18.518 100 91 179 0 1900413728 13640544 25003040
23:08:19 2029 8192000000 10807775632 11194548224 1862366384 18.522 100 91 182 0 1901496640 13406016 25724240
23:08:27 2057 8192000000 10805498928 11193176064 1863273392 18.530 100 92 185 1 1904031424 14448480 26309552
23:08:36 1628 8192000000 10812681376 11200684032 1867560560 18.565 100 94 188 1 1908413728 14515936 26337232
23:08:44 2970 8192000000 10812232944 11202674688 1869253376 18.578 100 88 177 1 1908137392 13479360 25404656
23:08:53 1888 8192000000 10813185728 11204497408 1874111328 18.618 100 95 193 2 1914591408 12973360 27506720
23:09:02 5760 8192000000 10795226256 11202396160 1869061136 18.577 100 72 142 0 1900637344 11272480 20303728
23:09:15 21935 8192000000 10783664656 11198238720 1863871728 18.535 100 39 77 2 1882363120 7302240 11189152
23:09:44 10373 8192000000 10795742032 11211702272 1872852144 18.607 100 54 109 1 1897800816 10168064 14780608
23:10:04 17187 8192000000 10829685312 11222020096 1882185696 18.683 100 73 144 3 1912865280 10145872 20533712
23:10:27 1972 8192000000 10822785904 11228446720 1889443008 18.741 100 81 163 1 1925975360 12008672 24523680
23:10:52 10310 8192000000 10789334864 11214835712 1880392672 18.668 100 27 54 0 1893770112 6014544 7362896
23:11:12 3726 8192000000 10804912016 11226329088 1885843536 18.712 100 51 102 3 1909010432 8747360 14419536
23:11:24 3225 8192000000 10812811184 11228925952 1887606480 18.726 100 60 120 1 1913086992 8738912 16741600
23:11:35 3007 8192000000 10805660240 11224616960 1885803024 18.712 100 40 80 2 1905598592 8640128 11155440
23:11:45 6391 8192000000 10812613072 11232296960 1888261504 18.732 100 30 60 1 1903639680 7307744 8070432
23:11:58 2120 8192000000 10815687280 11234349056 1892187136 18.763 100 41 82 2 1912640960 8788352 11665472
23:12:07 5002 8192000000 10812797296 11235815424 1894038384 18.778 100 33 67 3 1909758848 6164768 9555696
23:12:19 7664 8192000000 10794206768 11231244288 1891508032 18.758 100 19 38 0 1903562688 6715200 5339456
23:12:33 10488 8192000000 10804866208 11232616448 1892704272 18.768 100 17 34 1 1903323408 5332752 5286384
23:12:52 10967 8192000000 10814885152 11236200448 1896716512 18.800 100 31 62 2 1912653536 7230432 8706592
23:13:10 5882 8192000000 10802602432 11236929536 1896346176 18.797 100 22 45 2 1908827568 6222448 6258944
23:13:22 5519 8192000000 10813465616 11239657472 1898228304 18.812 100 26 53 0 1911267376 5524688 7514384
23:13:36 10995 8192000000 10805653776 11240189952 1899666976 18.824 100 17 34 3 1911953680 6349776 5936928
23:13:57 15045 8192000000 10816951072 11242467328 1900333856 18.829 100 22 45 1 1912600032 6330544 5935632
23:14:18 20277 8192000000 10819423344 11252080640 1900643344 18.831 100 15 31 2 1910265168 5071920 4549904
23:15:04 27313 8192000000 10873101808 11274280960 1918235424 18.973 100 87 174 1 1951193920 6913008 26045488
23:15:37 8115 8192000000 10823916656 11262058496 1909864944 18.906 100 26 52 0 1924395648 7264496 7266208
23:15:57 5711 8192000000 10826443984 11261898752 1912890080 18.930 100 28 56 0 1927545808 6701136 7954592
23:16:09 3334 8192000000 10832962400 11258810368 1896864976 18.801 99 43 86 3 1915596432 6474352 12257104
23:16:18 2832 8192000000 10843614752 11271593984 1914712880 18.944 100 51 103 0 1941265168 11960768 14591520
23:16:29 7916 8192000000 10828492144 11260690432 1894239696 18.780 99 37 72 3 1911651808 7244240 10167872
23:16:44 6049 8192000000 10806424464 11241119744 1892134528 18.763 99 30 59 3 1906565248 6109744 8320976
23:16:57 4912 8192000000 10813629824 11249188864 1902892640 18.850 100 36 72 0 1919915840 6193904 10829296
23:17:08 7084 8192000000 10811558080 11249704960 1885835264 18.712 99 18 36 0 1896487712 5579392 5073056
23:17:24 14633 8192000000 10791135296 11219947520 1847311008 18.400 97 25 50 1 1861457840 5910800 8236032
23:17:45 41636 8192000000 10794105952 11232628736 1886789360 18.720 100 30 60 1 1901787952 6584816 8413776
23:18:36 13003 8192000000 10793962672 11221942272 1853743040 18.453 98 13 26 1 1862597680 4976656 3877984
23:18:56 3886 8192000000 10767064320 11190784000 1831739440 18.274 98 26 50 2 1844426144 5279936 7406768
23:19:07 4898 8192000000 10754988560 11182137344 1838941488 18.332 99 33 66 0 1855498896 7400448 9156960
23:19:20 5324 8192000000 10723998064 11145166848 1760459264 17.688 95 22 44 0 1771790400 5158208 6172928
23:19:31 5098 8192000000 10713482224 11135565824 1793376544 17.960 98 27 54 1 1811919360 10728464 7814352
23:19:45 9324 8192000000 10727850176 11143168000 1757806720 17.666 96 39 78 3 1775679680 6088592 11784368
23:20:03 5882 8192000000 10730485360 11149578240 1795642032 17.978 99 32 64 1 1812294512 6645440 10007040
23:20:16 11377 8192000000 10731174928 11151929344 1772766368 17.790 96 23 46 0 1784718816 5691216 6261232
23:20:35 6675 8192000000 10708208032 11128352768 1763469328 17.713 97 25 50 1 1776469824 5673760 7326736
23:20:48 7230 8192000000 10725301104 11137863680 1778656224 17.838 98 20 39 1 1789654656 4891600 6106832
23:21:04 11669 8192000000 10696014720 11111858176 1740708560 17.525 97 19 38 0 1751901664 5890544 5302560
23:21:22 6868 8192000000 10714331488 11132383232 1796165296 17.982 100 37 72 3 1812920624 5855968 10899360
23:21:37 46458 8192000000 10702868416 11122491392 1720302976 17.355 95 35 69 0 1735884432 5153808 10427648
23:22:42 18264 8192000000 10701583552 11117608960 1709181392 17.262 95 20 37 2 1719030896 5114464 4735040
23:23:06 8500 8192000000 10722658864 11135307776 1786039936 17.899 99 18 36 0 1796339904 5965008 4334960
23:23:23 5971 8192000000 10734738336 11137802240 1792217520 17.950 99 39 77 2 1810953472 8128560 10607392
23:23:36 6117 8192000000 10717517152 11137978368 1802548896 18.035 100 33 66 1 1818461808 6833600 9079312
23:23:49 7650 8192000000 10735251744 11152793600 1817135968 18.154 100 22 44 0 1829136336 5343344 6657024
23:24:03 7707 8192000000 10753183488 11175424000 1830653376 18.265 100 29 57 3 1844828736 5628048 8547312
23:24:19 9061 8192000000 10747763472 11174297600 1822439136 18.198 99 23 46 2 1835174224 5316800 7418288
23:24:38 7184 8192000000 10763752704 11188408320 1848436320 18.409 100 27 54 2 1863108368 6899696 7772352
23:24:51 10982 8192000000 10769793248 11194228736 1846768832 18.396 100 22 44 1 1858801888 6080352 5952704
23:25:08 6449 8192000000 10770372688 11195154432 1854378112 18.458 100 24 47 1 1871621840 9231872 8011856
23:25:21 14618 8192000000 10770663712 11196182528 1855675360 18.468 100 15 30 0 1865363728 5337360 4351008
23:25:43 10674 8192000000 10778767568 11203489792 1857449664 18.483 100 20 40 2 1868276848 4608224 6218960
23:26:01 8861 8192000000 10774726144 11205787648 1864417824 18.539 100 28 56 2 1877469088 4726416 8324848
23:26:16 10237 8192000000 10779295728 11210665984 1865065728 18.544 100 22 43 1 1876519728 5727856 5726144
23:26:33 18552 8192000000 10773830368 11213090816 1873630976 18.614 100 23 45 2 1885944496 5449040 6864480
23:26:58 98262 8192000000 10821020064 11244101632 1895346336 18.789 100 40 80 1 1913779248 7435024 10997888
23:28:44 5855 8192000000 10848884320 11267022848 1915649680 18.952 100 63 126 1 1943280880 9637984 17993216
23:28:58 6887 8192000000 10863661712 11279302656 1926551984 19.039 100 59 117 0 1952766368 10201136 16013248
23:29:11 15741 8192000000 10850923408 11279716352 1925781056 19.033 100 47 94 0 1949132736 10297792 13053888
23:29:42 26387 8192000000 10862995296 11290300416 1936348320 19.118 100 50 100 0 1961848768 10080464 15419984
23:30:15 23181 8192000000 10873600208 11305635840 1944846528 19.185 100 51 99 0 1969734384 10118112 14769744
23:31:22 19515 8192000000 10906340480 11333160960 1963197824 19.331 100 54 108 2 1992942592 13578976 16165792
23:31:50 18383 8192000000 10891223744 11326976000 1963691264 19.335 100 56 109 1 1998120880 18586368 15843248
23:32:15 37070 8192000000 10886756784 11330002944 1947281504 19.205 99 36 72 2 1975566528 17573376 10711648
23:33:00 35656 8192000000 10900044192 11340242944 1961988944 19.322 100 37 74 0 1988790000 15317216 11483840
23:33:53 27431 8192000000 10910695344 11349958656 1975185040 19.427 100 34 68 0 2002992800 17141952 10665808
23:34:44 19909 8192000000 10928839536 11365068800 1983729648 19.494 100 38 75 1 2017144704 22173872 11241184
23:35:21 16272 8192000000 10933279584 11372359680 1987523200 19.524 100 43 86 0 2022394576 21795760 13075616
23:35:48 16626 8192000000 10949628368 11385077760 1998531312 19.611 100 45 90 0 2036742032 24082208 14128512
23:36:13 18216 8192000000 10954019968 11386605568 2002816752 19.645 100 48 94 0 2042087136 25216784 14053600
23:36:41 4673 8192000000 10940824704 11371192320 1967513568 19.366 98 60 118 3 2011117264 25510688 18093008
23:36:52 9850 8192000000 10951324656 11380535296 1998467200 19.611 100 65 131 1 2043655424 25121136 20067088
23:37:12 2650 8192000000 10959070480 11387047936 1999735680 19.621 100 59 118 1 2044007280 26699536 17572064
23:37:22 8485 8192000000 10965905776 11391574016 2004062992 19.655 100 64 126 0 2051330352 27901536 19365824
23:37:39 24592 8192000000 10973648544 11401998336 2007019584 19.678 100 61 122 0 2057684816 32040560 18624672
23:38:12 8566 8192000000 10935942960 11385593856 1970396912 19.389 98 44 88 2 2014399456 30565696 13436848
23:38:30 14277 8192000000 10940839760 11375910912 1981724128 19.478 99 44 88 0 2020194336 24925136 13545072
23:38:52 6451 8192000000 10952926480 11383369728 1990990528 19.552 100 61 119 0 2043705600 35370272 17344800
23:39:06 4008 8192000000 10965742224 11395837952 2003906176 19.654 100 67 135 1 2056523392 32261648 20355568
23:39:17 8008 8192000000 10957203392 11385094144 1997266608 19.601 100 58 116 0 2041323392 26818688 17238096
23:39:35 3522 8192000000 10983967248 11405684736 2009580624 19.698 100 75 150 1 2059772896 28104416 22087856
23:39:46 3753 8192000000 10980024960 11408748544 2016607632 19.753 100 69 138 0 2066553792 29255808 20690352
23:39:57 5088 8192000000 10974467888 11399766016 2009668640 19.699 100 67 130 1 2058968816 29340160 19960016
23:40:19 8788 8192000000 10966471488 11397390336 1991848528 19.558 99 59 118 1 2039198768 29580880 17769360
23:40:35 2310 8192000000 10971087024 11400138752 2008806176 19.692 100 62 124 2 2058851088 30604320 19440592
23:40:46 3649 8192000000 10989920336 11409338368 2019596928 19.777 100 67 133 2 2067866672 29157728 19112016
23:40:57 3792 8192000000 10993550560 11412512768 2018499984 19.768 100 75 149 2 2071523184 31128304 21894896
23:41:08 2557 8192000000 11000726688 11421249536 2024029488 19.812 100 89 178 1 2082808080 32408368 26370224
23:41:18 2185 8192000000 10993369248 11415072768 2008305968 19.688 99 82 164 4 2067007520 33377344 25324208
23:41:28 8010 8192000000 10984556320 11412844544 2003850432 19.653 99 79 157 1 2061344272 33404176 24089664
23:41:45 3596 8192000000 10993334080 11414749184 2016632176 19.754 100 79 158 0 2075807536 34931952 24243408
23:41:56 6262 8192000000 11000553840 11424944128 2019800352 19.779 100 75 151 0 2079566112 36127456 23638304
23:42:12 5535 8192000000 11000586464 11424247808 2026096048 19.828 100 77 153 0 2083110656 34052528 22962080
23:42:37 4194 8192000000 11000500144 11430375424 2027888656 19.842 100 73 144 0 2089747376 38500208 23358512
23:42:49 3478 8192000000 11001650464 11431682048 2023818928 19.810 100 74 146 2 2086492768 39959600 22714240
23:43:05 1743 8192000000 11005191664 11430817792 2028646176 19.848 100 77 154 0 2090748624 37853056 24249392
23:43:15 2080 8192000000 10965947376 11381817344 1984991728 19.504 98 73 147 2 2044819616 36475920 23351968
23:43:24 4596 8192000000 10984694848 11411992576 2012615728 19.722 100 69 138 0 2071536208 37560016 21360464
23:43:37 2510 8192000000 11004065984 11418021888 2019207184 19.774 100 85 170 2 2089240976 43022272 27011520
23:43:47 2171 8192000000 10955554432 11374010368 1976549424 19.437 98 75 149 1 2037814944 36959616 24305904
23:43:58 4875 8192000000 10967847136 11386417152 1965186816 19.347 98 85 170 1 2029702720 38029552 26486352
23:44:13 3085 8192000000 10976756976 11390627840 1978704672 19.454 99 80 161 2 2044014864 40401488 24908704
23:44:23 6434 8192000000 10970066592 11394826240 1989644560 19.541 100 74 145 1 2052437104 40010000 22782544
23:44:37 1868 8192000000 10983775072 11404828672 2001986768 19.638 100 83 166 1 2067678064 39779680 25911616
23:44:45 12584 8192000000 10971149328 11397226496 1989438448 19.539 100 61 123 0 2052671488 43553488 19679552
23:45:06 3123 8192000000 10978842976 11399827456 1991483984 19.556 100 69 137 1 2058209440 45171120 21554336
23:45:16 2063 8192000000 10976198944 11388243968 1981300288 19.475 100 83 165 0 2054345584 46846720 26198576
23:45:24 2298 8192000000 10985607072 11395592192 1986452208 19.516 100 92 184 1 2062875456 47895536 28527712
23:45:33 4873 8192000000 10960379168 11375759360 1971771040 19.399 100 79 158 1 2045516000 48731456 25013504
23:45:45 3354 8192000000 10951506640 11362066432 1945310448 19.189 98 87 173 1 2022614016 49740800 27562768
23:45:55 2137 8192000000 10962892240 11372240896 1964786304 19.344 100 83 166 0 2040279600 48983376 26509920
23:46:04 7351 8192000000 10964433856 11383664640 1973278048 19.411 100 78 157 1 2049411776 51366304 24767424
23:46:19 5455 8192000000 10965523584 11393310720 1977172928 19.442 100 83 165 2 2057422128 52932032 27317168
23:46:37 9532 8192000000 10965463536 11397242880 1980833184 19.471 100 66 130 2 2053081504 50488240 21760080
23:47:07 4334 8192000000 10983175200 11409420288 1985803568 19.511 100 71 141 2 2066335712 57072208 23459936
23:47:20 5289 8192000000 10982128432 11411111936 1997091200 19.600 100 67 132 2 2065482880 47641616 20750064
23:47:35 7097 8192000000 10979481136 11403866112 1971638640 19.398 99 70 136 0 2044604592 50217888 22748064
23:47:50 1719 8192000000 10956944736 11379658752 1966229424 19.356 99 83 165 2 2043059920 49881472 26949024
23:47:59 3210 8192000000 10972479984 11391471616 1976254592 19.435 100 81 161 1 2053990848 51593888 26142368
23:48:10 5628 8192000000 10972245216 11397828608 1984474352 19.500 100 68 134 1 2057312688 50345088 22493248
23:48:23 8864 8192000000 10964573440 11409240064 1975863712 19.432 99 60 120 2 2047898112 52319328 19715072
23:48:40 4133 8192000000 10964009440 11400196096 1983886624 19.495 100 52 104 0 2045791664 44187904 17717136
23:48:57 8839 8192000000 10962656368 11406893056 1988468704 19.532 100 53 107 0 2054198864 48001248 17728912
23:49:15 6107 8192000000 10966418560 11405672448 1987011440 19.520 100 54 109 1 2052433264 46836864 18584960
23:49:27 12310 8192000000 10937163744 11380060160 1939506576 19.143 98 41 81 0 1997102944 44030400 13565968
23:49:50 9973 8192000000 10930584528 11375874048 1966356704 19.357 100 41 82 1 2022865728 42838176 13670848
23:50:24 13811 8192000000 10934386384 11379568640 1951412800 19.238 99 45 90 1 2004279184 37749824 15116560
23:51:02 20364 8192000000 10914821584 11363131392 1922571200 19.007 98 26 52 2 1968003472 36479760 8952512
23:52:12 25022 8192000000 10891748416 11351355392 1915387904 18.950 99 20 40 1 1960317968 37707872 7222192
23:52:45 19441 8192000000 10880709856 11333795840 1891282592 18.756 98 20 40 1 1944178960 45419360 7477008
23:53:15 13309 8192000000 10875444800 11342647296 1918963792 18.979 100 23 46 1 1976026688 49027904 8034992
23:53:36 21973 8192000000 10848773872 11317862400 1885038112 18.706 99 15 30 1 1926452016 36227088 5186816
23:54:11 30423 8192000000 10852182656 11324444672 1867378128 18.563 98 11 22 0 1904781792 34053264 3350400
23:54:48 31367 8192000000 10861682144 11322015744 1918045616 18.971 100 11 22 1 1938639296 17212400 3381280
23:55:26 92515 8192000000 10861379888 11338129408 1896495440 18.798 98 29 56 0 1922105664 17538992 8071232
23:57:07 146792 8192000000 10841518160 11291521024 1743154688 17.545 90 10 20 0 1757488576 11857328 2476560
23:59:58 115352 8192000000 10880053392 11340288000 1931663856 19.080 100 13 26 1 1946324304 11397952 3262496
00:02:06 10673 8192000000 10878624864 11307106304 1922233712 19.005 99 53 100 2 1946136272 9700880 14201680
00:02:23 37643 8192000000 10849339648 11287465984 1842922368 18.365 95 16 32 0 1857946640 10764752 4259520
00:03:15 18860 8192000000 10874566896 11308982272 1926722080 19.041 100 27 54 1 1942143472 7356960 8064432
00:03:46 87354 8192000000 10873277120 11323961344 1925088784 19.028 99 24 48 1 1943907296 11293312 7525200
00:05:19 84229 8192000000 10895454576 11331411968 1911427616 18.918 98 37 71 1 1926793840 5735424 9630800
00:06:52 23449 8192000000 10899857392 11339378688 1947376704 19.206 100 47 95 2 1974287600 12335984 14574912
00:07:27 43907 8192000000 10916174160 11347812352 1957277008 19.284 100 51 101 1 1985291120 12944592 15069520
00:08:19 12800 8192000000 10899603296 11351961600 1953430288 19.254 100 22 44 1 1976295616 16530096 6335232
00:08:50 54600 8192000000 10890902528 11350507520 1959293120 19.300 100 20 40 1 1982506656 17058576 6154960
00:10:00 13415 8192000000 10891112464 11359293440 1963929776 19.337 100 18 36 0 1977658848 8040608 5688464
00:10:25 16023 8192000000 10916026224 11383283712 1982655008 19.486 100 21 42 1 2000629344 11597296 6377040
00:10:50 20864 8192000000 10933350128 11395600384 1991918800 19.559 100 25 50 0 2018775200 19264272 7592128
00:11:17 22587 8192000000 10944564688 11397550080 1994723936 19.581 100 30 60 0 2019560448 16105776 8730736
00:11:50 34288 8192000000 10967451792 11407155200 1996804928 19.598 100 41 81 1 2026036352 16893536 12337888
00:12:37 35627 8192000000 10955456784 11406561280 2002503504 19.642 100 47 94 2 2038671264 22304224 13863536
00:13:19 49455 8192000000 10926157408 11404439552 1979000016 19.457 99 31 61 1 2007734512 19980608 8753888
00:14:17 23970 8192000000 10921403312 11413639168 1986112624 19.513 100 14 28 1 2011715984 21165328 4438032
00:14:47 230136 8192000000 10896113008 11361566720 1904135312 18.860 96 11 22 0 1919244400 12330752 2778336
00:18:48 34113 8192000000 10904435040 11373809664 1957015216 19.282 99 30 60 2 1972493648 7511216 7967216
00:19:30 68547 8192000000 10922290400 11386310656 1958327136 19.293 99 10 20 0 1969541456 8729232 2485088
00:20:57 23271 8192000000 10922356416 11386437632 1991758448 19.558 100 46 89 2 2014301344 9628912 12913984
00:21:41 29449 8192000000 10923232752 11374743552 1948296624 19.213 98 40 80 0 1972869904 13472816 11100464
00:22:16 17970 8192000000 10920019920 11380957184 1983438464 19.492 100 39 78 0 2008810016 14410352 10961200
00:22:41 38008 8192000000 10927099808 11393970176 1986840912 19.519 100 25 50 0 2010996928 17085808 7070208
00:23:28 63070 8192000000 10884926000 11356602368 1843732432 18.371 93 20 41 0 1871701648 21771152 6198064
00:24:38 69343 8192000000 10901196048 11360653312 1892070976 18.762 96 15 30 0 1906453968 10198048 4184944
00:25:54 60440 8192000000 10895578512 11339321344 1873981280 18.616 95 23 43 4 1890932864 10639872 6311712
00:27:02 22257 8192000000 10912899776 11363655680 1948088432 19.211 99 39 77 2 1969980736 11225040 10667264
00:27:39 39530 8192000000 10919180256 11379974144 1964454464 19.341 100 23 46 2 1989125200 18287440 6383296
00:28:25 97773 8192000000 10897114784 11350560768 1888320816 18.732 96 17 34 2 1904405600 11287936 4796848
00:30:11 62035 8192000000 10904560096 11366277120 1927253440 19.045 98 19 38 0 1943098016 9958256 5886320
00:31:28 87792 8192000000 10896718464 11363360768 1927136768 19.044 98 25 50 2 1944406224 10228208 7041248
00:33:22 78697 8192000000 10900617360 11374931968 1955573088 19.271 99 22 44 2 1972119168 9948144 6597936
00:34:48 76680 8192000000 10886886336 11364605952 1920057776 18.987 97 15 30 0 1933270432 8657792 4554864
00:36:13 30269 8192000000 10905196544 11344039936 1913167168 18.932 97 35 70 0 1933896624 11069936 9659520
00:36:50 41441 8192000000 10868497376 11346354176 1919910096 18.986 98 26 52 1 1939805904 12086880 7808928
00:37:40 46142 8192000000 10852313104 11326492672 1867337040 18.563 96 8 17 0 1880247888 10465696 2445152
00:38:38 47533 8192000000 10836067632 11299389440 1858248144 18.489 96 11 21 2 1870561808 9546080 2767584
00:39:32 49401 8192000000 10868235616 11336503296 1921198368 18.996 99 22 45 2 1937804560 10056672 6549520
00:40:33 60776 8192000000 10817192416 11291168768 1798473056 18.001 93 13 26 0 1818926432 16673680 3779696
00:41:46 75124 8192000000 10852067392 11318300672 1918511184 18.975 100 19 37 1 1931388976 7610736 5267056
00:43:08 39035 8192000000 10853154576 11328643072 1911975328 18.923 99 18 36 1 1926122528 8684976 5462224
00:44:12 66458 8192000000 10860763968 11341639680 1928006608 19.051 99 4 8 0 1943804784 14675504 1122672
00:45:31 57914 8192000000 10871176016 11333132288 1869551440 18.581 96 15 30 1 1887961584 14375280 4034864
00:46:41 61872 8192000000 10861024496 11326865408 1859387152 18.498 96 14 28 0 1871895632 8916272 3592208
00:47:49 66141 8192000000 10863510592 11330412544 1880717376 18.671 97 23 46 1 1895394416 8643536 6033504
00:49:01 36881 8192000000 10865033904 11328757760 1920211984 18.989 99 23 46 1 1935556432 8602896 6741552
00:49:46 129844 8192000000 10877304272 11355115520 1856970752 18.479 95 17 34 0 1875677856 14003376 4703728
00:52:02 37303 8192000000 10876750112 11324772352 1915799712 18.953 99 27 53 1 1931907024 8507808 7599504
00:52:47 34579 8192000000 10888476640 11345461248 1950287408 19.229 100 40 80 1 1970585840 9134112 11164320
00:53:28 30205 8192000000 10909617488 11367968768 1960914048 19.313 100 35 70 0 1980558480 10177360 9467072
00:54:04 93504 8192000000 10906288304 11383869440 1948107136 19.211 99 11 22 0 1963534080 12745152 2681792
00:55:44 145103 8192000000 10918688608 11387850752 1896624064 18.799 96 20 40 0 1923653552 20841360 6188128
00:58:51 91070 8192000000 10926986720 11384967168 1934913712 19.106 97 27 54 0 1957503712 14364432 8225568
01:00:43 38465 8192000000 10879671520 11363676160 1947476352 19.206 99 10 20 0 1962391808 12264928 2650528
01:01:36 58552 8192000000 10863984768 11335102464 1892583504 18.767 96 13 26 0 1905909232 9268416 4057312
01:02:40 54801 8192000000 10897986912 11373559808 1959921280 19.305 100 9 18 1 1974347856 12191760 2234816
01:03:42 58567 8192000000 10904285712 11382607872 1976177616 19.434 100 8 16 0 1991864000 13468992 2217392
01:04:53 63867 8192000000 10921362224 11400523776 1973241520 19.411 99 24 48 0 1994821200 14191808 7387872
01:06:03 63186 8192000000 10920141424 11385700352 1934377904 19.102 97 16 32 0 1952876544 14116112 4382528
01:07:14 106467 8192000000 10889125472 11367415808 1918676064 18.976 97 16 32 0 1940481520 17176400 4629056
01:09:08 97231 8192000000 10897666480 11377922048 1953611808 19.255 99 13 24 1 1970982496 14235504 3135184
01:11:02 30465 8192000000 10911246064 11363852288 1924765168 19.025 97 33 64 0 1940684208 7037088 8881952
01:11:38 83634 8192000000 10904963936 11365535744 1881163312 18.675 95 28 56 2 1901910288 12647328 8099648
01:13:19 67066 8192000000 10912883488 11388858368 1964996160 19.346 100 9 18 0 1983154288 15446608 2711520
01:14:38 47474 8192000000 10902136304 11370610688 1935822064 19.113 98 29 58 3 1965114032 20653072 8638896
01:15:32 47656 8192000000 10908627984 11374043136 1945174032 19.188 99 19 38 2 1968992816 18761776 5057008
01:16:26 36961 8192000000 10876433360 11331162112 1864227008 18.538 95 13 26 0 1878460416 10799232 3434176
01:17:11 85188 8192000000 10882795392 11368341504 1914613024 18.944 98 8 16 0 1934008080 17450208 1944848
01:18:42 107741 8192000000 10894937392 11369500672 1931335488 19.078 98 13 25 1 1945784768 11208416 3240864
01:20:40 48036 8192000000 10888213056 11374383104 1965760752 19.352 100 14 28 1 1981758720 12008960 3989008
01:21:35 8465 8192000000 10873413344 11326021632 1929387024 19.062 98 30 58 2 1946627536 8936592 8303920
01:21:50 27580 8192000000 10856214720 11318124544 1867943392 18.568 96 38 76 1 1888141920 9605200 10593328
01:22:37 30388 8192000000 10841683696 11316281344 1898001088 18.810 98 13 26 2 1909113776 6726240 4386448
01:23:21 37918 8192000000 10832023856 11309187072 1889918016 18.745 98 6 12 0 1896458032 5183648 1356368
01:24:05 50650 8192000000 10835221392 11306430464 1896236480 18.796 98 10 20 0 1904846608 5937120 2673008
01:25:14 94684 8192000000 10856367024 11332558848 1867337888 18.563 96 14 28 0 1878883584 7706544 3839152
01:26:59 33203 8192000000 9990784208 10379628544 1114282016 11.973 58 3 6 0 1124697808 9996304 419488

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 31-01-2021 01:29:47 to 31-01-2021 01:30:18.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 189 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 31-01-2021 01:30:19 to 31-01-2021 01:30:21.

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          247536
MON$OLDEST_ACTIVE               247771
MON$OLDEST_SNAPSHOT             247771
MON$NEXT_TRANSACTION            247771
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                       2041888
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.33407 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33407 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33407 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33407 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 ---
:61: 
:62: mscs-test-161.budzdorov.ru    Sun Jan 31 01:27:42 2021
:63:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:64: 
:65: 
:66: mscs-test-161.budzdorov.ru    Sun Jan 31 01:27:44 2021
:67:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:68: 
:69: 
:70: mscs-test-161.budzdorov.ru    Sun Jan 31 01:27:47 2021
:71:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:72: 
--- end of diff output ---

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

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