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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17182080 kB
MemAvailable 31364636 kB
Buffers 0 kB
Cached 14481376 kB
SwapCached 2412 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-22 01:27:45
DTS_END                         2021-06-22 01:27:45.2630
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/47556
TRN_ID                          236209
ATT_ID                          676
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: 9267.90 19852 1112148
customer order: creation 167.69 412 20123
customer order: refuse 14.54 365 1745
order to supplier: creation 43.93 1357 5272
order to supplier: removal 3.40 109660 408
invoice (draft): creation 45.08 3527 5410
invoice (draft): removal 54.19 794 6503
invoice accept: apply 41.24 19911 4949
invoice accept: cancel 49.20 890 5904
customer reserve: creation 3745.60 201 449472
customer reserve: removal 4809.70 62 577164
realization accept: apply 81.33 189 9760
realization accept: cancel 85.34 112 10241
payment from customer: creation 57.43 126 6891
payment from customer: removal 5.66 94 679
payment to supplier: creation 47.88 138 5745
payment to supplier: removal 3.47 68 416
service: total inventory turnovers 4.57 1235 548
service: total monetary turnovers 6.88 41 825
service: aggregate perf. data 0.74 24232 89
service: refresh index statistics 0.03 233616 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 22-06-2021 01:29:06 to 22-06-2021 01:29:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2851
TEST_TIME 2 4725
TEST_TIME 3 4878
TEST_TIME 4 4786
TEST_TIME 5 4785
TEST_TIME 6 4869
TEST_TIME 7 5202
TEST_TIME 8 5327
TEST_TIME 9 5653
TEST_TIME 10 5928
TEST_TIME 11 6680
TEST_TIME 12 6912
TEST_TIME 13 7091
TEST_TIME 14 7499
TEST_TIME 15 7530
TEST_TIME 16 7567
TEST_TIME 17 7566
TEST_TIME 18 7783
TEST_TIME 19 7769
TEST_TIME 20 8274
TEST_TIME 21 8383
TEST_TIME 22 8598
TEST_TIME 23 8720
TEST_TIME 24 9010
TEST_TIME 25 9108
TEST_TIME 26 9304
TEST_TIME 27 9375
TEST_TIME 28 10443
TEST_TIME 29 11069
TEST_TIME 30 11288
TEST_TIME 31 11020
TEST_TIME 32 10751
TEST_TIME 33 10466
TEST_TIME 34 10430
TEST_TIME 35 10371
TEST_TIME 36 10242
TEST_TIME 37 10227
TEST_TIME 38 10235
TEST_TIME 39 10188
TEST_TIME 40 10103
TEST_TIME 41 10056
TEST_TIME 42 10000
TEST_TIME 43 9974
TEST_TIME 44 10070
TEST_TIME 45 9953
TEST_TIME 46 9861
TEST_TIME 47 9861
TEST_TIME 48 9747
TEST_TIME 49 9722
TEST_TIME 50 9642
TEST_TIME 51 9611
TEST_TIME 52 9658
TEST_TIME 53 9569
TEST_TIME 54 9515
TEST_TIME 55 9482
TEST_TIME 56 9359
TEST_TIME 57 9291
TEST_TIME 58 9251
TEST_TIME 59 9157
TEST_TIME 60 9194
TEST_TIME 61 9169
TEST_TIME 62 9145
TEST_TIME 63 9289
TEST_TIME 64 9283
TEST_TIME 65 9349
TEST_TIME 66 9292
TEST_TIME 67 9358
TEST_TIME 68 9408
TEST_TIME 69 9350
TEST_TIME 70 9409
TEST_TIME 71 9446
TEST_TIME 72 9545
TEST_TIME 73 9556
TEST_TIME 74 9534
TEST_TIME 75 9448
TEST_TIME 76 9394
TEST_TIME 77 9331
TEST_TIME 78 9332
TEST_TIME 79 9304
TEST_TIME 80 9295
TEST_TIME 81 9256
TEST_TIME 82 9200
TEST_TIME 83 9151
TEST_TIME 84 9137
TEST_TIME 85 9248
TEST_TIME 86 9250
TEST_TIME 87 9251
TEST_TIME 88 9295
TEST_TIME 89 9316
TEST_TIME 90 9294
TEST_TIME 91 9312
TEST_TIME 92 9340
TEST_TIME 93 9347
TEST_TIME 94 9405
TEST_TIME 95 9397
TEST_TIME 96 9377
TEST_TIME 97 9443
TEST_TIME 98 9411
TEST_TIME 99 9353
TEST_TIME 100 9333
TEST_TIME 101 9305
TEST_TIME 102 9263
TEST_TIME 103 9203
TEST_TIME 104 9218
TEST_TIME 105 9185
TEST_TIME 106 9223
TEST_TIME 107 9181
TEST_TIME 108 9214
TEST_TIME 109 9209
TEST_TIME 110 9175
TEST_TIME 111 9231
TEST_TIME 112 9219
TEST_TIME 113 9206
TEST_TIME 114 9192
TEST_TIME 115 9221
TEST_TIME 116 9288
TEST_TIME 117 9328
TEST_TIME 118 9358
TEST_TIME 119 9345
TEST_TIME 120 9270

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-06-2021 01:29:10 to 22-06-2021 01:29:13.

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 1529270 1529270 0 0.00 0 14206 7 0 0
doc_list_biud 1529269 1529269 0 0.00 0 55057 29 0 0
sp_add_invoice_to_stock 5065 4949 116 2.29 39 191245 19911 0 116
sp_cancel_adding_invoice 5904 5904 0 0.00 5 86792 891 0 0
sp_cancel_client_order 1745 1745 0 0.00 4 9844 365 0 0
sp_cancel_customer_reserve 577164 577164 0 0.00 1 55059 62 0 0
sp_cancel_pay_from_customer 679 679 0 0.00 2 9199 95 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 3 1561 69 0 0
sp_cancel_supplier_invoice 6511 6503 8 0.12 1 17874 795 0 8
sp_cancel_supplier_order 408 408 0 0.00 13 1017789 109660 0 0
sp_cancel_write_off 10241 10241 0 0.00 1 10275 113 0 0
sp_client_order 20123 20123 0 0.00 4 53785 412 0 0
sp_customer_reserve 449472 449472 0 0.00 0 73137 201 0 0
sp_fill_shopping_cart 30803 30803 0 0.00 1 15515 41 0 0
sp_fill_shopping_cart_clo_res 449466 449466 0 0.00 0 15181 15 0 0
sp_get_clo_for_invoice 4943 4943 0 0.00 0 36826 345 0 0
sp_kill_cost_storno 17240 17240 0 0.00 0 8821 56 0 0
sp_kill_qstorno_ret_qs2qd 1171480 1171480 0 0.00 0 55055 33 0 0
sp_kill_qty_storno 616667 616667 0 0.00 0 55057 72 0 0
sp_lock_selected_doc 20437 20437 0 0.00 0 9493 4 0 0
sp_make_cost_storno 27339 27339 0 0.00 0 14197 53 0 0
sp_multiply_rows_for_pdistr 27338 27338 0 0.00 0 11070 31 0 0
sp_multiply_rows_for_qdistr 20123 20123 0 0.00 0 53776 179 0 0
sp_pay_from_customer 6891 6891 0 0.00 4 30436 126 0 0
sp_pay_to_supplier 5745 5745 0 0.00 5 29784 139 0 0
sp_payment_common 12636 12636 0 0.00 1 30401 34 0 0
sp_qd_handle_on_cancel_clo 1745 1745 0 0.00 0 9836 318 0 0
sp_qd_handle_on_invoice_upd_sts 10847 10847 0 0.00 0 31660 345 0 0
sp_qd_handle_on_reserve_upd_sts 9759 9759 0 0.00 0 18474 62 0 0
sp_reserve_write_off 9760 9760 0 0.00 6 18485 190 0 0
sp_supplier_invoice 5410 5410 0 0.00 6 101951 3527 0 0
sp_supplier_order 5272 5272 0 0.00 5 26030 1358 0 0
srv_aggregate_perf_data 89 89 0 0.00 2816 357920 24233 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 1010 124181 30524 0 0
srv_find_qd_qs_mism 1066104 1066104 0 0.00 0 13413 6 0 0
srv_make_invnt_saldo 548 548 0 0.00 30 78137 1236 0 0
srv_make_money_saldo 825 825 0 0.00 1 6858 42 0 0
srv_recalc_idx_stat 4 4 0 0.00 146641 385727 233616 0 0
t$perf-abend:sp_add_invoice_to_stock 116 116 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 4949 4949 0 0.00 0 17444 202 0 0
t$perf-norm:sp_cancel_adding_invoice 395 395 0 0.00 0 14603 140 0 0
t$perf-norm:sp_cancel_client_order 1745 1745 0 0.00 0 2010 12 0 0
t$perf-norm:sp_cancel_customer_reserve 678 678 0 0.00 0 3939 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 679 679 0 0.00 0 550 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 863 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 423 423 0 0.00 0 1335 14 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 35783 1835 0 0
t$perf-norm:sp_cancel_write_off 994 994 0 0.00 0 1392 7 0 0
t$perf-norm:sp_client_order 20123 20123 0 0.00 0 17065 21 0 0
t$perf-norm:sp_customer_reserve 940 940 0 0.00 0 6947 14 0 0
t$perf-norm:sp_pay_from_customer 6891 6891 0 0.00 0 4073 10 0 0
t$perf-norm:sp_pay_to_supplier 5745 5745 0 0.00 0 5645 12 0 0
t$perf-norm:sp_reserve_write_off 9760 9760 0 0.00 0 6458 11 0 0
t$perf-norm:sp_supplier_invoice 5410 5410 0 0.00 0 14305 26 0 0
t$perf-norm:sp_supplier_order 5272 5272 0 0.00 0 4357 16 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 110 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 3432 25 0 0
t$perf-norm:srv_make_invnt_saldo 548 548 0 0.00 0 1049 28 0 0
t$perf-norm:srv_make_money_saldo 825 825 0 0.00 0 3018 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 10110 9878 232 2.29 0 9052 19 0 232
v_all_customers 36468 36468 0 0.00 0 54 1 0 0
v_all_suppliers 29400 29400 0 0.00 0 172 1 0 0
v_all_wares 40246 40246 0 0.00 0 84 1 0 0
v_cancel_adding_invoice 790 790 0 0.00 0 5420 17 0 0
v_cancel_client_order 3490 3490 0 0.00 0 7581 11 0 0
v_cancel_customer_prepayment 1358 1358 0 0.00 0 9187 18 0 0
v_cancel_customer_reserve 1356 1356 0 0.00 0 3221 11 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 957 5 0 0
v_cancel_supplier_invoice 862 846 16 1.85 0 1940 18 0 16
v_cancel_supplier_order 816 816 0 0.00 0 5948 11 0 0
v_cancel_write_off 1988 1988 0 0.00 0 2272 13 0 0
v_max_id_clo_ord 5271 5271 0 0.00 0 5963 3 0 0
v_max_id_clo_res 940 940 0 0.00 0 1906 18 0 0
v_max_id_ord_sup 5409 5409 0 0.00 0 10628 4 0 0
v_max_non_paid_invoice 1725 1725 0 0.00 0 5559 7 0 0
v_max_non_paid_realizn 3667 3667 0 0.00 0 567 2 0 0
v_min_id_clo_ord 5271 5271 0 0.00 0 1741 4 0 0
v_min_id_clo_res 940 940 0 0.00 0 6445 29 0 0
v_min_id_ord_sup 5409 5409 0 0.00 0 4875 5 0 0
v_min_non_paid_invoice 5745 5745 0 0.00 0 29766 28 0 0
v_min_non_paid_realizn 6891 6891 0 0.00 0 6334 17 0 0
v_our_firm 10226 10226 0 0.00 0 22 1 0 0
v_reserve_write_off 19518 19518 0 0.00 0 9184 9 0 0
x_lock_depdocs_on_canc_invoice 11984 11984 0 0.00 0 11076 133 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 14792 419 0 0
x_make_qstorno_1000_1200 5272 5272 0 0.00 2 26023 1273 0 0
x_make_qstorno_1200_2000 5410 5410 0 0.00 3 91405 3384 0 0
x_make_qstorno_2100_3300 449472 449472 0 0.00 0 73136 183 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-06-2021 01:29:14 to 22-06-2021 01:29:18.

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:48 1 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
22:57:55 27376 8192000000 10287106528 10592391168 844207936 9.342 64 53 111 0 863218528 2403248 16607344
22:58:30 42062 8192000000 10355313696 10673795072 1402365088 14.616 100 92 184 1 1439222688 5806832 31050768
22:59:25 26861 8192000000 10390928560 10714374144 1440991072 14.958 100 92 182 2 1477821616 7042464 29788080
23:00:04 18090 8192000000 10404491328 10733170688 1460524128 15.131 100 87 174 0 1497396208 7662144 29209936
23:00:46 12217 8192000000 10423058800 10755874816 1484348624 15.339 100 90 179 1 1521736976 8213056 29175296
23:01:08 16940 8192000000 10446262096 10781335552 1501215984 15.487 100 86 172 2 1537705632 8935728 27553920
23:01:36 25188 8192000000 10470529296 10815512576 1527223872 15.713 100 77 154 1 1560232240 8977056 24031312
23:02:23 16208 8192000000 10516467008 10867372032 1569955456 16.082 100 74 148 0 1602060480 9084656 23020368
23:02:53 11716 8192000000 10545126144 10902228992 1597462544 16.318 100 70 138 1 1627777344 9139456 21175344
23:03:14 15478 8192000000 10586028672 10943213568 1636987280 16.654 100 74 148 1 1668750448 9871920 21891248
23:03:40 10599 8192000000 10596638624 10962722816 1656443024 16.819 100 76 152 0 1690250304 11133328 22673952
23:03:59 9734 8192000000 10608657248 10980921344 1674665184 16.972 100 73 146 1 1707944000 11165536 22113280
23:04:17 7747 8192000000 10637028512 11005128704 1691662944 17.115 100 78 155 0 1726086064 11429152 22993968
23:04:32 9691 8192000000 10638644464 11008196608 1704335536 17.221 100 87 174 0 1741717104 12059616 25321952
23:04:49 9949 8192000000 10658904192 11030605824 1718121936 17.337 100 76 150 2 1752427648 12848848 21456864
23:05:05 10717 8192000000 10672023184 11047170048 1729526304 17.432 100 84 166 0 1767374672 13544480 24303888
23:05:24 5977 8192000000 10686677392 11059568640 1749108000 17.594 100 88 176 2 1787432144 13562016 24762128
23:05:37 6156 8192000000 10696263632 11075133440 1757932144 17.667 100 83 166 2 1794339888 12858112 23549632
23:05:52 5705 8192000000 10709336352 11087683584 1768007984 17.751 100 76 150 0 1800806288 12184416 20613888
23:06:04 5366 8192000000 10720864752 11099680768 1779571872 17.846 100 86 168 1 1815804304 12730816 23501616
23:06:16 4966 8192000000 10732205024 11111632896 1789016144 17.924 100 90 182 2 1828102928 13499952 25586832
23:06:28 2928 8192000000 10735168160 11116158976 1792202272 17.950 100 83 166 1 1829834896 13552608 24080016
23:06:38 3928 8192000000 10736209408 11120001024 1800561824 18.019 100 83 165 2 1837254000 12677200 24014976
23:06:49 2926 8192000000 10750508096 11129438208 1809347744 18.091 100 86 171 0 1846095968 13400784 23347440
23:06:59 6001 8192000000 10742556528 11132882944 1810292352 18.098 100 77 152 3 1844822064 13828112 20701600
23:07:12 2858 8192000000 10773413776 11154472960 1818299296 18.164 100 90 181 1 1857648816 13907744 25441776
23:07:21 2537 8192000000 10778955696 11165294592 1832677360 18.281 100 84 168 1 1872080000 15158656 24243984
23:07:30 2456 8192000000 10781159232 11166146560 1837285104 18.319 100 89 179 1 1877533712 15018512 25230096
23:07:39 2567 8192000000 10782938048 11168202752 1842804496 18.364 100 85 170 1 1882074816 14977472 24292848
23:07:49 1513 8192000000 10794423696 11181137920 1850998864 18.430 100 89 178 1 1890650160 14690416 24960880
23:07:57 1827 8192000000 10791713808 11183181824 1856227040 18.473 100 89 177 1 1892831520 12246608 24357872
23:08:05 1744 8192000000 10811890224 11197411328 1865297920 18.546 100 91 184 2 1904256128 13041168 25917040
23:08:13 1805 8192000000 10801646992 11189579776 1865930016 18.551 100 90 181 4 1905409488 13740560 25738912
23:08:21 1667 8192000000 10805849280 11197808640 1868444000 18.572 100 91 183 3 1908771936 13910608 26417328
23:08:29 1215 8192000000 10820463872 11210063872 1871208176 18.594 100 89 177 1 1910127120 14088944 24830000
23:08:37 1162 8192000000 10825033760 11216867328 1878442816 18.653 100 96 192 2 1919413408 13683904 27286688
23:08:44 1741 8192000000 10823506848 11213492224 1880679680 18.671 100 88 176 2 1919232880 13596624 24956576
23:08:52 1665 8192000000 10820592256 11215298560 1883066000 18.690 100 94 191 1 1923115952 13656432 26393520
23:09:00 35453 8192000000 10807783856 11214909440 1876456320 18.636 100 63 126 0 1904814832 10700896 17657616
23:09:42 10184 8192000000 10791933152 11208732672 1871756736 18.598 100 32 64 0 1887690416 6544384 9389296
23:09:59 6095 8192000000 10778868448 11210379264 1872123680 18.601 100 24 48 1 1884990256 5987952 6878624
23:10:12 6228 8192000000 10789952880 11214225408 1877518624 18.645 100 32 64 2 1893549296 7758336 8272336
23:10:24 4972 8192000000 10796915408 11218460672 1878716480 18.655 100 32 64 0 1895099792 7563712 8819600
23:10:37 5611 8192000000 10795065040 11222163456 1885704864 18.711 100 35 69 2 1903590144 7694400 10190880
23:10:50 8175 8192000000 10798890384 11227000832 1881633168 18.678 100 15 30 2 1892654560 6188448 4832944
23:11:05 5516 8192000000 10795436976 11228282880 1886766944 18.720 100 36 72 2 1903820320 6950656 10102720
23:11:19 9249 8192000000 10797446272 11229122560 1887142256 18.723 100 22 43 4 1899027072 5707232 6177584
23:11:36 14945 8192000000 10787734160 11230720000 1891133600 18.755 100 16 32 1 1901408752 5794544 4480608
23:12:03 7086 8192000000 10811907136 11239641088 1893427152 18.773 100 23 44 3 1905750512 5422400 6900960
23:12:19 8060 8192000000 10807180272 11238031360 1896441312 18.798 100 19 37 3 1908121760 6728816 4951632
23:12:34 8495 8192000000 10810733088 11246469120 1898668416 18.816 100 28 56 1 1913722672 6326448 8727808
23:12:49 70164 8192000000 10806732432 11251679232 1906309168 18.877 100 38 75 1 1922942736 5470176 11163392
23:14:07 9905 8192000000 10819963776 11253297152 1905006592 18.867 100 23 44 1 1916470624 5882096 5581936
23:14:24 5770 8192000000 10824638784 11257688064 1907729504 18.888 100 32 66 0 1923982176 7089376 9163296
23:14:37 7406 8192000000 10829183536 11259166720 1908057456 18.891 100 34 69 2 1924488704 6905936 9525312
23:14:54 5446 8192000000 10823427664 11261255680 1909288848 18.901 100 20 40 1 1920195728 5606032 5300848
23:15:08 6518 8192000000 10828310192 11264339968 1912718208 18.928 100 24 46 1 1924643520 5422368 6502944
23:15:22 7382 8192000000 10844693168 11267719168 1916540512 18.959 100 28 56 0 1931741280 7092736 8108032
23:15:35 10437 8192000000 10829597648 11266551808 1916837312 18.961 100 22 44 0 1929503824 6322016 6344496
23:15:52 3288 8192000000 10838120480 11269836800 1919226768 18.981 100 31 63 2 1934198288 5988624 8982896
23:16:02 3636 8192000000 10842350128 11271499776 1920524688 18.991 100 40 80 5 1938523216 6226304 11772224
23:16:11 10287 8192000000 10845615584 11278848000 1918890480 18.978 100 19 38 1 1934259024 10461456 4907088
23:16:29 7437 8192000000 10843919520 11279921152 1922149456 19.004 100 23 46 1 1934483120 6021328 6312336
23:16:43 7367 8192000000 10836490720 11266838528 1897340336 18.805 99 19 39 0 1912792192 9427536 6024320
23:16:58 11020 8192000000 10819978656 11259179008 1894046064 18.778 99 20 41 1 1905516640 5451792 6018784
23:17:20 47137 8192000000 10810619856 11239542784 1867110000 18.561 98 44 87 3 1886456800 6214720 13132080
23:18:16 7002 8192000000 10787839200 11224506368 1852570464 18.443 98 18 36 1 1863224064 5606368 5047232
23:18:29 5828 8192000000 10791734032 11225554944 1871753616 18.598 99 25 49 3 1885182544 5662336 7766592
23:18:41 9592 8192000000 10764787376 11186708480 1759619216 17.681 94 27 54 1 1773254800 6037104 7598480
23:18:59 3999 8192000000 10767168432 11189882880 1848329392 18.409 100 38 76 1 1865904608 6845424 10729792
23:19:10 4743 8192000000 10772268848 11190149120 1821386560 18.189 98 36 72 0 1838183216 6431936 10364720
23:19:21 6581 8192000000 10735741664 11151204352 1794258128 17.967 97 22 44 1 1806926896 6689424 5979344
23:19:34 7599 8192000000 10738493456 11165687808 1784597616 17.887 96 29 58 0 1798743888 5879088 8267184
23:19:48 6031 8192000000 10736814112 11155783680 1760954640 17.692 96 23 46 2 1777620832 9989488 6676704
23:20:02 10838 8192000000 10708274256 11124297728 1720310800 17.355 94 26 53 0 1733621904 5240112 8070992
23:20:24 6126 8192000000 10715608784 11128979456 1751608976 17.615 97 22 44 1 1764096304 5573248 6914080
23:20:37 10568 8192000000 10697092992 11108884480 1707892992 17.251 95 14 28 0 1721332976 9741984 3698000
23:20:54 7860 8192000000 10675548112 11093319680 1736840224 17.492 98 34 68 2 1752696064 5892032 9963808
23:21:09 9907 8192000000 10686313184 11093975040 1698008800 17.168 95 16 32 1 1708028784 5092656 4927328
23:21:28 13512 8192000000 10710819936 11117555712 1753600848 17.631 98 42 84 0 1776055984 9801520 12653616
23:21:48 74376 8192000000 10708784960 11134005248 1736594176 17.490 96 27 54 2 1749978688 5329888 8054624
23:23:10 9286 8192000000 10747922032 11153428480 1797100752 17.990 99 37 75 2 1814715440 7218256 10396432
23:23:25 5084 8192000000 10752241440 11169554432 1830436880 18.263 100 30 60 0 1845761712 7369104 7955728
23:23:38 5095 8192000000 10755245408 11177357312 1837040176 18.317 100 35 69 0 1853578512 6802704 9735632
23:23:50 4230 8192000000 10776993664 11191910400 1845819376 18.388 100 46 92 0 1866300976 7367824 13113776
23:24:00 5673 8192000000 10781240816 11198173184 1853211808 18.448 100 39 79 0 1872012240 7157440 11642992
23:24:12 4258 8192000000 10786997712 11205066752 1856427776 18.474 100 40 80 1 1875519104 7491040 11600288
23:24:23 4031 8192000000 10780099008 11199348736 1857870528 18.486 100 39 78 0 1875337472 5485648 11981296
23:24:36 7321 8192000000 10776893344 11203035136 1859589616 18.500 100 23 46 2 1871825440 5937392 6298432
23:24:50 10720 8192000000 10775759264 11211710464 1866976224 18.560 100 16 32 1 1878147824 5925344 5246256
23:25:10 5009 8192000000 10787971424 11214028800 1869239696 18.578 100 27 54 2 1883222064 6506000 7476368
23:25:22 8621 8192000000 10782616816 11215142912 1869751776 18.582 100 22 44 3 1880917184 4727776 6437632
23:25:37 10167 8192000000 10791466000 11220275200 1876506656 18.637 100 22 44 1 1888273504 5452160 6314688
23:25:54 5385 8192000000 10798815088 11226103808 1879134720 18.658 100 35 70 0 1895121408 6192544 9794144
23:26:10 57353 8192000000 10817311440 11233959936 1881080272 18.674 100 28 55 2 1894246048 5694032 7471744
23:27:15 29506 8192000000 10806834416 11240808448 1894710496 18.784 100 16 32 0 1903692144 4573856 4407792
23:27:52 30676 8192000000 10834789072 11256131584 1910294352 18.909 100 50 101 1 1930338960 6087968 13956640
23:28:35 9131 8192000000 10857686112 11274326016 1920727632 18.993 100 60 120 1 1947371232 8167168 18476432
23:28:51 13016 8192000000 10869739792 11289055232 1929570432 19.063 100 63 127 0 1957563056 10123248 17869376
23:29:12 8270 8192000000 10864447680 11286487040 1933128160 19.092 100 54 108 0 1958194832 9745344 15321328
23:29:28 3241 8192000000 10889669232 11300016128 1945910704 19.194 100 75 147 1 1977102832 10311360 20880768
23:29:39 2485 8192000000 10898109424 11305586688 1949780496 19.225 100 82 159 1 1982897200 10936432 22180272
23:29:49 14381 8192000000 10892166304 11313381376 1951354784 19.237 100 67 131 0 1981783840 12276480 18152576
23:30:15 15099 8192000000 10884375440 11316486144 1951382448 19.237 100 52 102 3 1978174176 12120608 14671120
23:30:43 21663 8192000000 10881282560 11318730752 1952149328 19.244 100 44 88 0 1975464384 10970848 12344208
23:31:18 30527 8192000000 10896217376 11325964288 1955789280 19.273 100 32 61 0 1976398224 12090032 8518912
23:32:02 14018 8192000000 10908044176 11339853824 1968449744 19.373 100 50 100 0 1999767840 16288096 15030000
23:32:25 8385 8192000000 10915182128 11342774272 1971577856 19.398 100 50 100 0 2002601616 16641504 14382256
23:32:43 4094 8192000000 10923736016 11350745088 1977346096 19.444 100 59 118 0 2012042080 16777728 17918256
23:32:55 12655 8192000000 10917842848 11350966272 1981787984 19.479 100 60 120 0 2016503504 17807888 16907632
23:33:15 17272 8192000000 10936172080 11360538624 1985153536 19.505 100 59 118 2 2021261216 19241488 16866192
23:33:42 8998 8192000000 10939467808 11365715968 1986022016 19.512 100 54 108 0 2020873872 19493600 15358256
23:34:01 4475 8192000000 10946550912 11370868736 1991877504 19.559 100 62 124 3 2030457232 20438448 18141280
23:34:12 2676 8192000000 10950792544 11370852352 1995738464 19.589 100 80 158 2 2038577504 19889952 22949088
23:34:34 8875 8192000000 10944256208 11375861760 1996022816 19.591 100 60 120 0 2036523136 22514944 17985376
23:34:57 14513 8192000000 10939843888 11376439296 1987934608 19.527 100 49 98 0 2026242736 23167296 15140832
23:35:19 8317 8192000000 10955456368 11382738944 1999422864 19.618 100 68 133 2 2045251712 25666448 20162400
23:35:36 3971 8192000000 10963414784 11384774656 2003142096 19.648 100 78 151 4 2050022304 25091312 21788896
23:35:46 5859 8192000000 10958720928 11383599104 2005454672 19.666 100 69 137 1 2050404944 25629376 19320896
23:36:00 10752 8192000000 10973364864 11393609728 2008068320 19.686 100 84 169 2 2060620080 28187072 24364688
23:36:19 7128 8192000000 10965087248 11392335872 2005136176 19.663 100 71 140 0 2057947536 31528144 21283216
23:36:33 10343 8192000000 10971567168 11398434816 2004984032 19.662 100 58 116 0 2053206384 30787504 17434848
23:36:54 6348 8192000000 10944331744 11377324032 1989626176 19.541 100 61 122 1 2039122560 30645936 18850448
23:37:10 3948 8192000000 10951944160 11382984704 1990624800 19.549 100 60 118 1 2038016800 29816592 17575408
23:37:22 3651 8192000000 10954167248 11386163200 2000389280 19.626 100 73 145 0 2051476800 29253504 21834016
23:37:35 10119 8192000000 10962033968 11395031040 2003778928 19.653 100 66 130 2 2054988368 30910000 20299440
23:37:54 5302 8192000000 10965935088 11399954432 2005855824 19.669 100 63 122 3 2055886272 31752576 18277872
23:38:08 2254 8192000000 10960158240 11390566400 1987742864 19.526 99 70 139 0 2037786384 29488704 20554816
23:38:17 4025 8192000000 10960240912 11385749504 1996692384 19.597 100 67 133 2 2046886272 29730192 20463696
23:38:30 7346 8192000000 10959110784 11385925632 1994823120 19.582 100 67 134 1 2047213008 31538512 20851376
23:38:46 5901 8192000000 10957487136 11381952512 1973356080 19.412 99 64 127 1 2024468512 31570512 19541920
23:39:00 3377 8192000000 10941268304 11371380736 1979594736 19.461 100 69 135 2 2031982656 31770224 20617696
23:39:14 3992 8192000000 10934427552 11362152448 1964587776 19.342 100 71 140 0 2017419088 31592368 21238944
23:39:26 7612 8192000000 10927472848 11353862144 1959960976 19.306 99 71 142 0 2014481168 32384336 22135856
23:39:41 1984 8192000000 10960215728 11379212288 1985063600 19.505 100 76 149 2 2039724656 31975248 22685808
23:39:49 6661 8192000000 10942667888 11368574976 1965325568 19.348 99 71 142 1 2020170112 33049872 21794672
23:40:03 8013 8192000000 10940795264 11374710784 1980851520 19.471 100 73 146 0 2037145536 34632880 21661136
23:40:19 8412 8192000000 10940414288 11375980544 1981711024 19.478 100 60 118 1 2031011104 31822560 17477520
23:40:34 4760 8192000000 10963664096 11385622528 1986604768 19.517 100 76 150 1 2041310976 32174944 22531264
23:40:46 12564 8192000000 10955666368 11386191872 1973497408 19.413 99 62 124 0 2027834528 35714560 18622560
23:41:06 2167 8192000000 10951056544 11373953024 1979056944 19.457 99 69 135 1 2031979728 33147264 19775520
23:41:15 3635 8192000000 10943520816 11361808384 1948599552 19.215 98 75 143 4 2002824896 33629088 20596256
23:41:27 2229 8192000000 10973757104 11388641280 1990128592 19.545 100 89 176 3 2052567392 35837184 26601616
23:41:36 2854 8192000000 10961872112 11384385536 1982669040 19.486 100 75 150 0 2040473408 36288960 21515408
23:41:47 1664 8192000000 10965090608 11383054336 1985693248 19.510 100 89 176 1 2049295248 37493280 26108720
23:41:57 11745 8192000000 10959451248 11389390848 1986100496 19.513 100 68 132 3 2046048256 40191696 19756064
23:42:16 11940 8192000000 10963141888 11397451776 1993777472 19.574 100 59 118 0 2048743024 36915168 18050384
23:42:37 1705 8192000000 10971831072 11390267392 1987837600 19.527 100 81 161 6 2052472864 39294704 25340560
23:42:46 5119 8192000000 10933124400 11348238336 1952597744 19.247 99 82 162 1 2014907872 37455536 24854592
23:43:01 5559 8192000000 10943489296 11365994496 1953127696 19.251 99 70 138 2 2015190656 41416384 20646576
23:43:21 1412 8192000000 10948762784 11369463808 1968418112 19.373 100 77 154 0 2032773200 40357552 23997536
23:43:31 6433 8192000000 10921866096 11355623424 1939161312 19.140 99 41 81 0 1992386880 40500912 12724656
23:44:07 8365 8192000000 10922359728 11338604544 1890939760 18.753 96 61 121 0 1951707984 42305648 18462576
23:44:23 1579 8192000000 10956670624 11371950080 1965391040 19.349 100 73 140 1 2031794992 44864016 21539936
23:44:33 6311 8192000000 10943458368 11372191744 1964952032 19.345 100 64 128 2 2031046528 46095488 19999008
23:44:46 3487 8192000000 10932297824 11356139520 1938113904 19.132 99 60 119 2 2002431344 44838256 19479184
23:45:12 9021 8192000000 10936580848 11370668032 1965558304 19.350 100 52 104 0 2026437344 44127936 16751104
23:45:29 3700 8192000000 10947246608 11364003840 1962525472 19.326 100 67 129 1 2022687968 38769584 21392912
23:45:39 3414 8192000000 10950196832 11368996864 1968099984 19.370 100 72 142 1 2032460208 41334624 23025600
23:45:53 7685 8192000000 10963216592 11383468032 1978508592 19.453 100 70 138 0 2042504640 43217168 20778880
23:46:10 5131 8192000000 10970528848 11385843712 1978887680 19.456 100 78 156 2 2048420496 45712240 23820576
23:46:21 2610 8192000000 10989078928 11403206656 1993556576 19.572 100 92 180 2 2068623632 46738864 28328192
23:46:32 1007 8192000000 10991119360 11405193216 1995558048 19.588 100 92 182 2 2071869792 46709248 29602496
23:46:40 1302 8192000000 10960427552 11368951808 1964755088 19.344 100 88 175 4 2038653536 47831984 26066464
23:46:48 2542 8192000000 10983802064 11389775872 1977936912 19.448 100 89 180 0 2057083424 51417440 27729072
23:46:58 1883 8192000000 10988214896 11398664192 1989086720 19.537 100 91 183 2 2070837824 52986624 28764480
23:47:07 3423 8192000000 10984174352 11401617408 1985072624 19.505 100 76 148 2 2063683744 55023072 23588048
23:47:19 1643 8192000000 10993186032 11409145856 1994456048 19.579 100 85 170 1 2076024944 54702720 26866176
23:47:30 3849 8192000000 10999681040 11417124864 1995591456 19.588 100 81 160 2 2077275184 56731744 24951984
23:47:41 4805 8192000000 10994131552 11412451328 1995856000 19.590 100 82 163 1 2078473040 56853120 25763920
23:47:53 4131 8192000000 10972664000 11410419712 1985886240 19.511 100 67 134 0 2065334128 57983984 21463904
23:48:07 6267 8192000000 10965179056 11396919296 1990922560 19.551 100 59 116 1 2052585360 43491136 18171664
23:48:25 1824 8192000000 10954372464 11377360896 1971362976 19.396 99 65 130 0 2036691328 43714032 21614320
23:48:35 2746 8192000000 10967538784 11372744704 1955097184 19.267 99 86 172 0 2029878960 46966864 27814912
23:48:51 2194 8192000000 10957854528 11370868736 1962078512 19.323 100 71 142 0 2031848320 47281664 22488144
23:49:00 5365 8192000000 10958204416 11373469696 1952024256 19.243 99 71 141 0 2026269424 50836416 23408752
23:49:14 2863 8192000000 10970832320 11388678144 1978265984 19.451 100 81 162 0 2056325040 51703744 26355312
23:49:29 2545 8192000000 10952750352 11376234496 1940382288 19.150 98 62 124 0 2014979424 54409568 20187568
23:49:41 13368 8192000000 10928383200 11370831872 1938242336 19.133 99 38 76 3 2004499088 52706448 13550304
23:50:10 10555 8192000000 10951974928 11383365632 1943160576 19.172 99 41 81 3 2010104000 52515216 14428208
23:50:28 12126 8192000000 10949752080 11395604480 1973249152 19.411 100 52 104 0 2047306992 55786768 18271072
23:50:50 7022 8192000000 10950240000 11387314176 1952744224 19.248 99 42 83 2 2021152640 54348304 14060112
23:51:06 10304 8192000000 10954824880 11393507328 1964225136 19.340 100 44 87 1 2034948976 55757360 14966480
23:51:27 15402 8192000000 10934201024 11381129216 1925733072 19.033 98 31 62 1 1992271888 55054272 11484544
23:51:55 11301 8192000000 10937677344 11385319424 1960523600 19.310 100 32 65 1 2023876912 52475808 10877504
23:52:27 8523 8192000000 10939142016 11385556992 1963038080 19.330 100 34 66 2 2022194528 48042976 11113472
23:52:57 12923 8192000000 10928161696 11382267904 1954987456 19.266 100 29 58 2 2017559408 52239760 10332192
23:53:45 20612 8192000000 10930293600 11380359168 1951117616 19.235 100 26 50 1 2010998800 50179680 9701504
23:54:15 12421 8192000000 10938093072 11389620224 1956764128 19.280 100 33 65 4 2023030992 54508496 11758368
23:54:46 35520 8192000000 10924478080 11381891072 1939563088 19.143 99 30 60 1 2003935920 53557792 10815040
23:55:29 26224 8192000000 10913758832 11390758912 1941017200 19.155 100 18 36 0 2002492608 54204416 7270992
23:56:12 38888 8192000000 10847215376 11311316992 1860997824 18.511 96 23 46 2 1906830784 38213056 7619904
23:57:02 74494 8192000000 10867633008 11322851328 1888976848 18.738 97 17 34 2 1908597568 15267664 4353056
23:58:37 106626 8192000000 10875208512 11333533696 1922928176 19.010 99 20 40 1 1940879696 12214400 5737120
00:01:16 33803 8192000000 10880516256 11330396160 1929622784 19.064 99 35 72 3 1950029664 9823344 10583536
00:01:56 25927 8192000000 10881948720 11335348224 1941187776 19.156 100 25 50 0 1957070352 8672032 7210544
00:02:32 8163 8192000000 10895660144 11341623296 1959997904 19.306 100 45 85 3 1979271696 7700896 11572896
00:02:47 21415 8192000000 10891024832 11354468352 1965598000 19.351 100 30 60 4 1984813792 10938816 8276976
00:03:28 92469 8192000000 10905464816 11384156160 1984582288 19.501 100 18 36 1 2004621120 14355648 5683184
00:05:16 38355 8192000000 10902562832 11382116352 1974955872 19.425 100 12 25 1 1999108688 20019888 4132928
00:06:38 118862 8192000000 10914886688 11383869440 1967295488 19.364 99 31 63 2 1987704208 11406448 9002272
00:08:43 70844 8192000000 10921390400 11397087232 1989511568 19.540 100 24 48 0 2012449056 16495152 6442336
00:10:23 68686 8192000000 10908812240 11381235712 1964110576 19.339 99 26 50 2 1985089696 13572448 7406672
00:12:45 94641 8192000000 10902250912 11363708928 1937929728 19.130 98 27 54 1 1955973568 9073680 8970160
00:14:26 79854 8192000000 10896942672 11357044736 1911830736 18.921 97 18 36 0 1932110608 14916896 5362976
00:15:58 35875 8192000000 10881375184 11360313344 1945100304 19.187 99 23 46 1 1972706208 21120944 6484960
00:16:45 23345 8192000000 10913657296 11372716032 1971654128 19.399 100 28 56 0 1994571904 14764544 8153232
00:17:16 43205 8192000000 10899928480 11374571520 1978770512 19.455 100 24 48 2 1997229552 11492512 6966528
00:18:24 54409 8192000000 10904423056 11386134528 1981394464 19.476 100 30 60 2 2004151200 13350400 9406336
00:20:40 47071 8192000000 10894826864 11372662784 1965570832 19.350 99 23 45 0 1980267248 8458368 6238048
00:22:59 75100 8192000000 10908046192 11355553792 1938553136 19.135 98 17 30 3 1952510080 8490592 5466352
00:24:31 44371 8192000000 10858648336 11327234048 1874804992 18.623 95 25 50 1 1887866752 6491216 6570544
00:25:32 51495 8192000000 10872489872 11353210880 1952559392 19.247 100 14 27 3 1965723264 9593104 3570768
00:26:32 71574 8192000000 10883080320 11366985728 1935330784 19.109 98 11 22 0 1949102160 10917472 2853904
00:27:51 61521 8192000000 10864462240 11339132928 1911492960 18.919 97 15 30 0 1928595104 13117792 3984352
00:28:59 43955 8192000000 10901029744 11367399424 1951671744 19.240 99 24 46 1 1968140224 10554160 5914320
00:29:57 85996 8192000000 10896568000 11380543488 1941162656 19.156 98 8 15 2 1953336960 10367680 1806624
00:31:35 67063 8192000000 10898028464 11349917696 1901867392 18.841 96 7 14 0 1911778384 8251312 1659680
00:32:48 58930 8192000000 10878353184 11340648448 1857634976 18.484 94 24 48 0 1877100656 12617184 6848496
00:33:53 112033 8192000000 10879522496 11371028480 1902099248 18.843 97 12 24 0 1923126992 17582128 3445616
00:35:52 27048 8192000000 10903628752 11353894912 1945016096 19.187 99 40 80 2 1968350832 11392896 11941840
00:36:27 15428 8192000000 10925483952 11379257344 1969033632 19.378 100 42 84 2 1996256032 16199216 11023184
00:36:52 38848 8192000000 10904225888 11374964736 1939669824 19.144 98 40 80 2 1974742720 23868096 11204800
00:37:40 42269 8192000000 10880466112 11352481792 1904749952 18.864 97 18 36 1 1924406240 14481328 5174960
00:39:00 117169 8192000000 10865624032 11335618560 1840034576 18.341 94 8 16 0 1857645136 15594656 2015904
00:41:06 124181 8192000000 10863499056 11329269760 1887287104 18.724 97 23 46 1 1902433424 8327648 6818672
00:43:16 101309 8192000000 10834089360 11287408640 1716153632 17.320 88 23 46 0 1728239936 5823264 6263040
00:45:22 43613 8192000000 10837353952 11308572672 1862705744 18.525 97 18 36 1 1878894368 10787392 5401232
00:46:12 56977 8192000000 10839216160 11323387904 1918962560 18.979 100 8 16 0 1933674032 12670576 2040896
00:47:57 52505 8192000000 10845054192 11318083584 1887929152 18.729 98 16 32 1 1900082944 7838624 4315168
00:48:57 95393 8192000000 10850778960 11316441088 1881773728 18.679 97 20 40 1 1899271200 11342016 6155456
00:50:39 79065 8192000000 10853310608 11330076672 1912353536 18.926 99 17 34 1 1934505088 17223472 4928080
00:52:09 84068 8192000000 10855685616 11323617280 1849300176 18.416 96 12 24 1 1870170720 17350064 3520480
00:53:40 46186 8192000000 10856077968 11314900992 1874999104 18.625 97 21 42 0 1891340464 10715264 5626096
00:54:32 21017 8192000000 10897820400 11336310784 1938497296 19.135 100 57 112 2 1963935440 8026832 17411312
00:54:59 21877 8192000000 10876697712 11332792320 1928316304 19.053 99 46 92 1 1952622256 11699984 12605968
00:55:41 70205 8192000000 10875168416 11346399232 1947287408 19.205 100 15 30 0 1961063632 9511920 4264304
00:56:57 29464 8192000000 10883357216 11333115904 1894183344 18.779 97 31 60 1 1909590016 7672288 7734384
00:57:35 36891 8192000000 10845475792 11298119680 1857690000 18.485 95 39 78 1 1878703200 10818112 10195088
00:58:18 57070 8192000000 10886724320 11349118976 1941928544 19.162 100 28 56 0 1960442160 11255568 7258048
00:59:36 59885 8192000000 10903414928 11360354304 1954851728 19.265 99 38 76 0 1979840240 14478368 10510144
01:00:42 86571 8192000000 10920384384 11385540608 1957531600 19.286 99 16 32 0 1978709984 16994224 4184160
01:02:15 60957 8192000000 10930284144 11389018112 1948586592 19.215 98 23 46 0 1965334400 10592864 6154944
01:03:26 70699 8192000000 10916677360 11398696960 1973915728 19.416 99 22 44 1 1995560032 15832784 5811520
01:04:43 100901 8192000000 10909629968 11380707328 1930119712 19.068 97 12 24 0 1950364464 16473472 3771280
01:07:17 60993 8192000000 10902916800 11378589696 1955781872 19.272 99 17 34 1 1971781280 11108032 4891376
01:08:24 42104 8192000000 10891905376 11371679744 1956135952 19.275 99 23 47 1 1978165616 14275024 7754640
01:09:22 82506 8192000000 10913369904 11395932160 1983226128 19.490 100 8 16 0 1996808656 11145200 2437328
01:10:50 76000 8192000000 10873774224 11350601728 1933897776 19.098 97 17 34 2 1958235984 19081664 5256544
01:12:17 28760 8192000000 10891272096 11362324480 1920682304 18.992 97 26 52 0 1937981424 10158608 7140512
01:12:56 64949 8192000000 10878218608 11361595392 1911413344 18.918 97 15 30 1 1933823808 18164192 4246272
01:14:07 66312 8192000000 10895551824 11376136192 1945438752 19.190 99 10 20 0 1961843744 13241184 3163808
01:15:20 48009 8192000000 10889994112 11369418752 1957372720 19.285 99 17 34 2 1973141664 11287792 4481152
01:16:16 46416 8192000000 10914229472 11360215040 1899308848 18.821 96 30 60 0 1916842112 9260512 8272752
01:17:09 63658 8192000000 10890194256 11355717632 1927737504 19.049 98 33 66 1 1952378960 15205328 9436128
01:18:36 43072 8192000000 10874193120 11330207744 1873398992 18.612 96 36 70 1 1895451088 11767312 10284784
01:19:26 59362 8192000000 10873891376 11349446656 1903310240 18.853 98 22 44 1 1919792288 10356224 6125824
01:20:31 48284 8192000000 10874793504 11338162176 1917651312 18.968 98 20 40 2 1939075136 15589968 5833856
01:22:40 28407 8192000000 10910713264 11374432256 1956531136 19.278 100 35 70 1 1990356560 23798496 10026928
01:23:19 41922 8192000000 10894971296 11367538688 1896463312 18.798 97 38 74 2 1930941952 24090304 10388336
01:24:10 117203 8192000000 10886508128 11373613056 1916570704 18.959 98 9 18 0 1933249040 15049600 1628736
01:26:14 110544 8192000000 9359218336 9644888064 482804736 5.565 25 6 9 1 486266592 1912080 1549776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 22-06-2021 01:29:20 to 22-06-2021 01:29:52.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 116 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 22-06-2021 01:29:53 to 22-06-2021 01:29:55.

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          236120
MON$OLDEST_ACTIVE               236511
MON$OLDEST_SNAPSHOT             236511
MON$NEXT_TRANSACTION            236511
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                       2031008
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 ---
:189: 
:190: mscs-test-161.budzdorov.ru    Tue Jun 22 01:28:07 2021
:191:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:192: 
:193: 
:194: mscs-test-161.budzdorov.ru    Tue Jun 22 01:28:07 2021
:195:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:196: 
:197: 
:198: mscs-test-161.budzdorov.ru    Tue Jun 22 01:28:07 2021
:199:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:200: 
:201: 
:202: mscs-test-161.budzdorov.ru    Tue Jun 22 01:28:07 2021
:203:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:204: 
--- end of diff output ---

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

22.06.21 01:29:56. 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-22 01:29:58 No severe PSQL-related problems occured
22.06.21 01:29:59. End of report.