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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17241352 kB
MemAvailable 31305292 kB
Buffers 0 kB
Cached 14421572 kB
SwapCached 4864 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-01-16 19:27:10
DTS_END                         2021-01-16 19:27:10.5760
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/53648
TRN_ID                          236355
ATT_ID                          609
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: 9297.50 22489 1115700
customer order: creation 167.52 398 20102
customer order: refuse 15.46 361 1855
order to supplier: creation 45.88 1281 5506
order to supplier: removal 3.42 107204 410
invoice (draft): creation 44.55 3247 5346
invoice (draft): removal 54.64 755 6557
invoice accept: apply 40.67 17132 4880
invoice accept: cancel 49.67 819 5960
customer reserve: creation 3779.62 167 453554
customer reserve: removal 4799.23 61 575908
realization accept: apply 82.23 175 9867
realization accept: cancel 87.82 104 10538
payment from customer: creation 57.06 119 6847
payment from customer: removal 5.78 97 694
payment to supplier: creation 48.73 130 5847
payment to supplier: removal 3.33 96 400
service: total inventory turnovers 4.85 1093 582
service: total monetary turnovers 6.18 23 742
service: aggregate perf. data 0.84 18774 101
service: refresh index statistics 0.03 297748 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-01-2021 19:28:08 to 16-01-2021 19:28:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4531
TEST_TIME 2 4481
TEST_TIME 3 4386
TEST_TIME 4 3910
TEST_TIME 5 3759
TEST_TIME 6 3615
TEST_TIME 7 3630
TEST_TIME 8 4075
TEST_TIME 9 4474
TEST_TIME 10 4686
TEST_TIME 11 4982
TEST_TIME 12 5503
TEST_TIME 13 5848
TEST_TIME 14 6701
TEST_TIME 15 7569
TEST_TIME 16 7440
TEST_TIME 17 7354
TEST_TIME 18 7744
TEST_TIME 19 8681
TEST_TIME 20 9065
TEST_TIME 21 9071
TEST_TIME 22 8979
TEST_TIME 23 9220
TEST_TIME 24 9733
TEST_TIME 25 9672
TEST_TIME 26 10464
TEST_TIME 27 10919
TEST_TIME 28 11061
TEST_TIME 29 10926
TEST_TIME 30 10836
TEST_TIME 31 10697
TEST_TIME 32 10647
TEST_TIME 33 10371
TEST_TIME 34 10572
TEST_TIME 35 10434
TEST_TIME 36 10336
TEST_TIME 37 10231
TEST_TIME 38 10094
TEST_TIME 39 10157
TEST_TIME 40 10216
TEST_TIME 41 10166
TEST_TIME 42 10158
TEST_TIME 43 10086
TEST_TIME 44 10156
TEST_TIME 45 10104
TEST_TIME 46 10058
TEST_TIME 47 9958
TEST_TIME 48 9873
TEST_TIME 49 9832
TEST_TIME 50 9831
TEST_TIME 51 9867
TEST_TIME 52 9846
TEST_TIME 53 9852
TEST_TIME 54 9919
TEST_TIME 55 10013
TEST_TIME 56 9982
TEST_TIME 57 9917
TEST_TIME 58 9912
TEST_TIME 59 9953
TEST_TIME 60 10063
TEST_TIME 61 10064
TEST_TIME 62 10005
TEST_TIME 63 9898
TEST_TIME 64 9780
TEST_TIME 65 9742
TEST_TIME 66 9767
TEST_TIME 67 9657
TEST_TIME 68 9622
TEST_TIME 69 9560
TEST_TIME 70 9664
TEST_TIME 71 9618
TEST_TIME 72 9637
TEST_TIME 73 9580
TEST_TIME 74 9596
TEST_TIME 75 9671
TEST_TIME 76 9680
TEST_TIME 77 9697
TEST_TIME 78 9680
TEST_TIME 79 9676
TEST_TIME 80 9833
TEST_TIME 81 9777
TEST_TIME 82 9788
TEST_TIME 83 9677
TEST_TIME 84 9618
TEST_TIME 85 9604
TEST_TIME 86 9545
TEST_TIME 87 9510
TEST_TIME 88 9460
TEST_TIME 89 9430
TEST_TIME 90 9373
TEST_TIME 91 9349
TEST_TIME 92 9408
TEST_TIME 93 9418
TEST_TIME 94 9507
TEST_TIME 95 9528
TEST_TIME 96 9538
TEST_TIME 97 9472
TEST_TIME 98 9526
TEST_TIME 99 9580
TEST_TIME 100 9584
TEST_TIME 101 9557
TEST_TIME 102 9549
TEST_TIME 103 9594
TEST_TIME 104 9549
TEST_TIME 105 9495
TEST_TIME 106 9431
TEST_TIME 107 9420
TEST_TIME 108 9403
TEST_TIME 109 9351
TEST_TIME 110 9341
TEST_TIME 111 9300
TEST_TIME 112 9308
TEST_TIME 113 9290
TEST_TIME 114 9365
TEST_TIME 115 9329
TEST_TIME 116 9333
TEST_TIME 117 9306
TEST_TIME 118 9347
TEST_TIME 119 9368
TEST_TIME 120 9299

