Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.12.2020 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 e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17207100 kB
MemAvailable 31484024 kB
Buffers 0 kB
Cached 14463848 kB
SwapCached 3696 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 2020-12-20 01:27:07
DTS_END                         2020-12-20 01:27:07.2470
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/47270
TRN_ID                          255744
ATT_ID                          716
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: 9796.19 19037 1175543
customer order: creation 187.76 310 22531
customer order: refuse 15.69 302 1883
order to supplier: creation 49.57 1147 5948
order to supplier: removal 3.67 81777 440
invoice (draft): creation 49.23 3087 5908
invoice (draft): removal 53.93 718 6472
invoice accept: apply 44.85 14982 5382
invoice accept: cancel 48.85 689 5862
customer reserve: creation 4203.38 147 504405
customer reserve: removal 4827.08 47 579249
realization accept: apply 89.50 157 10740
realization accept: cancel 83.94 86 10073
payment from customer: creation 64.08 98 7690
payment from customer: removal 6.24 62 749
payment to supplier: creation 52.28 106 6274
payment to supplier: removal 3.64 45 437
service: total inventory turnovers 4.93 1219 592
service: total monetary turnovers 6.56 30 787
service: aggregate perf. data 0.98 16255 117
service: refresh index statistics 0.03 259476 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-12-2020 01:28:28 to 20-12-2020 01:28:30.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9842
TEST_TIME 2 6486
TEST_TIME 3 6448
TEST_TIME 4 6157
TEST_TIME 5 7273
TEST_TIME 6 6708
TEST_TIME 7 6895
TEST_TIME 8 6769
TEST_TIME 9 6534
TEST_TIME 10 6505
TEST_TIME 11 6666
TEST_TIME 12 7147
TEST_TIME 13 7379
TEST_TIME 14 8073
TEST_TIME 15 9307
TEST_TIME 16 9192
TEST_TIME 17 9516
TEST_TIME 18 9284
TEST_TIME 19 9366
TEST_TIME 20 9452
TEST_TIME 21 10097
TEST_TIME 22 10450
TEST_TIME 23 11021
TEST_TIME 24 12025
TEST_TIME 25 12002
TEST_TIME 26 11862
TEST_TIME 27 11700
TEST_TIME 28 11636
TEST_TIME 29 11648
TEST_TIME 30 11507
TEST_TIME 31 11581
TEST_TIME 32 11730
TEST_TIME 33 11848
TEST_TIME 34 11608
TEST_TIME 35 11340
TEST_TIME 36 11245
TEST_TIME 37 11023
TEST_TIME 38 11061
TEST_TIME 39 10893
TEST_TIME 40 11024
TEST_TIME 41 10998
TEST_TIME 42 10844
TEST_TIME 43 10744
TEST_TIME 44 10650
TEST_TIME 45 10626
TEST_TIME 46 10595
TEST_TIME 47 10567
TEST_TIME 48 10523
TEST_TIME 49 10400
TEST_TIME 50 10336
TEST_TIME 51 10263
TEST_TIME 52 10283
TEST_TIME 53 10308
TEST_TIME 54 10309
TEST_TIME 55 10375
TEST_TIME 56 10315
TEST_TIME 57 10382
TEST_TIME 58 10445
TEST_TIME 59 10433
TEST_TIME 60 10511
TEST_TIME 61 10511
TEST_TIME 62 10548
TEST_TIME 63 10594
TEST_TIME 64 10589
TEST_TIME 65 10621
TEST_TIME 66 10475
TEST_TIME 67 10444
TEST_TIME 68 10444
TEST_TIME 69 10374
TEST_TIME 70 10272
TEST_TIME 71 10285
TEST_TIME 72 10247
TEST_TIME 73 10164
TEST_TIME 74 10133
TEST_TIME 75 10118
TEST_TIME 76 10150
TEST_TIME 77 10174
TEST_TIME 78 10205
TEST_TIME 79 10176
TEST_TIME 80 10225
TEST_TIME 81 10200
TEST_TIME 82 10217
TEST_TIME 83 10185
TEST_TIME 84 10204
TEST_TIME 85 10187
TEST_TIME 86 10268
TEST_TIME 87 10264
TEST_TIME 88 10170
TEST_TIME 89 10149
TEST_TIME 90 10145
TEST_TIME 91 10081
TEST_TIME 92 10011
TEST_TIME 93 10012
TEST_TIME 94 9985
TEST_TIME 95 9956
TEST_TIME 96 9962
TEST_TIME 97 9917
TEST_TIME 98 9958
TEST_TIME 99 9947
TEST_TIME 100 10098
TEST_TIME 101 10090
TEST_TIME 102 10104
TEST_TIME 103 10075
TEST_TIME 104 10085
TEST_TIME 105 10094
TEST_TIME 106 10101
TEST_TIME 107 10096
TEST_TIME 108 10051
TEST_TIME 109 9996
TEST_TIME 110 9969
TEST_TIME 111 9946
TEST_TIME 112 9891
TEST_TIME 113 9879
TEST_TIME 114 9878
TEST_TIME 115 9866
TEST_TIME 116 9847
TEST_TIME 117 9819
TEST_TIME 118 9807
TEST_TIME 119 9805
TEST_TIME 120 9798

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-12-2020 01:28:32 to 20-12-2020 01:28:35.

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 1641090 1641090 0 0.00 0 16222 5 0 0
doc_list_biud 1641090 1641090 0 0.00 0 40061 22 0 0
sp_add_invoice_to_stock 5484 5382 102 1.85 47 271870 14982 0 102
sp_cancel_adding_invoice 5862 5862 0 0.00 5 54160 690 0 0
sp_cancel_client_order 1883 1883 0 0.00 4 16941 302 0 0
sp_cancel_customer_reserve 579249 579249 0 0.00 1 23110 48 0 0
sp_cancel_pay_from_customer 749 749 0 0.00 2 10166 63 0 0
sp_cancel_pay_to_supplier 437 437 0 0.00 3 1507 45 0 0
sp_cancel_supplier_invoice 6476 6472 4 0.06 2 26256 719 0 4
sp_cancel_supplier_order 440 440 0 0.00 7 962021 81777 0 0
sp_cancel_write_off 10073 10073 0 0.00 1 14142 87 0 0
sp_client_order 22531 22531 0 0.00 3 19357 311 0 0
sp_customer_reserve 504405 504405 0 0.00 0 35399 147 0 0
sp_fill_shopping_cart 34383 34383 0 0.00 1 18326 37 0 0
sp_fill_shopping_cart_clo_res 504404 504404 0 0.00 0 10912 11 0 0
sp_get_clo_for_invoice 5381 5381 0 0.00 0 20246 232 0 0
sp_kill_cost_storno 17121 17121 0 0.00 0 5468 41 0 0
sp_kill_qstorno_ret_qs2qd 1175483 1175483 0 0.00 0 26249 26 0 0
sp_kill_qty_storno 620100 620100 0 0.00 0 40051 58 0 0
sp_lock_selected_doc 22249 22249 0 0.00 0 7258 5 0 0
sp_make_cost_storno 30085 30085 0 0.00 0 11145 43 0 0
sp_multiply_rows_for_pdistr 30085 30085 0 0.00 0 16154 27 0 0
sp_multiply_rows_for_qdistr 22531 22531 0 0.00 0 11250 129 0 0
sp_pay_from_customer 7690 7690 0 0.00 4 16227 99 0 0
sp_pay_to_supplier 6274 6274 0 0.00 5 12587 107 0 0
sp_payment_common 13964 13964 0 0.00 1 12357 25 0 0
sp_qd_handle_on_cancel_clo 1883 1883 0 0.00 0 16927 273 0 0
sp_qd_handle_on_invoice_upd_sts 11243 11243 0 0.00 0 40042 300 0 0
sp_qd_handle_on_reserve_upd_sts 10740 10740 0 0.00 0 19202 54 0 0
sp_reserve_write_off 10740 10740 0 0.00 6 19215 158 0 0
sp_supplier_invoice 5908 5908 0 0.00 6 94966 3088 0 0
sp_supplier_order 5948 5948 0 0.00 4 31607 1148 0 0
srv_aggregate_perf_data 117 117 0 0.00 3028 135942 16256 0 0
srv_fill_mon_cache_memory 146 146 0 0.00 1385 156540 36770 0 0
srv_find_qd_qs_mism 1123022 1123022 0 0.00 0 14136 5 0 0
srv_make_invnt_saldo 592 592 0 0.00 27 61822 1220 0 0
srv_make_money_saldo 787 787 0 0.00 1 5716 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 230465 291046 259477 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5383 5383 0 0.00 0 10041 126 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 0 6306 108 0 0
t$perf-norm:sp_cancel_client_order 1883 1883 0 0.00 0 5208 12 0 0
t$perf-norm:sp_cancel_customer_reserve 704 704 0 0.00 0 4229 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 749 749 0 0.00 0 1412 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 437 437 0 0.00 0 1998 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 409 409 0 0.00 0 2449 23 0 0
t$perf-norm:sp_cancel_supplier_order 440 440 0 0.00 0 16946 1244 0 0
t$perf-norm:sp_cancel_write_off 1093 1093 0 0.00 0 934 4 0 0
t$perf-norm:sp_client_order 22531 22531 0 0.00 0 13820 14 0 0
t$perf-norm:sp_customer_reserve 1145 1145 0 0.00 0 3831 9 0 0
t$perf-norm:sp_pay_from_customer 7690 7690 0 0.00 0 13876 10 0 0
t$perf-norm:sp_pay_to_supplier 6274 6274 0 0.00 0 21272 19 0 0
t$perf-norm:sp_reserve_write_off 10740 10740 0 0.00 0 11633 13 0 0
t$perf-norm:sp_supplier_invoice 5908 5908 0 0.00 0 5818 14 0 0
t$perf-norm:sp_supplier_order 5948 5948 0 0.00 0 13214 15 0 0
t$perf-norm:srv_aggregate_perf_data 117 117 0 0.00 0 200 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 146 146 0 0.00 0 6945 56 0 0
t$perf-norm:srv_make_invnt_saldo 592 592 0 0.00 0 856 14 0 0
t$perf-norm:srv_make_money_saldo 787 787 0 0.00 0 860 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10966 10762 204 1.86 0 9840 19 0 204
v_all_customers 40820 40820 0 0.00 0 15 1 0 0
v_all_suppliers 32674 32674 0 0.00 0 19 1 0 0
v_all_wares 45062 45062 0 0.00 0 143 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 3021 13 0 0
v_cancel_client_order 3766 3766 0 0.00 0 1847 4 0 0
v_cancel_customer_prepayment 1498 1498 0 0.00 0 2656 6 0 0
v_cancel_customer_reserve 1408 1408 0 0.00 0 2193 7 0 0
v_cancel_payment_to_supplier 874 874 0 0.00 0 1499 7 0 0
v_cancel_supplier_invoice 826 818 8 0.96 0 2104 18 0 8
v_cancel_supplier_order 880 880 0 0.00 0 1257 4 0 0
v_cancel_write_off 2186 2186 0 0.00 0 2013 12 0 0
v_max_id_clo_ord 5948 5948 0 0.00 0 214 1 0 0
v_max_id_clo_res 1145 1145 0 0.00 0 2205 20 0 0
v_max_id_ord_sup 5904 5904 0 0.00 0 3468 5 0 0
v_max_non_paid_invoice 1789 1789 0 0.00 0 1611 4 0 0
v_max_non_paid_realizn 4216 4216 0 0.00 0 1604 3 0 0
v_min_id_clo_ord 5948 5948 0 0.00 0 4327 7 0 0
v_min_id_clo_res 1145 1145 0 0.00 0 1423 5 0 0
v_min_id_ord_sup 5904 5904 0 0.00 0 4683 8 0 0
v_min_non_paid_invoice 6274 6274 0 0.00 0 12352 16 0 0
v_min_non_paid_realizn 7690 7690 0 0.00 0 5450 18 0 0
v_our_firm 11190 11190 0 0.00 0 15 1 0 0
v_reserve_write_off 21480 21480 0 0.00 0 4078 6 0 0
x_lock_depdocs_on_canc_invoice 11925 11925 0 0.00 0 30860 100 0 0
x_lock_depdocs_on_canc_sup_ord 440 440 0 0.00 0 13640 325 0 0
x_make_qstorno_1000_1200 5948 5948 0 0.00 1 31586 1075 0 0
x_make_qstorno_1200_2000 5908 5908 0 0.00 3 93723 2951 0 0
x_make_qstorno_2100_3300 504405 504405 0 0.00 0 35392 134 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-12-2020 01:28:36 to 20-12-2020 01:28:40.

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:11 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:17 8097 8192000000 10184081440 10483609600 959900528 10.488 77 67 134 0 986063008 2818272 23344208
22:57:33 22174 8192000000 10301138064 10611482624 1339748000 14.055 100 86 172 0 1373947696 4540272 29659424
22:58:16 28505 8192000000 10369361504 10691268608 1412987200 14.710 100 81 162 1 1446175344 6492864 26695280
22:58:53 16958 8192000000 10393781344 10720673792 1448939024 15.029 100 89 178 1 1485896176 7623008 29334144
22:59:22 31982 8192000000 10435705504 10770141184 1470274784 15.216 100 86 172 1 1506593888 8038224 28280880
23:00:04 20869 8192000000 10459935584 10797109248 1515354640 15.610 100 91 182 0 1553946208 9036160 29555408
23:00:40 25706 8192000000 10476340960 10818256896 1529146656 15.730 100 88 176 1 1567242912 9932016 28164240
23:01:15 10421 8192000000 10489945456 10834571264 1548848624 15.900 100 87 174 0 1586475200 10134448 27492128
23:01:39 11978 8192000000 10513527088 10865143808 1569810128 16.081 100 77 154 3 1604419344 10584112 24025104
23:02:04 7637 8192000000 10544671776 10897862656 1596783488 16.312 100 82 164 1 1633025632 10888256 25353888
23:02:21 13222 8192000000 10565598800 10921877504 1615269808 16.470 100 79 156 1 1650289952 11701440 23318704
23:02:41 7617 8192000000 10570435760 10935140352 1633731232 16.627 100 73 144 2 1667491888 11792432 21968224
23:02:58 10238 8192000000 10606582512 10971803648 1657684896 16.829 100 88 176 0 1696600176 12342992 26572288
23:03:19 8219 8192000000 10632337424 10998099968 1688293408 17.087 100 88 176 1 1726949424 12622864 26033152
23:03:38 10393 8192000000 10646519760 11020242944 1704563632 17.223 100 81 160 0 1741132032 12981040 23587360
23:03:56 9613 8192000000 10669747440 11041886208 1726605232 17.407 100 80 158 4 1762439872 13242928 22591712
23:04:15 5772 8192000000 10676991728 11053404160 1740436336 17.522 100 78 156 0 1776238352 13450112 22351904
23:04:28 5356 8192000000 10687269456 11067748352 1749930848 17.601 100 71 140 0 1782936896 12679424 20326624
23:04:40 4130 8192000000 10696843104 11073286144 1761134464 17.694 100 71 141 0 1793713008 12561120 20017424
23:04:52 5769 8192000000 10702090976 11091402752 1767316576 17.745 100 68 136 1 1799098688 12502832 19279280
23:05:05 8916 8192000000 10718573568 11100876800 1777035680 17.825 100 73 146 0 1810232928 13124768 20072480
23:05:20 4649 8192000000 10721759536 11105300480 1785613664 17.896 100 83 166 2 1822222640 13457360 23151616
23:05:32 2023 8192000000 10747455840 11132133376 1805704128 18.061 100 88 176 2 1844674016 14464160 24505728
23:05:42 2230 8192000000 10755245392 11136909312 1813430224 18.124 100 84 167 0 1850813712 13750112 23633376
23:05:51 2618 8192000000 10761607360 11147431936 1824631840 18.216 100 88 177 2 1862779936 13287168 24860928
23:06:00 2874 8192000000 10763804208 11154333696 1829353472 18.254 100 80 160 1 1865686112 13101280 23231360
23:06:09 1808 8192000000 10776360768 11164368896 1835998992 18.308 100 91 183 1 1874955488 13390160 25566336
23:06:17 2197 8192000000 10782764848 11170054144 1836941968 18.316 100 83 166 1 1873859104 12807552 24109584
23:06:26 1573 8192000000 10779477360 11166855168 1843823632 18.372 100 88 176 0 1886589392 16906624 25859136
23:06:34 1416 8192000000 10790735808 11177345024 1846264880 18.392 100 92 184 3 1885296688 13779488 25252320
23:06:42 1410 8192000000 10789449296 11178598400 1847928864 18.405 100 90 180 4 1887389680 13817200 25643616
23:06:50 1886 8192000000 10793494976 11186184192 1852720992 18.444 100 86 173 0 1891142080 13685920 24735168
23:06:59 2113 8192000000 10799651824 11192168448 1857829744 18.486 100 90 178 2 1896482240 13651728 25000768
23:07:07 1827 8192000000 10797175136 11195064320 1862990496 18.528 100 81 162 0 1899442112 13351936 23099680
23:07:16 1799 8192000000 10788648144 11195568128 1864328480 18.538 100 69 139 0 1896082720 12118368 19635872
23:07:24 3751 8192000000 10792640416 11202994176 1865131408 18.545 100 57 114 3 1891681808 10139856 16410544
23:07:35 4464 8192000000 10781694560 11198959616 1870093072 18.585 100 51 102 2 1894667776 10013680 14561024
23:07:49 7485 8192000000 10795740832 11205980160 1872979088 18.608 100 44 87 0 1892231408 7242224 12010096
23:08:03 38736 8192000000 10807530048 11211059200 1878476736 18.653 100 51 101 0 1900253808 7412064 14365008
23:08:48 33282 8192000000 10788288352 11217833984 1875377136 18.628 100 19 39 1 1886518064 5967904 5173024
23:09:32 4954 8192000000 10807325104 11228753920 1883424768 18.693 100 34 68 0 1900989216 8219008 9345440
23:09:46 7407 8192000000 10792190464 11224502272 1885375616 18.708 100 31 60 0 1899845488 6246864 8223008
23:09:59 7828 8192000000 10789392656 11227779072 1887448480 18.725 100 26 48 2 1900140992 6008896 6683616
23:10:13 6107 8192000000 10806546688 11234512896 1891991152 18.762 100 36 72 1 1913684944 12014384 9679408
23:10:29 10225 8192000000 10794960944 11234037760 1894576736 18.783 100 20 40 0 1906959648 6152176 6230736
23:10:46 7765 8192000000 10808222784 11241439232 1899366944 18.821 100 31 62 2 1914293984 6466912 8460128
23:11:02 5298 8192000000 10806281248 11241041920 1899936432 18.826 100 34 68 1 1924760352 15429152 9394768
23:11:17 9575 8192000000 10806840144 11244331008 1898435280 18.814 100 23 45 3 1915442832 9643392 7364160
23:11:35 9187 8192000000 10812469376 11244580864 1898940960 18.818 100 16 32 1 1909512336 6143744 4427632
23:11:52 7219 8192000000 10810897536 11246596096 1902875056 18.849 100 18 36 2 1914148752 6121696 5152000
23:12:09 9623 8192000000 10815234832 11251167232 1901629072 18.839 100 16 32 0 1911744512 5381040 4734400
23:12:27 9721 8192000000 10808986736 11251019776 1904706672 18.864 100 17 34 2 1915476480 5923232 4846576
23:12:42 10002 8192000000 10820549904 11255685120 1905685792 18.872 100 8 16 1 1913800000 6147232 1966976
23:13:01 73197 8192000000 10818781776 11263160320 1910750288 18.913 100 21 42 1 1922720704 5429600 6540816
23:14:24 7047 8192000000 10835258096 11270979584 1916591136 18.960 100 30 60 1 1931784272 6848160 8344976
23:14:37 5144 8192000000 10835659792 11266084864 1899643280 18.823 99 29 58 0 1913866688 6340352 7883056
23:14:48 7630 8192000000 10832709680 11273949184 1917437296 18.966 100 27 54 2 1932629472 8043232 7148944
23:15:06 6179 8192000000 10829271328 11274887168 1920930080 18.994 100 26 52 0 1934470992 6504368 7036544
23:15:21 4914 8192000000 10838715968 11276615680 1925744464 19.033 100 39 77 0 1944675616 8106112 10825040
23:15:33 6919 8192000000 10839470112 11275501568 1920710704 18.993 100 28 56 1 1934123696 5945760 7467232
23:15:50 5675 8192000000 10826477824 11262771200 1885798960 18.712 98 21 40 3 1897426720 4967552 6660208
23:16:05 4107 8192000000 10823911088 11254059008 1888314848 18.732 99 21 42 3 1899517952 5405808 5797296
23:16:16 6130 8192000000 10825221760 11257679872 1892762192 18.768 99 27 53 1 1907099312 6592896 7744224
23:16:30 10227 8192000000 10819576160 11254894592 1901163520 18.836 100 14 28 1 1911068048 6040192 3864336
23:16:48 7982 8192000000 10777095536 11213848576 1800069248 18.014 95 10 20 1 1807947136 5164016 2713872
23:17:06 14063 8192000000 10785093696 11222786048 1846829392 18.396 98 17 33 2 1858121712 6362224 4930096
23:17:28 21417 8192000000 10728970224 11149414400 1717289840 17.330 92 20 41 0 1728616000 4929616 6396544
23:17:55 61813 8192000000 10727031920 11151552512 1718888048 17.343 93 30 61 4 1733278736 5899376 8491312
23:19:06 13037 8192000000 10739014608 11175538688 1772928016 17.791 96 28 55 0 1786791120 5843472 8019632
23:19:27 5165 8192000000 10705539328 11120398336 1720960864 17.360 94 21 40 1 1733638704 6059360 6618480
23:19:40 5046 8192000000 10694383760 11108823040 1764174560 17.719 99 38 76 1 1782500992 7343424 10983008
23:19:52 6023 8192000000 10682345312 11084722176 1724291552 17.388 97 20 40 1 1735564048 5523280 5749216
23:20:06 5673 8192000000 10677582032 11090456576 1749981280 17.601 98 24 47 2 1762742816 5973456 6788080
23:20:19 6566 8192000000 10678021216 11094069248 1743080624 17.544 98 21 42 1 1754083696 5454624 5548448
23:20:33 11601 8192000000 10678908016 11087699968 1698292224 17.171 95 23 46 0 1710439280 5138256 7008800
23:20:51 8601 8192000000 10720610928 11129167872 1760368192 17.687 98 22 44 1 1771949632 5504272 6077168
23:21:07 5002 8192000000 10713823360 11127758848 1779416640 17.845 99 29 58 2 1793535952 4987840 9131472
23:21:19 6402 8192000000 10723445376 11142676480 1807643616 18.077 100 28 55 2 1820942432 4723680 8575136
23:21:32 11105 8192000000 10733779424 11154976768 1816275472 18.147 100 25 50 0 1830798224 5672304 8850448
23:21:53 9972 8192000000 10753926032 11170418688 1829621280 18.256 100 24 48 0 1842351728 5655856 7074592
23:22:09 10194 8192000000 10748437376 11174559744 1835796512 18.307 100 12 21 3 1844263456 5284944 3182000
23:22:25 23025 8192000000 10737607568 11167830016 1804197136 18.048 98 26 52 1 1817795888 5251184 8347568
23:23:31 28963 8192000000 10752842720 11181334528 1838445648 18.328 100 20 40 1 1849515920 6050096 5020176
23:24:08 10634 8192000000 10775446832 11194511360 1850485520 18.426 100 33 66 5 1865732208 5909120 9337568
23:24:27 7986 8192000000 10775841488 11196788736 1851705264 18.436 100 17 34 2 1862256144 5778720 4772160
23:24:43 8831 8192000000 10767459392 11195752448 1854392704 18.458 100 23 46 2 1866797712 5220880 7184128
23:24:58 11561 8192000000 10778441840 11205271552 1861013136 18.511 100 16 31 2 1870985648 5442416 4530096
23:25:18 11898 8192000000 10781821312 11212210176 1865406512 18.547 100 22 44 1 1877522176 5809728 6305936
23:25:36 11553 8192000000 10771651616 11208605696 1868023792 18.568 100 23 46 1 1881126944 6610608 6492544
23:25:54 8710 8192000000 10783408176 11213492224 1866419584 18.555 100 22 44 0 1878308128 5189120 6699424
23:26:12 17295 8192000000 10789518272 11215527936 1867631616 18.565 100 16 32 2 1877763824 5637616 4494592
23:26:38 14356 8192000000 10791445376 11216478208 1872748208 18.607 100 24 48 4 1885642128 5334000 7559920
23:27:01 9380 8192000000 10821019632 11230646272 1883867440 18.696 100 24 51 4 1894660976 4241856 6551680
23:27:21 17119 8192000000 10837082240 11251847168 1900220448 18.828 100 49 98 0 1920794720 6901664 13672608
23:27:47 5562 8192000000 10849215136 11261992960 1913405536 18.934 100 56 110 3 1936392080 8208720 14777824
23:27:59 64200 8192000000 10839525856 11271946240 1920913568 18.994 100 40 80 1 1941576752 8914416 11748768
23:29:28 80631 8192000000 10844934208 11283628032 1907612496 18.887 99 23 46 0 1922550480 8610192 6327792
23:30:57 13281 8192000000 10875612768 11303620608 1943753920 19.177 100 48 98 3 1967513952 9428000 14332032
23:31:20 2796 8192000000 10878018128 11297128448 1926865504 19.042 99 53 106 0 1952922496 11008496 15048496
23:31:35 58685 8192000000 10883104128 11318923264 1904070576 18.859 98 35 70 0 1925458048 12121840 9265632
23:32:41 17350 8192000000 10869290160 11311099904 1929472320 19.063 99 35 70 0 1948235616 8905776 9857520
23:33:24 12397 8192000000 10907432000 11337080832 1959363632 19.301 100 48 95 3 1986207984 13222416 13621936
23:33:44 2834 8192000000 10911439600 11322597376 1949818816 19.225 99 60 119 0 1983437760 16712624 16906320
23:33:55 7636 8192000000 10910126432 11331854336 1960236384 19.308 100 59 118 1 1994596480 17091808 17268288
23:34:10 11531 8192000000 10915457488 11338862592 1965405424 19.349 100 48 96 0 1997060496 16717904 14937168
23:34:30 5049 8192000000 10884019888 11313061888 1947880544 19.210 99 58 115 1 1982129776 16274816 17974416
23:34:46 13071 8192000000 10911069008 11342606336 1966121440 19.355 100 44 84 4 1995420256 16485600 12813216
23:35:08 8839 8192000000 10925999248 11352240128 1977666240 19.446 100 58 116 3 2014303120 18348560 18288320
23:35:24 3572 8192000000 10928623808 11351109632 1968365600 19.372 99 63 126 1 2006180912 18525616 19289696
23:35:34 14858 8192000000 10935530624 11364446208 1982134384 19.482 100 60 119 1 2018377728 19061104 17182240
23:35:59 8244 8192000000 10938163024 11370106880 1987930688 19.527 100 56 112 0 2028396768 23943904 16522176
23:36:24 10648 8192000000 10936223040 11360092160 1977013312 19.441 100 58 115 0 2017167168 23213904 16939952
23:36:47 6272 8192000000 10942091024 11364065280 1982361264 19.483 100 64 126 1 2024940672 23920032 18659376
23:37:03 5961 8192000000 10931874496 11358486528 1978418784 19.452 100 61 122 1 2020137120 23719600 17998736
23:37:20 6529 8192000000 10904471712 11326980096 1946606512 19.199 98 54 107 3 1987490672 24404432 16479728
23:37:33 5275 8192000000 10931226000 11358248960 1978379088 19.452 100 61 121 1 2027441984 31001680 18061216
23:37:46 5460 8192000000 10919292576 11345723392 1961353936 19.317 99 57 114 0 2006173584 27216848 17602800
23:37:59 3691 8192000000 10933103632 11351699456 1967892304 19.369 100 69 139 2 2018155856 28371088 21892464
23:38:12 6743 8192000000 10930336048 11349704704 1953158496 19.252 99 67 131 1 2002698528 29609648 19930384
23:38:26 3296 8192000000 10937410400 11356188672 1971998256 19.401 100 69 137 0 2023289440 30538000 20753184
23:38:37 4234 8192000000 10928501104 11350323200 1968824352 19.376 100 67 131 0 2018404816 29051408 20529056
23:38:51 8342 8192000000 10935654704 11355738112 1969135584 19.379 100 61 122 0 2017522048 29477472 18908992
23:39:12 4994 8192000000 10924896592 11337519104 1938953504 19.138 99 74 148 0 1996879760 34220048 23706208
23:39:26 4635 8192000000 10931276496 11342106624 1951027056 19.235 100 80 155 1 2014189328 38507120 24655152
23:39:38 1927 8192000000 10938574944 11350773760 1944230656 19.181 99 85 170 1 2011911408 41230576 26450176
23:39:48 11713 8192000000 10915668720 11336667136 1929516416 19.063 99 75 150 1 1993124864 40024448 23584000
23:40:08 2227 8192000000 10927067856 11347156992 1948840800 19.217 100 68 135 2 2012270144 41633168 21796176
23:40:18 9119 8192000000 10928298336 11350614016 1954238800 19.260 100 74 148 0 2021329856 43189616 23901440
23:40:35 1798 8192000000 10943828352 11353206784 1952883104 19.249 100 80 158 2 2022223536 43980160 25360272
23:40:44 1786 8192000000 10937138512 11344076800 1943992864 19.179 99 84 168 0 2014988816 45456992 25538960
23:40:53 1860 8192000000 10951056160 11366600704 1963319872 19.332 100 83 163 1 2036808816 46937760 26551184
23:41:04 2634 8192000000 10950297184 11364188160 1947269568 19.205 99 81 162 0 2019951104 47136592 25544944
23:41:15 3329 8192000000 10953230944 11370340352 1960282480 19.308 100 71 141 6 2034134432 50638944 23213008
23:41:28 1690 8192000000 10928750240 11345162240 1936772240 19.121 99 74 146 0 2013158928 52006000 24380688
23:41:37 3222 8192000000 10962752848 11374428160 1960495440 19.310 100 81 162 1 2040329648 53290320 26543888
23:41:48 2747 8192000000 10943114528 11363553280 1955891488 19.273 100 70 141 1 2029110816 50227248 22992080
23:41:59 4468 8192000000 10939760496 11353780224 1920137760 18.988 98 68 134 2 1990916368 48775360 22003248
23:42:11 2626 8192000000 10914140768 11324694528 1900305648 18.829 97 71 143 1 1968477648 45760032 22411968
23:42:36 12657 8192000000 10885376000 11320389632 1923937168 19.018 100 43 86 4 1977177584 39212016 14028400
23:43:01 9652 8192000000 10892361168 11310485504 1895750656 18.792 98 65 129 4 1955123664 39249168 20123840
23:43:19 5399 8192000000 10908248544 11322322944 1926765248 19.041 100 57 112 2 1986121952 41710304 17646400
23:43:33 7062 8192000000 10914567824 11333210112 1924685168 19.024 99 65 132 1 1989714192 43270848 21758176
23:43:50 5804 8192000000 10931493184 11345956864 1945806064 19.193 100 70 136 0 2010290224 43413376 21070784
23:44:06 1383 8192000000 10944415136 11352596480 1950061776 19.227 100 86 172 0 2024964912 48749616 26153520
23:44:15 8272 8192000000 10935882480 11356176384 1949302288 19.221 100 58 116 0 2016567008 49409664 17855056
23:44:30 8400 8192000000 10897217200 11332292608 1905653440 18.872 98 32 64 2 1957149168 41132512 10363216
23:44:45 13965 8192000000 10895300704 11333574656 1917532608 18.967 99 31 62 3 1969073056 41288064 10252384
23:45:07 14501 8192000000 10883570880 11316711424 1877760800 18.647 97 35 70 0 1931341552 42339504 11241248
23:45:29 16106 8192000000 10903088976 11335053312 1918573552 18.975 99 35 68 0 1973665344 44152944 10938848
23:45:52 16654 8192000000 10918871440 11348844544 1938317792 19.133 100 35 70 1 1995667296 45727184 11622320
23:46:15 15095 8192000000 10911753888 11347808256 1935515248 19.111 100 40 78 1 1999001392 50410928 13075216
23:46:38 23874 8192000000 10903848224 11336724480 1920154544 18.988 99 31 62 2 1977905744 47302608 10448592
23:47:18 10738 8192000000 10921503904 11357401088 1938124112 19.132 100 30 60 2 2005053120 56156352 10772656
23:47:36 11455 8192000000 10919771664 11357200384 1935325840 19.109 100 36 72 0 2008427664 60197936 12903888
23:48:07 15807 8192000000 10915685808 11362320384 1937287280 19.125 100 27 54 1 2006882704 59750672 9844752
23:48:29 36351 8192000000 10901298080 11346305024 1898871344 18.817 98 27 54 0 1968801216 60910288 9019584
23:49:26 30766 8192000000 10889470752 11336278016 1918334672 18.973 100 27 54 2 1976688608 48499216 9854720
23:50:05 18262 8192000000 10890976432 11339857920 1914553360 18.943 100 24 48 2 1973217632 49991280 8672992
23:50:29 31738 8192000000 10878309056 11325652992 1901190224 18.836 99 19 38 0 1951623376 43813488 6619664
23:51:12 32448 8192000000 10854083296 11338588160 1922402272 19.006 100 11 22 0 1949109568 22933040 3774256
23:51:50 78796 8192000000 10869236496 11315806208 1914928672 18.946 99 20 36 3 1929138032 9076048 5133312
23:53:15 48725 8192000000 10847767968 11298250752 1870258032 18.586 97 13 27 1 1882053296 8748656 3046608
23:54:16 80459 8192000000 10875446272 11319980032 1895646384 18.791 98 26 53 2 1912336320 9131488 7558448
23:55:43 76513 8192000000 10874903856 11341627392 1921126896 18.996 99 12 24 2 1934355552 10062528 3166128
23:57:14 126766 8192000000 10901507712 11373588480 1952832704 19.249 99 6 12 0 1973304576 19039376 1432496
23:59:27 156538 8192000000 10916891840 11368910848 1924597472 19.024 97 13 26 0 1950077376 21929872 3550032
00:02:12 90451 8192000000 10924444608 11376652288 1987229712 19.522 100 37 70 0 2005955616 7988832 10737072
00:03:52 56903 8192000000 10931284912 11387842560 1986709632 19.518 100 22 44 1 2006459632 13554592 6195408
00:04:59 53385 8192000000 10921269712 11383820288 1974583968 19.422 99 22 43 2 2002410000 21367504 6458528
00:05:59 25084 8192000000 10920166064 11386191872 1991328800 19.554 100 23 46 0 2006791344 8673392 6789152
00:06:32 43024 8192000000 10919135008 11391246336 1994757616 19.581 100 32 64 0 2015990160 11447936 9784608
00:07:36 42603 8192000000 10918825168 11392225280 1993060592 19.568 100 18 36 1 2006737552 8773552 4903408
00:08:25 45557 8192000000 10907286608 11379396608 1932625360 19.088 97 9 18 0 1951427536 16535600 2266576
00:09:17 42092 8192000000 10908157120 11385016320 1987499680 19.524 100 22 44 2 2000858272 6316640 7041952
00:10:32 46450 8192000000 10898934240 11378032640 1979815680 19.463 100 9 18 0 1992828976 10411296 2602000
00:11:25 37687 8192000000 10913795424 11383726080 1983815696 19.495 100 13 26 0 1999170944 11553440 3801808
00:12:11 29040 8192000000 10909301248 11374837760 1958864624 19.297 99 13 25 0 1974118064 11486512 3766928
00:12:56 36813 8192000000 10902581632 11378712576 1975525744 19.429 100 12 24 0 1987023936 7955408 3542784
00:13:58 52730 8192000000 10892622384 11373735936 1969219680 19.379 99 18 36 1 1985633488 11546720 4867088
00:15:01 39529 8192000000 10890584288 11366293504 1950123968 19.227 98 20 40 2 1968675600 13101632 5450000
00:15:53 53673 8192000000 10893897312 11357495296 1940575344 19.151 98 21 42 0 1952918512 6472400 5870768
00:18:49 24653 8192000000 10876453120 11360796672 1942353040 19.166 98 20 40 1 1955255648 7470912 5431696
00:19:23 47636 8192000000 10873350288 11353890816 1865856496 18.551 94 21 42 2 1881331392 9544256 5930640
00:20:18 29374 8192000000 10899332848 11372453888 1966480448 19.358 100 18 36 1 1980973648 9251200 5242000
00:20:54 50300 8192000000 10891676912 11369549824 1903143984 18.852 96 14 28 0 1918328560 11229584 3954992
00:21:51 46753 8192000000 10851799376 11308265472 1820542528 18.182 93 12 24 2 1833528256 9758944 3226784
00:22:48 32369 8192000000 10835823744 11301621760 1856196976 18.472 96 16 31 1 1868636976 7580816 4859184
00:23:27 25189 8192000000 10888001376 11337109504 1937794368 19.129 100 33 66 0 1954548928 7883328 8871232
00:24:00 62236 8192000000 10851999008 11330428928 1872011312 18.601 96 22 44 0 1891387440 13135424 6240704
00:25:08 37046 8192000000 10798497104 11257606144 1768958400 17.758 92 14 29 0 1784572176 10927536 4686240
00:25:52 44198 8192000000 10844494736 11296923648 1848737312 18.412 97 29 58 0 1870222288 13316880 8168096
00:26:55 48343 8192000000 10855414064 11310731264 1885192928 18.707 98 23 46 1 1902631216 11149744 6288544
00:28:05 75374 8192000000 10856232816 11305218048 1799097680 18.007 93 11 22 0 1809284592 7674112 2512800
00:29:27 31601 8192000000 10846843200 11302625280 1888004912 18.730 98 18 36 1 1902896944 10260848 4631184
00:30:05 56919 8192000000 10871272480 11328819200 1882807744 18.688 97 25 50 0 1903292784 13958832 6526208
00:31:10 33071 8192000000 10872527344 11331678208 1899142464 18.819 98 16 32 1 1915561680 12052000 4367216
00:31:55 78783 8192000000 10867276896 11338203136 1864504336 18.540 96 25 50 3 1892235584 20650624 7080624
00:33:49 72682 8192000000 10885224768 11341004800 1905377584 18.870 98 32 64 1 1921457872 8019360 8060928
00:35:18 20700 8192000000 10892034688 11350253568 1953564976 19.255 100 36 72 1 1979021040 15572272 9883792
00:35:45 44883 8192000000 10877767040 11349843968 1953937264 19.258 100 14 26 2 1968666528 11056256 3673008
00:36:44 56812 8192000000 10881128560 11357474816 1960978992 19.314 100 9 18 0 1974702144 10988960 2734192
00:37:53 69714 8192000000 10877570544 11361554432 1940745712 19.153 99 10 20 0 1958253248 14467840 3039696
00:39:09 45993 8192000000 10880373632 11343339520 1937716640 19.129 99 11 22 0 1952973680 11823920 3433120
00:40:06 53062 8192000000 10890705152 11360198656 1959196336 19.300 100 14 28 1 1969337024 6352656 3788032
00:41:09 82484 8192000000 10876093888 11345432576 1867776128 18.566 95 9 18 0 1878682288 8336544 2569616
00:42:44 86012 8192000000 10897285232 11371839488 1958550736 19.295 100 14 28 0 1978374192 15807584 4015872
00:44:16 74629 8192000000 10888008944 11345747968 1907686480 18.888 97 20 37 1 1924231456 11254352 5290624
00:45:37 28472 8192000000 10900142640 11365548032 1965111632 19.347 100 40 80 1 1984778768 7890640 11776496
00:46:13 78983 8192000000 10898376640 11377451008 1951122816 19.235 99 32 64 2 1971746592 11908736 8715040
00:47:43 47765 8192000000 10914347072 11371479040 1937439152 19.126 98 31 62 1 1954259744 8352480 8468112
00:48:40 63714 8192000000 10905289136 11379363840 1950138528 19.228 99 21 42 2 1966037584 10233040 5666016
00:49:51 49245 8192000000 10911627232 11373871104 1980636624 19.470 100 24 48 0 1995874016 8499744 6737648
00:50:48 18431 8192000000 10946386656 11396743168 1995611248 19.588 100 50 100 0 2018650480 9223376 13815856
00:51:14 33664 8192000000 10926236720 11389206528 1984954816 19.504 100 44 88 3 2009498336 12334400 12209120
00:51:55 44708 8192000000 10938260816 11400335360 1969459984 19.381 99 35 70 1 1989027488 10259056 9308448
00:52:48 46793 8192000000 10925010896 11400679424 1973196272 19.411 99 36 72 3 2002170464 18704672 10269520
00:53:43 120473 8192000000 10905100272 11389931520 1926269392 19.037 97 8 16 0 1941591312 12942208 2379712
00:56:00 100106 8192000000 10900132864 11396952064 1946711088 19.200 98 17 34 2 1968131264 16626144 4794032
00:58:23 64494 8192000000 10895360032 11374108672 1977956736 19.449 100 11 22 0 1987909120 7269072 2683312
01:00:05 62008 8192000000 10874896080 11363340288 1904493648 18.862 96 6 12 0 1912529792 7083376 952768
01:01:13 70304 8192000000 10842821104 11315064832 1737814400 17.500 88 13 26 0 1751304528 10167840 3322288
01:02:31 55318 8192000000 10886895664 11349401600 1886596256 18.718 97 19 38 2 1906413504 13952960 5864288
01:03:39 34933 8192000000 10892615040 11349037056 1932683392 19.088 99 21 42 1 1951449440 13090096 5675952
01:04:30 42681 8192000000 10867476128 11329662976 1863813984 18.534 96 30 60 1 1887241408 14489904 8937520
01:05:49 75448 8192000000 10871774784 11339161600 1905062496 18.867 98 13 26 0 1930344480 20989344 4292640
01:08:01 134294 8192000000 10862646080 11321585664 1808096704 18.080 93 23 47 1 1823189280 8555024 6537552
01:10:28 54244 8192000000 10876981408 11334901760 1917540528 18.967 99 23 46 1 1934653920 10631776 6481616
01:11:51 41311 8192000000 10881351920 11349233664 1946556560 19.199 100 24 48 1 1966914976 13798064 6560352
01:13:12 52673 8192000000 10888513648 11337531392 1909119424 18.900 98 33 65 3 1927336000 8950560 9266016
01:14:18 52734 8192000000 10842685456 11317784576 1847153968 18.399 95 27 54 0 1866427168 11347184 7926016
01:15:22 140669 8192000000 10866294896 11337760768 1873312864 18.611 97 26 52 0 1888865104 8167968 7384272
01:17:49 48662 8192000000 10856973968 11339141120 1924351152 19.022 99 18 36 1 1949049968 19843440 4855376
01:19:25 66683 8192000000 10877629392 11345641472 1944907424 19.186 100 12 24 0 1960004576 11777600 3319552
01:21:28 54509 8192000000 10837247056 11303903232 1820644240 18.183 94 17 35 0 1836903840 10979312 5280288
01:22:33 85119 8192000000 10843107376 11321638912 1895201920 18.788 99 19 38 1 1914288544 13546000 5540624
01:24:10 66078 8192000000 10871947296 11323867136 1856244576 18.473 96 17 33 1 1874387088 13106208 5036304
01:25:22 83128 8192000000 10857857040 11340328960 1897263024 18.804 98 18 35 2 1919355376 17345600 4746752
01:26:52 26136 8192000000 9239899376 9510244352 395786544 4.608 21 4 8 0 406164496 9382352 995600

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 20-12-2020 01:28:42 to 20-12-2020 01:29:11.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 102 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-12-2020 01:29:12 to 20-12-2020 01:29:14.

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          256128
MON$OLDEST_ACTIVE               256129
MON$OLDEST_SNAPSHOT             256129
MON$NEXT_TRANSACTION            256129
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                       2048544
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
--- end of diff output ---

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

20.12.20 01:29:15. 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
2020-12-20 01:29:18 No severe PSQL-related problems occured
20.12.20 01:29:19. End of report.