Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.04.2021 16:34
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 df9f488d08424df294c459d6c283e9c3
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-03-04 16:07
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.26
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 17338412 kB
MemAvailable 31418824 kB
Buffers 0 kB
Cached 14306136 kB
SwapCached 0 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-04-04 16:33:26
DTS_END                         2021-04-04 16:33:26.3700
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60574
TRN_ID                          227046
ATT_ID                          598
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: 9113.76 22098 1093651
customer order: creation 165.03 336 19803
customer order: refuse 14.31 402 1717
order to supplier: creation 44.58 1403 5350
order to supplier: removal 3.48 117227 417
invoice (draft): creation 44.46 3718 5335
invoice (draft): removal 52.33 960 6280
invoice accept: apply 40.67 18995 4881
invoice accept: cancel 47.51 943 5701
customer reserve: creation 3750.53 188 450064
customer reserve: removal 4669.47 68 560336
realization accept: apply 80.45 177 9654
realization accept: cancel 77.11 131 9253
payment from customer: creation 56.48 128 6777
payment from customer: removal 5.30 90 636
payment to supplier: creation 46.58 137 5590
payment to supplier: removal 3.16 83 379
service: total inventory turnovers 4.82 1068 578
service: total monetary turnovers 6.74 28 809
service: aggregate perf. data 0.73 26126 87
service: refresh index statistics 0.03 269746 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-04-2021 16:34:40 to 04-04-2021 16:34:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4304
TEST_TIME 2 4725
TEST_TIME 3 4793
TEST_TIME 4 4157
TEST_TIME 5 4018
TEST_TIME 6 4177
TEST_TIME 7 4336
TEST_TIME 8 4813
TEST_TIME 9 4871
TEST_TIME 10 4865
TEST_TIME 11 5219
TEST_TIME 12 5155
TEST_TIME 13 5472
TEST_TIME 14 5613
TEST_TIME 15 5707
TEST_TIME 16 5723
TEST_TIME 17 5618
TEST_TIME 18 6335
TEST_TIME 19 6323
TEST_TIME 20 6451
TEST_TIME 21 6803
TEST_TIME 22 6973
TEST_TIME 23 6985
TEST_TIME 24 6915
TEST_TIME 25 7378
TEST_TIME 26 7589
TEST_TIME 27 7541
TEST_TIME 28 7545
TEST_TIME 29 8098
TEST_TIME 30 8478
TEST_TIME 31 9228
TEST_TIME 32 9875
TEST_TIME 33 9675
TEST_TIME 34 9714
TEST_TIME 35 10062
TEST_TIME 36 9872
TEST_TIME 37 9796
TEST_TIME 38 9584
TEST_TIME 39 9382
TEST_TIME 40 9368
TEST_TIME 41 9553
TEST_TIME 42 9552
TEST_TIME 43 9522
TEST_TIME 44 9360
TEST_TIME 45 9277
TEST_TIME 46 9369
TEST_TIME 47 9275
TEST_TIME 48 9280
TEST_TIME 49 9403
TEST_TIME 50 9295
TEST_TIME 51 9320
TEST_TIME 52 9343
TEST_TIME 53 9242
TEST_TIME 54 9224
TEST_TIME 55 9206
TEST_TIME 56 9188
TEST_TIME 57 9128
TEST_TIME 58 9091
TEST_TIME 59 8966
TEST_TIME 60 9000
TEST_TIME 61 8975
TEST_TIME 62 9039
TEST_TIME 63 9027
TEST_TIME 64 9026
TEST_TIME 65 9052
TEST_TIME 66 9062
TEST_TIME 67 9231
TEST_TIME 68 9201
TEST_TIME 69 9224
TEST_TIME 70 9248
TEST_TIME 71 9221
TEST_TIME 72 9380
TEST_TIME 73 9360
TEST_TIME 74 9502
TEST_TIME 75 9562
TEST_TIME 76 9496
TEST_TIME 77 9424
TEST_TIME 78 9397
TEST_TIME 79 9349
TEST_TIME 80 9330
TEST_TIME 81 9380
TEST_TIME 82 9295
TEST_TIME 83 9339
TEST_TIME 84 9287
TEST_TIME 85 9244
TEST_TIME 86 9230
TEST_TIME 87 9223
TEST_TIME 88 9213
TEST_TIME 89 9190
TEST_TIME 90 9243
TEST_TIME 91 9230
TEST_TIME 92 9230
TEST_TIME 93 9212
TEST_TIME 94 9223
TEST_TIME 95 9310
TEST_TIME 96 9319
TEST_TIME 97 9277
TEST_TIME 98 9368
TEST_TIME 99 9355
TEST_TIME 100 9416
TEST_TIME 101 9439
TEST_TIME 102 9413
TEST_TIME 103 9398
TEST_TIME 104 9355
TEST_TIME 105 9342
TEST_TIME 106 9329
TEST_TIME 107 9331
TEST_TIME 108 9303
TEST_TIME 109 9264
TEST_TIME 110 9252
TEST_TIME 111 9276
TEST_TIME 112 9229
TEST_TIME 113 9198
TEST_TIME 114 9182
TEST_TIME 115 9162
TEST_TIME 116 9116
TEST_TIME 117 9160
TEST_TIME 118 9178
TEST_TIME 119 9175
TEST_TIME 120 9121

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-04-2021 16:34:43 to 04-04-2021 16:34:47.

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 1510193 1510193 0 0.00 0 30651 7 0 0
doc_list_biud 1510182 1510182 0 0.00 0 34922 32 0 0
sp_add_invoice_to_stock 5025 4881 144 2.86 54 175000 18995 0 144
sp_cancel_adding_invoice 5701 5701 0 0.00 4 88955 943 0 0
sp_cancel_client_order 1717 1717 0 0.00 4 20349 402 0 0
sp_cancel_customer_reserve 560336 560336 0 0.00 1 34923 68 0 0
sp_cancel_pay_from_customer 636 636 0 0.00 3 6804 90 0 0
sp_cancel_pay_to_supplier 379 379 0 0.00 3 5568 84 0 0
sp_cancel_supplier_invoice 6294 6280 14 0.22 1 30849 961 0 14
sp_cancel_supplier_order 417 417 0 0.00 5 1271221 117228 0 0
sp_cancel_write_off 9253 9253 0 0.00 1 28207 131 0 0
sp_client_order 19803 19803 0 0.00 3 34906 337 0 0
sp_customer_reserve 450064 450064 0 0.00 0 69803 189 0 0
sp_fill_shopping_cart 30482 30482 0 0.00 1 15517 39 0 0
sp_fill_shopping_cart_clo_res 450044 450044 0 0.00 0 14349 13 0 0
sp_get_clo_for_invoice 4856 4856 0 0.00 0 23649 261 0 0
sp_kill_cost_storno 15969 15969 0 0.00 0 17114 70 0 0
sp_kill_qstorno_ret_qs2qd 1136622 1136622 0 0.00 0 34893 37 0 0
sp_kill_qty_storno 598211 598211 0 0.00 0 34922 80 0 0
sp_lock_selected_doc 20109 20109 0 0.00 0 6324 3 0 0
sp_make_cost_storno 26874 26874 0 0.00 0 21590 55 0 0
sp_multiply_rows_for_pdistr 26874 26874 0 0.00 0 20649 32 0 0
sp_multiply_rows_for_qdistr 19803 19803 0 0.00 0 34891 161 0 0
sp_pay_from_customer 6777 6777 0 0.00 4 20663 128 0 0
sp_pay_to_supplier 5590 5590 0 0.00 5 21876 137 0 0
sp_payment_common 12367 12367 0 0.00 1 16331 39 0 0
sp_qd_handle_on_cancel_clo 1717 1717 0 0.00 0 20328 382 0 0
sp_qd_handle_on_invoice_upd_sts 10554 10554 0 0.00 0 16284 370 0 0
sp_qd_handle_on_reserve_upd_sts 9654 9654 0 0.00 0 21399 60 0 0
sp_reserve_write_off 9654 9654 0 0.00 6 21900 178 0 0
sp_supplier_invoice 5335 5335 0 0.00 5 80146 3718 0 0
sp_supplier_order 5350 5350 0 0.00 5 36341 1403 0 0
srv_aggregate_perf_data 87 87 0 0.00 3016 252759 26127 0 0
srv_fill_mon_cache_memory 177 177 0 0.00 1354 124654 29697 0 0
srv_find_qd_qs_mism 1047521 1047521 0 0.00 0 30650 6 0 0
srv_make_invnt_saldo 578 578 0 0.00 44 37676 1069 0 0
srv_make_money_saldo 809 809 0 0.00 1 2951 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 169461 346525 269746 0 0
t$perf-abend:sp_add_invoice_to_stock 144 144 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4881 4881 0 0.00 0 15168 202 0 0
t$perf-norm:sp_cancel_adding_invoice 439 439 0 0.00 0 6215 127 0 0
t$perf-norm:sp_cancel_client_order 1717 1717 0 0.00 0 2393 21 0 0
t$perf-norm:sp_cancel_customer_reserve 612 612 0 0.00 0 674 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 636 636 0 0.00 0 1774 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 379 379 0 0.00 0 148 1 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 1040 18 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 32032 1891 0 0
t$perf-norm:sp_cancel_write_off 1000 1000 0 0.00 0 3143 6 0 0
t$perf-norm:sp_client_order 19803 19803 0 0.00 0 8872 22 0 0
t$perf-norm:sp_customer_reserve 950 950 0 0.00 0 4441 11 0 0
t$perf-norm:sp_pay_from_customer 6777 6777 0 0.00 0 7233 12 0 0
t$perf-norm:sp_pay_to_supplier 5590 5590 0 0.00 0 7355 10 0 0
t$perf-norm:sp_reserve_write_off 9654 9654 0 0.00 0 5254 13 0 0
t$perf-norm:sp_supplier_invoice 5335 5335 0 0.00 0 8013 21 0 0
t$perf-norm:sp_supplier_order 5350 5350 0 0.00 0 10746 19 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 631 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 177 177 0 0.00 0 640 9 0 0
t$perf-norm:srv_make_invnt_saldo 578 578 0 0.00 0 1676 24 0 0
t$perf-norm:srv_make_money_saldo 809 809 0 0.00 0 1533 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 9994 9706 288 2.88 0 5334 16 0 288
v_all_customers 36128 36128 0 0.00 0 21 1 0 0
v_all_suppliers 29830 29830 0 0.00 0 21 1 0 0
v_all_wares 39606 39606 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 878 878 0 0.00 0 439 6 0 0
v_cancel_client_order 3434 3434 0 0.00 0 1782 5 0 0
v_cancel_customer_prepayment 1272 1272 0 0.00 0 869 6 0 0
v_cancel_customer_reserve 1224 1224 0 0.00 0 3529 10 0 0
v_cancel_payment_to_supplier 758 758 0 0.00 0 396 4 0 0
v_cancel_supplier_invoice 832 804 28 3.36 0 1328 16 0 28
v_cancel_supplier_order 834 834 0 0.00 0 4101 9 0 0
v_cancel_write_off 2000 2000 0 0.00 0 864 11 0 0
v_max_id_clo_ord 5348 5348 0 0.00 0 134 1 0 0
v_max_id_clo_res 950 950 0 0.00 0 2849 12 0 0
v_max_id_ord_sup 5331 5331 0 0.00 0 3397 4 0 0
v_max_non_paid_invoice 1354 1354 0 0.00 0 645 3 0 0
v_max_non_paid_realizn 3489 3489 0 0.00 0 8719 8 0 0
v_min_id_clo_ord 5348 5348 0 0.00 0 15463 8 0 0
v_min_id_clo_res 950 950 0 0.00 0 160 1 0 0
v_min_id_ord_sup 5331 5331 0 0.00 0 7003 6 0 0
v_min_non_paid_invoice 5590 5590 0 0.00 0 14437 29 0 0
v_min_non_paid_realizn 6777 6777 0 0.00 0 9821 23 0 0
v_our_firm 10054 10054 0 0.00 0 22 1 0 0
v_reserve_write_off 19308 19308 0 0.00 0 4375 6 0 0
x_lock_depdocs_on_canc_invoice 11579 11579 0 0.00 0 21427 135 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 5579 380 0 0
x_make_qstorno_1000_1200 5350 5350 0 0.00 2 36313 1313 0 0
x_make_qstorno_1200_2000 5335 5335 0 0.00 2 69637 3581 0 0
x_make_qstorno_2100_3300 450064 450064 0 0.00 0 69800 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-04-2021 16:34:48 to 04-04-2021 16:34:52.

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
14:03:30 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:03:36 19990 8192000000 10225524432 10528096256 874993936 9.650 70 55 112 0 896034192 2372432 18667824
14:04:05 50644 8192000000 10331512848 10648485888 1381167952 14.427 100 88 176 0 1415919104 5431136 29320016
14:05:15 12919 8192000000 10356010288 10676285440 1419711840 14.770 100 91 182 0 1456593376 6637152 30244384
14:05:41 25133 8192000000 10393864560 10716143616 1443511664 14.981 100 92 184 0 1481477328 7519600 30446064
14:06:15 32648 8192000000 10411700624 10738511872 1467292896 15.190 100 91 182 1 1505304736 8344576 29667264
14:06:57 22025 8192000000 10433934208 10767687680 1488426976 15.375 100 85 170 0 1524193920 8557168 27209776
14:07:35 18847 8192000000 10462926496 10804850688 1509681088 15.561 100 83 166 1 1544345232 9114208 25549936
14:08:06 18879 8192000000 10499841440 10845831168 1549916880 15.909 100 79 158 0 1583222352 9265440 24040032
14:08:34 15215 8192000000 10523495904 10876497920 1585463264 16.215 100 74 148 0 1617348000 9457760 22426976
14:09:01 18603 8192000000 10561531088 10918023168 1618295120 16.495 100 81 162 1 1652728224 10156912 24276192
14:09:32 14072 8192000000 10584435152 10949586944 1648192032 16.749 100 76 152 1 1681326480 10994224 22140224
14:09:56 11139 8192000000 10608473200 10975404032 1673538432 16.963 100 75 148 1 1706399088 11578192 21282464
14:10:16 9062 8192000000 10629110080 10998214656 1692835968 17.125 100 78 156 1 1727621920 11741296 23044656
14:10:32 7205 8192000000 10646087440 11016204288 1706597680 17.240 100 77 154 1 1740544400 11965488 21981232
14:10:53 10860 8192000000 10664326800 11041554432 1728063936 17.419 100 79 159 1 1763369744 13352448 21953360
14:11:11 6120 8192000000 10680839680 11057205248 1745892304 17.568 100 76 150 2 1780205904 12350272 21963328
14:11:26 8059 8192000000 10692097344 11073060864 1753984832 17.635 100 69 138 0 1785142304 11648816 19508656
14:11:40 6437 8192000000 10700566544 11086462976 1770143376 17.768 100 82 164 1 1805970096 12866496 22960224
14:11:54 4987 8192000000 10702554336 11091087360 1774178592 17.801 100 69 137 0 1805831280 12251632 19401056
14:12:06 6093 8192000000 10726220544 11107106816 1781887056 17.865 100 78 157 1 1816691824 12839408 21965360
14:12:19 3705 8192000000 10733878048 11117887488 1794965968 17.973 100 87 174 0 1833592816 13705168 24921680
14:12:30 13708 8192000000 10723865616 11118374912 1798143328 17.999 100 72 144 3 1831516176 13155360 20217488
14:12:53 3998 8192000000 10748787904 11137478656 1813790064 18.127 100 78 156 0 1847454304 11778704 21885536
14:13:04 4568 8192000000 10765528960 11153911808 1822215664 18.196 100 85 170 1 1859262800 12616128 24431008
14:13:16 4303 8192000000 10770119952 11155529728 1826491632 18.231 100 82 164 0 1862891120 13110272 23289216
14:13:27 3551 8192000000 10771184336 11155505152 1830701984 18.265 100 83 162 2 1867336592 13512064 23122544
14:13:38 4240 8192000000 10774806288 11164221440 1833406864 18.287 100 81 162 0 1869977456 13584768 22985824
14:13:50 3297 8192000000 10778076320 11168796672 1838493440 18.329 100 83 165 1 1878461456 17777568 22190448
14:14:01 3864 8192000000 10790494656 11176198144 1848179312 18.407 100 90 181 1 1887387232 14128784 25079136
14:14:11 3361 8192000000 10794763888 11183247360 1849174064 18.415 100 87 173 0 1888963392 15519728 24269600
14:14:21 3463 8192000000 10795464352 11184226304 1852855216 18.445 100 85 167 1 1890786800 14404080 23527504
14:14:31 2571 8192000000 10801196576 11190034432 1859085248 18.496 100 83 166 1 1895847712 12948240 23814224
14:14:40 3079 8192000000 10808781296 11198267392 1863945728 18.535 100 83 166 1 1899205008 12550000 22709280
14:14:50 2990 8192000000 10805917872 11196841984 1867328464 18.563 100 90 178 1 1905181872 12334528 25518880
14:14:59 2336 8192000000 10811642384 11200679936 1871436192 18.596 100 88 174 0 1907176080 11620128 24119760
14:15:09 2701 8192000000 10817950352 11206139904 1873916992 18.616 100 88 176 0 1911647328 13270112 24460224
14:15:18 2440 8192000000 10821770368 11209097216 1878482544 18.653 100 94 189 1 1919524080 15015008 26026528
14:15:27 2039 8192000000 10824154480 11213045760 1877337200 18.644 100 93 186 0 1918496960 14858304 26301456
14:15:35 2742 8192000000 10816152640 11212283904 1875342240 18.627 100 80 160 1 1911799168 13751104 22705824
14:15:44 1995 8192000000 10814910208 11207352320 1879991008 18.665 100 95 191 0 1919557200 12209232 27356960
14:15:53 4146 8192000000 10812330880 11216494592 1876604080 18.638 100 73 146 1 1914615040 17295504 20715456
14:16:09 10339 8192000000 10808540624 11210129408 1873968592 18.616 100 66 132 1 1903276336 10681296 18626448
14:16:26 3101 8192000000 10825047808 11215708160 1882437504 18.685 100 93 188 1 1919765008 11192640 26134864
14:16:36 2965 8192000000 10831054800 11221872640 1880580544 18.670 100 82 163 0 1916039728 13102640 22356544
14:16:46 1505 8192000000 10835129056 11222945792 1882494800 18.685 100 97 196 1 1924728688 14830928 27402960
14:16:54 2812 8192000000 10836532272 11226300416 1888080096 18.730 100 93 186 2 1928410704 13954848 26375760
14:17:05 15591 8192000000 10825728560 11223711744 1884809872 18.704 100 75 150 1 1918531664 13211152 20510640
14:17:27 1857 8192000000 10825482864 11218513920 1884840784 18.704 100 86 172 1 1921895680 11163296 25891600
14:17:36 20427 8192000000 10815898928 11220262912 1882430864 18.685 100 64 128 3 1909710288 9477072 17802352
14:18:03 4625 8192000000 10823049664 11230445568 1882514816 18.685 100 62 125 2 1914489328 15097568 16876944
14:18:14 5786 8192000000 10812101888 11227893760 1882697344 18.687 100 64 128 4 1915203776 15147040 17359392
14:18:27 2409 8192000000 10814871984 11223904256 1883774736 18.696 100 52 104 1 1907266672 9833984 13657952
14:18:36 2789 8192000000 10810333216 11221991424 1882968832 18.689 100 49 98 1 1905841072 9067696 13804544
14:18:46 3994 8192000000 10806049072 11221241856 1884956672 18.705 100 61 123 3 1910841024 8644944 17239408
14:18:58 3127 8192000000 10800965488 11219243008 1882105568 18.682 100 44 85 1 1902548784 8245312 12197904
14:19:08 4372 8192000000 10801025872 11223486464 1885175968 18.707 100 45 90 1 1906600960 9021696 12403296
14:19:20 4104 8192000000 10804935360 11224731648 1887188192 18.723 100 45 90 1 1909992304 9203952 13600160
14:19:36 4146 8192000000 10800034192 11226562560 1892733600 18.768 100 40 80 1 1910073152 6350144 10989408
14:19:46 2920 8192000000 10822699264 11231657984 1894003072 18.778 100 57 113 3 1916693072 6055856 16634144
14:19:57 14128 8192000000 10793085488 11225890816 1889012480 18.738 100 22 45 1 1901587856 6038224 6537152
14:20:21 4125 8192000000 10801221408 11230343168 1894665808 18.783 100 36 72 1 1911786656 7005904 10114944
14:20:39 9251 8192000000 10793359216 11227365376 1891274976 18.756 100 19 38 3 1902612336 6131696 5205664
14:20:54 5430 8192000000 10809911328 11234902016 1896163536 18.795 100 32 64 1 1911597024 6445680 8987808
14:21:09 8429 8192000000 10813870720 11239239680 1898114848 18.811 100 29 58 1 1912943792 7138976 7689968
14:21:28 53307 8192000000 10812895952 11248582656 1900451824 18.830 100 45 88 1 1920099856 5766640 13881392
14:22:30 15652 8192000000 10823834640 11251322880 1903185104 18.852 100 23 47 1 1916526080 6568128 6772848
14:22:54 4853 8192000000 10821816848 11256328192 1900092096 18.827 100 34 67 1 1921410000 12146112 9171792
14:23:09 4838 8192000000 10822412096 11251982336 1902606096 18.847 100 32 64 1 1918449552 7046144 8797312
14:23:20 5617 8192000000 10811081472 11235495936 1879540224 18.661 99 33 65 3 1895287504 6536000 9211280
14:23:32 5228 8192000000 10823449472 11250442240 1902343648 18.845 100 41 82 1 1921843584 7143104 12356832
14:23:46 5050 8192000000 10820927632 11249004544 1881451840 18.677 99 22 44 2 1894032480 6315776 6264864
14:23:57 3815 8192000000 10821370688 11249504256 1899372800 18.821 100 36 72 1 1916549488 6541376 10635312
14:24:08 5619 8192000000 10819026816 11249762304 1887034688 18.722 99 31 62 0 1903078704 7437568 8606448
14:24:21 8489 8192000000 10814700544 11247206400 1894198800 18.780 100 14 28 1 1903350128 5515712 3635616
14:24:37 5590 8192000000 10808343888 11242541056 1895712112 18.792 100 28 54 1 1909821360 6480976 7628272
14:24:49 4643 8192000000 10804700064 11234099200 1860111984 18.504 98 31 59 1 1873926784 4968304 8846496
14:25:02 9419 8192000000 10792264976 11219775488 1859259984 18.497 99 21 41 2 1871022656 5516144 6246528
14:25:18 4219 8192000000 10772565408 11203129344 1850176688 18.424 99 22 44 1 1861902576 6023200 5702688
14:25:28 9164 8192000000 10758515856 11184074752 1813455504 18.124 98 22 43 0 1825931888 6025072 6451312
14:25:45 7252 8192000000 10742405504 11167506432 1817297200 18.156 98 33 67 0 1833166896 5767824 10101872
14:26:01 8865 8192000000 10704223280 11122487296 1764374256 17.721 96 28 55 1 1779517792 5758192 9385344
14:26:17 44540 8192000000 10741863840 11175690240 1809585904 18.092 98 24 46 2 1822102704 5702944 6813856
14:27:13 29251 8192000000 10734604368 11152207872 1729674176 17.433 94 26 52 4 1742751728 5812736 7264816
14:27:50 6685 8192000000 10725783968 11145056256 1795386800 17.976 99 41 82 1 1815625104 8248656 11989648
14:28:04 7058 8192000000 10684806192 11088691200 1726041616 17.403 95 34 64 4 1738870240 4896016 7932608
14:28:17 5949 8192000000 10730619744 11137441792 1787500064 17.911 99 40 79 1 1806028560 7751792 10776704
14:28:31 4632 8192000000 10735900992 11144441856 1809099616 18.089 100 47 95 0 1830698560 8169376 13429568
14:28:45 7199 8192000000 10710517696 11135324160 1782548112 17.870 98 26 52 1 1797261648 7021520 7692016
14:28:58 9063 8192000000 10715668576 11135221760 1740721056 17.525 96 14 28 2 1750559536 5578880 4259600
14:29:16 8227 8192000000 10739780400 11156475904 1804821504 18.053 99 32 64 3 1820285232 6405584 9058144
14:29:37 5652 8192000000 10727336496 11143356416 1797680736 17.995 98 35 70 0 1814154688 5388736 11085216
14:29:49 4813 8192000000 10730370224 11144536064 1759466224 17.680 96 25 50 0 1771976816 4986864 7523728
14:30:00 9861 8192000000 10738392272 11157520384 1805877040 18.062 99 32 64 1 1821090112 5465888 9747184
14:30:16 10973 8192000000 10715554000 11128107008 1756172048 17.653 97 16 32 2 1765940032 5416960 4351024
14:30:33 14804 8192000000 10736243088 11143589888 1770084160 17.768 97 24 48 1 1782952416 5346320 7521936
14:30:54 44720 8192000000 10740667136 11160272896 1828479968 18.247 100 27 53 2 1842098688 5249648 8369072
14:31:45 27112 8192000000 10761692640 11186302976 1845660080 18.387 100 26 52 0 1863160800 9875552 7625168
14:32:24 6210 8192000000 10773800352 11198201856 1854511728 18.459 100 34 68 1 1870213088 6610720 9090640
14:32:37 5733 8192000000 10788950640 11211776000 1864828320 18.542 100 35 68 1 1886728416 12343280 9556816
14:32:49 5749 8192000000 10797739104 11214184448 1869669856 18.582 100 47 92 0 1889882800 7331072 12881872
14:33:03 3873 8192000000 10795471248 11219480576 1874804304 18.623 100 43 84 2 1892860704 6136208 11920192
14:33:13 7914 8192000000 10800792192 11224420352 1882873520 18.688 100 26 50 1 1895254352 4638704 7742128
14:33:27 4008 8192000000 10825070800 11233701888 1894597072 18.783 100 43 87 2 1913447216 6830656 12019488
14:33:41 42096 8192000000 10833213696 11253522432 1904717680 18.864 100 49 98 0 1927631888 8306048 14608160
14:34:34 20834 8192000000 10845369024 11266301952 1912064368 18.923 100 41 80 2 1932016768 8815296 11137104
14:35:04 9588 8192000000 10862251552 11280834560 1925948576 19.034 100 49 96 1 1950637008 11051392 13637040
14:35:28 7816 8192000000 10877749904 11290632192 1933520000 19.095 100 57 115 3 1961562096 11649824 16392272
14:35:45 24767 8192000000 10875632592 11300343808 1936343168 19.118 100 51 102 0 1966809488 15303888 15162432
14:36:24 38101 8192000000 10866674080 11310944256 1945251424 19.189 100 35 69 3 1969088208 13756960 10079824
14:37:09 5687 8192000000 10897056848 11322515456 1955967920 19.274 100 45 90 0 1985264640 15611808 13684912
14:37:24 51999 8192000000 10897080624 11329818624 1966784864 19.360 100 58 117 4 2000937648 17392352 16760432
14:38:33 9772 8192000000 10909469152 11336642560 1966196960 19.355 100 49 97 1 1999067008 18694688 14175360
14:38:51 20314 8192000000 10904567360 11341144064 1969982128 19.385 100 44 88 0 2002973536 20863024 12128384
14:39:21 18505 8192000000 10920073872 11348553728 1969292656 19.380 100 41 80 3 2003270832 21500656 12477520
14:39:56 36205 8192000000 10912484880 11349504000 1969786944 19.384 100 32 64 2 2004367184 24481552 10098688
14:40:42 16409 8192000000 10913437136 11356696576 1972941664 19.409 100 31 59 1 2006054064 24034720 9077680
14:41:08 54824 8192000000 10900939056 11356299264 1958866496 19.297 99 31 62 1 1996477792 27756704 9854592
14:42:12 11807 8192000000 10930769616 11366092800 1983609728 19.493 100 41 82 1 2017991712 22036896 12345088
14:42:32 8099 8192000000 10955715120 11375509504 1991499216 19.556 100 66 132 1 2034791216 24494192 18797808
14:42:47 5258 8192000000 10946663536 11376795648 1992316704 19.562 100 65 130 0 2037579376 26663792 18598880
14:43:00 11141 8192000000 10951345424 11381538816 1994790352 19.582 100 73 144 0 2042469344 27099712 20579280
14:43:27 9114 8192000000 10951919248 11383455744 1997444288 19.603 100 61 121 0 2046291456 30453264 18393904
14:43:44 9558 8192000000 10967848080 11391979520 1999379600 19.618 100 61 122 2 2048841840 30723136 18739104
14:44:03 6761 8192000000 10954743888 11390808064 1999854928 19.622 100 55 110 2 2046008016 29469424 16683664
14:44:23 5441 8192000000 10965309840 11399127040 2004885120 19.661 100 57 114 0 2052402032 30767872 16749040
14:44:40 13050 8192000000 10962417760 11397500928 2007126368 19.679 100 55 110 1 2056258896 33218768 15913760
14:45:03 13561 8192000000 10968562288 11406209024 2012229328 19.719 100 60 120 2 2060074864 29737984 18107552
14:45:24 2567 8192000000 10977035216 11404308480 2009267536 19.696 100 67 133 3 2056751728 29069104 18415088
14:45:34 5274 8192000000 10982622480 11403681792 2013385136 19.728 100 76 150 2 2066445056 31278592 21781328
14:45:51 3210 8192000000 10990337168 11418574848 2018971056 19.772 100 79 158 2 2079347216 36954832 23421328
14:46:01 2806 8192000000 10996202864 11418824704 2025239024 19.821 100 80 158 0 2081976336 33266144 23471168
14:46:12 6117 8192000000 10999030816 11416899584 2019025616 19.772 100 84 163 2 2075031472 31602240 24403616
14:46:25 2266 8192000000 10996683312 11417473024 2024018976 19.812 100 92 184 2 2082865328 31838272 27008080
14:46:37 2546 8192000000 10990566592 11412090880 2003443344 19.650 99 91 182 0 2063356128 32369872 27542912
14:46:48 9700 8192000000 10987818528 11417358336 2015520224 19.745 100 78 154 0 2069367408 31188768 22658416
14:47:05 3057 8192000000 11004134032 11419295744 2020288736 19.782 100 93 185 0 2081738976 33665216 27785024
14:47:17 9516 8192000000 10986566480 11419729920 2021294496 19.790 100 67 133 0 2074299424 33333392 19671536
14:47:46 9274 8192000000 10996806800 11428212736 2029092080 19.852 100 60 120 1 2078903824 31837872 17973872
14:48:07 12537 8192000000 10998697840 11430658048 2031037248 19.867 100 59 116 0 2081334976 32808464 17489264
14:48:27 6465 8192000000 11011220032 11436806144 2032976736 19.882 100 63 125 1 2086549520 34072128 19500656
14:48:44 6226 8192000000 11007698128 11436429312 2028187120 19.844 100 67 132 0 2083102224 34583520 20331584
14:48:59 7043 8192000000 11006581440 11440267264 2036721184 19.911 100 72 144 1 2094329472 35330592 22277696
14:49:13 2422 8192000000 11014849696 11434405888 2031745440 19.872 100 83 166 0 2092692624 35866800 25080384
14:49:24 16861 8192000000 11000692496 11436621824 2031753584 19.872 100 68 135 1 2090033120 35981696 22297840
14:49:48 3679 8192000000 11017326256 11442794496 2039001744 19.929 100 64 127 1 2096929120 38008768 19918608
14:49:59 5065 8192000000 11023752624 11449647104 2035099216 19.899 100 74 144 4 2098107616 39928832 23079568
14:50:13 3866 8192000000 11009373088 11443150848 2030578320 19.863 100 61 120 3 2091754352 41497216 19678816
14:50:24 3953 8192000000 10986318496 11412078592 2006353856 19.673 99 77 154 1 2074095696 43395664 24346176
14:50:35 9654 8192000000 11002372384 11432652800 2020265808 19.782 100 61 122 1 2091349248 51488096 19595344
14:50:52 8703 8192000000 11019926656 11447455744 2030363296 19.861 100 68 135 2 2105086128 53228224 21494608
14:51:09 8541 8192000000 11023330400 11458199552 2038372112 19.924 100 67 132 0 2107154368 47698176 21084080
14:51:32 5965 8192000000 11021409376 11460157440 2024535328 19.816 99 58 116 0 2099096016 55441984 19118704
14:51:49 8403 8192000000 10995267168 11426340864 2016073040 19.749 99 66 132 1 2085825200 48266448 21485712
14:52:06 4732 8192000000 11015441440 11446104064 2034205920 19.892 100 59 118 2 2094300288 40945408 19148960
14:52:19 7741 8192000000 11015230480 11453399040 2036811520 19.912 100 63 126 2 2099699472 42352336 20535616
14:52:46 7816 8192000000 11010380320 11448356864 2032356720 19.877 100 53 104 0 2090910160 41814896 16738544
14:53:04 15008 8192000000 11014643648 11454599168 2034379408 19.893 100 52 104 1 2095312752 43594176 17339168
14:53:29 6606 8192000000 11037345632 11466055680 2044049312 19.969 100 71 141 0 2117185936 51177184 21959440
14:53:42 1970 8192000000 11036480832 11460702208 2044607664 19.973 100 83 164 3 2118824384 47190752 27025968
14:53:52 5104 8192000000 11014881920 11448094720 2026051984 19.828 99 70 140 0 2095066224 46358336 22655904
14:54:09 3842 8192000000 11035695920 11459309568 2040201920 19.939 100 78 154 0 2112054288 48410336 23442032
14:54:21 5537 8192000000 11033196784 11465461760 2042943648 19.960 100 74 148 1 2115463136 49445392 23074096
14:54:34 2831 8192000000 11018417056 11444084736 2026947648 19.835 99 78 156 0 2089155472 37292800 24915024
14:54:43 3171 8192000000 11033046480 11463479296 2049778592 20.013 100 84 168 3 2113316608 37994384 25543632
14:54:55 1353 8192000000 11029550736 11453157376 2044681472 19.974 100 88 177 0 2112972400 40685120 27605808
14:55:04 2185 8192000000 11013745792 11450433536 2036183968 19.907 100 64 129 1 2098352608 42355376 19813264
14:55:17 2866 8192000000 11001464944 11437723648 2025171392 19.821 100 62 125 3 2080253680 36287840 18794448
14:55:29 5378 8192000000 11000245232 11434577920 2021974688 19.796 100 50 100 0 2077434976 39637088 15823200
14:55:45 11345 8192000000 11006951200 11439656960 2010560368 19.706 99 54 107 1 2069505360 41037088 17907904
14:56:04 3762 8192000000 11005003872 11436630016 2011804816 19.716 99 77 151 4 2080672064 44362656 24504592
14:56:17 2662 8192000000 11001523968 11422380032 2004932112 19.662 100 79 158 2 2074925824 45173104 24820608
14:56:26 3941 8192000000 10992050128 11406315520 1994061392 19.576 100 78 155 3 2063149664 44556512 24531760
14:56:39 5980 8192000000 11000478960 11422253056 2009200000 19.695 100 80 160 2 2081311024 46361616 25749408
14:56:53 1850 8192000000 10994961888 11408773120 1996024784 19.591 99 88 177 3 2071852928 47841184 27986960
14:57:03 7948 8192000000 11010765616 11433861120 2016617488 19.754 100 81 162 1 2093925216 51389232 25918496
14:57:19 3588 8192000000 11018645328 11436605440 2017842560 19.763 100 84 168 1 2096923312 52735024 26345728
14:57:31 4881 8192000000 11019052544 11444129792 2004674816 19.660 99 81 160 0 2085447056 55568384 25203856
14:57:43 3424 8192000000 11032174176 11452747776 2026526048 19.831 100 86 170 1 2110405664 56574832 27304784
14:57:56 3197 8192000000 11053693568 11471159296 2039364368 19.932 100 87 174 2 2125506784 58758512 27383904
14:58:06 3720 8192000000 11042245904 11471319040 2038587520 19.926 100 74 148 0 2121742368 59548512 23606336
14:58:18 2794 8192000000 11030637392 11466285056 2034702784 19.895 100 69 137 1 2116105024 59516384 21885856
14:58:33 18507 8192000000 11005657408 11463790592 2027246176 19.837 100 35 68 1 2093653824 54619600 11788048
14:59:05 8958 8192000000 11026691296 11475578880 2037165776 19.915 100 42 85 2 2106766736 55779424 13821536
14:59:21 9564 8192000000 11018166720 11471077376 2019662624 19.777 99 51 102 2 2095651472 59826368 16162480
14:59:48 9393 8192000000 10999216160 11450261504 1999912464 19.622 99 40 80 0 2069196880 55556704 13727712
15:00:06 10046 8192000000 10994614032 11447685120 2009819312 19.700 100 36 72 3 2078988544 56026608 13142624
15:00:23 9762 8192000000 10994841536 11444613120 1999229776 19.617 100 43 86 1 2078189360 63522224 15437360
15:00:47 8820 8192000000 10989486864 11435360256 1998212384 19.609 100 47 94 1 2073671840 59645568 15813888
15:01:03 12673 8192000000 10978219776 11425648640 1971028320 19.394 99 33 66 1 2044517616 61748944 11740352
15:01:23 9124 8192000000 10959913824 11413950464 1949381024 19.222 98 38 76 0 2024364928 61696256 13287648
15:01:40 16348 8192000000 10971725952 11425640448 1976263712 19.435 100 34 68 3 2055642144 66897264 12481168
15:02:03 21601 8192000000 10945466272 11423678464 1954749888 19.264 99 29 58 0 2030800160 65254848 10795424
15:02:42 16065 8192000000 10936250928 11390173184 1926143552 19.036 98 30 60 1 1999502784 61607264 11751968
15:03:08 19640 8192000000 10956003136 11412537344 1963777808 19.336 100 33 67 1 2039082496 64107552 11197136
15:03:34 24221 8192000000 10921858080 11380862976 1897658480 18.807 97 29 58 1 1976727456 68615296 10453680
15:04:05 17507 8192000000 10938179264 11394674688 1956432688 19.278 100 26 52 0 2017671856 51349280 9889888
15:04:33 11764 8192000000 10944098496 11389353984 1942231520 19.165 99 35 69 2 2003610496 50506912 10872064
15:04:51 9263 8192000000 10928294368 11384872960 1967074576 19.362 100 39 78 1 2019531936 39706592 12750768
15:05:10 19183 8192000000 10902651936 11373998080 1924692256 19.024 98 9 18 1 1944898176 18024400 2181520
15:05:37 56068 8192000000 10910666544 11366715392 1942853888 19.170 99 15 30 0 1960851712 13694224 4303600
15:06:41 42947 8192000000 10919750704 11387994112 1967306272 19.364 99 32 63 0 1990754736 14005952 9442512
15:07:37 48594 8192000000 10907140096 11391873024 1960293072 19.308 99 12 24 1 1988403856 23710848 4399936
15:08:32 94557 8192000000 10899812640 11348037632 1820471696 18.182 92 18 36 0 1837389184 10971024 5946464
15:10:23 51966 8192000000 10867690016 11333754880 1918857840 18.978 98 22 44 0 1932648736 8048416 5742480
15:11:21 98109 8192000000 10877111632 11329974272 1896910672 18.801 97 30 60 0 1916814896 11296688 8607536
15:13:07 72015 8192000000 10918580464 11373170688 1949392240 19.222 100 21 42 2 1976813312 21199584 6221488
15:14:28 98515 8192000000 10895376608 11352219648 1863546896 18.532 95 21 41 0 1883037440 13409376 6081168
15:16:13 45633 8192000000 10876995168 11348942848 1924680720 19.024 98 27 53 2 1945855008 14321776 6852512
15:17:21 57338 8192000000 10891794672 11352891392 1937895696 19.130 99 21 38 2 1954909456 10818320 6195440
15:18:37 32294 8192000000 10901683216 11368108032 1967959648 19.369 100 26 52 0 1988639568 13067472 7612448
15:19:18 52320 8192000000 10911493024 11370283008 1934909328 19.106 98 22 44 0 1956705280 14676736 7119216
15:20:18 26833 8192000000 10923893648 11363889152 1954807952 19.265 99 52 105 0 1984122256 13176272 16138032
15:20:51 30744 8192000000 10906182352 11365711872 1959521184 19.302 99 63 127 5 1992144976 13588048 19035744
15:21:39 39421 8192000000 10892028208 11373109248 1958404432 19.293 100 14 28 0 1980357904 17530160 4423312
15:22:26 31348 8192000000 10884459088 11373518848 1958844448 19.297 100 7 14 0 1974111296 13192944 2073904
15:23:05 35780 8192000000 10866028208 11337113600 1903527344 18.855 97 9 18 0 1920189312 13952624 2709344
15:23:49 26668 8192000000 10877377680 11351359488 1947376736 19.206 100 14 30 1 1964322080 12911120 4034224
15:24:23 22713 8192000000 10885184928 11362455552 1955504400 19.270 100 8 16 1 1971402192 13361360 2536432
15:24:52 31721 8192000000 10828021520 11290304512 1872284096 18.603 96 18 36 2 1890493072 13103040 5105936
15:25:31 40066 8192000000 10856973728 11327324160 1917813216 18.969 99 14 28 0 1931732304 9469168 4449920
15:26:19 98489 8192000000 10866953760 11352977408 1948078208 19.211 100 21 42 0 1964212816 9969904 6164704
15:29:01 49820 8192000000 10881806528 11363840000 1962753424 19.328 100 16 32 0 1976396992 9146032 4497536
15:30:10 15938 8192000000 10884069232 11371008000 1971947104 19.401 100 23 46 0 1988313840 9883872 6482864
15:30:48 59355 8192000000 10908853056 11388903424 1979782944 19.463 100 20 40 0 1997088784 11863952 5441888
15:32:02 57417 8192000000 10896371408 11385503744 1980772736 19.471 100 8 16 0 1993716432 10960032 1983664
15:33:18 70749 8192000000 10895510416 11383668736 1926626256 19.040 97 9 17 1 1940492784 11690752 2175776
15:34:35 65879 8192000000 10910209504 11395809280 1979962672 19.464 100 11 22 0 1997397760 14700496 2734592
15:35:47 39317 8192000000 10934029840 11410968576 1993897744 19.575 100 19 37 1 2008333248 10064000 4371504
15:36:38 56381 8192000000 10928214192 11406893056 1986155712 19.513 99 24 48 1 2003785056 11147136 6482208
15:37:56 42297 8192000000 10936233760 11407618048 1969791888 19.384 98 30 60 1 1989018320 10338800 8887632
15:38:49 30931 8192000000 10946449248 11409281024 1983069744 19.489 99 24 48 1 2002741776 12812704 6859328
15:39:27 53265 8192000000 10910998960 11403333632 1971114928 19.394 99 19 38 0 1990613680 13741552 5757200
15:40:29 50689 8192000000 10949482784 11392745472 1952618768 19.247 98 28 56 1 1975907472 15140976 8147728
15:41:28 9148 8192000000 10919103600 11367497728 1934593168 19.104 97 53 103 1 1958518352 9545600 14379584
15:41:45 16615 8192000000 10906330608 11368321024 1940689888 19.152 98 50 100 1 1966289600 11860400 13739312
15:42:09 49068 8192000000 10902965408 11372212224 1940631216 19.152 98 32 64 2 1961384720 11986304 8767200
15:43:05 78603 8192000000 10894724576 11380330496 1922338448 19.006 97 26 52 0 1943159856 13179744 7641664
15:44:30 68275 8192000000 10884620032 11361046528 1923490528 19.015 98 11 22 0 1942703344 15833632 3379184
15:45:47 50380 8192000000 10921440272 11374080000 1948294704 19.213 99 32 63 1 1966144208 8984976 8864528
15:47:06 67192 8192000000 10913627520 11401646080 1924124512 19.020 97 20 40 1 1949791888 20024976 5642400
15:49:25 99806 8192000000 10877121424 11342475264 1887918672 18.729 96 23 45 2 1907849984 13212528 6718784
15:51:11 77051 8192000000 10891726528 11370315776 1956761696 19.280 100 18 36 1 1979030544 17119408 5149440
15:52:34 18774 8192000000 10911175856 11376500736 1961953520 19.322 100 12 24 0 1983618464 18005984 3658960
15:52:59 58921 8192000000 10898587120 11379650560 1962597136 19.327 100 27 53 3 1991621056 21289392 7734528
15:54:06 46722 8192000000 10883966880 11383099392 1942233344 19.165 99 6 12 1 1960557472 16389936 1934192
15:54:59 40115 8192000000 10878824688 11358089216 1935587520 19.112 99 5 10 1 1951922048 14865360 1469168
15:55:47 56860 8192000000 10873280608 11348967424 1897721760 18.808 97 11 22 0 1911899392 11090176 3087456
15:56:50 66356 8192000000 10875828000 11344990208 1912417248 18.926 98 11 22 2 1926325776 10966656 2941872
15:58:03 84701 8192000000 10872820368 11353767936 1933165552 19.092 99 12 24 0 1954534944 17497504 3871888
15:59:35 60379 8192000000 10848686944 11332493312 1875584128 18.629 96 12 24 1 1890613904 11745856 3283920
16:00:42 44306 8192000000 10833643376 11299987456 1821234112 18.188 94 4 8 0 1832615712 10476400 905200
16:01:34 46459 8192000000 10843145456 11320152064 1908214464 18.892 99 10 19 2 1925378896 13695648 3468784
16:02:33 38258 8192000000 10834280672 11289243648 1832885120 18.283 95 30 58 0 1849250224 8001344 8363760
16:03:17 61066 8192000000 10838330960 11290267648 1826773616 18.233 95 22 44 0 1840969152 8551024 5644512
16:04:25 29023 8192000000 10851563696 11308888064 1905945488 18.874 99 34 68 2 1924391568 9079120 9366960
16:05:07 41086 8192000000 10858707552 11304890368 1870828800 18.591 97 31 62 1 1888708656 9861648 8018208
16:05:59 39988 8192000000 10875095472 11324334080 1896514736 18.798 98 27 54 1 1911560224 7963200 7082288
16:06:50 39597 8192000000 10883394288 11338551296 1905611952 18.871 98 39 78 1 1927060608 11142368 10306288
16:07:37 59247 8192000000 10852633520 11322122240 1845277648 18.384 95 21 42 0 1867308176 16332800 5697728
16:08:47 44014 8192000000 10861435184 11320492032 1863569344 18.532 97 25 50 2 1888483632 18110160 6804128
16:09:37 65391 8192000000 10905468512 11345682432 1936483072 19.119 100 28 54 2 1955310576 11133408 7694096
16:10:53 28797 8192000000 10897490944 11350319104 1935869312 19.114 99 50 100 0 1965408720 15739008 13800400
16:11:33 50275 8192000000 10875877392 11331416064 1890399168 18.749 97 15 30 2 1905762480 10949984 4413328
16:12:35 124653 8192000000 10879896720 11349086208 1887722608 18.727 97 23 46 2 1906175232 12341360 6111264
16:14:46 49488 8192000000 10912084592 11374415872 1965806688 19.352 100 22 43 0 1985202256 13205888 6189680
16:15:42 47638 8192000000 10895457008 11377004544 1964637664 19.343 100 24 48 2 1992075824 20401920 7036240
16:17:31 69753 8192000000 10911337344 11371864064 1951672736 19.240 99 13 26 0 1967842288 12126240 4043312
16:18:51 39094 8192000000 10905483824 11372224512 1976409232 19.436 100 35 70 0 1997822656 12068672 9344752
16:19:36 12697 8192000000 10894667808 11370631168 1973288448 19.412 100 9 18 0 1984757136 9232624 2236064
16:20:00 20287 8192000000 10916202800 11354857472 1955380192 19.269 99 30 57 1 1969384960 6233792 7770976
16:20:31 74989 8192000000 10873802736 11353034752 1937874736 19.130 99 11 22 0 1948707056 7759472 3072848
16:21:52 52818 8192000000 10889354800 11360751616 1960739088 19.312 100 7 14 0 1969977856 7299056 1939712
16:22:51 67388 8192000000 10908241504 11381608448 1971572352 19.398 100 19 38 3 1986628128 9189744 5866032
16:24:38 59111 8192000000 10898776752 11377192960 1972725904 19.407 100 10 20 0 1984932192 9843728 2362560
16:26:17 97319 8192000000 10870681088 11350106112 1893093488 18.771 96 22 44 0 1906777552 7870944 5813120
16:28:33 63910 8192000000 10900506416 11373674496 1947000992 19.203 99 10 20 1 1961183392 11064304 3118096
16:29:43 111462 8192000000 10884387696 11374231552 1905662608 18.872 97 5 10 0 1923677888 16265152 1750128
16:31:41 45295 8192000000 10890700240 11347603456 1898679264 18.816 97 25 50 2 1914083424 8375840 7028320
16:32:41 49526 8192000000 9863181456 10224193536 989931200 10.781 51 18 35 1 1001651088 6753648 4966240

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 04-04-2021 16:34:54 to 04-04-2021 16:35:27.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 144 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-04-2021 16:35:28 to 04-04-2021 16:35:30.

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          225129
MON$OLDEST_ACTIVE               227283
MON$OLDEST_SNAPSHOT             227283
MON$NEXT_TRANSACTION            227283
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                       2024736
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.33438 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33438 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33438 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33438 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Sun Apr  4 16:33:39 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Sun Apr  4 16:33:39 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
:14: 
:15: mscs-test-161.budzdorov.ru    Sun Apr  4 16:33:39 2021
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:17: 
:18: 
:19: mscs-test-161.budzdorov.ru    Sun Apr  4 16:33:43 2021
:20:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:21: 
--- end of diff output ---

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

04.04.21 16:35:31. 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-04-04 16:35:33 No severe PSQL-related problems occured
04.04.21 16:35:35. End of report.