Performance per minute, chart


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

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 1535350 1535350 0 0.00 0 17448 6 0 0
doc_list_biud 1535349 1535349 0 0.00 0 52967 29 0 0
sp_add_invoice_to_stock 4990 4880 110 2.20 38 205654 17133 0 110
sp_cancel_adding_invoice 5960 5960 0 0.00 4 51554 819 0 0
sp_cancel_client_order 1855 1855 0 0.00 4 25829 362 0 0
sp_cancel_customer_reserve 575908 575908 0 0.00 1 52969 61 0 0
sp_cancel_pay_from_customer 694 694 0 0.00 2 9653 97 0 0
sp_cancel_pay_to_supplier 400 400 0 0.00 3 6829 97 0 0
sp_cancel_supplier_invoice 6564 6557 7 0.10 2 19058 756 0 7
sp_cancel_supplier_order 410 410 0 0.00 7 1065829 107205 0 0
sp_cancel_write_off 10538 10538 0 0.00 1 13835 104 0 0
sp_client_order 20102 20102 0 0.00 3 15640 399 0 0
sp_customer_reserve 453554 453554 0 0.00 0 55394 167 0 0
sp_fill_shopping_cart 30930 30930 0 0.00 1 35268 34 0 0
sp_fill_shopping_cart_clo_res 453552 453552 0 0.00 0 14299 16 0 0
sp_get_clo_for_invoice 4878 4878 0 0.00 0 26871 395 0 0
sp_kill_cost_storno 17592 17592 0 0.00 0 7583 56 0 0
sp_kill_qstorno_ret_qs2qd 1169321 1169321 0 0.00 0 52962 33 0 0
sp_kill_qty_storno 615972 615972 0 0.00 0 52967 71 0 0
sp_lock_selected_doc 20592 20592 0 0.00 0 10854 7 0 0
sp_make_cost_storno 27439 27439 0 0.00 0 17408 53 0 0
sp_multiply_rows_for_pdistr 27438 27438 0 0.00 0 8418 30 0 0
sp_multiply_rows_for_qdistr 20102 20102 0 0.00 0 15635 212 0 0
sp_pay_from_customer 6847 6847 0 0.00 4 17511 119 0 0
sp_pay_to_supplier 5847 5847 0 0.00 5 16952 131 0 0
sp_payment_common 12694 12694 0 0.00 1 16957 33 0 0
sp_qd_handle_on_cancel_clo 1855 1855 0 0.00 0 25820 333 0 0
sp_qd_handle_on_invoice_upd_sts 10838 10838 0 0.00 0 38662 337 0 0
sp_qd_handle_on_reserve_upd_sts 9866 9866 0 0.00 0 12840 56 0 0
sp_reserve_write_off 9867 9867 0 0.00 6 19137 175 0 0
sp_supplier_invoice 5346 5346 0 0.00 6 105073 3247 0 0
sp_supplier_order 5506 5506 0 0.00 5 35456 1281 0 0
srv_aggregate_perf_data 101 101 0 0.00 2698 182776 18775 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1481 139764 33052 0 0
srv_find_qd_qs_mism 1068778 1068778 0 0.00 0 14359 5 0 0
srv_make_invnt_saldo 582 582 0 0.00 33 78381 1094 0 0
srv_make_money_saldo 742 742 0 0.00 1 1831 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 183437 375608 297748 0 0
t$perf-abend:sp_add_invoice_to_stock 110 110 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4880 4880 0 0.00 0 12265 162 0 0
t$perf-norm:sp_cancel_adding_invoice 444 444 0 0.00 0 12557 121 0 0
t$perf-norm:sp_cancel_client_order 1855 1855 0 0.00 0 3578 17 0 0
t$perf-norm:sp_cancel_customer_reserve 648 648 0 0.00 0 1144 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 694 694 0 0.00 0 378 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 400 400 0 0.00 0 3663 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 398 398 0 0.00 0 1409 15 0 0
t$perf-norm:sp_cancel_supplier_order 410 410 0 0.00 0 26776 1830 0 0
t$perf-norm:sp_cancel_write_off 999 999 0 0.00 0 4824 14 0 0
t$perf-norm:sp_client_order 20102 20102 0 0.00 0 8656 18 0 0
t$perf-norm:sp_customer_reserve 981 981 0 0.00 0 1459 7 0 0
t$perf-norm:sp_pay_from_customer 6847 6847 0 0.00 0 7148 10 0 0
t$perf-norm:sp_pay_to_supplier 5847 5847 0 0.00 0 5741 9 0 0
t$perf-norm:sp_reserve_write_off 9867 9867 0 0.00 0 4821 11 0 0
t$perf-norm:sp_supplier_invoice 5346 5346 0 0.00 0 12302 22 0 0
t$perf-norm:sp_supplier_order 5506 5506 0 0.00 0 8567 18 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 260 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 917 8 0 0
t$perf-norm:srv_make_invnt_saldo 582 582 0 0.00 0 812 22 0 0
t$perf-norm:srv_make_money_saldo 742 742 0 0.00 0 1180 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 16 5 0 0
v_add_invoice_to_stock 9976 9756 220 2.20 0 4858 18 0 220
v_all_customers 35972 35972 0 0.00 0 211 1 0 0
v_all_suppliers 30218 30218 0 0.00 0 31 1 0 0
v_all_wares 40202 40202 0 0.00 0 82 1 0 0
v_cancel_adding_invoice 888 888 0 0.00 0 828 7 0 0
v_cancel_client_order 3710 3710 0 0.00 0 5046 7 0 0
v_cancel_customer_prepayment 1388 1388 0 0.00 0 6457 14 0 0
v_cancel_customer_reserve 1296 1296 0 0.00 0 3112 7 0 0
v_cancel_payment_to_supplier 800 800 0 0.00 0 1095 5 0 0
v_cancel_supplier_invoice 810 796 14 1.72 0 3095 20 0 14
v_cancel_supplier_order 820 820 0 0.00 0 3050 12 0 0
v_cancel_write_off 1998 1998 0 0.00 0 5999 17 0 0
v_max_id_clo_ord 5498 5498 0 0.00 0 259 1 0 0
v_max_id_clo_res 981 981 0 0.00 0 3177 23 0 0
v_max_id_ord_sup 5330 5330 0 0.00 0 4152 4 0 0
v_max_non_paid_invoice 1566 1566 0 0.00 0 1392 6 0 0
v_max_non_paid_realizn 3873 3873 0 0.00 0 4039 6 0 0
v_min_id_clo_ord 5498 5498 0 0.00 0 2336 6 0 0
v_min_id_clo_res 981 981 0 0.00 0 4949 11 0 0
v_min_id_ord_sup 5330 5330 0 0.00 0 4381 3 0 0
v_min_non_paid_invoice 5847 5847 0 0.00 0 7299 20 0 0
v_min_non_paid_realizn 6847 6847 0 0.00 0 6979 18 0 0
v_our_firm 10178 10178 0 0.00 0 18 1 0 0
v_reserve_write_off 19732 19732 0 0.00 0 5104 7 0 0
x_lock_depdocs_on_canc_invoice 12119 12119 0 0.00 0 11808 104 0 0
x_lock_depdocs_on_canc_sup_ord 410 410 0 0.00 0 9781 328 0 0
x_make_qstorno_1000_1200 5506 5506 0 0.00 1 28832 1192 0 0
x_make_qstorno_1200_2000 5346 5346 0 0.00 3 105046 3142 0 0
x_make_qstorno_2100_3300 453554 453554 0 0.00 0 55392 149 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-01-2021 19:28:16 to 16-01-2021 19:28:20.

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
16:57:14 3 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:20 9360 8192000000 10176925264 10469765120 878726720 9.687 70 54 114 0 899185984 2321600 18137664
16:57:44 21486 8192000000 10317646960 10632888320 1368773104 14.316 100 89 178 0 1403409104 4328704 30307296
16:58:16 14515 8192000000 10356330448 10676035584 1412487024 14.706 100 85 170 0 1444794144 5399968 26907152
16:58:41 25237 8192000000 10387426816 10710437888 1434804400 14.904 100 77 154 0 1465916128 6215024 24896704
16:59:16 28006 8192000000 10415105824 10742034432 1464250320 15.163 100 88 176 0 1499762896 7201488 28311088
16:59:54 14824 8192000000 10433263232 10763075584 1487698112 15.369 100 88 176 1 1524251760 8100784 28452864
17:00:22 21705 8192000000 10444541744 10780651520 1503988320 15.511 100 88 177 1 1540383424 8419872 27975232
17:00:57 10192 8192000000 10456201776 10797498368 1520055392 15.651 100 81 162 0 1554211648 8405024 25751232
17:01:21 14225 8192000000 10498368480 10839269376 1555111728 15.954 100 91 182 1 1592954400 9514688 28327984
17:01:43 12862 8192000000 10508969728 10855002112 1564481200 16.035 100 84 166 2 1599534000 9581664 25471136
17:02:05 14008 8192000000 10526795024 10880917504 1586173856 16.221 100 74 148 2 1618463664 9986848 22302960
17:02:30 12359 8192000000 10570867792 10930765824 1621825984 16.525 100 74 147 0 1653217616 10054112 21337520
17:02:52 10144 8192000000 10590876896 10952986624 1649459536 16.760 100 78 156 1 1683729136 11135840 23133760
17:03:09 10318 8192000000 10603632832 10967072768 1663578208 16.879 100 80 157 1 1698467136 11653424 23235504
17:03:28 13107 8192000000 10628254672 10994393088 1682378064 17.037 100 83 166 1 1719465952 12609776 24478112
17:03:49 5302 8192000000 10622350064 10992566272 1690332880 17.104 100 73 146 2 1724150464 12827488 20990096
17:04:02 10280 8192000000 10641895120 11013783552 1703715904 17.216 100 83 166 0 1739924048 12193264 24014880
17:04:20 8727 8192000000 10657524016 11031478272 1719175568 17.345 100 85 170 0 1755896800 12588736 24132496
17:04:35 5681 8192000000 10664354032 11040485376 1729629072 17.432 100 82 163 1 1765860640 13045552 23186016
17:04:49 6886 8192000000 10682440880 11060781056 1747540800 17.581 100 78 156 0 1782802880 12859792 22402288
17:05:03 4950 8192000000 10698533888 11072307200 1755018192 17.643 100 85 166 1 1791368192 13420576 22929424
17:05:16 6240 8192000000 10706621008 11082809344 1759796208 17.683 100 81 162 0 1795919424 13541136 22582080
17:05:28 4915 8192000000 10707538752 11082739712 1772443056 17.787 100 86 171 3 1809875776 13868896 23563824
17:05:40 5472 8192000000 10716707120 11098730496 1777426448 17.828 100 77 154 0 1812313200 13439392 21447360
17:05:53 4061 8192000000 10730479664 11113443328 1791502768 17.944 100 88 174 2 1828591568 12252704 24836096
17:06:06 3981 8192000000 10743809328 11125157888 1801165024 18.023 100 93 186 0 1841046656 13973056 25908576
17:06:17 3107 8192000000 10749641920 11134152704 1806728528 18.069 100 79 158 0 1842531296 13424368 22378400
17:06:27 3668 8192000000 10765210112 11147993088 1818744576 18.167 100 84 168 1 1854706960 12552800 23409584
17:06:37 3234 8192000000 10760115776 11151007744 1827045168 18.235 100 81 162 2 1862104416 12534816 22524432
17:06:47 3836 8192000000 10768443328 11153047552 1828253504 18.245 100 88 175 0 1865110768 12182112 24675152
17:06:57 10645 8192000000 10761897312 11156602880 1830940704 18.267 100 79 158 0 1866354992 13308048 22106240
17:07:15 2666 8192000000 10787307360 11175084032 1835164528 18.301 100 76 150 2 1869278912 13667824 20446560
17:07:24 1740 8192000000 10792572256 11181801472 1855980480 18.471 100 89 177 1 1895282768 14760048 24542240
17:07:32 2276 8192000000 10798782512 11189612544 1860332368 18.506 100 93 186 2 1900706176 14244368 26129440
17:07:41 2257 8192000000 10802738496 11193032704 1859112016 18.496 100 86 171 0 1896596288 13293008 24191264
17:07:49 2354 8192000000 10810867040 11198291968 1866430560 18.555 100 95 191 1 1905836608 12622336 26783712
17:07:58 2146 8192000000 10813687872 11203162112 1867127808 18.561 100 93 184 0 1906112320 12747552 26236960
17:08:07 2296 8192000000 10805661120 11196071936 1868003408 18.568 100 87 174 3 1908503616 16437632 24062576
17:08:15 2164 8192000000 10819711440 11210133504 1874098384 18.617 100 91 181 2 1913169936 13395152 25676400
17:08:24 2126 8192000000 10824179488 11215089664 1878001824 18.649 100 91 183 0 1917244752 12869168 26373760
17:08:32 2222 8192000000 10825134864 11215187968 1876438848 18.636 100 93 184 1 1917459744 15226336 25794560
17:08:41 17179 8192000000 10825556272 11214209024 1875174848 18.626 100 81 162 0 1911360592 12979504 23206240
17:09:04 2479 8192000000 10793632384 11206279168 1874484528 18.621 100 62 124 0 1903221632 11586496 17150608
17:09:14 4640 8192000000 10792767952 11206574080 1872332256 18.603 100 57 114 2 1898765456 10444480 15988720
17:09:26 5111 8192000000 10792351328 11208757248 1871479888 18.596 100 50 100 0 1894873792 8609280 14784624
17:09:38 4728 8192000000 10795191904 11211067392 1872665440 18.606 100 33 64 1 1888920096 7414832 8839824
17:09:50 6388 8192000000 10788043040 11206483968 1872201824 18.602 100 26 52 0 1887335536 7576448 7557264
17:10:02 9017 8192000000 10795945632 11213697024 1877229296 18.643 100 27 54 0 1892243200 7024192 7989712
17:10:21 8791 8192000000 10789568320 11215290368 1878734704 18.655 100 24 48 2 1892510080 6910928 6864448
17:10:41 11087 8192000000 10807136512 11221983232 1887737536 18.728 100 41 83 1 1905587200 6061520 11788144
17:11:02 64500 8192000000 10807525840 11235840000 1891469776 18.758 100 33 66 2 1906619760 5806288 9343696
17:12:13 2651 8192000000 10813732240 11240423424 1896001376 18.794 100 42 84 1 1915932432 7641216 12289840
17:12:22 5817 8192000000 10808769808 11241189376 1894838528 18.785 100 28 56 1 1910177568 7462384 7876656
17:12:34 4984 8192000000 10812358208 11242528768 1896175472 18.796 100 27 54 0 1911155984 6696992 8283520
17:12:45 5539 8192000000 10814265040 11248533504 1900610064 18.831 100 30 59 2 1915770704 6600928 8559712
17:12:58 8220 8192000000 10817506096 11249463296 1902708384 18.848 100 21 42 0 1914640624 5870016 6062224
17:13:13 8849 8192000000 10812266272 11249070080 1904486064 18.862 100 19 38 1 1915771712 5878816 5406832
17:13:32 5833 8192000000 10822402768 11252834304 1903209424 18.852 100 23 46 2 1915700384 6158880 6332080
17:13:45 7558 8192000000 10820390160 11254636544 1903435552 18.854 100 17 34 1 1914009248 5747632 4826064
17:14:06 12765 8192000000 10814301680 11252297728 1902940768 18.850 100 13 26 0 1912027824 5016096 4070960
17:14:27 10530 8192000000 10818259392 11252699136 1905448208 18.870 100 26 52 0 1918813632 5432672 7932752
17:14:46 3899 8192000000 10815666080 11254210560 1907587856 18.887 100 21 42 1 1920675456 5917392 7170208
17:14:58 11009 8192000000 10800591056 11240181760 1880920912 18.673 99 15 30 1 1891079200 6151920 4006368
17:15:17 20574 8192000000 10816839136 11240734720 1866239616 18.554 98 34 68 0 1882320976 6082288 9999072
17:15:49 44409 8192000000 10863434496 11263508480 1906170736 18.876 100 70 143 3 1932792464 6015328 20606400
17:16:39 8720 8192000000 10810179040 11250991104 1901138176 18.835 100 23 46 0 1915496960 7328640 7030144
17:16:55 7198 8192000000 10801329056 11238531072 1879988896 18.665 99 19 36 1 1890637360 5384800 5263664
17:17:13 5764 8192000000 10807061248 11238129664 1877747776 18.647 99 25 50 1 1890972448 6175344 7049328
17:17:26 3330 8192000000 10818044224 11244470272 1898001552 18.810 100 41 82 1 1916954912 7369568 11583792
17:17:36 6141 8192000000 10806701408 11243462656 1897639056 18.807 100 27 54 2 1912887552 7785040 7463456
17:17:48 6083 8192000000 10757224400 11181727744 1810637872 18.101 96 26 52 3 1824184544 6350144 7196528
17:18:02 7141 8192000000 10782859440 11213406208 1870606704 18.589 100 35 71 2 1887750080 7306800 9836576
17:18:17 6834 8192000000 10737467776 11158175744 1798059600 17.998 97 22 44 1 1810022128 6010752 5951776
17:18:33 6309 8192000000 10751866192 11175706624 1835472368 18.304 100 22 44 0 1847201248 5471760 6257120
17:18:46 7281 8192000000 10738045376 11161477120 1802319776 18.033 98 21 39 3 1813427088 5636656 5470656
17:19:00 10813 8192000000 10741444160 11167776768 1817427040 18.157 99 19 38 2 1828448432 5733744 5287648
17:19:17 6899 8192000000 10715883664 11136446464 1750329088 17.604 96 18 36 0 1761934480 6120576 5484816
17:19:30 10637 8192000000 10709353824 11123343360 1721913504 17.368 95 26 51 1 1742897968 13535584 7448880
17:19:47 9004 8192000000 10698578288 11119493120 1763120080 17.710 98 19 38 1 1778238160 9440032 5678048
17:20:02 10766 8192000000 10724042016 11122012160 1792476688 17.952 100 22 44 1 1804598544 5538832 6583024
17:20:22 50011 8192000000 10753472768 11136163840 1753318176 17.629 96 68 139 0 1779051152 4978400 20754576
17:21:18 9943 8192000000 10724401504 11146903552 1795253488 17.975 99 21 42 2 1811547280 10805840 5487952
17:21:35 5541 8192000000 10698901024 11112648704 1742231536 17.537 97 37 74 1 1759100736 5644272 11224928
17:21:48 4180 8192000000 10698095744 11109625856 1755966736 17.651 98 24 48 0 1768732752 5946224 6819792
17:21:58 5347 8192000000 10702858496 11109720064 1766345936 17.737 99 29 58 0 1781827840 7154768 8327136
17:22:10 7097 8192000000 10698042528 11109122048 1746621424 17.574 98 21 43 0 1758346960 5829568 5895968
17:22:23 9475 8192000000 10705956544 11130302464 1780536816 17.854 99 25 50 2 1793183504 5653920 6992768
17:22:41 8653 8192000000 10727777888 11142320128 1799163344 18.007 99 30 58 1 1814334576 5456128 9715104
17:23:00 5293 8192000000 10734643376 11154288640 1819726400 18.175 100 25 50 2 1832792432 6093696 6972336
17:23:12 9604 8192000000 10745796288 11169353728 1833635072 18.289 100 25 50 0 1847814112 6207072 7971968
17:23:29 9689 8192000000 10750106464 11182989312 1840861920 18.348 100 21 41 4 1856579216 9247600 6469696
17:23:51 13683 8192000000 10760632528 11191848960 1831890512 18.275 99 14 28 0 1849105888 13851280 3364096
17:24:11 12711 8192000000 10782875376 11202932736 1858106464 18.488 100 33 66 1 1878195504 9669152 10419888
17:24:34 54858 8192000000 10764705904 11199016960 1844329424 18.376 99 37 75 1 1861763936 6529696 10904816
17:25:41 7753 8192000000 10785301680 11209576448 1867491424 18.564 100 26 52 3 1886172448 10212256 8468768
17:25:56 7858 8192000000 10777499152 11206021120 1869196656 18.578 100 41 81 2 1888100816 6693472 12210688
17:26:10 6923 8192000000 10783586528 11212431360 1866612480 18.557 100 23 46 0 1883785344 10939136 6233728
17:26:27 7749 8192000000 10775914400 11210170368 1868771040 18.574 100 23 47 1 1882219328 5940352 7507936
17:26:42 7412 8192000000 10782533904 11212804096 1872330400 18.603 100 19 38 0 1883342576 5266064 5746112
17:26:59 6236 8192000000 10796950640 11225776128 1879183168 18.659 100 21 42 0 1894170528 9112032 5875328
17:27:12 36081 8192000000 10819639440 11247194112 1899106592 18.819 100 38 76 0 1919811648 9123792 11581264
17:28:00 27369 8192000000 10834247136 11257708544 1914270160 18.941 100 36 72 1 1931468384 7073344 10124880
17:28:43 2415 8192000000 10852400768 11276472320 1928128256 19.052 100 53 107 1 1954938064 10724080 16085728
17:29:04 37095 8192000000 10868728416 11296968704 1931081712 19.076 100 41 81 2 1953115088 10512480 11520896
17:29:49 32116 8192000000 10888714896 11312889856 1945503296 19.191 100 49 97 0 1978109296 19173536 13432464
17:30:32 38903 8192000000 10892941664 11327639552 1956503040 19.278 100 46 91 1 1986194560 17704208 11987312
17:31:18 48041 8192000000 10899573328 11336208384 1964341088 19.341 100 37 74 1 1992233568 17593552 10298928
17:32:14 44607 8192000000 10906602544 11346755584 1972024432 19.402 100 36 72 1 2005603056 23631600 9947024
17:33:09 47928 8192000000 10913474256 11355115520 1976065168 19.434 100 29 58 2 2005316752 20794544 8457040
17:34:12 11811 8192000000 10928380224 11362385920 1984943504 19.504 100 41 82 3 2020042304 22332640 12766160
17:34:33 5980 8192000000 10930009936 11370934272 1989303104 19.538 100 41 80 2 2030047872 27945120 12799648
17:34:45 17930 8192000000 10935589744 11375964160 1992048432 19.560 100 35 70 0 2027634064 24295552 11290080
17:35:11 12043 8192000000 10941404544 11378544640 1995338240 19.586 100 35 68 1 2031328128 24899456 11090432
17:35:37 8237 8192000000 10950585728 11385663488 2002879712 19.645 100 56 112 2 2045929600 25780192 17269696
17:36:00 3506 8192000000 10970147632 11399827456 2005571920 19.667 100 56 106 4 2047174432 25397568 16204944
17:36:14 2770 8192000000 10977124720 11396640768 2009438208 19.697 100 59 116 2 2053584704 26486032 17660464
17:36:24 8006 8192000000 10971591616 11399421952 1995128752 19.584 99 69 136 2 2047537184 32054752 20353680
17:36:40 4804 8192000000 10967247040 11390246912 2006022496 19.670 100 74 147 4 2058462864 29350016 23090352
17:36:56 10091 8192000000 10961649152 11397005312 2005052928 19.663 100 54 108 1 2050497904 28941472 16503504
17:37:13 10637 8192000000 10983671968 11414433792 2016458016 19.752 100 57 114 2 2064774096 30930160 17385920
17:37:31 5832 8192000000 10989446160 11413901312 2022738384 19.802 100 76 152 0 2077401392 31917120 22745888
17:37:44 3390 8192000000 10991622624 11411947520 2017953856 19.764 100 67 134 0 2074459600 35403456 21102288
17:37:56 4690 8192000000 10987440960 11416649728 2020340000 19.783 100 75 148 1 2079365968 35970672 23055296
17:38:08 4651 8192000000 10984525824 11409846272 2000187072 19.624 99 67 132 0 2056857728 36187744 20482912
17:38:20 6415 8192000000 10989563616 11414761472 2017643712 19.762 100 78 157 1 2079987536 38213280 24130544
17:38:32 5859 8192000000 10974764624 11402977280 2005373840 19.665 100 68 136 0 2065616080 38564832 21677408
17:38:46 3665 8192000000 10980964128 11401453568 2001410560 19.634 100 73 146 0 2064235552 39932912 22892080
17:38:59 13915 8192000000 10966383504 11391737856 1986509440 19.516 99 64 127 0 2046058576 38679904 20869232
17:39:22 9613 8192000000 10976679856 11404906496 1998937280 19.614 100 58 116 3 2057988544 40613296 18437968
17:39:39 6721 8192000000 10974619120 11404922880 2000335072 19.625 100 67 133 0 2061993456 40834736 20823648
17:39:53 9989 8192000000 10971815920 11400491008 2000461968 19.626 100 60 116 1 2061339632 42300448 18577216
17:40:12 5818 8192000000 10973816416 11406413824 1987108672 19.521 99 69 136 3 2053078944 43641392 22328880
17:40:25 8131 8192000000 10955162800 11385823232 1978872048 19.456 99 61 121 2 2045140800 45615552 20653200
17:40:41 8268 8192000000 10984554176 11411685376 2002589952 19.643 100 66 131 0 2069055200 45657152 20808096
17:40:56 2545 8192000000 10972300976 11390083072 1989791920 19.542 100 79 157 0 2060195440 46778272 23625248
17:41:07 6508 8192000000 10964077008 11391950848 1972277216 19.404 99 65 130 1 2044292784 51120048 20895520
17:41:21 3187 8192000000 10977293888 11391377408 1981016784 19.473 99 86 173 1 2053651232 45591360 27043088
17:41:30 1831 8192000000 10978253328 11392995328 1973573664 19.414 99 91 183 1 2047856880 45756496 28526720
17:41:40 1990 8192000000 10983934384 11399069696 1989492512 19.540 100 84 167 2 2062973664 47412848 26068304
17:41:49 3349 8192000000 10963044400 11378638848 1970933520 19.393 99 88 175 1 2042847056 44775984 27137552
17:41:59 1665 8192000000 10979463520 11392905216 1989981696 19.544 100 82 160 1 2056806000 41894576 24929728
17:42:08 6877 8192000000 10990879824 11410276352 2002846992 19.645 100 81 163 1 2067336048 40407856 24081200
17:42:24 2303 8192000000 10987577008 11404992512 1990333296 19.546 99 87 174 2 2058306192 42132032 25840864
17:42:38 2036 8192000000 10998192656 11411431424 2002677456 19.644 100 95 187 0 2076777552 45589024 28511072
17:42:47 7479 8192000000 10951574592 11390394368 1989071152 19.536 100 46 92 2 2039786496 36717152 13998192
17:43:02 5067 8192000000 10953963888 11387711488 1987887008 19.527 100 52 105 1 2039795840 35522896 16385936
17:43:16 2769 8192000000 10970193936 11385585664 1961677952 19.319 98 73 144 2 2020126432 36271200 22177280
17:43:27 2082 8192000000 10973775696 11386015744 1982706464 19.486 100 84 165 1 2046336848 38482848 25147536
17:43:36 3127 8192000000 10965180832 11383140352 1982568752 19.485 100 88 173 3 2048354960 39073472 26712736
17:43:50 6524 8192000000 10955858176 11385970688 1972784832 19.408 99 65 130 0 2034412704 40704768 20923104
17:44:04 1480 8192000000 10967491680 11385618432 1980853216 19.471 100 75 149 0 2048358800 43446384 24059200
17:44:13 6525 8192000000 10973845360 11390074880 1979839696 19.463 100 77 154 3 2051387648 45809216 25738736
17:44:27 6583 8192000000 10971480672 11398582272 1991470688 19.555 100 73 144 1 2065464288 50443008 23550592
17:44:43 3769 8192000000 10987334048 11407437824 1994864288 19.582 100 81 162 1 2075647264 54429376 26353600
17:44:54 6594 8192000000 10970013584 11392450560 1971967248 19.401 99 74 148 0 2053332960 56262144 25103568
17:45:08 5727 8192000000 10976217472 11406331904 1984713008 19.502 100 64 128 0 2068183632 62705296 20765328
17:45:22 2039 8192000000 10982335776 11397750784 1978147776 19.450 99 95 187 2 2064380080 55423568 30808736
17:45:31 1686 8192000000 10993475760 11416010752 1988782144 19.534 100 80 160 1 2072861264 58198112 25881008
17:45:40 10138 8192000000 10992556384 11417890816 1993221520 19.569 100 65 130 3 2076385984 61760384 21404080
17:46:01 4001 8192000000 10985109920 11411722240 1984977040 19.504 100 75 148 0 2067311264 57946416 24387808
17:46:12 6509 8192000000 10967170560 11395985408 1975280432 19.427 100 46 92 0 2047660464 56729056 15650976
17:46:25 8122 8192000000 10957856448 11402375168 1976017616 19.433 100 53 106 0 2050339264 56950704 17370944
17:46:40 5046 8192000000 10922104112 11352731648 1911209200 18.916 98 48 94 0 1978292192 50245664 16837328
17:46:54 7624 8192000000 10907980608 11348860928 1926947888 19.042 99 45 90 2 1986436656 44336880 15151888
17:47:21 13631 8192000000 10918531568 11358056448 1953786384 19.257 100 35 68 3 2002189520 36936928 11466208
17:47:41 11938 8192000000 10912533920 11354693632 1913053984 18.931 98 31 62 0 1961958048 38944128 9959936
17:48:31 16402 8192000000 10921957488 11369857024 1962353120 19.325 100 27 54 0 2006485648 35079600 9052928
17:48:53 18031 8192000000 10929146240 11382792192 1970188608 19.387 100 25 50 0 2014533744 35976496 8368640
17:49:18 21075 8192000000 10888990656 11329241088 1862093152 18.520 95 31 62 2 1911948064 39381648 10473264
17:49:50 11423 8192000000 10907725440 11344388096 1936047296 19.115 100 33 65 1 1988434320 41210992 11176032
17:50:08 11524 8192000000 10902820128 11351343104 1935471568 19.111 100 31 60 2 1987618192 41590912 10555712
17:50:40 20839 8192000000 10889516000 11335458816 1926343488 19.038 100 26 51 2 1972668288 37402272 8922528
17:51:33 25592 8192000000 10883844496 11335806976 1913939072 18.938 99 19 38 0 1953246720 33091824 6215824
17:52:05 20280 8192000000 10906526576 11354525696 1940669808 19.152 100 25 50 0 1982854896 34362992 7822096
17:52:31 31461 8192000000 10900824432 11358724096 1939949024 19.146 100 22 44 2 1987259264 39575136 7735104
17:53:20 25834 8192000000 10880518432 11361292288 1929128320 19.060 100 11 22 0 1973440000 39941120 4370560
17:54:04 33803 8192000000 10874152544 11343781888 1928155920 19.052 99 15 30 0 1949027008 16732192 4138896
17:54:51 69717 8192000000 10863839520 11329146880 1886222096 18.715 97 12 24 0 1902628512 13041280 3365136
17:56:08 19237 8192000000 10854719840 11302047744 1908808432 18.897 99 34 68 2 1926562112 7832896 9920784
17:56:34 52873 8192000000 10883073888 11332427776 1920932944 18.994 99 20 40 1 1937257088 11209040 5115104
17:57:39 58364 8192000000 10888872624 11331940352 1916605600 18.960 98 31 62 1 1931949584 6926944 8417040
17:58:43 122786 8192000000 10893478336 11336024064 1897847632 18.809 97 34 68 0 1919658560 11967040 9843888
18:01:08 85502 8192000000 10872021216 11327389696 1895332544 18.789 97 20 39 0 1913270304 12503888 5433872
18:02:40 37612 8192000000 10878993616 11338334208 1940957248 19.154 100 15 30 2 1959452976 13796928 4698800
18:03:56 15870 8192000000 10898187808 11350884352 1949776000 19.225 99 27 54 3 1971102752 13162912 8163840
18:04:22 17055 8192000000 10906654048 11360907264 1967337616 19.364 100 26 52 0 1989427664 14244640 7845408
18:04:58 38819 8192000000 10918550416 11360583680 1951455856 19.238 99 32 63 2 1977567504 16192448 9919200
18:06:29 20682 8192000000 10900141600 11356692480 1947184288 19.204 99 36 72 0 1976659536 18826672 10648576
18:07:00 46864 8192000000 10899400832 11373723648 1965405456 19.349 100 16 32 0 1986290544 16032224 4852864
18:08:45 55180 8192000000 10903079328 11372298240 1951115664 19.235 99 14 28 0 1971367776 15773872 4478240
18:10:19 59408 8192000000 10913149808 11378266112 1969286032 19.380 100 26 53 2 1995016784 18409680 7321072
18:11:25 50359 8192000000 10905720896 11380715520 1972781200 19.408 100 12 24 0 1990489888 14214960 3493728
18:12:32 39924 8192000000 10903513728 11371724800 1981760176 19.479 100 29 56 1 2000238608 10341968 8136464
18:13:32 58338 8192000000 10906983408 11388481536 1988826112 19.535 100 21 42 2 2005913408 10672432 6414864
18:15:24 27054 8192000000 10909611312 11393015808 1983321728 19.491 100 17 34 1 2006460864 18280288 4858848
18:16:05 23605 8192000000 10908480144 11374858240 1980911024 19.472 100 6 12 0 1994965696 12263088 1791584
18:16:35 34092 8192000000 10923075264 11390287872 1993234928 19.569 100 20 40 1 2005499664 7173696 5091040
18:17:17 38731 8192000000 10917861024 11399434240 1994059440 19.576 100 12 24 0 2009429536 11886112 3483984
18:18:02 73335 8192000000 10936185568 11401388032 2000639712 19.628 100 19 38 0 2021580784 15459232 5481840
18:19:37 31718 8192000000 10913783344 11388829696 1987199264 19.522 100 17 34 2 2004252992 12418032 4635696
18:20:15 94899 8192000000 10909262944 11374563328 1897875280 18.809 95 14 28 0 1914860928 12816704 4168944
18:22:03 76104 8192000000 10894484304 11358429184 1901610704 18.839 96 12 24 1 1915536784 10874512 3051568
18:23:31 34781 8192000000 10902869024 11356094464 1929455920 19.063 98 31 62 1 1948983712 10833104 8694688
18:24:12 11517 8192000000 10910222768 11358679040 1970026464 19.386 100 55 108 1 1996038352 9753760 16258128
18:24:31 14723 8192000000 10915668704 11369095168 1973011312 19.409 100 37 74 1 1993923648 10572560 10339776
18:24:55 13634 8192000000 10905142944 11352707072 1932168960 19.084 98 39 78 0 1953017872 10262176 10586736
18:25:16 13320 8192000000 10911729648 11364196352 1967496496 19.366 100 44 88 0 1990180976 10930912 11753568
18:25:36 21445 8192000000 10908902560 11359899648 1955513104 19.270 99 46 92 0 1981181680 13033840 12634736
18:26:09 100357 8192000000 10864669296 11332136960 1867925328 18.567 95 17 34 1 1884407232 12366144 4115760
18:28:01 127783 8192000000 10884712032 11342315520 1885936448 18.713 96 16 32 0 1902182496 11932080 4313968
18:30:25 69082 8192000000 10872482400 11324395520 1909346176 18.901 97 42 84 2 1928677584 6442368 12889040
18:31:40 52639 8192000000 10865402928 11333627904 1931297648 19.077 99 22 44 0 1945705616 8706480 5701488
18:32:48 62905 8192000000 10866105856 11352993792 1937443840 19.126 99 7 14 0 1948984960 9617792 1923328
18:33:57 26404 8192000000 10877135088 11362418688 1953875264 19.257 100 13 25 0 1970550400 13187760 3487376
18:34:34 16908 8192000000 10866782624 11353731072 1954530672 19.263 100 4 8 0 1964491872 8935696 1025504
18:34:58 41298 8192000000 10854417808 11331788800 1860455552 18.507 95 28 57 1 1874652816 6927392 7269872
18:35:45 46870 8192000000 10855026016 11322646528 1887585056 18.726 97 23 45 1 1902653408 8916352 6152000
18:36:39 71698 8192000000 10831026912 11300483072 1799119232 18.007 93 22 44 1 1818967984 12983152 6865600
18:37:56 46815 8192000000 10837703536 11298172928 1900468528 18.830 99 13 26 1 1911692080 7763888 3459664
18:38:52 55873 8192000000 10844548368 11297513472 1889519808 18.742 99 28 56 0 1908946928 11384400 8042720
18:39:58 61964 8192000000 10858794000 11320975360 1874437664 18.620 97 16 32 0 1891787728 12667872 4682192
18:41:35 97570 8192000000 10844765504 11300376576 1857282048 18.481 96 18 36 3 1881224352 18226608 5715696
18:43:19 42725 8192000000 10856033952 11313553408 1845037536 18.382 96 22 44 0 1863492032 12458496 5996000
18:44:10 19631 8192000000 10850167872 11297144832 1880742528 18.671 98 42 82 0 1904810752 12626704 11441520
18:44:38 22682 8192000000 10856842688 11310157824 1919229520 18.981 100 35 68 1 1940730112 12120640 9379952
18:45:07 31057 8192000000 10847401072 11302076416 1868383392 18.571 97 27 54 2 1887183856 11456256 7344208
18:45:45 35191 8192000000 10874952592 11328643072 1912988784 18.931 99 30 60 1 1932027088 10196768 8841536
18:46:30 45534 8192000000 10856582736 11332841472 1875496944 18.629 97 15 30 3 1895466976 15202784 4767248
18:47:37 45042 8192000000 10878109952 11328364544 1909266416 18.901 99 24 49 0 1927843248 12348704 6228128
18:48:28 41905 8192000000 10851328848 11312701440 1877837280 18.648 97 47 89 1 1902392192 12138624 12416288
18:49:16 139763 8192000000 10844289552 11311013888 1896716976 18.800 98 20 40 1 1913942544 11880576 5344992
18:51:56 62201 8192000000 10819658736 11295141888 1889685408 18.743 98 8 16 1 1900109808 7829776 2594624
18:53:10 108185 8192000000 10834289360 11311419392 1883431696 18.693 98 10 20 0 1895953808 9737712 2784400
18:55:04 8892 8192000000 10842616832 11316944896 1923924928 19.018 100 18 36 1 1941811040 12800560 5085552
18:55:37 29128 8192000000 10844834400 11326664704 1924169312 19.020 100 8 16 0 1943097968 16666064 2262592
18:56:15 40315 8192000000 10848622624 11329499136 1909172304 18.900 99 6 12 1 1926952336 16065088 1714944
18:57:51 33302 8192000000 10902210592 11362304000 1963697392 19.335 100 26 50 2 1987805760 16403760 7704608
18:58:31 51593 8192000000 10924006128 11387781120 1970649552 19.391 100 23 47 0 1993525552 15757968 7118032
18:59:40 85789 8192000000 10896414688 11381055488 1962793600 19.328 99 18 36 0 1982082096 13818240 5470256
19:01:18 50962 8192000000 10903975216 11368615936 1938866992 19.138 98 13 26 2 1951243872 8527136 3849744
19:02:20 102993 8192000000 10907448896 11386675200 1968943104 19.377 99 19 38 1 1988787584 13730176 6114304
19:04:09 60521 8192000000 10940394384 11405283328 1990778688 19.550 100 33 67 2 2013930608 14114480 9037440
19:06:12 74183 8192000000 10901148336 11386273792 1945808160 19.193 98 15 30 0 1975347664 25321840 4217664
19:07:39 54450 8192000000 10905026112 11360673792 1937906048 19.130 98 32 64 1 1956560624 9226720 9427856
19:08:40 68857 8192000000 10918926240 11373727744 1958006512 19.290 99 31 61 0 1977130880 10823984 8300384
19:10:00 24534 8192000000 10935809392 11386413056 1989800592 19.542 100 50 98 1 2015807952 12317280 13690080
19:10:34 71293 8192000000 10896546736 11356262400 1845127648 18.383 93 23 46 0 1866225456 14752800 6345008
19:11:52 128182 8192000000 10873955760 11345039360 1939702800 19.144 99 20 40 0 1957471920 12065616 5703504
19:14:06 53562 8192000000 10878322480 11356082176 1950766816 19.233 99 29 58 2 1968706816 9917280 8022720
19:15:18 60375 8192000000 10885659232 11369906176 1967124976 19.363 100 14 28 1 1983198624 11683248 4390400
19:16:24 33862 8192000000 10883361936 11368144896 1951152064 19.236 99 8 15 0 1963311904 10242416 1917424
19:18:05 71820 8192000000 10902706800 11382661120 1959608784 19.303 99 16 32 0 1975306224 10981968 4715472
19:19:31 77495 8192000000 10873644864 11348639744 1863364832 18.531 94 12 24 0 1876557072 9902256 3289984
19:20:56 55160 8192000000 10868612656 11360235520 1924651520 19.024 98 18 36 2 1943230400 12905936 5672944
19:21:57 64393 8192000000 10891067168 11354472448 1923223152 19.013 98 16 31 1 1935938352 8543232 4171968
19:23:08 63167 8192000000 10878561296 11358375936 1928616192 19.056 98 21 42 2 1946424208 11557072 6250944
19:24:30 53087 8192000000 10889087856 11356188672 1906071680 18.875 97 38 76 0 1932082880 14972912 11038288
19:25:32 63865 8192000000 10888936368 11364392960 1935764912 19.113 99 22 45 1 1955724944 13984384 5975648
19:26:47 39332 8192000000 9250535488 9511837696 403550512 4.694 21 1 2 0 409562080 5949440 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 16-01-2021 19:28:22 to 16-01-2021 19:28:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 110 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-01-2021 19:28:54 to 16-01-2021 19:28:56.

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          237800
MON$OLDEST_ACTIVE               237801
MON$OLDEST_SNAPSHOT             237801
MON$NEXT_TRANSACTION            237801
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                       2020800
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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'

16.01.21 19:28:57. 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-01-16 19:28:59 No severe PSQL-related problems occured
16.01.21 19:29:01. End of report.