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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-03 01:27:17
DTS_END                         2021-02-03 01:27:17.6050
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/36456
TRN_ID                          228497
ATT_ID                          642
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: 9155.71 24349 1098685
customer order: creation 158.74 394 19049
customer order: refuse 13.78 388 1654
order to supplier: creation 42.83 1399 5140
order to supplier: removal 3.36 122515 403
invoice (draft): creation 42.75 3631 5130
invoice (draft): removal 53.78 901 6453
invoice accept: apply 38.59 18753 4631
invoice accept: cancel 49.32 799 5918
customer reserve: creation 3602.50 181 432300
customer reserve: removal 4872.39 65 584687
realization accept: apply 77.12 205 9254
realization accept: cancel 81.24 131 9749
payment from customer: creation 54.37 157 6524
payment from customer: removal 5.32 112 638
payment to supplier: creation 45.00 173 5400
payment to supplier: removal 3.24 82 389
service: total inventory turnovers 4.32 1154 518
service: total monetary turnovers 6.27 33 752
service: aggregate perf. data 0.77 21443 92
service: refresh index statistics 0.03 314456 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5147
TEST_TIME 2 5265
TEST_TIME 3 4636
TEST_TIME 4 5135
TEST_TIME 5 4968
TEST_TIME 6 4879
TEST_TIME 7 5606
TEST_TIME 8 6323
TEST_TIME 9 6618
TEST_TIME 10 6304
TEST_TIME 11 6249
TEST_TIME 12 6521
TEST_TIME 13 6617
TEST_TIME 14 6622
TEST_TIME 15 6523
TEST_TIME 16 6894
TEST_TIME 17 7021
TEST_TIME 18 7081
TEST_TIME 19 7230
TEST_TIME 20 7239
TEST_TIME 21 7736
TEST_TIME 22 7814
TEST_TIME 23 8068
TEST_TIME 24 8355
TEST_TIME 25 8805
TEST_TIME 26 8655
TEST_TIME 27 9750
TEST_TIME 28 9504
TEST_TIME 29 9852
TEST_TIME 30 10646
TEST_TIME 31 11251
TEST_TIME 32 11007
TEST_TIME 33 10811
TEST_TIME 34 10610
TEST_TIME 35 10646
TEST_TIME 36 10599
TEST_TIME 37 10501
TEST_TIME 38 10344
TEST_TIME 39 10155
TEST_TIME 40 10058
TEST_TIME 41 10047
TEST_TIME 42 9989
TEST_TIME 43 9937
TEST_TIME 44 9827
TEST_TIME 45 9743
TEST_TIME 46 9601
TEST_TIME 47 9738
TEST_TIME 48 9707
TEST_TIME 49 9591
TEST_TIME 50 9445
TEST_TIME 51 9370
TEST_TIME 52 9313
TEST_TIME 53 9389
TEST_TIME 54 9402
TEST_TIME 55 9362
TEST_TIME 56 9278
TEST_TIME 57 9206
TEST_TIME 58 9067
TEST_TIME 59 9069
TEST_TIME 60 9119
TEST_TIME 61 9071
TEST_TIME 62 9058
TEST_TIME 63 9138
TEST_TIME 64 9105
TEST_TIME 65 9055
TEST_TIME 66 9132
TEST_TIME 67 9116
TEST_TIME 68 9153
TEST_TIME 69 9162
TEST_TIME 70 9283
TEST_TIME 71 9278
TEST_TIME 72 9303
TEST_TIME 73 9365
TEST_TIME 74 9333
TEST_TIME 75 9338
TEST_TIME 76 9416
TEST_TIME 77 9425
TEST_TIME 78 9350
TEST_TIME 79 9291
TEST_TIME 80 9252
TEST_TIME 81 9223
TEST_TIME 82 9207
TEST_TIME 83 9129
TEST_TIME 84 9142
TEST_TIME 85 9123
TEST_TIME 86 9107
TEST_TIME 87 9040
TEST_TIME 88 9111
TEST_TIME 89 9100
TEST_TIME 90 9153
TEST_TIME 91 9175
TEST_TIME 92 9224
TEST_TIME 93 9238
TEST_TIME 94 9262
TEST_TIME 95 9329
TEST_TIME 96 9266
TEST_TIME 97 9322
TEST_TIME 98 9436
TEST_TIME 99 9388
TEST_TIME 100 9440
TEST_TIME 101 9413
TEST_TIME 102 9335
TEST_TIME 103 9343
TEST_TIME 104 9325
TEST_TIME 105 9279
TEST_TIME 106 9233
TEST_TIME 107 9252
TEST_TIME 108 9228
TEST_TIME 109 9175
TEST_TIME 110 9149
TEST_TIME 111 9119
TEST_TIME 112 9120
TEST_TIME 113 9122
TEST_TIME 114 9160
TEST_TIME 115 9195
TEST_TIME 116 9223
TEST_TIME 117 9205
TEST_TIME 118 9220
TEST_TIME 119 9199
TEST_TIME 120 9158

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 03-02-2021 01:28:15 to 03-02-2021 01:28:19.

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 1499671 1499671 0 0.00 0 17272 6 0 0
doc_list_biud 1499670 1499670 0 0.00 0 78423 32 0 0
sp_add_invoice_to_stock 4755 4631 124 2.60 55 185185 18754 0 124
sp_cancel_adding_invoice 5918 5918 0 0.00 4 79175 799 0 0
sp_cancel_client_order 1654 1654 0 0.00 5 13265 388 0 0
sp_cancel_customer_reserve 584687 584687 0 0.00 1 70254 66 0 0
sp_cancel_pay_from_customer 638 638 0 0.00 3 7995 113 0 0
sp_cancel_pay_to_supplier 389 389 0 0.00 3 5620 83 0 0
sp_cancel_supplier_invoice 6471 6453 18 0.27 2 78432 902 0 18
sp_cancel_supplier_order 403 403 0 0.00 9 1029766 122516 0 0
sp_cancel_write_off 9749 9749 0 0.00 1 8586 132 0 0
sp_client_order 19049 19049 0 0.00 3 30857 394 0 0
sp_customer_reserve 432300 432300 0 0.00 0 75126 181 0 0
sp_fill_shopping_cart 29304 29304 0 0.00 1 23615 43 0 0
sp_fill_shopping_cart_clo_res 432296 432296 0 0.00 0 20593 15 0 0
sp_get_clo_for_invoice 4625 4625 0 0.00 0 28870 360 0 0
sp_kill_cost_storno 16694 16694 0 0.00 0 11469 63 0 0
sp_kill_qstorno_ret_qs2qd 1185979 1185979 0 0.00 0 78419 36 0 0
sp_kill_qty_storno 622743 622743 0 0.00 0 78421 76 0 0
sp_lock_selected_doc 19244 19244 0 0.00 0 6999 5 0 0
sp_make_cost_storno 25803 25803 0 0.00 0 12185 64 0 0
sp_multiply_rows_for_pdistr 25803 25803 0 0.00 0 11758 37 0 0
sp_multiply_rows_for_qdistr 19049 19049 0 0.00 0 13902 174 0 0
sp_pay_from_customer 6524 6524 0 0.00 4 17820 158 0 0
sp_pay_to_supplier 5400 5400 0 0.00 4 16194 173 0 0
sp_payment_common 11924 11924 0 0.00 1 9855 37 0 0
sp_qd_handle_on_cancel_clo 1654 1654 0 0.00 0 13254 345 0 0
sp_qd_handle_on_invoice_upd_sts 10543 10543 0 0.00 0 28879 363 0 0
sp_qd_handle_on_reserve_upd_sts 9254 9254 0 0.00 0 7174 60 0 0
sp_reserve_write_off 9254 9254 0 0.00 6 13265 205 0 0
sp_supplier_invoice 5130 5130 0 0.00 7 92910 3631 0 0
sp_supplier_order 5140 5140 0 0.00 5 75775 1400 0 0
srv_aggregate_perf_data 92 92 0 0.00 2679 181393 21444 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1298 132052 30698 0 0
srv_find_qd_qs_mism 1054740 1054740 0 0.00 0 9681 5 0 0
srv_make_invnt_saldo 518 518 0 0.00 40 56541 1155 0 0
srv_make_money_saldo 752 752 0 0.00 1 2516 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 139298 508203 314457 0 0
t$perf-abend:sp_add_invoice_to_stock 124 124 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 18 18 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4631 4631 0 0.00 0 8869 192 0 0
t$perf-norm:sp_cancel_adding_invoice 382 382 0 0.00 0 10046 115 0 0
t$perf-norm:sp_cancel_client_order 1654 1654 0 0.00 0 2010 15 0 0
t$perf-norm:sp_cancel_customer_reserve 589 589 0 0.00 0 3766 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 638 638 0 0.00 0 163 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 389 389 0 0.00 0 621 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 348 348 0 0.00 0 451 12 0 0
t$perf-norm:sp_cancel_supplier_order 403 403 0 0.00 0 26164 1757 0 0
t$perf-norm:sp_cancel_write_off 962 962 0 0.00 0 2139 9 0 0
t$perf-norm:sp_client_order 19049 19049 0 0.00 0 6443 20 0 0
t$perf-norm:sp_customer_reserve 891 891 0 0.00 0 2185 9 0 0
t$perf-norm:sp_pay_from_customer 6524 6524 0 0.00 0 4856 9 0 0
t$perf-norm:sp_pay_to_supplier 5400 5400 0 0.00 0 4038 11 0 0
t$perf-norm:sp_reserve_write_off 9254 9254 0 0.00 0 6095 13 0 0
t$perf-norm:sp_supplier_invoice 5130 5130 0 0.00 0 4389 17 0 0
t$perf-norm:sp_supplier_order 5140 5140 0 0.00 0 4536 18 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 1117 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 700 9 0 0
t$perf-norm:srv_make_invnt_saldo 518 518 0 0.00 0 2104 30 0 0
t$perf-norm:srv_make_money_saldo 752 752 0 0.00 0 1993 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 9498 9250 248 2.61 0 12954 29 0 248
v_all_customers 34712 34712 0 0.00 0 35 1 0 0
v_all_suppliers 28598 28598 0 0.00 0 15 1 0 0
v_all_wares 38096 38096 0 0.00 0 245 1 0 0
v_cancel_adding_invoice 764 764 0 0.00 0 1844 12 0 0
v_cancel_client_order 3308 3308 0 0.00 0 5605 9 0 0
v_cancel_customer_prepayment 1276 1276 0 0.00 0 7932 12 0 0
v_cancel_customer_reserve 1178 1178 0 0.00 0 8729 18 0 0
v_cancel_payment_to_supplier 778 778 0 0.00 0 1580 5 0 0
v_cancel_supplier_invoice 732 696 36 4.91 0 3532 21 0 36
v_cancel_supplier_order 806 806 0 0.00 0 15071 31 0 0
v_cancel_write_off 1924 1924 0 0.00 0 7875 27 0 0
v_max_id_clo_ord 5134 5134 0 0.00 0 1279 1 0 0
v_max_id_clo_res 891 891 0 0.00 0 3199 14 0 0
v_max_id_ord_sup 5121 5121 0 0.00 0 5444 6 0 0
v_max_non_paid_invoice 1356 1356 0 0.00 0 1047 3 0 0
v_max_non_paid_realizn 3460 3460 0 0.00 0 4545 5 0 0
v_min_id_clo_ord 5134 5134 0 0.00 0 5069 12 0 0
v_min_id_clo_res 891 891 0 0.00 0 5806 10 0 0
v_min_id_ord_sup 5121 5121 0 0.00 0 3833 8 0 0
v_min_non_paid_invoice 5400 5400 0 0.00 0 6502 23 0 0
v_min_non_paid_realizn 6524 6524 0 0.00 0 6680 28 0 0
v_our_firm 9512 9512 0 0.00 0 14 1 0 0
v_reserve_write_off 18508 18508 0 0.00 0 5648 9 0 0
x_lock_depdocs_on_canc_invoice 12023 12023 0 0.00 0 20398 129 0 0
x_lock_depdocs_on_canc_sup_ord 403 403 0 0.00 0 9131 419 0 0
x_make_qstorno_1000_1200 5140 5140 0 0.00 1 75736 1300 0 0
x_make_qstorno_1200_2000 5130 5130 0 0.00 3 92601 3488 0 0
x_make_qstorno_2100_3300 432300 432300 0 0.00 0 75104 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-02-2021 01:28:20 to 03-02-2021 01:28:24.

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:20 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:27 8896 8192000000 10206182704 10512080896 1019879024 11.071 81 61 124 3 1044011216 2805888 21326304
22:57:44 28795 8192000000 10330654080 10656903168 1383113936 14.444 100 84 170 0 1414321888 4410320 26797632
22:58:23 27960 8192000000 10397797760 10721841152 1447654144 15.017 100 91 182 1 1484709696 6586640 30468912
22:59:02 31723 8192000000 10433647328 10763218944 1485889776 15.353 100 94 188 0 1524499424 7795472 30814176
22:59:54 15662 8192000000 10453608688 10786562048 1509175232 15.556 100 94 188 0 1548111712 9216848 29719632
23:00:29 24998 8192000000 10464182192 10804011008 1519978576 15.650 100 85 170 0 1556832144 9921136 26932432
23:01:09 18562 8192000000 10485198912 10828161024 1535303216 15.783 100 82 164 0 1570967920 9664496 26000208
23:01:34 19104 8192000000 10500143104 10843836416 1554006912 15.945 100 81 162 1 1589319248 10120032 25192304
23:02:08 19281 8192000000 10542758480 10894471168 1587912624 16.236 100 86 172 0 1625134928 10382256 26840048
23:02:36 6906 8192000000 10556978176 10911571968 1614899360 16.466 100 84 168 1 1651007440 11003808 25104272
23:02:54 15602 8192000000 10575408656 10936377344 1632345744 16.615 100 79 158 1 1667758768 11837376 23575648
23:03:18 12118 8192000000 10603409152 10966847488 1658123440 16.833 100 84 168 3 1696142176 12849280 25169456
23:03:37 10761 8192000000 10609053472 10977439744 1668148864 16.918 100 74 148 0 1702954352 12432304 22373184
23:03:55 10398 8192000000 10630211632 11000778752 1688698784 17.090 100 82 164 3 1725454416 12461376 24294256
23:04:13 7901 8192000000 10645554112 11016232960 1708455648 17.256 100 76 152 0 1742619616 12280064 21883904
23:04:29 10133 8192000000 10665637584 11039653888 1721943312 17.368 100 82 164 0 1757693984 12015264 23735408
23:04:49 7217 8192000000 10676603856 11050958848 1736311776 17.488 100 76 150 2 1770331696 12281744 21738176
23:05:04 6753 8192000000 10683192816 11056812032 1745931712 17.568 100 86 172 0 1784458080 13812464 24713904
23:05:18 6318 8192000000 10696121808 11074105344 1753094048 17.627 100 80 158 1 1789130800 13908704 22128048
23:05:34 4893 8192000000 10693143632 11070648320 1761136560 17.694 100 81 160 2 1796978992 13496112 22346320
23:05:49 4859 8192000000 10716828704 11096285184 1768076512 17.751 100 76 149 1 1802486864 13429968 20980384
23:06:01 9907 8192000000 10705565952 11095986176 1779295120 17.844 100 73 146 0 1812270864 12692496 20283248
23:06:19 4140 8192000000 10729042896 11111653376 1792995120 17.956 100 79 158 0 1828179616 12630400 22554096
23:06:33 2998 8192000000 10743547648 11130613760 1809022000 18.088 100 79 160 1 1843617088 11951344 22643744
23:06:44 3208 8192000000 10746264960 11134509056 1817797360 18.160 100 85 170 2 1854530304 12939024 23793920
23:06:56 4102 8192000000 10766033824 11153498112 1826870880 18.234 100 88 176 1 1864864192 12909984 25083328
23:07:07 3252 8192000000 10769960816 11159441408 1832890288 18.283 100 88 176 0 1871354688 13520656 24943744
23:07:17 2311 8192000000 10790789408 11173789696 1841095120 18.350 100 89 179 0 1878836736 12841200 24900416
23:07:26 3160 8192000000 10783067504 11174764544 1845116512 18.382 100 94 189 2 1885325600 13528912 26680176
23:07:36 2018 8192000000 10791151440 11179597824 1847621680 18.403 100 87 174 0 1885988128 13865104 24501344
23:07:44 2175 8192000000 10800719168 11188551680 1857928848 18.486 100 92 179 1 1896691712 13502032 25260832
23:07:53 2242 8192000000 10802145792 11192451072 1861631856 18.517 100 91 182 2 1899856224 12599936 25624432
23:08:02 1893 8192000000 10800868064 11192557568 1863230080 18.529 100 87 170 0 1900994432 13245040 24519312
23:08:11 3018 8192000000 10812582160 11203604480 1865828992 18.551 100 90 178 1 1905210416 13760160 25621264
23:08:20 1844 8192000000 10815362784 11204800512 1868924288 18.576 100 91 180 2 1908097952 14122752 25050912
23:08:29 1870 8192000000 10816550912 11206565888 1874001216 18.617 100 89 178 0 1913064576 13951808 25111552
23:08:37 1981 8192000000 10817000832 11209523200 1874170528 18.618 100 88 176 1 1911633072 12609056 24853488
23:08:45 27735 8192000000 10814538416 11210117120 1873846192 18.615 100 66 132 1 1902520464 10397504 18276768
23:09:19 1299 8192000000 10828897072 11222372352 1885579392 18.710 100 87 175 1 1921360480 10958048 24823040
23:09:27 8739 8192000000 10829466176 11220201472 1881667552 18.679 100 73 148 2 1913084224 11205024 20211648
23:09:43 3051 8192000000 10812395776 11222265856 1884373344 18.700 100 67 134 0 1915442848 12095344 18974160
23:09:54 1902 8192000000 10823545072 11225509888 1890161200 18.747 100 83 164 3 1924633472 11687488 22784784
23:10:03 2425 8192000000 10816126704 11220123648 1883913648 18.697 100 55 110 1 1909526528 10068912 15543968
23:10:12 3235 8192000000 10802635392 11218464768 1883425184 18.693 100 46 92 0 1906292272 9467328 13399760
23:10:21 7342 8192000000 10782479152 11214602240 1882530752 18.686 100 38 76 2 1902767232 9309728 10926752
23:10:35 3029 8192000000 10797756848 11218313216 1883039728 18.690 100 39 76 1 1901705056 8216224 10449104
23:10:45 3754 8192000000 10798903104 11216429056 1884632960 18.703 100 44 89 0 1905552096 8461520 12457616
23:11:00 7446 8192000000 10799988208 11221471232 1886208624 18.715 100 37 74 2 1904758320 8044080 10505616
23:11:14 6415 8192000000 10801870096 11223064576 1888150240 18.731 100 25 49 2 1901477712 6749440 6578032
23:11:29 6981 8192000000 10789177808 11221475328 1887934736 18.729 100 37 73 1 1904805648 5721312 11149600
23:11:42 8580 8192000000 10787967424 11221295104 1886348560 18.716 100 28 56 4 1901238800 6796672 8093568
23:11:57 6093 8192000000 10793383200 11221471232 1885870016 18.712 100 26 52 2 1899546112 6518368 7157728
23:12:09 13613 8192000000 10782223312 11220447232 1884898208 18.705 100 13 26 1 1898688032 10284704 3505120
23:12:30 9315 8192000000 10793156512 11226456064 1892073072 18.762 100 15 30 0 1902116416 4961840 5081504
23:12:47 9728 8192000000 10801830352 11231252480 1892788240 18.768 100 14 28 2 1902942736 5925856 4228640
23:13:03 22543 8192000000 10795221696 11231535104 1896465056 18.798 100 25 50 5 1910156288 6445904 7245328
23:13:32 17232 8192000000 10800276912 11240325120 1897409008 18.805 100 39 78 2 1915667056 6790496 11467552
23:14:34 35106 8192000000 10814400496 11246399488 1897741136 18.808 100 27 55 1 1911080720 6254176 7085408
23:15:15 7373 8192000000 10813861856 11247374336 1899497616 18.822 100 29 58 3 1914249200 6199504 8552080
23:15:29 7289 8192000000 10830274256 11261403136 1905676496 18.872 100 33 66 3 1922906928 7786608 9443824
23:15:42 5882 8192000000 10813387552 11250642944 1906094320 18.875 100 25 49 2 1918780432 5322544 7363568
23:15:57 4717 8192000000 10816640848 11249295360 1902765056 18.849 100 30 58 3 1917627888 6527200 8335632
23:16:10 7959 8192000000 10817445040 11250274304 1904803840 18.865 100 27 54 3 1918309584 5950992 7554752
23:16:24 7088 8192000000 10816434080 11250962432 1903622384 18.855 100 23 46 2 1915692848 5784816 6285648
23:16:39 7584 8192000000 10814299952 11251109888 1901848512 18.841 100 23 46 0 1914313472 5820032 6644928
23:16:54 8860 8192000000 10824324448 11258241024 1906131984 18.876 100 19 38 0 1918115376 6254368 5729024
23:17:12 10892 8192000000 10802471568 11236720640 1851500416 18.434 97 22 44 1 1864707296 6585872 6621008
23:17:31 5058 8192000000 10790157008 11222835200 1867657584 18.565 99 23 46 3 1880050544 5593552 6799408
23:17:45 9554 8192000000 10758630752 11181203456 1800967712 18.022 96 21 42 1 1812606096 5895856 5742528
23:18:05 18193 8192000000 10768031872 11197534208 1827708224 18.241 98 16 32 0 1837886720 5498128 4680368
23:18:32 58454 8192000000 10768607728 11182493696 1839106288 18.334 99 38 75 2 1855185504 4660400 11418816
23:19:36 14374 8192000000 10718714496 11145453568 1704921616 17.226 92 25 50 2 1717556416 5196048 7438752
23:19:58 8896 8192000000 10733257680 11142696960 1743737280 17.550 96 32 63 3 1759452144 6767024 8947840
23:20:16 7030 8192000000 10703480112 11107500032 1727689136 17.416 95 42 81 3 1745797920 5814432 12294352
23:20:29 6961 8192000000 10700537104 11117338624 1763346208 17.712 98 35 70 1 1780308896 6537232 10425456
23:20:42 8895 8192000000 10704034752 11117424640 1760667552 17.690 98 21 42 0 1771639008 5378560 5592896
23:20:57 6403 8192000000 10710174432 11123859456 1780968160 17.857 99 30 61 2 1796093008 6266752 8858096
23:21:10 4364 8192000000 10703130032 11119579136 1773410480 17.795 99 35 71 1 1794907648 10513136 10984032
23:21:22 6668 8192000000 10729119728 11145027584 1791051856 17.940 99 33 66 1 1807283552 6190032 10041664
23:21:35 6948 8192000000 10705908880 11111198720 1741148560 17.528 97 34 67 2 1757561664 6164304 10248800
23:21:49 6745 8192000000 10700150816 11123101696 1753381904 17.630 97 19 38 1 1764842640 6113152 5347584
23:22:02 6726 8192000000 10733162288 11145646080 1807617440 18.076 100 19 38 1 1819841248 5740944 6482864
23:22:21 14535 8192000000 10723917952 11155714048 1776753008 17.823 97 15 30 1 1786909760 5319712 4837040
23:22:41 10835 8192000000 10747696240 11169685504 1829884272 18.258 100 25 50 0 1843513680 5630368 7999040
23:22:59 11205 8192000000 10726721344 11148017664 1795468640 17.977 98 21 42 0 1807621648 5339360 6813648
23:23:17 17283 8192000000 10736814560 11166875648 1814379600 18.132 99 28 56 1 1828809472 5460832 8969040
23:23:41 59819 8192000000 10767045920 11182592000 1845846336 18.388 100 46 92 0 1864457952 5154160 13457456
23:24:47 8156 8192000000 10764568992 11193237504 1848326240 18.409 100 29 57 2 1863176960 6991280 7859440
23:25:02 6904 8192000000 10765124912 11196686336 1854142128 18.456 100 24 48 1 1867198288 6221040 6835120
23:25:15 7452 8192000000 10773526800 11203670016 1860967776 18.511 100 27 54 0 1875551952 7026688 7557488
23:25:30 6422 8192000000 10774402912 11207667712 1864718704 18.542 100 28 56 1 1878742672 5622976 8400992
23:25:45 12774 8192000000 10783606288 11215208448 1869994624 18.584 100 23 46 1 1881916928 5730032 6192272
23:26:04 11882 8192000000 10781611344 11217612800 1870976032 18.592 100 21 41 2 1886345616 9215280 6154304
23:26:22 11125 8192000000 10785190528 11214237696 1870771680 18.591 100 18 36 0 1881306848 5276880 5258288
23:26:41 5665 8192000000 10789016528 11221352448 1872539920 18.605 100 24 49 1 1884982016 5366752 7075344
23:26:53 10045 8192000000 10784024016 11218116608 1874520016 18.621 100 22 44 0 1887514880 5931712 7063152
23:27:09 20785 8192000000 10812973536 11238817792 1890358112 18.749 100 27 54 1 1903216736 5043712 7814912
23:27:43 3053 8192000000 10851044880 11263848448 1911022864 18.915 100 49 97 1 1930539728 5929840 13587024
23:27:55 14814 8192000000 10836252288 11261050880 1914243824 18.941 100 42 82 1 1933383680 7211712 11928144
23:28:19 20432 8192000000 10847889376 11273326592 1920083696 18.988 100 42 82 0 1943715488 12168528 11463264
23:28:54 15355 8192000000 10857415536 11282456576 1926734448 19.041 100 40 77 0 1950005088 12810336 10460304
23:29:25 13607 8192000000 10863848448 11289210880 1934235856 19.101 100 48 96 1 1956823776 9155504 13432416
23:29:46 60103 8192000000 10869627712 11299631104 1937281584 19.125 100 49 99 1 1961295216 10004272 14009360
23:31:14 27259 8192000000 10859629504 11307622400 1942143008 19.164 100 28 56 2 1959114240 8583056 8388176
23:31:59 35678 8192000000 10886148656 11323437056 1952454816 19.246 100 26 52 2 1971631296 12122288 7054192
23:32:46 2761 8192000000 10903155760 11326029824 1960002064 19.306 100 63 123 2 1991135600 12243280 18890256
23:32:56 13128 8192000000 10901357344 11331407872 1962337616 19.325 100 49 98 0 1989879392 13208144 14333632
23:33:23 18902 8192000000 10917129776 11342491648 1974545504 19.421 100 65 128 1 2008186800 14942224 18699072
23:34:03 14057 8192000000 10925714944 11354914816 1979060192 19.457 100 58 116 1 2014099280 18650128 16388960
23:34:29 5057 8192000000 10922341456 11355119616 1978163440 19.450 100 54 108 0 2011674528 17823104 15687984
23:34:40 1832 8192000000 10931473488 11347812352 1974689104 19.423 100 65 127 2 2010829456 17029056 19111296
23:34:49 7290 8192000000 10911113280 11345707008 1970761984 19.391 100 57 114 1 2005989616 18404480 16823152
23:35:05 12569 8192000000 10924200016 11357282304 1980587104 19.469 100 59 118 2 2016497024 17842416 18067504
23:35:24 1728 8192000000 10932224752 11359526912 1984287984 19.499 100 64 126 0 2020557696 17153824 19115888
23:35:33 11129 8192000000 10921856416 11359596544 1965252864 19.348 99 59 117 1 2001808656 18358864 18196928
23:35:54 6223 8192000000 10933034800 11363332096 1985489952 19.508 100 64 127 2 2022430416 17687296 19253168
23:36:08 6342 8192000000 10933258768 11367366656 1989799728 19.542 100 63 126 1 2026964960 19015536 18149696
23:36:25 8719 8192000000 10943044208 11377418240 1992763504 19.566 100 57 114 0 2029959008 20153184 17042320
23:36:44 15706 8192000000 10927243472 11372519424 1992405408 19.563 100 42 80 2 2021920784 17429824 12085552
23:37:08 19092 8192000000 10934489360 11378708480 1994592544 19.580 100 46 90 0 2026048832 18600208 12856080
23:37:35 15212 8192000000 10950578048 11385528320 2008719200 19.691 100 54 108 1 2045655600 21078048 15858352
23:38:05 10297 8192000000 10953987088 11396247552 2008845856 19.692 100 55 110 0 2047459216 22656192 15957168
23:38:22 14890 8192000000 10957269056 11396640768 2010578336 19.706 100 48 94 2 2046641024 22297760 13764928
23:38:52 3977 8192000000 10974612592 11395100672 1981848720 19.479 98 64 126 1 2025718848 26557952 17312176
23:39:03 2765 8192000000 10963574672 11383046144 1997859392 19.606 100 79 158 2 2048211296 27090592 23261312
23:39:15 2559 8192000000 10955126336 11383267328 1996924416 19.598 100 68 136 0 2044180048 27219056 20036576
23:39:25 4390 8192000000 10969851408 11393282048 2006788720 19.676 100 67 134 0 2052481904 25885296 19807888
23:39:37 6504 8192000000 10960014256 11397312512 2006103424 19.671 100 56 113 0 2048934976 26258768 16572784
23:39:52 2200 8192000000 10964498320 11396939776 2008107248 19.687 100 58 116 2 2051244944 25878672 17259024
23:40:04 3073 8192000000 10976779088 11392421888 2001176656 19.632 100 77 149 2 2048213344 25795152 21241536
23:40:14 4335 8192000000 10976608416 11405180928 2006227248 19.672 100 68 135 1 2057844144 31098112 20518784
23:40:26 4413 8192000000 10967608512 11397197824 1990447120 19.547 99 72 144 1 2043111616 31221904 21442592
23:40:41 8653 8192000000 10970929152 11405660160 2009239552 19.696 100 69 138 1 2062914944 32097552 21577840
23:40:58 2551 8192000000 10970487456 11397419008 1992852288 19.566 99 62 123 0 2042822640 31495744 18474608
23:41:08 10288 8192000000 10977263168 11407986688 2011115904 19.710 100 61 121 0 2062467200 32771952 18579344
23:41:25 8713 8192000000 10932491664 11364847616 1946677664 19.200 97 58 114 2 1996691616 32746224 17267728
23:41:41 7410 8192000000 10940524400 11373264896 1974648128 19.422 100 57 113 1 2026725392 33733392 18343872
23:41:59 10595 8192000000 10941564400 11377020928 1984226320 19.498 100 49 98 0 2032953904 32757888 15969696
23:42:17 5712 8192000000 10953890768 11389448192 1989948112 19.543 100 57 110 4 2041700240 34960096 16792032
23:42:31 8380 8192000000 10969593552 11401392128 1988968192 19.536 99 61 121 0 2044400272 36825040 18607040
23:42:48 8587 8192000000 10968154784 11401003008 1988887056 19.535 99 60 121 0 2047783248 39849600 19046592
23:43:05 2868 8192000000 10969880096 11394580480 1989636512 19.541 100 63 126 1 2052383632 42973040 19774080
23:43:16 3766 8192000000 10950940192 11376721920 1973241280 19.411 99 68 135 2 2030927392 37915440 19770672
23:43:28 2976 8192000000 10947713920 11366490112 1972118928 19.402 100 73 145 2 2031382640 37140208 22123504
23:43:38 2976 8192000000 10954612032 11367096320 1977554416 19.445 100 88 170 2 2041819760 38707392 25557952
23:43:48 2459 8192000000 10960806336 11369779200 1976559648 19.437 100 88 176 2 2042666592 40098752 26008192
23:43:59 1818 8192000000 10982440528 11388502016 1989565904 19.540 100 95 189 0 2059164928 41137024 28462000
23:44:08 2429 8192000000 10969159488 11383431168 1986416176 19.515 100 79 158 1 2051701472 41341408 23943888
23:44:17 4332 8192000000 10943908192 11353595904 1944500048 19.183 99 83 166 0 2011594304 41782800 25311456
23:44:29 2671 8192000000 10957782960 11367104512 1971016368 19.394 100 87 174 0 2040199504 42501824 26681312
23:44:39 10528 8192000000 10955134528 11371192320 1974945120 19.425 100 77 153 0 2040876160 42133280 23797760
23:44:57 1953 8192000000 10951251488 11368742912 1971798128 19.400 100 67 134 0 2035529712 42627696 21103888
23:45:08 1898 8192000000 10973558080 11383234560 1967689632 19.367 99 86 172 2 2040292208 46311856 26290720
23:45:17 2776 8192000000 10984644928 11392864256 1988301312 19.530 100 89 178 1 2063598816 47859344 27438160
23:45:31 2840 8192000000 10987490656 11396685824 1991278000 19.554 100 82 163 1 2065625344 49231808 25115536
23:45:41 2116 8192000000 10978699968 11390779392 1985924368 19.512 100 85 171 1 2061348576 49096832 26327376
23:45:50 3787 8192000000 10993920992 11402088448 1992880256 19.567 100 87 174 0 2076180976 56199472 27101248
23:46:03 2529 8192000000 10985033712 11394437120 1987566720 19.525 100 78 156 2 2064051536 51963600 24521216
23:46:12 4708 8192000000 10992581552 11399008256 1991456208 19.555 100 91 179 1 2072693712 53185024 28052480
23:46:23 2161 8192000000 10982802272 11389243392 1976620928 19.438 99 93 186 1 2060757280 54584464 29551888
23:46:32 5158 8192000000 10966755984 11387691008 1977754608 19.447 100 74 146 1 2055707248 54537296 23415344
23:46:52 4629 8192000000 10962111664 11385593856 1972796544 19.408 100 57 114 0 2048111808 56249840 19065424
23:47:03 3729 8192000000 10976355296 11395198976 1983762672 19.494 100 66 132 0 2062170672 56831808 21576192
23:47:14 5720 8192000000 10990090672 11407888384 1992246640 19.562 100 75 148 0 2075413440 58783216 24383584
23:47:27 1774 8192000000 11002024160 11412058112 1999449632 19.618 100 83 166 2 2082957648 57541824 25966192
23:47:38 1422 8192000000 10987324944 11392065536 1977399040 19.444 99 84 167 2 2064805392 61475920 25930432
23:47:49 3496 8192000000 10998031552 11415244800 1994112592 19.576 100 76 151 2 2080237648 62776064 23348992
23:48:00 3322 8192000000 11022994384 11428347904 2005931520 19.669 100 82 164 0 2097209904 65106112 26172272
23:48:10 3070 8192000000 11028825920 11440312320 2014832400 19.740 100 87 174 3 2107964432 65557968 27574064
23:48:20 3286 8192000000 11020216464 11426078720 2001348928 19.633 100 87 174 1 2095810752 66274928 28186896
23:48:31 1426 8192000000 11002810736 11408240640 1984178640 19.498 99 91 182 1 2077780304 64613216 28988448
23:48:42 1297 8192000000 11010073376 11418595328 1998728544 19.613 100 88 176 0 2089942192 63074912 28138736
23:48:54 3784 8192000000 11000982256 11419865088 1982888560 19.488 99 81 162 2 2070238128 61065792 26283776
23:49:09 4494 8192000000 11002547472 11422158848 2003146224 19.648 100 79 158 2 2090448528 61851104 25451200
23:49:21 2500 8192000000 11011639008 11430977536 2004638880 19.659 100 74 148 0 2092493008 63722720 24131408
23:49:35 7468 8192000000 11010780112 11439329280 2007448160 19.681 100 64 128 0 2094810144 66079456 21282528
23:49:50 9067 8192000000 11003064048 11432419328 2001126912 19.632 100 54 108 0 2087312064 67217008 18968144
23:50:10 3434 8192000000 10986540000 11415441408 1984613568 19.501 99 56 112 0 2069315632 65808688 18893376
23:50:21 10634 8192000000 10991527120 11423375360 1974582816 19.422 99 52 104 4 2061598096 68779040 18236240
23:50:46 10443 8192000000 10984439472 11418841088 1989806320 19.542 100 52 104 0 2076955504 68986000 18163184
23:51:10 10169 8192000000 10981407296 11425968128 1985333376 19.507 100 43 86 0 2065948368 65158480 15456512
23:51:33 21152 8192000000 10979680560 11422576640 1989255408 19.538 100 42 84 1 2067445616 62668144 15522064
23:52:04 4558 8192000000 10973915120 11402272768 1950706240 19.232 98 54 106 1 2030289808 60951600 18631968
23:52:17 6699 8192000000 10975521168 11403534336 1973719648 19.415 100 55 110 2 2052295088 60264160 18311280
23:52:30 8857 8192000000 10963009152 11401146368 1953595568 19.255 99 44 88 3 2027694592 59193232 14905792
23:53:08 27050 8192000000 10943246048 11390803968 1944972336 19.186 99 40 78 1 2018819728 59717968 14129424
23:54:01 10850 8192000000 10954494176 11408281600 1958305088 19.293 100 31 62 0 2039215424 69178416 11731920
23:54:19 22940 8192000000 10936485488 11401232384 1956138928 19.275 100 23 46 4 2022429584 57921472 8369184
23:55:14 27734 8192000000 10925001424 11382644736 1950311264 19.229 100 19 38 1 2005850896 48957744 6581888
23:55:53 13872 8192000000 10933990592 11395702784 1952186720 19.244 100 19 38 2 2022359152 62691600 7480832
23:56:37 31032 8192000000 10923784304 11392720896 1911754400 18.921 98 17 34 0 1978321824 60005040 6562384
23:57:14 47514 8192000000 10911287936 11388944384 1949652928 19.224 100 12 24 1 1997239216 42951920 4634368
23:58:13 74720 8192000000 10878764368 11342487552 1883237376 18.691 96 11 22 0 1907899616 21710128 2952112
23:59:40 36773 8192000000 10893666496 11328352256 1899678560 18.824 97 43 85 1 1922412576 9901616 12832400
00:00:23 68630 8192000000 10875627264 11324817408 1911225632 18.916 98 53 105 5 1936461840 9884560 15351648
00:01:41 29883 8192000000 10881312784 11329241088 1940883088 19.154 100 27 52 1 1959034656 10716336 7435232
00:02:17 46268 8192000000 10868703648 11312857088 1906652800 18.880 98 20 40 0 1923484320 10263040 6568480
00:03:11 80384 8192000000 10860275584 11324731392 1865684176 18.549 96 32 64 0 1881286128 6634368 8967584
00:04:38 49149 8192000000 10878068496 11334774784 1930064400 19.067 99 15 31 0 1941676160 7605280 4006480
00:05:33 90209 8192000000 10900440672 11355934720 1947296224 19.205 99 19 38 2 1966854080 13901008 5656848
00:07:24 57856 8192000000 10898850672 11364065280 1959377456 19.301 99 28 55 0 1977296256 9611440 8307360
00:08:28 76394 8192000000 10903777952 11374071808 1974811584 19.424 100 20 40 0 1993987344 13018560 6157200
00:09:53 90936 8192000000 10923106816 11385405440 1987467152 19.524 100 26 52 1 2005764048 10405728 7891168
00:11:37 132052 8192000000 10927841568 11385520128 1971842912 19.400 99 25 50 0 1992103280 12967504 7292864
00:13:57 77820 8192000000 10924776640 11399229440 1995889648 19.590 100 38 75 1 2033535648 26497136 11148864
00:15:27 72559 8192000000 10921956624 11369353216 1958878688 19.297 98 26 51 1 1976658720 10379696 7400336
00:16:52 71562 8192000000 10929117312 11391455232 1999108016 19.616 100 31 62 0 2017722656 9938240 8676400
00:18:26 38768 8192000000 10932427280 11400773632 2003265936 19.648 100 23 45 2 2021923856 12321328 6336592
00:19:14 31275 8192000000 10923175824 11390255104 1966427488 19.357 98 23 46 1 1984698480 11216880 7054112
00:19:52 59008 8192000000 10898773872 11379736576 1916015984 18.955 96 28 57 2 1936340880 12074928 8249968
00:21:03 49596 8192000000 10887139120 11375493120 1951836704 19.241 99 7 14 0 1971090032 17017056 2236272
00:22:05 37802 8192000000 10891890224 11372175360 1968777488 19.376 100 6 12 1 1986370800 15769792 1823520
00:23:34 44732 8192000000 10898297376 11373137920 1968694896 19.375 99 14 28 1 1979434960 6346064 4394000
00:24:35 71720 8192000000 10942544048 11390365696 1999346544 19.618 100 22 44 1 2016363408 10713296 6303568
00:25:53 119021 8192000000 10899052240 11377979392 1931039152 19.075 97 9 18 0 1948654320 15555680 2059488
00:28:07 66116 8192000000 10911586928 11394965504 1973382496 19.412 99 15 30 0 1993774960 16558304 3834160
00:29:27 88163 8192000000 10914042992 11410362368 1989497808 19.540 100 11 22 1 2011395424 18890752 3006864
00:31:05 67425 8192000000 10900428608 11368734720 1893501232 18.774 95 12 23 1 1903248160 6886176 2860752
00:32:23 63567 8192000000 10922520672 11394654208 1953933136 19.258 98 27 54 2 1978410144 16764112 7712896
00:33:39 46083 8192000000 10921010192 11393052672 1981050128 19.473 100 22 44 1 2003159968 15850464 6259376
00:35:08 40241 8192000000 10893216192 11365969920 1906103280 18.875 96 22 44 0 1926948960 14294544 6551136
00:36:08 41076 8192000000 10911811744 11385462784 1953516384 19.254 99 14 28 0 1977790192 20048800 4225008
00:38:24 67696 8192000000 10887532000 11369984000 1904139360 18.860 96 20 40 0 1922225808 12712256 5374192
00:39:38 68692 8192000000 10884812288 11369717760 1918425392 18.974 97 20 40 0 1936129824 12288784 5415648
00:40:57 84101 8192000000 10880586528 11330097152 1786816720 17.906 91 31 62 0 1804579584 9508144 8254720
00:42:38 41887 8192000000 10838398560 11294523392 1835174336 18.302 95 15 29 2 1853339616 13941936 4223344
00:43:27 71327 8192000000 10853599920 11309334528 1859856928 18.502 97 18 34 1 1878859552 14329632 4672992
00:44:45 105265 8192000000 10854187184 11312521216 1903936448 18.858 99 33 66 0 1922053568 9151024 8966096
00:46:39 64655 8192000000 10851786832 11321901056 1913089168 18.931 99 15 30 2 1928006256 10361424 4555664
00:47:50 13661 8192000000 10850797056 11322273792 1930122672 19.068 100 16 32 1 1944066624 9521040 4422912
00:48:11 6904 8192000000 10865135280 11334463488 1936451216 19.118 100 24 48 2 1952794896 9408096 6935584
00:48:24 72377 8192000000 10857039232 11333091328 1904740416 18.864 98 16 32 0 1921244064 11923632 4580016
00:49:46 38635 8192000000 10856829392 11339845632 1920919728 18.994 99 10 20 0 1937894816 13959744 3015344
00:50:30 28781 8192000000 10870258640 11350335488 1940092592 19.147 100 11 22 0 1959582960 16100352 3390016
00:51:11 79366 8192000000 10882167344 11356545024 1936696224 19.120 99 18 36 1 1953057216 11303696 5057296
00:52:48 85581 8192000000 10863713344 11342090240 1894897424 18.785 97 11 22 2 1908545040 10972224 2675392
00:54:42 18250 8192000000 10862740016 11333529600 1906362352 18.877 98 17 34 1 1925600016 14534768 4702896
00:55:12 64045 8192000000 10874573120 11348865024 1903158544 18.852 98 17 34 0 1925205920 16925376 5122000
00:56:29 53310 8192000000 10868747904 11336024064 1881069888 18.674 96 22 43 1 1905699904 18092160 6537856
00:57:37 47655 8192000000 10880253376 11341500416 1907454384 18.886 98 20 40 2 1929150128 15337680 6358064
00:58:39 86761 8192000000 10870671984 11337777152 1866722416 18.558 96 9 18 0 1885427744 16185088 2520240
01:00:13 101361 8192000000 10906351296 11370958848 1939723008 19.145 99 22 45 0 1966033440 19720928 6589504
01:02:04 29602 8192000000 10869357120 11340595200 1913919312 18.938 98 8 16 0 1927567568 11766224 1882032
01:03:02 49613 8192000000 10901525696 11353812992 1923354208 19.014 98 31 62 0 1947118832 14914160 8850464
01:03:58 29456 8192000000 10900137936 11351449600 1932060816 19.083 99 40 81 0 1963190288 19603136 11526336
01:04:37 30663 8192000000 10907022512 11361431552 1956514240 19.278 100 33 66 2 1985690576 19835072 9341264
01:05:18 100921 8192000000 10908259760 11370446848 1944766192 19.185 99 15 30 1 1967764848 19159424 3839232
01:08:18 123095 8192000000 10917740512 11387777024 1984830800 19.503 100 20 40 1 2001528608 10958768 5739040
01:10:28 86743 8192000000 10911785888 11399737344 1985048816 19.505 100 9 18 0 2001814112 14472560 2292736
01:12:01 7782 8192000000 10908352336 11401637888 1986136784 19.513 100 5 10 1 2002763072 15544048 1082240
01:12:19 6444 8192000000 10908825056 11404124160 1989674736 19.541 100 4 8 0 2005309088 14645408 988944
01:12:32 14556 8192000000 10920261200 11395051520 1996385200 19.594 100 14 26 0 2010484976 10340288 3759488
01:14:26 76997 8192000000 10909198368 11396198400 1986375104 19.515 100 9 18 0 1998647920 9791088 2481728
01:16:58 64882 8192000000 10879293488 11345522688 1935535888 19.111 98 21 42 0 1950330560 8330592 6464080
01:18:09 76987 8192000000 10884104960 11364921344 1915713552 18.952 97 14 28 0 1929931520 10387056 3830912
01:20:11 76304 8192000000 10890567488 11374845952 1942664048 19.168 99 13 26 1 1959924880 13735552 3525280
01:21:39 80862 8192000000 10898993776 11378147328 1947235280 19.204 99 23 46 1 1962149376 8528064 6386032
01:23:20 72696 8192000000 10895956368 11369635840 1918017952 18.971 97 24 48 1 1938749728 13530496 7201280
01:24:39 40022 8192000000 10897811632 11350241280 1925056736 19.027 98 26 50 1 1943798784 11830144 6911904
01:25:35 48491 8192000000 10883071424 11350515712 1925050688 19.027 98 19 40 0 1940292432 9753648 5488096
01:26:29 43501 8192000000 10886443296 11348078592 1887151616 18.723 96 26 52 0 1904837040 10249888 7435536

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 03-02-2021 01:28:26 to 03-02-2021 01:28:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 124 v_add_invoice_to_stock 335544517
except 18 v_cancel_supplier_invoice 335544517

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

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          226581
MON$OLDEST_ACTIVE               228898
MON$OLDEST_SNAPSHOT             228898
MON$NEXT_TRANSACTION            228898
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                       2036704
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.33411 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33411 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33411 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33411 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 ---
:93: 
:94: mscs-test-161.budzdorov.ru    Wed Feb  3 01:27:20 2021
:95:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:96: 
:97: 
:98: mscs-test-161.budzdorov.ru    Wed Feb  3 01:27:28 2021
:99:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:100: 
:101: 
:102: mscs-test-161.budzdorov.ru    Wed Feb  3 01:27:29 2021
:103:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:104: 
--- end of diff output ---

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

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