Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.06.2021 22: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 58e1ddde69c44dad93d327777e5becec
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-05-09 08:45
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 4793.92
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 17205480 kB
MemAvailable 31349428 kB
Buffers 0 kB
Cached 14436360 kB
SwapCached 2408 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-06-19 22:27:36
DTS_END                         2021-06-19 22:27:36.5600
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/41536
TRN_ID                          244131
ATT_ID                          600
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: 9380.79 22921 1125695
customer order: creation 175.70 347 21084
customer order: refuse 14.90 332 1788
order to supplier: creation 46.73 1237 5607
order to supplier: removal 3.35 93707 402
invoice (draft): creation 45.34 3265 5441
invoice (draft): removal 52.62 666 6314
invoice accept: apply 43.01 18579 5161
invoice accept: cancel 48.08 732 5769
customer reserve: creation 3929.68 187 471562
customer reserve: removal 4720.70 53 566484
realization accept: apply 85.32 179 10238
realization accept: cancel 83.15 108 9978
payment from customer: creation 60.78 115 7294
payment from customer: removal 5.96 75 715
payment to supplier: creation 48.96 137 5875
payment to supplier: removal 3.69 66 443
service: total inventory turnovers 5.28 977 633
service: total monetary turnovers 6.66 26 799
service: aggregate perf. data 0.87 18043 104
service: refresh index statistics 0.03 319590 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-06-2021 22:28:37 to 19-06-2021 22:28:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3058
TEST_TIME 2 3779
TEST_TIME 3 3417
TEST_TIME 4 3950
TEST_TIME 5 4424
TEST_TIME 6 4566
TEST_TIME 7 4531
TEST_TIME 8 4819
TEST_TIME 9 5223
TEST_TIME 10 5314
TEST_TIME 11 5779
TEST_TIME 12 6227
TEST_TIME 13 6457
TEST_TIME 14 6682
TEST_TIME 15 7320
TEST_TIME 16 7484
TEST_TIME 17 7911
TEST_TIME 18 8036
TEST_TIME 19 8582
TEST_TIME 20 8956
TEST_TIME 21 9100
TEST_TIME 22 9184
TEST_TIME 23 9194
TEST_TIME 24 9852
TEST_TIME 25 10532
TEST_TIME 26 10487
TEST_TIME 27 10406
TEST_TIME 28 10444
TEST_TIME 29 10211
TEST_TIME 30 10054
TEST_TIME 31 10006
TEST_TIME 32 10001
TEST_TIME 33 9892
TEST_TIME 34 9770
TEST_TIME 35 9747
TEST_TIME 36 9745
TEST_TIME 37 9689
TEST_TIME 38 9779
TEST_TIME 39 9744
TEST_TIME 40 9688
TEST_TIME 41 9575
TEST_TIME 42 9452
TEST_TIME 43 9520
TEST_TIME 44 9473
TEST_TIME 45 9433
TEST_TIME 46 9567
TEST_TIME 47 9454
TEST_TIME 48 9435
TEST_TIME 49 9718
TEST_TIME 50 9692
TEST_TIME 51 9642
TEST_TIME 52 9831
TEST_TIME 53 9782
TEST_TIME 54 9850
TEST_TIME 55 9824
TEST_TIME 56 9812
TEST_TIME 57 9742
TEST_TIME 58 9672
TEST_TIME 59 9607
TEST_TIME 60 9546
TEST_TIME 61 9472
TEST_TIME 62 9460
TEST_TIME 63 9500
TEST_TIME 64 9496
TEST_TIME 65 9508
TEST_TIME 66 9431
TEST_TIME 67 9479
TEST_TIME 68 9535
TEST_TIME 69 9543
TEST_TIME 70 9685
TEST_TIME 71 9710
TEST_TIME 72 9720
TEST_TIME 73 9726
TEST_TIME 74 9680
TEST_TIME 75 9720
TEST_TIME 76 9677
TEST_TIME 77 9701
TEST_TIME 78 9788
TEST_TIME 79 9697
TEST_TIME 80 9634
TEST_TIME 81 9572
TEST_TIME 82 9561
TEST_TIME 83 9573
TEST_TIME 84 9525
TEST_TIME 85 9510
TEST_TIME 86 9499
TEST_TIME 87 9414
TEST_TIME 88 9369
TEST_TIME 89 9332
TEST_TIME 90 9342
TEST_TIME 91 9329
TEST_TIME 92 9382
TEST_TIME 93 9356
TEST_TIME 94 9381
TEST_TIME 95 9446
TEST_TIME 96 9484
TEST_TIME 97 9465
TEST_TIME 98 9464
TEST_TIME 99 9448
TEST_TIME 100 9544
TEST_TIME 101 9523
TEST_TIME 102 9574
TEST_TIME 103 9536
TEST_TIME 104 9569
TEST_TIME 105 9584
TEST_TIME 106 9502
TEST_TIME 107 9451
TEST_TIME 108 9395
TEST_TIME 109 9428
TEST_TIME 110 9443
TEST_TIME 111 9415
TEST_TIME 112 9380
TEST_TIME 113 9360
TEST_TIME 114 9298
TEST_TIME 115 9325
TEST_TIME 116 9369
TEST_TIME 117 9406
TEST_TIME 118 9393
TEST_TIME 119 9361
TEST_TIME 120 9382

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 19-06-2021 22:28:41 to 19-06-2021 22:28:44.

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 1562741 1562741 0 0.00 0 15136 7 0 0
doc_list_biud 1562741 1562741 0 0.00 0 39534 24 0 0
sp_add_invoice_to_stock 5307 5161 146 2.75 24 170471 18579 0 146
sp_cancel_adding_invoice 5769 5769 0 0.00 4 69492 732 0 0
sp_cancel_client_order 1788 1788 0 0.00 4 8840 333 0 0
sp_cancel_customer_reserve 566484 566484 0 0.00 1 19372 54 0 0
sp_cancel_pay_from_customer 715 715 0 0.00 3 7881 76 0 0
sp_cancel_pay_to_supplier 443 443 0 0.00 3 2667 67 0 0
sp_cancel_supplier_invoice 6322 6314 8 0.12 1 14222 666 0 8
sp_cancel_supplier_order 402 402 0 0.00 6 879876 93708 0 0
sp_cancel_write_off 9978 9978 0 0.00 1 13975 109 0 0
sp_client_order 21084 21084 0 0.00 3 15177 348 0 0
sp_customer_reserve 471562 471562 0 0.00 0 107802 188 0 0
sp_fill_shopping_cart 32129 32129 0 0.00 1 25185 37 0 0
sp_fill_shopping_cart_clo_res 471561 471561 0 0.00 0 14416 12 0 0
sp_get_clo_for_invoice 5157 5157 0 0.00 0 29393 277 0 0
sp_kill_cost_storno 16905 16905 0 0.00 0 6934 50 0 0
sp_kill_qstorno_ret_qs2qd 1149662 1149662 0 0.00 0 19368 29 0 0
sp_kill_qty_storno 606129 606129 0 0.00 0 39532 62 0 0
sp_lock_selected_doc 21343 21343 0 0.00 0 8577 7 0 0
sp_make_cost_storno 28563 28563 0 0.00 0 13022 59 0 0
sp_multiply_rows_for_pdistr 28563 28563 0 0.00 0 9511 31 0 0
sp_multiply_rows_for_qdistr 21084 21084 0 0.00 0 11349 165 0 0
sp_pay_from_customer 7294 7294 0 0.00 4 13096 115 0 0
sp_pay_to_supplier 5875 5875 0 0.00 5 11481 137 0 0
sp_payment_common 13169 13169 0 0.00 1 13082 33 0 0
sp_qd_handle_on_cancel_clo 1788 1788 0 0.00 0 8191 304 0 0
sp_qd_handle_on_invoice_upd_sts 10925 10925 0 0.00 0 39529 294 0 0
sp_qd_handle_on_reserve_upd_sts 10238 10238 0 0.00 0 13463 51 0 0
sp_reserve_write_off 10238 10238 0 0.00 6 13491 180 0 0
sp_supplier_invoice 5441 5441 0 0.00 5 88626 3265 0 0
sp_supplier_order 5607 5607 0 0.00 5 25213 1238 0 0
srv_aggregate_perf_data 104 104 0 0.00 2718 138940 18044 0 0
srv_fill_mon_cache_memory 151 151 0 0.00 1180 114941 34296 0 0
srv_find_qd_qs_mism 1077273 1077273 0 0.00 0 15135 6 0 0
srv_make_invnt_saldo 633 633 0 0.00 32 72054 977 0 0
srv_make_money_saldo 799 799 0 0.00 1 2100 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 155487 527544 319591 0 0
t$perf-abend:sp_add_invoice_to_stock 146 146 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 5161 5161 0 0.00 0 17858 172 0 0
t$perf-norm:sp_cancel_adding_invoice 424 424 0 0.00 1 12194 99 0 0
t$perf-norm:sp_cancel_client_order 1788 1788 0 0.00 0 4744 13 0 0
t$perf-norm:sp_cancel_customer_reserve 727 727 0 0.00 0 1572 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 715 715 0 0.00 0 4927 26 0 0
t$perf-norm:sp_cancel_pay_to_supplier 443 443 0 0.00 0 4205 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 426 426 0 0.00 0 2582 17 0 0
t$perf-norm:sp_cancel_supplier_order 402 402 0 0.00 0 21486 1532 0 0
t$perf-norm:sp_cancel_write_off 1024 1024 0 0.00 0 7212 12 0 0
t$perf-norm:sp_client_order 21084 21084 0 0.00 0 13695 19 0 0
t$perf-norm:sp_customer_reserve 1053 1053 0 0.00 0 2554 9 0 0
t$perf-norm:sp_pay_from_customer 7294 7294 0 0.00 0 7627 15 0 0
t$perf-norm:sp_pay_to_supplier 5875 5875 0 0.00 0 9403 18 0 0
t$perf-norm:sp_reserve_write_off 10238 10238 0 0.00 0 15229 14 0 0
t$perf-norm:sp_supplier_invoice 5441 5441 0 0.00 0 12022 16 0 0
t$perf-norm:sp_supplier_order 5607 5607 0 0.00 0 10924 18 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 963 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 151 151 0 0.00 0 682 7 0 0
t$perf-norm:srv_make_invnt_saldo 633 633 0 0.00 0 2359 25 0 0
t$perf-norm:srv_make_money_saldo 799 799 0 0.00 0 4059 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 70 27 0 0
v_add_invoice_to_stock 10602 10310 292 2.75 0 7884 19 0 292
v_all_customers 38468 38468 0 0.00 0 19 1 0 0
v_all_suppliers 30048 30048 0 0.00 0 62 1 0 0
v_all_wares 42168 42168 0 0.00 0 41 1 0 0
v_cancel_adding_invoice 848 848 0 0.00 0 1769 10 0 0
v_cancel_client_order 3576 3576 0 0.00 0 1815 4 0 0
v_cancel_customer_prepayment 1430 1430 0 0.00 0 1557 7 0 0
v_cancel_customer_reserve 1454 1454 0 0.00 0 2264 8 0 0
v_cancel_payment_to_supplier 886 886 0 0.00 0 2011 8 0 0
v_cancel_supplier_invoice 868 852 16 1.84 0 382 16 0 16
v_cancel_supplier_order 804 804 0 0.00 0 1968 7 0 0
v_cancel_write_off 2048 2048 0 0.00 0 5528 14 0 0
v_max_id_clo_ord 5606 5606 0 0.00 0 390 1 0 0
v_max_id_clo_res 1053 1053 0 0.00 0 3126 16 0 0
v_max_id_ord_sup 5439 5439 0 0.00 0 1382 2 0 0
v_max_non_paid_invoice 1896 1896 0 0.00 0 5797 7 0 0
v_max_non_paid_realizn 3927 3927 0 0.00 0 1622 4 0 0
v_min_id_clo_ord 5606 5606 0 0.00 0 5407 6 0 0
v_min_id_clo_res 1053 1053 0 0.00 0 4747 22 0 0
v_min_id_ord_sup 5439 5439 0 0.00 0 10004 5 0 0
v_min_non_paid_invoice 5875 5875 0 0.00 0 7170 21 0 0
v_min_non_paid_realizn 7294 7294 0 0.00 0 5996 22 0 0
v_our_firm 10434 10434 0 0.00 0 63 1 0 0
v_reserve_write_off 20476 20476 0 0.00 0 2316 5 0 0
x_lock_depdocs_on_canc_invoice 11657 11657 0 0.00 0 14135 115 0 0
x_lock_depdocs_on_canc_sup_ord 402 402 0 0.00 0 9783 393 0 0
x_make_qstorno_1000_1200 5607 5607 0 0.00 2 22164 1152 0 0
x_make_qstorno_1200_2000 5441 5441 0 0.00 2 88616 3139 0 0
x_make_qstorno_2100_3300 471562 471562 0 0.00 0 107799 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-06-2021 22:28:45 to 19-06-2021 22:28:49.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:40 1 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
19:57:46 14972 8192000000 10218833696 10521776128 854668496 9.447 69 56 113 0 876858272 2464384 19725392
19:58:13 31964 8192000000 10349514960 10664034304 1386344960 14.473 100 80 158 1 1417602752 4726912 26530880
19:58:52 25619 8192000000 10389304144 10709618688 1435001808 14.906 100 87 174 1 1469887168 6328464 28556896
19:59:26 20473 8192000000 10397619216 10723819520 1454572176 15.078 100 91 182 0 1491125648 7011936 29541536
19:59:58 6082 8192000000 10407920736 10731577344 1466455504 15.183 100 92 184 1 1503852208 7507696 29889008
20:00:10 26992 8192000000 10422487760 10752823296 1472609680 15.237 100 85 170 1 1508023168 7669472 27744016
20:00:49 14050 8192000000 10443873312 10776358912 1501001008 15.485 100 91 182 1 1537910752 8138464 28771280
20:01:16 18614 8192000000 10461507120 10798395392 1515245168 15.609 100 85 170 0 1550413168 8676336 26491664
20:01:42 18289 8192000000 10478122160 10822008832 1536935136 15.797 100 87 174 0 1573662000 9433744 27293120
20:02:10 24269 8192000000 10524148384 10872074240 1567238912 16.059 100 81 162 0 1601199200 9784592 24175696
20:02:42 8438 8192000000 10546355008 10900426752 1608843984 16.415 100 85 170 1 1644941200 10663024 25434192
20:02:59 14907 8192000000 10572697744 10927108096 1625878176 16.560 100 79 158 1 1660204064 10993328 23332560
20:03:20 7657 8192000000 10586600016 10948984832 1643677968 16.711 100 77 154 1 1678166432 11606224 22882240
20:03:38 6008 8192000000 10606679056 10970517504 1663521440 16.879 100 82 164 0 1699472336 12213168 23737728
20:03:53 13461 8192000000 10630227952 10998595584 1684901472 17.059 100 77 154 1 1719241568 12384656 21955440
20:04:14 8172 8192000000 10640620672 11009634304 1702111664 17.203 100 85 169 1 1738961312 12378992 24470656
20:04:31 7346 8192000000 10655186576 11023761408 1713046032 17.294 100 81 160 1 1748574352 12792048 22736272
20:04:49 7657 8192000000 10659274160 11035955200 1723448976 17.381 100 81 163 0 1759185184 12717504 23018704
20:05:06 6592 8192000000 10672700576 11046096896 1735126496 17.478 100 86 172 1 1772847456 13923712 23797248
20:05:21 3027 8192000000 10690371488 11063922688 1748945248 17.593 100 92 182 0 1788997536 14038656 26013632
20:05:31 5237 8192000000 10698344288 11074863104 1758753520 17.674 100 86 171 1 1796492832 13840992 23898320
20:05:44 4090 8192000000 10706972272 11085438976 1769026272 17.759 100 84 166 3 1806133856 13266560 23841024
20:05:56 4044 8192000000 10716728016 11094958080 1786584752 17.904 100 89 178 1 1825636304 14606608 24444944
20:06:06 4728 8192000000 10728862512 11109691392 1787465632 17.911 100 87 174 1 1826820128 14329040 25025456
20:06:18 3581 8192000000 10735793984 11116064768 1795490336 17.977 100 82 164 0 1832028256 14011024 22526896
20:06:28 3683 8192000000 10740485344 11125473280 1799068688 18.006 100 85 168 3 1836269664 13394800 23806176
20:06:39 2214 8192000000 10748185440 11128500224 1808843712 18.086 100 93 186 1 1848442304 14107328 25491264
20:06:48 7953 8192000000 10747824496 11139407872 1814193632 18.130 100 94 188 2 1855200880 15327840 25679408
20:07:04 3804 8192000000 10755754240 11143004160 1818352496 18.164 100 86 172 1 1856981728 14706672 23922560
20:07:16 1638 8192000000 10781013520 11164196864 1835197584 18.302 100 95 188 0 1875734368 14047632 26489152
20:07:24 2159 8192000000 10784357216 11170332672 1841916192 18.356 100 91 180 1 1880870320 13870416 25083712
20:07:32 2319 8192000000 10793881360 11178528768 1844602592 18.378 100 87 172 3 1882361072 14209152 23549328
20:07:41 2129 8192000000 10794552288 11177717760 1847147344 18.399 100 95 189 2 1888323040 14981840 26193856
20:07:49 1781 8192000000 10796872944 11182272512 1851586640 18.435 100 97 193 0 1894247104 15861536 26798928
20:07:57 2148 8192000000 10793440672 11183316992 1852835808 18.445 100 92 184 1 1893017520 13976576 26205136
20:08:06 1870 8192000000 10801062192 11185770496 1856816448 18.477 100 99 195 1 1897197296 12987264 27393584
20:08:14 1738 8192000000 10800063584 11188133888 1858351392 18.490 100 89 178 0 1896611584 13034304 25225888
20:08:22 1756 8192000000 10812217232 11200458752 1863584080 18.532 100 94 188 3 1903596672 13750224 26262368
20:08:30 1412 8192000000 10812299104 11201867776 1867114480 18.561 100 94 187 0 1907729648 14286224 26328944
20:08:38 1766 8192000000 10817524640 11205050368 1868168016 18.569 100 96 191 1 1909998704 14051328 27779360
20:08:46 1964 8192000000 10821693888 11209269248 1876097952 18.634 100 97 195 1 1915791872 12695984 26997936
20:08:54 1108 8192000000 10822913504 11213627392 1875537808 18.629 100 94 185 1 1916153712 13975488 26640416
20:09:01 1139 8192000000 10824101520 11214086144 1880414832 18.668 100 88 177 0 1918335152 12630352 25289968
20:09:09 32467 8192000000 10809416608 11209482240 1875405632 18.628 100 57 112 0 1898469648 7077872 15986144
20:09:48 2036 8192000000 10797905952 11213549568 1874494352 18.621 100 57 114 1 1900388224 9145072 16748800
20:09:58 6276 8192000000 10786276736 11209527296 1874460528 18.620 100 36 72 1 1891999648 7198688 10340432
20:10:10 7285 8192000000 10781917456 11213750272 1870753296 18.590 100 18 36 1 1881771888 6126656 4891936
20:10:23 3512 8192000000 10795040528 11215122432 1880358432 18.668 100 49 99 1 1901622160 6961248 14302480
20:10:36 5127 8192000000 10795928576 11215347712 1877764672 18.647 100 40 80 1 1897180464 8461424 10954368
20:10:51 7078 8192000000 10788634464 11224920064 1876855408 18.640 100 25 50 1 1889993840 6133104 7005328
20:11:07 6447 8192000000 10794451232 11219369984 1886277328 18.716 100 33 65 0 1900638672 5017776 9343568
20:11:23 8886 8192000000 10790543392 11224453120 1880545152 18.670 100 27 54 3 1895086256 7368208 7172896
20:11:38 8635 8192000000 10796366336 11225354240 1883888416 18.696 100 17 34 0 1894409968 5609408 4912144
20:11:53 7405 8192000000 10793050832 11226218496 1885933824 18.713 100 21 42 1 1897954960 6275808 5745328
20:12:10 9715 8192000000 10802697840 11231141888 1886607360 18.718 100 15 30 1 1896910688 5946032 4357296
20:12:27 13957 8192000000 10799555760 11236024320 1889674672 18.743 100 15 30 1 1899505488 5930048 3900768
20:12:48 10632 8192000000 10807008880 11240513536 1897517600 18.806 100 14 28 1 1907808112 6545072 3745440
20:13:04 79299 8192000000 10810243104 11242487808 1902389600 18.846 100 23 46 0 1915130896 4945952 7795344
20:14:30 4583 8192000000 10833127328 11260252160 1908101664 18.891 100 46 91 4 1928068640 7752576 12214400
20:14:44 5099 8192000000 10815566160 11253342208 1906939360 18.882 100 26 50 1 1920624352 5783008 7901984
20:14:56 4507 8192000000 10834554032 11259879424 1911766176 18.921 100 45 90 1 1931443936 6678912 12998848
20:15:07 2860 8192000000 10849439408 11268521984 1912662848 18.928 100 32 64 2 1933259072 11838096 8758128
20:15:17 4744 8192000000 10846568496 11272364032 1915128320 18.948 100 40 81 1 1933044080 7002592 10913168
20:15:31 5020 8192000000 10840632384 11273879552 1916499632 18.959 100 33 65 1 1932066752 6519472 9047648
20:15:45 3288 8192000000 10835646896 11263406080 1910661344 18.912 100 32 64 1 1926846464 6935360 9249760
20:15:56 4923 8192000000 10838707600 11267936256 1917328624 18.965 100 34 68 1 1933162976 5346016 10488336
20:16:07 6808 8192000000 10809005824 11247558656 1898301024 18.813 100 25 50 0 1911806864 6045104 7460736
20:16:20 5915 8192000000 10814013376 11255078912 1906291040 18.877 100 23 46 3 1918285552 5390352 6604160
20:16:37 7949 8192000000 10799293408 11239251968 1882443824 18.685 99 15 30 1 1892234656 5698592 4092240
20:16:51 7711 8192000000 10791834048 11225915392 1868880464 18.575 99 20 38 2 1879764720 5690672 5193584
20:17:06 4982 8192000000 10786594896 11217633280 1851278752 18.433 98 27 54 1 1865429856 5852848 8298256
20:17:20 12862 8192000000 10802728320 11237519360 1886377344 18.717 100 13 26 0 1895558704 5307312 3874048
20:17:44 6727 8192000000 10787964192 11218481152 1817501904 18.157 96 17 34 3 1827952672 5886096 4564672
20:17:59 60725 8192000000 10772284128 11210727424 1801786320 18.029 96 15 30 3 1810759088 4783280 4189488
20:19:11 9111 8192000000 10767423408 11188781056 1758885984 17.675 94 31 62 2 1777264240 10408512 7969744
20:19:28 4824 8192000000 10762975936 11181940736 1825501408 18.223 99 42 84 1 1845359120 8012576 11845136
20:19:43 6421 8192000000 10738582528 11152617472 1765651280 17.731 96 31 62 1 1780516080 6492096 8372704
20:19:56 13092 8192000000 10717386720 11141861376 1752245504 17.620 96 33 66 1 1768324704 6743168 9336032
20:20:16 6030 8192000000 10728469696 11153944576 1798850976 18.004 99 31 62 1 1814191872 6209440 9131456
20:20:28 8116 8192000000 10697722096 11116621824 1749129184 17.594 96 19 37 1 1760340848 5691088 5520576
20:20:45 5707 8192000000 10688024848 11095003136 1728951424 17.427 97 27 54 0 1742452960 5571264 7930272
20:20:58 11375 8192000000 10688008688 11112468480 1747092544 17.577 98 14 28 0 1760296976 9489888 3714544
20:21:17 7937 8192000000 10691488256 11116216320 1769079104 17.759 99 28 56 0 1782980880 5442272 8459504
20:21:31 9090 8192000000 10707283200 11129548800 1776915216 17.824 99 16 32 2 1786727936 5537088 4275632
20:21:47 11316 8192000000 10704150304 11125870592 1778872608 17.840 99 32 64 1 1794398816 5667792 9858416
20:22:05 6940 8192000000 10707963040 11127439360 1765333072 17.728 98 31 62 0 1780436128 5463952 9639104
20:22:18 10836 8192000000 10711082320 11135041536 1768658192 17.756 98 21 42 1 1779858944 5189776 6010976
20:22:37 20295 8192000000 10730565344 11160268800 1802995808 18.038 99 24 48 2 1815443984 5295936 7152240
20:23:03 57309 8192000000 10721691472 11149881344 1810688240 18.102 99 26 52 2 1828965712 9948272 8329200
20:24:11 9382 8192000000 10745866912 11178778624 1840758160 18.347 100 21 41 1 1852107584 5564800 5784624
20:24:28 10759 8192000000 10754455376 11179601920 1825707008 18.224 99 23 45 0 1838004720 5792864 6504848
20:24:45 3890 8192000000 10758107648 11185991680 1844315232 18.376 100 24 48 0 1857290928 6258160 6717536
20:24:55 9449 8192000000 10765148704 11192909824 1849660544 18.419 100 24 48 2 1862850304 6236816 6952944
20:25:13 8637 8192000000 10766493072 11198021632 1856881200 18.478 100 20 40 3 1868399296 5345552 6172544
20:25:33 7527 8192000000 10775559392 11204083712 1864203776 18.537 100 33 65 1 1880529632 6451392 9874464
20:25:49 5863 8192000000 10794999984 11214999552 1867553104 18.564 100 24 48 1 1883667696 9539216 6575376
20:26:01 4952 8192000000 10794338608 11215704064 1867477200 18.564 100 26 51 0 1880783328 5732096 7574032
20:26:15 14088 8192000000 10780759072 11216027648 1873204048 18.610 100 19 39 0 1884141808 5368576 5569184
20:26:38 10352 8192000000 10783720928 11219156992 1874641584 18.622 100 11 23 0 1882693760 4868624 3183552
20:26:55 27846 8192000000 10811792304 11238367232 1890261552 18.748 100 15 30 3 1899584848 5468736 3854560
20:27:29 11464 8192000000 10827702496 11252338688 1902187808 18.844 100 18 35 2 1911524720 4942560 4394352
20:27:48 20705 8192000000 10845780368 11268485120 1917454080 18.966 100 53 104 1 1938816176 5947280 15414816
20:28:16 58305 8192000000 10861039008 11288453120 1932679120 19.088 100 51 101 1 1955591488 8107056 14805312
20:29:41 36990 8192000000 10861540528 11298439168 1936287792 19.117 100 37 72 2 1955060944 8435024 10338128
20:30:29 13478 8192000000 10878077056 11309690880 1943801280 19.177 100 39 78 2 1966244848 11387504 11056064
20:30:54 10931 8192000000 10885451472 11311013888 1949039472 19.219 100 52 104 3 1975796816 12517552 14239792
20:31:20 1771 8192000000 10907739168 11327614976 1957197904 19.284 100 70 140 2 1995489072 18047104 20244064
20:31:30 35644 8192000000 10891206944 11315752960 1936593264 19.120 99 48 96 0 1966148272 15397184 14157824
20:32:16 60978 8192000000 10900849744 11338739712 1958345936 19.293 100 41 81 0 1987202896 16704208 12152752
20:33:26 11650 8192000000 10911624544 11343302656 1970701936 19.391 100 55 108 1 2003905248 16888272 16315040
20:33:45 11766 8192000000 10911967424 11345100800 1971898240 19.401 100 47 93 1 2003045968 18054800 13092928
20:34:05 9814 8192000000 10919368496 11355238400 1976129424 19.434 100 45 90 1 2008162000 18838608 13193968
20:34:22 5133 8192000000 10929951120 11360645120 1983261952 19.491 100 60 119 3 2020578864 20064880 17252032
20:34:38 6701 8192000000 10927686928 11359334400 1983241232 19.490 100 49 98 0 2018682832 21121360 14320240
20:34:56 9141 8192000000 10950116352 11378765824 1994745792 19.581 100 58 116 0 2037175824 24717936 17712096
20:35:13 27130 8192000000 10941394464 11383832576 1978845920 19.456 99 59 118 1 2021659264 25702368 17110976
20:35:48 22684 8192000000 10934453936 11376705536 1989736144 19.542 100 45 90 1 2029462432 25549152 14177136
20:36:38 23053 8192000000 10939345808 11380432896 1992133712 19.561 100 42 84 2 2028071392 22853792 13083888
20:37:11 4869 8192000000 10941958880 11386609664 1994001184 19.575 100 38 75 1 2032117600 26614912 11501504
20:37:36 6133 8192000000 10962570384 11390185472 1985960720 19.512 99 53 105 1 2030598064 28740976 15896368
20:37:50 2703 8192000000 10976581744 11399602176 2009656208 19.699 100 84 159 2 2062586352 28812464 24117680
20:38:00 4549 8192000000 10974227552 11404419072 2009790016 19.700 100 71 140 2 2061321408 30592768 20938624
20:38:14 4954 8192000000 10983326560 11410006016 2010664720 19.707 100 64 128 0 2060924592 31277136 18982736
20:38:29 12086 8192000000 10961908576 11392876544 1983321488 19.491 99 64 128 0 2032307424 29089904 19896032
20:38:55 2869 8192000000 10974629920 11401916416 2007343408 19.681 100 73 147 3 2057445840 28965008 21137424
20:39:05 2708 8192000000 10958559984 11391811584 2002131984 19.640 100 66 129 0 2050769888 29642192 18995712
20:39:17 6986 8192000000 10964660800 11398115328 2000852016 19.629 100 60 120 2 2049023104 30533936 17637152
20:39:30 3056 8192000000 10978186304 11405545472 2008836928 19.692 100 67 130 0 2060888480 31922544 20129008
20:39:41 6426 8192000000 10972501744 11402461184 2011575408 19.714 100 73 144 1 2062598624 29625888 21397328
20:39:57 1438 8192000000 10988209728 11414142976 2018778720 19.771 100 90 176 0 2074606384 29760784 26066880
20:40:06 5051 8192000000 10982341728 11406434304 1997358336 19.602 99 72 143 2 2049405536 30729552 21317648
20:40:18 3732 8192000000 10957079120 11392172032 1990015488 19.544 99 69 138 1 2042305344 32032944 20256912
20:40:29 3816 8192000000 10984373648 11405037568 2011369072 19.712 100 81 162 2 2068285520 31993760 24922688
20:40:41 4307 8192000000 10960538880 11395338240 1992068096 19.560 99 67 134 1 2043668816 31634960 19965760
20:40:56 6232 8192000000 10952968944 11382714368 1978614992 19.454 99 70 138 2 2032386096 32758144 21012960
20:41:12 2715 8192000000 10965803600 11384737792 1987757360 19.526 100 74 148 1 2046336848 35987216 22592272
20:41:22 2149 8192000000 10963251168 11386548224 1988662656 19.533 100 86 171 1 2051158912 37120880 25375376
20:41:33 1177 8192000000 10965399968 11378040832 1970234304 19.387 99 88 176 1 2034182000 37312448 26635248
20:41:41 2257 8192000000 10971689312 11389214720 1988899856 19.535 100 80 159 0 2052170464 39344928 23925680
20:41:52 2223 8192000000 10978908400 11399544832 1995449616 19.587 100 84 169 3 2060329536 38983872 25896048
20:42:04 4015 8192000000 10975751840 11392253952 1987250496 19.522 100 89 177 0 2054560400 40251680 27058224
20:42:15 1298 8192000000 10981063984 11394404352 1985697840 19.510 100 94 190 0 2055514144 40622944 29193360
20:42:23 4972 8192000000 10948165824 11376652288 1979040928 19.457 100 60 120 1 2037996368 40250080 18705360
20:42:36 3265 8192000000 10911566288 11326914560 1911502576 18.919 97 75 152 4 1969324704 35162496 22659632
20:42:47 4270 8192000000 10940365120 11358334976 1946194112 19.196 99 81 163 1 2008673984 37732096 24747776
20:43:00 1271 8192000000 10945239568 11359072256 1953350688 19.253 99 88 176 3 2016142768 36940144 25851936
20:43:11 7213 8192000000 10941742848 11367911424 1964164800 19.339 100 68 136 2 2022929248 38291008 20473440
20:43:31 7713 8192000000 10936708304 11353776128 1951432192 19.238 100 68 135 1 2012098320 38580032 22086096
20:43:46 5218 8192000000 10941909552 11363364864 1963451424 19.333 100 78 156 3 2028463632 40699648 24312560
20:43:57 6086 8192000000 10938166672 11358617600 1944691328 19.184 99 63 126 1 2006952720 41670464 20590928
20:44:13 4607 8192000000 10957372160 11376992256 1970840464 19.392 100 75 145 1 2037335872 43781424 22713984
20:44:24 5765 8192000000 10933222656 11343433728 1923817264 19.017 98 81 162 3 1995577472 46059952 25700256
20:44:38 3520 8192000000 10928715392 11340455936 1931634704 19.080 100 83 166 1 2008288592 50657312 25996576
20:44:49 1472 8192000000 10931808288 11349217280 1945468464 19.190 100 85 171 1 2017108336 45489776 26150096
20:44:58 1736 8192000000 10933015296 11345444864 1932213408 19.085 99 79 158 2 2001316416 44457248 24645760
20:45:08 3103 8192000000 10877474768 11280097280 1886800048 18.720 98 80 160 3 1954092400 42976336 24316016
20:45:19 6713 8192000000 10922198288 11330469888 1928712048 19.057 100 81 159 0 1997393472 44220720 24460704
20:45:36 1762 8192000000 10927908112 11330588672 1919715744 18.985 99 84 167 0 1994260496 48706592 25838160
20:45:45 3429 8192000000 10941319184 11350880256 1944100928 19.179 100 85 169 4 2019686464 49544720 26040816
20:45:56 3170 8192000000 10929952000 11357548544 1945125408 19.188 100 67 136 0 2014984816 48086592 21772816
20:46:06 6687 8192000000 10927637296 11360501760 1954921872 19.266 100 60 118 0 2014118512 40906064 18290576
20:46:20 10168 8192000000 10920742272 11359240192 1938849488 19.138 99 36 70 1 1986541312 36347040 11344784
20:46:43 19604 8192000000 10896008176 11331833856 1878080880 18.650 97 36 72 2 1929514656 39178192 12255584
20:47:11 6208 8192000000 10916807568 11345252352 1940036592 19.147 100 57 115 0 1998522832 40633680 17852560
20:47:27 3513 8192000000 10908229984 11342172160 1937908320 19.130 100 52 104 0 1996334592 41783920 16642352
20:47:48 3732 8192000000 10897257664 11325304832 1916428048 18.958 99 56 111 2 1965520944 31548208 17544688
20:48:00 11264 8192000000 10874280704 11317633024 1908158896 18.892 99 42 81 1 1957788000 37072816 12556288
20:48:40 13363 8192000000 10884258624 11327746048 1933207120 19.093 100 29 58 1 1971263024 28230432 9825472
20:49:01 18852 8192000000 10873812288 11318337536 1923222352 19.013 100 31 62 0 1962464928 29368480 9874096
20:49:28 16750 8192000000 10871092192 11322789888 1907195056 18.884 99 29 58 1 1953652368 36993472 9463840
20:49:51 20576 8192000000 10875374912 11320188928 1918043712 18.971 100 27 54 3 1960748432 33480896 9223824
20:50:24 20276 8192000000 10891586944 11335467008 1931243952 19.077 100 34 68 4 1974774912 31839328 11691632
20:50:51 27976 8192000000 10882680592 11332964352 1912547984 18.927 99 19 38 0 1952795216 33382608 6864624
20:51:35 31795 8192000000 10888151600 11350208512 1934502128 19.103 100 19 38 1 1976265488 35313424 6449936
20:52:13 25636 8192000000 10875046256 11332472832 1923833952 19.018 99 16 32 1 1948221312 19124992 5262368
20:52:50 13147 8192000000 10880267344 11340128256 1951884160 19.241 100 29 58 2 1975769648 15169776 8715712
20:53:16 17224 8192000000 10880795504 11346436096 1955418560 19.270 100 10 18 3 1965947520 7868512 2660448
20:53:40 20550 8192000000 10886959824 11345788928 1940055872 19.147 99 16 30 2 1953927952 9158960 4713120
20:54:09 42463 8192000000 10887735312 11343618048 1933239984 19.093 99 28 52 0 1947840704 7583424 7017296
20:54:59 46923 8192000000 10881940640 11342741504 1940468928 19.150 99 21 41 3 1954118592 8497312 5152352
20:56:36 114753 8192000000 10867652160 11321327616 1890717872 18.752 97 31 62 2 1909937808 9925968 9293968
20:58:37 52198 8192000000 10886139104 11339571200 1914015504 18.939 98 32 62 1 1929521744 7101504 8404736
20:59:53 109919 8192000000 10939871584 11369697280 1963881984 19.337 99 66 136 1 1990192016 6969440 19340592
21:01:50 28254 8192000000 10928562960 11373174784 1989962512 19.543 100 53 104 0 2017115376 12147232 15005632
21:02:29 32238 8192000000 10932389264 11374825472 1973263872 19.411 99 47 92 1 1997997536 11623792 13109872
21:03:10 30218 8192000000 10925970224 11374309376 1987304368 19.522 100 37 74 2 2009376464 10725008 11347088
21:03:58 20674 8192000000 10918273040 11383799808 1991167680 19.553 100 25 50 2 2008437568 10435008 6834880
21:04:25 35669 8192000000 10915053424 11378221056 1990876032 19.551 100 18 35 1 2007123712 10566624 5681056
21:05:07 99021 8192000000 10925347280 11394932736 1997511088 19.603 100 21 42 0 2014409504 9997808 6900608
21:06:55 66207 8192000000 10927941232 11401916416 2006152416 19.671 100 14 28 0 2020176096 10155536 3868144
21:08:11 43457 8192000000 10939394976 11409362944 2012797248 19.724 100 21 43 4 2030680512 12182368 5700896
21:09:16 67166 8192000000 10947109472 11413729280 2010588240 19.706 100 12 24 0 2029069696 14760352 3721104
21:10:30 32859 8192000000 10930043024 11419877376 2012757312 19.723 100 14 28 1 2029797520 13274880 3765328
21:11:21 56009 8192000000 10946799008 11436462080 2015282768 19.743 100 14 28 2 2033519808 14312240 3924800
21:12:48 49622 8192000000 10943547584 11422826496 1997558992 19.603 99 24 48 0 2022709760 17431376 7719392
21:13:56 78214 8192000000 10946853520 11412226048 1974917312 19.424 98 17 34 1 2002559424 22826752 4815360
21:15:21 89413 8192000000 10934919472 11407015936 1987338816 19.523 99 22 44 2 2019456400 24521504 7596080
21:17:01 38159 8192000000 10936784384 11395977216 1969712464 19.383 98 19 38 1 1985606496 10584144 5309888
21:17:49 28705 8192000000 10926298800 11389009920 1974216992 19.419 98 40 80 1 1998635008 13400016 11018000
21:18:26 56439 8192000000 10925261040 11394981888 1953756784 19.256 98 23 46 0 1980580656 19943360 6880512
21:20:01 51006 8192000000 10904822816 11366473728 1946036432 19.195 98 28 56 1 1963962352 10854640 7071280
21:21:02 52557 8192000000 10908940032 11380674560 1943818240 19.177 98 23 46 0 1967621408 17371920 6431248
21:22:01 46701 8192000000 10901713632 11359895552 1906503728 18.879 96 32 64 2 1926802480 11006928 9291824
21:22:55 37730 8192000000 10883516496 11336454144 1871558480 18.597 95 28 56 0 1889129120 10026368 7544272
21:23:43 40918 8192000000 10879633952 11331825664 1909213232 18.900 98 36 72 1 1932261568 13148880 9899456
21:24:40 62476 8192000000 10829097840 11300474880 1841932240 18.357 95 29 58 2 1859016688 8885936 8198512
21:25:48 39112 8192000000 10853267408 11302064128 1837851600 18.323 95 27 54 1 1855896800 10461760 7583440
21:26:33 69239 8192000000 10843869184 11308912640 1907299424 18.885 99 27 54 0 1931635136 16636896 7698816
21:27:49 26931 8192000000 10857211424 11305140224 1891874352 18.761 98 20 40 1 1913860048 16539152 5446544
21:28:36 86137 8192000000 10838437296 11310116864 1903773808 18.857 99 14 28 0 1923806496 16092144 3940544
21:30:08 55974 8192000000 10823339616 11296514048 1848478720 18.410 96 13 26 2 1874730272 22121584 4129968
21:31:10 35842 8192000000 10803497696 11280879616 1874813248 18.623 99 9 18 0 1894036640 16629120 2594272
21:32:57 84291 8192000000 10840176112 11300274176 1853600944 18.451 97 24 48 3 1877720160 17292320 6826896
21:34:28 73194 8192000000 10857802512 11329880064 1901430960 18.838 99 18 36 1 1925335504 18457552 5446992
21:35:48 56655 8192000000 10883216400 11345035264 1941500128 19.159 100 23 47 1 1963374016 15439472 6434416
21:36:50 42436 8192000000 10872144976 11341766656 1926493344 19.039 99 20 40 0 1953357200 19759984 7103872
21:38:22 74730 8192000000 10876596976 11337965568 1870266800 18.586 96 21 42 1 1895064592 18676416 6121376
21:39:43 61351 8192000000 10871542720 11338366976 1902457200 18.846 98 25 50 3 1923629136 14343552 6828384
21:40:54 54584 8192000000 10898134496 11350941696 1910323120 18.909 98 42 82 2 1933821728 12291728 11206880
21:41:58 24725 8192000000 10884685440 11335897088 1907029184 18.883 98 38 76 1 1931001840 12574528 11398128
21:42:31 57450 8192000000 10901172672 11347447808 1956153536 19.275 100 40 80 0 1979032432 12055536 10823360
21:43:40 40544 8192000000 10893773024 11349053440 1924924448 19.026 99 40 80 0 1948355344 11621520 11809376
21:44:32 78272 8192000000 10882421536 11367809024 1909764224 18.905 98 23 44 0 1934901472 19186048 5951200
21:45:57 74207 8192000000 10892833104 11357298688 1947650304 19.208 100 15 29 2 1967254624 15228640 4375680
21:47:17 73467 8192000000 10889028144 11357405184 1939607120 19.144 99 17 34 1 1951338800 6913856 4817824
21:48:41 73635 8192000000 10896376720 11374194688 1966796080 19.360 100 29 58 0 1995679312 20682336 8200896
21:50:52 51774 8192000000 10882695632 11362603008 1934806304 19.105 98 20 40 0 1952973936 12761856 5405776
21:51:50 70535 8192000000 10881703936 11373068288 1942942912 19.170 99 7 14 0 1958343312 13714928 1685472
21:53:16 48975 8192000000 10874033616 11359674368 1946364944 19.198 99 11 22 0 1957448624 8292512 2791168
21:54:11 78294 8192000000 10864959936 11350175744 1946687808 19.200 99 14 28 0 1956072144 5795424 3588912
21:57:14 65431 8192000000 10901217104 11392385024 1980511424 19.469 100 11 21 1 1998934656 15471952 2951280
21:58:31 85977 8192000000 10914999984 11405819904 1986801280 19.519 100 9 17 0 2002917968 13672144 2444544
22:00:03 86350 8192000000 10899980688 11388211200 1930013840 19.067 97 17 34 0 1943886352 9179600 4692912
22:01:54 60668 8192000000 10917028384 11380760576 1959594592 19.303 99 36 72 1 1983498336 13568256 10335488
22:03:21 88671 8192000000 10872128336 11338035200 1841295824 18.351 93 11 22 0 1855498576 11222992 2979760
22:04:59 58794 8192000000 10923001232 11389583360 1970800512 19.392 100 41 81 2 1999790400 17257600 11732288
22:07:56 73562 8192000000 10900722192 11375878144 1896532528 18.798 96 23 46 1 1915721680 12869408 6319744
22:09:21 92631 8192000000 10898927760 11364163584 1866811280 18.558 95 6 12 0 1883982864 15865952 1305632
22:11:06 53088 8192000000 10904510448 11385966592 1960808848 19.312 100 15 30 0 1983679424 18709376 4161200
22:12:19 114941 8192000000 10890781488 11356393472 1930567936 19.071 98 13 26 0 1943666992 9654288 3444768
22:14:20 86933 8192000000 10892091712 11353993216 1878516720 18.653 95 36 71 0 1904916624 16147808 10252096
22:15:54 29778 8192000000 10896303008 11364675584 1939200272 19.140 99 32 65 1 1971177008 22020032 9956704
22:16:41 56855 8192000000 10872973536 11354198016 1917074032 18.963 98 9 18 0 1939853136 20287568 2491536
22:18:44 63891 8192000000 10876310592 11354411008 1936124304 19.116 99 10 20 0 1950601296 11594128 2882864
22:20:15 60595 8192000000 10865155712 11334623232 1869758480 18.582 95 12 24 0 1884787936 11575920 3453536
22:21:29 65626 8192000000 10894137184 11372806144 1932706416 19.089 99 13 26 0 1954726240 18049472 3970352
22:22:46 89183 8192000000 10850822912 11348291584 1876486208 18.637 96 14 28 0 1899848640 19018784 4343648
22:24:27 40540 8192000000 10844935760 11308511232 1820798496 18.184 94 22 44 0 1842537040 16269344 5469200
22:25:28 48813 8192000000 10851055184 11315347456 1887480560 18.725 98 36 71 1 1911192944 14087536 9624848
22:26:24 57845 8192000000 10869410528 11331547136 1912700144 18.928 99 27 54 2 1933521040 13224336 7596560
22:27:32 18256 8192000000 9375638512 9667379200 521744048 5.987 27 1 2 0 528960800 7154624 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 19-06-2021 22:28:51 to 19-06-2021 22:29:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 146 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:02, from 19-06-2021 22:29:23 to 19-06-2021 22:29:25.

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          245029
MON$OLDEST_ACTIVE               245030
MON$OLDEST_SNAPSHOT             245030
MON$NEXT_TRANSACTION            245030
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                       2027808
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 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 ---
:84: 
:85: mscs-test-161.budzdorov.ru    Sat Jun 19 22:27:54 2021
:86:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:87: 
:88: 
:89: mscs-test-161.budzdorov.ru    Sat Jun 19 22:27:54 2021
:90:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:91: 
--- end of diff output ---

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

19.06.21 22:29:26. 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-06-19 22:29:28 No severe PSQL-related problems occured
19.06.21 22:29:29. End of report.